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

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.10, 10.0, 10.1
    • Fix Version/s: 10.1.14
    • Component/s: Replication
    • Labels:
      None
    • Environment:
      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. master.info.example
          0.1 kB
        3. master-info.txt
          4 kB
        4. MDEV-9383-100grama.sample
          0.5 kB
        5. MDEV-9383-ck.sample
          0.7 kB
        6. MDEV-9383-miss60.sample
          0.9 kB
        7. mysqld.cnf
          1 kB
        8. relay.ls.txt.gz
          34 kB

          Activity

            People

            Assignee:
            knielsen Kristian Nielsen
            Reporter:
            ip1981 Igor Pashev
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: