enterprise-support team mailing list archive

[Laurynas Biveinis <laurynas.biveinis@xxxxxxxxx>]

Threads 6-9, 11-21 "show slave status nolock" waits for mi->data_lock
Thread 10 "show slave status" waits for rli->data_lock, has mi->data_lock
Thread 5 slave I/O thread waits for waits for mi->data_lock
Thread 4 slave SQL thread waits for MDL commit lock, has rli->data_lock
Thread 3 "show slave status" waits for LOCK_active_mi

Something must have the FTWRL or a similar lock that prevents commit.

Thread 4 corresponds to Thread 27 of 70307 two-thread deadlock
stacktrace, and Thread 10 corresponds to other one.

Confirmed upstream 70307.

** Tags added: upstream

** Changed in: percona-server/5.6
       Status: Confirmed => Triaged

** Changed in: percona-server/5.6
   Importance: Undecided => High

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=70307
   Importance: Unknown
       Status: Unknown

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1386363

Title:
  SHOW SLAVE STATUS hangs

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1386363/+subscriptions