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?
Any ideas?
PK
Philip Kime
NOPS Systems Architect
310 401 0407
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?
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 …
PKFrom: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Thursday, March 01, 2007 5:21 PM
To: Philip Kime
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Upgraded Perl and apache/mod_perl and now a few
things are really slow …
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
The rt-users Archives
Community help: http://wiki.bestpractical.com Commercial support:
sales@bestpractical.com
Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
rtlog.txt.gz (13 KB)
I think that I’ve fixed problem, could you test the attached patch against 1.46?On 3/2/07, Philip Kime pkime@shopzilla.com wrote:
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
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?
[snip]
Best regards, Ruslan.
SB-1.46-dont_query_on_each_next_for_unions.patch (889 Bytes)