[MDEV-31148] myqsl_upgrade fails: mysql.innodb_index_stats not present Created: 2023-04-28  Updated: 2023-04-28  Resolved: 2023-04-28

Status: Closed
Project: MariaDB Server
Component/s: Upgrades
Affects Version/s: 10.11.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Marc Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-21651 mysql_upgrade fails without providing... Confirmed

 Description   

[...}
sys.x$waits_global_by_latency OK
Phase 4/7: Running 'mysql_fix_privilege_tables'
ERROR 1932 (42S02) at line 482: Table 'mysql.innodb_index_stats' doesn't exist in engine
FATAL ERROR: Upgrade failed

 Comments   
Comment by Marc [ 2023-04-28 ]

maybe it would be a good idea, not to totally fail the update script, if some table is missing, if it is not really needed (in my case innodb is not used), but other update scripts fail.

Or at least issue a help, how to solve such an issue.

removing the file in mysql-dir solved the problem.

Comment by Marc [ 2023-04-28 ]

It was 10.5.19 - but as you corrected the title, it would just be helpful to have some advice, or skip the failed table and continue with other updates, if possible.

Comment by Alice Sherepa [ 2023-04-28 ]

Thank you! I will close this bug then, let's track it in MDEV-21651

Generated at Thu Feb 08 10:21:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.