140806 13:19:18 [Note] Start binlog_dump to slave_server(2443445205), pos(bin.000018, 10341) 140806 13:19:43 [Note] Start binlog_dump to slave_server(1505023518), pos(bin.000018, 10341) 140806 13:24:01 [Note] /usr/sbin/mysqld: Normal shutdown 140806 13:24:01 [Note] Event Scheduler: Purging the queue. 0 events 140806 13:24:03 [Warning] /usr/sbin/mysqld: Forcing close of thread 80773 user: 'SUSR_Heartbeat' 140806 13:24:03 InnoDB: Starting shutdown... 140806 13:24:03 InnoDB: Waiting for 16 pages to be flushed 140806 13:24:04 InnoDB: Shutdown completed; log sequence number 9793789086 140806 13:24:04 [Note] /usr/sbin/mysqld: Shutdown complete 140806 13:24:04 mysqld_safe mysqld from pid file /opt/mysql/dbprod/test-p0.pid ended 140806 13:24:06 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/dbdata1/test-p0 140806 13:24:06 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140806 13:24:06 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140806 13:24:06 [Note] Plugin 'FEDERATED' is disabled. InnoDB: Warning: innodb_overwrite_relay_log_info is enabled. Updates by other storage engines may not be synchronized. 140806 13:24:06 InnoDB: The InnoDB memory heap is disabled 140806 13:24:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140806 13:24:06 InnoDB: Compressed tables use zlib 1.2.3 140806 13:24:06 InnoDB: Using Linux native AIO 140806 13:24:06 InnoDB: Initializing buffer pool, size = 5.0G 140806 13:24:07 InnoDB: Completed initialization of buffer pool 140806 13:24:07 InnoDB: highest supported file format is Barracuda. 140806 13:24:07 InnoDB: Waiting for the background threads to start 140806 13:24:08 Percona XtraDB (http://www.percona.com) 5.5.38-35.2 started; log sequence number 9793789086 InnoDB: something wrong with relay-log.info. InnoDB will not overwrite it. 140806 13:24:08 [Note] Event Scheduler: Loaded 0 events 140806 13:24:08 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.38-35.2-log' socket: '/opt/mysql/dbprod/test-p0.sock' port: 3306 Percona Server (GPL), Release 35.2, Revision 674 140806 13:24:16 [Note] Start binlog_dump to slave_server(1505023518), pos(bin.000018, 157451) 140806 13:24:16 [Note] Start binlog_dump to slave_server(2443445205), pos(bin.000018, 157451) 140806 13:32:25 [Note] /usr/sbin/mysqld: Normal shutdown 140806 13:32:25 [Note] Event Scheduler: Purging the queue. 0 events 140806 13:32:27 [Warning] /usr/sbin/mysqld: Forcing close of thread 7 user: 'SUSR_Heartbeat' 140806 13:32:27 [Warning] /usr/sbin/mysqld: Forcing close of thread 6 user: 'SUSR_Heartbeat' 140806 13:32:27 [Warning] /usr/sbin/mysqld: Forcing close of thread 5 user: 'SUSR_Heartbeat' 140806 13:32:27 InnoDB: Starting shutdown... 140806 13:32:28 InnoDB: Waiting for 12 pages to be flushed 140806 13:32:29 InnoDB: Shutdown completed; log sequence number 9794041122 140806 13:32:29 [Note] /usr/sbin/mysqld: Shutdown complete 140806 13:32:29 mysqld_safe mysqld from pid file /opt/mysql/dbprod/test-p0.pid ended 140806 13:33:06 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/dbdata1/test-p0 140806 13:33:06 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140806 13:33:06 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140806 13:33:06 [Note] Plugin 'FEDERATED' is disabled. InnoDB: Warning: innodb_overwrite_relay_log_info is enabled. Updates by other storage engines may not be synchronized. 140806 13:33:06 InnoDB: The InnoDB memory heap is disabled 140806 13:33:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140806 13:33:06 InnoDB: Compressed tables use zlib 1.2.3 140806 13:33:06 InnoDB: Using Linux native AIO 140806 13:33:07 InnoDB: Initializing buffer pool, size = 5.0G 140806 13:33:07 InnoDB: Completed initialization of buffer pool 140806 13:33:07 InnoDB: highest supported file format is Barracuda. 140806 13:33:07 InnoDB: Waiting for the background threads to start 140806 13:33:08 Percona XtraDB (http://www.percona.com) 5.5.38-35.2 started; log sequence number 9794041122 InnoDB: something wrong with relay-log.info. InnoDB will not overwrite it. 140806 13:33:09 [Note] Event Scheduler: Loaded 0 events 140806 13:33:09 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.38-35.2-log' socket: '/opt/mysql/dbprod/test-p0.sock' port: 3306 Percona Server (GPL), Release 35.2, Revision 674 140806 13:37:15 [Warning] Aborted connection 56 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets) 140806 13:39:22 [Note] /usr/sbin/mysqld: Normal shutdown 140806 13:39:22 [Note] Event Scheduler: Purging the queue. 0 events 140806 13:39:24 [Warning] /usr/sbin/mysqld: Forcing close of thread 63 user: 'SUSR_Heartbeat' 140806 13:39:24 [Warning] /usr/sbin/mysqld: Forcing close of thread 62 user: 'SUSR_Heartbeat' 140806 13:39:24 [Warning] /usr/sbin/mysqld: Forcing close of thread 61 user: 'SUSR_Heartbeat' 140806 13:39:24 [Warning] /usr/sbin/mysqld: Forcing close of thread 60 user: 'SUSR_Heartbeat' 140806 13:39:24 InnoDB: Starting shutdown... 140806 13:39:29 InnoDB: Shutdown completed; log sequence number 9794041687 140806 13:39:29 [Note] /usr/sbin/mysqld: Shutdown complete 140806 13:39:29 mysqld_safe mysqld from pid file /opt/mysql/dbprod/test-p0.pid ended 140806 13:43:29 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/dbdata1/test-p0 140806 13:43:29 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140806 13:43:29 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140806 13:43:29 [Note] Plugin 'FEDERATED' is disabled. InnoDB: Warning: innodb_overwrite_relay_log_info is enabled. Updates by other storage engines may not be synchronized. 140806 13:43:29 InnoDB: The InnoDB memory heap is disabled 140806 13:43:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140806 13:43:29 InnoDB: Compressed tables use zlib 1.2.3 140806 13:43:29 InnoDB: Using Linux native AIO 140806 13:43:29 InnoDB: Initializing buffer pool, size = 5.0G 140806 13:43:30 InnoDB: Completed initialization of buffer pool 140806 13:43:30 InnoDB: highest supported file format is Barracuda. 140806 13:43:30 InnoDB: Waiting for the background threads to start 140806 13:43:31 Percona XtraDB (http://www.percona.com) 5.5.38-35.2 started; log sequence number 9794041687 InnoDB: something wrong with relay-log.info. InnoDB will not overwrite it. 140806 13:43:31 [Note] Event Scheduler: Loaded 0 events 140806 13:43:31 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.38-35.2-log' socket: '/opt/mysql/dbprod/test-p0.sock' port: 3306 Percona Server (GPL), Release 35.2, Revision 674 140806 13:58:03 [Note] Start binlog_dump to slave_server(3036626707), pos(bin.000009, 702049614) 140806 13:59:51 [Note] Start binlog_dump to slave_server(3343678670), pos(bin.000009, 702049614) 140806 14:01:44 [Note] Start binlog_dump to slave_server(2188973017), pos(bin.000009, 702049614) 140806 14:01:50 [Note] /usr/sbin/mysqld: Normal shutdown 140806 14:01:50 [Note] Event Scheduler: Purging the queue. 0 events 140806 14:01:52 [Warning] /usr/sbin/mysqld: Forcing close of thread 4 user: 'SUSR_Heartbeat' 140806 14:01:52 [Warning] /usr/sbin/mysqld: Forcing close of thread 3 user: 'SUSR_Heartbeat' 140806 14:01:52 [Warning] /usr/sbin/mysqld: Forcing close of thread 2 user: 'SUSR_Heartbeat' 140806 14:01:52 [Warning] /usr/sbin/mysqld: Forcing close of thread 1 user: 'SUSR_Heartbeat' 140806 14:01:52 InnoDB: Starting shutdown... 140806 14:01:56 InnoDB: Shutdown completed; log sequence number 9794041687 140806 14:01:56 [Note] /usr/sbin/mysqld: Shutdown complete 140806 14:01:56 mysqld_safe mysqld from pid file /opt/mysql/dbprod/test-p0.pid ended 140806 14:01:59 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/dbdata1/test-p0 140806 14:01:59 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140806 14:01:59 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140806 14:01:59 [Note] Plugin 'FEDERATED' is disabled. InnoDB: Warning: innodb_overwrite_relay_log_info is enabled. Updates by other storage engines may not be synchronized. 140806 14:01:59 InnoDB: The InnoDB memory heap is disabled 140806 14:01:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140806 14:01:59 InnoDB: Compressed tables use zlib 1.2.3 140806 14:01:59 InnoDB: Using Linux native AIO 140806 14:01:59 InnoDB: Initializing buffer pool, size = 5.0G 140806 14:01:59 InnoDB: Completed initialization of buffer pool 140806 14:01:59 InnoDB: highest supported file format is Barracuda. 140806 14:02:00 InnoDB: Waiting for the background threads to start 140806 14:02:01 Percona XtraDB (http://www.percona.com) 5.5.38-35.2 started; log sequence number 9794041687 InnoDB: something wrong with relay-log.info. InnoDB will not overwrite it. 140806 14:02:01 [Note] Event Scheduler: Loaded 0 events 140806 14:02:01 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.38-35.2-log' socket: '/opt/mysql/dbprod/test-p0.sock' port: 3306 Percona Server (GPL), Release 35.2, Revision 674 140806 14:33:09 [Warning] Aborted connection 2 to db: 'unconnected' user: 'SUSR_Heartbeat' host: '127.0.0.1' (Got timeout reading communication packets) 140806 14:33:09 [Warning] Aborted connection 4 to db: 'unconnected' user: 'SUSR_Heartbeat' host: '127.0.0.1' (Got timeout reading communication packets) 140806 14:33:09 [Warning] Aborted connection 3 to db: 'unconnected' user: 'SUSR_Heartbeat' host: '127.0.0.1' (Got timeout reading communication packets) 140807 20:06:54 [Warning] Access denied for user 'cxie'@'localhost' (using password: NO) 140807 20:23:52 [Warning] Aborted connection 1648 to db: 'unconnected' user: 'root' host: 'localhost' (Got timeout reading communication packets) 140807 23:50:40 [Note] /usr/sbin/mysqld: Normal shutdown 140807 23:50:40 [Note] Event Scheduler: Purging the queue. 0 events 140807 23:50:42 [Warning] /usr/sbin/mysqld: Forcing close of thread 1 user: 'SUSR_Heartbeat' 140807 23:50:42 InnoDB: Starting shutdown... 140807 23:50:45 InnoDB: Shutdown completed; log sequence number 9794041687 140807 23:50:45 [Note] /usr/sbin/mysqld: Shutdown complete 140807 23:50:45 mysqld_safe mysqld from pid file /opt/mysql/dbprod/test-p0.pid ended 140807 23:51:01 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/dbdata1/test-p0 140807 23:51:01 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140807 23:51:01 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140807 23:51:01 [Note] Plugin 'FEDERATED' is disabled. InnoDB: Warning: innodb_overwrite_relay_log_info is enabled. Updates by other storage engines may not be synchronized. 140807 23:51:01 InnoDB: The InnoDB memory heap is disabled 140807 23:51:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140807 23:51:01 InnoDB: Compressed tables use zlib 1.2.3 140807 23:51:01 InnoDB: Using Linux native AIO 140807 23:51:01 InnoDB: Initializing buffer pool, size = 5.0G 140807 23:51:02 InnoDB: Completed initialization of buffer pool 140807 23:51:02 InnoDB: highest supported file format is Barracuda. 140807 23:51:02 InnoDB: Waiting for the background threads to start 140807 23:51:03 Percona XtraDB (http://www.percona.com) 5.5.38-35.2 started; log sequence number 9794041687 InnoDB: something wrong with relay-log.info. InnoDB will not overwrite it. 140807 23:51:03 [Note] Event Scheduler: Loaded 0 events 140807 23:51:03 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.38-35.2-log' socket: '/opt/mysql/dbprod/test-p0.sock' port: 3306 Percona Server (GPL), Release 35.2, Revision 674 140807 23:53:40 [Note] /usr/sbin/mysqld: Normal shutdown 140807 23:53:40 [Note] Event Scheduler: Purging the queue. 0 events 140807 23:53:42 [Warning] /usr/sbin/mysqld: Forcing close of thread 4 user: 'SUSR_Heartbeat' 140807 23:53:42 [Warning] /usr/sbin/mysqld: Forcing close of thread 3 user: 'SUSR_Heartbeat' 140807 23:53:42 [Warning] /usr/sbin/mysqld: Forcing close of thread 2 user: 'SUSR_Heartbeat' 140807 23:53:42 [Warning] /usr/sbin/mysqld: Forcing close of thread 1 user: 'SUSR_Heartbeat' 140807 23:53:42 InnoDB: Starting shutdown... 140807 23:53:43 InnoDB: Shutdown completed; log sequence number 9794041687 140807 23:53:43 [Note] /usr/sbin/mysqld: Shutdown complete 140807 23:53:43 mysqld_safe mysqld from pid file /opt/mysql/dbprod/test-p0.pid ended 140807 23:56:40 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/dbdata1/test-p0 140807 23:56:41 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140807 23:56:41 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140807 23:56:41 [Note] Plugin 'FEDERATED' is disabled. InnoDB: Warning: innodb_overwrite_relay_log_info is enabled. Updates by other storage engines may not be synchronized. 140807 23:56:41 InnoDB: The InnoDB memory heap is disabled 140807 23:56:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140807 23:56:41 InnoDB: Compressed tables use zlib 1.2.3 140807 23:56:41 InnoDB: Using Linux native AIO 140807 23:56:41 InnoDB: Initializing buffer pool, size = 5.0G 140807 23:56:41 InnoDB: Completed initialization of buffer pool 140807 23:56:41 InnoDB: highest supported file format is Barracuda. 140807 23:56:42 InnoDB: Waiting for the background threads to start 140807 23:56:43 Percona XtraDB (http://www.percona.com) 5.5.37-35.1-35.1 started; log sequence number 9794041687 InnoDB: something wrong with relay-log.info. InnoDB will not overwrite it. 140807 23:56:43 [Note] Event Scheduler: Loaded 0 events 140807 23:56:43 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.37-35.1-log' socket: '/opt/mysql/dbprod/test-p0.sock' port: 3306 Percona Server (GPL), Release 35.1, Revision 666 140807 23:57:25 [Note] /usr/sbin/mysqld: Normal shutdown 140807 23:57:25 [Note] Event Scheduler: Purging the queue. 0 events 140807 23:57:27 [Warning] /usr/sbin/mysqld: Forcing close of thread 1 user: 'SUSR_Heartbeat' 140807 23:57:27 InnoDB: Starting shutdown... 140807 23:57:32 InnoDB: Shutdown completed; log sequence number 9794041687 140807 23:57:32 [Note] /usr/sbin/mysqld: Shutdown complete 140807 23:57:32 mysqld_safe mysqld from pid file /opt/mysql/dbprod/test-p0.pid ended 140808 00:00:14 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/dbdata1/test-p0 140808 0:00:14 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140808 0:00:14 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140808 0:00:14 [Note] Plugin 'FEDERATED' is disabled. InnoDB: Warning: innodb_overwrite_relay_log_info is enabled. Updates by other storage engines may not be synchronized. 140808 0:00:14 InnoDB: The InnoDB memory heap is disabled 140808 0:00:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140808 0:00:14 InnoDB: Compressed tables use zlib 1.2.3 140808 0:00:14 InnoDB: Using Linux native AIO 140808 0:00:14 InnoDB: Initializing buffer pool, size = 5.0G 140808 0:00:15 InnoDB: Completed initialization of buffer pool 140808 0:00:15 InnoDB: highest supported file format is Barracuda. 140808 0:00:15 InnoDB: Waiting for the background threads to start 140808 0:00:16 Percona XtraDB (http://www.percona.com) 5.5.38-35.2 started; log sequence number 9794041687 InnoDB: something wrong with relay-log.info. InnoDB will not overwrite it. 140808 0:00:16 [Note] Event Scheduler: Loaded 0 events 140808 0:00:16 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.38-35.2-log' socket: '/opt/mysql/dbprod/test-p0.sock' port: 3306 Percona Server (GPL), Release 35.2, Revision 674 140808 0:05:50 [Note] /usr/sbin/mysqld: Normal shutdown 140808 0:05:50 [Note] Event Scheduler: Purging the queue. 0 events 140808 0:05:50 InnoDB: Starting shutdown... 140808 0:05:51 InnoDB: Shutdown completed; log sequence number 9794041687 140808 0:05:51 [Note] /usr/sbin/mysqld: Shutdown complete 140808 00:05:51 mysqld_safe mysqld from pid file /opt/mysql/dbprod/test-p0.pid ended 140808 00:06:31 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/dbdata1/test-p0 140808 0:06:31 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140808 0:06:31 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140808 0:06:31 [Note] Plugin 'FEDERATED' is disabled. InnoDB: Warning: innodb_overwrite_relay_log_info is enabled. Updates by other storage engines may not be synchronized. 140808 0:06:31 InnoDB: The InnoDB memory heap is disabled 140808 0:06:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140808 0:06:31 InnoDB: Compressed tables use zlib 1.2.3 140808 0:06:31 InnoDB: Using Linux native AIO 140808 0:06:31 InnoDB: Initializing buffer pool, size = 5.0G 140808 0:06:32 InnoDB: Completed initialization of buffer pool 140808 0:06:32 InnoDB: highest supported file format is Barracuda. 140808 0:06:32 InnoDB: Waiting for the background threads to start 140808 0:06:33 Percona XtraDB (http://www.percona.com) 5.5.38-35.2 started; log sequence number 9794041687 InnoDB: something wrong with relay-log.info. InnoDB will not overwrite it. 140808 0:06:33 [Note] Event Scheduler: Loaded 0 events 140808 0:06:33 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.38-35.2-log' socket: '/opt/mysql/dbprod/test-p0.sock' port: 3306 Percona Server (GPL), Release 35.2, Revision 674 140808 3:35:44 [Note] /usr/sbin/mysqld: Normal shutdown 140808 3:35:44 [Note] Event Scheduler: Purging the queue. 0 events 140808 3:35:44 InnoDB: Starting shutdown... 140808 3:35:46 InnoDB: Shutdown completed; log sequence number 9794041687 140808 3:35:46 [Note] /usr/sbin/mysqld: Shutdown complete 140808 03:35:46 mysqld_safe mysqld from pid file /opt/mysql/dbprod/test-p0.pid ended 140808 03:42:09 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/dbdata1/test-p0 140808 3:42:09 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140808 3:42:09 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140808 3:42:09 [Note] Plugin 'FEDERATED' is disabled. 140808 3:42:09 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/auth_pam.so' (errno: 0 /usr/lib64/mysql/plugin/auth_pam.so: cannot open shared object file: No such file or directory) 140808 3:42:09 [Warning] Couldn't load plugin named 'auth_pam' with soname 'auth_pam.so'. 140808 3:42:09 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/auth_pam_compat.so' (errno: 0 /usr/lib64/mysql/plugin/auth_pam_compat.so: cannot open shared object file: No such file or directory) 140808 3:42:09 [Warning] Couldn't load plugin named 'auth_pam_compat' with soname 'auth_pam_compat.so'. 140808 3:42:09 InnoDB: The InnoDB memory heap is disabled 140808 3:42:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140808 3:42:09 InnoDB: Compressed tables use zlib 1.2.3 140808 3:42:09 InnoDB: Using Linux native AIO 140808 3:42:09 InnoDB: Initializing buffer pool, size = 5.0G 140808 3:42:09 InnoDB: Completed initialization of buffer pool 140808 3:42:09 InnoDB: highest supported file format is Barracuda. 140808 3:42:10 InnoDB: Waiting for the background threads to start 140808 3:42:11 InnoDB: 5.5.38 started; log sequence number 9794041687 140808 3:42:11 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_recovery_update_relay_log=1' 140808 3:42:11 [ERROR] Aborting 140808 3:42:11 InnoDB: Starting shutdown... 140808 3:42:12 InnoDB: Shutdown completed; log sequence number 9794041687 140808 3:42:12 [Note] /usr/sbin/mysqld: Shutdown complete 140808 03:42:12 mysqld_safe mysqld from pid file /opt/mysql/dbprod/test-p0.pid ended 140808 03:43:08 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/dbdata1/test-p0 140808 3:43:08 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140808 3:43:08 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140808 3:43:08 [Note] Plugin 'FEDERATED' is disabled. 140808 3:43:08 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/auth_pam.so' (errno: 0 /usr/lib64/mysql/plugin/auth_pam.so: cannot open shared object file: No such file or directory) 140808 3:43:08 [Warning] Couldn't load plugin named 'auth_pam' with soname 'auth_pam.so'. 140808 3:43:08 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/auth_pam_compat.so' (errno: 0 /usr/lib64/mysql/plugin/auth_pam_compat.so: cannot open shared object file: No such file or directory) 140808 3:43:08 [Warning] Couldn't load plugin named 'auth_pam_compat' with soname 'auth_pam_compat.so'. 140808 3:43:08 InnoDB: The InnoDB memory heap is disabled 140808 3:43:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140808 3:43:08 InnoDB: Compressed tables use zlib 1.2.3 140808 3:43:08 InnoDB: Using Linux native AIO 140808 3:43:08 InnoDB: Initializing buffer pool, size = 5.0G 140808 3:43:08 InnoDB: Completed initialization of buffer pool 140808 3:43:08 InnoDB: highest supported file format is Barracuda. 140808 3:43:09 InnoDB: Waiting for the background threads to start 140808 3:43:10 InnoDB: 5.5.38 started; log sequence number 9794041687 140808 3:43:10 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_recovery_update_relay_log=1' 140808 3:43:10 [ERROR] Aborting 140808 3:43:10 InnoDB: Starting shutdown... 140808 3:43:11 InnoDB: Shutdown completed; log sequence number 9794041687 140808 3:43:11 [Note] /usr/sbin/mysqld: Shutdown complete 140808 03:43:11 mysqld_safe mysqld from pid file /opt/mysql/dbprod/test-p0.pid ended 140808 03:43:58 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/dbdata1/test-p0 140808 3:43:58 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140808 3:43:58 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140808 3:43:58 [Note] Plugin 'FEDERATED' is disabled. 140808 3:43:58 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/auth_pam.so' (errno: 0 /usr/lib64/mysql/plugin/auth_pam.so: cannot open shared object file: No such file or directory) 140808 3:43:58 [Warning] Couldn't load plugin named 'auth_pam' with soname 'auth_pam.so'. 140808 3:43:58 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/auth_pam_compat.so' (errno: 0 /usr/lib64/mysql/plugin/auth_pam_compat.so: cannot open shared object file: No such file or directory) 140808 3:43:58 [Warning] Couldn't load plugin named 'auth_pam_compat' with soname 'auth_pam_compat.so'. 140808 3:43:58 InnoDB: The InnoDB memory heap is disabled 140808 3:43:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140808 3:43:58 InnoDB: Compressed tables use zlib 1.2.3 140808 3:43:58 InnoDB: Using Linux native AIO 140808 3:43:58 InnoDB: Initializing buffer pool, size = 5.0G 140808 3:43:58 InnoDB: Completed initialization of buffer pool 140808 3:43:58 InnoDB: highest supported file format is Barracuda. 140808 3:43:59 InnoDB: Waiting for the background threads to start 140808 3:44:00 InnoDB: 5.5.38 started; log sequence number 9794041687 140808 3:44:00 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_recovery_update_relay_log=1' 140808 3:44:00 [ERROR] Aborting 140808 3:44:00 InnoDB: Starting shutdown... 140808 3:44:01 InnoDB: Shutdown completed; log sequence number 9794041687 140808 3:44:01 [Note] /usr/sbin/mysqld: Shutdown complete 140808 03:44:01 mysqld_safe mysqld from pid file /opt/mysql/dbprod/test-p0.pid ended 140808 03:46:44 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/dbdata1/test-p0 140808 3:46:44 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140808 3:46:44 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140808 3:46:44 [Note] Plugin 'FEDERATED' is disabled. InnoDB: Warning: innodb_overwrite_relay_log_info is enabled. Updates by other storage engines may not be synchronized. 140808 3:46:44 InnoDB: The InnoDB memory heap is disabled 140808 3:46:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140808 3:46:44 InnoDB: Compressed tables use zlib 1.2.3 140808 3:46:44 InnoDB: Using Linux native AIO 140808 3:46:44 InnoDB: Initializing buffer pool, size = 5.0G 140808 3:46:44 InnoDB: Completed initialization of buffer pool 140808 3:46:44 InnoDB: highest supported file format is Barracuda. 140808 3:46:45 InnoDB: Waiting for the background threads to start 140808 3:46:46 Percona XtraDB (http://www.percona.com) 5.5.38-35.2 started; log sequence number 9794041687 InnoDB: something wrong with relay-log.info. InnoDB will not overwrite it. 140808 3:46:46 [Note] Event Scheduler: Loaded 0 events 140808 3:46:46 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.38-35.2-log' socket: '/opt/mysql/dbprod/test-p0.sock' port: 3306 Percona Server (GPL), Release 35.2, Revision 674 140808 3:47:26 [Note] /usr/sbin/mysqld: Normal shutdown 140808 3:47:26 [Note] Event Scheduler: Purging the queue. 0 events 140808 3:47:26 InnoDB: Starting shutdown... 140808 3:47:30 InnoDB: Shutdown completed; log sequence number 9794041687 140808 3:47:30 [Note] /usr/sbin/mysqld: Shutdown complete 140808 03:47:30 mysqld_safe mysqld from pid file /opt/mysql/dbprod/test-p0.pid ended 140808 03:47:58 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/dbdata1/test-p0 140808 3:47:58 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 140808 3:47:58 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 140808 3:47:58 [Note] Plugin 'FEDERATED' is disabled. InnoDB: Warning: innodb_overwrite_relay_log_info is enabled. Updates by other storage engines may not be synchronized. 140808 3:47:58 InnoDB: The InnoDB memory heap is disabled 140808 3:47:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140808 3:47:58 InnoDB: Compressed tables use zlib 1.2.3 140808 3:47:58 InnoDB: Using Linux native AIO 140808 3:47:58 InnoDB: Initializing buffer pool, size = 5.0G 140808 3:47:59 InnoDB: Completed initialization of buffer pool 140808 3:47:59 InnoDB: highest supported file format is Barracuda. 140808 3:47:59 InnoDB: Waiting for the background threads to start 140808 3:48:00 Percona XtraDB (http://www.percona.com) 5.5.38-35.2 started; log sequence number 9794041687 InnoDB: something wrong with relay-log.info. InnoDB will not overwrite it. 140808 3:48:00 [Note] Event Scheduler: Loaded 0 events 140808 3:48:00 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.38-35.2-log' socket: '/opt/mysql/dbprod/test-p0.sock' port: 3306 Percona Server (GPL), Release 35.2, Revision 674