[rt-users] RT 3.6.1 Logging

[Farrell,Bob]

Rebuilt RT on this box, installed Jesse's CGI patch and got rid of the
PERL error below.

 

Now two things happened:

 

When upgrading I got this error:

 

readline() on closed filehandle SCHEMA_LOCAL at
/opt/rt3/sbin/rt-setup-database line 192

 

Then while using RT, it is VERY slow, and I get these errors: ( I
flushed the Mason cache )

 

[Sun Aug 27 09:51:07 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:54:51 2006] [error] [Mason] File does not exist:
/opt/rt3/share/html/favicon.ico

Aug 27 09:54:52 help RT: prepare_cached(                 SELECT
a_session FROM sessions WHERE id = ?) statement handle
DBI::st=HASH(0xac09370) still Active at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 80
(/usr/lib/perl5/5.8.8/Carp.pm:271)

Aug 27 09:56:03 help RT: prepare_cached(                 SELECT
a_session FROM sessions WHERE id = ?) statement handle
DBI::st=HASH(0xac0eba4) still Active at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 80
(/usr/lib/perl5/5.8.8/Carp.pm:271)

[Sun Aug 27 09:56:51 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:56:51 2006] [info] [client 192.168.250.26] (32)Broken
pipe: core_output_filter: writing data to the network

[Sun Aug 27 09:56:54 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:56:55 2006] [info] [client 192.168.250.26] (32)Broken
pipe: core_output_filter: writing data to the network

[Sun Aug 27 09:57:07 2006] [error] [Mason] File does not exist:
/opt/rt3/share/html/favicon.ico

[Sun Aug 27 09:57:57 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:57:59 2006] [info] [client 192.168.250.26] (32)Broken
pipe: core_output_filter: writing data to the network

[Sun Aug 27 09:58:01 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:58:03 2006] [info] [client 192.168.250.26] (32)Broken
pipe: core_output_filter: writing data to the network

Aug 27 09:58:06 help RT: Successful login for rf from 192.168.250.26
(/opt/rt3/share/html/autohandler:244)

[Sun Aug 27 09:58:38 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:58:39 2006] [info] [client 192.168.250.26] (32)Broken
pipe: core_output_filter: writing data to the network

[Sun Aug 27 09:58:44 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:58:48 2006] [info] [client 192.168.250.26] (32)Broken
pipe: core_output_filter: writing data to the network

[Sun Aug 27 09:59:23 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:59:25 2006] [info] [client 192.168.250.26] (32)Broken
pipe: core_output_filter: writing data to the network

[Sun Aug 27 09:59:43 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:59:44 2006] [info] [client 192.168.250.26] (32)Broken
pipe: core_output_filter: writing data to the network

 

Any help would be appreciated, for if this does not work, I need to put
the RT 3.0.11 box back online.

 

Bob

 

From: Farrell,Bob 
Sent: Saturday, August 26, 2006 3:31 PM
To: Farrell,Bob; rt-users at lists.bestpractical.com
Subject: RE: [rt-users] RT 3.6.1 Logging

 

Got RT logging working.

 

Seeing a lot of debug info, but "appears" my issues lie with the

RT: DBD::mysql::st execute failed: Unknown column 'main.LookupType' in
'where clause'

Error.

 

Any assistance would be greatly appreciated.

 

I searched and searched before bothering the list members with this.

 

Thanks

BF

 

 

From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of
Farrell,Bob
Sent: Saturday, August 26, 2006 10:25 AM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] RT 3.6.1 Logging

 

I cannot get RT to log any errors...... not sure why.

 

I followed early posts and Wiki / Internet instructions.

 

I "DO" get one PERL error:

 

RT: DBD::mysql::st execute failed: Unknown column 'main.LookupType' in
'where clause'

 

 

I did all the schema upgrades.

 

Is there a way to fix this on an in place Production machine?

 

Regards,

Bob

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060827/f29e49b2/attachment.htm>