2018-11-29T07:34:09.243569Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-11-29T07:34:09.245224Z 0 [Note] mysqld (mysqld 5.7.23-24-log) starting as process 1 ...
2018-11-29T07:34:09.267751Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-11-29T07:34:09.267861Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-11-29T07:34:09.267884Z 0 [Note] InnoDB: Uses event mutexes
2018-11-29T07:34:09.267905Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-11-29T07:34:09.267922Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-11-29T07:34:09.267955Z 0 [Note] InnoDB: Using Linux native AIO
2018-11-29T07:34:09.268355Z 0 [Note] InnoDB: Number of pools: 1
2018-11-29T07:34:09.268528Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-11-29T07:34:09.276248Z 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2018-11-29T07:34:09.294970Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-11-29T07:34:09.301285Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-11-29T07:34:09.405589Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2018-11-29T07:34:09.432202Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-11-29T07:34:09.638302Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 3932160 bytes
2018-11-29T07:34:11.192457Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-11-29T07:34:11.192489Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-11-29T07:34:11.192534Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-11-29T07:34:11.764633Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-11-29T07:34:11.765540Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-11-29T07:34:11.765564Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-11-29T07:34:11.773553Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.23-24 started; log sequence number 12437032
2018-11-29T07:34:11.773883Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-11-29T07:34:11.774086Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-11-29T07:34:12.339142Z 0 [Note] Salting uuid generator variables, current_pid: 1, server_start_time: 1543476849, bytes_sent: 0, 
2018-11-29T07:34:12.339273Z 0 [Note] Generated uuid: '2a8836c8-f3a9-11e8-871b-466dd2dd491b', server_start_time: 281476520187506, bytes_sent: 93970735039712
2018-11-29T07:34:12.339302Z 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: 2a8836c8-f3a9-11e8-871b-466dd2dd491b.
2018-11-29T07:34:12.800461Z 0 [Note] Auto generated SSL certificates are placed in data directory.
2018-11-29T07:34:12.801157Z 0 [Warning] CA certificate ca.pem is self signed.
2018-11-29T07:34:12.868715Z 0 [Note] Auto generated RSA key files are placed in data directory.
2018-11-29T07:34:12.869320Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-11-29T07:34:12.869348Z 0 [Note] IPv6 is available.
2018-11-29T07:34:12.869397Z 0 [Note]   - '::' resolves to '::';
2018-11-29T07:34:12.869452Z 0 [Note] Server socket created on IP: '::'.
2018-11-29T07:34:13.289239Z 0 [ERROR] mysqld: Table './mysql/user' is marked as crashed and should be repaired
2018-11-29T07:34:13.289513Z 0 [Warning] Checking table:   './mysql/user'
2018-11-29T07:34:13.289532Z 0 [ERROR] 1 client is using or hasn't closed the table properly
2018-11-29T07:34:13.289845Z 0 [ERROR] mysqld: Table './mysql/db' is marked as crashed and should be repaired
2018-11-29T07:34:13.289975Z 0 [Warning] Checking table:   './mysql/db'
2018-11-29T07:34:13.289991Z 0 [ERROR] 1 client is using or hasn't closed the table properly
2018-11-29T07:34:13.290265Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
2018-11-29T07:34:13.290323Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-11-29T07:34:13.290352Z 0 [Note] Utility user 'sys_utility_sidecar'@'%' in use with access rights 'SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, GRANT, ALTER, SHOW DATABASES, SUPER, LOCK TABLES, REPLICATION SLAVE, REPLICATION CLIENT, CREATE USER'.
2018-11-29T07:34:13.290380Z 0 [Note] Utility user 'sys_utility_sidecar'@'%' in use with full access to schemas 'mysql'.
2018-11-29T07:34:13.290388Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-11-29T07:34:13.290391Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-11-29T07:34:13.290404Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
2018-11-29T07:34:13.935149Z 0 [ERROR] mysqld: Table './mysql/tables_priv' is marked as crashed and should be repaired
2018-11-29T07:34:13.935327Z 0 [Warning] Checking table:   './mysql/tables_priv'
2018-11-29T07:34:13.935343Z 0 [ERROR] 1 client is using or hasn't closed the table properly
2018-11-29T07:34:13.935917Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
2018-11-29T07:34:13.935938Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
2018-11-29T07:34:14.094286Z 0 [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 '--relay-log=prod-ain-cluster-mysql-2-relay-bin' to avoid this problem.
2018-11-29T07:34:14.286939Z 0 [ERROR] Error during --relay-log-recovery: Could not locate rotate event from master in relay log file.
2018-11-29T07:34:14.582064Z 0 [ERROR] Slave: Failed to initialize the master info structure for channel ''; its record may still be present in 'mysql.slave_master_info' table, consider deleting it.
2018-11-29T07:34:14.582109Z 0 [ERROR] Failed to create or recover replication info repositories.
2018-11-29T07:34:14.582133Z 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-11-29T07:34:14.589024Z 0 [Note] Event Scheduler: Loaded 0 events
2018-11-29T07:34:14.589316Z 0 [Note] mysqld: ready for connections.
Version: '5.7.23-24-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Percona Server (GPL), Release '24', Revision '57a9574'
2018-11-29T07:34:14.616672Z 9 [Note] 'CHANGE MASTER TO FOR CHANNEL '' executed'. Previous state master_host='prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''.
2018-11-29T07:34:14.992499Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181129  7:34:14
2018-11-29T07:34:14.997996Z 10 [ERROR] Slave SQL for channel '': Slave failed to initialize relay log info structure from the repository, Error_code: 1872
2018-11-29T07:34:15.282580Z 13 [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-11-29T07:34:15.288224Z 13 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 1, Error_code: 2005
2018-11-29T07:34:15.288240Z 13 [Note] Slave I/O thread for channel '' killed while connecting to master
2018-11-29T07:34:15.288243Z 13 [Note] Slave I/O thread exiting for channel '', read up to log 'FIRST', position 4
2018-11-29T07:34:15.494396Z 14 [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-11-29T07:34:15.495161Z 15 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'FIRST' at position 0, relay log './prod-ain-cluster-mysql-2-relay-bin.000001' position: 4
2018-11-29T07:34:15.498373Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 1, Error_code: 2005
2018-11-29T07:34:25.508624Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 2, Error_code: 2005
2018-11-29T07:34:35.517491Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 3, Error_code: 2005
2018-11-29T07:34:55.531704Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 4, Error_code: 2005
2018-11-29T07:35:05.538682Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 5, Error_code: 2005
2018-11-29T07:35:15.546249Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 6, Error_code: 2005
2018-11-29T07:35:25.574373Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 7, Error_code: 2005
2018-11-29T07:35:35.580569Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 8, Error_code: 2005
2018-11-29T07:35:45.586624Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 9, Error_code: 2005
2018-11-29T07:35:55.596013Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 10, Error_code: 2005
2018-11-29T07:36:05.601751Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 11, Error_code: 2005
2018-11-29T07:36:15.609373Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 12, Error_code: 2005
2018-11-29T07:36:25.619391Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 13, Error_code: 2005
2018-11-29T07:36:35.625666Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 14, Error_code: 2005
2018-11-29T07:36:45.632644Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 15, Error_code: 2005
2018-11-29T07:36:55.638576Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 16, Error_code: 2005
2018-11-29T07:37:05.646304Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 17, Error_code: 2005
2018-11-29T07:37:15.653700Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 18, Error_code: 2005
2018-11-29T07:37:25.660638Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 19, Error_code: 2005
2018-11-29T07:37:35.668558Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 20, Error_code: 2005
2018-11-29T07:37:45.676231Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 21, Error_code: 2005
2018-11-29T07:37:55.682874Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 22, Error_code: 2005
2018-11-29T07:38:05.689970Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 23, Error_code: 2005
2018-11-29T07:38:15.697587Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 24, Error_code: 2005
2018-11-29T07:38:25.710005Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 25, Error_code: 2005
2018-11-29T07:38:35.723582Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 26, Error_code: 2005
2018-11-29T07:38:45.730004Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 27, Error_code: 2005
2018-11-29T07:38:55.736009Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 28, Error_code: 2005
2018-11-29T07:39:05.745253Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 29, Error_code: 2005
2018-11-29T07:39:15.754113Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 30, Error_code: 2005
2018-11-29T07:39:25.761991Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 31, Error_code: 2005
2018-11-29T07:39:35.770693Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 32, Error_code: 2005
2018-11-29T07:39:45.778211Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 33, Error_code: 2005
2018-11-29T07:39:55.783748Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 34, Error_code: 2005
2018-11-29T07:40:05.791021Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 35, Error_code: 2005
2018-11-29T07:40:15.798779Z 14 [ERROR] Slave I/O for channel '': error connecting to master 'repl_1FULi@prod-ain-cluster-mysql-0.prod-ain-cluster-mysql-nodes.defaul:3306' - retry-time: 10  retries: 36, Error_code: 2005