perfsonar-user - [perfsonar-user] MySQL errors
Subject: perfSONAR User Q&A and Other Discussion
List archive
- From: Luís Felipe <>
- To: "" <>
- Subject: [perfsonar-user] MySQL errors
- Date: Tue, 30 Sep 2014 17:10:51 -0300
|
Hey, everyone! The results of my latency regular tests aren't appearing. In my host this errors appear in the mysqld.log: 140926 16:30:56 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structureHow can I fix this question without break the perfSONAR-BUOY MA? Thanks. Luís Felipe |
140927 1:05:02 [Note] /usr/libexec/mysqld: Normal shutdown 140927 1:05:02 [Note] Event Scheduler: Purging the queue. 0 events 140927 1:05:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4662 user: 'pinger' 140927 1:05:04 [Warning] /usr/libexec/mysqld: Forcing close of thread 4101 user: 'perfsonar' 140927 1:05:04 InnoDB: Starting shutdown... 140927 01:05:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140927 1:05:10 [Note] libgovernor.so not found 140927 1:05:10 [Note] Plugin 'FEDERATED' is disabled. 140927 1:05:10 InnoDB: The InnoDB memory heap is disabled 140927 1:05:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140927 1:05:10 InnoDB: Compressed tables use zlib 1.2.3 140927 1:05:10 InnoDB: Using Linux native AIO 140927 1:05:10 InnoDB: Initializing buffer pool, size = 128.0M 140927 1:05:10 InnoDB: Completed initialization of buffer pool 140927 1:05:10 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140927 1:05:10 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 140927 1:05:10 InnoDB: Waiting for the background threads to start 140927 1:05:11 InnoDB: 5.5.40 started; log sequence number 9949803778 140927 1:05:11 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it 140927 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure 140927 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure 140927 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure 140927 1:05:11 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure 140927 1:05:11 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure 140927 1:05:11 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure 140927 1:05:11 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure 140927 1:05:11 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure 140927 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure 140927 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure 140927 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure 140927 1:05:11 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure 140927 1:05:11 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure 140927 1:05:11 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure 140927 1:05:11 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure 140927 1:05:11 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 140927 1:05:11 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure 140927 1:05:11 [Note] Event Scheduler: Loaded 0 events 140927 1:05:11 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.40-cll-lve' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) by Atomicorp 140928 1:05:01 [Note] /usr/libexec/mysqld: Normal shutdown 140928 1:05:01 [Note] Event Scheduler: Purging the queue. 0 events 140928 1:05:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 1274 user: 'pinger' 140928 1:05:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 1273 user: 'perfsonar' 140928 1:05:03 InnoDB: Starting shutdown... 140928 01:05:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140928 1:05:10 [Note] libgovernor.so not found 140928 1:05:10 [Note] Plugin 'FEDERATED' is disabled. 140928 1:05:10 InnoDB: The InnoDB memory heap is disabled 140928 1:05:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140928 1:05:10 InnoDB: Compressed tables use zlib 1.2.3 140928 1:05:10 InnoDB: Using Linux native AIO 140928 1:05:10 InnoDB: Initializing buffer pool, size = 128.0M 140928 1:05:10 InnoDB: Completed initialization of buffer pool 140928 1:05:10 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140928 1:05:10 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 140928 1:05:10 InnoDB: Waiting for the background threads to start 140928 1:05:11 InnoDB: 5.5.40 started; log sequence number 9984607686 140928 1:05:11 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it 140928 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure 140928 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure 140928 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure 140928 1:05:11 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure 140928 1:05:11 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure 140928 1:05:11 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure 140928 1:05:11 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure 140928 1:05:11 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure 140928 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure 140928 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure 140928 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure 140928 1:05:11 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure 140928 1:05:11 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure 140928 1:05:11 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure 140928 1:05:11 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure 140928 1:05:11 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 140928 1:05:11 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure 140928 1:05:11 [Note] Event Scheduler: Loaded 0 events 140928 1:05:11 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.40-cll-lve' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) by Atomicorp 140929 1:05:01 [Note] /usr/libexec/mysqld: Normal shutdown 140929 1:05:01 [Note] Event Scheduler: Purging the queue. 0 events 140929 1:05:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 159 user: 'pinger' 140929 1:05:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 8 user: 'perfsonar' 140929 1:05:03 InnoDB: Starting shutdown... 140929 1:05:04 InnoDB: Waiting for 18 pages to be flushed 140929 01:05:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140929 1:05:09 [Note] libgovernor.so not found 140929 1:05:09 [Note] Plugin 'FEDERATED' is disabled. 140929 1:05:09 InnoDB: The InnoDB memory heap is disabled 140929 1:05:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140929 1:05:09 InnoDB: Compressed tables use zlib 1.2.3 140929 1:05:09 InnoDB: Using Linux native AIO 140929 1:05:09 InnoDB: Initializing buffer pool, size = 128.0M 140929 1:05:09 InnoDB: Completed initialization of buffer pool 140929 1:05:09 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140929 1:05:09 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 140929 1:05:10 InnoDB: Waiting for the background threads to start 140929 1:05:11 InnoDB: 5.5.40 started; log sequence number 10016989375 140929 1:05:11 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it 140929 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure 140929 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure 140929 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure 140929 1:05:11 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure 140929 1:05:11 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure 140929 1:05:11 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure 140929 1:05:11 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure 140929 1:05:11 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure 140929 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure 140929 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure 140929 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure 140929 1:05:11 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure 140929 1:05:11 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure 140929 1:05:11 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure 140929 1:05:11 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure 140929 1:05:11 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 140929 1:05:11 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure 140929 1:05:11 [Note] Event Scheduler: Loaded 0 events 140929 1:05:11 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.40-cll-lve' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) by Atomicorp 140930 1:05:01 [Note] /usr/libexec/mysqld: Normal shutdown 140930 1:05:01 [Note] Event Scheduler: Purging the queue. 0 events 140930 1:05:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 9 user: 'pinger' 140930 1:05:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 8 user: 'perfsonar' 140930 1:05:03 InnoDB: Starting shutdown... 140930 01:05:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140930 1:05:10 [Note] libgovernor.so not found 140930 1:05:10 [Note] Plugin 'FEDERATED' is disabled. 140930 1:05:10 InnoDB: The InnoDB memory heap is disabled 140930 1:05:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140930 1:05:10 InnoDB: Compressed tables use zlib 1.2.3 140930 1:05:10 InnoDB: Using Linux native AIO 140930 1:05:10 InnoDB: Initializing buffer pool, size = 128.0M 140930 1:05:10 InnoDB: Completed initialization of buffer pool 140930 1:05:10 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140930 1:05:10 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 140930 1:05:10 InnoDB: Waiting for the background threads to start 140930 1:05:11 InnoDB: 5.5.40 started; log sequence number 10053730662 140930 1:05:11 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it 140930 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure 140930 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure 140930 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure 140930 1:05:11 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure 140930 1:05:11 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure 140930 1:05:11 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure 140930 1:05:11 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure 140930 1:05:11 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure 140930 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure 140930 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure 140930 1:05:11 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure 140930 1:05:11 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure 140930 1:05:11 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure 140930 1:05:11 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure 140930 1:05:11 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure 140930 1:05:11 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 140930 1:05:11 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure 140930 1:05:11 [Note] Event Scheduler: Loaded 0 events 140930 1:05:11 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.40-cll-lve' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) by Atomicorp
- [perfsonar-user] MySQL errors, Luís Felipe, 09/30/2014
Archive powered by MHonArc 2.6.16.