Re: [Sqlgrey-users] Couple Problems with 1.6.0

[David R. <dr...@gm...>]

On 6/24/05, Lionel Bouton <lio...@bo...> wrote:
>=20
> That is really puzzling. Which version of:
> - perl,
> - DBI,
> - postgresql DBD driver,
> are you using, are they all coming with your distribution ?

perl-5.8.6-15
perl-DBI-1.48-4
perl-DBD-Pg-1.41-2
perl-Net-Server-0.87-4

All packages are shipped with FC4 except for perl-Net-Server which is
shipped by Fedora Extras.  Running postgresql 8 as well.

> - the connection with the database is borked.
> Either way, the code is designed to get around this (let the message
> pass if we can't get a straight answer from the database) and reconnect
> to the database hoping it is a temporary DB problem.

I'm guessing that the connection got borked, but for some reason it
didn't recover.  While sqlgrey has been running pretty smoothly since
yesterday, I still see a couple messages which it appears to recover
from:

Jun 24 00:03:54 forty sqlgrey: grey: domain awl match: updating
216.155.201(216.155.201.61), returns.groups.yahoo.com
Jun 24 00:05:04 forty sqlgrey: mail: failed to send: No child processes
Jun 24 00:05:04 forty sqlgrey: dbaccess: error: couldn't get reconnect
delay: ERROR:  prepared statement "dbdpg_73" does not exist
Jun 24 00:05:04 forty sqlgrey: warning: Use of uninitialized value in
concatenation (.) or string at /usr/sbin/sqlgrey line 1985.
Jun 24 00:05:04 forty sqlgrey: grey: reconnect ok:
68.142.198(68.142.198.207), ted...@sb... ->
dr...@gr... ()
Jun 24 00:05:04 forty sqlgrey: mail: failed to send: No child processes
Jun 24 00:05:04 forty sqlgrey: grey: from awl: 68.142.198,
ted...@sb... added
Jun 24 00:05:04 forty sqlgrey: mail: failed to send: No child processes
Jun 24 00:05:04 forty sqlgrey: dbaccess: warning: couldn't do query:
INSERT INTO from_awl (sender_name, sender_domain, src, first_seen,
last_seen) VALUES('ted.rees','sbcglobal.net','68.142.198','sql
error',NOW()): ERROR:  invalid input syntax for type timestamp: "sql
error" , reconnecting to DB
Jun 24 00:05:05 forty sqlgrey: mail: failed to send: No child processes
Jun 24 00:05:05 forty sqlgrey: warning: Use of uninitialized value in
concatenation (.) or string at /usr/sbin/sqlgrey line 2008.

> Even more surprising! I'm betting on a distro specific problem. A wild
> guess: is SELinux active? What happens if you deactivate it?

Nope, SELinux is disabled...

-Dave