[MDEV-20348] DROP TABLE IF EXISTS killed on master but was replicated. Created: 2019-08-14  Updated: 2020-08-25  Resolved: 2019-08-14

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: None
Fix Version/s: 10.2.27, 10.3.18, 10.4.8

Type: Bug Priority: Blocker
Reporter: Sujatha Sivakumar (Inactive) Assignee: Sujatha Sivakumar (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks

 Description   

Following steps were performed by a process:

DROP TABLE IF EXISTS `tmp_1e` /* generated by server */
CREATE TABLE tmp_1 LIKE perm_1 /* ainternal305, gs:361F952CDB0FF3C076C373243996193F, tx:ddb58f2cdb873bc076c3732439961936 */
DELETE IGNORE FROM tmp_1 WHERE tmp_1.sys_id = OLD.sys_id;
REPLACE INTO tmp_1(`u_configuration_item`,`sys_id`) VALUES (NEW.`u_configuration_item`,NEW.`sys_id`);
REPLACE INTO tmp_1 (`u_configuration_item`,`sys_id`) VALUES (NEW.`u_configuration11111_item`,NEW.`sys_id`);
DROP TABLE IF EXISTS `z_tmp_1` /* generated by server */
RENAME TABLE perm_1 TO z_tmp_1, tmp_1 TO perm_1 /* a305, gs:361F952CDB0FF3C076C373243996193F, tx:ddb58f2cdb873bc076c3732439961936 */
DROP TABLE IF EXISTS `z_tmp_1 /* generated by server *

The last DROP TABLE IF EXISTS was killed. The table still exists on the master but the DDL was still logged:

#190731 14:36:55 server id 3119271449 end_log_pos 882519717 CRC32 0xa0c2142c Query	thread_id=2387200	exec_time=3	error_code=1317
SET TIMESTAMP=1564609015/*!*/;
DROP TABLE IF EXISTS `z_tmp_1` /* generated by server */
/*!*/;

It is logged with the query interrupted error (1317), but should it be logged since the table was not removed?



 Comments   
Comment by Sujatha Sivakumar (Inactive) [ 2019-08-14 ]

Fix for this issue is implemented in 10.2.27

Generated at Thu Feb 08 08:58:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.