Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14573

Upgrade from previous versions is broken for procedures

    XMLWordPrintable

    Details

      Description

      • 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
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              cvicentiu Vicențiu Ciorbaru
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: