Been running into this lately with the our RT2-0-11 setup, and have seen the same issue coming from previous versions back to RT2-0-1…
We’ve been seeing RT overload itself on the SQL backend (mysql) occasionally as of late.
Today I managed to catch the query that was causing it, which is:
SELECT DISTINCT main.* FROM Tickets main, Watchers Watchers_1, Watchers Watchers_3, Watchers Watcher
When this happens it locks the RT Tickets table while it copies the query to a tmp database:
| 5933 | rtuser | localhost | rt2 | Query | 447 | Copying to tmp table | SELECT DISTINCT main.* FROM Tickets main, Watchers Watchers_1, Watchers Watchers_3, Watchers Watcher |
However, we’re seeing this sit for up to hours without resolution… I end up having to flush the processes in order for RT to resume operation.
Has anyone else ran into this and/or know how to resolve it?
Thanks,
Derek