2021-08-18 10:54:04 0 [Note] InnoDB: Uses event mutexes 2021-08-18 10:54:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2021-08-18 10:54:04 0 [Note] InnoDB: Number of pools: 1 2021-08-18 10:54:04 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2021-08-18 10:54:04 0 [Note] InnoDB: Using Linux native AIO 2021-08-18 10:54:04 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2021-08-18 10:54:04 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-18 10:54:04 0 [Note] InnoDB: 128 rollback segments are active. 2021-08-18 10:54:04 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-18 10:54:04 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-18 10:54:04 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-08-18 10:54:04 0 [Note] InnoDB: 10.5.12 started; log sequence number 45094; transaction id 20 2021-08-18 10:54:04 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-18 10:54:04 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-08-18 10:54:04 0 [Note] InnoDB: Buffer pool(s) load completed at 210818 10:54:04 2021-08-18 10:54:04 0 [Note] Server socket created on IP: '::'. 2021-08-18 10:54:04 0 [Note] Reading of all Master_info entries succeeded 2021-08-18 10:54:04 0 [Note] Added new Master_info '' to hash table 2021-08-18 10:54:04 0 [Note] /usr/sbin/mariadbd: ready for connections. Version: '10.5.12-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server 2021-08-18 10:57:21 11 [Note] Master connection name: '' Master_info_file: 'master.info' Relay_info_file: 'relay-log.info' 2021-08-18 10:57:21 11 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MariaDB server acts as a replica and has its hostname changed. Please use '--log-basename=#' or '--relay-log=ip-172-31-64-255-relay-bin' to avoid this problem. 2021-08-18 10:57:21 11 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='172.31.71.127', master_port='3306', master_log_file='', master_log_pos='4'. 2021-08-18 10:57:21 11 [Note] Previous Using_Gtid=No. New Using_Gtid=Slave_Pos 2021-08-18 10:57:25 12 [Note] Slave I/O thread: Start asynchronous replication to master 'repl@172.31.71.127:3306' in log '' at position 4 2021-08-18 10:57:25 13 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 4, relay log './ip-172-31-64-255-relay-bin.000001' position: 4; GTID position '201-1-10' 2021-08-18 10:57:25 12 [ERROR] Slave I/O: error connecting to master 'repl@172.31.71.127:3306' - retry-time: 60 maximum-retries: 86400 message: Access denied for user 'repl'@'ip-172-31-64-255.ec2.internal' (using password: YES), Internal MariaDB error code: 1045 2021-08-18 10:58:08 13 [Note] Error reading relay log event: slave SQL thread was killed 2021-08-18 10:58:08 13 [Note] Slave SQL thread exiting, replication stopped in log 'FIRST' at position 4; GTID position '201-1-10' 2021-08-18 10:58:08 13 [Note] master was 172.31.71.127:3306 2021-08-18 10:58:08 12 [Note] Slave I/O thread killed while connecting to master 2021-08-18 10:58:08 12 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4; GTID position 201-1-10 2021-08-18 10:58:08 12 [Note] master was 172.31.71.127:3306 2021-08-18 10:58:15 11 [Note] Deleted Master_info file '/var/lib/mysql/master.info'. 2021-08-18 10:58:15 11 [Note] Deleted Master_info file '/var/lib/mysql/relay-log.info'. 2021-08-18 10:59:55 11 [Note] Master connection name: '' Master_info_file: 'master.info' Relay_info_file: 'relay-log.info' 2021-08-18 10:59:55 11 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='172.31.71.127', master_port='3306', master_log_file='', master_log_pos='4'. 2021-08-18 10:59:55 11 [Note] Previous Using_Gtid=No. New Using_Gtid=Slave_Pos 2021-08-18 11:00:02 14 [Note] Slave I/O thread: Start asynchronous replication to master 'repl@172.31.71.127:3306' in log '' at position 4 2021-08-18 11:00:02 15 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 4, relay log './ip-172-31-64-255-relay-bin.000001' position: 4; GTID position '201-1-12' 2021-08-18 11:00:02 14 [Note] Slave I/O thread: connected to master 'repl@172.31.71.127:3306',replication starts at GTID position '201-1-12' 2021-08-18 11:02:18 15 [Note] Error reading relay log event: slave SQL thread was killed 2021-08-18 11:02:18 15 [Note] Slave SQL thread exiting, replication stopped in log 'mysql-bin.000001' at position 3504; GTID position '201-1-13' 2021-08-18 11:02:18 15 [Note] master was 172.31.71.127:3306 2021-08-18 11:02:18 14 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000001', position 3504; GTID position 201-1-13 2021-08-18 11:02:18 14 [Note] master was 172.31.71.127:3306 2021-08-18 11:06:37 16 [Note] Slave I/O thread: Start asynchronous replication to master 'repl@172.31.71.127:3306' in log 'mysql-bin.000001' at position 3504 2021-08-18 11:06:37 17 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000001' at position 3504, relay log './ip-172-31-64-255-relay-bin.000001' position: 4; GTID position '201-1-13' 2021-08-18 11:06:37 16 [Note] Slave I/O thread: connected to master 'repl@172.31.71.127:3306',replication starts at GTID position '201-1-13'