Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.0.14
-
unbuntu 12.04
Description
Hello,
I made a cleaner to supress data from a database, to test the script I put it at max and I got a freeze on a drop of temporary table (on slave).
DROP TEMPORARY TABLE IF EXISTS `PRODUCTION`.`DELETE_PROD_PRODUITS_BABEL` /* generated by server */ |
It's the 3rd time I meet with this problem.
show full processlist;
|
+------+------------------+------------------+------------+---------+--------+----------------------------------+----------------------------------------------------------------------------------------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+------+------------------+------------------+------------+---------+--------+----------------------------------+----------------------------------------------------------------------------------------------------+----------+
|
| 2 | event_scheduler | localhost | NULL | Daemon | 280218 | Waiting on empty queue | NULL | 0.000 |
|
| 228 | system user | | NULL | Connect | 274596 | Waiting for master to send event | NULL | 0.000 |
|
| 229 | system user | | PRODUCTION | Connect | 83613 | init | DROP TEMPORARY TABLE IF EXISTS `PRODUCTION`.`DELETE_PROD_PRODUITS_BABEL` /* generated by server */ | 0.000 |
|
| 7908 | dba | 10.10.16.7:32875 | mysql | Query | 83610 | init | SHOW MASTER STATUS | 0.000 |
|
| 7910 | debian-sys-maint | localhost | NULL | Query | 30808 | init | flush logs | 0.000 |
|
| 7913 | dba | 10.10.16.7:35808 | mysql | Query | 13804 | init | SHOW MASTER STATUS | 0.000 |
|
| 7914 | dba | 10.10.16.7:35826 | mysql | Query | 13751 | init | SHOW MASTER STATUS | 0.000 |
|
| 7915 | dba | 10.10.16.7:35847 | mysql | Query | 13287 | init | SHOW MASTER LOGS | 0.000 |
|
| 7917 | dba | 10.10.16.9:40147 | NULL | Killed | 10819 | Killing slave | stop slave | 0.000 |
|
| 7922 | dba | 10.10.16.9:40176 | NULL | Killed | 30 | init | SHOW MASTER LOGS | 0.000 |
|
| 7925 | dba | 10.10.16.9:40179 | NULL | Query | 0 | init | show full processlist | 0.000 |
|
+------+------------------+------------------+------------+---------+--------+----------------------------------+----------------------------------------------------------------------------------------------------+----------+
|
11 rows in set (0.00 sec)
|
and strange things : (empty)
show engine innodb status;
|
+--------+------+--------+
|
| Type | Name | Status |
|
+--------+------+--------+
|
| InnoDB | | |
|
+--------+------+--------+
|
1 row in set (0.00 sec)
|
After it all tools / function in relation with replication are totally frozen.