Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17720

slave_ddl_exec_mode=IDEMPOTENT does not handle DROP DATABASE

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3.10
    • Fix Version/s: 10.0.38
    • Component/s: Replication
    • 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'
      

        Attachments

          Activity

            People

            • Assignee:
              sachin.setiya.007 Sachin Setiya
              Reporter:
              hholzgra Hartmut Holzgraefe
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: