2018-05-21 14:02:15 40793 [Note] Plugin 'BLACKHOLE' is disabled. 2018-05-21 14:02:15 40793 [Note] Plugin 'ARCHIVE' is disabled. 2018-05-21 14:02:15 40793 [Note] Plugin 'FEDERATED' is disabled. /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist 2018-05-21 14:02:15 40793 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 2018-05-21 14:02:15 7f959e5af7e0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2018-05-21 14:02:15 40793 [Note] InnoDB: Using atomics to ref count buffer pool pages 2018-05-21 14:02:15 40793 [Note] InnoDB: The InnoDB memory heap is disabled 2018-05-21 14:02:15 40793 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-05-21 14:02:15 40793 [Note] InnoDB: Memory barrier is not used 2018-05-21 14:02:15 40793 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-05-21 14:02:15 40793 [Note] InnoDB: Using Linux native AIO 2018-05-21 14:02:15 40793 [Note] InnoDB: Using CPU crc32 instructions 2018-05-21 14:02:15 40793 [Note] InnoDB: Initializing buffer pool, size = 180.0G 2018-05-21 14:02:20 40793 [Note] InnoDB: Completed initialization of buffer pool 2018-05-21 14:02:21 40793 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2018-05-21 14:02:21 40793 [Note] InnoDB: Setting file ./ibdata1 size to 10 MB 2018-05-21 14:02:21 40793 [Note] InnoDB: Database physically writes the file full: wait... 2018-05-21 14:02:21 40793 [Note] InnoDB: Setting log file ./ib_logfile101 size to 1024 MB InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000 2018-05-21 14:02:22 40793 [Note] InnoDB: Setting log file ./ib_logfile1 size to 1024 MB InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000 2018-05-21 14:02:23 40793 [Note] InnoDB: Setting log file ./ib_logfile2 size to 1024 MB InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000 2018-05-21 14:02:25 40793 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2018-05-21 14:02:25 40793 [Warning] InnoDB: New log files created, LSN=45781 2018-05-21 14:02:25 40793 [Note] InnoDB: Doublewrite buffer not found: creating new 2018-05-21 14:02:25 40793 [Note] InnoDB: Doublewrite buffer created 2018-05-21 14:02:25 40793 [Note] InnoDB: 128 rollback segment(s) are active. 2018-05-21 14:02:25 40793 [Warning] InnoDB: Creating foreign key constraint system tables. 2018-05-21 14:02:25 40793 [Note] InnoDB: Foreign key constraint system tables created 2018-05-21 14:02:25 40793 [Note] InnoDB: Creating tablespace and datafile system tables. 2018-05-21 14:02:25 40793 [Note] InnoDB: Tablespace and datafile system tables created. 2018-05-21 14:02:25 40793 [Note] InnoDB: Creating zip_dict and zip_dict_cols system tables. 2018-05-21 14:02:25 40793 [Note] InnoDB: zip_dict and zip_dict_cols system tables created. 2018-05-21 14:02:25 40793 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 0 2018-05-21 14:02:25 40793 [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: 9708629f-5cff-11e8-bbf3-0a94ef41aa87. 2018-05-21 14:02:25 40793 [Note] RSA private key file not found: /var/opt/data/snow/glide/mysql/data//private_key.pem. Some authentication plugins will not work. 2018-05-21 14:02:25 40793 [Note] RSA public key file not found: /var/opt/data/snow/glide/mysql/data//public_key.pem. Some authentication plugins will not work. 2018-05-21 14:02:25 40793 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2018-05-21 14:02:25 40793 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2018-05-21 14:02:25 40793 [Note] Server socket created on IP: '0.0.0.0'. 2018-05-21 14:02:25 40793 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 2018-05-21 14:09:26 43455 [Note] Plugin 'BLACKHOLE' is disabled. 2018-05-21 14:09:26 43455 [Note] Plugin 'ARCHIVE' is disabled. 2018-05-21 14:09:26 43455 [Note] Plugin 'FEDERATED' is disabled. 2018-05-21 14:09:26 7fd6d43a77e0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2018-05-21 14:09:26 43455 [Note] InnoDB: Using atomics to ref count buffer pool pages 2018-05-21 14:09:26 43455 [Note] InnoDB: The InnoDB memory heap is disabled 2018-05-21 14:09:26 43455 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-05-21 14:09:26 43455 [Note] InnoDB: Memory barrier is not used 2018-05-21 14:09:26 43455 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-05-21 14:09:26 43455 [Note] InnoDB: Using Linux native AIO 2018-05-21 14:09:26 43455 [Note] InnoDB: Using CPU crc32 instructions 2018-05-21 14:09:26 43455 [Note] InnoDB: Initializing buffer pool, size = 180.0G 2018-05-21 14:09:31 43455 [Note] InnoDB: Completed initialization of buffer pool 2018-05-21 14:09:32 43455 [Note] InnoDB: Highest supported file format is Barracuda. 2018-05-21 14:09:34 43455 [Note] InnoDB: 128 rollback segment(s) are active. 2018-05-21 14:09:34 43455 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1632013 2018-05-21 14:09:34 43455 [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: 96e43fdb-5d00-11e8-bbf9-0a94ef41aa87. 2018-05-21 14:09:34 43455 [Note] RSA private key file not found: /var/opt/data/snow/glide/mysql/data//private_key.pem. Some authentication plugins will not work. 2018-05-21 14:09:34 43455 [Note] RSA public key file not found: /var/opt/data/snow/glide/mysql/data//public_key.pem. Some authentication plugins will not work. 2018-05-21 14:09:34 43455 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2018-05-21 14:09:34 43455 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2018-05-21 14:09:34 43455 [Note] Server socket created on IP: '0.0.0.0'. 2018-05-21 14:09:34 43455 [Note] Event Scheduler: Loaded 0 events 2018-05-21 14:09:34 43455 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.39-83.1-log' socket: '/tmp/mysql.sock' port: 3306 Percona Server (GPL), Release 83.1, Revision da5a1c2923f 2018-06-04 08:15:56 43455 [ERROR] Failed in open_index_file() called from Relay_log_info::rli_init_info(). 2018-06-04 08:17:03 43455 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='10.72.188.165', master_port= 3306, master_log_file='mysql-binlog.058540', master_log_pos= 16306960, master_bind=''. 2018-06-04 08:17:34 43455 [Note] /usr/sbin/mysqld: Normal shutdown 2018-06-04 08:17:34 43455 [Note] Giving 0 client threads a chance to die gracefully 2018-06-04 08:17:34 43455 [Note] Event Scheduler: Purging the queue. 0 events 2018-06-04 08:17:34 43455 [Note] Shutting down slave threads 2018-06-04 08:17:34 43455 [Note] Forcefully disconnecting 0 remaining clients 2018-06-04 08:17:34 43455 [Note] Binlog end 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'partition' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_METRICS' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_CMP' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'INNODB_TRX' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'XTRADB_ZIP_DICT' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'XTRADB_RSEG' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'XTRADB_READ_VIEW' 2018-06-04 08:17:34 43455 [Note] Shutting down plugin 'InnoDB' 2018-06-04 08:17:34 43455 [Note] InnoDB: FTS optimize thread exiting. 2018-06-04 08:17:34 43455 [Note] InnoDB: Starting shutdown... 2018-06-04 08:17:35 43455 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2018-06-04 08:17:44 43455 [Note] InnoDB: Shutdown completed; log sequence number 2189069418676 2018-06-04 08:17:44 43455 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-06-04 08:17:44 43455 [Note] Shutting down plugin 'MyISAM' 2018-06-04 08:17:44 43455 [Note] Shutting down plugin 'MRG_MYISAM' 2018-06-04 08:17:44 43455 [Note] Shutting down plugin 'CSV' 2018-06-04 08:17:44 43455 [Note] Shutting down plugin 'MEMORY' 2018-06-04 08:17:44 43455 [Note] Shutting down plugin 'sha256_password' 2018-06-04 08:17:44 43455 [Note] Shutting down plugin 'mysql_old_password' 2018-06-04 08:17:44 43455 [Note] Shutting down plugin 'mysql_native_password' 2018-06-04 08:17:44 43455 [Note] Shutting down plugin 'binlog' 2018-06-04 08:17:44 43455 [Note] /usr/sbin/mysqld: Shutdown complete 180604 08:17:47 mysqld_safe Logging to '/var/opt/log/snow/mysql/mysqld.log'. 180604 08:17:47 mysqld_safe Starting mysqld daemon with databases from /var/opt/data/snow/glide/mysql/data 2018-06-04 08:17:47 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-06-04 08:17:47 0 [Note] /usr/sbin/mysqld (mysqld 5.6.39-83.1-log) starting as process 8035 ... 2018-06-04 08:17:47 8035 [Note] Plugin 'BLACKHOLE' is disabled. 2018-06-04 08:17:47 8035 [Note] Plugin 'ARCHIVE' is disabled. 2018-06-04 08:17:47 8035 [Note] Plugin 'FEDERATED' is disabled. 2018-06-04 08:17:47 7f1ba92f17e0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2018-06-04 08:17:47 8035 [Note] InnoDB: Using atomics to ref count buffer pool pages 2018-06-04 08:17:47 8035 [Note] InnoDB: The InnoDB memory heap is disabled 2018-06-04 08:17:47 8035 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-06-04 08:17:47 8035 [Note] InnoDB: Memory barrier is not used 2018-06-04 08:17:47 8035 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-06-04 08:17:47 8035 [Note] InnoDB: Using Linux native AIO 2018-06-04 08:17:47 8035 [Note] InnoDB: Using CPU crc32 instructions 2018-06-04 08:17:47 8035 [Note] InnoDB: Initializing buffer pool, size = 180.0G 2018-06-04 08:17:52 8035 [Note] InnoDB: Completed initialization of buffer pool 2018-06-04 08:17:54 8035 [Note] InnoDB: Highest supported file format is Barracuda. 2018-06-04 08:17:56 8035 [Note] InnoDB: 128 rollback segment(s) are active. 2018-06-04 08:17:56 8035 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 2189069418676 2018-06-04 08:17:56 8035 [Note] RSA private key file not found: /var/opt/data/snow/glide/mysql/data//private_key.pem. Some authentication plugins will not work. 2018-06-04 08:17:56 8035 [Note] RSA public key file not found: /var/opt/data/snow/glide/mysql/data//public_key.pem. Some authentication plugins will not work. 2018-06-04 08:17:56 8035 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2018-06-04 08:17:56 8035 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2018-06-04 08:17:56 8035 [Note] Server socket created on IP: '0.0.0.0'. 2018-06-04 08:17:56 8035 [Warning] Recovery from master pos 16306960 and file mysql-binlog.058540. Previous relay log pos and relay log file had been set to 4, /var/opt/data/snow/glide/mysql/relaylog/mysql-relay.000001 respectively. 2018-06-04 08:17:56 8035 [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-06-04 08:17:56 8035 [Note] Slave SQL thread initialized, starting replication in log 'mysql-binlog.058540' at position 16306960, relay log '/var/opt/data/snow/glide/mysql/relaylog/mysql-relay.000002' position: 4 2018-06-04 08:17:56 8035 [Note] Event Scheduler: Loaded 0 events 2018-06-04 08:17:56 8035 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.39-83.1-log' socket: '/tmp/mysql.sock' port: 3306 Percona Server (GPL), Release 83.1, Revision da5a1c2923f 2018-06-04 08:17:56 8035 [Note] Slave I/O thread: connected to master 'repl_clus@10.72.188.165:3306',replication started in log 'mysql-binlog.058540' at position 16306960 2018-06-04 18:34:24 8035 [ERROR] Slave SQL: Error 'Table 'amosprod.sysevent0005' doesn't exist' on query. Default database: 'amosprod'. Query: 'CREATE TABLE tmp_s15399028615 LIKE sysevent0005 /* amosprod002 */', Error_code: 1146 2018-06-04 18:34:24 8035 [Warning] Slave: Table 'amosprod.sysevent0005' doesn't exist Error_code: 1146 2018-06-04 18:34:24 8035 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-binlog.058770' position 78544209 2018-06-06 06:53:19 8035 [Note] Slave I/O thread killed while reading event 2018-06-06 06:53:19 8035 [Note] Slave I/O thread exiting, read up to log 'mysql-binlog.059479', position 139789742 2018-06-08 15:11:32 8035 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='10.72.188.165', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='10.72.188.165', master_port= 3306, master_log_file='mysql-binlog.060063', master_log_pos= 186609410, master_bind=''. 2018-06-11 05:47:49 8035 [Note] /usr/sbin/mysqld: Normal shutdown 2018-06-11 05:47:49 8035 [Note] Giving 0 client threads a chance to die gracefully 2018-06-11 05:47:49 8035 [Note] Event Scheduler: Purging the queue. 0 events 2018-06-11 05:47:49 8035 [Note] Shutting down slave threads 2018-06-11 05:47:49 8035 [Note] Forcefully disconnecting 0 remaining clients 2018-06-11 05:47:49 8035 [Note] Binlog end 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'partition' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_METRICS' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_CMP' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'INNODB_TRX' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'XTRADB_ZIP_DICT' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'XTRADB_RSEG' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'XTRADB_READ_VIEW' 2018-06-11 05:47:49 8035 [Note] Shutting down plugin 'InnoDB' 2018-06-11 05:47:49 8035 [Note] InnoDB: FTS optimize thread exiting. 2018-06-11 05:47:49 8035 [Note] InnoDB: Starting shutdown... 2018-06-11 05:47:49 8035 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2018-06-11 05:47:56 8035 [Note] InnoDB: Shutdown completed; log sequence number 3239466140068 2018-06-11 05:47:56 8035 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-06-11 05:47:56 8035 [Note] Shutting down plugin 'MyISAM' 2018-06-11 05:47:56 8035 [Note] Shutting down plugin 'MRG_MYISAM' 2018-06-11 05:47:56 8035 [Note] Shutting down plugin 'CSV' 2018-06-11 05:47:56 8035 [Note] Shutting down plugin 'MEMORY' 2018-06-11 05:47:56 8035 [Note] Shutting down plugin 'sha256_password' 2018-06-11 05:47:56 8035 [Note] Shutting down plugin 'mysql_old_password' 2018-06-11 05:47:56 8035 [Note] Shutting down plugin 'mysql_native_password' 2018-06-11 05:47:56 8035 [Note] Shutting down plugin 'binlog' 2018-06-11 05:47:56 8035 [Note] /usr/sbin/mysqld: Shutdown complete 180611 05:47:56 mysqld_safe mysqld from pid file /var/opt/data/snow/glide/mysql/data/sla21215.pid ended 180611 05:47:58 mysqld_safe Logging to '/var/opt/log/snow/mysql/mysqld.log'. 180611 05:47:58 mysqld_safe Starting mysqld daemon with databases from /var/opt/data/snow/glide/mysql/data 2018-06-11 05:47:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-06-11 05:47:59 0 [Note] /usr/sbin/mysqld (mysqld 5.6.39-83.1-log) starting as process 13311 ... 2018-06-11 05:47:59 13311 [Note] Plugin 'BLACKHOLE' is disabled. 2018-06-11 05:47:59 13311 [Note] Plugin 'ARCHIVE' is disabled. 2018-06-11 05:47:59 13311 [Note] Plugin 'FEDERATED' is disabled. 2018-06-11 05:47:59 7f0d3ff7b7e0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2018-06-11 05:47:59 13311 [Note] InnoDB: Using atomics to ref count buffer pool pages 2018-06-11 05:47:59 13311 [Note] InnoDB: The InnoDB memory heap is disabled 2018-06-11 05:47:59 13311 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-06-11 05:47:59 13311 [Note] InnoDB: Memory barrier is not used 2018-06-11 05:47:59 13311 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-06-11 05:47:59 13311 [Note] InnoDB: Using Linux native AIO 2018-06-11 05:47:59 13311 [Note] InnoDB: Using CPU crc32 instructions 2018-06-11 05:47:59 13311 [Note] InnoDB: Initializing buffer pool, size = 180.0G 2018-06-11 05:48:04 13311 [Note] InnoDB: Completed initialization of buffer pool 2018-06-11 05:48:05 13311 [Note] InnoDB: Highest supported file format is Barracuda. 2018-06-11 05:48:07 13311 [Note] InnoDB: 128 rollback segment(s) are active. 2018-06-11 05:48:07 13311 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 3239466140068 2018-06-11 05:48:11 13311 [Note] RSA private key file not found: /var/opt/data/snow/glide/mysql/data//private_key.pem. Some authentication plugins will not work. 2018-06-11 05:48:11 13311 [Note] RSA public key file not found: /var/opt/data/snow/glide/mysql/data//public_key.pem. Some authentication plugins will not work. 2018-06-11 05:48:11 13311 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2018-06-11 05:48:11 13311 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2018-06-11 05:48:11 13311 [Note] Server socket created on IP: '0.0.0.0'. 2018-06-11 05:48:11 13311 [Warning] Recovery from master pos 186609410 and file mysql-binlog.060063. Previous relay log pos and relay log file had been set to 4, /var/opt/data/snow/glide/mysql/relaylog/mysql-relay.000001 respectively. 2018-06-11 05:48:11 13311 [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-06-11 05:48:11 13311 [Note] Slave SQL thread initialized, starting replication in log 'mysql-binlog.060063' at position 186609410, relay log '/var/opt/data/snow/glide/mysql/relaylog/mysql-relay.000002' position: 4 2018-06-11 05:48:11 13311 [Note] Event Scheduler: Loaded 0 events 2018-06-11 05:48:11 13311 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.39-83.1-log' socket: '/tmp/mysql.sock' port: 3306 Percona Server (GPL), Release 83.1, Revision da5a1c2923f 2018-06-11 05:48:11 13311 [Note] Slave I/O thread: connected to master 'repl_clus@10.72.188.165:3306',replication started in log 'mysql-binlog.060063' at position 186609410 2018-07-03 02:50:32 13311 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-binlog.065929' at position 142610777 2018-07-03 02:50:32 13311 [Note] Slave I/O thread killed while reading event 2018-07-03 02:50:32 13311 [Note] Slave I/O thread exiting, read up to log 'mysql-binlog.065929', position 142837476 2018-07-03 02:51:36 13311 [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-07-03 02:51:36 13311 [Note] Slave SQL thread initialized, starting replication in log 'mysql-binlog.065929' at position 142610777, relay log '/var/opt/data/snow/glide/mysql/relaylog/mysql-relay.017600' position: 142610943 2018-07-03 02:51:36 13311 [Note] Slave I/O thread: connected to master 'repl_clus@10.72.188.165:3306',replication started in log 'mysql-binlog.065929' at position 142837476 2018-07-06 10:37:45 13311 [Note] Error reading relay log event: slave SQL thread was killed 2018-07-06 10:37:45 13311 [Note] Slave I/O thread killed while reading event 2018-07-06 10:37:45 13311 [Note] Slave I/O thread exiting, read up to log 'mysql-binlog.066975', position 188756203 2018-07-06 10:45:42 13311 [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-07-06 10:45:42 13311 [Note] Slave SQL thread initialized, starting replication in log 'mysql-binlog.066975' at position 188756203, relay log '/var/opt/data/snow/glide/mysql/relaylog/mysql-relay.020738' position: 188756369 2018-07-06 10:45:42 13311 [Note] Slave I/O thread: connected to master 'repl_clus@10.72.188.165:3306',replication started in log 'mysql-binlog.066975' at position 188756203 2018-07-26 16:04:09 13311 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-binlog.072699' at position 197586950 2018-07-26 16:04:09 13311 [Note] Slave I/O thread killed while reading event 2018-07-26 16:04:09 13311 [Note] Slave I/O thread exiting, read up to log 'mysql-binlog.072705', position 116746932 2018-07-26 16:04:48 13311 [Note] /usr/sbin/mysqld: Normal shutdown 2018-07-26 16:04:48 13311 [Note] Giving 0 client threads a chance to die gracefully 2018-07-26 16:04:48 13311 [Note] Event Scheduler: Purging the queue. 0 events 2018-07-26 16:04:48 13311 [Note] Shutting down slave threads 2018-07-26 16:04:48 13311 [Note] Forcefully disconnecting 0 remaining clients 2018-07-26 16:04:48 13311 [Note] Binlog end 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'partition' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_METRICS' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_CMP' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'INNODB_TRX' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'XTRADB_ZIP_DICT' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'XTRADB_RSEG' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'XTRADB_READ_VIEW' 2018-07-26 16:04:51 13311 [Note] Shutting down plugin 'InnoDB' 2018-07-26 16:04:51 13311 [Note] InnoDB: FTS optimize thread exiting. 2018-07-26 16:04:51 13311 [Note] InnoDB: Starting shutdown... 2018-07-26 16:04:51 13311 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2018-07-26 16:05:07 13311 [Note] InnoDB: Shutdown completed; log sequence number 7933561206469 2018-07-26 16:05:07 13311 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-07-26 16:05:07 13311 [Note] Shutting down plugin 'MyISAM' 2018-07-26 16:05:07 13311 [Note] Shutting down plugin 'MRG_MYISAM' 2018-07-26 16:05:07 13311 [Note] Shutting down plugin 'CSV' 2018-07-26 16:05:07 13311 [Note] Shutting down plugin 'MEMORY' 2018-07-26 16:05:07 13311 [Note] Shutting down plugin 'sha256_password' 2018-07-26 16:05:07 13311 [Note] Shutting down plugin 'mysql_old_password' 2018-07-26 16:05:07 13311 [Note] Shutting down plugin 'mysql_native_password' 2018-07-26 16:05:07 13311 [Note] Shutting down plugin 'binlog' 2018-07-26 16:05:07 13311 [Note] /usr/sbin/mysqld: Shutdown complete 180726 16:05:07 mysqld_safe mysqld from pid file /var/opt/data/snow/glide/mysql/data/sla21215.pid ended 2018-07-26 17:26:05 12245 [Note] Plugin 'BLACKHOLE' is disabled. 2018-07-26 17:26:05 12245 [Note] Plugin 'ARCHIVE' is disabled. 2018-07-26 17:26:05 12245 [Note] Plugin 'FEDERATED' is disabled. 2018-07-26 17:26:05 7f752b6a07e0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2018-07-26 17:26:05 12245 [Note] InnoDB: Using atomics to ref count buffer pool pages 2018-07-26 17:26:05 12245 [Note] InnoDB: The InnoDB memory heap is disabled 2018-07-26 17:26:05 12245 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-07-26 17:26:05 12245 [Note] InnoDB: Memory barrier is not used 2018-07-26 17:26:05 12245 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-07-26 17:26:05 12245 [Note] InnoDB: Using Linux native AIO 2018-07-26 17:26:05 12245 [Note] InnoDB: Using CPU crc32 instructions 2018-07-26 17:26:05 12245 [Note] InnoDB: Initializing buffer pool, size = 180.0G 2018-07-26 17:26:10 12245 [Note] InnoDB: Completed initialization of buffer pool 2018-07-26 17:26:11 12245 [Note] InnoDB: Highest supported file format is Barracuda. 2018-07-26 17:26:13 12245 [Note] InnoDB: 128 rollback segment(s) are active. 2018-07-26 17:26:13 12245 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 7933561206469 2018-07-26 17:26:16 12245 [Note] RSA private key file not found: /var/opt/data/snow/glide/mysql/data//private_key.pem. Some authentication plugins will not work. 2018-07-26 17:26:16 12245 [Note] RSA public key file not found: /var/opt/data/snow/glide/mysql/data//public_key.pem. Some authentication plugins will not work. 2018-07-26 17:26:16 12245 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2018-07-26 17:26:16 12245 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2018-07-26 17:26:16 12245 [Note] Server socket created on IP: '0.0.0.0'. 2018-07-26 17:26:16 12245 [Warning] Recovery from master pos 197586950 and file mysql-binlog.072699. Previous relay log pos and relay log file had been set to 197587116, /var/opt/data/snow/glide/mysql/relaylog/mysql-relay.037910 respectively. 2018-07-26 17:26:16 12245 [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-07-26 17:26:16 12245 [Note] Slave SQL thread initialized, starting replication in log 'mysql-binlog.072699' at position 197586950, relay log '/var/opt/data/snow/glide/mysql/relaylog/mysql-relay.037929' position: 4 2018-07-26 17:26:16 12245 [Note] Event Scheduler: Loaded 0 events 2018-07-26 17:26:16 12245 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.39-83.1-log' socket: '/tmp/mysql.sock' port: 3306 Percona Server (GPL), Release 83.1, Revision da5a1c2923f 2018-07-26 17:26:16 12245 [Note] Slave I/O thread: connected to master 'repl_clus@10.72.188.165:3306',replication started in log 'mysql-binlog.072699' at position 197586950 2018-07-26 17:29:18 12245 [Note] /usr/sbin/mysqld: Normal shutdown 2018-07-26 17:29:18 12245 [Note] Giving 2 client threads a chance to die gracefully 2018-07-26 17:29:18 12245 [Note] Event Scheduler: Purging the queue. 0 events 2018-07-26 17:29:18 12245 [Note] Shutting down slave threads 2018-07-26 17:29:18 12245 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-binlog.072700' at position 45493820 2018-07-26 17:29:18 12245 [Note] Slave I/O thread killed while reading event 2018-07-26 17:29:18 12245 [Note] Slave I/O thread exiting, read up to log 'mysql-binlog.072711', position 242580582 2018-07-26 17:29:18 12245 [Note] Forcefully disconnecting 0 remaining clients 2018-07-26 17:29:18 12245 [Note] Binlog end 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'partition' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_METRICS' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_CMP' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'INNODB_TRX' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'XTRADB_ZIP_DICT' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'XTRADB_RSEG' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'XTRADB_READ_VIEW' 2018-07-26 17:29:18 12245 [Note] Shutting down plugin 'InnoDB' 2018-07-26 17:29:18 12245 [Note] InnoDB: FTS optimize thread exiting. 2018-07-26 17:29:18 12245 [Note] InnoDB: Starting shutdown... 2018-07-26 17:29:18 12245 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2018-07-26 17:29:31 12245 [Note] InnoDB: Shutdown completed; log sequence number 7933743428666 2018-07-26 17:29:31 12245 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-07-26 17:29:31 12245 [Note] Shutting down plugin 'MyISAM' 2018-07-26 17:29:31 12245 [Note] Shutting down plugin 'MRG_MYISAM' 2018-07-26 17:29:31 12245 [Note] Shutting down plugin 'CSV' 2018-07-26 17:29:31 12245 [Note] Shutting down plugin 'MEMORY' 2018-07-26 17:29:31 12245 [Note] Shutting down plugin 'sha256_password' 2018-07-26 17:29:31 12245 [Note] Shutting down plugin 'mysql_old_password' 2018-07-26 17:29:31 12245 [Note] Shutting down plugin 'mysql_native_password' 2018-07-26 17:29:31 12245 [Note] Shutting down plugin 'binlog' 2018-07-26 17:29:31 12245 [Note] /usr/sbin/mysqld: Shutdown complete 2018-07-26 17:41:56 7527 [Note] Plugin 'BLACKHOLE' is disabled. 2018-07-26 17:41:56 7527 [Note] Plugin 'ARCHIVE' is disabled. 2018-07-26 17:41:56 7527 [Note] Plugin 'FEDERATED' is disabled. 2018-07-26 17:41:56 7ffab636a7e0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2018-07-26 17:41:56 7527 [Note] InnoDB: Using atomics to ref count buffer pool pages 2018-07-26 17:41:56 7527 [Note] InnoDB: The InnoDB memory heap is disabled 2018-07-26 17:41:56 7527 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-07-26 17:41:56 7527 [Note] InnoDB: Memory barrier is not used 2018-07-26 17:41:56 7527 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-07-26 17:41:56 7527 [Note] InnoDB: Using Linux native AIO 2018-07-26 17:41:56 7527 [Note] InnoDB: Using CPU crc32 instructions 2018-07-26 17:41:56 7527 [Note] InnoDB: Initializing buffer pool, size = 180.0G 2018-07-26 17:42:01 7527 [Note] InnoDB: Completed initialization of buffer pool 2018-07-26 17:42:02 7527 [Note] InnoDB: Highest supported file format is Barracuda. 2018-07-26 17:42:04 7527 [Note] InnoDB: 128 rollback segment(s) are active. 2018-07-26 17:42:04 7527 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 7933743428666 2018-07-26 17:42:06 7527 [Note] RSA private key file not found: /var/opt/data/snow/glide/mysql/data//private_key.pem. Some authentication plugins will not work. 2018-07-26 17:42:06 7527 [Note] RSA public key file not found: /var/opt/data/snow/glide/mysql/data//public_key.pem. Some authentication plugins will not work. 2018-07-26 17:42:06 7527 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2018-07-26 17:42:06 7527 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2018-07-26 17:42:06 7527 [Note] Server socket created on IP: '0.0.0.0'. 2018-07-26 17:42:06 7527 [Warning] Recovery from master pos 45493820 and file mysql-binlog.072700. Previous relay log pos and relay log file had been set to 45493986, /var/opt/data/snow/glide/mysql/relaylog/mysql-relay.037932 respectively. 2018-07-26 17:42:06 7527 [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-07-26 17:42:06 7527 [Note] Slave SQL thread initialized, starting replication in log 'mysql-binlog.072700' at position 45493820, relay log '/var/opt/data/snow/glide/mysql/relaylog/mysql-relay.037966' position: 4 2018-07-26 17:42:06 7527 [Note] Event Scheduler: Loaded 0 events 2018-07-26 17:42:06 7527 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.39-83.1-log' socket: '/tmp/mysql.sock' port: 3306 Percona Server (GPL), Release 83.1, Revision da5a1c2923f 2018-07-26 17:42:06 7527 [Note] Slave I/O thread: connected to master 'repl_clus@10.72.188.165:3306',replication started in log 'mysql-binlog.072700' at position 45493820 2018-07-26 17:51:03 7527 [Note] /usr/sbin/mysqld: Normal shutdown 2018-07-26 17:51:03 7527 [Note] Giving 2 client threads a chance to die gracefully 2018-07-26 17:51:03 7527 [Note] Event Scheduler: Purging the queue. 0 events 2018-07-26 17:51:03 7527 [Note] Shutting down slave threads 2018-07-26 17:51:03 7527 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-binlog.072701' at position 184328818 2018-07-26 17:51:03 7527 [Note] Slave I/O thread killed while reading event 2018-07-26 17:51:03 7527 [Note] Slave I/O thread exiting, read up to log 'mysql-binlog.072726', position 206350475 2018-07-26 17:51:03 7527 [Note] Forcefully disconnecting 0 remaining clients 2018-07-26 17:51:03 7527 [Note] Binlog end 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'partition' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_METRICS' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_CMP' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'INNODB_TRX' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'XTRADB_ZIP_DICT' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'XTRADB_RSEG' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'XTRADB_READ_VIEW' 2018-07-26 17:51:03 7527 [Note] Shutting down plugin 'InnoDB' 2018-07-26 17:51:03 7527 [Note] InnoDB: FTS optimize thread exiting. 2018-07-26 17:51:03 7527 [Note] InnoDB: Starting shutdown... 2018-07-26 17:51:04 7527 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2018-07-26 17:51:17 7527 [Note] InnoDB: Shutdown completed; log sequence number 7934364383301 2018-07-26 17:51:17 7527 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-07-26 17:51:17 7527 [Note] Shutting down plugin 'MyISAM' 2018-07-26 17:51:17 7527 [Note] Shutting down plugin 'MRG_MYISAM' 2018-07-26 17:51:17 7527 [Note] Shutting down plugin 'CSV' 2018-07-26 17:51:17 7527 [Note] Shutting down plugin 'MEMORY' 2018-07-26 17:51:17 7527 [Note] Shutting down plugin 'sha256_password' 2018-07-26 17:51:17 7527 [Note] Shutting down plugin 'mysql_old_password' 2018-07-26 17:51:17 7527 [Note] Shutting down plugin 'mysql_native_password' 2018-07-26 17:51:17 7527 [Note] Shutting down plugin 'binlog' 2018-07-26 17:51:17 7527 [Note] /usr/sbin/mysqld: Shutdown complete 2018-07-26 18:04:05 12734 [Note] Plugin 'BLACKHOLE' is disabled. 2018-07-26 18:04:05 12734 [Note] Plugin 'ARCHIVE' is disabled. 2018-07-26 18:04:05 12734 [Note] Plugin 'FEDERATED' is disabled. 2018-07-26 18:04:05 7f696d8047e0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2018-07-26 18:04:05 12734 [Note] InnoDB: Using atomics to ref count buffer pool pages 2018-07-26 18:04:05 12734 [Note] InnoDB: The InnoDB memory heap is disabled 2018-07-26 18:04:05 12734 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-07-26 18:04:05 12734 [Note] InnoDB: Memory barrier is not used 2018-07-26 18:04:05 12734 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-07-26 18:04:05 12734 [Note] InnoDB: Using Linux native AIO 2018-07-26 18:04:05 12734 [Note] InnoDB: Using CPU crc32 instructions 2018-07-26 18:04:05 12734 [Note] InnoDB: Initializing buffer pool, size = 180.0G 2018-07-26 18:04:10 12734 [Note] InnoDB: Completed initialization of buffer pool 2018-07-26 18:04:12 12734 [Note] InnoDB: Highest supported file format is Barracuda. 2018-07-26 18:04:14 12734 [Note] InnoDB: 128 rollback segment(s) are active. 2018-07-26 18:04:14 12734 [Note] InnoDB: Waiting for purge to start 2018-07-26 18:04:14 12734 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 7934364383301 2018-07-26 18:04:16 12734 [Note] RSA private key file not found: /var/opt/data/snow/glide/mysql/data//private_key.pem. Some authentication plugins will not work. 2018-07-26 18:04:16 12734 [Note] RSA public key file not found: /var/opt/data/snow/glide/mysql/data//public_key.pem. Some authentication plugins will not work. 2018-07-26 18:04:16 12734 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2018-07-26 18:04:16 12734 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2018-07-26 18:04:16 12734 [Note] Server socket created on IP: '0.0.0.0'. 2018-07-26 18:04:16 12734 [Warning] Recovery from master pos 184328818 and file mysql-binlog.072701. Previous relay log pos and relay log file had been set to 184328984, /var/opt/data/snow/glide/mysql/relaylog/mysql-relay.037969 respectively. 2018-07-26 18:04:16 12734 [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-07-26 18:04:16 12734 [Note] Slave SQL thread initialized, starting replication in log 'mysql-binlog.072701' at position 184328818, relay log '/var/opt/data/snow/glide/mysql/relaylog/mysql-relay.038045' position: 4 2018-07-26 18:04:16 12734 [Note] Slave I/O thread: connected to master 'repl_clus@10.72.188.165:3306',replication started in log 'mysql-binlog.072701' at position 184328818 2018-07-26 18:04:16 12734 [Note] Event Scheduler: Loaded 0 events 2018-07-26 18:04:16 12734 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.39-83.1-log' socket: '/tmp/mysql.sock' port: 3306 Percona Server (GPL), Release 83.1, Revision da5a1c2923f 2018-08-14 16:06:58 12734 [Note] Slave: received end packet from server due to dump thread being killed on master. Dump threads are killed for example during master shutdown, explicitly by a user, or when the master receives a binlog send request from a duplicate server UUID <96e43fdb-5d00-11e8-bbf9-0a94ef41aa87> : Error 2018-08-14 16:06:58 12734 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-binlog.077679' at position 110088207 2018-08-14 16:06:58 12734 [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-08-14 16:06:58 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 1, Error_code: 2003 2018-08-14 16:07:58 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 2, Error_code: 2003 2018-08-14 16:08:58 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 3, Error_code: 2003 2018-08-14 16:09:58 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 4, Error_code: 2003 2018-08-14 16:10:58 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 5, Error_code: 2003 2018-08-14 16:11:58 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 6, Error_code: 2003 2018-08-14 16:12:58 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 7, Error_code: 2003 2018-08-14 16:13:58 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 8, Error_code: 2003 2018-08-14 16:14:58 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 9, Error_code: 2003 2018-08-14 16:15:58 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 10, Error_code: 2003 2018-08-14 16:16:58 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 11, Error_code: 2003 2018-08-14 16:17:58 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 12, Error_code: 2003 2018-08-14 16:18:58 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 13, Error_code: 2003 2018-08-14 16:21:01 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 14, Error_code: 2003 2018-08-14 16:23:04 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 15, Error_code: 2003 2018-08-14 16:25:07 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 16, Error_code: 2003 2018-08-14 16:27:10 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 17, Error_code: 2003 2018-08-14 16:29:13 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 18, Error_code: 2003 2018-08-14 16:31:16 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 19, Error_code: 2003 2018-08-14 16:32:16 12734 [Note] Slave: connected to master 'repl_clus@10.72.188.165:3306',replication resumed in log 'mysql-binlog.077679' at position 110088207 2018-08-14 16:49:47 12734 [Note] Slave: received end packet from server due to dump thread being killed on master. Dump threads are killed for example during master shutdown, explicitly by a user, or when the master receives a binlog send request from a duplicate server UUID <96e43fdb-5d00-11e8-bbf9-0a94ef41aa87> : Error 2018-08-14 16:49:47 12734 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-binlog.077682' at position 241725501 2018-08-14 16:49:47 12734 [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-08-14 16:49:47 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 1, Error_code: 2003 2018-08-14 16:51:50 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 2, Error_code: 2003 2018-08-14 16:53:53 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 3, Error_code: 2003 2018-08-14 16:55:56 12734 [ERROR] Slave I/O: error reconnecting to master 'repl_clus@10.72.188.165:3306' - retry-time: 60 retries: 4, Error_code: 2003 2018-08-14 16:56:56 12734 [Note] Slave: connected to master 'repl_clus@10.72.188.165:3306',replication resumed in log 'mysql-binlog.077682' at position 241725501