Server upgrade from '50700' to '80028' interrupted, stuck at sdi_delete failed

MySQL & MariaDB
1

Unfortunately at some point upgrade from 5.7 to 8 was interrupted (docker, mysql percona:8). I’m now stuck at:

snmysql_1     | 2022-06-22T23:10:00.944019Z 4 [System] [MY-013381] [Server] Server upgrade from '50700' to '80028' started.
snmysql_1     | 2022-06-22T23:10:02.668010Z 4 [Warning] [MY-011836] [InnoDB] sdi_delete failed: Record Doesn't exist: tablespace_id: 20 Key: 1 1833
snmysql_1     | 2022-06-22T23:10:02.668202Z 4 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement 'ALTER TABLE slave_master_info STATS_PERSISTENT=0; ' failed with error code = 3958, error message = 'Failed to delete sdi for mysql.slave_master_info in mysql/slave_master_info due to missing record.'.
snmysql_1     | 2022-06-22T23:10:02.669849Z 0 [ERROR] [MY-013380] [Server] Failed to upgrade server.
snmysql_1     | 2022-06-22T23:10:02.670308Z 0 [ERROR] [MY-010119] [Server] Aborting

Is there anything I can do to skip slave_master_info?

2

I would try dropping the table and re-creating it, then try to do the upgrade again.

1 Like