MySQL Workbench shows running query but query not in process list I am having an issue where the same query sometimes completes in 600 seconds or less, but sometimes lags for multiple hours. MySQL Workbench shows the query as 'Running...', and initially I can see the query in the processlist. But after a significant amount of time after the query should have already returned results, I check the processlist and the query is no longer executing--yet Workbench still shows that it is running. What is happening to the query and why doesn't Workbench immediately give me an error code?
Sometimes if I wait a sufficiently long time to trigger a timeout I do get the 2013 error.
I am using a MacBook Pro running Big Sur connecting to a remote MySQL server through a VPN.
Could this be explained by poor network connectivity?
It may happen when a transaction is not committed or even roll-backed.
I had similar issues regarding incomplete queries in here when-a-table-is-locked-but-show-processlist-shows-nothing.
Hope that help you.