Not the answer you need?
Register and ask your own question!

5.6.17-66.0 performance schema issues

WheresWardyWheresWardy ContributorInactive User Role Beginner
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:
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:
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:
[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.

Comments

  • jriverajrivera Percona Support Engineer Percona Staff Role
    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
  • jriverajrivera Percona Support Engineer Percona Staff Role
    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.
  • WheresWardyWheresWardy Contributor Inactive User Role Beginner
    I can confirm that that solves the issue.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.