This is a follow up of my previous thread: High service latency
This occurred on a single node running with almost no load. A delete query was running on a table with 7 rows in it, every 5-10 seconds, and no rows are matched by the delete query so nothing was being deleted.
After running for several hours, I got the same issue I had in the previous thread, where the queries do not finish.
Here is the result of
show queries: https://pastebin.com/raw/69DeEqnd
Along with queries that do not respond anymore, it seems there are many duplicates of the same query with the same timestamp, even though there should only be one for each timestamp.
I have since killed my client so there should be zero activity, but more duplicates of these queries continue to show up in
show queries, with the same timestamps as before: https://pastebin.com/raw/mXNe2V9k (truncated from 200 rows)
Running the same query manually does not have any issues.
At the same time when the queries stopped responding, the only messages in the log that looked out of place (eveything else was regular info logs), were some warnings which are still occurring: https://pastebin.com/raw/nrs4ujRE
Does anybody have any insight into my problem?