"System lock" status of "CHECK TABLE `mytable`"

Got partitioned innodb table mytable. Got problems while trying to execute “CHECK TABLE mytable“. Process hangs with “System lock” status.
mytable is partitioned:

/*!50100 PARTITION BY RANGE (UNIX_TIMESTAMP(dt))
(PARTITION p20150702 VALUES LESS THAN (1435870799) ENGINE = InnoDB,
PARTITION p2015w27 VALUES LESS THAN (1437944399) ENGINE = InnoDB,
PARTITION p2015w28 VALUES LESS THAN (1438376399) ENGINE = InnoDB,
PARTITION p2015m08_1 VALUES LESS THAN (1439153999) ENGINE = InnoDB,
PARTITION p2015m08_2 VALUES LESS THAN (1439672399) ENGINE = InnoDB,
PARTITION p2015m08_3 VALUES LESS THAN (1440277199) ENGINE = InnoDB,
PARTITION pCurrent VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */ |

fsck on unmounted partition works fine.
Same problem after mysql restart, after server reboot.
Nothing special in error log for the last couple of weeks.


Source: mysql

Leave a Reply