Announcement

Announcement Module
Collapse
No announcement yet.

5.6.17-66.0 performance schema issues

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 5.6.17-66.0 performance schema issues

    I've just upgraded a server from Percona Server 5.6.16-64.1 to 5.6.17-66.0 and got the following error in the log for every performance_schema table:

    Code:
    2014-06-12 08:29:14 21012 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './performance_schema/accounts.frm'
    2014-06-12 08:29:14 21012 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
    I ran mysql_upgrade to see if this would solve the issue, which again produced the following error for every performance_schema table:

    Code:
    2014-06-12 08:29:39 21012 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './performance_schema/accounts.frm'
    After which, whenever I try and read from a performance_schema table in MySQL I get the following error:

    Code:
    [localhost] (root@performance_schema) > SELECT * FROM accounts LIMIT 1;
    ERROR 1682 (HY000): Native table 'performance_schema'.'accounts' has the wrong structure
    There were no configuration changes during the upgrade, just a yum update on RHEL 6.5. Has this issue been reproduced at all? I'm not sure how to go about fixing this now, other than a downgrade to Percona Server.

  • #2
    Hi,

    Thanks for reporting this to us.
    I've reported this as a bug, you may get updates from this link https://bugs.launchpad.net/percona-server/+bug/1329772

    Comment


    • #3
      I've tried this out on a VM and it looks like you have to do the following steps:

      1) run # mysql_upgrade --upgrade-system-tables
      2) restart mysql server after mysql_upgrade is ok
      3) test with mysql> select * from performance_schema.accounts limit 1;

      Let me know if this solves it.

      Comment


      • #4
        I can confirm that that solves the issue.

        Comment

        Working...
        X