GEMCLUSTER DB connection error

[Laurentiu D.]

Traceback (most recent call last):
  File "/usr/bin/openquake", line 163, in <module>
    args.config_file, user_name=getpass.getuser())
  File "/usr/lib/pymodules/python2.7/openquake/engine.py", line 830, in import_job_profile
    job_profile = _prepare_job(params, sections, user_name)
  File "/usr/lib/pymodules/python2.7/django/db/transaction.py", line 217, in inner
    res = func(*args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openquake/engine.py", line 585, in _prepare_job
    input_set.save()
  File "/usr/lib/pymodules/python2.7/django/db/models/base.py", line 460, in save
    self.save_base(using=using, force_insert=force_insert, force_update=force_update)
  File "/usr/lib/pymodules/python2.7/django/db/models/base.py", line 553, in save_base
    result = manager._insert(values, return_id=update_pk, using=using)
  File "/usr/lib/pymodules/python2.7/django/db/models/manager.py", line 195, in _insert
    return insert_query(self.model, values, **kwargs)
  File "/usr/lib/pymodules/python2.7/django/db/models/query.py", line 1436, in insert_query
    return query.get_compiler(using=using).execute_sql(return_id)
  File "/usr/lib/pymodules/python2.7/django/db/models/sql/compiler.py", line 791, in execute_sql
    cursor = super(SQLInsertCompiler, self).execute_sql(None)
  File "/usr/lib/pymodules/python2.7/django/db/models/sql/compiler.py", line 734, in execute_sql
    cursor = self.connection.cursor()
  File "/usr/lib/pymodules/python2.7/django/db/backends/__init__.py", line 252, in cursor
    cursor = util.CursorWrapper(self._cursor(), self)
  File "/usr/lib/pymodules/python2.7/django/db/backends/postgresql_psycopg2/base.py", line 140, in _cursor
    self.connection = Database.connect(**conn_params)
psycopg2.OperationalError: FATAL: remaining connection slots are reserved for non-replication superuser connections

[Muharem Hrnjadovic (al-maisan)]

$ ps ax | grep postg | grep openquake | wc -l
196

196 open connections is not too bad since we have 186 workers.

[Muharem Hrnjadovic (al-maisan)]

Increased the number of connections to 256