#4200 declined git push for "FATAL: remaining connection slots are reserved for non-replication superuser connections"
Closed: Invalid by pingou. Opened by jaruga.

Right now i faced below error when doing "git push" to my forked repository.
Do you know why?

$ git remote -v
jaruga  ssh://jaruga@pkgs.fedoraproject.org/forks/jaruga/rpms/ruby.git (fetch)
jaruga  ssh://jaruga@pkgs.fedoraproject.org/forks/jaruga/rpms/ruby.git (push)
origin  ssh://jaruga@pkgs.fedoraproject.org/rpms/ruby.git (fetch)
origin  ssh://jaruga@pkgs.fedoraproject.org/rpms/ruby.git (push)
$ git push jaruga hotfix/f29-fix-ftbfs
Enumerating objects: 20, done.
Counting objects: 100% (20/20), done.
Delta compression using up to 4 threads
Compressing objects: 100% (17/17), done.
Writing objects: 100% (17/17), 13.92 KiB | 13.92 MiB/s, done.
Total 17 (delta 10), reused 0 (delta 0)
remote: Traceback (most recent call last):
remote:   File "hooks/pre-receive", line 36, in <module>
remote:     run_hook_file(hooktype)
remote:   File "/usr/lib/python2.7/site-packages/pagure/hooks/__init__.py", line 526, in run_hook_file
remote:     session, repo, user=username, namespace=namespace
remote:   File "/usr/lib/python2.7/site-packages/pagure/lib/query.py", line 2752, in _get_project
remote:     return query.one()
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2395, in one
remote:     ret = list(self)
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2438, in __iter__
remote:     return self._execute_and_instances(context)
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2451, in _execute_and_instances
remote:     close_with_result=True)
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2442, in _connection_from_session
remote:     **kw)
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 854, in connection
remote:     close_with_result=close_with_result)
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 858, in _connection_for_bind
remote:     return self.transaction._connection_for_bind(engine)
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 322, in _connection_for_bind
remote:     conn = bind.contextual_connect()
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1798, in contextual_connect
remote:     self.pool.connect(),
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 338, in connect
remote:     return _ConnectionFairy._checkout(self)
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 644, in _checkout
remote:     fairy = _ConnectionRecord.checkout(pool)
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 440, in checkout
remote:     rec = pool._do_get()
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 963, in _do_get
remote:     return self._create_connection()
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 285, in _create_connection
remote:     return _ConnectionRecord(self)
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 411, in __init__
remote:     self.connection = self.__connect()
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 538, in __connect
remote:     connection = self.__pool._creator()
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 96, in connect
remote:     connection_invalidated=invalidated
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
remote:     reraise(type(exception), exception, tb=exc_tb)
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 90, in connect
remote:     return dialect.connect(*cargs, **cparams)
remote:   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 377, in connect
remote:     return self.dbapi.connect(*cargs, **cparams)
remote:   File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 164, in connect
remote:     conn = _connect(dsn, connection_factory=connection_factory, async=async)
remote: sqlalchemy.exc.OperationalError: (OperationalError) FATAL:  remaining connection slots are reserved for non-replication superuser connections
remote:  None None
To ssh://pkgs.fedoraproject.org/forks/jaruga/rpms/ruby.git
 ! [remote rejected] hotfix/f29-fix-ftbfs -> hotfix/f29-fix-ftbfs (pre-receive hook declined)
error: failed to push some refs to 'ssh://jaruga@pkgs.fedoraproject.org/forks/jaruga/rpms/ruby.git'

Thanks.


This is an infra issue that has been reported and is being tracked at: https://pagure.io/fedora-infrastructure/issue/7500

Thanks for your report though :)

Metadata Update from @pingou:
- Issue close_status updated to: Invalid
- Issue status updated to: Closed (was: Open)

Sure! :)
Now I could push the branch.

Metadata