[rt-users] Upgraded Perl and apache/mod_perl and now a few things are really slow ...

[Philip Kime]

Found the culprit - DBIx::Searchbuilder 1.46. I downgraded to 1.45_02
and it's now fine.
I have attached the query log of trying to open the Query Builder page
with 1.46. All that repeated

OR Principals_1.Disabled = '0'

Looks a little odd ...

PK

 

-----Original Message-----
From: Jesse Vincent [mailto:jesse at bestpractical.com] 
Sent: Thursday, March 01, 2007 5:21 PM
To: Philip Kime
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Upgraded Perl and apache/mod_perl and now a few
things are really slow ...




On Thu, Mar 01, 2007 at 05:18:35PM -0800, Philip Kime wrote:
> RT 3.6.3.
>  
> I upgraded a server running apache/mod_perl to the latest stable 
> versions, re-compiling them on a 64-bit RHEL4 box. I used the worker 
> module for apache. I also re-compiled a 64-bit perl. Previously, the 
> box was using 32-bit everything. Anyway, with the new setup, it all 
> works except I get really slow repsonse times for loading the 
> query-builder and the Reply page for tickets - about 90 seconds each. 
> This makes me think it's related to the Owner drop-down. However, if I

> stop apache, put back the original Perl and original apache, both of 
> those pages are fine and fast. So, it doesn't seem to be a DB problem?
>  
> I did re-compile and install all the RT required perl modules from 
> scratch - perhaps a newer version of some module isn't working 
> properly
> - anyone know of anything like this?

Compare the output from the "RT variables and module listing" page from
running RT with both perls?

>  
> Any ideas?
>  
> PK
>  
> --
> Philip Kime
> NOPS Systems Architect
> 310 401 0407
>  

> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com Commercial support: 
> sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com

-- 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: rtlog.txt.gz
Type: application/x-gzip
Size: 13343 bytes
Desc: rtlog.txt.gz
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070301/f340a352/attachment.bin>