Something went wrong There was a database error while processing your request

ghazi1 · July 5, 2023, 3:07am

Hello indico community,

My indico error… I can’t access all menus or log in as admin, since that error I have done the following:

Upgrade to 3.2.5 with command ( indico db upgrade --sql, indico db upgrade, indico db --all-plugins upgrade ) when I run the indico db upgrade --sql script I get the following error :

INFO  [alembic.runtime.migration] Running upgrade c0888cb57c58 -> 7a72d63acba9, Update map aspects structure
-- Running upgrade c0888cb57c58 -> 7a72d63acba9

Traceback (most recent call last):
  File "/opt/indico/.venv/bin/indico", line 8, in <module>
    sys.exit(cli())
  File "/opt/indico/.venv/lib/python3.9/site-packages/click/core.py", line 1130, in __call__
    return self.main(*args, **kwargs)
  File "/opt/indico/.venv/lib/python3.9/site-packages/click/core.py", line 1055, in main
    rv = self.invoke(ctx)
  File "/opt/indico/.venv/lib/python3.9/site-packages/click/core.py", line 1657, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/opt/indico/.venv/lib/python3.9/site-packages/indico/cli/util.py", line 108, in invoke
    return self._impl.invoke(ctx)
  File "/opt/indico/.venv/lib/python3.9/site-packages/click/core.py", line 1657, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/opt/indico/.venv/lib/python3.9/site-packages/click/core.py", line 1404, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/opt/indico/.venv/lib/python3.9/site-packages/click/core.py", line 760, in invoke
    return __callback(*args, **kwargs)
  File "/opt/indico/.venv/lib/python3.9/site-packages/click/decorators.py", line 26, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/opt/indico/.venv/lib/python3.9/site-packages/flask/cli.py", line 357, in decorator
    return __ctx.invoke(f, *args, **kwargs)
  File "/opt/indico/.venv/lib/python3.9/site-packages/click/core.py", line 760, in invoke
    return __callback(*args, **kwargs)
  File "/opt/indico/.venv/lib/python3.9/site-packages/indico/cli/database.py", line 139, in _call_with_plugins
    func(*args, **kwargs)
  File "/opt/indico/.venv/lib/python3.9/site-packages/click/decorators.py", line 26, in new_func
    return f(get_current_context(), *args, **kwargs)
  File "/opt/indico/.venv/lib/python3.9/site-packages/flask/cli.py", line 357, in decorator
    return __ctx.invoke(f, *args, **kwargs)
  File "/opt/indico/.venv/lib/python3.9/site-packages/click/core.py", line 760, in invoke
    return __callback(*args, **kwargs)
  File "/opt/indico/.venv/lib/python3.9/site-packages/flask_migrate/cli.py", line 150, in upgrade
    _upgrade(directory, revision, sql, tag, x_arg)
  File "/opt/indico/.venv/lib/python3.9/site-packages/flask_migrate/__init__.py", line 111, in wrapped
    f(*args, **kwargs)
  File "/opt/indico/.venv/lib/python3.9/site-packages/flask_migrate/__init__.py", line 200, in upgrade
    command.upgrade(config, revision, sql=sql, tag=tag)
  File "/opt/indico/.venv/lib/python3.9/site-packages/alembic/command.py", line 378, in upgrade
    script.run_env()
  File "/opt/indico/.venv/lib/python3.9/site-packages/alembic/script/base.py", line 576, in run_env
    util.load_python_file(self.dir, "env.py")
  File "/opt/indico/.venv/lib/python3.9/site-packages/alembic/util/pyfiles.py", line 94, in load_python_file
    module = load_module_py(module_id, path)
  File "/opt/indico/.venv/lib/python3.9/site-packages/alembic/util/pyfiles.py", line 110, in load_module_py
    spec.loader.exec_module(module)  # type: ignore
  File "<frozen importlib._bootstrap_external>", line 850, in exec_module
  File "<frozen importlib._bootstrap>", line 228, in _call_with_frames_removed
  File "/opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/env.py", line 89, in <module>
    run_migrations_offline()
  File "/opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/env.py", line 63, in run_migrations_offline
    context.run_migrations()
  File "<string>", line 8, in run_migrations
  File "/opt/indico/.venv/lib/python3.9/site-packages/alembic/runtime/environment.py", line 868, in run_migrations
    self.get_context().run_migrations(**kw)
  File "/opt/indico/.venv/lib/python3.9/site-packages/alembic/runtime/migration.py", line 622, in run_migrations
    step.migration_fn(**kw)
  File "/opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20181023_1209_7a72d63acba9_update_map_aspects_structure.py", line 21, in upgrade
    raise Exception('This upgrade is only possible in online mode')
Exception: This upgrade is only possible in online mode

This is the error log when I access the indico site :

[parameters: {'provider_1': 'indico', 'identifier_1': 'root4', 'param_1': 1}]
(Background on this error at: https://sqlalche.me/e/14/f405)
Traceback (most recent call last):
  File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1905, in _execute_context
    self.dialect.do_execute(
  File "/opt/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 "/opt/indico/.venv/lib/python3.9/site-packages/flask/app.py", line 1484, in full_dispatch_request
    rv = self.dispatch_request()
  File "/opt/indico/.venv/lib/python3.9/site-packages/flask/app.py", line 1469, in dispatch_request
    return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
  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 295, 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 285, in process
    res = self._do_process()
  File "/opt/indico/.venv/lib/python3.9/site-packages/indico/web/rh.py", line 256, in _do_process
    rv = self._process()
  File "/opt/indico/.venv/lib/python3.9/site-packages/indico/modules/auth/controllers.py", line 100, in _process
    response = multipass.handle_login_form(provider, form.data)
  File "/opt/indico/.venv/lib/python3.9/site-packages/flask_multipass/core.py", line 517, in handle_login_form
    response = provider.process_local_login(data)
  File "/opt/indico/.venv/lib/python3.9/site-packages/flask_multipass/providers/sqlalchemy.py", line 52, in process_local_login
    identity = self.identity_model.query.filter(type(self).provider_column == self.name,
  File "/opt/indico/.venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 2824, in first
    return self.limit(1)._iter().first()

I will be very grateful if someone can help me to do what I should do to solve this problem.

Regards
Ghazi

ThiefMaster · July 5, 2023, 6:44am

don’t use --sql. it’s not supported for all upgrades, some more complex one fail with that exact error message you got.

ghazi1 · July 5, 2023, 6:46am

Thanks for quick reply,

So, what should i do ?

ThiefMaster · July 5, 2023, 6:56am

Just run indico db upgrade like the documentation asks you to do

ghazi1 · July 5, 2023, 7:01am

I just run this script, and i still got same error

ThiefMaster · July 5, 2023, 7:04am

hmm that indicates you ran all updates successfully… what does indico db current -v show?

ghazi1 · July 5, 2023, 7:07am

ThiefMaster · July 5, 2023, 8:02am

What does indico --version tell you?

What’s the output of ls -al /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/*.py?

ghazi1 · July 5, 2023, 8:05am

-rw-rw-r-- 1 indico indico  1423 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20170905_1445_f1eee7b4880a_add_event_roles_table.py
-rw-rw-r-- 1 indico indico 25955 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20170905_1521_640584a3987e_add_event_roles_to_acls.py
-rw-rw-r-- 1 indico indico  1101 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20170914_1433_790a06790309_rename_roles_to_permissions.py
-rw-rw-r-- 1 indico indico   777 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20170915_1023_1d512a9ebb30_add_default_session_to_tracks.py
-rw-rw-r-- 1 indico indico   701 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20171101_1149_566d5de4e0e5_add_is_private_column_to_contribution_types.py
-rw-rw-r-- 1 indico indico  2824 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20171124_1138_2af245be72a6_review_questions_models.py
-rw-rw-r-- 1 indico indico  2467 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20171214_1059_9c4418d7a6aa_add_session_types_table.py
-rw-rw-r-- 1 indico indico  1253 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20180126_1130_093533d27a96_add_visibility_options_to_contribution.py
-rw-rw-r-- 1 indico indico   699 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20180129_0706_c820455976ba_add_include_description_to_reminders.py
-rw-rw-r-- 1 indico indico   922 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20180129_0842_813ea74ce8dc_add_attachment_folder_is_hidden.py
-rw-rw-r-- 1 indico indico   487 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20180423_1602_66ecbb1c0ddd_add_natsort_function.py
-rw-rw-r-- 1 indico indico   822 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20180509_1521_a13e25814c4c_add_favorite_rooms_table.py
-rw-rw-r-- 1 indico indico   512 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20180803_1703_93985a8c11ed_remove_room_thumbnail.py
-rw-rw-r-- 1 indico indico   692 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20181023_1051_55893713f6b7_add_room_name_format.py
-rw-rw-r-- 1 indico indico  1356 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20181023_1103_f7ab9ee32bdf_add_verbose_name_column.py
-rw-rw-r-- 1 indico indico   880 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20181023_1104_c0888cb57c58_remove_holidays_table.py
-rw-rw-r-- 1 indico indico  5051 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20181023_1209_7a72d63acba9_update_map_aspects_structure.py
-rw-rw-r-- 1 indico indico  1031 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20181023_1716_c5c21246445a_rename_aspects_to_map_areas.py
-rw-rw-r-- 1 indico indico   976 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20181023_1730_0117bd0fa784_store_room_coordinates_as_numbers.py
-rw-rw-r-- 1 indico indico  3279 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20181024_1424_27c45c384d65_make_equipment_types_global.py
-rw-rw-r-- 1 indico indico  3589 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20181025_1148_ec410be271df_make_room_attributes_global.py
-rw-rw-r-- 1 indico indico   825 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20181025_1224_7749141f3e08_remove_room_attribute_nesting.py
-rw-rw-r-- 1 indico indico   820 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20181025_1538_db32adb8fc4e_remove_equipment_nesting.py
-rw-rw-r-- 1 indico indico   928 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20181025_1710_868c04697dd7_remove_reservation_equipment_association.py
-rw-rw-r-- 1 indico indico  1299 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20181026_1322_7e03b2262e9e_add_room_features.py
-rw-rw-r-- 1 indico indico   681 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20181123_1036_4f98f2f979c7_remove_roomattribute_is_required.py
-rw-rw-r-- 1 indico indico  2967 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20181213_1049_252c0015c9a0_add_missing_blocking_principal.py
-rw-rw-r-- 1 indico indico 11530 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20181213_1110_cbe630695800_add_room_principals_table.py
-rw-rw-r-- 1 indico indico  1972 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190117_1044_579a36843848_use_enum_for_reservation_state.py
-rw-rw-r-- 1 indico indico  1832 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190118_1213_7ec3949a21c7_use_enum_for_resv_occurrence_state.py
-rw-rw-r-- 1 indico indico  1133 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190118_1349_ff49d8d05ce7_disallow_empty_rejection_reasons.py
-rw-rw-r-- 1 indico indico  4272 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190118_1514_416f9c877300_add_reservationlink_table.py
-rw-rw-r-- 1 indico indico  1020 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190221_1423_7aabedfb5e3a_make_some_room_cols_not_nullable.py
-rw-rw-r-- 1 indico indico  1601 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190227_1523_081d4c97060a_add_end_notifications.py
-rw-rw-r-- 1 indico indico  3389 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190319_1720_3e4a0c08eae6_fix_truncated_constraint_names.py
-rw-rw-r-- 1 indico indico  2039 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190319_1728_fe73a07da0b4_add_room_notification_emails_column.py
-rw-rw-r-- 1 indico indico   905 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190331_1619_8521bce91242_remove_location_is_default.py
-rw-rw-r-- 1 indico indico   814 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190423_0920_ad0625914645_room_is_active_is_deleted.py
-rw-rw-r-- 1 indico indico  1059 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190423_1431_a83e77e11e36_add_location_is_deleted.py
-rw-rw-r-- 1 indico indico  1762 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190425_1507_7024f7f66e20_remove_assistance_vc_columns_from_rb.py
-rw-rw-r-- 1 indico indico  7434 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190517_1313_06a4ec717b84_switch_from_json_to_jsonb.py
-rw-rw-r-- 1 indico indico   752 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190809_1711_620b312814f3_migrate_indico_weeks_view_theme_name.py
-rw-rw-r-- 1 indico indico  1245 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190821_1515_eefba82b42c5_add_track_groups_table.py
-rw-rw-r-- 1 indico indico  1431 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190918_1722_1b741c9123f6_add_columns_for_program_codes.py
-rw-rw-r-- 1 indico indico   839 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190923_1438_0f20a5e4018e_add_new_abstract_state.py
-rw-rw-r-- 1 indico indico   923 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20190924_1509_f6fba869a27c_add_uuid_column_to_abstracts.py
-rw-rw-r-- 1 indico indico  1126 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20191021_1350_a2472148d2c5_add_signature_token_column_to_user.py
-rw-rw-r-- 1 indico indico  1301 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20191107_1816_bb522e9f9066_add_files_table.py
-rw-rw-r-- 1 indico indico  1412 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20191108_1402_39a25a873063_add_editing_file_types_table.py
-rw-rw-r-- 1 indico indico  5709 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20191108_1713_4e459d27adab_add_tables_for_editing_revisions.py
-rw-rw-r-- 1 indico indico 11173 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20191111_1820_2496c4adc7e9_add_track_principal.py
-rw-rw-r-- 1 indico indico  1553 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200120_1055_e01c48de5a5e_allow_more_digits_in_prices.py
-rw-rw-r-- 1 indico indico   542 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200120_1340_6a185fdcd4ee_add_filename_template_column.py
-rw-rw-r-- 1 indico indico  1486 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200204_1201_4d263fa78830_add_category_roles_table.py
-rw-rw-r-- 1 indico indico 42695 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200207_1615_b3ce69ab24d9_add_category_roles_to_acls.py
-rw-rw-r-- 1 indico indico   885 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200319_1342_18a1088f1ea8_use_ondelete_cascade_for_comments.py
-rw-rw-r-- 1 indico indico   833 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200319_1605_56a26a721717_add_slides_as_editable_type.py
-rw-rw-r-- 1 indico indico  1436 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200324_0926_266d78b1c5db_add_table_for_event_labels.py
-rw-rw-r-- 1 indico indico  2969 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200324_1004_a3295d628e3b_migrate_event_labels_from_settings.py
-rw-rw-r-- 1 indico indico  1429 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200327_1501_6444c893a21f_associate_file_types_with_editable_types.py
-rw-rw-r-- 1 indico indico   845 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200331_1251_3c5462aef0b7_review_conditions_editable_types.py
-rw-rw-r-- 1 indico indico  1624 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200401_1738_02bf20df06b3_add_table_for_review_conditions.py
-rw-rw-r-- 1 indico indico  2739 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200402_1113_933665578547_migrate_review_conditions_from_settings.py
-rw-rw-r-- 1 indico indico   598 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200409_1711_7f56252c73ab_add_map_url_to_events_table.py
-rw-rw-r-- 1 indico indico  1002 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200428_1807_532f0ea25bb1_add_user_profile_picture.py
-rw-rw-r-- 1 indico indico   715 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200615_2142_c0fc1e46888b_disallow_editing_permissions_for_groups.py
-rw-rw-r-- 1 indico indico 35542 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200619_1526_b6dd0a4ed40d_add_registration_form_to_event_acls.py
-rw-rw-r-- 1 indico indico   751 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200623_1718_05f227f4b938_add_metadata_to_event_logs.py
-rw-rw-r-- 1 indico indico  6234 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200729_1503_4f0b4dd412b5_remove_email_principals_from_tracks.py
-rw-rw-r-- 1 indico indico   677 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200729_1842_d89abffb0f63_add_menu_entries_registered_only.py
-rw-rw-r-- 1 indico indico   641 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200729_1848_12fbf6af2367_add_custom_boa_file_to_event.py
-rw-rw-r-- 1 indico indico   801 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200804_1308_497c61b68050_fix_session_friendly_id_index.py
-rw-rw-r-- 1 indico indico  2053 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200805_1423_c997dc927fbc_add_default_badge_to_categories.py
-rw-rw-r-- 1 indico indico  1260 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20200904_1543_f37d509e221c_add_user_profile_picture_source_column.py
-rw-rw-r-- 1 indico indico  4710 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20201103_1431_8d614ef75968_allow_mx_user_title.py
-rw-rw-r-- 1 indico indico  1024 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20201209_2010_e4fb983dc64c_add_until_approved_regform_modification_mode.py
-rw-rw-r-- 1 indico indico   712 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210129_2232_e787389ca868_add_rejection_reason.py
-rw-rw-r-- 1 indico indico   644 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210211_1613_26985db8ed12_add_attach_ical_to_reminders.py
-rw-rw-r-- 1 indico indico   675 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210215_1052_f26c201c8254_add_attach_ical_to_registrationform.py
-rw-rw-r-- 1 indico indico   531 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210219_1428_3782de7970da_rename_oauth_default_scopes.py
-rw-rw-r-- 1 indico indico  3691 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210219_1555_da06d8f50342_separate_authorized_scopes_from_tokens.py
-rw-rw-r-- 1 indico indico   764 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210222_1754_c36abe1c23c7_make_oauth_pkce_flow_configurable.py
-rw-rw-r-- 1 indico indico  2706 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210222_1914_d354278c6d95_store_tokens_as_hashes.py
-rw-rw-r-- 1 indico indico  1545 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210224_1805_ecc7088914e7_use_cascading_fks_for_oauth.py
-rw-rw-r-- 1 indico indico  1285 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210224_1808_26806768cd3f_remove_flower_oauth_app.py
-rw-rw-r-- 1 indico indico   494 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210507_1812_d89585afaf2e_add_index_on_user_merged_into_id.py
-rw-rw-r-- 1 indico indico   778 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210524_1447_cf9e1b4e2f5f_restrict_event_creation_cat_subcats.py
-rw-rw-r-- 1 indico indico  2579 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210527_1314_178d297eae7e_disallow_seconds_in_durations.py
-rw-rw-r-- 1 indico indico  1729 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210607_1548_735dc4e8d2f3_update_merged_users_in_registrations.py
-rw-rw-r-- 1 indico indico   529 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210615_1612_fda76e047e87_make_sure_contributions_have_titles.py
-rw-rw-r-- 1 indico indico  2368 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210615_1627_79e770865675_add_more_fts_indexes.py
-rw-rw-r-- 1 indico indico   568 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210622_1655_90384b9b3d22_make_room_division_non_nullable.py
-rw-rw-r-- 1 indico indico   908 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210630_1104_356b8985ae7c_add_survey_anonymous_submissions_table.py
-rw-rw-r-- 1 indico indico  1375 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210630_1205_1f6738730753_add_personal_access_tokens.py
-rw-rw-r-- 1 indico indico   469 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210630_1206_1b7e98f581bc_make_token_scopes_not_nullable.py
-rw-rw-r-- 1 indico indico  1247 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210630_1349_5cbb0eb12eb3_add_last_used_ip_and_use_count_to_tokens.py
-rw-rw-r-- 1 indico indico   685 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210705_1337_420195768776_add_reminder_send_to_speakers_column.py
-rw-rw-r-- 1 indico indico   705 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210705_1726_cd3fef2095b4_add_is_flat_view_enabled_setting_for_categories.py
-rw-rw-r-- 1 indico indico   990 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210707_1635_1cec32e42f65_add_reviewed_dt_to_paper_revisions.py
-rw-rw-r-- 1 indico indico  1774 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210802_1514_4b097412a8d9_add_category_logs.py
-rw-rw-r-- 1 indico indico  3020 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210804_1211_9d00917b2fa8_add_event_category_request.py
-rw-rw-r-- 1 indico indico  1074 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210813_1633_dc53d6e8c576_make_event_category_nullable.py
-rw-rw-r-- 1 indico indico  1662 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20210927_1027_b36825c7869e_add_registration_tags.py
-rw-rw-r-- 1 indico indico   626 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20211116_1457_8993132179d3_ensure_single_choice_fields_have_item_type.py
-rw-rw-r-- 1 indico indico  2627 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20211119_1539_84874a17eaf3_cleanup_registration_fields_is_billable.py
-rw-rw-r-- 1 indico indico  2123 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20211121_1403_3dafee32ba7d_remove_is_billable_from_registration_fields.py
-rw-rw-r-- 1 indico indico  3118 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20211207_1106_82fb6c6ac6db_add_publish_registrations_with_consent.py
-rw-rw-r-- 1 indico indico  1353 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20220225_1335_ef7a8b2e6737_add_access_column_to_menu_entries.py
-rw-rw-r-- 1 indico indico  1365 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20220315_1520_5123f24eb41e_add_form_field_retention_period.py
-rw-rw-r-- 1 indico indico   739 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20220318_1614_57696d76f9b0_add_registration_visibility_override.py
-rw-rw-r-- 1 indico indico   634 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20220329_1207_a61ce4bd7549_add_publish_registrations_duration_to_regforms.py
-rw-rw-r-- 1 indico indico   554 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20220406_1431_88eb87ee0d3e_add_registration_retention_period.py
-rw-rw-r-- 1 indico indico   694 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20220407_1306_a707753d16e2_add_registration_is_purged.py
-rw-rw-r-- 1 indico indico   814 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20220421_1316_812aa90a3660_add_favorite_events_table.py
-rw-rw-r-- 1 indico indico  1564 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20220513_1333_c39db219f85a_add_predefined_affiliations.py
-rw-rw-r-- 1 indico indico  3354 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20220513_1337_1950e5d12ab5_add_predefined_affiliations_to_persons.py
-rw-rw-r-- 1 indico indico  3011 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20220531_1439_0c4bb2973536_move_affiliation_into_users_table.py
-rw-rw-r-- 1 indico indico  1122 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20220718_1534_33c3ab67d729_add_registration_created_by_manager_.py
-rw-rw-r-- 1 indico indico   683 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20220726_1007_b60f5c45acf7_add_option_to_enable_captcha.py
-rw-rw-r-- 1 indico indico   655 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20220815_1631_b45847c0e62f_add_event_series_title_pattern.py
-rw-rw-r-- 1 indico indico  1221 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20230131_1254_7551bd141960_fix_purged_accommodation_fields.py
-rw-rw-r-- 1 indico indico  2280 Jul  4 07:05 /opt/indico/.venv/lib/python3.9/site-packages/indico/migrations/versions/20230209_1214_5d05eda06776_add_undone_state_to_editing_revisions.py

ThiefMaster · July 5, 2023, 8:06am

OK it’s VERY strange that running the DB upgrade doesn’t execute those newer revisions.

Run psql and run the query select * from alembic_version; in there and show me the output

ghazi1 · July 5, 2023, 8:07am

ghazi1 · July 5, 2023, 8:26am

yes, i also think this is weird, i have been looking for a solution to solve this problem, but i am stuck

ThiefMaster · July 5, 2023, 8:59am

so I don’t know what you did there, but for some reason you are on two revisions at the same time… unfortunately that’s a huge mess since we need to figure out what migrations you have currently applied. something that’d be easy to do when having DB access and knowing what to look for, but not something I feel like explaining in-depth tbh if i can avoid it…

from which version did you upgrade? maybe I can come up with a workaround…

also, did you ever customize something in your indico package, or did you only use our official releases?

ghazi1 · July 6, 2023, 12:32am

something that’d be easy to do when having DB access and knowing what to look for, but not something I feel like explaining in-depth tbh if i can avoid it…
Answer : I haven’t done anything recently, on Indico can I find out the details of what I’ve done? If you wish to do a deeper check, do you need our indico database?

from which version did you upgrade? maybe I can come up with a workaround…
Answer : I upgraded from version 3.24 to version 3.25 , The error appeared before I decided to upgrade, with the same error log. unfortunately I don’t know why the error appears, it suddenly appears

also, did you ever customize something in your indico package, or did you only use our official releases?
Answer : I only use source code from Indico official, I don’t do any customization outside of Indico GitHub official.

Thanks for the very fast response, you guys are awesome

ThiefMaster · July 6, 2023, 7:40am

If you wish to do a deeper check, do you need our indico database?

I don’t need/want your actual data, but if you can get me a pg_dump of your database with --schema-only then yes, that would be very helpful. That way I do not get any of your data, but the database structure in order to check which migrations have (not) been applied yet. The full command is pg_dump --schema-only indico > /tmp/indico-structure.sql; send me the /tmp/indico-structure.sql file afterwards (you can upload it to a post in here, as long as you use --schema-only it contains no sensitive data).

I upgraded from version 3.24 to version 3.25

3.2.4 to 3.2.5? That’s strange. There were no database changes between those versions so I would not expect such an issue there.

Do you still have he full output from when you ran any indico db commands initially after the upgrade?

I only use source code from Indico official, I don’t do any customization outside of Indico GitHub official.

Just to clarify: You only used pip install indico etc, but did NOT build your own indico packages from source?

ghazi1 · July 6, 2023, 8:18am

Here the database structure : indico-structure.sql - Google Drive
can you explain in more detail what should i do to get that output?
Yes… i only use tutorial from : https://docs.getindico.io

Thankyou for your help

ThiefMaster · July 6, 2023, 9:50am

If you no longer have it in your terminal history, you can’t get it anymore. Shell output isn’t saved anywhere.

ghazi1 · July 7, 2023, 12:26am

Sorry Adrian,

I just got new information from other people that handle our system,

Apologies in advance, I’m new here, guys. It seems that our Indico was previously upgraded from version 2.x to 3.x, but it appears that the upgrade wasn’t done correctly or completely, resulting in some issues.

Furthermore, it appears that we don’t have a backup of the database. In this situation, what steps can I take to address these problems? Is it still possible to rectify the situation?

ThiefMaster · July 7, 2023, 12:56pm

You’re lucky, it’s very easy to recover your database structure:

First of all, run these commands in a psql shell:

CREATE INDEX ix_emails_email_unaccent ON users.emails USING gin (indico.indico_unaccent(lower((email)::text)) gin_trgm_ops);
CREATE INDEX ix_users_address_unaccent ON users.users USING gin (indico.indico_unaccent(lower(address)) gin_trgm_ops);
CREATE INDEX ix_users_first_name_unaccent ON users.users USING gin (indico.indico_unaccent(lower((first_name)::text)) gin_trgm_ops);
CREATE INDEX ix_users_last_name_unaccent ON users.users USING gin (indico.indico_unaccent(lower((last_name)::text)) gin_trgm_ops);
CREATE INDEX ix_users_phone_unaccent ON users.users USING gin (indico.indico_unaccent(lower((phone)::text)) gin_trgm_ops);
DELETE FROM alembic_version WHERE version_num = 'e787389ca868';

Afterwards, exit the psql shell again and run indico db upgrade in the normal shell.

You’re now on the proper database structure that matches your currently installed version and everything should work fine!