← Back to team overview

maria-developers team mailing list archive

Query Stuck in "closing table" State


I have a situation with MariaDB 10.0.0 where an
INSERT INTO ... SELECT query that takes 3 seconds to run ends up
stuck in the closing tables state for 15+ minutes while burning
100% of CPU.

I have seen bug reports dating back 5 years that sound very similar
but none of them are listed as resolved.

Is there a way to debug/troubleshoot this further? The problem is
quite intermittent. My data is in a state of constant flux so
finding an exact reproducible test case based on data lone isn't
likely to be viable. Is there a reasonable way to capture more detailed
debug information than what is available from "show full processlist"?


Follow ups