Description:
rpl_ignore_table has been disabled due to BUG#32462. Since BUG#32462 is "Can't repeat", I re-enabled rpl_ignore_table. However, that causes a new failure:
rpl.rpl_ignore_table 'row' [ fail ]
=== SHOW MASTER STATUS ===
---- 1. ----
File slave-bin.000001
Position 1278
Binlog_Do_DB
Binlog_Ignore_DB
==========================
=== SHOW SLAVE STATUS ===
---- 1. ----
Slave_IO_State Waiting for master to send event
Master_Host 127.0.0.1
Master_User root
Master_Port 10100
Connect_Retry 1
Master_Log_File master-bin.000001
Read_Master_Log_Pos 2525
Relay_Log_File slave-relay-bin.000002
Relay_Log_Pos 1815
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 test.t3,test.t1,test.t2
Replicate_Wild_Do_Table
Replicate_Wild_Ignore_Table %.tmptbl%
Last_Errno 1364
Last_Error Could not execute Write_rows event on table mysql.user; Field 'ssl_cipher' doesn't have a default value, Error_code: 1364; Field 'x509_issuer' doesn't have a default value, Error_code: 1364; Field 'x509_subject' doesn't have a default value, Error_code: 1364; handler error HA_ERR_ROWS_EVENT_APPLY; the event's master log master-bin.000001, end_log_pos 1946
Skip_Counter 0
Exec_Master_Log_Pos 1668
Relay_Log_Space 2828
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
Master_SSL_Verify_Server_Cert No
Last_IO_Errno 0
Last_IO_Error
Last_SQL_Errno 1364
Last_SQL_Error Could not execute Write_rows event on table mysql.user; Field 'ssl_cipher' doesn't have a default value, Error_code: 1364; Field 'x509_issuer' doesn't have a default value, Error_code: 1364; Field 'x509_subject' doesn't have a default value, Error_code: 1364; handler error HA_ERR_ROWS_EVENT_APPLY; the event's master log master-bin.000001, end_log_pos 1946
=========================
mysqltest: At line 85: could not sync with master ('select master_pos_wait('master-bin.000001', 2525)' returned NULL)
The result from queries just before the failure was:
< snip >
GRANT SELECT, INSERT, UPDATE, REFERENCES ON `test`.`t1` TO 'mysqltest2'@'localhost'
GRANT INSERT ON `test`.`t4` TO 'mysqltest2'@'localhost'
show grants for mysqltest3@localhost;
Grants for mysqltest3@localhost
GRANT USAGE ON *.* TO 'mysqltest3'@'localhost'
GRANT SELECT ON `test`.* TO 'mysqltest3'@'localhost'
GRANT SELECT (a), INSERT, INSERT (a), UPDATE (a), REFERENCES (a) ON `test`.`t4` TO 'mysqltest3'@'localhost'
show grants for mysqltest4@localhost;
Grants for mysqltest4@localhost
GRANT USAGE ON *.* TO 'mysqltest4'@'localhost' IDENTIFIED BY PASSWORD '*196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7'
GRANT SELECT ON `mysqltest2`.`t2` TO 'mysqltest4'@'localhost'
show grants for mysqltest6@localhost;
Grants for mysqltest6@localhost
GRANT SELECT, INSERT ON *.* TO 'mysqltest6'@'localhost'
GRANT INSERT ON `test`.* TO 'mysqltest6'@'localhost'
GRANT INSERT ON `test`.`t1` TO 'mysqltest6'@'localhost'
flush privileges;
show grants for mysqltest5@somehost;
Grants for mysqltest5@somehost
GRANT USAGE ON *.* TO 'mysqltest5'@'somehost'
More results from queries before failure can be found in /home/sven/bzr/b40903-disabled.def/6.0/mysql-test/var/log/rpl_ignore_table.log
Stopping All Servers
Restoring snapshot of databases
Resuming Tests
How to repeat:
enable rpl_ignore_table and run it.
Suggested fix:
rpl_ignore_table is now disabled by this bug. Please re-enable rpl_ignore_table after fixing this bug.
