Re: [Sqlgrey-users] 1.6.x and 1.7.x freezes

[Rupa S. (lists) <rup...@ru...>]

On 7/25/2005 10:26 AM, Rupa Schomaker (lists) wrote:
> I just started experiencing this problem.  Small volume mail server
> (3-6k msgs a day).  I have to restart sqlgrey a few times a day.

I also noticed the following in my mail.log (uninitialized vars):

Jul 25 09:15:50 shakti sqlgrey: Process Backgrounded
Jul 25 09:15:50 shakti sqlgrey: 2005/07/25-09:15:50 sqlgrey (type
Net::Server::Multiplex) starting! pid(15110)
Jul 25 09:15:50 shakti sqlgrey: Binding to TCP port 2501 on host localhost
Jul 25 09:15:50 shakti sqlgrey: Setting gid to "1016 1016"
Jul 25 09:15:50 shakti sqlgrey: Setting uid to "1016"
[...]
Jul 25 10:18:43 shakti sqlgrey: dbaccess: error: couldn't get reconnect
delay: ERROR:  prepared statement "dbdpg_282" does not exist
Jul 25 10:18:43 shakti sqlgrey: warning: Use of uninitialized value in
concatenation (.) or string at /var/lib/sqlgrey/sqlgrey line 2002.
Jul 25 10:18:43 shakti sqlgrey: grey: reconnect ok: 64.4.31(64.4.31.16),
[removed] -> [removed]
[snip]
Jul 25 10:18:43 shakti sqlgrey: warning: Use of uninitialized value in
concatenation (.) or string at /var/lib/sqlgrey/sqlgrey line 227.
Jul 25 10:18:43 shakti sqlgrey: dbaccess: warning: couldn't do query:
INSERT INTO from_awl (sender_name, sender_domain, src, first_seen,
last_seen) VALUES('[removed]','hotmail.com','64.4.31','sql
error',NOW()): , reconnecting to DB
Jul 25 10:18:43 shakti postfix/qmgr[16103]: 7C2999423E3:
from=<sq...@ru...>, size=423, nrcpt=1 (queue active)
Jul 25 10:18:43 shakti postfix/pickup[17307]: 83C949423E4: uid=1016
from=<sqlgrey>
Jul 25 10:18:43 shakti postfix/cleanup[17386]: 83C949423E4:
message-id=<200...@ma...>
Jul 25 10:18:43 shakti sqlgrey: warning: Use of uninitialized value in
concatenation (.) or string at /var/lib/sqlgrey/sqlgrey line 2025.


-- 
 -Rupa