Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-381

LP #1329772: Errors on performance_schema tables after upgrade from 5.6.16-64.1 to 5.6.17-66.0

    Details

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

      Description

      **Reported in Launchpad by Jericho Rivera last update 18-08-2014 16:06:45

      From Percona Forums:
      http://www.percona.com/forums/questions-discussions/mysql-and-percona-server/percona-server-5-6/16913-5-6-17-66-0-performance-schema-issues

      After upgrading Percona Server 5.6.16-64.1 to latest Percona Server 5.6.17-66.0 errors on the log file show for every P_S table.
      I was able to repeat on a clean CentOS 6.5 installation.

      How to repeat:

      • Install PS 5.6.16-64.1 from binaries
      • Enable performance schema on my.cnf
        [mysqld]
        performance_schema=on
      • Install Percona yum repo, then run yum update

      See attached error log.

      mysql> select @@version;
      -------------

      @@version

      -------------

      5.6.17-66.0

      -------------
      1 row in set (0.00 sec)

      mysql> show global variables like 'performance_schema';
      -------------------------+

      Variable_name Value

      -------------------------+

      performance_schema ON

      -------------------------+
      1 row in set (0.00 sec)

      mysql> select * from performance_schema.accounts limit 1;
      ERROR 1682 (HY000): Native table 'performance_schema'.'accounts' has the wrong structure
      mysql>

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: