<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2712.300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=vt100 size=2>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.. </FONT></DIV>
<DIV><FONT face=vt100 size=2></FONT> </DIV>
<DIV><FONT face=vt100 size=2>We've been seeing RT overload itself on the SQL
backend (mysql) occasionally as of late.</FONT></DIV>
<DIV><FONT face=vt100 size=2></FONT> </DIV>
<DIV><FONT face=vt100 size=2>Today I managed to catch the query that was causing
it, which is:</FONT></DIV>
<DIV><FONT face=vt100 size=2></FONT> </DIV>
<DIV><FONT size=2>
<P>SELECT DISTINCT main.* FROM Tickets main, Watchers Watchers_1, Watchers
Watchers_3, Watchers Watcher</P>
<P><FONT face=vt100>When this happens it locks the RT Tickets table while it
copies the query to a tmp database:</FONT></P>
<P><FONT face=vt100>| 5933 | rtuser |
localhost |
rt2 | Query | 447 | Copying to
tmp table | SELECT DISTINCT main.* FROM Tickets main, Watchers Watchers_1,
Watchers Watchers_3, Watchers Watcher |</FONT></P>
<P><FONT face=vt100>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.</FONT></P>
<P><FONT face=vt100>Has anyone else ran into this and/or know how to resolve
it?</FONT></P>
<P><FONT face=vt100>Thanks,</FONT></P>
<P><FONT face=vt100><BR>Derek</FONT></P></FONT></DIV></BODY></HTML>