[rt-users] Odd Question

[Derek Buttineau]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20020131/c34cf55e/attachment.htm>