Bug 53590 - admindiary/options: ProgrammingError: (psycopg2.ProgrammingError) FEHLER: Relation »tags« existiert nicht
admindiary/options: ProgrammingError: (psycopg2.ProgrammingError) FEHLER: Re...
Status: NEW
Product: UCS
Classification: Unclassified
Component: Admin Diary
UCS 4.4
Other Linux
: P5 normal (vote)
: ---
Assigned To: UCS maintainers
UCS maintainers
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2021-07-16 20:34 CEST by Christian Castens
Modified: 2022-08-01 16:15 CEST (History)
0 users

See Also:
What kind of report is it?: ---
What type of bug is this?: ---
Who will be affected by this bug?: ---
How will those affected feel about the bug?: ---
User Pain:
Enterprise Customer affected?:
School Customer affected?:
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number: 2021071421000338, 2021013121000183
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 Christian Castens univentionstaff 2021-07-16 20:34:13 CEST
Version: 4.4-8 errata1007 (Blumenthal)

Remark: Nach dem auf einer BDN-Rolle das Domain Join Skript (erfolgreich) für das Admin Diary ausgeführt wurde, erscheint beim Aufruf diese Fehlermeldung.

Error:
Interner Server-Fehler in "admindiary/options".
Request: admindiary/options

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 321, in _response
    result = _multi_response(self, request)
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 181, in _response
    return function(self, request)
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 443, in _response
    return list(function(self, iterator, *nones))
  File "%PY2.7%/univention/management/console/modules/decorators.py", line 289, in _fake_func
    yield function(self, *args)
  File "%PY2.7%/univention/management/console/modules/admindiary/__init__.py", line 111, in options
    return client.options()
  File "%PY2.7%/univention/admindiary/backend.py", line 189, in options
    ret['tags'] = sorted([tag.name for tag in self._session.query(Tag).all()])
  File "%PY2.7%/sqlalchemy/orm/query.py", line 2613, in all
    return list(self)
  File "%PY2.7%/sqlalchemy/orm/query.py", line 2761, in __iter__
    return self._execute_and_instances(context)
  File "%PY2.7%/sqlalchemy/orm/query.py", line 2776, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "%PY2.7%/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "%PY2.7%/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "%PY2.7%/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
    compiled_sql, distilled_params
  File "%PY2.7%/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "%PY2.7%/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "%PY2.7%/sqlalchemy/util/compat.py", line 202, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "%PY2.7%/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "%PY2.7%/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
ProgrammingError: (psycopg2.ProgrammingError) FEHLER:  Relation »tags« existiert nicht
ZEILE 2: FROM tags
              ^
 [SQL: 'SELECT tags.id AS tags_id, tags.name AS tags_name \nFROM tags']

Role: domaincontroller_backup

Errno: 94a22552cfbcaa800d19cc6497eaa68c