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

mysql_upgrade crashes server process

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

            Not matching mysql.event definition isn't fatal. Could you please show the complete error log?

            serg Sergei Golubchik added a comment - Not matching mysql.event definition isn't fatal. Could you please show the complete error log?
            mokraemer Marc added a comment -

            that is all of the servers error log.

            mokraemer Marc added a comment - that is all of the servers error log.

            Normally the crash shows in the logs like, for example, in MDEV-16856

            Are you saying the server suddenly disappears with no trace in the logs whatsoever and the last line is "MariaDB Audit Plugin version 1.4.13 STARTED" ?

            How do you start mariadbd?

            serg Sergei Golubchik added a comment - Normally the crash shows in the logs like, for example, in MDEV-16856 Are you saying the server suddenly disappears with no trace in the logs whatsoever and the last line is "MariaDB Audit Plugin version 1.4.13 STARTED" ? How do you start mariadbd?
            mokraemer Marc added a comment -

            Here is the full output after server start and running mysql_upgrade
            mysql.err.log

            mokraemer Marc added a comment - Here is the full output after server start and running mysql_upgrade mysql.err.log

            Looks like MDEV-26950, do you have OpenSSL 3.0?

            serg Sergei Golubchik added a comment - Looks like MDEV-26950 , do you have OpenSSL 3.0?
            mokraemer Marc added a comment -

            Yes, I have. Did not look obvious to me this has sth to do with ssl.

            mokraemer Marc added a comment - Yes, I have. Did not look obvious to me this has sth to do with ssl.

            No problem. Same conclusion though — OpeSSL 3.0 is not supported yet. It's work in progress still, see MDEV-25785.
            Should be done in 10.8 and then backported to earlier releases.

            serg Sergei Golubchik added a comment - No problem. Same conclusion though — OpeSSL 3.0 is not supported yet. It's work in progress still, see MDEV-25785 . Should be done in 10.8 and then backported to earlier releases.

            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.