[rt-users] Re: Never-ending OR search

[seph]

"Jonathan Reeder" <jreeder at minutemenu.com> writes:

> I'm trying to do a ticket search that looks basically like this:
>
> RequestorGroup = 'xxx' OR CcGroup = 'xxx'
>
> When I run this search, it runs for several minutes with no results.
> Nothing is displayed to screen, and after giving up the search, if I try to
> click back or simply make a new request for my RT's homepage, I get no
> response from the server.  I have to close my browser and open a new one (or
> just get rid of my RT cookie) before RT will give me any pages at all after
> I try this search.

There are a couple things going on. A certain set of conditions seems
to produce sql that takes ages to chomp. It's been discussed on the
mailing lists, though I'm not sure what its current state is. 

The other that that's happening, is that while your database is
chewing on that sql query, it locks your session. Further hits to rt
from the same session, start tying up mysql processes waiting for the
first search to finish. At least, that's what I've observed on my
machines.

seph