2018-03-10 23:15:54 140621126653920 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded 2018-03-10 23:15:54 140621126653920 [ERROR] /usr/sbin/mysqld: unknown option '--skip-locking' 2018-03-10 23:15:54 140621126653920 [ERROR] Aborting 2018-03-10 23:16:48 139862017468384 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded 2018-03-10 23:16:48 139862017468384 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2018-03-10 23:16:48 139862017468384 [Note] Server socket created on IP: '0.0.0.0'. 2018-03-10 23:16:48 139862017468384 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 2018-03-10 23:20:22 139810027030496 [Note] Server socket created on IP: '0.0.0.0'. 2018-03-10 23:20:22 139810027030496 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-10 23:20:22 139810027030496 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-03-10 23:20:22 139810027030496 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-10 23:20:22 139810027030496 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.13-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-03-10 23:33:32 139810006640384 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-03-10 23:33:32 139810006640384 [Note] Event Scheduler: Purging the queue. 0 events 2018-03-10 23:33:32 139810006640384 [Note] /usr/sbin/mysqld: Shutdown complete 2018-03-10 23:33:34 140351431055328 [ERROR] /usr/sbin/mysqld: unknown variable 'master-user=repl' 2018-03-10 23:33:34 140351431055328 [ERROR] Aborting 2018-03-10 23:34:08 140134165981152 [Note] Server socket created on IP: '0.0.0.0'. 2018-03-10 23:34:08 140134165981152 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-10 23:34:08 140134165981152 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-03-10 23:34:08 140134165981152 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-10 23:34:08 140134165981152 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.13-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-03-11 0:33:13 140134145894144 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=MASTER14-relay-bin' to avoid this problem. 2018-03-11 0:33:13 140134145894144 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='10.20.20.12', master_port='3306', master_log_file='SLAVE18-bin.000001', master_log_pos='4'. 2018-03-11 0:33:19 140134145287936 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000001' at position 4 2018-03-11 18:09:48 140134144984832 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000008' at position 288117922 2018-03-11 18:09:48 140134145287936 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000008', position 288117922 2018-03-11 18:51:40 140134144984832 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-03-11 18:51:40 140134144984832 [Note] Event Scheduler: Purging the queue. 0 events 2018-03-11 18:51:40 140134144984832 [Note] /usr/sbin/mysqld: Shutdown complete 2018-03-11 18:51:43 140216154478560 [Note] Server socket created on IP: '0.0.0.0'. 2018-03-11 18:51:43 140216154478560 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-11 18:51:43 140216154478560 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-03-11 18:51:43 140216154478560 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-11 18:51:43 140216154478560 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=MASTER14-relay-bin' to avoid this problem. 2018-03-11 18:51:43 140216154478560 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.13-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-03-11 18:51:43 140216153863936 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000008' at position 288117922 2018-03-12 0:15:35 140216134391552 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 0:15:35 140216134391552 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 0:15:35 140216134391552 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 0:19:24 140216152954624 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 0:19:24 140216152954624 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 0:19:24 140216152954624 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 2:16:06 140216040179456 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 2:16:06 140216040179456 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 2:16:06 140216040179456 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 2:17:11 140216040179456 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 2:17:11 140216040179456 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 2:17:11 140216040179456 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 2:20:19 140216040179456 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 2:20:19 140216040179456 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 2:20:19 140216040179456 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 2:20:43 140216040179456 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 2:20:43 140216040179456 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-03-12 2:20:43 140216040179456 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-16 20:37:10 140216153863936 [Note] Slave: received end packet from server, apparent master shutdown: 2018-03-16 20:37:10 140216153863936 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SLAVE18-bin.000021' at position 509539363 2018-03-16 20:37:10 140216153863936 [ERROR] Slave I/O: error reconnecting to master 'repluser@10.20.20.12:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on '10.20.20.12' (111 "Connection refused"), Internal MariaDB error code: 2003 2018-03-16 20:39:44 140216153863936 [Note] Slave: received end packet from server, apparent master shutdown: 2018-03-16 20:39:44 140216153863936 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SLAVE18-bin.000022' at position 1352 2018-03-16 20:39:44 140216153863936 [ERROR] Slave I/O: error reconnecting to master 'repluser@10.20.20.12:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on '10.20.20.12' (111 "Connection refused"), Internal MariaDB error code: 2003 2018-03-16 20:45:59 140216153863936 [Note] Slave: received end packet from server, apparent master shutdown: 2018-03-16 20:45:59 140216153863936 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SLAVE18-bin.000023' at position 343 2018-03-16 20:45:59 140216153863936 [ERROR] Slave I/O: error reconnecting to master 'repluser@10.20.20.12:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on '10.20.20.12' (111 "Connection refused"), Internal MariaDB error code: 2003 2018-03-23 21:44:50 140216023205632 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-03-23 21:44:50 140216023205632 [Note] Event Scheduler: Purging the queue. 0 events 2018-03-23 21:44:50 140216153560832 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000040' at position 76028764 2018-03-23 21:44:50 140216153863936 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000040', position 76028764 2018-03-23 21:44:50 140216023205632 [Note] /usr/sbin/mysqld: Shutdown complete 2018-03-23 21:47:19 140492220012512 [Note] Server socket created on IP: '0.0.0.0'. 2018-03-23 21:47:19 140492220012512 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-23 21:47:19 140492220012512 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-03-23 21:47:19 140492220012512 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-23 21:47:19 140492220012512 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=MASTER14-relay-bin' to avoid this problem. 2018-03-23 21:47:19 140492220012512 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.13-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-03-23 21:47:19 140492219397888 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000040' at position 76028764 2018-03-28 3:13:33 140492219094784 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000049' at position 84661428 2018-03-28 3:13:33 140492219397888 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000049', position 84679634 2018-03-28 3:13:53 140492219094784 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-03-28 3:13:53 140492219094784 [Note] Event Scheduler: Purging the queue. 0 events 2018-03-28 3:13:53 140492219094784 [Note] /usr/sbin/mysqld: Shutdown complete 2018-03-28 3:13:55 140165085095904 [ERROR] mysqld: File './MASTER14-bin.000071' not found (Errcode: 2 "No such file or directory") 2018-03-28 3:13:55 140165085095904 [ERROR] Failed to open log (file './MASTER14-bin.000071', errno 2) 2018-03-28 3:13:55 140165085095904 [ERROR] Could not open log file 2018-03-28 3:13:55 140165085095904 [ERROR] Can't init tc log 2018-03-28 3:13:55 140165085095904 [ERROR] Aborting 2018-03-28 3:14:49 139932489373664 [ERROR] I/O error reading the header from the binary log, errno=175, io cache code=0 2018-03-28 3:14:49 139932489373664 [ERROR] I/O error reading the header from the binary log 2018-03-28 3:14:49 139932489373664 [ERROR] Can't init tc log 2018-03-28 3:14:49 139932489373664 [ERROR] Aborting 2018-03-28 3:16:31 140099368044512 [Note] Server socket created on IP: '0.0.0.0'. 2018-03-28 3:16:31 140099368044512 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-28 3:16:31 140099368044512 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-03-28 3:16:31 140099368044512 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-03-28 3:16:31 140099368044512 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=MASTER14-relay-bin' to avoid this problem. 2018-03-28 3:16:31 140099368044512 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.13-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-03-28 3:16:31 140099367429888 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000049' at position 84679634 2018-03-28 3:17:23 140099367126784 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000049' at position 255970115 2018-03-28 3:17:23 140099367429888 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000049', position 255970607 2018-03-28 3:31:19 140099347957504 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000049' at position 255970607 2018-03-30 20:38:35 140099347957504 [Note] Slave: received end packet from server, apparent master shutdown: 2018-03-30 20:38:35 140099347957504 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SLAVE18-bin.000056' at position 365579791 2018-03-30 20:38:35 140099347957504 [ERROR] Slave I/O: error reconnecting to master 'repluser@10.20.20.12:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on '10.20.20.12' (111 "Connection refused"), Internal MariaDB error code: 2003 2018-04-06 20:31:17 140099347957504 [Note] Slave: received end packet from server, apparent master shutdown: 2018-04-06 20:31:17 140099347957504 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SLAVE18-bin.000073' at position 289032097 2018-04-06 20:31:17 140099347957504 [ERROR] Slave I/O: error reconnecting to master 'repluser@10.20.20.12:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on '10.20.20.12' (111 "Connection refused"), Internal MariaDB error code: 2003 2018-04-20 20:31:43 140099347957504 [Note] Slave: received end packet from server, apparent master shutdown: 2018-04-20 20:31:43 140099347957504 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SLAVE18-bin.000106' at position 251199952 2018-04-20 20:31:43 140099347957504 [ERROR] Slave I/O: error reconnecting to master 'repluser@10.20.20.12:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on '10.20.20.12' (111 "Connection refused"), Internal MariaDB error code: 2003 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000072' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000073' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000074' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000075' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000076' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000077' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000078' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000079' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000080' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000081' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000082' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000083' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000084' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000085' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000086' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000087' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000088' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000089' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000090' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000091' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000092' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000093' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000094' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000095' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000096' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000097' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000098' 2018-04-23 13:23:43 140099243136768 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000099' 2018-04-27 20:35:04 140099347957504 [Note] Slave: received end packet from server, apparent master shutdown: 2018-04-27 20:35:04 140099347957504 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SLAVE18-bin.000122' at position 586623058 2018-04-27 20:35:04 140099347957504 [ERROR] Slave I/O: error reconnecting to master 'repluser@10.20.20.12:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on '10.20.20.12' (111 "Connection refused"), Internal MariaDB error code: 2003 2018-05-18 20:31:38 140099347957504 [Note] Slave: received end packet from server, apparent master shutdown: 2018-05-18 20:31:38 140099347957504 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SLAVE18-bin.000170' at position 985044790 2018-05-18 20:31:38 140099347957504 [ERROR] Slave I/O: error reconnecting to master 'repluser@10.20.20.12:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on '10.20.20.12' (111 "Connection refused"), Internal MariaDB error code: 2003 2018-05-18 21:04:59 140099262535424 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-05-18 21:04:59 140099262535424 [Note] Event Scheduler: Purging the queue. 0 events 2018-05-18 21:04:59 140099347654400 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000171' at position 2985048 2018-05-18 21:04:59 140099347957504 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000171', position 2985048 2018-05-18 21:05:01 140099262535424 [Note] /usr/sbin/mysqld: Shutdown complete 2018-05-18 21:05:03 140436493273056 [Note] Server socket created on IP: '0.0.0.0'. 2018-05-18 21:05:03 140436493273056 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-05-18 21:05:03 140436493273056 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-05-18 21:05:03 140436493273056 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-05-18 21:05:03 140436493273056 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=MASTER14-relay-bin' to avoid this problem. 2018-05-18 21:05:03 140436493273056 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.13-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-05-18 21:05:03 140436492658432 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000171' at position 2985048 2018-05-18 21:08:30 140436472882944 [Note] /usr/sbin/mysqld (unknown): Normal shutdown 2018-05-18 21:08:30 140436472882944 [Note] Event Scheduler: Purging the queue. 0 events 2018-05-18 21:08:30 140436492355328 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000171' at position 3306984 2018-05-18 21:08:30 140436492658432 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000171', position 3306984 2018-05-18 21:08:30 140436472882944 [Note] /usr/sbin/mysqld: Shutdown complete 2018-05-18 21:08:32 139919139772384 [Note] Server socket created on IP: '0.0.0.0'. 2018-05-18 21:08:32 139919139772384 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-05-18 21:08:32 139919139772384 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-05-18 21:08:32 139919139772384 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-05-18 21:08:32 139919139772384 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=MASTER14-relay-bin' to avoid this problem. 2018-05-18 21:08:32 139919139772384 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.15-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-05-18 21:08:32 139919139157760 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000171' at position 3306984 2018-05-18 21:29:31 139919119406848 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 2018-05-18 21:29:31 139919119406848 [Note] Event Scheduler: Purging the queue. 0 events 2018-05-18 21:29:31 139919138854656 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000171' at position 4006347 2018-05-18 21:29:31 139919139157760 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000171', position 4006347 2018-05-18 21:29:31 139919119406848 [Note] /usr/sbin/mysqld: Shutdown complete 2018-05-18 21:32:01 140575937517536 [Note] Server socket created on IP: '0.0.0.0'. 2018-05-18 21:32:01 140575937517536 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-05-18 21:32:01 140575937517536 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-05-18 21:32:01 140575937517536 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-05-18 21:32:01 140575937517536 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=MASTER14-relay-bin' to avoid this problem. 2018-05-18 21:32:01 140575937517536 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.15-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-05-18 21:32:01 140575936902912 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000171' at position 4006347 2018-05-25 0:43:00 140575936599808 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000184' at position 925678061 2018-05-25 0:43:00 140575936902912 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000184', position 925678061 2018-05-25 0:43:31 140564858898176 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000184' at position 925678061 2018-05-25 0:59:04 140575825970944 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-05-25 0:59:04 140575825970944 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-05-25 0:59:04 140575825970944 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-05-25 1:04:49 140575936599808 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000184' at position 1021043424 2018-05-25 1:04:49 140564858898176 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000184', position 1021043424 2018-05-25 1:37:50 140575936296704 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000184' at position 1021043424 2018-05-25 1:43:37 140564858898176 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000184' at position 1038524158 2018-05-25 1:43:37 140575936296704 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000184', position 1038524158 2018-05-25 1:43:55 140575936296704 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 2018-05-25 1:43:55 140575936296704 [Note] Event Scheduler: Purging the queue. 0 events 2018-05-25 1:43:55 140575936296704 [Note] /usr/sbin/mysqld: Shutdown complete 2018-05-25 1:43:58 139959668389856 [Note] Server socket created on IP: '0.0.0.0'. 2018-05-25 1:43:58 139959668389856 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-05-25 1:43:58 139959668389856 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-05-25 1:43:58 139959668389856 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-05-25 1:43:58 139959668389856 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=MASTER14-relay-bin' to avoid this problem. 2018-05-25 1:43:58 139959668389856 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.15-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-05-25 1:43:58 139959667775232 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000184' at position 1038524158 2018-05-27 3:35:52 139948594259712 [Note] Detected table cache mutex contention at instance 1: 25% waits. Additional table cache instance activated. Number of instances after activation: 2. 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000110' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000111' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000112' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000113' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000114' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000115' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000116' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000117' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000118' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000119' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000120' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000121' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000122' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000123' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000124' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000125' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000126' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000127' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000128' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000129' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000130' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000131' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000132' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000133' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000134' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000135' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000136' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000137' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000138' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000139' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000140' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000141' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000142' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000143' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000144' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000145' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000146' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000147' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000148' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000149' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000150' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000151' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000152' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000153' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000154' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000155' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000156' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000157' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000158' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000159' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000160' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000161' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000162' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000163' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000164' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000165' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000166' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000167' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000168' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000169' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000170' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000171' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000172' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000173' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000174' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000175' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000176' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000177' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000178' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000179' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000180' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000181' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000182' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000183' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000184' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000185' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000186' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000187' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000188' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000189' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000190' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000191' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000192' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000193' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000194' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000195' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000196' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000197' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000198' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000199' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000200' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000201' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000202' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000203' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000204' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000205' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000206' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000207' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000208' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000209' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000210' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000211' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000212' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000213' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000214' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000215' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000216' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000217' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000218' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000219' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000220' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000221' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000222' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000223' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000224' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000225' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000226' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000227' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000228' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000229' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000230' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000231' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000232' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000233' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000234' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000235' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000236' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000237' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000238' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000239' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000240' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000241' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000242' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000243' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000244' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000245' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000246' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000247' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000248' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000249' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000250' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000251' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000252' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000253' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000254' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000255' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000256' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000257' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000258' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000259' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000260' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000261' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000262' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000263' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000264' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000265' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000266' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000267' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000268' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000269' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000270' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000271' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000272' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000273' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000274' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000275' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000276' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000277' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000278' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000279' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000280' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000281' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000282' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000283' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000284' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000285' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000286' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000287' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000288' 2018-06-09 18:06:11 139948595169024 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000289' 2018-06-15 20:36:30 139959667775232 [Note] Slave: received end packet from server, apparent master shutdown: 2018-06-15 20:36:30 139959667775232 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SLAVE18-bin.000237' at position 725783866 2018-06-15 20:36:30 139959667775232 [ERROR] Slave I/O: error reconnecting to master 'repluser@10.20.20.12:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on '10.20.20.12' (111 "Connection refused"), Internal MariaDB error code: 2003 2018-06-15 20:38:42 139959667775232 [Note] Slave: received end packet from server, apparent master shutdown: 2018-06-15 20:38:42 139959667775232 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SLAVE18-bin.000238' at position 343 2018-06-15 20:38:42 139959667775232 [ERROR] Slave I/O: error reconnecting to master 'repluser@10.20.20.12:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on '10.20.20.12' (111 "Connection refused"), Internal MariaDB error code: 2003 2018-06-15 20:46:32 139959667775232 [Note] Slave: received end packet from server, apparent master shutdown: 2018-06-15 20:46:32 139959667775232 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SLAVE18-bin.000239' at position 343 2018-06-15 20:46:32 139959667775232 [ERROR] Slave I/O: error reconnecting to master 'repluser@10.20.20.12:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on '10.20.20.12' (111 "Connection refused"), Internal MariaDB error code: 2003 2018-06-15 20:57:44 139948608808704 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 2018-06-15 20:57:44 139948608808704 [Note] Event Scheduler: Purging the queue. 0 events 2018-06-15 20:57:44 139959667472128 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000240' at position 343 2018-06-15 20:57:44 139959667775232 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000240', position 343 2018-06-15 20:57:44 139948608808704 [Note] /usr/sbin/mysqld: Shutdown complete 2018-06-15 21:02:34 140040595986400 [Note] Server socket created on IP: '0.0.0.0'. 2018-06-15 21:02:34 140040595986400 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-06-15 21:02:34 140040595986400 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-06-15 21:02:34 140040595986400 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-06-15 21:02:34 140040595986400 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=MASTER14-relay-bin' to avoid this problem. 2018-06-15 21:02:34 140040595986400 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.15-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-06-15 21:02:34 140040595371776 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000240' at position 343 2018-06-15 21:43:37 140040575620864 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-06-15 21:43:37 140040575620864 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-06-15 21:43:37 140040575620864 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-06-16 0:09:38 140040470800128 [Note] Detected table cache mutex contention at instance 1: 34% waits. Additional table cache instance activated. Number of instances after activation: 2. 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000307' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000308' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000309' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000310' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000311' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000312' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000313' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000314' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000315' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000316' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000317' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000318' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000319' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000320' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000321' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000322' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000323' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000324' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000325' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000326' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000327' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000328' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000329' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000330' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000331' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000332' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000333' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000334' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000335' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000336' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000337' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000338' 2018-06-20 4:35:00 140040475043584 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000339' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000348' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000349' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000350' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000351' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000352' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000353' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000354' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000355' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000356' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000357' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000358' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000359' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000360' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000361' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000362' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000363' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000364' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000365' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000366' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000367' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000368' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000369' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000370' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000371' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000372' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000373' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000374' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000375' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000376' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000377' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000378' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000379' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000380' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000381' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000382' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000383' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000384' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000385' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000386' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000387' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000388' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000389' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000390' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000391' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000392' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000393' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000394' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000395' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000396' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000397' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000398' 2018-07-06 10:50:51 140040488986368 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000399' 2018-07-06 20:33:27 140040595371776 [Note] Slave: received end packet from server, apparent master shutdown: 2018-07-06 20:33:27 140040595371776 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'SLAVE18-bin.000289' at position 838609064 2018-07-06 20:33:27 140040595371776 [ERROR] Slave I/O: error reconnecting to master 'repluser@10.20.20.12:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on '10.20.20.12' (111 "Connection refused"), Internal MariaDB error code: 2003 2018-07-12 1:35:33 140040595068672 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000302' at position 8561393 2018-07-12 1:35:33 140040595371776 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000302', position 8561393 2018-07-12 1:43:19 140040484742912 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000302' at position 8561393 2018-07-14 0:07:04 140040468678400 [Note] Detected table cache mutex contention at instance 1: 38% waits. Additional table cache instance activated. Number of instances after activation: 3. 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000424' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000425' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000426' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000427' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000428' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000429' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000430' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000431' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000432' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000433' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000434' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000435' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000436' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000437' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000438' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000439' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000440' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000441' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000442' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000443' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000444' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000445' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000446' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000447' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000448' 2018-07-18 10:51:07 140040575317760 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000449' 2018-07-21 4:48:47 140040490198784 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000454' 2018-07-21 4:48:47 140040490198784 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000455' 2018-07-21 4:48:47 140040490198784 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000456' 2018-07-21 4:48:47 140040490198784 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000457' 2018-07-21 4:48:47 140040490198784 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000458' 2018-07-21 4:48:47 140040490198784 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000459' 2018-07-30 0:35:27 140040484136704 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000344' at position 962889599 2018-07-30 0:35:27 140040484742912 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000344', position 962889799 2018-07-30 0:56:05 140040491411200 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000344' at position 962889799 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000479' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000480' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000481' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000482' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000483' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000484' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000485' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000486' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000487' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000488' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000489' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000490' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000491' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000492' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000493' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000494' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000495' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000496' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000497' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000498' 2018-07-30 13:31:44 140040481105664 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000499' 2018-08-03 21:09:35 140040474437376 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 2018-08-03 21:09:35 140040474437376 [Note] Event Scheduler: Purging the queue. 0 events 2018-08-03 21:09:35 140040464131840 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000357' at position 762474902 2018-08-03 21:09:35 140040491411200 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000357', position 762474902 2018-08-03 21:09:35 140040474437376 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03 21:09:38 139850595518432 [Note] Server socket created on IP: '0.0.0.0'. 2018-08-03 21:09:38 139850595518432 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-08-03 21:09:38 139850595518432 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-08-03 21:09:38 139850595518432 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-08-03 21:09:38 139850595518432 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=MASTER14-relay-bin' to avoid this problem. 2018-08-03 21:09:38 139850595518432 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.16-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-08-03 21:09:38 139850594903808 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000357' at position 762474902 2018-08-03 21:11:31 139850594600704 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000357' at position 762624381 2018-08-03 21:11:31 139850594903808 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000357', position 762624381 2018-08-03 21:11:38 139850594903808 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 2018-08-03 21:11:38 139850594903808 [Note] Event Scheduler: Purging the queue. 0 events 2018-08-03 21:11:38 139850594903808 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03 21:14:08 139970597644256 [Note] Server socket created on IP: '0.0.0.0'. 2018-08-03 21:14:08 139970597644256 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-08-03 21:14:08 139970597644256 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-08-03 21:14:08 139970597644256 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-08-03 21:14:08 139970597644256 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=MASTER14-relay-bin' to avoid this problem. 2018-08-03 21:14:08 139970597644256 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.16-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-08-03 21:14:08 139970597029632 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000357' at position 762624381 2018-08-04 0:07:48 139959541794560 [Note] Detected table cache mutex contention at instance 1: 55% waits. Additional table cache instance activated. Number of instances after activation: 2. 2018-08-20 0:41:22 139970596726528 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000394' at position 1014218238 2018-08-20 0:41:22 139970597029632 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000394', position 1014218238 2018-08-20 0:56:27 139959544522496 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000394' at position 1014218238 2018-08-20 0:56:28 139970506024704 [ERROR] Slave SQL: Error 'Duplicate entry '816732' for key 'PRIMARY'' on query. Default database: 'cvt'. Query: 'INSERT INTO location SET sdesc = 'Emailed by Carlos', ldesc = '', type = 'R', addressid = '368040', storenbr = '08/20/18', effdate = now()', Gtid 0-18-901540841, Internal MariaDB error code: 1062 2018-08-20 0:56:28 139970506024704 [Warning] Slave: Data truncated for column 'effdate' at row 1 Error_code: 1265 2018-08-20 0:56:28 139970506024704 [Warning] Slave: Duplicate entry '816732' for key 'PRIMARY' Error_code: 1062 2018-08-20 0:56:28 139970506024704 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'SLAVE18-bin.000394' position 1014223492 2018-08-20 0:56:28 139970506024704 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000394' at position 1014223492 2018-08-20 1:23:11 139959544522496 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 2018-08-20 1:23:11 139959544522496 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000395', position 61852184 2018-08-20 1:23:23 139959539672832 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000395' at position 61852184 2018-08-20 1:23:23 139959537248000 [Note] 'SQL_SLAVE_SKIP_COUNTER=1' executed at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='5810', master_log_name='SLAVE18-bin.000394', master_log_pos='1014223492' and new position at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='6188', master_log_name='SLAVE18-bin.000394', master_log_pos='1014223870' 2018-08-20 1:23:23 139959537248000 [ERROR] Slave SQL: Error 'Duplicate entry '816723' for key 'PRIMARY'' on query. Default database: 'cvt'. Query: 'INSERT INTO locationlink(companyid, locationid) VALUES(200865, 816732)', Gtid 0-18-901540842, Internal MariaDB error code: 1062 2018-08-20 1:23:23 139959537248000 [Warning] Slave: Duplicate entry '816723' for key 'PRIMARY' Error_code: 1062 2018-08-20 1:23:23 139959537248000 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'SLAVE18-bin.000394' position 1014223870 2018-08-20 1:23:23 139959537248000 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000394' at position 1014223870 2018-08-20 1:23:32 139959539672832 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 2018-08-20 1:23:32 139959539672832 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000395', position 61910202 2018-08-20 1:23:32 139959546947328 [Note] 'SQL_SLAVE_SKIP_COUNTER=1' executed at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='6188', master_log_name='SLAVE18-bin.000394', master_log_pos='1014223870' and new position at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='6436', master_log_name='SLAVE18-bin.000394', master_log_pos='1014224118' 2018-08-20 1:23:32 139959539672832 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000395' at position 61910202 2018-08-20 1:23:32 139959546947328 [ERROR] Slave SQL: Error 'Duplicate entry '2600246' for key 'PRIMARY'' on query. Default database: 'cvt'. Query: 'INSERT INTO standardroutes(routeid,locationid,normalroute) VALUES(18205,816732,'Y')', Gtid 0-18-901540845, Internal MariaDB error code: 1062 2018-08-20 1:23:32 139959546947328 [Warning] Slave: Duplicate entry '2600246' for key 'PRIMARY' Error_code: 1062 2018-08-20 1:23:32 139959546947328 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'SLAVE18-bin.000394' position 1014224874 2018-08-20 1:23:32 139959546947328 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000394' at position 1014224874 2018-08-20 1:23:38 139959539672832 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 2018-08-20 1:23:38 139959539672832 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000395', position 61915386 2018-08-20 1:23:38 139959539672832 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000395' at position 61915386 2018-08-20 1:23:38 139959546947328 [Note] 'SQL_SLAVE_SKIP_COUNTER=1' executed at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='7192', master_log_name='SLAVE18-bin.000394', master_log_pos='1014224874' and new position at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='7446', master_log_name='SLAVE18-bin.000394', master_log_pos='1014225128' 2018-08-20 1:23:39 139959546947328 [ERROR] Slave SQL: Error 'Duplicate entry '4426401' for key 'PRIMARY'' on query. Default database: 'cvt'. Query: 'INSERT INTO locationcomment(clientlocid,locationid, datetm, comment, personid, type, notifyflag) values('301049','816732',now(),'New Room Added in CUS11','206219','SM','N')', Gtid 0-18-901542047, Internal MariaDB error code: 1062 2018-08-20 1:23:39 139959546947328 [Warning] Slave: Duplicate entry '4426401' for key 'PRIMARY' Error_code: 1062 2018-08-20 1:23:39 139959546947328 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'SLAVE18-bin.000394' position 1014507481 2018-08-20 1:23:39 139959546947328 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000394' at position 1014507481 2018-08-20 1:23:43 139959539672832 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 2018-08-20 1:23:43 139959539672832 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000395', position 61917686 2018-08-20 1:23:43 139959548765952 [Note] 'SQL_SLAVE_SKIP_COUNTER=1' executed at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='289799', master_log_name='SLAVE18-bin.000394', master_log_pos='1014507481' and new position at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='290163', master_log_name='SLAVE18-bin.000394', master_log_pos='1014507845' 2018-08-20 1:23:43 139959539672832 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000395' at position 61917686 2018-08-20 1:23:43 139959548765952 [ERROR] Slave SQL: Error 'Duplicate entry '4426402' for key 'PRIMARY'' on query. Default database: 'cvt'. Query: 'INSERT INTO locationcomment(clientlocid,locationid, datetm, comment, personid, type, notifyflag) values('301049','816732',now(),'New Draw Added: Pub = NYMM; From Date = 08/20/18; To Date = 08/20/18; Copies = 1/0/0/0/0/0/0; Price Code = Mandarin Oriental ','206219','SM','N')', Gtid 0-18-901542089, Internal MariaDB error code: 1062 2018-08-20 1:23:43 139959548765952 [Warning] Slave: Duplicate entry '4426402' for key 'PRIMARY' Error_code: 1062 2018-08-20 1:23:43 139959548765952 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'SLAVE18-bin.000394' position 1014520944 2018-08-20 1:23:43 139959548765952 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000394' at position 1014520944 2018-08-20 1:23:50 139959539672832 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 2018-08-20 1:23:50 139959539672832 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000395', position 61925130 2018-08-20 1:23:50 139959548765952 [Note] 'SQL_SLAVE_SKIP_COUNTER=1' executed at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='303262', master_log_name='SLAVE18-bin.000394', master_log_pos='1014520944' and new position at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='303727', master_log_name='SLAVE18-bin.000394', master_log_pos='1014521409' 2018-08-20 1:23:50 139959539672832 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000395' at position 61925130 2018-08-20 1:23:50 139959548765952 [ERROR] Slave SQL: Error 'Duplicate entry '816733' for key 'PRIMARY'' on query. Default database: 'cvt'. Query: 'INSERT INTO location SET sdesc = 'Emailed by Paul', ldesc = '', type = 'R', addressid = '582193', storenbr = '08/20/18', effdate = now()', Gtid 0-18-901543266, Internal MariaDB error code: 1062 2018-08-20 1:23:50 139959548765952 [Warning] Slave: Data truncated for column 'effdate' at row 1 Error_code: 1265 2018-08-20 1:23:50 139959548765952 [Warning] Slave: Duplicate entry '816733' for key 'PRIMARY' Error_code: 1062 2018-08-20 1:23:50 139959548765952 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'SLAVE18-bin.000394' position 1014960679 2018-08-20 1:23:50 139959548765952 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000394' at position 1014960679 2018-08-20 1:23:55 139959539672832 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 2018-08-20 1:23:55 139959539672832 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000395', position 61934667 2018-08-20 1:23:55 139959537248000 [Note] 'SQL_SLAVE_SKIP_COUNTER=1' executed at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='742997', master_log_name='SLAVE18-bin.000394', master_log_pos='1014960679' and new position at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='743373', master_log_name='SLAVE18-bin.000394', master_log_pos='1014961055' 2018-08-20 1:23:55 139959539672832 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000395' at position 61934667 2018-08-20 1:23:55 139959537248000 [ERROR] Slave SQL: Error 'Duplicate entry '816724' for key 'PRIMARY'' on query. Default database: 'cvt'. Query: 'INSERT INTO locationlink(companyid, locationid) VALUES(325765, 816733)', Gtid 0-18-901543267, Internal MariaDB error code: 1062 2018-08-20 1:23:55 139959537248000 [Warning] Slave: Duplicate entry '816724' for key 'PRIMARY' Error_code: 1062 2018-08-20 1:23:55 139959537248000 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'SLAVE18-bin.000394' position 1014961055 2018-08-20 1:23:55 139959537248000 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000394' at position 1014961055 2018-08-20 1:23:58 139959539672832 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 2018-08-20 1:23:58 139959539672832 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000395', position 61934881 2018-08-20 1:23:58 139959541491456 [Note] 'SQL_SLAVE_SKIP_COUNTER=1' executed at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='743373', master_log_name='SLAVE18-bin.000394', master_log_pos='1014961055' and new position at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='743621', master_log_name='SLAVE18-bin.000394', master_log_pos='1014961303' 2018-08-20 1:23:58 139959539672832 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000395' at position 61934881 2018-08-20 1:23:58 139959541491456 [ERROR] Slave SQL: Error 'Duplicate entry '2600247' for key 'PRIMARY'' on query. Default database: 'cvt'. Query: 'INSERT INTO standardroutes(routeid,locationid,normalroute) VALUES(18205,816733,'Y')', Gtid 0-18-901543270, Internal MariaDB error code: 1062 2018-08-20 1:23:58 139959541491456 [Warning] Slave: Duplicate entry '2600247' for key 'PRIMARY' Error_code: 1062 2018-08-20 1:23:58 139959541491456 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'SLAVE18-bin.000394' position 1014962059 2018-08-20 1:23:58 139959541491456 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000394' at position 1014962059 2018-08-20 1:24:02 139959539672832 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 2018-08-20 1:24:02 139959539672832 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000395', position 61935458 2018-08-20 1:24:02 139959539672832 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000395' at position 61935458 2018-08-20 1:24:02 139959544522496 [Note] 'SQL_SLAVE_SKIP_COUNTER=1' executed at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='744377', master_log_name='SLAVE18-bin.000394', master_log_pos='1014962059' and new position at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='744631', master_log_name='SLAVE18-bin.000394', master_log_pos='1014962313' 2018-08-20 1:24:03 139959544522496 [ERROR] Slave SQL: Error 'Duplicate entry '4426403' for key 'PRIMARY'' on query. Default database: 'cvt'. Query: 'INSERT INTO locationcomment(clientlocid,locationid, datetm, comment, personid, type, notifyflag) values('301049','816733',now(),'New Room Added in CUS11','206219','SM','N')', Gtid 0-18-901544734, Internal MariaDB error code: 1062 2018-08-20 1:24:03 139959544522496 [Warning] Slave: Duplicate entry '4426403' for key 'PRIMARY' Error_code: 1062 2018-08-20 1:24:03 139959544522496 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'SLAVE18-bin.000394' position 1015312379 2018-08-20 1:24:03 139959544522496 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000394' at position 1015312379 2018-08-20 1:24:07 139959539672832 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 2018-08-20 1:24:07 139959539672832 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000395', position 61935821 2018-08-20 1:24:07 139959544522496 [Note] 'SQL_SLAVE_SKIP_COUNTER=1' executed at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='1094697', master_log_name='SLAVE18-bin.000394', master_log_pos='1015312379' and new position at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='1095061', master_log_name='SLAVE18-bin.000394', master_log_pos='1015312743' 2018-08-20 1:24:07 139959539672832 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000395' at position 61935821 2018-08-20 1:24:08 139959544522496 [ERROR] Slave SQL: Error 'Duplicate entry '4426404' for key 'PRIMARY'' on query. Default database: 'cvt'. Query: 'INSERT INTO locationcomment(clientlocid,locationid, datetm, comment, personid, type, notifyflag) values('301049','816733',now(),'New Draw Added: Pub = TTMES; From Date = 08/20/18; To Date = 08/20/18; Copies = 5/0/0/0/0/0/0; Price Code = Greenwich Hotel ','206219','SM','N')', Gtid 0-18-901548247, Internal MariaDB error code: 1062 2018-08-20 1:24:08 139959544522496 [Warning] Slave: Duplicate entry '4426404' for key 'PRIMARY' Error_code: 1062 2018-08-20 1:24:08 139959544522496 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'SLAVE18-bin.000394' position 1016737492 2018-08-20 1:24:08 139959544522496 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000394' at position 1016737492 2018-08-20 1:24:14 139959539672832 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 2018-08-20 1:24:14 139959539672832 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000395', position 62375797 2018-08-20 1:24:14 139970510874368 [Note] 'SQL_SLAVE_SKIP_COUNTER=1' executed at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='2519810', master_log_name='SLAVE18-bin.000394', master_log_pos='1016737492' and new position at relay_log_file='./MASTER14-relay-bin.001179', relay_log_pos='2520274', master_log_name='SLAVE18-bin.000394', master_log_pos='1016737956' 2018-08-20 1:24:14 139959539672832 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000395' at position 62375797 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000571' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000572' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000573' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000574' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000575' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000576' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000577' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000578' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000579' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000580' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000581' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000582' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000583' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000584' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000585' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000586' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000587' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000588' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000589' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000590' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000591' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000592' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000593' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000594' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000595' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000596' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000597' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000598' 2018-08-24 16:44:53 139970512996096 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000599' 2018-08-31 20:59:02 139970512996096 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 2018-08-31 20:59:02 139970512996096 [Note] Event Scheduler: Purging the queue. 0 events 2018-08-31 20:59:02 139970510874368 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000425' at position 907555501 2018-08-31 20:59:02 139959539672832 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000425', position 907555501 2018-08-31 20:59:03 139970512996096 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000602' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000603' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000604' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000605' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000606' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000607' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000608' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000609' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000610' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000611' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000612' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000613' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000614' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000615' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000616' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000617' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000618' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000619' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000620' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000621' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000622' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000623' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000624' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000625' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000626' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000627' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000628' 2018-08-31 20:59:05 139772674521056 [Note] Failed to execute mysql_file_stat on file './MASTER14-bin.000629' 2018-08-31 20:59:05 139772674521056 [Note] Server socket created on IP: '0.0.0.0'. 2018-08-31 20:59:05 139772674521056 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-08-31 20:59:05 139772674521056 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-08-31 20:59:05 139772674521056 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-08-31 20:59:05 139772674521056 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=MASTER14-relay-bin' to avoid this problem. 2018-08-31 20:59:06 139772674521056 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.17-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-08-31 20:59:06 139772673906432 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000425' at position 907555501 2018-08-31 21:02:11 139772591085312 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-08-31 21:02:11 139772591085312 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-08-31 21:02:11 139772591085312 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-08-31 21:02:24 139772590782208 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown 2018-08-31 21:02:24 139772590782208 [Note] Event Scheduler: Purging the queue. 0 events 2018-08-31 21:02:24 139772673603328 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000425' at position 907845207 2018-08-31 21:02:24 139772673906432 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000425', position 907845207 2018-08-31 21:02:24 139772590782208 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-31 21:04:52 140193152403424 [Note] Server socket created on IP: '0.0.0.0'. 2018-08-31 21:04:52 140193152403424 [Warning] 'user' entry 'root@MASTER14' ignored in --skip-name-resolve mode. 2018-08-31 21:04:52 140193152403424 [Warning] 'user' entry '@MASTER14' ignored in --skip-name-resolve mode. 2018-08-31 21:04:52 140193152403424 [Warning] 'proxies_priv' entry '@% root@MASTER14' ignored in --skip-name-resolve mode. 2018-08-31 21:04:52 140193152403424 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=MASTER14-relay-bin' to avoid this problem. 2018-08-31 21:04:52 140193152403424 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.2.17-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2018-08-31 21:04:52 140193151788800 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000425' at position 907845207 2018-09-01 0:10:08 140193066239744 [Note] Detected table cache mutex contention at instance 1: 25% waits. Additional table cache instance activated. Number of instances after activation: 2. 2018-09-07 1:22:20 140193151485696 [Note] Slave SQL thread exiting, replication stopped in log 'SLAVE18-bin.000439' at position 1070594887 2018-09-07 1:22:20 140193151788800 [Note] Slave I/O thread exiting, read up to log 'SLAVE18-bin.000439', position 1070594887 2018-09-07 1:29:00 140193045325568 [Note] Slave I/O thread: connected to master 'repluser@10.20.20.12:3306',replication started in log 'SLAVE18-bin.000439' at position 1070594887