Errors with performance schema in MySQL 5.5

[sriramrajan]

I know that this was fixed in 1.0.6. Backups work and so it does not fail to run.

But I do see this in /var/spool/holland/slave2/<bkup dir>/holland_lvm.log. Not sure if this a bug but might be worth changing the messages logged. In any case worth pointing it out as it might lead to other things. Let me know if you want to review the server that is showing this

Logs :-

110310 20:14:17 [Warning] /usr/libexec/mysqld: unknown option '--loose-skip-ndbcluster'
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/events_waits_current.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/events_waits_history.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/events_waits_history_long.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/setup_consumers.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/setup_instruments.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/setup_timers.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/performance_timers.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/threads.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/events_waits_summary_by_thread_by_event_name.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/events_waits_summary_by_instance.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/events_waits_summary_global_by_event_name.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/file_summary_by_event_name.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/file_summary_by_instance.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/mutex_instances.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/rwlock_instances.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/cond_instances.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
110310 20:14:17 [ERROR] /usr/libexec/mysqld: Can't find file: './performance_schema/file_instances.frm' (errno: 13)
110310 20:14:17 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure

Version Info :-

# holland --version

Holland Backup v1.0.6
Copyright (c) 2008-2010 Rackspace US, Inc.
More info available at http://hollandbackup.org

[[[[[[[]]]]]]] [[[[[[[]]]]]]]
[[[[[[[]]]]]]] [[[[[[[]]]]]]]
[[[[[[[]]]]]]] [[[[[[[]]]]]]]
[[[[[[[]]]]]]] [[[[[[[]]]]]]]

# rpm -qa |grep -i holland
holland-commvault-1.0-2.rs.el5.noarch
holland-mysqldump-1.0.6-3.el5.noarch
holland-common-1.0.6-3.el5.noarch
holland-mysqllvm-1.0.6-3.el5.noarch
holland-1.0.6-3.el5.noarch

Mysql
mysql55-server-5.5.9-1.ius.el5.x86_64

[Andrew Garner (muzazzi)]

I wasn't initially able to reproduce this with either of those plugins on my MySQL 5.5 test box. However, if I do an rm -f $datadir/performance_schema/* I was able to generate those errors in mysqldump-lvm's holland_lvm.log error log. Have you run mysql_upgrade?

[sriramrajan (sriram-rajan)]

This is on a fresh install of 5.5 and so wasn't an upgrade issue.
But your comment made me look deeper and it turned out be a permissions issue datadir/performance_schema was owned by root.

All good now. Sorry for wasting your time,