[MDEV-14573] Upgrade from previous versions is broken for procedures - Jira

XML

Word

Printable

start an old version, e.g. 10.2 (same for 10.3.2, but it's less important since we don't guarantee a working upgrade from Alphas);
create a procedure, e.g.
create procedure pr() begin end;
shut down the server properly;
start the new 10.3 server on the same datadir;

try to use the procedure

10.3 1af2d7ba2353
MariaDB [test]> call pr();
ERROR 1558 (HY000): Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100212, now running 100303. Please use mysql_upgrade to fix this error

Running mysql_upgrade does not work and does not help

...

mysql.time_zone_transition                         OK

mysql.time_zone_transition_type                    OK

mysql.user                                         OK

Phase 2/7: Installing used storage engines... Skipped

Phase 3/7: Fixing views

Phase 4/7: Running 'mysql_fix_privilege_tables'

ERROR 1805 (HY000) at line 574: Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted

ERROR 1805 (HY000) at line 576: Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted

ERROR 1805 (HY000) at line 584: Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted

ERROR 1805 (HY000) at line 586: Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted

FATAL ERROR: Upgrade failed

relates to

MDEV-21332 Error message when upgrading from 10.1 or 10.2 to 10.3

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.