tenant1.log/000755 000765 000024 00000000000 13250447467 013360 5ustar00tonystaff000000 000000 tenant1.log/tenant1-mysql-1.mysqld.err000644 000765 000024 00000070234 13250447412 020251 0ustar00tonystaff000000 000000 2018-03-09T07:53:38.572502Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=tenant1-mysql-1-bin' to avoid this problem. 2018-03-09T07:53:39.650698Z 0 [Warning] InnoDB: New log files created, LSN=47547 2018-03-09T07:53:39.778391Z 0 [Warning] InnoDB: The parameter innodb_undo_logs is deprecated and may be removed in future releases. Please use innodb_rollback_segments instead. See http://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html 2018-03-09T07:53:39.781346Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2018-03-09T07:53:39.844366Z 0 [Warning] unknown variable 'loose-group-replication-ip-whitelist=0.0.0.0/0' 2018-03-09T07:53:39.851574Z 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: faf4b36a-236e-11e8-8025-ee1df28cf30b. 2018-03-09T07:53:39.853652Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2018-03-09T07:53:39.858574Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed 2018-03-09T07:53:40.083112Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2018-03-09T07:53:40.749439Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:40.749509Z 1 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:40.749538Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:40.749570Z 1 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:40.749581Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:40.749598Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:40.749652Z 1 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:40.749668Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:43.068312Z 0 [Note] mysqld (mysqld 5.7.20-log) starting as process 61 ... 2018-03-09T07:53:43.071456Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=tenant1-mysql-1-bin' to avoid this problem. 2018-03-09T07:53:43.077058Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-03-09T07:53:43.077087Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-03-09T07:53:43.077093Z 0 [Note] InnoDB: Uses event mutexes 2018-03-09T07:53:43.077100Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-03-09T07:53:43.077105Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-03-09T07:53:43.077118Z 0 [Note] InnoDB: Using Linux native AIO 2018-03-09T07:53:43.077137Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 4 to 1 since innodb_buffer_pool_size is less than 1024 MiB 2018-03-09T07:53:43.077532Z 0 [Note] InnoDB: Number of pools: 1 2018-03-09T07:53:43.077700Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-03-09T07:53:43.081058Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-03-09T07:53:43.092531Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-03-09T07:53:43.095893Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-03-09T07:53:43.117648Z 0 [Note] InnoDB: Opened 2 undo tablespaces 2018-03-09T07:53:43.117667Z 0 [Note] InnoDB: 0 undo tablespaces made active 2018-03-09T07:53:43.117920Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-03-09T07:53:43.135758Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-03-09T07:53:43.135867Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-03-09T07:53:43.236585Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-03-09T07:53:43.236719Z 0 [Warning] InnoDB: The parameter innodb_undo_logs is deprecated and may be removed in future releases. Please use innodb_rollback_segments instead. See http://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html 2018-03-09T07:53:43.237576Z 0 [Note] InnoDB: 1 redo rollback segment(s) found. 1 redo rollback segment(s) are active. 2018-03-09T07:53:43.237594Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-03-09T07:53:43.238111Z 0 [Note] InnoDB: Waiting for purge to start 2018-03-09T07:53:43.289124Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 1389987 2018-03-09T07:53:43.289505Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-03-09T07:53:43.290106Z 0 [Note] Plugin 'ARCHIVE' is disabled. 2018-03-09T07:53:43.290121Z 0 [Note] Plugin 'BLACKHOLE' is disabled. 2018-03-09T07:53:43.290127Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-03-09T07:53:43.290132Z 0 [Note] Plugin 'partition' is disabled. 2018-03-09T07:53:43.299440Z 0 [Warning] unknown variable 'loose-group-replication-ip-whitelist=0.0.0.0/0' 2018-03-09T07:53:43.316607Z 0 [Note] Skipping generation of SSL certificates as options related to SSL are specified. 2018-03-09T07:53:43.317206Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed 2018-03-09T07:53:43.317228Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-03-09T07:53:43.326695Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:43.326757Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:43.326773Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:43.326806Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:43.326815Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:43.326836Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:43.332929Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180309 7:53:43 2018-03-09T07:53:43.342452Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:43.342505Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:43.366939Z 0 [Note] Event Scheduler: Loaded 0 events 2018-03-09T07:53:43.367280Z 0 [Note] mysqld: ready for connections. Version: '5.7.20-log' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) 2018-03-09T07:53:43.367308Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-03-09T07:53:43.367316Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-03-09T07:53:43.382283Z 0 [Note] End of list of non-natively partitioned tables 2018-03-09T07:53:46.564337Z 5 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:46.564385Z 5 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:46.564420Z 5 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:46.564436Z 5 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:46.564463Z 5 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:46.564556Z 5 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:46.564574Z 5 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:46.596333Z 7 [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=tenant1-mysql-1-relay-bin' to avoid this problem. 2018-03-09T07:53:46.604531Z 7 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. 2018-03-09T07:53:46.616087Z 0 [Note] Giving 0 client threads a chance to die gracefully 2018-03-09T07:53:46.616109Z 0 [Note] Shutting down slave threads 2018-03-09T07:53:46.616115Z 0 [Note] Forcefully disconnecting 0 remaining clients 2018-03-09T07:53:46.616125Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2018-03-09T07:53:46.617816Z 0 [Note] Binlog end 2018-03-09T07:53:46.619874Z 0 [Note] Shutting down plugin 'ngram' 2018-03-09T07:53:46.619897Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-03-09T07:53:46.619932Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-03-09T07:53:46.619942Z 0 [Note] Shutting down plugin 'MyISAM' 2018-03-09T07:53:46.619958Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-03-09T07:53:46.619963Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-03-09T07:53:46.619967Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-03-09T07:53:46.619971Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-03-09T07:53:46.619974Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-03-09T07:53:46.619978Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-03-09T07:53:46.619982Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-03-09T07:53:46.619985Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-03-09T07:53:46.619989Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-03-09T07:53:46.619992Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-03-09T07:53:46.619996Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-03-09T07:53:46.619999Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-03-09T07:53:46.620002Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-03-09T07:53:46.620006Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-03-09T07:53:46.620010Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-03-09T07:53:46.620013Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-03-09T07:53:46.620017Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-03-09T07:53:46.620021Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-03-09T07:53:46.620024Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-03-09T07:53:46.620028Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-03-09T07:53:46.620031Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-03-09T07:53:46.620035Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-03-09T07:53:46.620039Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-03-09T07:53:46.620042Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-03-09T07:53:46.620046Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-03-09T07:53:46.620049Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-03-09T07:53:46.620053Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-03-09T07:53:46.620056Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-03-09T07:53:46.620060Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-03-09T07:53:46.620063Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-03-09T07:53:46.620067Z 0 [Note] Shutting down plugin 'InnoDB' 2018-03-09T07:53:46.620136Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-03-09T07:53:46.620278Z 0 [Note] InnoDB: Starting shutdown... 2018-03-09T07:53:46.720456Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-03-09T07:53:46.720977Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180309 7:53:46 2018-03-09T07:53:48.131839Z 0 [Note] InnoDB: Shutdown completed; log sequence number 10687102 2018-03-09T07:53:48.131995Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-03-09T07:53:48.132010Z 0 [Note] Shutting down plugin 'MEMORY' 2018-03-09T07:53:48.132016Z 0 [Note] Shutting down plugin 'CSV' 2018-03-09T07:53:48.132023Z 0 [Note] Shutting down plugin 'sha256_password' 2018-03-09T07:53:48.132027Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-03-09T07:53:48.132164Z 0 [Note] Shutting down plugin 'binlog' 2018-03-09T07:53:48.135386Z 0 [Note] mysqld: Shutdown complete 2018-03-09T07:53:48.519164Z 0 [Note] mysqld (mysqld 5.7.20-log) starting as process 1 ... 2018-03-09T07:53:48.522224Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=tenant1-mysql-1-bin' to avoid this problem. 2018-03-09T07:53:48.530027Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-03-09T07:53:48.530055Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-03-09T07:53:48.530061Z 0 [Note] InnoDB: Uses event mutexes 2018-03-09T07:53:48.530068Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-03-09T07:53:48.530073Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-03-09T07:53:48.530078Z 0 [Note] InnoDB: Using Linux native AIO 2018-03-09T07:53:48.530097Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 4 to 1 since innodb_buffer_pool_size is less than 1024 MiB 2018-03-09T07:53:48.530498Z 0 [Note] InnoDB: Number of pools: 1 2018-03-09T07:53:48.530677Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-03-09T07:53:48.533756Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-03-09T07:53:48.545148Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-03-09T07:53:48.548548Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-03-09T07:53:48.570283Z 0 [Note] InnoDB: Opened 2 undo tablespaces 2018-03-09T07:53:48.570299Z 0 [Note] InnoDB: 0 undo tablespaces made active 2018-03-09T07:53:48.570593Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-03-09T07:53:48.588678Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-03-09T07:53:48.588822Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-03-09T07:53:48.691787Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-03-09T07:53:48.691914Z 0 [Warning] InnoDB: The parameter innodb_undo_logs is deprecated and may be removed in future releases. Please use innodb_rollback_segments instead. See http://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html 2018-03-09T07:53:48.692751Z 0 [Note] InnoDB: 1 redo rollback segment(s) found. 1 redo rollback segment(s) are active. 2018-03-09T07:53:48.692767Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-03-09T07:53:48.693562Z 0 [Note] InnoDB: Waiting for purge to start 2018-03-09T07:53:48.744823Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 10687102 2018-03-09T07:53:48.745053Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-03-09T07:53:48.745620Z 0 [Note] Plugin 'ARCHIVE' is disabled. 2018-03-09T07:53:48.745640Z 0 [Note] Plugin 'BLACKHOLE' is disabled. 2018-03-09T07:53:48.745647Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-03-09T07:53:48.745654Z 0 [Note] Plugin 'partition' is disabled. 2018-03-09T07:53:48.775238Z 0 [Note] Skipping generation of SSL certificates as options related to SSL are specified. 2018-03-09T07:53:48.775688Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed 2018-03-09T07:53:48.775717Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-03-09T07:53:48.776225Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2018-03-09T07:53:48.776296Z 0 [Note] IPv6 is available. 2018-03-09T07:53:48.776310Z 0 [Note] - '::' resolves to '::'; 2018-03-09T07:53:48.776345Z 0 [Note] Server socket created on IP: '::'. 2018-03-09T07:53:48.786338Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:48.786355Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:48.786381Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:48.786387Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:48.786409Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:48.808061Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:48.808082Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:53:48.819862Z 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=tenant1-mysql-1-relay-bin' to avoid this problem. 2018-03-09T07:53:48.824731Z 0 [Note] Relay log recovery skipped for group replication channel. 2018-03-09T07:53:48.824750Z 0 [Warning] Recovery from master pos 4 and file for channel 'group_replication_recovery'. Previous relay log pos and relay log file had been set to 4, ./tenant1-mysql-1-relay-bin-group_replication_recovery.000001 respectively. 2018-03-09T07:53:48.834566Z 0 [Note] Event Scheduler: Loaded 0 events 2018-03-09T07:53:48.834862Z 0 [Note] mysqld: ready for connections. Version: '5.7.20-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2018-03-09T07:53:48.834895Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-03-09T07:53:48.834906Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-03-09T07:53:48.843622Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180309 7:53:48 2018-03-09T07:53:48.849647Z 0 [Note] End of list of non-natively partitioned tables 2018-03-09T07:53:48.850246Z 3 [Note] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "DISABLED"' 2018-03-09T07:53:48.859341Z 3 [Warning] Plugin group_replication reported: '[GCS] Peer address "tenant1-mysql-1.mysql:6606" is not valid.' 2018-03-09T07:53:48.859359Z 3 [Warning] Plugin group_replication reported: '[GCS] Peer address "tenant1-mysql-2.mysql:6606" is not valid.' 2018-03-09T07:53:48.859466Z 3 [Note] Plugin group_replication reported: '[GCS] Translated 'tenant1-mysql-1.mysql.default.svc.cluster.local' to 192.168.181.22' 2018-03-09T07:53:48.865069Z 3 [Warning] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.' 2018-03-09T07:53:48.865144Z 3 [Note] Plugin group_replication reported: '[GCS] SSL was not enabled' 2018-03-09T07:53:48.865161Z 3 [Note] Plugin group_replication reported: 'Initialized group communication with configuration: group_replication_group_name: "925deea1-75db-4e92-86a9-00259c8d8078"; group_replication_local_address: "tenant1-mysql-1.mysql.default.svc.cluster.local:6606"; group_replication_group_seeds: "tenant1-mysql-0.mysql:6606,tenant1-mysql-1.mysql:6606,tenant1-mysql-2.mysql:6606"; group_replication_bootstrap_group: false; group_replication_poll_spin_loops: 0; group_replication_compression_threshold: 1000000; group_replication_ip_whitelist: "0.0.0.0/0"' 2018-03-09T07:53:48.865204Z 3 [Note] Plugin group_replication reported: 'Member configuration: member_id: 101; member_uuid: "faf4b36a-236e-11e8-8025-ee1df28cf30b"; single-primary mode: "true"; group_replication_auto_increment_increment: 7; ' 2018-03-09T07:53:48.878188Z 4 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. 2018-03-09T07:53:48.904052Z 7 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log './tenant1-mysql-1-relay-bin-group_replication_applier.000001' position: 4 2018-03-09T07:53:48.904050Z 3 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!' 2018-03-09T07:53:48.904117Z 3 [Note] Plugin group_replication reported: 'auto_increment_increment is set to 7' 2018-03-09T07:53:48.904127Z 3 [Note] Plugin group_replication reported: 'auto_increment_offset is set to 101' 2018-03-09T07:53:48.904371Z 0 [Note] Plugin group_replication reported: 'state 0 action xa_init' 2018-03-09T07:53:48.938428Z 0 [Note] Plugin group_replication reported: 'Successfully bound to 0.0.0.0:6606 (socket=49).' 2018-03-09T07:53:48.938458Z 0 [Note] Plugin group_replication reported: 'Successfully set listen backlog to 32 (socket=49)!' 2018-03-09T07:53:48.938468Z 0 [Note] Plugin group_replication reported: 'Successfully unblocked socket (socket=49)!' 2018-03-09T07:53:48.938533Z 0 [Note] Plugin group_replication reported: 'Ready to accept incoming connections on 0.0.0.0:6606 (socket=49)!' 2018-03-09T07:53:48.938532Z 0 [Note] Plugin group_replication reported: 'connecting to tenant1-mysql-1.mysql.default.svc.cluster.local 6606' 2018-03-09T07:53:48.938811Z 0 [Note] Plugin group_replication reported: 'client connected to tenant1-mysql-1.mysql.default.svc.cluster.local 6606 fd 51' 2018-03-09T07:53:48.939162Z 0 [Note] Plugin group_replication reported: 'connecting to tenant1-mysql-1.mysql.default.svc.cluster.local 6606' 2018-03-09T07:53:48.939332Z 0 [Note] Plugin group_replication reported: 'client connected to tenant1-mysql-1.mysql.default.svc.cluster.local 6606 fd 53' 2018-03-09T07:53:48.939663Z 0 [Note] Plugin group_replication reported: 'connecting to tenant1-mysql-1.mysql.default.svc.cluster.local 6606' 2018-03-09T07:53:48.939869Z 0 [Note] Plugin group_replication reported: 'client connected to tenant1-mysql-1.mysql.default.svc.cluster.local 6606 fd 55' 2018-03-09T07:53:48.940221Z 0 [Note] Plugin group_replication reported: 'connecting to tenant1-mysql-1.mysql.default.svc.cluster.local 6606' 2018-03-09T07:53:48.940414Z 0 [Note] Plugin group_replication reported: 'client connected to tenant1-mysql-1.mysql.default.svc.cluster.local 6606 fd 57' 2018-03-09T07:53:48.940804Z 0 [Note] Plugin group_replication reported: 'connecting to tenant1-mysql-1.mysql.default.svc.cluster.local 6606' 2018-03-09T07:53:48.940995Z 0 [Note] Plugin group_replication reported: 'client connected to tenant1-mysql-1.mysql.default.svc.cluster.local 6606 fd 59' 2018-03-09T07:53:48.941357Z 0 [Note] Plugin group_replication reported: 'connecting to tenant1-mysql-1.mysql.default.svc.cluster.local 6606' 2018-03-09T07:53:48.941561Z 0 [Note] Plugin group_replication reported: 'client connected to tenant1-mysql-1.mysql.default.svc.cluster.local 6606 fd 61' 2018-03-09T07:53:48.941931Z 0 [Note] Plugin group_replication reported: 'connecting to tenant1-mysql-0.mysql 6606' 2018-03-09T07:53:48.942892Z 0 [Note] Plugin group_replication reported: 'client connected to tenant1-mysql-0.mysql 6606 fd 63' 2018-03-09T07:53:51.958849Z 0 [Note] Plugin group_replication reported: 'state 4337 action xa_snapshot' 2018-03-09T07:53:51.960839Z 0 [Note] Plugin group_replication reported: 'new state x_recover' 2018-03-09T07:53:51.960855Z 0 [Note] Plugin group_replication reported: 'state 4357 action xa_complete' 2018-03-09T07:53:51.961091Z 0 [Note] Plugin group_replication reported: 'new state x_run' 2018-03-09T07:53:52.907349Z 15 [Note] Aborted connection 15 to db: 'unconnected' user: 'root' host: '192.168.71.21' (Got an error reading communication packets) 2018-03-09T07:53:53.301851Z 3 [Note] Plugin group_replication reported: 'This server is working as secondary member with primary member address tenant1-mysql-0.mysql:3306.' 2018-03-09T07:53:53.302136Z 18 [Note] Plugin group_replication reported: 'Establishing group recovery connection with a possible donor. Attempt 1/200' 2018-03-09T07:53:53.302227Z 0 [Note] Plugin group_replication reported: 'Group membership changed to tenant1-mysql-0.mysql:3306, tenant1-mysql-1.mysql:3306 on view 15205820123067686:2.' 2018-03-09T07:53:53.316162Z 18 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='tenant1-mysql-0.mysql', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. 2018-03-09T07:53:53.332829Z 18 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor f068bc14-236e-11e8-bfcf-76820757d241 at tenant1-mysql-0.mysql port: 3306.' 2018-03-09T07:53:53.333208Z 20 [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-03-09T07:53:53.336859Z 20 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'root@tenant1-mysql-0.mysql:3306',replication started in log 'FIRST' at position 4 2018-03-09T07:53:53.343373Z 21 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log 'FIRST' at position 0, relay log './tenant1-mysql-1-relay-bin-group_replication_recovery.000001' position: 4 2018-03-09T07:53:53.360184Z 18 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and purging the corresponding logs.' 2018-03-09T07:53:53.364032Z 20 [Note] Slave I/O thread killed while reading event for channel 'group_replication_recovery' 2018-03-09T07:53:53.364050Z 20 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'tenant1-mysql-0-bin.000002', position 758 2018-03-09T07:53:53.380855Z 18 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='tenant1-mysql-0.mysql', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. 2018-03-09T07:53:53.398593Z 0 [Note] Plugin group_replication reported: 'This server was declared online within the replication group' 2018-03-09T07:54:03.803791Z 0 [Note] Plugin group_replication reported: 'getstart group_id 2e0493c8' 2018-03-09T07:54:08.016271Z 0 [Note] Plugin group_replication reported: 'Members joined the group: tenant1-mysql-2.mysql:3306' 2018-03-09T07:54:08.016406Z 0 [Note] Plugin group_replication reported: 'Group membership changed to tenant1-mysql-2.mysql:3306, tenant1-mysql-0.mysql:3306, tenant1-mysql-1.mysql:3306 on view 15205820123067686:3.' 2018-03-09T07:54:08.062821Z 37 [Note] Start binlog_dump to master_thread_id(37) slave_server(102), pos(, 4) 2018-03-09T07:54:08.123654Z 0 [Note] Plugin group_replication reported: 'The member with address tenant1-mysql-2.mysql:3306 was declared online within the replication group' 2018-03-09T07:54:09.942187Z 4 [Note] Plugin group_replication reported: 'Primary had applied all relay logs, disabled conflict detection' 2018-03-09T07:54:09.949697Z 37 [Note] Aborted connection 37 to db: 'unconnected' user: 'root' host: '192.168.71.21' (failed on flush_net()) 2018-03-09T08:39:57.346553Z 1691 [Note] Aborted connection 1691 to db: 'unconnected' user: 'root' host: '192.168.181.22' (Got an error reading communication packets) 2018-03-09T08:48:49.482822Z 2012 [Note] Aborted connection 2012 to db: 'unconnected' user: 'root' host: '192.168.181.22' (Got an error reading communication packets) tenant1.log/tenant1-mysql-2.mysqld.err000644 000765 000024 00000065340 13250447424 020257 0ustar00tonystaff000000 000000 2018-03-09T07:51:01.092154Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=tenant1-mysql-2-bin' to avoid this problem. 2018-03-09T07:51:02.235504Z 0 [Warning] InnoDB: New log files created, LSN=47547 2018-03-09T07:51:02.534058Z 0 [Warning] InnoDB: The parameter innodb_undo_logs is deprecated and may be removed in future releases. Please use innodb_rollback_segments instead. See http://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html 2018-03-09T07:51:02.537698Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2018-03-09T07:51:02.602030Z 0 [Warning] unknown variable 'loose-group-replication-ip-whitelist=0.0.0.0/0' 2018-03-09T07:51:02.610471Z 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: 9d3b9ca4-236e-11e8-bc53-46af227730b0. 2018-03-09T07:51:02.612216Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2018-03-09T07:51:02.617481Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed 2018-03-09T07:51:02.709688Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2018-03-09T07:51:03.417984Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:03.418007Z 1 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:03.418015Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:03.418033Z 1 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:03.418038Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:03.418050Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:03.418077Z 1 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:03.418086Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:05.852654Z 0 [Note] mysqld (mysqld 5.7.20-log) starting as process 66 ... 2018-03-09T07:51:05.855977Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=tenant1-mysql-2-bin' to avoid this problem. 2018-03-09T07:51:05.861840Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-03-09T07:51:05.861864Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-03-09T07:51:05.861870Z 0 [Note] InnoDB: Uses event mutexes 2018-03-09T07:51:05.861876Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-03-09T07:51:05.861886Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-03-09T07:51:05.861891Z 0 [Note] InnoDB: Using Linux native AIO 2018-03-09T07:51:05.861909Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 4 to 1 since innodb_buffer_pool_size is less than 1024 MiB 2018-03-09T07:51:05.862350Z 0 [Note] InnoDB: Number of pools: 1 2018-03-09T07:51:05.862517Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-03-09T07:51:05.866056Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-03-09T07:51:05.877956Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-03-09T07:51:05.881191Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-03-09T07:51:05.907942Z 0 [Note] InnoDB: Opened 2 undo tablespaces 2018-03-09T07:51:05.907957Z 0 [Note] InnoDB: 0 undo tablespaces made active 2018-03-09T07:51:05.908316Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-03-09T07:51:05.928829Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-03-09T07:51:05.928926Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-03-09T07:51:06.041094Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-03-09T07:51:06.041413Z 0 [Warning] InnoDB: The parameter innodb_undo_logs is deprecated and may be removed in future releases. Please use innodb_rollback_segments instead. See http://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html 2018-03-09T07:51:06.042922Z 0 [Note] InnoDB: 1 redo rollback segment(s) found. 1 redo rollback segment(s) are active. 2018-03-09T07:51:06.042938Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-03-09T07:51:06.043603Z 0 [Note] InnoDB: Waiting for purge to start 2018-03-09T07:51:06.094849Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 1389987 2018-03-09T07:51:06.095228Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-03-09T07:51:06.095707Z 0 [Note] Plugin 'ARCHIVE' is disabled. 2018-03-09T07:51:06.095718Z 0 [Note] Plugin 'BLACKHOLE' is disabled. 2018-03-09T07:51:06.095724Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-03-09T07:51:06.095729Z 0 [Note] Plugin 'partition' is disabled. 2018-03-09T07:51:06.106182Z 0 [Warning] unknown variable 'loose-group-replication-ip-whitelist=0.0.0.0/0' 2018-03-09T07:51:06.124792Z 0 [Note] Skipping generation of SSL certificates as options related to SSL are specified. 2018-03-09T07:51:06.125216Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed 2018-03-09T07:51:06.125230Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-03-09T07:51:06.138715Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:06.138758Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:06.138767Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:06.138790Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:06.138796Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:06.138809Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:06.150302Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180309 7:51:06 2018-03-09T07:51:06.159210Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:06.159251Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:06.182013Z 0 [Note] Event Scheduler: Loaded 0 events 2018-03-09T07:51:06.182207Z 0 [Note] mysqld: ready for connections. Version: '5.7.20-log' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) 2018-03-09T07:51:06.182225Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-03-09T07:51:06.182229Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-03-09T07:51:06.196537Z 0 [Note] End of list of non-natively partitioned tables 2018-03-09T07:51:09.451724Z 5 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:09.451751Z 5 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:09.451778Z 5 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:09.451791Z 5 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:09.451817Z 5 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:09.451888Z 5 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:09.451908Z 5 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:09.483387Z 7 [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=tenant1-mysql-2-relay-bin' to avoid this problem. 2018-03-09T07:51:09.491133Z 7 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. 2018-03-09T07:51:09.502585Z 0 [Note] Giving 0 client threads a chance to die gracefully 2018-03-09T07:51:09.502606Z 0 [Note] Shutting down slave threads 2018-03-09T07:51:09.502611Z 0 [Note] Forcefully disconnecting 0 remaining clients 2018-03-09T07:51:09.502620Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2018-03-09T07:51:09.504332Z 0 [Note] Binlog end 2018-03-09T07:51:09.506274Z 0 [Note] Shutting down plugin 'ngram' 2018-03-09T07:51:09.506293Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-03-09T07:51:09.506319Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-03-09T07:51:09.506324Z 0 [Note] Shutting down plugin 'MyISAM' 2018-03-09T07:51:09.506332Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-03-09T07:51:09.506336Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-03-09T07:51:09.506340Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-03-09T07:51:09.506343Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-03-09T07:51:09.506347Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-03-09T07:51:09.506350Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-03-09T07:51:09.506354Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-03-09T07:51:09.506357Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-03-09T07:51:09.506360Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-03-09T07:51:09.506364Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-03-09T07:51:09.506367Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-03-09T07:51:09.506371Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-03-09T07:51:09.506374Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-03-09T07:51:09.506377Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-03-09T07:51:09.506381Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-03-09T07:51:09.506384Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-03-09T07:51:09.506388Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-03-09T07:51:09.506392Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-03-09T07:51:09.506395Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-03-09T07:51:09.506398Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-03-09T07:51:09.506402Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-03-09T07:51:09.506405Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-03-09T07:51:09.506409Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-03-09T07:51:09.506412Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-03-09T07:51:09.506416Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-03-09T07:51:09.506419Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-03-09T07:51:09.506423Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-03-09T07:51:09.506426Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-03-09T07:51:09.506430Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-03-09T07:51:09.506433Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-03-09T07:51:09.506437Z 0 [Note] Shutting down plugin 'InnoDB' 2018-03-09T07:51:09.506524Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-03-09T07:51:09.506641Z 0 [Note] InnoDB: Starting shutdown... 2018-03-09T07:51:09.606797Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-03-09T07:51:09.607356Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180309 7:51:09 2018-03-09T07:51:11.018350Z 0 [Note] InnoDB: Shutdown completed; log sequence number 10687102 2018-03-09T07:51:11.018490Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-03-09T07:51:11.018502Z 0 [Note] Shutting down plugin 'MEMORY' 2018-03-09T07:51:11.018509Z 0 [Note] Shutting down plugin 'CSV' 2018-03-09T07:51:11.018514Z 0 [Note] Shutting down plugin 'sha256_password' 2018-03-09T07:51:11.018518Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-03-09T07:51:11.018646Z 0 [Note] Shutting down plugin 'binlog' 2018-03-09T07:51:11.021729Z 0 [Note] mysqld: Shutdown complete 2018-03-09T07:51:11.390864Z 0 [Note] mysqld (mysqld 5.7.20-log) starting as process 1 ... 2018-03-09T07:51:11.393958Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=tenant1-mysql-2-bin' to avoid this problem. 2018-03-09T07:51:11.399476Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-03-09T07:51:11.399500Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-03-09T07:51:11.399506Z 0 [Note] InnoDB: Uses event mutexes 2018-03-09T07:51:11.399512Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-03-09T07:51:11.399517Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-03-09T07:51:11.399521Z 0 [Note] InnoDB: Using Linux native AIO 2018-03-09T07:51:11.399539Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 4 to 1 since innodb_buffer_pool_size is less than 1024 MiB 2018-03-09T07:51:11.399904Z 0 [Note] InnoDB: Number of pools: 1 2018-03-09T07:51:11.400066Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-03-09T07:51:11.403398Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-03-09T07:51:11.414783Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-03-09T07:51:11.417926Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-03-09T07:51:11.444095Z 0 [Note] InnoDB: Opened 2 undo tablespaces 2018-03-09T07:51:11.444110Z 0 [Note] InnoDB: 0 undo tablespaces made active 2018-03-09T07:51:11.444379Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-03-09T07:51:11.464425Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-03-09T07:51:11.464516Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-03-09T07:51:11.573502Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-03-09T07:51:11.573634Z 0 [Warning] InnoDB: The parameter innodb_undo_logs is deprecated and may be removed in future releases. Please use innodb_rollback_segments instead. See http://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html 2018-03-09T07:51:11.574456Z 0 [Note] InnoDB: 1 redo rollback segment(s) found. 1 redo rollback segment(s) are active. 2018-03-09T07:51:11.574469Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-03-09T07:51:11.575019Z 0 [Note] InnoDB: Waiting for purge to start 2018-03-09T07:51:11.626003Z 0 [Note] InnoDB: 5.7.20 started; log sequence number 10687102 2018-03-09T07:51:11.626281Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-03-09T07:51:11.626743Z 0 [Note] Plugin 'ARCHIVE' is disabled. 2018-03-09T07:51:11.626757Z 0 [Note] Plugin 'BLACKHOLE' is disabled. 2018-03-09T07:51:11.626764Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-03-09T07:51:11.626770Z 0 [Note] Plugin 'partition' is disabled. 2018-03-09T07:51:11.659875Z 0 [Note] Skipping generation of SSL certificates as options related to SSL are specified. 2018-03-09T07:51:11.660299Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed 2018-03-09T07:51:11.660323Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2018-03-09T07:51:11.660923Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2018-03-09T07:51:11.660980Z 0 [Note] IPv6 is available. 2018-03-09T07:51:11.660992Z 0 [Note] - '::' resolves to '::'; 2018-03-09T07:51:11.661026Z 0 [Note] Server socket created on IP: '::'. 2018-03-09T07:51:11.673811Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:11.673827Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:11.673852Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:11.673857Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:11.673873Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:11.699931Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:11.699950Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-03-09T07:51:11.720736Z 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=tenant1-mysql-2-relay-bin' to avoid this problem. 2018-03-09T07:51:11.726613Z 0 [Note] Relay log recovery skipped for group replication channel. 2018-03-09T07:51:11.726630Z 0 [Warning] Recovery from master pos 4 and file for channel 'group_replication_recovery'. Previous relay log pos and relay log file had been set to 4, ./tenant1-mysql-2-relay-bin-group_replication_recovery.000001 respectively. 2018-03-09T07:51:11.736090Z 0 [Note] Event Scheduler: Loaded 0 events 2018-03-09T07:51:11.736500Z 0 [Note] mysqld: ready for connections. Version: '5.7.20-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2018-03-09T07:51:11.736524Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-03-09T07:51:11.736529Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-03-09T07:51:11.750633Z 0 [Note] End of list of non-natively partitioned tables 2018-03-09T07:51:11.751197Z 3 [Note] Plugin group_replication reported: 'Group communication SSL configuration: group_replication_ssl_mode: "DISABLED"' 2018-03-09T07:51:11.757632Z 3 [Warning] Plugin group_replication reported: '[GCS] Peer address "tenant1-mysql-2.mysql:6606" is not valid.' 2018-03-09T07:51:11.757734Z 3 [Note] Plugin group_replication reported: '[GCS] Translated 'tenant1-mysql-2.mysql.default.svc.cluster.local' to 192.168.71.21' 2018-03-09T07:51:11.759368Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180309 7:51:11 2018-03-09T07:51:11.760065Z 3 [Warning] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the whitelist. It is mandatory that it is added.' 2018-03-09T07:51:11.760135Z 3 [Note] Plugin group_replication reported: '[GCS] SSL was not enabled' 2018-03-09T07:51:11.760163Z 3 [Note] Plugin group_replication reported: 'Initialized group communication with configuration: group_replication_group_name: "925deea1-75db-4e92-86a9-00259c8d8078"; group_replication_local_address: "tenant1-mysql-2.mysql.default.svc.cluster.local:6606"; group_replication_group_seeds: "tenant1-mysql-0.mysql:6606,tenant1-mysql-1.mysql:6606,tenant1-mysql-2.mysql:6606"; group_replication_bootstrap_group: false; group_replication_poll_spin_loops: 0; group_replication_compression_threshold: 1000000; group_replication_ip_whitelist: "0.0.0.0/0"' 2018-03-09T07:51:11.760209Z 3 [Note] Plugin group_replication reported: 'Member configuration: member_id: 102; member_uuid: "9d3b9ca4-236e-11e8-bc53-46af227730b0"; single-primary mode: "true"; group_replication_auto_increment_increment: 7; ' 2018-03-09T07:51:11.774006Z 4 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. 2018-03-09T07:51:11.803021Z 3 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!' 2018-03-09T07:51:11.803024Z 7 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log './tenant1-mysql-2-relay-bin-group_replication_applier.000001' position: 4 2018-03-09T07:51:11.803062Z 3 [Note] Plugin group_replication reported: 'auto_increment_increment is set to 7' 2018-03-09T07:51:11.803090Z 3 [Note] Plugin group_replication reported: 'auto_increment_offset is set to 102' 2018-03-09T07:51:11.803271Z 0 [Note] Plugin group_replication reported: 'state 0 action xa_init' 2018-03-09T07:51:11.836984Z 0 [Note] Plugin group_replication reported: 'Successfully bound to 0.0.0.0:6606 (socket=49).' 2018-03-09T07:51:11.837007Z 0 [Note] Plugin group_replication reported: 'Successfully set listen backlog to 32 (socket=49)!' 2018-03-09T07:51:11.837016Z 0 [Note] Plugin group_replication reported: 'Successfully unblocked socket (socket=49)!' 2018-03-09T07:51:11.837058Z 0 [Note] Plugin group_replication reported: 'connecting to tenant1-mysql-2.mysql.default.svc.cluster.local 6606' 2018-03-09T07:51:11.837063Z 0 [Note] Plugin group_replication reported: 'Ready to accept incoming connections on 0.0.0.0:6606 (socket=49)!' 2018-03-09T07:51:11.837303Z 0 [Note] Plugin group_replication reported: 'client connected to tenant1-mysql-2.mysql.default.svc.cluster.local 6606 fd 51' 2018-03-09T07:51:11.837583Z 0 [Note] Plugin group_replication reported: 'connecting to tenant1-mysql-2.mysql.default.svc.cluster.local 6606' 2018-03-09T07:51:11.837742Z 0 [Note] Plugin group_replication reported: 'client connected to tenant1-mysql-2.mysql.default.svc.cluster.local 6606 fd 53' 2018-03-09T07:51:11.837976Z 0 [Note] Plugin group_replication reported: 'connecting to tenant1-mysql-2.mysql.default.svc.cluster.local 6606' 2018-03-09T07:51:11.838119Z 0 [Note] Plugin group_replication reported: 'client connected to tenant1-mysql-2.mysql.default.svc.cluster.local 6606 fd 55' 2018-03-09T07:51:11.838367Z 0 [Note] Plugin group_replication reported: 'connecting to tenant1-mysql-2.mysql.default.svc.cluster.local 6606' 2018-03-09T07:51:11.838518Z 0 [Note] Plugin group_replication reported: 'client connected to tenant1-mysql-2.mysql.default.svc.cluster.local 6606 fd 57' 2018-03-09T07:51:11.838757Z 0 [Note] Plugin group_replication reported: 'connecting to tenant1-mysql-2.mysql.default.svc.cluster.local 6606' 2018-03-09T07:51:11.838898Z 0 [Note] Plugin group_replication reported: 'client connected to tenant1-mysql-2.mysql.default.svc.cluster.local 6606 fd 59' 2018-03-09T07:51:11.839128Z 0 [Note] Plugin group_replication reported: 'connecting to tenant1-mysql-2.mysql.default.svc.cluster.local 6606' 2018-03-09T07:51:11.839277Z 0 [Note] Plugin group_replication reported: 'client connected to tenant1-mysql-2.mysql.default.svc.cluster.local 6606 fd 61' 2018-03-09T07:51:11.839519Z 0 [Note] Plugin group_replication reported: 'connecting to tenant1-mysql-0.mysql 6606' 2018-03-09T07:51:11.840131Z 0 [Note] Plugin group_replication reported: 'client connected to tenant1-mysql-0.mysql 6606 fd 63' 2018-03-09T07:51:14.951265Z 0 [Note] Plugin group_replication reported: 'state 4337 action xa_snapshot' 2018-03-09T07:51:14.954005Z 0 [Note] Plugin group_replication reported: 'new state x_recover' 2018-03-09T07:51:14.954027Z 0 [Note] Plugin group_replication reported: 'state 4357 action xa_complete' 2018-03-09T07:51:14.954336Z 0 [Note] Plugin group_replication reported: 'new state x_run' 2018-03-09T07:51:16.053627Z 3 [Note] Plugin group_replication reported: 'This server is working as secondary member with primary member address tenant1-mysql-0.mysql:3306.' 2018-03-09T07:51:16.053862Z 18 [Note] Plugin group_replication reported: 'Establishing group recovery connection with a possible donor. Attempt 1/200' 2018-03-09T07:51:16.053912Z 0 [Note] Plugin group_replication reported: 'Group membership changed to tenant1-mysql-2.mysql:3306, tenant1-mysql-0.mysql:3306, tenant1-mysql-1.mysql:3306 on view 15205820123067686:3.' 2018-03-09T07:51:16.070051Z 18 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='tenant1-mysql-1.mysql', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. 2018-03-09T07:51:16.086763Z 18 [Note] Plugin group_replication reported: 'Establishing connection to a group replication recovery donor faf4b36a-236e-11e8-8025-ee1df28cf30b at tenant1-mysql-1.mysql port: 3306.' 2018-03-09T07:51:16.087053Z 20 [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-03-09T07:51:16.089071Z 20 [Note] Slave I/O thread for channel 'group_replication_recovery': connected to master 'root@tenant1-mysql-1.mysql:3306',replication started in log 'FIRST' at position 4 2018-03-09T07:51:16.097482Z 21 [Note] Slave SQL thread for channel 'group_replication_recovery' initialized, starting replication in log 'FIRST' at position 0, relay log './tenant1-mysql-2-relay-bin-group_replication_recovery.000001' position: 4 2018-03-09T07:51:16.117497Z 18 [Note] Plugin group_replication reported: 'Terminating existing group replication donor connection and purging the corresponding logs.' 2018-03-09T07:51:16.121866Z 20 [Note] Slave I/O thread killed while reading event for channel 'group_replication_recovery' 2018-03-09T07:51:16.121880Z 20 [Note] Slave I/O thread exiting for channel 'group_replication_recovery', read up to log 'tenant1-mysql-1-bin.000002', position 1082 2018-03-09T07:51:16.142097Z 18 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='tenant1-mysql-1.mysql', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. 2018-03-09T07:51:16.161206Z 0 [Note] Plugin group_replication reported: 'This server was declared online within the replication group' 2018-03-09T07:51:17.979614Z 4 [Note] Plugin group_replication reported: 'Primary had applied all relay logs, disabled conflict detection'