mtr rpl.rpl_row_inexist_tbl fails

[Seppo Jaakola]

MySQL test suite test rpl.rpl_row_inexist_tbl fails for wrong error code in slave processing.

CURRENT_TEST: rpl.rpl_row_inexist_tbl
mysqltest: In included file "./include/wait_for_slave_sql_error.inc":
included from ./include/wait_for_slave_sql_error.inc at line 58:
At line 57: Slave stopped with wrong error code

The result from queries just before the failure was:
< snip >
SHOW BINARY LOGS;
Log_name File_size
master-bin.000001 405

**** SHOW BINLOG EVENTS on server_1 ****
binlog_name = 'master-bin.000001'
SHOW BINLOG EVENTS IN 'master-bin.000001';
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 4 Format_desc 1 107 Server ver: 5.5.15-wsrep_21.1beta-debug-log, Binlog ver: 4
master-bin.000001 107 Query 1 193 use `test`; CREATE TABLE t1 (a INT)
master-bin.000001 193 Query 1 261 BEGIN
master-bin.000001 261 Table_map 1 302 table_id: 41 (test.t1)
master-bin.000001 302 Write_rows 1 336 table_id: 41 flags: STMT_END_F
master-bin.000001 336 Query 1 405 COMMIT

**** SHOW RELAYLOG EVENTS on server_1 ****
relaylog_name = 'No such row'
SHOW RELAYLOG EVENTS IN 'No such row';
Log_name Pos Event_type Server_id End_log_pos Info
**** Slave stopped with wrong error code: 1053 (expected 1146) ****

[Seppo Jaakola (seppo-jaakola)]

Test is being run in native MySQL compatibility mode (no wsrep provider).
Underlying problem is that MySQL slave gets wron error code when trying to apply a RBR event for a table which does not exist. Error code in slave is: 1053 (server shutting down), anbd expected result was: 1146.

Slave status shows:

mysql> show slave status \G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 127.0.0.1
                  Master_User: root
                  Master_Port: 3307
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000001
          Read_Master_Log_Pos: 1332
               Relay_Log_File: pitbull-relay-bin.000004
                Relay_Log_Pos: 435
        Relay_Master_Log_File: mysql-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: 1053
                   Last_Error: Error executing row event: 'Table 'test.t' doesn't exist'
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 1163
              Relay_Log_Space: 1272
              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: 1053
               Last_SQL_Error: Error executing row event: 'Table 'test.t' doesn't exist'
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1

[Seppo Jaakola (seppo-jaakola)]

The fix deals also with bug lp:843252