-- 5.7

rm -rf master_98799
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/master_98799 --log-error-verbosity=3
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/master_98799 --core-file --socket=/tmp/mysql_master.sock --port=3333 --log-error=$PWD/master_98799/log.err --log-bin=master-bin --server_id=1 2>&1 &

rm -rf slave_98799
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/slave_98799 --log-error-verbosity=3
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/slave_98799 --core-file --socket=/tmp/mysql_slave.sock --port=6666 --log-error=$PWD/slave_98799/log.err --log-bin=slave_98799-bin --server_id=2 --skip_slave_start --slave-type-conversions=ALL_NON_LOSSY 2>&1 &

- master

 bin/mysql -uroot -S /tmp/mysql_master.sock --prompt='Master>'
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.29-log MySQL Community Server (GPL)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Master>CREATE USER 'repl'@'localhost' IDENTIFIED BY 'slavepass';
Query OK, 0 rows affected (0.00 sec)

Master>GRANT REPLICATION SLAVE ON *.* TO 'repl'@'localhost';
Query OK, 0 rows affected (0.00 sec)

Master>
Master>CREATE USER 'repl'@'127.0.0.1' IDENTIFIED BY 'slavepass';
Query OK, 0 rows affected (0.00 sec)

Master>GRANT REPLICATION SLAVE ON *.* TO 'repl'@'127.0.0.1';
Query OK, 0 rows affected (0.00 sec)

Master>FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

Master>show master logs;
+-------------------+-----------+
| Log_name          | File_size |
+-------------------+-----------+
| master-bin.000001 |      1220 |
+-------------------+-----------+
1 row in set (0.00 sec)

Master>

- slave

bin/mysql -uroot -S /tmp/mysql_slave.sock --prompt='Slave>'
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.29-log MySQL Community Server (GPL)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Slave>CHANGE MASTER TO
    ->      MASTER_HOST='localhost',
    ->      MASTER_PORT=3333,
    ->      MASTER_USER='repl',
    ->      MASTER_PASSWORD='slavepass',
    ->      MASTER_LOG_FILE='master-bin.000001',
    ->      MASTER_LOG_POS=1220;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

Slave>start slave;
Query OK, 0 rows affected (0.00 sec)

Slave>show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: localhost
                  Master_User: repl
                  Master_Port: 3333
                Connect_Retry: 60
              Master_Log_File: master-bin.000001
          Read_Master_Log_Pos: 1220
               Relay_Log_File: hod03-relay-bin.000002
                Relay_Log_Pos: 321
        Relay_Master_Log_File: master-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 1220
              Relay_Log_Space: 528
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
                  Master_UUID: aa875224-5de2-11ea-b7eb-0010e05f3e06
             Master_Info_File: /export/umesh/server/binaries/GABuilds/mysql-5.7.29/slave_98799/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Master_SSL_Crl:
           Master_SSL_Crlpath:
           Retrieved_Gtid_Set:
            Executed_Gtid_Set:
                Auto_Position: 0
         Replicate_Rewrite_DB:
                 Channel_Name:
           Master_TLS_Version:
1 row in set (0.00 sec)

Slave>


- master

CREATE TABLE `table1` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

INSERT INTO table1 VALUE();


BEGIN;
INSERT INTO table1 VALUE();
INSERT INTO table1 VALUE();
INSERT INTO table1 VALUE();
COMMIT;

select * from table1;

Master>CREATE TABLE `table1` (
    ->   `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
    ->   PRIMARY KEY (`id`)
    -> ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0.01 sec)

Master>
Master>INSERT INTO table1 VALUE();
Query OK, 1 row affected (0.00 sec)

Master>
Master>
Master>BEGIN;
Query OK, 0 rows affected (0.00 sec)

Master>INSERT INTO table1 VALUE();
Query OK, 1 row affected (0.00 sec)

Master>INSERT INTO table1 VALUE();
Query OK, 1 row affected (0.00 sec)

Master>INSERT INTO table1 VALUE();
Query OK, 1 row affected (0.00 sec)

Master>COMMIT;
Query OK, 0 rows affected (0.00 sec)

Master>
Master>select * from table1;
+----+
| id |
+----+
| 13 |
| 14 |
| 15 |
| 16 |
+----+
4 rows in set (0.00 sec)

- slave

Slave>show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: localhost
                  Master_User: repl
                  Master_Port: 3333
                Connect_Retry: 60
              Master_Log_File: master-bin.000001
          Read_Master_Log_Pos: 3607
               Relay_Log_File: hod03-relay-bin.000002
                Relay_Log_Pos: 2708
        Relay_Master_Log_File: master-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 3607
              Relay_Log_Space: 2915
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
                  Master_UUID: aa875224-5de2-11ea-b7eb-0010e05f3e06
             Master_Info_File: /export/umesh/server/binaries/GABuilds/mysql-5.7.29/slave_98799/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Master_SSL_Crl:
           Master_SSL_Crlpath:
           Retrieved_Gtid_Set:
            Executed_Gtid_Set:
                Auto_Position: 0
         Replicate_Rewrite_DB:
                 Channel_Name:
           Master_TLS_Version:
1 row in set (0.00 sec)


Slave>select * from table1;
+----+
| id |
+----+
| 13 |
| 14 |
| 15 |
| 16 |
+----+
4 rows in set (0.00 sec)

Slave>show create table table1\G
*************************** 1. row ***************************
       Table: table1
Create Table: CREATE TABLE `table1` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

Slave>ALTER TABLE table1 MODIFY COLUMN id INT unsigned AUTO_INCREMENT;
Query OK, 4 rows affected (0.01 sec)
Records: 4  Duplicates: 0  Warnings: 0

Slave>show create table table1\G
*************************** 1. row ***************************
       Table: table1
Create Table: CREATE TABLE `table1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

Slave>
Slave>show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: localhost
                  Master_User: repl
                  Master_Port: 3333
                Connect_Retry: 60
              Master_Log_File: master-bin.000001
          Read_Master_Log_Pos: 3607
               Relay_Log_File: hod03-relay-bin.000002
                Relay_Log_Pos: 2708
        Relay_Master_Log_File: master-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 3607
              Relay_Log_Space: 2915
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
                  Master_UUID: aa875224-5de2-11ea-b7eb-0010e05f3e06
             Master_Info_File: /export/umesh/server/binaries/GABuilds/mysql-5.7.29/slave_98799/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Master_SSL_Crl:
           Master_SSL_Crlpath:
           Retrieved_Gtid_Set:
            Executed_Gtid_Set:
                Auto_Position: 0
         Replicate_Rewrite_DB:
                 Channel_Name:
           Master_TLS_Version:
1 row in set (0.00 sec)

Slave>


- master

Master>INSERT INTO table1 VALUE();
Query OK, 1 row affected (0.00 sec)

Master>
Master>
Master>BEGIN;
Query OK, 0 rows affected (0.00 sec)

Master>INSERT INTO table1 VALUE();
Query OK, 1 row affected (0.00 sec)

Master>INSERT INTO table1 VALUE();
Query OK, 1 row affected (0.00 sec)

Master>INSERT INTO table1 VALUE();
Query OK, 1 row affected (0.00 sec)

Master>COMMIT;
Query OK, 0 rows affected (0.00 sec)

Master>select * from table1;
+----+
| id |
+----+
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
+----+
8 rows in set (0.00 sec)



- slave

Slave>select * from table1;
+----+
| id |
+----+
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
+----+
8 rows in set (0.00 sec)

Slave>show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: localhost
                  Master_User: repl
                  Master_Port: 3333
                Connect_Retry: 60
              Master_Log_File: master-bin.000001
          Read_Master_Log_Pos: 4295
               Relay_Log_File: hod03-relay-bin.000002
                Relay_Log_Pos: 3396
        Relay_Master_Log_File: master-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 4295
              Relay_Log_Space: 3603
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
                  Master_UUID: aa875224-5de2-11ea-b7eb-0010e05f3e06
             Master_Info_File: /export/umesh/server/binaries/GABuilds/mysql-5.7.29/slave_98799/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Master_SSL_Crl:
           Master_SSL_Crlpath:
           Retrieved_Gtid_Set:
            Executed_Gtid_Set:
                Auto_Position: 0
         Replicate_Rewrite_DB:
                 Channel_Name:
           Master_TLS_Version:
1 row in set (0.00 sec)

- master

Master>ALTER TABLE table1 AUTO_INCREMENT=12093336;
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

Master>SHOW CREATE TABLE `table1`\G
*************************** 1. row ***************************
       Table: table1
Create Table: CREATE TABLE `table1` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12093336 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)


- slave


Slave>SHOW CREATE TABLE `table1`\G
*************************** 1. row ***************************
       Table: table1
Create Table: CREATE TABLE `table1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12093336 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

Slave>show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: localhost
                  Master_User: repl
                  Master_Port: 3333
                Connect_Retry: 60
              Master_Log_File: master-bin.000001
          Read_Master_Log_Pos: 4476
               Relay_Log_File: hod03-relay-bin.000002
                Relay_Log_Pos: 3577
        Relay_Master_Log_File: master-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 4476
              Relay_Log_Space: 3784
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
                  Master_UUID: aa875224-5de2-11ea-b7eb-0010e05f3e06
             Master_Info_File: /export/umesh/server/binaries/GABuilds/mysql-5.7.29/slave_98799/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Master_SSL_Crl:
           Master_SSL_Crlpath:
           Retrieved_Gtid_Set:
            Executed_Gtid_Set:
                Auto_Position: 0
         Replicate_Rewrite_DB:
                 Channel_Name:
           Master_TLS_Version:
1 row in set (0.00 sec)


- master

Master>ALTER TABLE table1 AUTO_INCREMENT=12093336;
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

Master>SHOW CREATE TABLE `table1`\G
*************************** 1. row ***************************
       Table: table1
Create Table: CREATE TABLE `table1` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12093336 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

Master>INSERT INTO table1 VALUE();
Query OK, 1 row affected (0.00 sec)

Master>
Master>
Master>BEGIN;
Query OK, 0 rows affected (0.00 sec)

Master>INSERT INTO table1 VALUE();
Query OK, 1 row affected (0.00 sec)

Master>INSERT INTO table1 VALUE();
Query OK, 1 row affected (0.00 sec)

Master>INSERT INTO table1 VALUE();
Query OK, 1 row affected (0.00 sec)

Master>COMMIT;
Query OK, 0 rows affected (0.00 sec)

Master>select * from table1;
+----------+
| id       |
+----------+
|       13 |
|       14 |
|       15 |
|       16 |
|       17 |
|       18 |
|       19 |
|       20 |
| 12093336 |
| 12093337 |
| 12093338 |
| 12093339 |
+----------+
12 rows in set (0.00 sec)


- slave

Slave>select * from table1;
+----+
| id |
+----+
|  0 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
+----+
9 rows in set (0.01 sec)

Slave>show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: localhost
                  Master_User: repl
                  Master_Port: 3333
                Connect_Retry: 60
              Master_Log_File: master-bin.000001
          Read_Master_Log_Pos: 5164
               Relay_Log_File: hod03-relay-bin.000002
                Relay_Log_Pos: 3833
        Relay_Master_Log_File: master-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: No
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 1062
                   Last_Error: Could not execute Write_rows event on table test.table1; Duplicate entry '0' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log master-bin.000001, end_log_pos 4957
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 4732
              Relay_Log_Space: 4472
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 1062
               Last_SQL_Error: Could not execute Write_rows event on table test.table1; Duplicate entry '0' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log master-bin.000001, end_log_pos 4957
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
                  Master_UUID: aa875224-5de2-11ea-b7eb-0010e05f3e06
             Master_Info_File: /export/umesh/server/binaries/GABuilds/mysql-5.7.29/slave_98799/master.info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State:
           Master_Retry_Count: 86400
                  Master_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp: 200304 07:48:15
               Master_SSL_Crl:
           Master_SSL_Crlpath:
           Retrieved_Gtid_Set:
            Executed_Gtid_Set:
                Auto_Position: 0
         Replicate_Rewrite_DB:
                 Channel_Name:
           Master_TLS_Version:
1 row in set (0.00 sec)

- extract from slave's error log

2020-03-04T06:48:15.484123Z 4 [ERROR] Slave SQL for channel '': Could not execute Write_rows event on table test.table1; Duplicate entry '0' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log master-bin.000001, end_log_pos 4957, Error_code: 1062
2020-03-04T06:48:15.484145Z 4 [Warning] Slave: Duplicate entry '0' for key 'PRIMARY' Error_code: 1062
2020-03-04T06:48:15.484153Z 4 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master-bin.000001' position 4732.

-- extract from master's binlog

# at 4295
#200304  7:46:51 server id 1  end_log_pos 4360 CRC32 0x6282b6e8         Anonymous_GTID  last_committed=16       sequence_number=17      rbr_only=no
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/;
# at 4360
#200304  7:46:51 server id 1  end_log_pos 4476 CRC32 0x4b7e9aab         Query   thread_id=2     exec_time=0     error_code=0
SET TIMESTAMP=1583304411/*!*/;
ALTER TABLE table1 AUTO_INCREMENT=12093336
/*!*/;
# at 4476
#200304  7:48:15 server id 1  end_log_pos 4541 CRC32 0x88fd3e97         Anonymous_GTID  last_committed=17       sequence_number=18      rbr_only=yes
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/;
# at 4541
#200304  7:48:15 server id 1  end_log_pos 4613 CRC32 0xc5e0918c         Query   thread_id=2     exec_time=0     error_code=0
SET TIMESTAMP=1583304495/*!*/;
BEGIN
/*!*/;
# at 4613
#200304  7:48:15 server id 1  end_log_pos 4662 CRC32 0x63f07832         Table_map: `test`.`table1` mapped to number 110
# at 4662
#200304  7:48:15 server id 1  end_log_pos 4701 CRC32 0x94874da0         Write_rows: table id 110 flags: STMT_END_F
### INSERT INTO `test`.`table1`
### SET
###   @1=-4683880 (12093336) /* MEDIUMINT meta=0 nullable=0 is_null=0 */
# at 4701
#200304  7:48:15 server id 1  end_log_pos 4732 CRC32 0x5632e5a4         Xid = 49
COMMIT/*!*/;
# at 4732
#200304  7:48:15 server id 1  end_log_pos 4797 CRC32 0xd6149754         Anonymous_GTID  last_committed=18       sequence_number=19      rbr_only=yes
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/;
# at 4797
#200304  7:48:15 server id 1  end_log_pos 4869 CRC32 0xc445383a         Query   thread_id=2     exec_time=0     error_code=0
SET TIMESTAMP=1583304495/*!*/;
BEGIN
/*!*/;
# at 4869
#200304  7:48:15 server id 1  end_log_pos 4918 CRC32 0x6d1790e3         Table_map: `test`.`table1` mapped to number 110
# at 4918
#200304  7:48:15 server id 1  end_log_pos 4957 CRC32 0x0a9fa409         Write_rows: table id 110 flags: STMT_END_F
### INSERT INTO `test`.`table1`
### SET
###   @1=-4683879 (12093337) /* MEDIUMINT meta=0 nullable=0 is_null=0 */
# at 4957
#200304  7:48:15 server id 1  end_log_pos 5006 CRC32 0x432360c4         Table_map: `test`.`table1` mapped to number 110
# at 5006
#200304  7:48:15 server id 1  end_log_pos 5045 CRC32 0xbca6cc9b         Write_rows: table id 110 flags: STMT_END_F
### INSERT INTO `test`.`table1`
### SET
###   @1=-4683878 (12093338) /* MEDIUMINT meta=0 nullable=0 is_null=0 */
# at 5045
#200304  7:48:15 server id 1  end_log_pos 5094 CRC32 0xefe032e6         Table_map: `test`.`table1` mapped to number 110
# at 5094
#200304  7:48:15 server id 1  end_log_pos 5133 CRC32 0x03459fb9         Write_rows: table id 110 flags: STMT_END_F
### INSERT INTO `test`.`table1`
### SET
###   @1=-4683877 (12093339) /* MEDIUMINT meta=0 nullable=0 is_null=0 */
# at 5133
#200304  7:48:15 server id 1  end_log_pos 5164 CRC32 0x93f9f699         Xid = 51
COMMIT/*!*/;
# at 5164
#200304  8:09:37 server id 1  end_log_pos 5187 CRC32 0x964856da         Stop
SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/;
DELIMITER ;
# End of log file
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;