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

[Justin Hayes]

Hi Kenneth,

I'm using MYSQL, How can I tell which query it is? I get no logging and nothing in the MYSQL slow search log, I assume because it never completes?

Thanks,

Justin

-------------------------------------------------
Justin Hayes
Orbis Support Manager
justin.hayes at orbisuk.com




On 29 Apr 2010, at 13:39, Kenneth Marshall wrote:

> 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?
> 
> Cheers,
> Ken