Not Able to connect to MYSQL server

Issues related to software problems.
Post Reply
brijesh
Posts: 1
Joined: 2014/08/05 12:54:12

Not Able to connect to MYSQL server

Post by brijesh » 2014/08/05 13:11:30

Please i need an urgent help.
Please go through the below error and giv me the solutions in steps. Will thankful for you guys.

ERROR

140618 16:10:04 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140618 16:11:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140618 16:11:15 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
140618 16:11:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140618 16:11:15 InnoDB: The InnoDB memory heap is disabled
140618 16:11:15 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140618 16:11:15 InnoDB: Compressed tables use zlib 1.2.3
140618 16:11:15 InnoDB: Using Linux native AIO
140618 16:11:15 InnoDB: Initializing buffer pool, size = 128.0M
140618 16:11:15 InnoDB: Completed initialization of buffer pool
140618 16:11:15 InnoDB: highest supported file format is Barracuda.
140618 16:11:15 InnoDB: Waiting for the background threads to start
140618 16:11:16 InnoDB: 5.5.32 started; log sequence number 6516206
140618 16:11:16 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140618 16:11:16 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140618 16:11:16 [Note] Server socket created on IP: '0.0.0.0'.
140618 16:11:17 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
140618 16:11:17 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
140618 16:11:17 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
140618 16:11:17 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
140618 16:11:17 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
140618 16:11:17 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
140618 16:11:17 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
140618 16:11:17 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
140618 16:11:17 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
140618 16:11:17 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
140618 16:11:17 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
140618 16:11:17 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
140618 16:11:17 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
140618 16:11:17 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
140618 16:11:17 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
140618 16:11:17 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
140618 16:11:17 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
140618 16:11:17 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
140618 16:11:17 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
140618 16:11:17 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50095, now running 50532. Please use mysql_upgrade to fix this error.
140618 16:11:17 [ERROR] mysql.user has no `Event_priv` column at position 29
140618 16:11:17 [ERROR] Cannot open mysql.event
140618 16:11:17 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
140618 16:11:17 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.32' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
140618 16:24:56 [Note] /usr/libexec/mysqld: Normal shutdown

140618 16:24:56 InnoDB: Starting shutdown...
140618 16:24:57 InnoDB: Shutdown completed; log sequence number 6516206
140618 16:24:57 [Note] /usr/libexec/mysqld: Shutdown complete

140618 16:24:57 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140618 16:34:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140618 16:34:30 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
140618 16:34:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140618 16:34:30 InnoDB: The InnoDB memory heap is disabled
140618 16:34:30 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140618 16:34:30 InnoDB: Compressed tables use zlib 1.2.3
140618 16:34:30 InnoDB: Using Linux native AIO
140618 16:34:30 InnoDB: Initializing buffer pool, size = 128.0M
140618 16:34:31 InnoDB: Completed initialization of buffer pool
140618 16:34:31 InnoDB: highest supported file format is Barracuda.
140618 16:34:31 InnoDB: Waiting for the background threads to start
140618 16:34:32 InnoDB: 5.5.32 started; log sequence number 6516206
140618 16:34:32 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140618 16:34:32 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140618 16:34:32 [Note] Server socket created on IP: '0.0.0.0'.
140618 16:34:32 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
140618 16:34:32 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
140618 16:34:32 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
140618 16:34:32 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
140618 16:34:32 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
140618 16:34:32 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
140618 16:34:32 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
140618 16:34:32 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
140618 16:34:32 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
140618 16:34:32 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
140618 16:34:32 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
140618 16:34:32 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
140618 16:34:32 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
140618 16:34:32 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
140618 16:34:32 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
140618 16:34:32 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
140618 16:34:32 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
140618 16:34:32 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
140618 16:34:32 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
140618 16:34:32 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50095, now running 50532. Please use mysql_upgrade to fix this error.
140618 16:34:32 [ERROR] mysql.user has no `Event_priv` column at position 29
140618 16:34:32 [ERROR] Cannot open mysql.event
140618 16:34:32 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
140618 16:34:32 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.32' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
140620 14:58:20 [Note] /usr/libexec/mysqld: Normal shutdown

140620 14:58:20 InnoDB: Starting shutdown...
140620 14:58:21 InnoDB: Shutdown completed; log sequence number 6516206
140620 14:58:21 [Note] /usr/libexec/mysqld: Shutdown complete

140620 14:58:21 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140620 15:03:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140620 15:03:20 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
140620 15:03:20 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140620 15:03:20 InnoDB: The InnoDB memory heap is disabled
140620 15:03:20 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140620 15:03:20 InnoDB: Compressed tables use zlib 1.2.3
140620 15:03:20 InnoDB: Using Linux native AIO
140620 15:03:20 InnoDB: Initializing buffer pool, size = 128.0M
140620 15:03:20 InnoDB: Completed initialization of buffer pool
140620 15:03:20 InnoDB: highest supported file format is Barracuda.
140620 15:03:20 InnoDB: Waiting for the background threads to start
140620 15:03:21 InnoDB: 5.5.32 started; log sequence number 6516206
140620 15:03:21 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140620 15:03:21 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140620 15:03:21 [Note] Server socket created on IP: '0.0.0.0'.
140620 15:03:22 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
140620 15:03:22 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
140620 15:03:22 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
140620 15:03:22 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
140620 15:03:22 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
140620 15:03:22 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
140620 15:03:22 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
140620 15:03:22 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
140620 15:03:22 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
140620 15:03:22 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
140620 15:03:22 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
140620 15:03:22 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
140620 15:03:22 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
140620 15:03:22 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
140620 15:03:22 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
140620 15:03:22 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
140620 15:03:22 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
140620 15:03:22 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
140620 15:03:22 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
140620 15:03:22 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50095, now running 50532. Please use mysql_upgrade to fix this error.
140620 15:03:22 [ERROR] mysql.user has no `Event_priv` column at position 29
140620 15:03:22 [ERROR] Cannot open mysql.event
140620 15:03:22 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
140620 15:03:22 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.32' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
140705 20:09:09 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140705 20:09:09 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140705 20:19:09 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140705 20:19:09 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140705 20:29:09 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140705 20:29:09 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140705 20:39:09 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)140706 07:54:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140706 7:54:46 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
140706 7:54:46 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140706 7:54:46 InnoDB: The InnoDB memory heap is disabled
140706 7:54:46 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140706 7:54:46 InnoDB: Compressed tables use zlib 1.2.3
140706 7:54:46 InnoDB: Using Linux native AIO
140706 7:54:46 InnoDB: Initializing buffer pool, size = 128.0M
140706 7:54:46 InnoDB: Completed initialization of buffer pool
140706 7:54:46 InnoDB: highest supported file format is Barracuda.
140706 7:54:46 InnoDB: Waiting for the background threads to start
140706 7:54:47 InnoDB: 5.5.32 started; log sequence number 6516206
140706 7:54:47 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140706 7:54:47 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140706 7:54:47 [Note] Server socket created on IP: '0.0.0.0'.
140706 7:54:48 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
140706 7:54:48 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
140706 7:54:48 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
140706 7:54:48 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
140706 7:54:48 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
140706 7:54:48 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
140706 7:54:48 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
140706 7:54:48 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
140706 7:54:48 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
140706 7:54:48 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
140706 7:54:48 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
140706 7:54:48 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
140706 7:54:48 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
140706 7:54:48 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
140706 7:54:48 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
140706 7:54:48 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
140706 7:54:48 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
140706 7:54:48 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
140706 7:54:48 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
140706 7:54:48 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50095, now running 50532. Please use mysql_upgrade to fix this error.
140706 7:54:48 [ERROR] mysql.user has no `Event_priv` column at position 29
140706 7:54:48 [ERROR] Cannot open mysql.event
140706 7:54:48 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
140706 7:54:48 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.32' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
140706 9:27:36 [ERROR] /usr/libexec/mysqld: Sort aborted: Error writing file '/tmp/MY673vTo' (Errcode: 28)
140706 9:29:49 [ERROR] /usr/libexec/mysqld: Sort aborted: Error writing file '/tmp/MYwwgakL' (Errcode: 28)
140706 9:33:45 [ERROR] /usr/libexec/mysqld: Sort aborted: Error writing file '/tmp/MYoAEtmI' (Errcode: 28)
140706 9:34:04 [ERROR] /usr/libexec/mysqld: Sort aborted: Error writing file '/tmp/MY1sHvjN' (Errcode: 28)
140706 9:34:11 [ERROR] /usr/libexec/mysqld: Sort aborted: Error writing file '/tmp/MYczObWf' (Errcode: 28)
140706 9:38:32 [ERROR] /usr/libexec/mysqld: Sort aborted: Error writing file '/tmp/MYCosom4' (Errcode: 28)
140706 9:42:17 [ERROR] /usr/libexec/mysqld: Sort aborted: Error writing file '/tmp/MYIleHyb' (Errcode: 28)
140706 9:49:15 [ERROR] /usr/libexec/mysqld: Sort aborted: Error writing file '/tmp/MYEHcUAO' (Errcode: 28)
140706 10:33:36 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140706 10:33:36 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140725 10:50:41 [Note] /usr/libexec/mysqld: Normal shutdown

140725 10:50:41 InnoDB: Starting shutdown...
140725 10:50:42 InnoDB: Shutdown completed; log sequence number 6516206
140725 10:50:42 [Note] /usr/libexec/mysqld: Shutdown complete

140725 10:50:42 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140725 11:01:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140725 11:02:00 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
140725 11:02:00 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140725 11:02:00 InnoDB: The InnoDB memory heap is disabled
140725 11:02:00 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140725 11:02:00 InnoDB: Compressed tables use zlib 1.2.3
140725 11:02:00 InnoDB: Using Linux native AIO
140725 11:02:00 InnoDB: Initializing buffer pool, size = 128.0M
140725 11:02:00 InnoDB: Completed initialization of buffer pool
140725 11:02:00 InnoDB: highest supported file format is Barracuda.
140725 11:02:00 InnoDB: Waiting for the background threads to start
140725 11:02:01 InnoDB: 5.5.32 started; log sequence number 6516206
140725 11:02:01 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140725 11:02:01 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140725 11:02:01 [Note] Server socket created on IP: '0.0.0.0'.
140725 11:02:02 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
140725 11:02:02 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
140725 11:02:02 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
140725 11:02:02 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
140725 11:02:02 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
140725 11:02:02 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
140725 11:02:02 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
140725 11:02:02 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
140725 11:02:02 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
140725 11:02:02 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
140725 11:02:02 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
140725 11:02:02 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
140725 11:02:02 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
140725 11:02:02 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
140725 11:02:02 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
140725 11:02:02 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
140725 11:02:02 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
140725 11:02:02 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
140725 11:02:02 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
140725 11:02:02 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50095, now running 50532. Please use mysql_upgrade to fix this error.
140725 11:02:02 [ERROR] mysql.user has no `Event_priv` column at position 29
140725 11:02:02 [ERROR] Cannot open mysql.event
140725 11:02:02 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
140725 11:02:02 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.32' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
140728 13:28:37 [Note] /usr/libexec/mysqld: Normal shutdown

140728 13:28:39 [Warning] /usr/libexec/mysqld: Forcing close of thread 31 user: 'rsyslog'

140728 13:28:39 InnoDB: Starting shutdown...
140728 13:28:40 InnoDB: Shutdown completed; log sequence number 6516206
140728 13:28:40 [Note] /usr/libexec/mysqld: Shutdown complete

140728 13:28:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140728 13:30:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140728 13:30:20 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
140728 13:30:20 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140728 13:30:20 InnoDB: The InnoDB memory heap is disabled
140728 13:30:20 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140728 13:30:20 InnoDB: Compressed tables use zlib 1.2.3
140728 13:30:20 InnoDB: Using Linux native AIO
140728 13:30:20 InnoDB: Initializing buffer pool, size = 128.0M
140728 13:30:20 InnoDB: Completed initialization of buffer pool
140728 13:30:20 InnoDB: highest supported file format is Barracuda.
140728 13:30:20 InnoDB: Waiting for the background threads to start
140728 13:30:21 InnoDB: 5.5.32 started; log sequence number 6516206
140728 13:30:21 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140728 13:30:21 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140728 13:30:21 [Note] Server socket created on IP: '0.0.0.0'.
140728 13:30:22 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
140728 13:30:22 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
140728 13:30:22 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
140728 13:30:22 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
140728 13:30:22 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
140728 13:30:22 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
140728 13:30:22 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
140728 13:30:22 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
140728 13:30:22 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
140728 13:30:22 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
140728 13:30:22 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
140728 13:30:22 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
140728 13:30:22 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
140728 13:30:22 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
140728 13:30:22 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
140728 13:30:22 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
140728 13:30:22 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
140728 13:30:22 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
140728 13:30:22 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
140728 13:30:22 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50095, now running 50532. Please use mysql_upgrade to fix this error.
140728 13:30:22 [ERROR] mysql.user has no `Event_priv` column at position 29
140728 13:30:22 [ERROR] Cannot open mysql.event
140728 13:30:22 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
140728 13:30:22 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.32' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
140804 13:04:03 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140804 13:04:03 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140804 13:14:03 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140804 13:14:03 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140804 13:24:03 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140804 13:24:03 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140804 13:34:03 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140804 13:34:03 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140804 13:44:03 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140804 13:44:03 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140804 13:54:03 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140804 13:54:03 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140804 14:04:03 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140804 14:04:03 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140804 14:14:03 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140804 14:14:03 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140804 14:24:03 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140804 14:24:03 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140804 14:34:03 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140804 14:34:03 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140804 14:44:03 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140804 14:44:03 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140804 14:54:03 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
140804 14:54:03 [Warning] Retry in 60 secs. Message reprinted in 600 secs
140804 15:04:03 [Warning] Disk is full writing './rsyslogdb/SystemEvents.MYD' (Errcode: 28). Waiting for someone to free space... 140804 16:32:04 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140804 16:32:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140804 16:32:47 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
140804 16:32:47 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140804 16:32:47 InnoDB: The InnoDB memory heap is disabled
140804 16:32:47 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140804 16:32:47 InnoDB: Compressed tables use zlib 1.2.3
140804 16:32:47 InnoDB: Using Linux native AIO
140804 16:32:47 InnoDB: Initializing buffer pool, size = 128.0M
140804 16:32:47 InnoDB: Completed initialization of buffer pool
140804 16:32:47 InnoDB: highest supported file format is Barracuda.
140804 16:32:48 InnoDB: Waiting for the background threads to start
140804 16:32:49 InnoDB: 5.5.32 started; log sequence number 6516206
140804 16:32:49 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140804 16:32:49 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140804 16:32:49 [Note] Server socket created on IP: '0.0.0.0'.
140804 16:32:49 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
140804 16:32:50 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
140804 16:32:50 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
140804 16:32:50 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
140804 16:32:50 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
140804 16:32:50 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
140804 16:32:50 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
140804 16:32:50 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
140804 16:32:50 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
140804 16:32:50 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
140804 16:32:50 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
140804 16:32:50 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
140804 16:32:50 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
140804 16:32:50 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
140804 16:32:50 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
140804 16:32:50 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
140804 16:32:50 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
140804 16:32:50 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
140804 16:32:50 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
140804 16:32:50 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50095, now running 50532. Please use mysql_upgrade to fix this error.
140804 16:32:50 [ERROR] mysql.user has no `Event_priv` column at position 29
140804 16:32:50 [ERROR] Cannot open mysql.event
140804 16:32:50 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
140804 16:32:50 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.32' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
140804 16:34:35 [ERROR] /usr/libexec/mysqld: Table './rsyslogdb/SystemEvents' is marked as crashed and should be repaired
140804 16:34:35 [ERROR] /usr/libexec/mysqld: Table './rsyslogdb/SystemEvents' is marked as crashed and should be repaired
140804 16:35:05 [ERROR] /usr/libexec/mysqld: Table './rsyslogdb/SystemEvents' is marked as crashed and sh140805 0:01:25 [ERROR] /usr/libexec/mysqld: Table './rsyslogdb/SystemEvents' is marked as crashed and should be repaired
140805 0:01:25 [ERROR] /usr/libexec/mysqld: Table './rsyslogdb/SystemEvents' is marked as crashed and should be repaired
140805 0:02:01 [ERROR] /usr/libexec/mysqld: Table './rsyslogdb/SystemEvents' is marked as crashed and should be repaired

140805 1:42:28 [ERROR] /usr/libexec/mysqld: Table './rsyslogdb/SystemEvents' is marked as crashed and should be repaired

140805 3:35:06 [ERROR] /usr/libexec/mysqld: Table './rsyslogdb/SystemEvents' is marked as crashed and should be repaired
140805140805 10:16:38 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140805 10:18:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140805 10:18:50 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
140805 10:18:50 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140805 10:18:50 InnoDB: The InnoDB memory heap is disabled
140805 10:18:50 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140805 10:18:50 InnoDB: Compressed tables use zlib 1.2.3
140805 10:18:50 InnoDB: Using Linux native AIO
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibNjRU1t' (Errcode: 28)
140805 10:18:50 InnoDB: Error: unable to create temporary file; errno: 28
140805 10:18:50 [ERROR] Plugin 'InnoDB' init function returned error.
140805 10:18:50 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140805 10:18:50 [ERROR] Unknown/unsupported storage engine: InnoDB
140805 10:18:50 [ERROR] Aborting

140805 10:18:50 [Note] /usr/libexec/mysqld: Shutdown complete

140805 10:18:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140805 10:28:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140805 10:28:50 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
140805 10:28:50 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140805 10:28:50 InnoDB: The InnoDB memory heap is disabled
140805 10:28:50 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140805 10:28:50 InnoDB: Compressed tables use zlib 1.2.3
140805 10:28:50 InnoDB: Using Linux native AIO
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibCg639T' (Errcode: 28)
140805 10:28:50 InnoDB: Error: unable to create temporary file; errno: 28
140805 10:28:50 [ERROR] Plugin 'InnoDB' init function returned error.
140805 10:28:50 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140805 10:28:50 [ERROR] Unknown/unsupported storage engine: InnoDB
140805 10:28:50 [ERROR] Aborting

140805 10:28:50 [Note] /usr/libexec/mysqld: Shutdown complete

140805 10:28:50 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140805 12:09:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140805 12:09:17 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
140805 12:09:17 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140805 12:09:17 InnoDB: The InnoDB memory heap is disabled
140805 12:09:17 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140805 12:09:17 InnoDB: Compressed tables use zlib 1.2.3
140805 12:09:17 InnoDB: Using Linux native AIO
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibF1C4rK' (Errcode: 28)
140805 12:09:17 InnoDB: Error: unable to create temporary file; errno: 28
140805 12:09:17 [ERROR] Plugin 'InnoDB' init function returned error.
140805 12:09:17 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140805 12:09:17 [ERROR] Unknown/unsupported storage engine: InnoDB
140805 12:09:17 [ERROR] Aborting

140805 12:09:17 [Note] /usr/libexec/mysqld: Shutdown complete

140805 12:09:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140805 12:09:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140805 12:09:30 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
140805 12:09:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140805 12:09:30 InnoDB: The InnoDB memory heap is disabled
140805 12:09:30 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140805 12:09:30 InnoDB: Compressed tables use zlib 1.2.3
140805 12:09:30 InnoDB: Using Linux native AIO
/usr/libexec/mysqld: Can't create/write to file '/tmp/ib3EjeH7' (Errcode: 28)
140805 12:09:30 InnoDB: Error: unable to create temporary file; errno: 28
140805 12:09:30 [ERROR] Plugin 'InnoDB' init function returned erro140805 12:09:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140805 12:16:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140805 12:16:05 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
140805 12:16:05 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140805 12:16:05 InnoDB: The InnoDB memory heap is disabled
140805 12:16:05 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140805 12:16:05 InnoDB: Compressed tables use zlib 1.2.3
140805 12:16:05 InnoDB: Using Linux native AIO
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibs5WYAw' (Errcode: 28)
140805 12:16:05 InnoDB: Error: unable to create temporary file; errno: 28
140805 12:16:05 [ERROR] Plugin 'InnoDB' init function returned error.
140805 12:16:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140805 12:16:05 [ERROR] Unknown/unsupported storage engine: InnoDB
140805 12:16:05 [ERROR] Aborting

140805 12:16:05 [Note] /usr/libexec/mysqld: Shutdown complete

140805 12:16:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140805 12:43:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140805 12:43:30 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
140805 12:43:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140805 12:43:30 InnoDB: The InnoDB memory heap is disabled
140805 12:43:30 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140805 12:43:30 InnoDB: Compressed tables use zlib 1.2.3
140805 12:43:30 InnoDB: Using Linux native AIO
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibZjGtIS' (Errcode: 28)
140805 12:43:30 InnoDB: Error: unable to create temporary file; errno: 28
140805 12:43:30 [ERROR] Plugin 'InnoDB' init function returned error.
140805 12:43:30 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140805 12:43:30 [ERROR] Unknown/unsupported storage engine: InnoDB
140805 12:43:30 [ERROR] Aborting

140805 12:43:30 [Note] /usr/libexec/mysqld: Shutdown complete

140805 12:43:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

User avatar
TrevorH
Site Admin
Posts: 33215
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: Not Able to connect to MYSQL server

Post by TrevorH » 2014/08/05 17:20:26

140725 11:02:02 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50095, now running 50532. Please use mysql_upgrade to fix this error.
This says you started on mysql 5.0.95 and now have 5.5.32. I suspect this means that you are running CentOS 5 which is the only one I know that supplied 5.0.95 so I am moving your post from CentOS Social where it definitely doesn't belong to CentOS 5 Software Support where it might be better suited. If you're not running CentOS 5 then let me know and I will shift it to the relevant forum instead.

No version of CentOS has shipped with 5.5.32 so the next question is where did you get this version from? If you intended to migrate from one to the other then did you backup and restore your data or just install the new version and hope for the best? If the latter then did you run the mysql_upgrade command like it told you to?

Did you fix the errors created by your running out of disk space previously?

If you didn't intend to update mysql from the distro 5.0.95 to 5.5.32 then I am unsure if you can now uninstall 5.5.32 and revert to 5.0.95 without a problem. You may need to back up your database with mysqldump and restore it.

It also looks like you have some sort of problem with /tmp that needs to be fixed.
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

Post Reply