Focalboard upgrade 7.7.0 to 7.9.0 error - service doesn't start anymore

[ToniooinoT79]

Describe the bug

After an upgrade of Focalboard from 7.7.0 to 7.9.0 the app doesn't run anymore with an error in service log.

Thanks a lot for your help

Context

• Hardware: * DELL 3050 i5 quadcore 8GB Ram 500G HD.*
• YunoHost version: 11.1.15
• I have access to my server: Through SSH | through the webadmin |
• Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: no
• Using, or trying to install package version/branch: 7.9.0~ynh1
• If upgrading, current package version: can be found in the admin, or with yunohost app info $app_id
  7.7.0~ynh1

Steps to reproduce

• If you performed a command from the CLI, the command itself is enough.

  sudo yunohost app upgrade focalboard

Expected behavior

No error during installation/upgrade of the app from 7.7.0 to 7.9.0 but focal board service doesn't start anymore. see log :

Logs

LOGFILE: journalctl
-- Journal begins at Tue 2023-02-21 15:32:29 CET, ends at Tue 2023-03-14 09:31:14 CET. --
mars 14 09:31:14 focalboard-server[2364565]: debug [2023-03-14 09:31:14.799 +01:00] == Ensuring migrations applied up to version ==================== caller="sqlstore/migrate.go:273" version=20 current_version=35
mars 14 09:31:14 focalboard-server[2364565]: debug [2023-03-14 09:31:14.799 +01:00] -- There is no need of applying any migration -------------------- caller="sqlstore/migrate.go:281"
mars 14 09:31:14 focalboard-server[2364565]: debug [2023-03-14 09:31:14.800 +01:00] == Applying all remaining migrations ==================== caller="sqlstore/migrate.go:251" current_version=35
mars 14 09:31:14 focalboard-server[2364565]: 2023/03/14 09:31:14 == category_board_add_unique_constraint: migrating ===============================================
mars 14 09:31:14 focalboard-server[2364565]: debug [2023-03-14 09:31:14.810 +01:00] Closing migration engine caller="sqlstore/migrate.go:208"
mars 14 09:31:14 focalboard-server[2364565]: debug [2023-03-14 09:31:14.842 +01:00] Closing migrations connection caller="sqlstore/migrate.go:121"
mars 14 09:31:14 focalboard-server[2364565]: error [2023-03-14 09:31:14.843 +01:00] Table creation / migration failed caller="sqlstore/sqlstore.go:75" error="driver: postgres, message: failed to execute migration, command: executing_query, originalError: pq: n'a pas pu créer l'index unique « unique_user_category_board », query:
mars 14 09:31:14 focalboard-server[2364565]: DO
mars 14 09:31:14 focalboard-server[2364565]: $$
mars 14 09:31:14 focalboard-server[2364565]: BEGIN
mars 14 09:31:14 focalboard-server[2364565]: IF NOT EXISTS (
mars 14 09:31:14 focalboard-server[2364565]: SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
mars 14 09:31:14 focalboard-server[2364565]: WHERE constraint_schema = 'public'
mars 14 09:31:14 focalboard-server[2364565]: AND constraint_name = 'unique_user_category_board'
mars 14 09:31:14 focalboard-server[2364565]: AND constraint_type = 'UNIQUE'
mars 14 09:31:14 focalboard-server[2364565]: AND table_name = 'category_boards'
mars 14 09:31:14 focalboard-server[2364565]: ) THEN
mars 14 09:31:14 focalboard-server[2364565]: ALTER TABLE public.category_boards ADD CONSTRAINT unique_user_category_board UNIQUE(user_id, board_id);
mars 14 09:31:14 focalboard-server[2364565]: END IF;
mars 14 09:31:14 focalboard-server[2364565]: END;
mars 14 09:31:14 focalboard-server[2364565]: $$
mars 14 09:31:14 focalboard-server[2364565]: LANGUAGE plpgsql;
mars 14 09:31:14 focalboard-server[2364565]:
mars 14 09:31:14 focalboard-server[2364565]: "
mars 14 09:31:14 focalboard-server[2364565]: fatal [2023-03-14 09:31:14.843 +01:00] server.NewStore ERROR caller="main/main.go:136" error="driver: postgres, message: failed to execute migration, command: executing_query, originalError: pq: n'a pas pu créer l'index unique « unique_user_category_board », query:
mars 14 09:31:14 focalboard-server[2364565]: DO
mars 14 09:31:14 focalboard-server[2364565]: $$
mars 14 09:31:14 focalboard-server[2364565]: BEGIN
mars 14 09:31:14 focalboard-server[2364565]: IF NOT EXISTS (
mars 14 09:31:14 focalboard-server[2364565]: SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
mars 14 09:31:14 focalboard-server[2364565]: WHERE constraint_schema = 'public'
mars 14 09:31:14 focalboard-server[2364565]: AND constraint_name = 'unique_user_category_board'
mars 14 09:31:14 focalboard-server[2364565]: AND constraint_type = 'UNIQUE'
mars 14 09:31:14 focalboard-server[2364565]: AND table_name = 'category_boards'
mars 14 09:31:14 focalboard-server[2364565]: ) THEN
mars 14 09:31:14 focalboard-server[2364565]: ALTER TABLE public.category_boards ADD CONSTRAINT unique_user_category_board UNIQUE(user_id, board_id);
mars 14 09:31:14 focalboard-server[2364565]: END IF;
mars 14 09:31:14 focalboard-server[2364565]: END;
mars 14 09:31:14 focalboard-server[2364565]: $$
mars 14 09:31:14 focalboard-server[2364565]: LANGUAGE plpgsql;
mars 14 09:31:14 focalboard-server[2364565]:
mars 14 09:31:14 focalboard-server[2364565]: "
mars 14 09:31:14 focalboard-server[2364565]: main.main
mars 14 09:31:14 focalboard-server[2364565]: /home/runner/work/focalboard/focalboard/focalboard/server/main/main.go:136
mars 14 09:31:14 focalboard-server[2364565]: runtime.main
mars 14 09:31:14 focalboard-server[2364565]: /opt/hostedtoolcache/go/1.19.5/x64/src/runtime/proc.go:250
mars 14 09:31:14 focalboard-server[2364565]: runtime.goexit
mars 14 09:31:14 focalboard-server[2364565]: /opt/hostedtoolcache/go/1.19.5/x64/src/runtime/asm_amd64.s:1594
mars 14 09:31:14 systemd[1]: focalboard.service: Main process exited, code=exited, status=1/FAILURE
mars 14 09:31:14 systemd[1]: focalboard.service: Failed with result 'exit-code'.

[ericgaspar]

This seems to be an upstream bug: mattermost-community/focalboard#4614
Should be fixed with the pre-release 7.8.1 available in testing.