Hi was just testet it on testserver with centos7 and apache, get database errors. 3.1.1 runs fine.
Just followed the normal update instructions from Upgrade — Indico 3.2 documentation except the python update at the end.
Traceback
---------
Traceback (most recent call last):
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context
)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedTable: relation "users.affiliations" does not exist
LINE 2: ...d = categories.principals.user_id LEFT OUTER JOIN users.affi...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/indico/.venv/lib/python3.9/site-packages/flask/app.py", line 1516, in full_dispatch_request
if rv is None:
File "/opt/indico/.venv/lib/python3.9/site-packages/flask/app.py", line 1502, in dispatch_request
# otherwise dispatch to the handler for that endpoint
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/flask/util.py", line 79, in wrapper
return obj().process()
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/rh.py", line 291, in process
handle_sqlalchemy_database_error() # this will re-raise an exception
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/rh.py", line 281, in process
res = self._do_process()
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/rh.py", line 252, in _do_process
rv = self._process()
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/modules/categories/controllers/display.py", line 233, in _process
children_strategy.load_only('id')
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/modules/categories/controllers/util.py", line 144, in get_category_view_params
managers = sorted(category.get_manager_list(), key=attrgetter('principal_type.name', 'name'))
File "/opt/indico/.venv/lib/python3.9/site-packages/indico/core/db/sqlalchemy/protection.py", line 500, in get_manager_list
for x in self.acl_entries
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/attributes.py", line 481, in __get__
)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/attributes.py", line 941, in get
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/attributes.py", line 977, in _fire_loader_callables
elif self.callable_:
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/strategies.py", line 911, in _load_for_state
return self._emit_lazyload(
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/strategies.py", line 1047, in _emit_lazyload
result = session.execute(
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1692, in execute
orm_exec_state._starting_event_idx = idx
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1614, in _execute_20
(
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
d.pop("_is_clone_of", None)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1481, in _execute_clauseelement
self.dispatch.after_execute(
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1845, in _execute_context
statement,
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2026, in _handle_dbapi_exception
util.raise_(
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
try:
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context
)
File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "users.affiliations" does not exist
LINE 2: ...d = categories.principals.user_id LEFT OUTER JOIN users.affi...
^
[SQL: SELECT categories.principals.mp_group_provider AS categories_principals_mp_group_provider, categories.principals.mp_group_name AS categories_principals_mp_group_name, categories.principals.read_access AS categories_principals_read_access, categories.principals.full_access AS
categories_principals_full_access, categories.principals.permissions AS categories_principals_permissions, categories.principals.id AS categories_principals_id, categories.principals.category_id AS categories_principals_category_id, categories.principals.type AS categories_principals_type,
categories.principals.user_id AS categories_principals_user_id, categories.principals.local_group_id AS categories_principals_local_group_id, categories.principals.ip_network_group_id AS categories_principals_ip_network_group_id, categories.principals.category_role_id AS
categories_principals_category_role_id, users_1.title AS users_1_title, affiliations_1.id AS affiliations_1_id, affiliations_1.user_id AS affiliations_1_user_id, affiliations_1.name AS affiliations_1_name, emails_1.id AS emails_1_id, emails_1.user_id AS emails_1_user_id, emails_1.email AS
emails_1_email, emails_1.is_primary AS emails_1_is_primary, emails_1.is_user_deleted AS emails_1_is_user_deleted, users_1.id AS users_1_id, users_1.first_name AS users_1_first_name, users_1.last_name AS users_1_last_name, users_1.phone AS users_1_phone, users_1.address AS users_1_address,
users_1.merged_into_id AS users_1_merged_into_id, users_1.is_system AS users_1_is_system, users_1.is_admin AS users_1_is_admin, users_1.is_blocked AS users_1_is_blocked, users_1.is_pending AS users_1_is_pending, users_1.is_deleted AS users_1_is_deleted, users_1.signing_secret AS
users_1_signing_secret, users_1.picture_metadata AS users_1_picture_metadata, users_1.picture_source AS users_1_picture_source, groups_1.id AS groups_1_id, groups_1.name AS groups_1_name, ip_networks_1.group_id AS ip_networks_1_group_id, ip_networks_1.network AS ip_networks_1_network,
ip_network_groups_1.id AS ip_network_groups_1_id, ip_network_groups_1.name AS ip_network_groups_1_name, ip_network_groups_1.description AS ip_network_groups_1_description, ip_network_groups_1.hidden AS ip_network_groups_1_hidden, ip_network_groups_1.attachment_access_override AS
ip_network_groups_1_attachment_access_override, roles_1.id AS roles_1_id, roles_1.category_id AS roles_1_category_id, roles_1.name AS roles_1_name, roles_1.code AS roles_1_code, roles_1.color AS roles_1_color
FROM categories.principals LEFT OUTER JOIN users.users AS users_1 ON users_1.id = categories.principals.user_id LEFT OUTER JOIN users.affiliations AS affiliations_1 ON users_1.id = affiliations_1.user_id LEFT OUTER JOIN users.emails AS emails_1 ON users_1.id = emails_1.user_id AND
emails_1.is_primary LEFT OUTER JOIN users.groups AS groups_1 ON groups_1.id = categories.principals.local_group_id LEFT OUTER JOIN indico.ip_network_groups AS ip_network_groups_1 ON ip_network_groups_1.id = categories.principals.ip_network_group_id LEFT OUTER JOIN indico.ip_networks AS ip_networks_1
ON ip_network_groups_1.id = ip_networks_1.group_id LEFT OUTER JOIN categories.roles AS roles_1 ON roles_1.id = categories.principals.category_role_id
WHERE %(param_1)s = categories.principals.category_id]
[parameters: {'param_1': 0}]
(Background on this error at: https://sqlalche.me/e/14/f405)
Request Data
------------
{'data': {'get': {},
'headers': {'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8',
'Accept-Encoding': 'gzip, deflate, br',
'Accept-Language': 'de,en-US;q=0.7,en;q=0.3',
'Cache-Control': 'no-cache',
'Connection': 'keep-alive',
'Cookie': 'CID=AgAAAMmF/i/pyQGNT6XeN/ol8m8=',
'Dnt': '1',
'Host': 'XXXXXXXXXXXXXXXXX.de',
'Pragma': 'no-cache',
'Sec-Fetch-Dest': 'document',
'Sec-Fetch-Mode': 'navigate',
'Sec-Fetch-Site': 'none',
'Sec-Fetch-User': '?1',
'Upgrade-Insecure-Requests': '1',
'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; '
'rv:91.0) Gecko/20100101 Firefox/91.0'},
'json': None,
'post': {},
'url': {'category_id': 0}},
'endpoint': 'categories.display',
'id': '7b134c8dc3774ea0',
'ip': 'XXXXXXXXXXXXXX',
'method': 'GET',
'referrer': None,
'rh': 'RHDisplayCategory',
'time': '2022-08-25T11:02:43.068566',
'url': 'https://XXXXXXXXXXXXXXX.de/',
'user': None,
'user_agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) '
'Gecko/20100101 Firefox/91.0'}
--
Indico :: Error Report
https://XXXXXXXXXXXXXXXX.de/