DB error after upgrade

Administrators
21 
$ indico db stamp 5d05eda06776
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
(.venv) indico@indico:~$ psql
psql (13.15 (Debian 13.15-1.pgdg120+1))
Type "help" for help.

indico=> select * from alembic_version
indico-> ;
 version_num  
--------------
 4f5bac451434
(1 row)

$ indico db stamp 5d05eda06776
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
(.venv) indico@indico:~$ psql
psql (13.15 (Debian 13.15-1.pgdg120+1))
Type "help" for help.

indico=> select * from alembic_version
indico-> ;
 version_num  
--------------
 4f5bac451434
(1 row)
22 
-rw-r--r-- 1 indico www-data   811 Jun 16 14:56 /opt/indico/.venv/lib/python3.12/site-packages/indico/migrations/versions/20231124_0941_fb0ca1440185_add_redirect_uri_checkin_app.py
-rw-r--r-- 1 indico www-data  2078 Jun 16 14:56 /opt/indico/.venv/lib/python3.12/site-packages/indico/migrations/versions/20231201_1200_e2b69fe5155d_add_user_data_export_table.py
-rw-r--r-- 1 indico www-data   712 Jun 16 14:56 /opt/indico/.venv/lib/python3.12/site-packages/indico/migrations/versions/20231213_1432_8e08236a529f_add_skip_access_check_to_invitations.py
-rw-r--r-- 1 indico www-data  1046 Jun 16 14:56 /opt/indico/.venv/lib/python3.12/site-packages/indico/migrations/versions/20240206_1223_5bb555dd91eb_update_merged_users_in_abstract_email_logs.py
-rw-r--r-- 1 indico www-data  1042 Jun 16 14:56 /opt/indico/.venv/lib/python3.12/site-packages/indico/migrations/versions/20240209_1700_17996ef18cb9_add_picture_personal_data_type_registrations.py
-rw-r--r-- 1 indico www-data  2455 Jun 16 14:56 /opt/indico/.venv/lib/python3.12/site-packages/indico/migrations/versions/20240219_1130_492c6d801a4a_add_google_wallet_integration.py
-rw-r--r-- 1 indico www-data   694 Jun 16 14:56 /opt/indico/.venv/lib/python3.12/site-packages/indico/migrations/versions/20240229_1300_b697f09a120d_add_exceptional_modification_deadline.py
-rw-r--r-- 1 indico www-data   569 Jun 16 14:56 /opt/indico/.venv/lib/python3.12/site-packages/indico/migrations/versions/20240229_1500_e4ac92d27295_add_accepted_terms_dt_users.py
-rw-r--r-- 1 indico www-data  6894 Jun 16 14:56 /opt/indico/.venv/lib/python3.12/site-packages/indico/migrations/versions/20240307_1408_b37cbc4bb129_link_events_to_reservation_occurrences.py
-rw-r--r-- 1 indico www-data  1141 Jun 16 14:56 /opt/indico/.venv/lib/python3.12/site-packages/indico/migrations/versions/20240314_1430_4e32f4d5ebe4_add_registration_id_to_designer_templates.py
23

Can you try indico db stamp --purge 5d05eda06776 and then the upgrade? Maybe it does not like the “bad” revision in the table…

24

Sorry cannot send more replies, but the --purge did the trick!

$ indico db stamp --purge 5d05eda06776
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running stamp_revision  -> 5d05eda06776
(.venv) indico@indico:~$ psql
psql (13.15 (Debian 13.15-1.pgdg120+1))
Type "help" for help.

indico=> select * from alembic_version;
 version_num  
--------------
 5d05eda06776
(1 row)

indico=> quit
(.venv) indico@indico:~$ indico db upgrade
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 5d05eda06776 -> 9b3fc740b722, Fix user name_format values
INFO  [alembic.runtime.migration] Running upgrade 9b3fc740b722 -> aba7935f9226, Add is_event_not_happening to EventLabel
INFO  [alembic.runtime.migration] Running upgrade aba7935f9226 -> e47fc6634291, Add menu entry ACLs
INFO  [alembic.runtime.migration] Running upgrade e47fc6634291 -> a59688f9ba40, Add require_privacy_policy_agreement to regforms
INFO  [alembic.runtime.migration] Running upgrade a59688f9ba40 -> 0af8f63aa603, Refactor editing revisions
INFO  [alembic.runtime.migration] Running upgrade 0af8f63aa603 -> cb46beecbb93, Add Editable.is_deleted
INFO  [alembic.runtime.migration] Running upgrade cb46beecbb93 -> cd7038a37646, Add internal_note column to room bookings
INFO  [alembic.runtime.migration] Running upgrade cd7038a37646 -> 0c44046dc1be, Add generate accompanying person tickets
INFO  [alembic.runtime.migration] Running upgrade 0c44046dc1be -> d8562ad31e90, Add created_dt on User model
INFO  [alembic.runtime.migration] Running upgrade d8562ad31e90 -> 13d8ba15a83b, Add recurrence_weekdays to reservations
INFO  [alembic.runtime.migration] Running upgrade 13d8ba15a83b -> 155cfc134f0c, Setting for future events threshold
INFO  [alembic.runtime.migration] Running upgrade 155cfc134f0c -> 31b699664893, Add modified date to editing revisions
INFO  [alembic.runtime.migration] Running upgrade 31b699664893 -> 0acf26d68434, Add subcontrib_speakers_can_submit to events table
INFO  [alembic.runtime.migration] Running upgrade 0acf26d68434 -> 252d61f890a0, Add receipt data structures
INFO  [alembic.runtime.migration] Running upgrade 252d61f890a0 -> fb0ca1440185, Add a redirect URI for the new Check-in app
INFO  [alembic.runtime.migration] Running upgrade fb0ca1440185 -> e2b69fe5155d, Add data_export_requests table
INFO  [alembic.runtime.migration] Running upgrade e2b69fe5155d -> 8e08236a529f, Add skip_access_check to invitations
INFO  [alembic.runtime.migration] Running upgrade 8e08236a529f -> 5bb555dd91eb, Update merged users in abstract email logs
INFO  [alembic.runtime.migration] Running upgrade 5bb555dd91eb -> 17996ef18cb9, Add picture personal data type for registrations
INFO  [alembic.runtime.migration] Running upgrade 17996ef18cb9 -> 492c6d801a4a, Add Google Wallet integration
INFO  [alembic.runtime.migration] Running upgrade 492c6d801a4a -> b697f09a120d, Add exceptional modification deadline to registrations
INFO  [alembic.runtime.migration] Running upgrade b697f09a120d -> e4ac92d27295, Add accepted_terms_dt to users
INFO  [alembic.runtime.migration] Running upgrade e4ac92d27295 -> b37cbc4bb129, Link events to reservation occurrences
INFO  [alembic.runtime.migration] Running upgrade b37cbc4bb129 -> 4e32f4d5ebe4, Add registration_form_id to designer templates
25

sorry, i meant --purge