[rt-users] Searching Attachments

[Kevin Murphy]

Coincidentally, Richard's problem is the same as mine (apache spins 
cpu).  I have determined that whenever someone searches for 
attachments, the browser times out after a while, but an httpd/mod_perl 
process keeps desperately chewing  on the problem.

I'm using Postgres 7.3.4.  What are you using, Richard?

Is this a known problem?

As per a great hint on the mod_perl man page, I modified RT.pm to dump 
stack on receipt of a USR1 signal and signalled a fresh runaway httpd 
process after searching by ticket attachment.  The results hint where 
the problem might be:

(/Library/Perl/Carp.pm:192)
(/usr/local/rt3/lib/RT.pm:253)
/Library/Perl/DBIx/SearchBuilder/Handle/Pg.pm:243
/Library/Perl/DBIx/SearchBuilder.pm:309
/Library/Perl/DBIx/SearchBuilder.pm:211
/Library/Perl/DBIx/SearchBuilder.pm:1284
/usr/local/rt3/lib/RT/Tickets_Overlay.pm:1698
/usr/local/rt3/share/html/Search/Listing.html:104
/usr/local/rt3/share/html/autohandler:163

-Kevin Murphy