Bug 37664 - [pkgdb] transaction is aborted
[pkgdb] transaction is aborted
Status: REOPENED
Product: UCS
Classification: Unclassified
Component: UMC - Software monitor
UCS 4.4
Other Linux
: P5 normal (vote)
: ---
Assigned To: UMC maintainers
:
: 49754 (view as bug list)
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2015-02-02 09:04 CET by Florian Best
Modified: 2019-06-28 14:39 CEST (History)
3 users (show)

See Also:
What kind of report is it?: Bug Report
What type of bug is this?: 3: Simply Wrong: The implementation doesn't match the docu
Who will be affected by this bug?: 1: Will affect a very few installed domains
How will those affected feel about the bug?: 2: A Pain – users won’t like this once they notice it
User Pain: 0.034
Enterprise Customer affected?:
School Customer affected?:
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number: 2019031921001465
Bug group (optional): Error handling, External feedback
Max CVSS v3 score:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Florian Best univentionstaff 2015-02-02 09:04:29 CET
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
Comment 1 Florian Best univentionstaff 2015-02-02 09:05:52 CET
Code introduced by Bug #34723.
Comment 2 Janek Walkenhorst univentionstaff 2015-02-19 11:28:40 CET
Maybe a "connection.rollback()" before the "SELECT TRUE" solves this as well.
Comment 3 Stefan Gohmann univentionstaff 2019-01-03 07:17:50 CET
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.
Comment 4 Florian Best univentionstaff 2019-06-28 14:38:49 CEST
*** Bug 49754 has been marked as a duplicate of this bug. ***