[MDEV-17720] slave_ddl_exec_mode=IDEMPOTENT does not handle DROP DATABASE Created: 2018-11-14  Updated: 2018-12-21  Resolved: 2018-12-19

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.3.10
Fix Version/s: 10.0.38

Type: Bug Priority: Major
Reporter: Hartmut Holzgraefe Assignee: Sachin Setiya (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

With slave_ddl_exec_mode=IDEMPOTENT a DROP TABLE ... gets rewritten to DROP TABLE IF EXISTS ... before being executed on a slave, so it does not fail if the table is missing on the salve side.

A DROP DATABASE ... on the other hand does not get rewritten, and so leads to 

                Last_SQL_Errno: 1008
 
                Last_SQL_Error: Error 'Can't drop database 'test23'; database doesn't exist' on query.        
                       Default database: 'test23'. Query: 'drop database test23'



 Comments   
Comment by Sachin Setiya (Inactive) [ 2018-12-19 ]

HI Elkin , please review the patch for this bug , it is in bb-10.0-17720 branch

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