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

Server fails to read master.info after upgrade 10.0 -> 10.1

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.10, 10.0(EOL), 10.1(EOL)
    • 10.1.14
    • Replication
    • None
    • Linux

    Description

      I tried to upgrade the server 10.0.22 -> 10.1.10.
      Old version was shutdown, but new failed to start:

      2016-01-08 22:25:00 7f8017479700 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
      2016-01-08 22:25:00 7f8017479700 InnoDB: Error: Fetch of persistent statistics requested for table "mysql"."gtid_slave_pos" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
      2016-01-08 22:25:01 140188123334592 [Note] Server socket created on IP: '::'.
      2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize master info using_gtid
      2016-01-08 22:25:01 140188123334592 [ERROR] Error reading master configuration
      2016-01-08 22:25:01 140188123334592 [ERROR] Initialized Master_info from 'master-bob@002dhk.info' failed
      2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize master info using_gtid
      2016-01-08 22:25:01 140188123334592 [ERROR] Error reading master configuration
      2016-01-08 22:25:01 140188123334592 [ERROR] Initialized Master_info from 'master-bob@002dth.info' failed
      2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize master info using_gtid
      2016-01-08 22:25:01 140188123334592 [ERROR] Error reading master configuration
      2016-01-08 22:25:01 140188123334592 [ERROR] Initialized Master_info from 'master-bob@002dsg.info' failed
      2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize master info using_gtid
      2016-01-08 22:25:01 140188123334592 [ERROR] Error reading master configuration
      2016-01-08 22:25:01 140188123334592 [ERROR] Initialized Master_info from 'master-delivery.info' failed
      2016-01-08 22:25:01 140188123334592 [Warning] Reading of some Master_info entries failed
      2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize multi master structures
      2016-01-08 22:25:01 140188123334592 [ERROR] Aborting
      

      I guess I can't use mysql_upgrade when the server is not running.

      Attachments

        1. log.txt
          23 kB
        2. mysqld.cnf
          1 kB
        3. relay.ls.txt.gz
          34 kB
        4. master-info.txt
          4 kB
        5. master.info.example
          0.1 kB
        6. MDEV-9383-100grama.sample
          0.5 kB
        7. MDEV-9383-ck.sample
          0.7 kB
        8. MDEV-9383-miss60.sample
          0.9 kB

        Activity

          People

            knielsen Kristian Nielsen
            ip1981 Igor Pashev
            Votes:
            1 Vote for this issue
            Watchers:
            5 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.