I’m having an DB issue upgrading from 3.1.1 to 3.2.1. I’m basically going through the steps from Upgrade — Indico 3.2.1 documentation. Everything looks to work okay (there was an error during the db ugrade about CACHE_BACKEND, but I was able to remove that by changing indico.conf). I’ve moved back to backup a few times and tried a couple different steps (e.g. move to 3.2.0 1st).
But every time, when accessing the website after the upgrade I get a database error page. The following is the error I’m getting from log/indico.log (or the postgres logs). It’s running postgresql 12. The relation ‘indico.affiliations’ not existing appears to be the problem. Looking through the DB pre-update, the only place I can find ‘affiliation’ is in the designer_templates table as a “type” in the json data. Notice it is also singular so it appears unrelated with the error being caused by something new in the upgrade.
I’m relatively new to administering indico, so it may be an obvious error. But any help would be appreciated.
Error below:
name;Traceback (most recent call last):
File "/var/local/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
self.dialect.do_execute(
File "/var/local/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedTable: relation "indico.affiliations" does not exist
LINE 2: ...1.user_id AND emails_1.is_primary LEFT OUTER JOIN indico.aff...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/var/local/indico/.venv/lib/python3.9/site-packages/flask/app.py", line 1820, in full_dispatch_request
rv = self.dispatch_request()
File "/var/local/indico/.venv/lib/python3.9/site-packages/flask/app.py", line 1796, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
File "/var/local/indico/.venv/lib/python3.9/site-packages/indico/modules/events/controllers/entry.py", line 35, in event_or_shorturl
return RHDisplayEvent().process()
File "/var/local/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 "/var/local/indico/.venv/lib/python3.9/site-packages/indico/web/rh.py", line 281, in process
res = self._do_process()
File "/var/local/indico/.venv/lib/python3.9/site-packages/indico/modules/events/controllers/base.py", line 90, in _do_process
return RHEventBase._do_process(self)
File "/var/local/indico/.venv/lib/python3.9/site-packages/indico/web/rh.py", line 236, in _do_process
self._check_access()
File "/var/local/indico/.venv/lib/python3.9/site-packages/indico/modules/events/controllers/base.py", line 62, in _check_access
RHProtectedEventBase._check_access(self)
File "/var/local/indico/.venv/lib/python3.9/site-packages/indico/modules/events/controllers/base.py", line 37, in _check_access
if not self.event.can_access(session.user):
File "/var/local/indico/.venv/lib/python3.9/site-packages/indico/util/caching.py", line 54, in memoizer
cache[key] = f(*args, **kwargs)
File "/var/local/indico/.venv/lib/python3.9/site-packages/indico/core/db/sqlalchemy/protection.py", line 213, in can_access
if self.inheriting_have_acl and any(user in entry.principal for entry in iter_acl(self.acl_entries)):
File "/var/local/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/attributes.py", line 482, in __get__
return self.impl.get(state, dict_)
File "/var/local/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/attributes.py", line 942, in get
value = self._fire_loader_callables(state, key, passive)
File "/var/local/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/attributes.py", line 978, in _fire_loader_callables
return self.callable_(state, passive)
File "/var/local/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/strategies.py", line 912, in _load_for_state
return self._emit_lazyload(
File "/var/local/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/strategies.py", line 1046, in _emit_lazyload
result = session.execute(
File "/var/local/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1714, in execute
result = conn._execute_20(statement, params or {}, execution_options)
File "/var/local/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/var/local/indico/.venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection
return connection._execute_clauseelement(
File "/var/local/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement
ret = self._execute_context(
File "/var/local/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context
self._handle_dbapi_exception(
File "/var/local/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapi_exception
util.raise_(
File "/var/local/indico/.venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/var/local/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
self.dialect.do_execute(
File "/var/local/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "indico.affiliations" does not exist
LINE 2: ...1.user_id AND emails_1.is_primary LEFT OUTER JOIN indico.aff...
^
[SQL: SELECT events.principals.mp_group_provider AS events_principals_mp_group_provider, events.principals.mp_group_name AS events_principals_mp_group_name, events.principals.read_access AS events_principals_read_access, events.principals.full_access AS events_principals_full_access, events.principals.permissions AS events_principals_permissions, events.principals.id AS events_principals_id, events.principals.event_id AS events_principals_event_id, events.principals.type AS events_principals_type, events.principals.user_id AS events_principals_user_id, events.principals.local_group_id AS events_principals_local_group_id, events.principals.email AS events_principals_email, events.principals.ip_network_group_id AS events_principals_ip_network_group_id, events.principals.event_role_id AS events_principals_event_role_id, events.principals.category_role_id AS events_principals_category_role_id, events.principals.registration_form_id AS events_principals_registration_form_id, users_1.title AS users_1_title, 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, affiliations_1.id AS affiliations_1_id, affiliations_1.name AS affiliations_1_name, affiliations_1.is_deleted AS affiliations_1_is_deleted, affiliations_1.street AS affiliations_1_street, affiliations_1.postcode AS affiliations_1_postcode, affiliations_1.city AS affiliations_1_city, affiliations_1.country_code AS affiliations_1_country_code, affiliations_1.meta AS affiliations_1_meta, 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.affiliation AS users_1_affiliation, users_1.affiliation_id AS users_1_affiliation_id, 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.event_id AS roles_1_event_id, roles_1.name AS roles_1_name, roles_1.code AS roles_1_code, roles_1.color AS roles_1_color, roles_2.id AS roles_2_id, roles_2.category_id AS roles_2_category_id, roles_2.name AS roles_2_name, roles_2.code AS roles_2_code, roles_2.color AS roles_2_color, forms_1.id AS forms_1_id, forms_1.event_id AS forms_1_event_id, forms_1.title AS forms_1_title, forms_1.is_participation AS forms_1_is_participation, forms_1.introduction AS forms_1_introduction, forms_1.contact_info AS forms_1_contact_info, forms_1.start_dt AS forms_1_start_dt, forms_1.end_dt AS forms_1_end_dt, forms_1.modification_mode AS forms_1_modification_mode, forms_1.modification_end_dt AS forms_1_modification_end_dt, forms_1.is_deleted AS forms_1_is_deleted, forms_1.require_login AS forms_1_require_login, forms_1.require_user AS forms_1_require_user, forms_1.require_captcha AS forms_1_require_captcha, forms_1.registration_limit AS forms_1_registration_limit, forms_1.publish_registrations_public AS forms_1_publish_registrations_public, forms_1.publish_registrations_participants AS forms_1_publish_registrations_participants, forms_1.publish_registrations_duration AS forms_1_publish_registrations_duration, forms_1.publish_registration_count AS forms_1_publish_registration_count, forms_1.publish_checkin_enabled AS forms_1_publish_checkin_enabled, forms_1.moderation_enabled AS forms_1_moderation_enabled, forms_1.base_price AS forms_1_base_price, forms_1.currency AS forms_1_currency, forms_1.notification_sender_address AS forms_1_notification_sender_address, forms_1.message_pending AS forms_1_message_pending, forms_1.message_unpaid AS forms_1_message_unpaid, forms_1.message_complete AS forms_1_message_complete, forms_1.attach_ical AS forms_1_attach_ical, forms_1.manager_notifications_enabled AS forms_1_manager_notifications_enabled, forms_1.manager_notification_recipients AS forms_1_manager_notification_recipients, forms_1.tickets_enabled AS forms_1_tickets_enabled, forms_1.ticket_on_email AS forms_1_ticket_on_email, forms_1.ticket_on_event_page AS forms_1_ticket_on_event_page, forms_1.ticket_on_summary_page AS forms_1_ticket_on_summary_page, forms_1.ticket_template_id AS forms_1_ticket_template_id, forms_1.retention_period AS forms_1_retention_period, forms_1.is_purged AS forms_1_is_purged
FROM events.principals LEFT OUTER JOIN users.users AS users_1 ON users_1.id = events.principals.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 indico.affiliations AS affiliations_1 ON affiliations_1.id = users_1.affiliation_id LEFT OUTER JOIN users.groups AS groups_1 ON groups_1.id = events.principals.local_group_id LEFT OUTER JOIN indico.ip_network_groups AS ip_network_groups_1 ON ip_network_groups_1.id = events.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 events.roles AS roles_1 ON roles_1.id = events.principals.event_role_id LEFT OUTER JOIN categories.roles AS roles_2 ON roles_2.id = events.principals.category_role_id LEFT OUTER JOIN event_registration.forms AS forms_1 ON forms_1.id = events.principals.registration_form_id
WHERE %(param_1)s = events.principals.event_id]
[parameters: {'param_1': 46}]
(Background on this error at: https://sqlalche.me/e/14/f405)