2018-05-14T05:58:11.649067Z 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:58:11.650987Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-log) starting as process 68911 ... 2018-05-14T05:58:13.148198Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-05-14T05:58:13.148259Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-05-14T05:58:13.148269Z 0 [Note] InnoDB: Uses event mutexes 2018-05-14T05:58:13.148278Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2018-05-14T05:58:13.148285Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-05-14T05:58:13.148291Z 0 [Note] InnoDB: Using Linux native AIO 2018-05-14T05:58:13.148598Z 0 [Note] InnoDB: Number of pools: 1 2018-05-14T05:58:13.198362Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-05-14T05:58:13.204019Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-05-14T05:58:13.215302Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-05-14T05:58:13.217628Z 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:58:14.539904Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-05-14T05:58:15.998384Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-05-14T05:58:15.998501Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-05-14T05:58:17.052020Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-05-14T05:58:17.053260Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-05-14T05:58:17.053292Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-05-14T05:58:17.053528Z 0 [Note] InnoDB: Waiting for purge to start 2018-05-14T05:58:17.108005Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 2565058 2018-05-14T05:58:17.108325Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-05-14T05:58:17.108534Z 0 [Note] InnoDB: Loading buffer pool(s) from /mysql_data/mysql/ib_buffer_pool 2018-05-14T05:58:18.087017Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180514 5:58:18 2018-05-14T05:58:21.144980Z 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:58:21.194358Z 0 [Warning] CA certificate ca.pem is self signed. 2018-05-14T05:58:21.199372Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2018-05-14T05:58:21.199400Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2018-05-14T05:58:21.199429Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2018-05-14T05:58:22.102730Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-05-14T05:58:22.102809Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-05-14T05:58:22.118227Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-05-14T05:58:22.118244Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-05-14T05:58:22.252279Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-05-14T05:58:22.252300Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-05-14T05:58:22.742485Z 0 [Note] Event Scheduler: Loaded 0 events 2018-05-14T05:58:22.742657Z 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:58:27.262831Z 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.13', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. 2018-05-14T05:58:30.424398Z 19 [Note] Slave I/O thread: Start semi-sync replication to master 'repl_user@172.19.0.13:3306' in log 'FIRST' at position 4 2018-05-14T05:58:30.424432Z 19 [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:58:30.445448Z 19 [Note] Slave I/O thread for channel '': connected to master 'repl_user@172.19.0.13:3306',replication started in log 'FIRST' at position 4 2018-05-14T05:58:30.896821Z 20 [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:59:14.699201Z 59 [Note] Aborted connection 59 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:08:57.547692Z 97 [Note] Aborted connection 97 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:08:57.550409Z 96 [Note] Aborted connection 96 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:08:57.550828Z 88 [Note] Aborted connection 88 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:08:57.560908Z 82 [Note] Aborted connection 82 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:08:57.561239Z 81 [Note] Aborted connection 81 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:08:57.561370Z 75 [Note] Aborted connection 75 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:08:57.561638Z 74 [Note] Aborted connection 74 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:08:57.561967Z 58 [Note] Aborted connection 58 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:17:28.274397Z 231 [Note] Aborted connection 231 to db: 'unconnected' user: 'root' host: '127.0.0.1' (Got an error reading communication packets) 2018-05-14T06:31:11.794371Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4447ms. The settings might not be optimal. (flushed=161 and evicted=0, during the time.) 2018-05-14T06:44:41.715694Z 19 [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-14T06:46:11.867722Z 19 [Note] Slave I/O thread killed while waiting to reconnect after a failed read for channel '' 2018-05-14T06:46:11.867748Z 19 [Note] Slave I/O thread exiting for channel '', read up to log 'mysql-bin.000002', position 816880 2018-05-14T06:46:11.902606Z 500 [Note] Slave I/O thread: Start semi-sync replication to master 'repl_user@172.19.0.13:3306' in log 'mysql-bin.000002' at position 816880 2018-05-14T06:46:11.902629Z 500 [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-14T06:46:11.922890Z 500 [Note] Slave I/O thread for channel '': connected to master 'repl_user@172.19.0.13:3306',replication started in log 'mysql-bin.000002' at position 816880 2018-05-14T06:47:11.947587Z 500 [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-14T06:48:27.450499Z 20 [Note] Error reading relay log event for channel '': slave SQL thread was killed 2018-05-14T06:48:27.481642Z 500 [Note] Slave I/O thread killed while waiting to reconnect after a failed read for channel '' 2018-05-14T06:48:27.481659Z 500 [Note] Slave I/O thread exiting for channel '', read up to log 'mysql-bin.000002', position 816880 2018-05-14T06:48:30.543162Z 521 [Note] Slave I/O thread: Start semi-sync replication to master 'repl_user@172.19.0.13:3306' in log 'mysql-bin.000002' at position 816880 2018-05-14T06:48:30.543200Z 521 [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-14T06:48:30.571905Z 521 [Note] Slave I/O thread for channel '': connected to master 'repl_user@172.19.0.13:3306',replication started in log 'mysql-bin.000002' at position 816880 2018-05-14T06:48:30.952719Z 522 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'mysql-bin.000002' at position 816880, relay log './relay-log-slave.000002' position: 817053 2018-05-14T06:49:31.018168Z 521 [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-14T06:50:31.874476Z 521 [Note] Slave I/O thread killed while waiting to reconnect after a failed read for channel '' 2018-05-14T06:50:31.874491Z 521 [Note] Slave I/O thread exiting for channel '', read up to log 'mysql-bin.000002', position 816880 2018-05-14T06:50:31.907382Z 570 [Note] Slave I/O thread: Start semi-sync replication to master 'repl_user@172.19.0.13:3306' in log 'mysql-bin.000002' at position 816880 2018-05-14T06:50:31.907399Z 570 [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-14T06:50:31.927780Z 570 [Note] Slave I/O thread for channel '': connected to master 'repl_user@172.19.0.13:3306',replication started in log 'mysql-bin.000002' at position 816880 2018-05-14T06:51:32.001956Z 570 [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-14T06:52:34.869845Z 570 [Note] Slave I/O thread killed while waiting to reconnect after a failed read for channel '' 2018-05-14T06:52:34.869862Z 570 [Note] Slave I/O thread exiting for channel '', read up to log 'mysql-bin.000002', position 816880 2018-05-14T06:52:34.897779Z 590 [Note] Slave I/O thread: Start semi-sync replication to master 'repl_user@172.19.0.13:3306' in log 'mysql-bin.000002' at position 816880 2018-05-14T06:52:34.897797Z 590 [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-14T06:52:34.916601Z 590 [Note] Slave I/O thread for channel '': connected to master 'repl_user@172.19.0.13:3306',replication started in log 'mysql-bin.000002' at position 816880 2018-05-14T06:53:34.985203Z 590 [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.