"flush tables with read lock" wrong error message

Bug #1054319 reported by pservit
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
New
Undecided
Unassigned
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Won't Fix
Undecided
Unassigned

Bug Description

OS: Linux db3 2.6.32-220.el6.x86_64 #1 SMP Tue Dec 6 19:48:22 GMT 2011 x86_64 x86_64 x86_64 GNU/Linux
Server version: 5.5.27-log Percona XtraDB Cluster (GPL), wsrep_23.6.r356

Percona-XtraDB-Cluster-shared-5.5.27-23.6.356.rhel6.x86_64
Percona-XtraDB-Cluster-galera-2.0-1.114.rhel6.x86_64
Percona-Server-shared-compat-5.5.27-rel28.1.296.rhel6.x86_64
Percona-XtraDB-Cluster-server-5.5.27-23.6.356.rhel6.x86_64
Percona-XtraDB-Cluster-client-5.5.27-23.6.356.rhel6.x86_64
percona-xtrabackup-2.0.2-461.rhel6.x86_64

I'm trying to setup new cluster.
When joining new node sst failed on flush tables step (https://bugs.launchpad.net/percona-xtrabackup/+bug/1022874)

mysql> flush tables with read lock;
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

Error appears immediately after issuing command without delays, but all threads are in "Waiting for global read lock" state until "unlock tables"

Revision history for this message
Vadim Tkachenko (vadim-tk) wrote :

Please try the latest 5.5.28 release

Changed in percona-xtradb-cluster:
status: New → Incomplete
Revision history for this message
pservit (pservit) wrote :

Same issue on 5.5.28

Changed in percona-xtradb-cluster:
status: Incomplete → New
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

@pservit,

Still hitting that error? It may have been because of lp:1007446 which has been fixed now. Also, have you set lock_wait_timeout (not innodb lock wait timeout) in my.cnf

Changed in percona-xtradb-cluster:
status: New → Incomplete
Revision history for this message
Krunal Bauskar (krunal-bauskar) wrote :

FLUSH TABLE WITH READ LOCK work w/o any error in latest 5.6 trunk. Please upgrade.
(Old version may have error/issue that got fixed as part of other fixes till date). Will close this bug.

Changed in percona-xtradb-cluster:
status: Incomplete → Won't Fix
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/PXC-1246

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.