holland-coredev team mailing list archive
-
holland-coredev team
-
Mailing list archive
-
Message #00090
[Bug 732825] [NEW] Errors with performance schema in MySQL 5.5
Public bug reported:
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
** Affects: holland-backup
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Holland
Discuss, which is subscribed to holland-backup.
https://bugs.launchpad.net/bugs/732825
Title:
Errors with performance schema in MySQL 5.5
Status in Holland Backup Framework:
New
Bug description:
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
Follow ups
References