2019-11-04 12:55:17 140692352591616 [ERROR] InnoDB: Page 38:4016 may be corrupted. Post encryption checksum 3690179534 stored [3690179534:3690179534] key_version 1 2019-11-04 12:55:17 140692352591616 [ERROR] InnoDB: Unable to decompress ./dba/mgdbdbgrowth.ibd[page id: space=38, page number=4016] 2019-11-04 12:55:17 140692352591616 [Note] InnoDB: Row compressed page could be encrypted with key_version 1 ... 2019-11-04 14:32:34 140692341532416 [ERROR] Got error 192 when reading table './dba/mgdbdbgrowth' ... <<< switching database role due to table not being readable anymore >>> 2019-11-04 17:08:51 140692342454016 [Note] Deleted Master_info file '/usr/local/mysql/data/master.info'. 2019-11-04 17:08:51 140692342454016 [Note] Deleted Master_info file '/usr/local/mysql/data/relay-log.info'. 2019-11-04 17:08:51 140692342454016 [Note] Master connection name: '' Master_info_file: 'master.info' Relay_info_file: 'relay-log.info' 2019-11-04 17:08:51 140692342454016 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='mariaprod', master_port='8801', master_log_file='', master_log_pos='4'. 2019-11-04 17:08:51 140692342454016 [Note] Master connection name: '' Master_info_file: 'master.info' Relay_info_file: 'relay-log.info' 2019-11-04 17:08:51 140692342454016 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='mariaprod', master_port='8801', master_log_file='', master_log_pos='4'. New state master_host='mariaprod', master_port='8801', master_log_file='mysql-bin.000145', master_log_pos='793'. 2019-11-04 17:08:51 140692342454016 [Note] Semi-sync replication initialized for transactions. 2019-11-04 17:08:51 140692342454016 [Note] Semi-sync replication enabled on the master. 2019-11-04 17:08:51 140692363650816 [Note] Slave I/O thread: Start semi-sync replication to master 'replicator@mariaprod:8801' in log 'mysql-bin.000145' at position 793 2019-11-04 17:08:51 140692119070464 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000145' at position 793, relay log './mysqld-relay-bin.000001' position: 4 2019-11-04 17:08:51 140692363650816 [Note] Slave I/O thread: connected to master 'replicator@mariaprod:8801',replication started in log 'mysql-bin.000145' at position 793 2019-11-04 17:09:01 140692350134016 [Warning] Timeout waiting for reply of binlog (file: mysql-bin.000997, pos: 822852301), semi-sync up to file , position 0. 2019-11-04 17:09:01 140692350134016 [Note] Semi-sync replication switched OFF. 2019-11-04 17:10:16 140692342146816 [Warning] Aborted connection 6617695 to db: 'unconnected' user: 'dba_monitor' host: 'monitor' (Got an error reading communication packets) 2019-11-04 17:15:10 140692119070464 [ERROR] Slave SQL: Error executing row event: 'Got error 192 'Table encrypted but decryption failed. This could be because correct encryption management plugin is not loaded, used encryption key is not available or encryption method does not match.' from InnoDB', Gtid 0-1-1681780435, Internal MariaDB error code: 1296 2019-11-04 17:15:10 140692119070464 [Warning] Slave: Table mgdbdbgrowth in file ./dba/mgdbdbgrowth.ibd is encrypted but encryption service or used key_id is not available. Can't continue reading table. Error_code: 192 2019-11-04 17:15:10 140692119070464 [Warning] Slave: Got error 192 'Table encrypted but decryption failed. This could be because correct encryption management plugin is not loaded, used encryption key is not available or encryption method does not match.' from InnoDB Error_code: 1296 2019-11-04 17:15:10 140692119070464 [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-bin.000145' position 3969075 2019-11-04 17:15:10 140692119070464 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.000145' at position 3969075 2019-11-04 17:15:24 140692351977216 [Warning] Aborted connection 6620216 to db: 'unconnected' user: 'dba_monitor' host: 'monitor' (Got an error reading communication packets) 2019-11-04 17:16:43 140694480013056 [Note] Stop asynchronous binlog_dump to slave (server_id: 1) 2019-11-04 17:16:43 140694480013056 [Warning] Aborted connection 1941 to db: 'unconnected' user: 'replicator' host: 'mariaprod' (Got an error writing communication packets) 2019-11-04 17:20:17 140692350134016 [Warning] Aborted connection 6620247 to db: 'unconnected' user: 'dba_monitor' host: 'monitor' (Got an error reading communication packets) 2019-11-04 17:21:31 140694480013056 [Note] /usr/local/mysql/mariadb/sbin/mysqld (mysql[mysql] @ localhost []): Normal shutdown 2019-11-04 17:21:31 140692363650816 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000145', position 41277223 2019-11-04 17:21:31 140694480013056 [Note] Event Scheduler: Purging the queue. 0 events 2019-11-04 17:21:31 140691451655936 [Note] InnoDB: FTS optimize thread exiting. 2019-11-04 17:21:31 140694480013056 [Note] unregister_replicator OK 191104 17:21:31 server_audit: STOPPED 2019-11-04 17:21:31 140694480013056 [Note] InnoDB: Starting shutdown... 2019-11-04 17:21:31 140689975277312 [Note] InnoDB: Dumping buffer pool(s) to /usr/local/mysql/data/ib_buffer_pool 2019-11-04 17:21:31 140689975277312 [Note] InnoDB: Instance 0, restricted to 8192 pages due to innodb_buf_pool_dump_pct=25 2019-11-04 17:21:31 140689975277312 [Note] InnoDB: Buffer pool(s) dump completed at 191104 17:21:31 2019-11-04 17:21:33 140694480013056 [Note] InnoDB: Shutdown completed; log sequence number 2401634453794 2019-11-04 17:21:33 140694480013056 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-11-04 17:21:33 140694480013056 [Note] /usr/local/mysql/mariadb/sbin/mysqld: Shutdown complete 191104 17:21:34 mysqld_safe mysqld from pid file /usr/local/mysql/data/mysqld.pid ended 191104 17:21:49 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 2019-11-04 17:21:50 140354151323840 [Note] Using unique option prefix 'ignore-db-dir' is error-prone and can break in the future. Please use the full name 'ignore_db_dirs' instead. 2019-11-04 17:21:50 140354151323840 [Note] /usr/local/mysql/mariadb/sbin/mysqld (mysqld 10.2.8-MariaDB-log) starting as process 27929 ... 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Uses event mutexes 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Using Linux native AIO 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Number of pools: 1 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Using SSE2 crc32 instructions 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Completed initialization of buffer pool 2019-11-04 17:21:50 140351112431360 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Highest supported file format is Barracuda. 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Setting file '/usr/local/mysql/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: File '/usr/local/mysql/data/ibtmp1' size is now 12 MB. 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Waiting for purge to start 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: 5.7.19 started; log sequence number 2401634453794 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Creating 1 encryption thread id 140348458264320 total threads 8. 2019-11-04 17:21:50 140348592486144 [Note] InnoDB: Loading buffer pool(s) from /usr/local/mysql/data/ib_buffer_pool 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Creating 2 encryption thread id 140348324042496 total threads 8. 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Creating 3 encryption thread id 140348189820672 total threads 8. 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Creating 4 encryption thread id 140348055598848 total threads 8. 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Creating 5 encryption thread id 140347921377024 total threads 8. 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Creating 6 encryption thread id 140347787155200 total threads 8. 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Creating 7 encryption thread id 140347652933376 total threads 8. 2019-11-04 17:21:50 140354151323840 [Note] InnoDB: Creating 8 encryption thread id 140347518711552 total threads 8. 2019-11-04 17:21:50 140348592486144 [Note] InnoDB: Buffer pool(s) load completed at 191104 17:21:50 2019-11-04 17:21:50 140354151323840 [Note] Plugin 'FEEDBACK' is disabled. 191104 17:21:50 server_audit: MariaDB Audit Plugin version 1.4.1 STARTED. 2019-11-04 17:21:50 140354151323840 [Note] Using encryption key id 2 for temporary files 2019-11-04 17:21:51 140354151323840 [Warning] Failed to create a socket for IPv6 '::': errno: 97. 2019-11-04 17:21:51 140354151323840 [Note] Server socket created on IP: '0.0.0.0'. 2019-11-04 17:21:51 140354151323840 [Note] Reading of all Master_info entries succeded 2019-11-04 17:21:51 140354151323840 [Note] Added new Master_info '' to hash table 2019-11-04 17:21:51 140353102505728 [Note] Slave I/O thread: Start asynchronous replication to master 'replicator@mariaprod:8801' in log 'mysql-bin.000145' at position 41277223 2019-11-04 17:21:51 140354151323840 [Note] /usr/local/mysql/mariadb/sbin/mysqld: ready for connections. Version: '10.2.8-MariaDB-log' socket: '/tmp/mysql.sock' port: 8801 MariaDB Server 2019-11-04 17:21:51 140353102198528 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000145' at position 3969075, relay log './mysqld-relay-bin.000002' position: 2156664 2019-11-04 17:21:51 140353102505728 [Note] Slave I/O thread: connected to master 'replicator@mariaprod:8801',replication started in log 'mysql-bin.000145' at position 41277223