Bug #67942 CREATE TABLE is not written in binary log if connection is killed in the process
| Submitted: | 18 Dec 2012 21:34 | Modified: | 20 Dec 2012 16:55 |
|---|---|---|---|
| Reporter: | Elena Stepanova | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Row Based Replication ( RBR ) | Severity: | S3 (Non-critical) |
| Version: | 5.5, 5.6, 5.5.30 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | regression | ||
[18 Dec 2012 21:34]
Elena Stepanova
[19 Dec 2012 11:51]
Valeriy Kravchuk
This is easy to verify on 5.5.28: **** SHOW SLAVE STATUS on default **** SHOW SLAVE STATUS; Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port 13000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 429 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 364 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 1146 Last_Error Error executing row event: 'Table 'test.t2' doesn't exist' Skip_Counter 0 Exec_Master_Log_Pos 217 Relay_Log_Space 732 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 1146 Last_SQL_Error Error executing row event: 'Table 'test.t2' doesn't exist' Replicate_Ignore_Server_Ids Master_Server_Id 1
[20 Dec 2012 16:55]
Sveta Smirnova
Thank you for the report. Verified as described. Bug is not repeatable with versions 5.1.68 and 5.7.1
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.