Error: failed to execute query SELECT * FROM db2.#sql-ib189-3038396219 with --lock-ddl-per-table

Bug #1706587 reported by Shahriyar Rzayev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Triaged
Medium
Sergei Glushchenko

Bug Description

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.

Tags: qa
Changed in percona-xtrabackup:
status: Confirmed → Triaged
assignee: nobody → Sergei Glushchenko (sergei.glushchenko)
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-793

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.