[MDEV-30241] mysql_upgrade to 10.9.4 fails Created: 2022-12-16 Updated: 2022-12-26 Resolved: 2022-12-26 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Upgrades |
| Affects Version/s: | 10.9.4 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Marc | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Description |
|
mysql_upgrade Repairing tables |
| Comments |
| Comment by Daniel Black [ 2022-12-16 ] |
|
mokraemer what was the previous version running? Was mariadb-upgrade/mysql_upgrade run on that version? What version of MariaDB/MySQL was the original datadir installation from? |
| Comment by Marko Mäkelä [ 2022-12-16 ] |
|
It is a long shot, but if the old version was MariaDB 10.4 or MySQL 5.7 or earlier, then this report might be a duplicate of |
| Comment by Marc [ 2022-12-16 ] |
|
Yes, it was 10.5.18; so it is a duplicate - thanks. So i'm waiting for 10.9.5 to get this fixed? |
| Comment by Marko Mäkelä [ 2022-12-16 ] |
|
My next guess would be that the 10.5.18 server had not been shut down, or you are trying to start up 10.9.4 on a backup of the 10.5.18 server, on which mariadb-backup --prepare had not been run using the 10.5 (or 10.6 or 10.7) version of the backup tool. |
| Comment by Marc [ 2022-12-16 ] |
|
I think sth. with innodb_index_stats and innodb_table_stats was corrupted. Just dropped both tables and rerun mysql_upgrade which now worked as expected. Sorry, I think you can close this - thanks for your help. |