enterprise-support team mailing list archive

[Nilnandan Joshi <nilnandan.joshi@xxxxxxxxxxx>]

Public bug reported:

CREATE TABLE `flushes` (
  `id` int(11) DEFAULT NULL
) ENGINE=MyISAM

insert into flushes values(1);
insert into flushes values(2);
insert into flushes values(3);

Connection1:
----------------------
select * from flushes where id=3 or sleep(213);  ## STEP-1

Connection2:
--------------------
flush tables with read lock; ## STEP-2, (you can run 'flush tables' as well)

#notice this flush blocks with status -> 'waiting for table flush',
which is ok.

Connection2:  ## STEP-3
-------------------
Do a Control-c and EXIT terminal. , ( i.e. interrupt the flush query)

Connection3:  ### STEP-4
--------------------
select * from flushes;

Connection4:   ### STEP-5 
--------------------
insert into flushes values(5);

Connection5:
---------------------
show processlist;

this show the following:
-----------------------------------------------------------------------------
State                   |                 Info      
-----------------------------------------------------------------------------
User sleep              |  select * from flushes where id=3 or sleep(213)
waiting for table flush |  select * from flushes;
waiting for table flush |  insert into flushes values(5);
-----------------------------------------------------------------------------

the blocked queries will terminate with lock wait timeout error.

Even though the 'flush tables...' terminated without even acquiring a
lock , subsequent queries were not allowed to continue.

** Affects: mysql-server
     Importance: Unknown
         Status: Unknown

** Affects: percona-server
     Importance: Undecided
         Status: Confirmed


** Tags: i57518 upstream

** Project changed: percona-xtrabackup => percona-server

** Bug watch added: MySQL Bug System #65777
   http://bugs.mysql.com/bug.php?id=65777

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

** Tags added: upstream

** Tags added: i57518

-- 
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/1479606

Title:
  killing 'Flush tables' in 'waiting for table flush' makes other
  queries block

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