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

MariaDB Crash (Signal 11) when running mysql_upgrade

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.6.5
    • N/A
    • SSL
    • None

    Description

      I have just upgraded from 10.5.12 to 10.6.5 (using the Gentoo ebuild) and upon upgrade am attempting to run mysql_upgrade. However it repeatably and reliably crashes out with a Signal 11 message. The output looks like this:

      thunderstorm # mysql_upgrade 
      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
      mysqlcheck: Got error: 2013: Lost connection to server during query when executing 'REPAIR NO_WRITE_TO_BINLOG VIEW ... '
      FATAL ERROR: Upgrade failed
      thunderstorm #
      

      I can then restart mysqld just fine and it seems to work however the event scheduler is disabled from that point on.

      The error log is attached which had lots more information in it.

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              reuben.farrelly Reuben Farrelly
              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.