[rt-users] Requestor email address search hangs apache process

Kenneth Marshall ktm at rice.edu
Thu Apr 29 08:39:07 EDT 2010

On Thu, Apr 29, 2010 at 08:24:22AM +0100, Justin Hayes wrote:
> RT3.8.4
> If I use an unprivileged user (or a privileged user with no rights to see queues or tickets) to create a very simple search that looks like this:
> Requestor.EmailAddress Like '<email address>' 
> then the apache process handling the request maxes out CPU and hangs forever. If I create the same search with a privileged user that has rights to see queues etc it's fine and returns instantly.
> This is a big problem as the SelfService interface screens work via requestor email address, so anyone accessing SelfService severely affects performance of my RT.
> Anyone got any ideas????
> Thanks,
> Justin
> -------------------------------------------------
> Justin Hayes
> Orbis Support Manager
> justin.hayes at orbisuk.com
Hi Justin,

Perhaps you are missing an index. What query is hitting the database
for the slow search? What DB backend are you using?


More information about the rt-users mailing list