Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC

CTAS-based MDL lock hang

  1. Series 5.6
  2. Bug #1245831
Bug #1245831 reported by Raghavendra D Prabhu
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
New
Undecided
Seppo Jaakola
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Status tracked in 5.6
5.5
Won't Fix
Medium
Unassigned
5.6
Fix Committed
Medium
Unassigned

Bug Description

This is related to https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1208937 but with release build (hence doesn't crash).

The lock is MDL related in ha_commit_trans path.

Tags: ctas
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

Also adding codership here since https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1208937 affects it too.

Seppo Jaakola (seppo-jaakola)
Changed in codership-mysql:
assignee: nobody → Seppo Jaakola (seppo-jaakola)
Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

first hit this issue, when reproducing: lp:1246257

Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

Next issue hit when trying to reproduce this, was CTAS with empty result sets, this bug is tracked here: lp:1246921

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

Related issue: https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1274260

Revision history for this message
Krunal Bauskar (krunal-bauskar) wrote :

Recent testing with 5.6 hasn't shown the said CTAS issue.

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-1085

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

Other bug subscribers

Bug attachments

Remote bug watches

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