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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Invalid
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      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

        Smart Checklist

          Attachments

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: