2018-05-14T04:36:42.144024Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-05-14T04:36:42.480260Z 0 [Warning] You need to use --log-bin to make --log-slave-updates work. 2018-05-14T04:36:42.480275Z 0 [Warning] You need to use --log-bin to make --binlog-format work. 100 100 2018-05-14T04:37:06.135069Z 0 [Warning] InnoDB: New log files created, LSN=45790 2018-05-14T04:37:07.652259Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2018-05-14T04:37:07.892497Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 75aa0a2c-5730-11e8-9eb4-000d3a068798. 2018-05-14T04:37:07.903117Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2018-05-14T04:37:07.943092Z 1 [Note] A temporary password is generated for root@localhost: (T8HaB2cw/kf 2018-05-14T04:37:23.892354Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-05-14T04:37:23.895210Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-log) starting as process 11512 ... 2018-05-14T04:37:24.392975Z 0 [Warning] You need to use --log-bin to make --log-slave-updates work. 2018-05-14T04:37:24.392987Z 0 [Warning] You need to use --log-bin to make --binlog-format work. 2018-05-14T04:37:24.642318Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-05-14T04:37:24.642367Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-05-14T04:37:24.642378Z 0 [Note] InnoDB: Uses event mutexes 2018-05-14T04:37:24.642387Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2018-05-14T04:37:24.642394Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-05-14T04:37:24.642400Z 0 [Note] InnoDB: Using Linux native AIO 2018-05-14T04:37:24.643236Z 0 [Note] InnoDB: Number of pools: 1 2018-05-14T04:37:24.742589Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-05-14T04:37:24.748447Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-05-14T04:37:24.808058Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-05-14T04:37:24.810836Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-05-14T04:37:24.949415Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-05-14T04:37:25.749426Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-05-14T04:37:25.749499Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-05-14T04:37:26.847075Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-05-14T04:37:26.848213Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-05-14T04:37:26.848228Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-05-14T04:37:26.848525Z 0 [Note] InnoDB: Waiting for purge to start 2018-05-14T04:37:26.902284Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 2552453 2018-05-14T04:37:26.903240Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-05-14T04:37:26.903744Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql_data/mysql/ib_buffer_pool 2018-05-14T04:37:27.007865Z 0 [Note] Plugin 'validate_password' is disabled. 2018-05-14T04:37:27.045912Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-05-14T04:37:27.046593Z 0 [Warning] CA certificate ca.pem is self signed. 2018-05-14T04:37:27.048329Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2018-05-14T04:37:27.048365Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2018-05-14T04:37:27.048409Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2018-05-14T04:37:27.327005Z 0 [ERROR] /usr/sbin/mysqld: slave_preserve_commit_order is not supported unless both log_bin and log_slave_updates are enabled. 2018-05-14T04:37:27.327041Z 0 [Note] Some of the channels are not created/initialized properly. Check for additional messages above. You will not be able to start replication on those channels until the issue is resolved and the server restarted. 2018-05-14T04:37:27.334156Z 0 [Note] Event Scheduler: Loaded 0 events 2018-05-14T04:37:27.334308Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.21-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2018-05-14T04:37:27.377345Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180514 4:37:27 2018-05-14T04:37:27.743683Z 2 [Note] Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO) 2018-05-14T04:38:03.482942Z 3 [Note] Access denied for user 'root'@'localhost' (using password: YES) 2018-05-14T04:40:02.679930Z 5 [Note] Access denied for user 'root'@'localhost' (using password: YES) 2018-05-14T04:40:10.410597Z 0 [Note] Giving 0 client threads a chance to die gracefully 2018-05-14T04:40:10.410621Z 0 [Note] Shutting down slave threads 2018-05-14T04:40:10.410631Z 0 [Note] Forcefully disconnecting 0 remaining clients 2018-05-14T04:40:10.410640Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2018-05-14T04:40:10.411242Z 0 [Note] Binlog end 2018-05-14T04:40:10.412014Z 0 [Note] Shutting down plugin 'rpl_semi_sync_slave' 2018-05-14T04:40:10.412035Z 0 [Note] Shutting down plugin 'rpl_semi_sync_master' 2018-05-14T04:40:10.412047Z 0 [Note] unregister_replicator OK 2018-05-14T04:40:10.412052Z 0 [Note] Shutting down plugin 'ngram' 2018-05-14T04:40:10.412056Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-05-14T04:40:10.412061Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-05-14T04:40:10.412066Z 0 [Note] Shutting down plugin 'partition' 2018-05-14T04:40:10.412071Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-05-14T04:40:10.412076Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-05-14T04:40:10.412080Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-05-14T04:40:10.412101Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-05-14T04:40:10.412106Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-05-14T04:40:10.412134Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-05-14T04:40:10.412138Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-05-14T04:40:10.412144Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-05-14T04:40:10.412149Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-05-14T04:40:10.412154Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-05-14T04:40:10.412174Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-05-14T04:40:10.412178Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-05-14T04:40:10.412183Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-05-14T04:40:10.412187Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-05-14T04:40:10.412192Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-05-14T04:40:10.412212Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-05-14T04:40:10.412216Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-05-14T04:40:10.412236Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-05-14T04:40:10.412241Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-05-14T04:40:10.412245Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-05-14T04:40:10.412249Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-05-14T04:40:10.412253Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-05-14T04:40:10.412258Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-05-14T04:40:10.412262Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-05-14T04:40:10.412266Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-05-14T04:40:10.412271Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-05-14T04:40:10.412291Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-05-14T04:40:10.412296Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-05-14T04:40:10.412300Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-05-14T04:40:10.412311Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-05-14T04:40:10.412330Z 0 [Note] Shutting down plugin 'InnoDB' 2018-05-14T04:40:10.412523Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-05-14T04:40:10.412619Z 0 [Note] InnoDB: Starting shutdown... 2018-05-14T04:40:10.512939Z 0 [Note] InnoDB: Dumping buffer pool(s) to /mysql_data/mysql/ib_buffer_pool 2018-05-14T04:40:10.513120Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180514 4:40:10 2018-05-14T04:40:12.089366Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2560401 2018-05-14T04:40:12.089589Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-05-14T04:40:12.089602Z 0 [Note] Shutting down plugin 'MEMORY' 2018-05-14T04:40:12.089610Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-05-14T04:40:12.089637Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-05-14T04:40:12.089646Z 0 [Note] Shutting down plugin 'MyISAM' 2018-05-14T04:40:12.089657Z 0 [Note] Shutting down plugin 'CSV' 2018-05-14T04:40:12.089665Z 0 [Note] Shutting down plugin 'sha256_password' 2018-05-14T04:40:12.089670Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-05-14T04:40:12.089909Z 0 [Note] Shutting down plugin 'binlog' 2018-05-14T04:40:12.114706Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-05-14T04:43:55.703677Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-05-14T04:43:55.705896Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-log) starting as process 12283 ... 2018-05-14T04:43:55.722789Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-05-14T04:43:55.722815Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-05-14T04:43:55.722825Z 0 [Note] InnoDB: Uses event mutexes 2018-05-14T04:43:55.722834Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2018-05-14T04:43:55.722841Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-05-14T04:43:55.722847Z 0 [Note] InnoDB: Using Linux native AIO 2018-05-14T04:43:55.723131Z 0 [Note] InnoDB: Number of pools: 1 2018-05-14T04:43:55.723264Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-05-14T04:43:55.733275Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-05-14T04:43:55.744969Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-05-14T04:43:55.748571Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-05-14T04:43:56.102697Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-05-14T04:43:57.158243Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-05-14T04:43:57.158315Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-05-14T04:43:58.204862Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-05-14T04:43:58.205975Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-05-14T04:43:58.205990Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-05-14T04:43:58.206276Z 0 [Note] InnoDB: Waiting for purge to start 2018-05-14T04:43:58.259908Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 2560401 2018-05-14T04:43:58.260224Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-05-14T04:43:58.265064Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql_data/mysql/ib_buffer_pool 2018-05-14T04:43:58.576404Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-05-14T04:43:58.576701Z 0 [Warning] CA certificate ca.pem is self signed. 2018-05-14T04:43:58.578057Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2018-05-14T04:43:58.578102Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2018-05-14T04:43:58.578133Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2018-05-14T04:43:58.761328Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-05-14T04:43:58.761401Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-05-14T04:43:58.761441Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-05-14T04:43:58.761448Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-05-14T04:43:58.762528Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-05-14T04:43:58.762546Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-05-14T04:43:58.833536Z 0 [Note] Event Scheduler: Loaded 0 events 2018-05-14T04:43:58.833773Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.21-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2018-05-14T04:43:58.910914Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180514 4:43:58 2018-05-14T04:44:03.092352Z 15 [Note] 'CHANGE MASTER TO FOR CHANNEL '' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='172.19.0.12', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. 2018-05-14T04:44:06.211536Z 18 [Note] Slave I/O thread: Start semi-sync replication to master 'repl_user@172.19.0.12:3306' in log 'FIRST' at position 4 2018-05-14T04:44:06.211571Z 18 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2018-05-14T04:44:06.237533Z 18 [Note] Slave I/O thread for channel '': connected to master 'repl_user@172.19.0.12:3306',replication started in log 'FIRST' at position 4 2018-05-14T04:44:06.791074Z 19 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'FIRST' at position 0, relay log './relay-log-slave.000001' position: 4 2018-05-14T05:13:40.564782Z 18 [ERROR] Error reading packet from server for channel '': Lost connection to MySQL server during query (server_errno=2013) 2018-05-14T05:13:40.564823Z 18 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000001' at position 491 for channel '' 2018-05-14T05:13:40.564835Z 18 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2018-05-14T05:49:35.532113Z 18 [Note] Slave I/O thread killed while reading event for channel '' 2018-05-14T05:49:35.582150Z 18 [Note] Slave I/O thread exiting for channel '', read up to log 'mysql-bin.000001', position 491 2018-05-14T05:49:40.282178Z 592 [Note] Aborted connection 592 to db: 'unconnected' user: 'repl_user' host: 'localhost' (Got an error writing communication packets) 2018-05-14T05:49:58.429031Z 19 [Note] Error reading relay log event for channel '': slave SQL thread was killed 2018-05-14T05:51:26.232574Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5002ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) 2018-05-14T05:52:05.782837Z 0 [Note] Giving 1 client threads a chance to die gracefully 2018-05-14T05:52:05.782881Z 0 [Note] Shutting down slave threads 2018-05-14T05:52:07.832589Z 0 [Note] Forcefully disconnecting 1 remaining clients 2018-05-14T05:52:07.832640Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 293 user: 'root' 2018-05-14T05:52:07.832908Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2018-05-14T05:52:08.032464Z 0 [Note] Binlog end 2018-05-14T05:52:08.386880Z 0 [Note] Shutting down plugin 'validate_password' 2018-05-14T05:52:08.386956Z 0 [Note] Shutting down plugin 'rpl_semi_sync_slave' 2018-05-14T05:52:08.386967Z 0 [Note] Shutting down plugin 'rpl_semi_sync_master' 2018-05-14T05:52:08.432616Z 0 [Note] unregister_replicator OK 2018-05-14T05:52:08.432652Z 0 [Note] Shutting down plugin 'ngram' 2018-05-14T05:52:08.432657Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-05-14T05:52:08.432672Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-05-14T05:52:08.432677Z 0 [Note] Shutting down plugin 'partition' 2018-05-14T05:52:08.432682Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-05-14T05:52:08.432690Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-05-14T05:52:08.432694Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-05-14T05:52:08.432699Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-05-14T05:52:08.432704Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-05-14T05:52:08.432708Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-05-14T05:52:08.432713Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-05-14T05:52:08.432718Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-05-14T05:52:08.432722Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-05-14T05:52:08.432726Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-05-14T05:52:08.432730Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-05-14T05:52:08.432735Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-05-14T05:52:08.432739Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-05-14T05:52:08.432743Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-05-14T05:52:08.432747Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-05-14T05:52:08.432752Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-05-14T05:52:08.432756Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-05-14T05:52:08.432760Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-05-14T05:52:08.432764Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-05-14T05:52:08.432769Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-05-14T05:52:08.432773Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-05-14T05:52:08.432777Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-05-14T05:52:08.432781Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-05-14T05:52:08.432785Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-05-14T05:52:08.432789Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-05-14T05:52:08.432794Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-05-14T05:52:08.432798Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-05-14T05:52:08.432802Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-05-14T05:52:08.432807Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-05-14T05:52:08.432811Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-05-14T05:52:08.432815Z 0 [Note] Shutting down plugin 'InnoDB' 2018-05-14T05:52:08.434401Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-05-14T05:52:08.482577Z 0 [Note] InnoDB: Starting shutdown... 2018-05-14T05:52:08.610347Z 0 [Note] InnoDB: Dumping buffer pool(s) to /mysql_data/mysql/ib_buffer_pool 2018-05-14T05:52:08.640184Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180514 5:52:08 2018-05-14T05:52:18.632929Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2610316 2018-05-14T05:52:18.633613Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-05-14T05:52:18.633627Z 0 [Note] Shutting down plugin 'MEMORY' 2018-05-14T05:52:18.633635Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-05-14T05:52:18.635214Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-05-14T05:52:18.635233Z 0 [Note] Shutting down plugin 'MyISAM' 2018-05-14T05:52:18.636099Z 0 [Note] Shutting down plugin 'CSV' 2018-05-14T05:52:18.636160Z 0 [Note] Shutting down plugin 'sha256_password' 2018-05-14T05:52:18.636168Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-05-14T05:52:18.636695Z 0 [Note] Shutting down plugin 'binlog' 2018-05-14T05:52:18.684236Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-05-14T05:52:55.395054Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-05-14T05:52:55.397009Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-log) starting as process 39167 ... 2018-05-14T05:52:55.832864Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-05-14T05:52:55.832905Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-05-14T05:52:55.832915Z 0 [Note] InnoDB: Uses event mutexes 2018-05-14T05:52:55.832924Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2018-05-14T05:52:55.832930Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-05-14T05:52:55.832936Z 0 [Note] InnoDB: Using Linux native AIO 2018-05-14T05:52:55.833279Z 0 [Note] InnoDB: Number of pools: 1 2018-05-14T05:52:55.833433Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-05-14T05:52:55.842499Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-05-14T05:52:55.854215Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-05-14T05:52:55.856745Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-05-14T05:52:56.166067Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-05-14T05:52:57.501916Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-05-14T05:52:57.502805Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-05-14T05:52:58.623523Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-05-14T05:52:58.624868Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-05-14T05:52:58.624882Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-05-14T05:52:58.625108Z 0 [Note] InnoDB: Waiting for purge to start 2018-05-14T05:52:58.679731Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 2610316 2018-05-14T05:52:58.680025Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-05-14T05:52:58.680332Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql_data/mysql/ib_buffer_pool 2018-05-14T05:52:59.605006Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180514 5:52:59 2018-05-14T05:52:59.881960Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2018-05-14T05:52:59.923207Z 0 [Warning] CA certificate ca.pem is self signed. 2018-05-14T05:52:59.924542Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2018-05-14T05:52:59.924585Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2018-05-14T05:52:59.924618Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2018-05-14T05:53:00.082591Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-05-14T05:53:00.082667Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-05-14T05:53:00.106766Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-05-14T05:53:00.106793Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-05-14T05:53:00.222540Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-05-14T05:53:00.222576Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-05-14T05:53:00.811284Z 0 [Note] Event Scheduler: Loaded 0 events 2018-05-14T05:53:00.811498Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.21-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2018-05-14T05:53:10.102860Z 14 [Note] 'CHANGE MASTER TO FOR CHANNEL '' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='172.19.0.12', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. 2018-05-14T05:53:13.266343Z 17 [Note] Slave I/O thread: Start semi-sync replication to master 'repl_user@172.19.0.12:3306' in log 'FIRST' at position 4 2018-05-14T05:53:13.266407Z 17 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2018-05-14T05:53:13.354129Z 17 [Note] Slave I/O thread for channel '': connected to master 'repl_user@172.19.0.12:3306',replication started in log 'FIRST' at position 4 2018-05-14T05:53:14.236132Z 18 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'FIRST' at position 0, relay log './relay-log-slave.000001' position: 4 2018-05-14T05:55:54.710012Z 73 [Note] Aborted connection 73 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T05:55:54.711672Z 72 [Note] Aborted connection 72 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T05:56:15.262734Z 17 [Note] Slave I/O thread killed while reading event for channel '' 2018-05-14T05:56:15.262751Z 17 [Note] Slave I/O thread exiting for channel '', read up to log 'mysql-bin.000002', position 194 2018-05-14T05:56:15.331251Z 18 [Note] Error reading relay log event for channel '': slave SQL thread was killed 2018-05-14T05:58:26.468815Z 110 [Note] Semi-sync replication initialized for transactions. 2018-05-14T05:58:26.468834Z 110 [Note] Semi-sync replication enabled on the master. 2018-05-14T05:58:26.469587Z 0 [Note] Starting ack receiver thread 2018-05-14T05:58:30.906954Z 113 [Note] Start binlog_dump to master_thread_id(113) slave_server(111), pos(, 4) 2018-05-14T05:58:30.907002Z 113 [Note] Start semi-sync binlog_dump to slave (server_id: 111), pos(, 4) 2018-05-14T05:59:55.230472Z 134 [Note] Aborted connection 134 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:05:25.626009Z 288 [Note] Aborted connection 288 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:05:25.628516Z 266 [Note] Aborted connection 266 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:05:25.629432Z 239 [Note] Aborted connection 239 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:05:25.630214Z 212 [Note] Aborted connection 212 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:05:25.632536Z 184 [Note] Aborted connection 184 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:05:25.635534Z 156 [Note] Aborted connection 156 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:05:25.638438Z 128 [Note] Aborted connection 128 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:05:25.641550Z 119 [Note] Aborted connection 119 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:05:25.642292Z 118 [Note] Aborted connection 118 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:05:25.642838Z 89 [Note] Aborted connection 89 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:05:25.645556Z 88 [Note] Aborted connection 88 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:05:25.646054Z 81 [Note] Aborted connection 81 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:05:25.649533Z 80 [Note] Aborted connection 80 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:07:58.638559Z 342 [Note] Aborted connection 342 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:08:39.251643Z 368 [Note] Aborted connection 368 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:16:51.359916Z 592 [Note] Start binlog_dump to master_thread_id(592) slave_server(110), pos(, 4) 2018-05-14T06:16:52.218768Z 592 [Note] Start semi-sync binlog_dump to slave (server_id: 110), pos(, 4) 2018-05-14T06:16:54.516444Z 0 [ERROR] /usr/sbin/mysqld: Got an error reading communication packets 2018-05-14T06:16:58.848308Z 593 [Note] While initializing dump thread for slave with UUID <84717b93-5730-11e8-a3ee-000d3a068fe4>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(592). 2018-05-14T06:16:58.848395Z 592 [Note] Stop semi-sync binlog_dump to slave (server_id: 110) 2018-05-14T06:16:58.848486Z 593 [Note] Start binlog_dump to master_thread_id(593) slave_server(110), pos(, 4) 2018-05-14T06:16:59.522526Z 593 [Note] Start semi-sync binlog_dump to slave (server_id: 110), pos(, 4) 2018-05-14T06:17:00.999670Z 577 [Note] Aborted connection 577 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:20:00.451261Z 655 [Note] Aborted connection 655 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:22:59.451758Z 734 [Note] Aborted connection 734 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:24:59.874862Z 786 [Note] Aborted connection 786 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:24:59.875201Z 761 [Note] Aborted connection 761 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:24:59.889521Z 627 [Note] Aborted connection 627 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:24:59.889877Z 599 [Note] Aborted connection 599 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:24:59.890302Z 501 [Note] Aborted connection 501 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:24:59.891729Z 475 [Note] Aborted connection 475 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:24:59.893218Z 449 [Note] Aborted connection 449 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:24:59.893973Z 422 [Note] Aborted connection 422 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:24:59.894704Z 395 [Note] Aborted connection 395 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:24:59.895463Z 315 [Note] Aborted connection 315 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:26:37.796501Z 840 [Note] Aborted connection 840 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:31:01.009660Z 941 [Note] Aborted connection 941 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:32:38.242476Z 1002 [Note] Aborted connection 1002 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:34:42.035503Z 1057 [Note] Aborted connection 1057 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:37:58.177813Z 1135 [Note] Aborted connection 1135 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:39:59.380600Z 1188 [Note] Aborted connection 1188 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:43:12.471694Z 963 [Note] Aborted connection 963 to db: 'demo' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets) 2018-05-14T06:43:12.471858Z 964 [Note] Aborted connection 964 to db: 'demo' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets) 2018-05-14T06:43:12.472527Z 960 [Note] Aborted connection 960 to db: 'demo' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets) 2018-05-14T06:43:12.472607Z 961 [Note] Aborted connection 961 to db: 'demo' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets) 2018-05-14T06:43:12.473574Z 962 [Note] Aborted connection 962 to db: 'demo' user: 'admin' host: '13.228.235.229' (Got an error reading communication packets) 2018-05-14T06:43:51.880292Z 113 [ERROR] Semi-sync master failed on net_flush() before waiting for slave reply 2018-05-14T06:43:51.880985Z 113 [Note] Stop semi-sync binlog_dump to slave (server_id: 111) 2018-05-14T06:44:41.754052Z 1343 [Note] While initializing dump thread for slave with UUID <770ca92e-5730-11e8-9f7a-000d3a064af1>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(113). 2018-05-14T06:44:41.863759Z 1343 [Note] Start binlog_dump to master_thread_id(1343) slave_server(111), pos(, 4) 2018-05-14T06:46:11.934785Z 1382 [Note] While initializing dump thread for slave with UUID <770ca92e-5730-11e8-9f7a-000d3a064af1>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(113). 2018-05-14T06:46:11.934894Z 1382 [Note] Start binlog_dump to master_thread_id(1382) slave_server(111), pos(, 4) 2018-05-14T06:47:11.985863Z 1408 [Note] While initializing dump thread for slave with UUID <770ca92e-5730-11e8-9f7a-000d3a064af1>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(113). 2018-05-14T06:47:11.985974Z 1408 [Note] Start binlog_dump to master_thread_id(1408) slave_server(111), pos(, 4) 2018-05-14T06:48:30.963923Z 1442 [Note] While initializing dump thread for slave with UUID <770ca92e-5730-11e8-9f7a-000d3a064af1>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(113). 2018-05-14T06:48:30.964037Z 1442 [Note] Start binlog_dump to master_thread_id(1442) slave_server(111), pos(, 4) 2018-05-14T06:49:31.053344Z 1467 [Note] While initializing dump thread for slave with UUID <770ca92e-5730-11e8-9f7a-000d3a064af1>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(113). 2018-05-14T06:49:31.053465Z 1467 [Note] Start binlog_dump to master_thread_id(1467) slave_server(111), pos(, 4) 2018-05-14T06:50:31.947434Z 1493 [Note] While initializing dump thread for slave with UUID <770ca92e-5730-11e8-9f7a-000d3a064af1>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(113). 2018-05-14T06:50:31.994489Z 1493 [Note] Start binlog_dump to master_thread_id(1493) slave_server(111), pos(, 4) 2018-05-14T06:51:32.037610Z 1514 [Note] While initializing dump thread for slave with UUID <770ca92e-5730-11e8-9f7a-000d3a064af1>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(113). 2018-05-14T06:51:32.037721Z 1514 [Note] Start binlog_dump to master_thread_id(1514) slave_server(111), pos(, 4) 2018-05-14T06:52:34.929023Z 1544 [Note] While initializing dump thread for slave with UUID <770ca92e-5730-11e8-9f7a-000d3a064af1>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(1514). 2018-05-14T06:52:34.929139Z 1544 [Note] Start binlog_dump to master_thread_id(1544) slave_server(111), pos(, 4)