|
From: David R. <dr...@gm...> - 2005-06-23 21:52:41
|
I just upgraded to 1.6.0 from 1.4.8 yesterday and have had a couple
problems with it.
I noticed this morning that sqlgrey appeared to have stopped
responding, then found these errors in /var/log/maillog:
Jun 22 16:45:21 forty sqlgrey: dbaccess: error: couldn't get reconnect
delay: ERROR: prepared statement "dbdpg_17" does not exist
Jun 22 16:45:21 forty sqlgrey: warning: Use of uninitialized value in
concatenation (.) or string at /usr/sbin/sqlgrey line 1985.
Jun 22 16:45:21 forty sqlgrey: dbaccess: warning: couldn't do query:
INSERT INTO from_awl (sender_name, sender_domain, src, first_seen,
last_seen) VALUES('tcg
rant','alumni.princeton.edu','64.97.160.33','sql error',NOW()): ERROR:
invalid input syntax for type timestamp: "sql error" , reconnecting
to DB
Jun 22 16:45:21 forty sqlgrey: warning: Use of uninitialized value in
concatenation (.) or string at /usr/sbin/sqlgrey line 2008.
Then it appears to have tried to restart itself later and I found
these messages:
Jun 23 02:58:53 forty sqlgrey: mail: failed to send: No child processes
Jun 23 02:58:53 forty sqlgrey: dbaccess: error: couldn't get reconnect
delay: ERROR: prepared statement "dbdpg_6" does not exist
Jun 23 02:58:53 forty sqlgrey: warning: Use of uninitialized value in
concatenation (.) or string at /usr/sbin/sqlgrey line 1985.
I tried killing the sqlgrey process, but would only respond to a kill -9.
Any ideas? I'm running on Fedora Core 4.
-Dave
|