Docker upgrade to v4 fails

Trying to upgrade from 3.0.7 to v4, we have done the upgrade successfully to 3.3.8 but are having an issue completing the upgrade to v4.

docker-compose logs shows these errors after starting the upgrade:
Is there something we’ve missed along the way?

xibo-docker-400-cms-db-1          | 2023-10-05T12:27:16.994421Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 1
xibo-docker-400-cms-db-1          | 2023-10-05T12:27:17.002565Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
xibo-docker-400-cms-db-1          | 2023-10-05T12:27:17.002607Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
xibo-docker-400-cms-db-1          | 2023-10-05T12:27:17.043592Z 1 [ERROR] [MY-012209] [InnoDB] Multiple files found for the same tablespace ID:
xibo-docker-400-cms-db-1          | 2023-10-05T12:27:17.043670Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 2 = ['mysql/innodb_index_stats.ibd', 'mysql/plugin.ibd'] 
xibo-docker-400-cms-db-1          | 2023-10-05T12:27:17.043686Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 3 = ['mysql/servers.ibd', 'mysql/slave_relay_log_info.ibd'] 
xibo-docker-400-cms-db-1          | 2023-10-05T12:27:17.043691Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 4 = ['mysql/help_topic.ibd', 'mysql/slave_master_info.ibd'] 
xibo-docker-400-cms-db-1          | 2023-10-05T12:27:17.043695Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 5 = ['mysql/help_category.ibd', 'mysql/slave_worker_info.ibd'] 
xibo-docker-400-cms-db-1          | 2023-10-05T12:27:17.043700Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 6 = ['cms/phinxlog.ibd', 'mysql/help_relation.ibd'] 
xibo-docker-400-cms-db-1          | 2023-10-05T12:27:17.043704Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 7 = ['cms/session.ibd', 'mysql/help_keyword.ibd'] 
xibo-docker-400-cms-db-1          | 2023-10-05T12:27:17.043709Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 9 = ['cms/usertype.ibd', 'mysql/time_zone.ibd'] 
xibo-docker-400-cms-db-1          | 2023-10-05T12:27:17.043733Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 11 = ['cms/useroption.ibd', 'mysql/time_zone_transition_type.ibd'] 
xibo-docker-400-cms-db-1          | 2023-10-05T12:27:17.043738Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 21 = ['cms/lkmediadisplaygroup.ibd', 'sys/sys_config.ibd'] 
xibo-docker-400-cms-db-1          | 2023-10-05T12:27:17.043755Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Failed, retry may succeed.
xibo-docker-400-cms-db-1          | 2023-10-05T12:27:17.043772Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
xibo-docker-400-cms-db-1          | 2023-10-05T12:27:17.044001Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
xibo-docker-400-cms-db-1          | 2023-10-05T12:27:17.044033Z 0 [ERROR] [MY-010119] [Server] Aborting

Ok, so part of the original upgrade process was going from version 3.0.7, to 3.1, then 3.3, then to 4.

After cleanup of some duplicate tags, and tidying the library of 3.0.7, I was able to upgrade straight from 3.0.7 to 3.3.8, then to 4.0.4 without issue.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.