[rt-users] FastCGI install very slow

[Paul Khavkine]

Hi folks.

I have installed RT3.0.9 on apache2 2.0.48 and fast_cgi 2.4.2 and very
often it seems very slow. I also see various errors in the log file:

[Mon Feb 23 11:30:00 2004] [error] [client 66.38.181.24] FastCGI: server "/usr/local/RT/bin/mason_handler.fcgi" stderr: DBD::Pg::st execute failed: ERROR:  invalid input syntax for integer: "" at /usr/local/lib/perl5/site_perl/5.8.2/DBIx/SearchBuilder/Handle.pm line 410., referer: http://rt.mtndods.distributel.net/Admin/Users/Modify.html
[Mon Feb 23 11:30:00 2004] [error] [client 66.38.181.24] FastCGI: server "/usr/local/RT/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0x8c23c4c) couldn't execute the query 'SELECT  * FROM Principals WHERE PrincipalType ILIKE ? AND (ObjectId IS NULL OR ObjectId = '')' at /usr/local/lib/perl5/site_perl/5.8.2/DBIx/SearchBuilder/Handle.pm line 417., referer: http://rt.mtndods.distributel.net/Admin/Users/Modify.html
[Mon Feb 23 12:00:04 2004] [error] [client 66.38.181.24] FastCGI: comm with server "/usr/local/RT/bin/mason_handler.fcgi" aborted: idle timeout (30 sec), referer: http://rt.mtndods.distributel.net/Search/Listing.html?ValueOfStatus=open&ValueOfStatus=new&StatusOp=%3D&QueueOp=%3D&ValueOfQueue=7&RowsPerPage=50&NewSearch=1

I'm using PostgreSQL 7.4.1


Thanx
Paul

************************************************
Paul Khavkine
Network Administrator
DISTRIBUTEL Communications.
740 Notre Dame West, Suite 1135
Montreal, Quebec, Canada, H3C 3X6
1-514-877-5505 x 263
http://www.distributel.net
************************************************