/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #241022 12:00:42 server id 1 end_log_pos 256 CRC32 0xa048d1ff Start: binlog v 4, server v 10.6.20-MariaDB-debug-log created 241022 12:00:42 at startup # Warning: this binlog is either in use or was not closed properly. ROLLBACK/*!*/; BINLOG ' OvkWZw8BAAAA/AAAAAABAAABAAQAMTAuNi4yMC1NYXJpYURCLWRlYnVnLWxvZwAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAA6+RZnEzgNAAgAEgAEBAQEEgAA5AAEGggAAAAICAgCAAAACgoKAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAEEwQADQgICAoKCgH/0Uig '/*!*/; # at 256 #241022 12:00:42 server id 1 end_log_pos 285 CRC32 0xc88d306f Gtid list [] # at 285 #241022 12:00:42 server id 1 end_log_pos 325 CRC32 0x16f3449f Binlog checkpoint binlog.000001 # at 325 #241022 12:00:43 server id 1 end_log_pos 367 CRC32 0xec0a6e58 GTID 0-1-1 /*M!100101 SET @@session.skip_parallel_replication=0*//*!*/; /*M!100001 SET @@session.gtid_domain_id=0*//*!*/; /*M!100001 SET @@session.server_id=1*//*!*/; /*M!100001 SET @@session.gtid_seq_no=1*//*!*/; START TRANSACTION /*!*/; # at 367 #241022 12:00:43 server id 1 end_log_pos 466 CRC32 0x847848ba Query thread_id=5 exec_time=0 error_code=0 xid=0 SET TIMESTAMP=1729558843/*!*/; SET @@session.pseudo_thread_id=5/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.sql_if_exists=0, @@session.explicit_defaults_for_timestamp=0/*!*/; SET @@session.sql_mode=0/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C utf8mb3 *//*!*/; SET @@session.character_set_client=utf8mb3,@@session.collation_connection=33,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; DELETE FROM mysql.user WHERE user='' /*!*/; # at 466 #241022 12:00:43 server id 1 end_log_pos 535 CRC32 0xa0a1e042 Query thread_id=5 exec_time=0 error_code=0 xid=0 SET TIMESTAMP=1729558843/*!*/; COMMIT /*!*/; # at 535 #241022 12:00:43 server id 1 end_log_pos 577 CRC32 0x8976c23c GTID 0-1-2 ddl /*M!100001 SET @@session.gtid_seq_no=2*//*!*/; # at 577 #241022 12:00:43 server id 1 end_log_pos 731 CRC32 0x9711d2da Query thread_id=6 exec_time=0 error_code=0 xid=0 SET TIMESTAMP=1729558843/*!*/; GRANT REPLICATION SLAVE ON *.* TO 'repl_user'@'%' IDENTIFIED BY 'repl_pass' /*!*/; # at 731 #241022 12:00:43 server id 1 end_log_pos 773 CRC32 0x509ccfdd GTID 0-1-3 /*M!100001 SET @@session.gtid_seq_no=3*//*!*/; # at 773 #241022 12:00:43 server id 1 end_log_pos 852 CRC32 0x13115450 Query thread_id=6 exec_time=0 error_code=0 xid=0 SET TIMESTAMP=1729558843/*!*/; FLUSH PRIVILEGES /*!*/; # at 852 #241022 12:00:44 server id 1 end_log_pos 894 CRC32 0x89b55789 GTID 0-1-4 ddl /*M!100001 SET @@session.gtid_seq_no=4*//*!*/; # at 894 #241022 12:00:44 server id 1 end_log_pos 995 CRC32 0xa0b56c4a Query thread_id=10 exec_time=0 error_code=0 xid=0 SET TIMESTAMP=1729558844/*!*/; create database if not exists test /*!*/; # at 995 #241022 12:00:44 server id 1 end_log_pos 1037 CRC32 0x09b6a4be GTID 0-1-5 ddl /*M!100001 SET @@session.gtid_seq_no=5*//*!*/; # at 1037 #241022 12:00:44 server id 1 end_log_pos 1173 CRC32 0x7ac688e6 Query thread_id=11 exec_time=0 error_code=0 xid=23 use `test`/*!*/; SET TIMESTAMP=1729558844/*!*/; CREATE TABLE t1 (a1 VARCHAR(1), a2 VARCHAR(1)) ENGINE=InnoDB /*!*/; # at 1173 #241022 12:00:44 server id 1 end_log_pos 1215 CRC32 0xd9e257ff GTID 0-1-6 ddl /*M!100001 SET @@session.gtid_seq_no=6*//*!*/; START TRANSACTION /*!*/; # at 1215 #241022 12:00:44 server id 1 end_log_pos 1339 CRC32 0x7dd04058 Query thread_id=11 exec_time=0 error_code=0 xid=25 SET TIMESTAMP=1729558844/*!*/; SET @@session.pseudo_thread_id=11/*!*/; CREATE TEMPORARY TABLE t1 (c1 INT) ENGINE=InnoDB /*!*/; # at 1339 #241022 12:00:44 server id 1 end_log_pos 1433 CRC32 0x312f5de0 Query thread_id=11 exec_time=0 error_code=0 xid=0 SET TIMESTAMP=1729558844/*!*/; INSERT INTO t1 VALUES ('a') /*!*/; # at 1433 #241022 12:00:44 server id 1 end_log_pos 1475 CRC32 0xe32c0ae7 User_var SET @`inserted_value`:=NULL/*!*/; # at 1475 #241022 12:00:44 server id 1 end_log_pos 1588 CRC32 0xd2c61d9a Query thread_id=11 exec_time=0 error_code=0 xid=0 SET TIMESTAMP=1729558844/*!*/; INSERT IGNORE INTO t1 VALUES (@inserted_value) /*!*/; # at 1588 #241022 12:00:44 server id 1 end_log_pos 1663 CRC32 0xafd8656c Query thread_id=11 exec_time=0 error_code=0 xid=0 SET TIMESTAMP=1729558844/*!*/; ROLLBACK /*!*/; # at 1663 #241022 12:00:44 server id 1 end_log_pos 1705 CRC32 0x673d0cbc GTID 102-1-1 ddl /*M!100001 SET @@session.gtid_domain_id=102*//*!*/; /*M!100001 SET @@session.gtid_seq_no=1*//*!*/; # at 1705 #241022 12:00:44 server id 1 end_log_pos 1819 CRC32 0xeceb4e45 Query thread_id=11 exec_time=0 error_code=0 xid=0 SET TIMESTAMP=1729558844/*!*/; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `t1` /*!*/; DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;