Bug 47596 – pkgdb/columns: InternalError: ERROR: current transaction is aborted, commands ignored until end of transaction block

Bug 47596 - pkgdb/columns: InternalError: ERROR: current transaction is aborted, commands ignored until end of transaction block


Summary:	pkgdb/columns: InternalError: ERROR: current transaction is aborted, command...

Status:	NEW

Product:	UCS
Classification:	Unclassified
Component:	UMC - Software monitor
Version:	UCS 5.0
Hardware:	Other Linux

Importance:	P5 normal (vote)
Target Milestone:	---
Assigned To:	UMC maintainers
QA Contact:	UMC maintainers

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2018-08-16 12:40 CEST by Johannes Keiser
Modified:	2021-11-26 10:38 CET (History)
CC List:	2 users (show)

See Also:
What kind of report is it?:	Bug Report
What type of bug is this?:	4: Minor Usability: Impairs usability in secondary scenarios
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.046
Enterprise Customer affected?:
School Customer affected?:
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:	2021112521000434, 2018081021000715, 2020072421000179, 2021053021000212
Bug group (optional):	External feedback
Max CVSS v3 score:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Johannes Keiser

2018-08-16 12:40:48 CEST

Version: 4.3-1 errata163 (Neustadt)

Internal server error during "pkgdb/columns".
Request: pkgdb/columns

Traceback (most recent call last):
  File "%PY2.7%/univention/management/console/base.py", line 253, in execute
    function.__func__(self, request, *args, **kwargs)
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 192, in _response
    return function(self, request)
  File "%PY2.7%/univention/management/console/modules/pkgdb/__init__.py", line 223, in _connect
    self.test_connection()
  File "%PY2.7%/univention/management/console/modules/pkgdb/__init__.py", line 241, in test_connection
    self.cursor.execute('SELECT TRUE')
  File "/usr/lib/python2.7/dist-packages/pgdb.py", line 1026, in execute
    return self.executemany(operation, [parameters])
  File "/usr/lib/python2.7/dist-packages/pgdb.py", line 1050, in executemany
    rows = self._src.execute(sql)
InternalError: ERROR:  current transaction is aborted, commands ignored until end of transaction block

Role: domaincontroller_master

Comment 1 Christian Castens

2020-08-07 13:32:33 CEST

Version: 4.4-5 errata652 (Blumenthal)

Error:
Interner Server-Fehler in "pkgdb/columns".
Request: pkgdb/columns

Traceback (most recent call last):
  File "%PY2.7%/univention/management/console/base.py", line 359, in __error_handling
    six.reraise(etype, exc, etraceback)
  File "%PY2.7%/univention/management/console/base.py", line 262, in execute
    function.__func__(self, request, *args, **kwargs)
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 181, in _response
    return function(self, request)
  File "%PY2.7%/univention/management/console/modules/pkgdb/__init__.py", line 223, in _connect
    self.test_connection()
  File "%PY2.7%/univention/management/console/modules/pkgdb/__init__.py", line 241, in test_connection
    self.cursor.execute('SELECT TRUE')
  File "%PY2.7%/pgdb.py", line 1026, in execute
    return self.executemany(operation, [parameters])
  File "%PY2.7%/pgdb.py", line 1050, in executemany
    rows = self._src.execute(sql)
InternalError: FEHLER:  aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum Ende der Transaktion ignoriert

Role: domaincontroller_master

Errno: a35c1404f90b910f3d0b1e57667d1600

Comment 2 Christian Castens

2021-06-23 11:55:26 CEST

Version: 5.0-0 errata0

Error:
Interner Server-Fehler in "pkgdb/proposals".
Request: pkgdb/proposals

Traceback (most recent call last):
  File "%PY2.7%/univention/management/console/base.py", line 344, in __error_handling
    six.reraise(etype, exc, etraceback)
  File "%PY2.7%/univention/management/console/base.py", line 247, in execute
    function.__func__(self, request, *args, **kwargs)
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 181, in _response
    return function(self, request)
  File "%PY2.7%/univention/management/console/modules/pkgdb/__init__.py", line 223, in _connect
    self.test_connection()
  File "%PY2.7%/univention/management/console/modules/pkgdb/__init__.py", line 241, in test_connection
    self.cursor.execute('SELECT TRUE')
  File "%PY2.7%/pgdb.py", line 1030, in execute
    return self.executemany(operation, [parameters])
  File "%PY2.7%/pgdb.py", line 1054, in executemany
    rows = self._src.execute(sql)
InternalError: FEHLER:  aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum Ende der Transaktion ignoriert

Role: domaincontroller_master

Comment 3 Maximilian Janßen

2021-11-26 10:38:45 CET

reported again:
Version: 5.0-0 errata159
traceback: Comment #2