Univention Bugzilla – Bug 37664
[pkgdb] transaction is aborted
Last modified: 2019-06-28 14:39:34 CEST
Probably when restarting / stopping postgresql?! We just catch pgdb.OperationalError and try to reconnect then. Probably we should catch pgdb.DatabaseError or pgdb.Error. Traceback: Execution of command 'pkgdb/columns' has failed: Execution of command 'pkgdb/proposals' has failed: Traceback (most recent call last): File "/usr/lib/pymodules/python2.7/univention/management/console/modules/__init__.py", line 176, in _decorated return function(self, request, *args, **kwargs) File "/usr/lib/pymodules/python2.7/univention/management/console/modules/decorators.py", line 188, in _response return function(self, request) File "/usr/lib/pymodules/python2.7/univention/management/console/modules/pkgdb/__init__.py", line 221, in _connect self.test_connection() File "/usr/lib/pymodules/python2.7/univention/management/console/modules/pkgdb/__init__.py", line 239, in test_connection self.cursor.execute('SELECT TRUE') File "/usr/lib/python2.7/dist-packages/pgdb.py", line 259, in execute self.executemany(operation, (params,)) File "/usr/lib/python2.7/dist-packages/pgdb.py", line 289, in executemany raise DatabaseError("error '%s' in '%s'" % (msg, sql)) DatabaseError: error 'ERROR: current transaction is aborted, commands ignored until end of transaction block ' in 'SELECT TRUE' Remark: Trying to view packages
Code introduced by Bug #34723.
Maybe a "connection.rollback()" before the "SELECT TRUE" solves this as well.
This issue has been filled against UCS 4.0. The maintenance with bug and security fixes for UCS 4.0 has ended on 31st of May 2016. Customers still on UCS 4.0 are encouraged to update to UCS 4.3. Please contact your partner or Univention for any questions. If this issue still occurs in newer UCS versions, please use "Clone this bug" or simply reopen the issue. In this case please provide detailed information on how this issue is affecting you.
*** Bug 49754 has been marked as a duplicate of this bug. ***