[rt-users] long running query that never finishes (six days at 100%CPU)

[Brian Kerr]

On 7/24/06, Schultz, Eric <ESchultz at corp.untd.com> wrote:
> It would help even more to show the original "RT query" that generated
> this SQL.

Here you go.

Thanks,
Brian

[13/Jul/2006:10:09:30 -0400] x.x.x.x SSLv3 RC4-MD5 "GET
/Search/Results.html?Order=ASC&Query=%20Priority%20%3D%2075%20AND%20Created%20%3E%20'1%2F1%2F2006'%20AND%20Queue%20%3D%20'alerts'%20AND%20'CF.%7BActionable%7D'%20LIKE%20'Yes'%20AND%20'CF.%7BIR%7D'%20LIKE%20'Yes'%20AND%20Content%20NOT%20LIKE%20'Incident%20Report'&Rows=&OrderBy=id&Format='%20%20%20%3Cb%3E%3Ca%20href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23'%2C%0A'%3Cb%3E%3Ca%20href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject'%2C%0A'__Status__'%2C%0A'__QueueName__'%2C%0A'__OwnerName__'%2C%0A'__Priority__'%2C%0A'__NEWLINE__'%2C%0A''%2C%0A'%3Csmall%3E__Requestors__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E'
HTTP/1.1" 52331