Uploaded image for project: 'Percona XtraBackup'
  1. Percona XtraBackup
  2. PXB-793

Fix syntax error when executing --lock-ddl-per-table queries

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • None
    • 2.4.21, 8.0.22-15
    • None

    Description

      **Reported in Launchpad by Shahriyar Rzayev last update 26-07-2017 12:10:29

      The SQL syntax error shown while trying to acquire MDL:

      170726 11:32:44 Locking MDL for db2.#sql-ib189-3038396219
      Error: failed to execute query SELECT * FROM db2.#sql-ib189-3038396219 LIMIT 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
      170726 11:32:44 [02] Copying ./db2/#sql-ib189-3038396219.ibd to /home/shahriyar.rzaev/backup_dir/ps_5.7_master/full/2017-07-26_11-31-56/db2/#sql-ib189-3038396219.ibd
      170726 11:32:44 [02] ...done

      It is clear, that issue is with temporary tables.
      So, maybe it is much more convenient not to show this error for temporary tables.

      Attachments

        Issue Links

          Activity

            People

              marcelo.altmann Marcelo Altmann
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist