Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-2008

LP #1722368: mariadb10.1 to percona 5.7 upgrade failed

Details

    • Bug
    • Status: Done
    • Low
    • Resolution: Invalid
    • None
    • None
    • None

    Description

      **Reported in Launchpad by Proskurin Kirill last update 13-10-2017 05:46:52

      Hello,

      Scenario:
      mariadb-10.1.14 upgrade toPercona-XtraDB-Cluster-5.7.19-rel17-29.22.1
      Both deployed via tars, not packages. OS: Centos 7.3 x64

      1) Shutdown Maria
      2) Deploy Percona
      3) Start Percona
      4) Run mysql_ugrade
      5) Get the following error

      "mysql_upgrade: (non fatal) [ERROR] 1728: Cannot load from mysql.proc. The table is probably corrupted
      mysql_upgrade: (non fatal) [ERROR] 1545: Failed to open mysql.event"
      6) Restart Percona
      7) Try to do some user manipulations(in my case - remove test user via ansible) and get the
      "Column count of mysql.user is wrong. Expected 45, found 48."

      Additionally, "sys" database can't be created via mysql_upgrade, with the following error:
      "Upgrading the sys schema.
      mysql_upgrade: [ERROR] 1136: Column count doesn't match value count at row 1"

      Probably because the same problem with mysql.user

      Related: https://www.percona.com/forums/questions-discussions/mysql-and-percona-server/48583-column-count-of-mysql-user-is-wrong-expected-45-found-48

      Attachments

        Activity

          People

            lalit.choudhary Lalit Choudhary
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist