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

mysql_upgrade crashes server process

    XMLWordPrintable

Details

    Description

      running mysql_upgrade shows:

      mysql_upgrade --verbose
      Looking for 'mysql' as: mysql
      Looking for 'mysqlcheck' as: mysqlcheck
      Phase 1/7: Checking and upgrading mysql database
      Processing databases
      mysql
      mysql.column_stats                                 OK
      mysql.columns_priv                                 OK
      mysql.db                                           OK
      mysql.event                                        OK
      mysql.func                                         OK
      mysql.global_priv                                  OK
      mysql.gtid_slave_pos                               OK
      mysql.help_category                                OK
      mysql.help_keyword                                 OK
      mysql.help_relation                                OK
      mysql.help_topic                                   OK
      mysql.index_stats                                  OK
      mysql.innodb_index_stats                           OK
      mysql.innodb_table_stats                           OK
      mysql.plugin                                       OK
      mysql.proc                                         OK
      mysql.procs_priv                                   OK
      mysql.proxies_priv                                 OK
      mysql.roles_mapping                                OK
      mysql.servers                                      OK
      mysql.table_stats                                  OK
      mysql.tables_priv                                  OK
      mysql.time_zone                                    OK
      mysql.time_zone_leap_second                        OK
      mysql.time_zone_name                               OK
      mysql.time_zone_transition                         OK
      mysql.time_zone_transition_type                    OK
      mysql.transaction_registry                         OK
      Phase 2/7: Installing used storage engines... Skipped
      Phase 3/7: Fixing views
      Processing databases
      information_schema
      mysql
      mysqlcheck: Got error: 2013: Lost connection to server during query when executing 'REPAIR NO_WRITE_TO_BINLOG VIEW ... '
      FATAL ERROR: Upgrade failed
      
      

      and in the server log you can see:
      Dez 12 11:52:03 localhost mysqld[66966]: 2021-12-12 11:52:03 0 [Note] /usr/sbin/mysqld: ready for connections.
      Dez 12 11:52:03 localhost mysqld[66966]: 2021-12-12 11:52:03 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
      Dez 12 11:52:03 localhost mysqld[66966]: 211212 11:52:03 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.2021-12-12 11:52:03 0 [ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type varchar(, found type char(141).
      Dez 12 11:52:03 localhost mysqld[66966]: 211212 11:52:03 server_audit: MariaDB Audit Plugin version 1.4.13 STARTED

      It looks like some definitions do not match

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              mokraemer Marc
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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