Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-30985

Replica stops with error on ALTER ONLINE with Geometry Types

Details

    Description

      The following is non-deterministic - usually I can get a failure with --repeat=100.

      --source include/master-slave.inc
      		 
      --source include/have_innodb.inc
      		 
      --source include/have_binlog_format_row.inc
      		 
       
      		 
      --connection slave
      		 
      call mtr.add_suppression("Can't find record in 'DD'");
      		 
       
      		 
      --connection master
      		 
      USE test;
      		 
       
      		 
      CREATE TABLE `DD` (geocol7 GEOMETRYCOLLECTION NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), scol4 BINARY NOT NULL DEFAULT '', vcol9 POINT AS ( geocol7 ) );
      		 
      INSERT INTO `DD` () VALUES (),(),();
      		 
       
      		 
      # not sure if this is necessary, but failure seems to occur with or without
      		 
      UNLOCK TABLES;
      		 
       
      		 
      # FLUSH TABLES seems necessary for replication to error
      		 
      FLUSH TABLES;
      		 
       
      		 
      ALTER ONLINE TABLE `DD` ADD COLUMN ( geocol3 GEOMETRY NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), ncol4 DECIMAL UNSIGNED NOT NULL ), ALGORITHM=COPY, LOCK=NONE;
      		 
      DELETE FROM `DD` LIMIT 7;
      		 
       
      		 
      DROP TABLE DD;
      		 
      --source include/rpl_end.inc


      CURRENT_TEST: rpl.1048_small
      		 
      mysqltest: In included file "./include/check_slave_param.inc":
      		 
      included from ./include/check_slave_no_error.inc at line 24:
      		 
      included from ./include/rpl_end.inc at line 74:
      		 
      included from /home/angelique/dev/build-11.1-MDEV-16329-e599b8b4586/build1/mysql-test/suite/rpl/t/1048_small.test at line 25:
      		 
      At line 31: Wrong value for slave parameter Last_SQL_Errno


      **** SHOW SLAVE STATUS on server_2 ****
      		 
      SHOW SLAVE STATUS;
      		 
      Slave_IO_State	Waiting for master to send event
      		 
      Master_Host	127.0.0.1
      		 
      Master_User	root
      		 
      Master_Port	16000
      		 
      Connect_Retry	1
      		 
      Master_Log_File	master-bin.000001
      		 
      Read_Master_Log_Pos	2125
      		 
      Relay_Log_File	slave-relay-bin.000002
      		 
      Relay_Log_Pos	1733
      		 
      Relay_Master_Log_File	master-bin.000001
      		 
      Slave_IO_Running	Yes
      		 
      Slave_SQL_Running	No
      		 
      Replicate_Rewrite_DB
      		 
      Replicate_Do_DB
      		 
      Replicate_Ignore_DB
      		 
      Replicate_Do_Table
      		 
      Replicate_Ignore_Table
      		 
      Replicate_Wild_Do_Table
      		 
      Replicate_Wild_Ignore_Table
      		 
      Last_Errno	1032
      		 
      Last_Error	Could not execute Delete_rows_v1 event on table test.DD; Can't find record in 'DD', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log master-bin.000001, end_log_pos 1893
      		 
      Skip_Counter	0
      		 
      Exec_Master_Log_Pos	1433
      		 
      Relay_Log_Space	2734
      		 
      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	1032
      		 
      Last_SQL_Error	Could not execute Delete_rows_v1 event on table test.DD; Can't find record in 'DD', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log master-bin.000001, end_log_pos 1893
      		 
      Replicate_Ignore_Server_Ids
      		 
      Master_Server_Id	1
      		 
      Master_SSL_Crl
      		 
      Master_SSL_Crlpath
      		 
      Using_Gtid	Slave_Pos
      		 
      Gtid_IO_Pos	0-1-6
      		 
      Replicate_Do_Domain_Ids
      		 
      Replicate_Ignore_Domain_Ids
      		 
      Parallel_Mode	optimistic
      		 
      SQL_Delay	0
      		 
      SQL_Remaining_Delay	NULL
      		 
      Slave_SQL_Running_State
      		 
      Slave_DDL_Groups	11
      		 
      Slave_Non_Transactional_Groups	6
      		 
      Slave_Transactional_Groups	0

      Replication failure also occurs with InnoDB, but doesn't seem to occur if the table is defined with the Aria engine.

      A much longer test that always seems to fail is attached (1048.test).

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-16329 Engine-independent online ALTER TABLE

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-16329 Engine-independent online ALTER TABLE

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            angelique.sklavounos Angelique Sklavounos (Inactive) created issue -
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Field Original Value New Value
            Fix Version/s 11.1 [ 28549 ]
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Attachment 1048.test [ 69344 ]
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Attachment 1048.test [ 69344 ]
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Attachment 1048.test [ 69345 ]
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Description The following is non-deterministic - usually I can get a failure with {{--repeat=100}}.

            {code:sql}
            --source include/master-slave.inc
            --source include/have_innodb.inc
            --source include/have_binlog_format_row.inc

            --connection slave
            call mtr.add_suppression("Can't find record in 'DD'");

            --connection master
            USE test;

            CREATE TABLE `DD` (geocol7 GEOMETRYCOLLECTION NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), scol4 BINARY NOT NULL DEFAULT '', vcol9 POINT AS ( geocol7 ) );
            INSERT INTO `DD` () VALUES (),(),();

            # not sure if this is necessary, but failure seems to occur with or without
            UNLOCK TABLES;

            # FLUSH TABLES seems necessary for replication to error
            FLUSH TABLES;

            ALTER ONLINE TABLE `DD` ADD COLUMN ( geocol3 GEOMETRY NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), ncol4 DECIMAL UNSIGNED NOT NULL ), ALGORITHM=COPY, LOCK=NONE;
            DELETE FROM `DD` LIMIT 7;

            DROP TABLE DD;
            --source include/rpl_end.inc
            {code}

            Replication failure also occurs with InnoDB, but doesn't seem to occur if table {{B}} is defined with the Aria engine.             		The following is non-deterministic - usually I can get a failure with {{--repeat=100}}.

            {code:sql}
            --source include/master-slave.inc
            --source include/have_innodb.inc
            --source include/have_binlog_format_row.inc

            --connection slave
            call mtr.add_suppression("Can't find record in 'DD'");

            --connection master
            USE test;

            CREATE TABLE `DD` (geocol7 GEOMETRYCOLLECTION NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), scol4 BINARY NOT NULL DEFAULT '', vcol9 POINT AS ( geocol7 ) );
            INSERT INTO `DD` () VALUES (),(),();

            # not sure if this is necessary, but failure seems to occur with or without
            UNLOCK TABLES;

            # FLUSH TABLES seems necessary for replication to error
            FLUSH TABLES;

            ALTER ONLINE TABLE `DD` ADD COLUMN ( geocol3 GEOMETRY NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), ncol4 DECIMAL UNSIGNED NOT NULL ), ALGORITHM=COPY, LOCK=NONE;
            DELETE FROM `DD` LIMIT 7;

            DROP TABLE DD;
            --source include/rpl_end.inc
            {code}

            Replication failure also occurs with InnoDB, but doesn't seem to occur if table {{B}} is defined with the Aria engine.

            A much longer test that always seems to fail is attached (1048.test).
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Description The following is non-deterministic - usually I can get a failure with {{--repeat=100}}.

            {code:sql}
            --source include/master-slave.inc
            --source include/have_innodb.inc
            --source include/have_binlog_format_row.inc

            --connection slave
            call mtr.add_suppression("Can't find record in 'DD'");

            --connection master
            USE test;

            CREATE TABLE `DD` (geocol7 GEOMETRYCOLLECTION NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), scol4 BINARY NOT NULL DEFAULT '', vcol9 POINT AS ( geocol7 ) );
            INSERT INTO `DD` () VALUES (),(),();

            # not sure if this is necessary, but failure seems to occur with or without
            UNLOCK TABLES;

            # FLUSH TABLES seems necessary for replication to error
            FLUSH TABLES;

            ALTER ONLINE TABLE `DD` ADD COLUMN ( geocol3 GEOMETRY NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), ncol4 DECIMAL UNSIGNED NOT NULL ), ALGORITHM=COPY, LOCK=NONE;
            DELETE FROM `DD` LIMIT 7;

            DROP TABLE DD;
            --source include/rpl_end.inc
            {code}

            Replication failure also occurs with InnoDB, but doesn't seem to occur if table {{B}} is defined with the Aria engine.

            A much longer test that always seems to fail is attached (1048.test).             		The following is non-deterministic - usually I can get a failure with {{--repeat=100}}.

            {code:sql}
            --source include/master-slave.inc
            --source include/have_innodb.inc
            --source include/have_binlog_format_row.inc

            --connection slave
            call mtr.add_suppression("Can't find record in 'DD'");

            --connection master
            USE test;

            CREATE TABLE `DD` (geocol7 GEOMETRYCOLLECTION NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), scol4 BINARY NOT NULL DEFAULT '', vcol9 POINT AS ( geocol7 ) );
            INSERT INTO `DD` () VALUES (),(),();

            # not sure if this is necessary, but failure seems to occur with or without
            UNLOCK TABLES;

            # FLUSH TABLES seems necessary for replication to error
            FLUSH TABLES;

            ALTER ONLINE TABLE `DD` ADD COLUMN ( geocol3 GEOMETRY NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), ncol4 DECIMAL UNSIGNED NOT NULL ), ALGORITHM=COPY, LOCK=NONE;
            DELETE FROM `DD` LIMIT 7;

            DROP TABLE DD;
            --source include/rpl_end.inc
            {code}

            Replication failure also occurs with InnoDB, but doesn't seem to occur if table {{B}} is defined with the Aria engine.

            A much longer test that always seems to fail is attached ({{1048.test}}).
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Summary Replica SQL thread stops with 1032 error on ALTER ONLINE Replica SQL thread stops with 1032 error on ALTER ONLINE with Geometry Types
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Description The following is non-deterministic - usually I can get a failure with {{--repeat=100}}.

            {code:sql}
            --source include/master-slave.inc
            --source include/have_innodb.inc
            --source include/have_binlog_format_row.inc

            --connection slave
            call mtr.add_suppression("Can't find record in 'DD'");

            --connection master
            USE test;

            CREATE TABLE `DD` (geocol7 GEOMETRYCOLLECTION NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), scol4 BINARY NOT NULL DEFAULT '', vcol9 POINT AS ( geocol7 ) );
            INSERT INTO `DD` () VALUES (),(),();

            # not sure if this is necessary, but failure seems to occur with or without
            UNLOCK TABLES;

            # FLUSH TABLES seems necessary for replication to error
            FLUSH TABLES;

            ALTER ONLINE TABLE `DD` ADD COLUMN ( geocol3 GEOMETRY NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), ncol4 DECIMAL UNSIGNED NOT NULL ), ALGORITHM=COPY, LOCK=NONE;
            DELETE FROM `DD` LIMIT 7;

            DROP TABLE DD;
            --source include/rpl_end.inc
            {code}

            Replication failure also occurs with InnoDB, but doesn't seem to occur if table {{B}} is defined with the Aria engine.

            A much longer test that always seems to fail is attached ({{1048.test}}).             		The following is non-deterministic - usually I can get a failure with {{--repeat=100}}.

            {code:sql}
            --source include/master-slave.inc
            --source include/have_innodb.inc
            --source include/have_binlog_format_row.inc

            --connection slave
            call mtr.add_suppression("Can't find record in 'DD'");

            --connection master
            USE test;

            CREATE TABLE `DD` (geocol7 GEOMETRYCOLLECTION NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), scol4 BINARY NOT NULL DEFAULT '', vcol9 POINT AS ( geocol7 ) );
            INSERT INTO `DD` () VALUES (),(),();

            # not sure if this is necessary, but failure seems to occur with or without
            UNLOCK TABLES;

            # FLUSH TABLES seems necessary for replication to error
            FLUSH TABLES;

            ALTER ONLINE TABLE `DD` ADD COLUMN ( geocol3 GEOMETRY NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), ncol4 DECIMAL UNSIGNED NOT NULL ), ALGORITHM=COPY, LOCK=NONE;
            DELETE FROM `DD` LIMIT 7;

            DROP TABLE DD;
            --source include/rpl_end.inc
            {code}

            {noformat}
            CURRENT_TEST: rpl.1048_small
            mysqltest: In included file "./include/check_slave_param.inc":
            included from ./include/check_slave_no_error.inc at line 24:
            included from ./include/rpl_end.inc at line 74:
            included from /home/angelique/dev/build-11.1-MDEV-16329-e599b8b4586/build1/mysql-test/suite/rpl/t/1048_small.test at line 25:
            At line 31: Wrong value for slave parameter Last_SQL_Errno
            {noformat}

            {noformat}
            **** SHOW SLAVE STATUS on server_2 ****
            SHOW SLAVE STATUS;
            Slave_IO_State Waiting for master to send event
            Master_Host 127.0.0.1
            Master_User root
            Master_Port 16000
            Connect_Retry 1
            Master_Log_File master-bin.000001
            Read_Master_Log_Pos 2125
            Relay_Log_File slave-relay-bin.000002
            Relay_Log_Pos 1733
            Relay_Master_Log_File master-bin.000001
            Slave_IO_Running Yes
            Slave_SQL_Running No
            Replicate_Rewrite_DB
            Replicate_Do_DB
            Replicate_Ignore_DB
            Replicate_Do_Table
            Replicate_Ignore_Table
            Replicate_Wild_Do_Table
            Replicate_Wild_Ignore_Table
            Last_Errno 1032
            Last_Error Could not execute Delete_rows_v1 event on table test.DD; Can't find record in 'DD', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log master-bin.000001, end_log_pos 1893
            Skip_Counter 0
            Exec_Master_Log_Pos 1433
            Relay_Log_Space 2734
            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 1032
            Last_SQL_Error Could not execute Delete_rows_v1 event on table test.DD; Can't find record in 'DD', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log master-bin.000001, end_log_pos 1893
            Replicate_Ignore_Server_Ids
            Master_Server_Id 1
            Master_SSL_Crl
            Master_SSL_Crlpath
            Using_Gtid Slave_Pos
            Gtid_IO_Pos 0-1-6
            Replicate_Do_Domain_Ids
            Replicate_Ignore_Domain_Ids
            Parallel_Mode optimistic
            SQL_Delay 0
            SQL_Remaining_Delay NULL
            Slave_SQL_Running_State
            Slave_DDL_Groups 11
            Slave_Non_Transactional_Groups 6
            Slave_Transactional_Groups 0
            {noformat}
            Replication failure also occurs with InnoDB, but doesn't seem to occur if table {{B}} is defined with the Aria engine.

            A much longer test that always seems to fail is attached ({{1048.test}}).
            nikitamalyavin Nikita Malyavin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Description The following is non-deterministic - usually I can get a failure with {{--repeat=100}}.

            {code:sql}
            --source include/master-slave.inc
            --source include/have_innodb.inc
            --source include/have_binlog_format_row.inc

            --connection slave
            call mtr.add_suppression("Can't find record in 'DD'");

            --connection master
            USE test;

            CREATE TABLE `DD` (geocol7 GEOMETRYCOLLECTION NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), scol4 BINARY NOT NULL DEFAULT '', vcol9 POINT AS ( geocol7 ) );
            INSERT INTO `DD` () VALUES (),(),();

            # not sure if this is necessary, but failure seems to occur with or without
            UNLOCK TABLES;

            # FLUSH TABLES seems necessary for replication to error
            FLUSH TABLES;

            ALTER ONLINE TABLE `DD` ADD COLUMN ( geocol3 GEOMETRY NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), ncol4 DECIMAL UNSIGNED NOT NULL ), ALGORITHM=COPY, LOCK=NONE;
            DELETE FROM `DD` LIMIT 7;

            DROP TABLE DD;
            --source include/rpl_end.inc
            {code}

            {noformat}
            CURRENT_TEST: rpl.1048_small
            mysqltest: In included file "./include/check_slave_param.inc":
            included from ./include/check_slave_no_error.inc at line 24:
            included from ./include/rpl_end.inc at line 74:
            included from /home/angelique/dev/build-11.1-MDEV-16329-e599b8b4586/build1/mysql-test/suite/rpl/t/1048_small.test at line 25:
            At line 31: Wrong value for slave parameter Last_SQL_Errno
            {noformat}

            {noformat}
            **** SHOW SLAVE STATUS on server_2 ****
            SHOW SLAVE STATUS;
            Slave_IO_State Waiting for master to send event
            Master_Host 127.0.0.1
            Master_User root
            Master_Port 16000
            Connect_Retry 1
            Master_Log_File master-bin.000001
            Read_Master_Log_Pos 2125
            Relay_Log_File slave-relay-bin.000002
            Relay_Log_Pos 1733
            Relay_Master_Log_File master-bin.000001
            Slave_IO_Running Yes
            Slave_SQL_Running No
            Replicate_Rewrite_DB
            Replicate_Do_DB
            Replicate_Ignore_DB
            Replicate_Do_Table
            Replicate_Ignore_Table
            Replicate_Wild_Do_Table
            Replicate_Wild_Ignore_Table
            Last_Errno 1032
            Last_Error Could not execute Delete_rows_v1 event on table test.DD; Can't find record in 'DD', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log master-bin.000001, end_log_pos 1893
            Skip_Counter 0
            Exec_Master_Log_Pos 1433
            Relay_Log_Space 2734
            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 1032
            Last_SQL_Error Could not execute Delete_rows_v1 event on table test.DD; Can't find record in 'DD', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log master-bin.000001, end_log_pos 1893
            Replicate_Ignore_Server_Ids
            Master_Server_Id 1
            Master_SSL_Crl
            Master_SSL_Crlpath
            Using_Gtid Slave_Pos
            Gtid_IO_Pos 0-1-6
            Replicate_Do_Domain_Ids
            Replicate_Ignore_Domain_Ids
            Parallel_Mode optimistic
            SQL_Delay 0
            SQL_Remaining_Delay NULL
            Slave_SQL_Running_State
            Slave_DDL_Groups 11
            Slave_Non_Transactional_Groups 6
            Slave_Transactional_Groups 0
            {noformat}
            Replication failure also occurs with InnoDB, but doesn't seem to occur if table {{B}} is defined with the Aria engine.

            A much longer test that always seems to fail is attached ({{1048.test}}).             		The following is non-deterministic - usually I can get a failure with {{--repeat=100}}.

            {code:sql}
            --source include/master-slave.inc
            --source include/have_innodb.inc
            --source include/have_binlog_format_row.inc

            --connection slave
            call mtr.add_suppression("Can't find record in 'DD'");

            --connection master
            USE test;

            CREATE TABLE `DD` (geocol7 GEOMETRYCOLLECTION NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), scol4 BINARY NOT NULL DEFAULT '', vcol9 POINT AS ( geocol7 ) );
            INSERT INTO `DD` () VALUES (),(),();

            # not sure if this is necessary, but failure seems to occur with or without
            UNLOCK TABLES;

            # FLUSH TABLES seems necessary for replication to error
            FLUSH TABLES;

            ALTER ONLINE TABLE `DD` ADD COLUMN ( geocol3 GEOMETRY NULL DEFAULT ST_GEOMFROMTEXT('Point(1 1)'), ncol4 DECIMAL UNSIGNED NOT NULL ), ALGORITHM=COPY, LOCK=NONE;
            DELETE FROM `DD` LIMIT 7;

            DROP TABLE DD;
            --source include/rpl_end.inc
            {code}

            {noformat}
            CURRENT_TEST: rpl.1048_small
            mysqltest: In included file "./include/check_slave_param.inc":
            included from ./include/check_slave_no_error.inc at line 24:
            included from ./include/rpl_end.inc at line 74:
            included from /home/angelique/dev/build-11.1-MDEV-16329-e599b8b4586/build1/mysql-test/suite/rpl/t/1048_small.test at line 25:
            At line 31: Wrong value for slave parameter Last_SQL_Errno
            {noformat}

            {noformat}
            **** SHOW SLAVE STATUS on server_2 ****
            SHOW SLAVE STATUS;
            Slave_IO_State Waiting for master to send event
            Master_Host 127.0.0.1
            Master_User root
            Master_Port 16000
            Connect_Retry 1
            Master_Log_File master-bin.000001
            Read_Master_Log_Pos 2125
            Relay_Log_File slave-relay-bin.000002
            Relay_Log_Pos 1733
            Relay_Master_Log_File master-bin.000001
            Slave_IO_Running Yes
            Slave_SQL_Running No
            Replicate_Rewrite_DB
            Replicate_Do_DB
            Replicate_Ignore_DB
            Replicate_Do_Table
            Replicate_Ignore_Table
            Replicate_Wild_Do_Table
            Replicate_Wild_Ignore_Table
            Last_Errno 1032
            Last_Error Could not execute Delete_rows_v1 event on table test.DD; Can't find record in 'DD', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log master-bin.000001, end_log_pos 1893
            Skip_Counter 0
            Exec_Master_Log_Pos 1433
            Relay_Log_Space 2734
            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 1032
            Last_SQL_Error Could not execute Delete_rows_v1 event on table test.DD; Can't find record in 'DD', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log master-bin.000001, end_log_pos 1893
            Replicate_Ignore_Server_Ids
            Master_Server_Id 1
            Master_SSL_Crl
            Master_SSL_Crlpath
            Using_Gtid Slave_Pos
            Gtid_IO_Pos 0-1-6
            Replicate_Do_Domain_Ids
            Replicate_Ignore_Domain_Ids
            Parallel_Mode optimistic
            SQL_Delay 0
            SQL_Remaining_Delay NULL
            Slave_SQL_Running_State
            Slave_DDL_Groups 11
            Slave_Non_Transactional_Groups 6
            Slave_Transactional_Groups 0
            {noformat}
            Replication failure also occurs with InnoDB, but doesn't seem to occur if the table is defined with the Aria engine.

            A much longer test that always seems to fail is attached ({{1048.test}}).
            nikitamalyavin Nikita Malyavin made changes -
            Summary Replica SQL thread stops with 1032 error on ALTER ONLINE with Geometry Types Replica stops with error on ALTER ONLINE with Geometry Types
            nikitamalyavin Nikita Malyavin made changes -
            Assignee Nikita Malyavin [ nikitamalyavin ] Oleksandr Byelkin [ sanja ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Nikita Malyavin [ nikitamalyavin ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            nikitamalyavin Nikita Malyavin made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 11.2 [ 28603 ]
            Fix Version/s 11.1 [ 28549 ]
            nikitamalyavin Nikita Malyavin made changes -
            nikitamalyavin Nikita Malyavin made changes -
            nikitamalyavin Nikita Malyavin made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 11.2.1 [ 29034 ]
            Fix Version/s 11.2 [ 28603 ]
            Resolution Fixed [ 1 ]
            Status In Testing [ 10301 ] Closed [ 6 ]

            People

              nikitamalyavin Nikita Malyavin
              angelique.sklavounos Angelique Sklavounos (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.