Re: Weird error output when using "git push"

[Robert-André Mauchin <zebob.m@xxxxxxxxx>]

On 8/12/21 2:36 PM, Richard Shaw wrote:
> Now that vigra went stable in f35 I'm trying to build hugin.The git 
> merge from rawhide worked fine as usual but when I tried 'git push' I 
> get this:
>
> $ git merge rawhide
> Updating 88d7c81..69827ac
> Fast-forward
>   hugin-openexr3.patch | 17 ++++++++++++++++-
>   hugin.spec           | 11 ++++++++++-
>   2 files changed, 26 insertions(+), 2 deletions(-)
> [build@hobbes hugin]$ git push
> Total 0 (delta 0), reused 0 (delta 0), pack-reused 0
> remote: Traceback (most recent call last):
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 
> 2262, in _wrap_pool_connect
> remote:     return fn()
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/pool/base.py", line 354, 
> in connect
> remote:     return _ConnectionFairy._checkout(self)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/pool/base.py", line 751, 
> in _checkout
> remote:     fairy = _ConnectionRecord.checkout(pool)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/pool/base.py", line 483, 
> in checkout
> remote:     rec = pool._do_get()
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/pool/impl.py", line 138, 
> in _do_get
> remote:     self._dec_overflow()
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/util/langhelpers.py", 
> line 68, in __exit__
> remote:     compat.reraise(exc_type, exc_value, exc_tb)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 
> 129, in reraise
> remote:     raise value
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/pool/impl.py", line 135, 
> in _do_get
> remote:     return self._create_connection()
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/pool/base.py", line 299, 
> in _create_connection
> remote:     return _ConnectionRecord(self)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/pool/base.py", line 428, 
> in __init__
> remote:     self.__connect(first_connect_check=True)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/pool/base.py", line 630, 
> in __connect
> remote:     connection = pool._invoke_creator(self)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/strategies.py", 
> line 114, in connect
> remote:     return dialect.connect(*cargs, **cparams)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line 
> 453, in connect
> remote:     return self.dbapi.connect(*cargs, **cparams)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/psycopg2/__init__.py", line 130, in 
> connect
> remote:     conn = _connect(dsn, connection_factory=connection_factory, 
> **kwasync)
> remote: psycopg2.OperationalError: FATAL:  remaining connection slots 
> are reserved for non-replication superuser connections
> remote:
> remote:
> remote: The above exception was the direct cause of the following exception:
> remote:
> remote: Traceback (most recent call last):
> remote:   File "hooks/pre-receive", line 48, in <module>
> remote:     run_hook_file(hooktype)
> remote:   File 
> "/usr/lib/python3.6/site-packages/pagure/hooks/__init__.py", line 531, 
> in run_hook_file
> remote:     session, repo, user=username, namespace=namespace
> remote:   File "/usr/lib/python3.6/site-packages/pagure/lib/query.py", 
> line 2865, in _get_project
> remote:     return query.one()
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 3275, 
> in one
> remote:     ret = self.one_or_none()
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 3244, 
> in one_or_none
> remote:     ret = list(self)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 3317, 
> in __iter__
> remote:     return self._execute_and_instances(context)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 3339, 
> in _execute_and_instances
> remote:     querycontext, self._connection_from_session, 
> close_with_result=True
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 3354, 
> in _get_bind_args
> remote:     mapper=self._bind_mapper(), clause=querycontext.statement, **kw
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 3332, 
> in _connection_from_session
> remote:     conn = self.session.connection(**kw)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/session.py", line 
> 1123, in connection
> remote:     execution_options=execution_options,
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/session.py", line 
> 1129, in _connection_for_bind
> remote:     engine, execution_options
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/session.py", line 
> 430, in _connection_for_bind
> remote:     conn = bind._contextual_connect()
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 
> 2226, in _contextual_connect
> remote:     self._wrap_pool_connect(self.pool.connect, None),
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 
> 2266, in _wrap_pool_connect
> remote:     e, dialect, self
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 
> 1536, in _handle_dbapi_exception_noconnection
> remote:     util.raise_from_cause(sqlalchemy_exception, exc_info)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 
> 383, in raise_from_cause
> remote:     reraise(type(exception), exception, tb=exc_tb, cause=cause)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 
> 128, in reraise
> remote:     raise value.with_traceback(tb)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 
> 2262, in _wrap_pool_connect
> remote:     return fn()
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/pool/base.py", line 354, 
> in connect
> remote:     return _ConnectionFairy._checkout(self)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/pool/base.py", line 751, 
> in _checkout
> remote:     fairy = _ConnectionRecord.checkout(pool)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/pool/base.py", line 483, 
> in checkout
> remote:     rec = pool._do_get()
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/pool/impl.py", line 138, 
> in _do_get
> remote:     self._dec_overflow()
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/util/langhelpers.py", 
> line 68, in __exit__
> remote:     compat.reraise(exc_type, exc_value, exc_tb)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 
> 129, in reraise
> remote:     raise value
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/pool/impl.py", line 135, 
> in _do_get
> remote:     return self._create_connection()
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/pool/base.py", line 299, 
> in _create_connection
> remote:     return _ConnectionRecord(self)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/pool/base.py", line 428, 
> in __init__
> remote:     self.__connect(first_connect_check=True)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/pool/base.py", line 630, 
> in __connect
> remote:     connection = pool._invoke_creator(self)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/strategies.py", 
> line 114, in connect
> remote:     return dialect.connect(*cargs, **cparams)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line 
> 453, in connect
> remote:     return self.dbapi.connect(*cargs, **cparams)
> remote:   File 
> "/usr/lib64/python3.6/site-packages/psycopg2/__init__.py", line 130, in 
> connect
> remote:     conn = _connect(dsn, connection_factory=connection_factory, 
> **kwasync)
> remote: sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) 
> FATAL:  remaining connection slots are reserved for non-replication 
> superuser connections
> remote:
> remote: (Background on this error at: http://sqlalche.me/e/e3q8 
> <http://sqlalche.me/e/e3q8>)
> To ssh://pkgs.fedoraproject.org/rpms/hugin 
> <http://pkgs.fedoraproject.org/rpms/hugin>
>   ! [remote rejected] f35 -> f35 (pre-receive hook declined)
> error: failed to push some refs to 
> 'ssh://pkgs.fedoraproject.org/rpms/hugin 
> <http://pkgs.fedoraproject.org/rpms/hugin>'
>
> I've gotten this one other time. On a whim I tried reauthenticating, it 
> removes all the verbose part of the error but I still get:
>
> $ git push
> Total 0 (delta 0), reused 0 (delta 0), pack-reused 0
> remote: Unspecified ref refs/heads/f35 is blocked
> remote: Denied push for ref 'refs/heads/f35' for user 'hobbes1069'
> remote: All changes have been rejected
> To ssh://pkgs.fedoraproject.org/rpms/hugin 
> <http://pkgs.fedoraproject.org/rpms/hugin>
>   ! [remote rejected] f35 -> f35 (pre-receive hook declined)
> error: failed to push some refs to 
> 'ssh://pkgs.fedoraproject.org/rpms/hugin 
> <http://pkgs.fedoraproject.org/rpms/hugin>'
>
> Ideas? Last time I just deleted and re-checked out the repo but I 
> shouldn't have to do that.
>
> Thanks,
> Richard

Had the same issue, filled a bug with infra:
https://pagure.io/fedora-infrastructure/issue/10157

As a workaround I use a PR to my own project and merged it with no 
issue. I didn't have issue merging to stable branches afterwards.
_______________________________________________
devel mailing list -- devel@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe send an email to devel-leave@xxxxxxxxxxxxxxxxxxxxxxx
Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives: https://lists.fedoraproject.org/archives/list/devel@xxxxxxxxxxxxxxxxxxxxxxx
Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure