[Sqlgrey-users] lost connection event

[Bastien L. <ba...@yo...>]

Hi, using SQLGrey Version: 1.6.8-1  since a 10 days on  our production setup, receiving around  600 000 message per day.
2 servers hosting sqlgrey and 1 backend postgreSQL DB for sqlgrey.
It does work really great, thanks for this great tool ;)


Only little problem, I wanna solve is that really rarely (most of time, 1 or 2 times a day, sometimes 0), SQLGrey does encounter a concatenation problem and does not succeed to enter some data in DB.
This does trigger a lost connection and reconnection event, therefore sending me an email to tell me that connection to database was lost and a second one one second later to tell me that connection is back.

I identified 2 mails which triggered this kind of problem . Any idea of what was so special with theses 2 emails?
Or a way to tell SQLGrey to wait for 3 or 4 lost connections before sending alert email? (false positive are a bit annoying)

Mar 15 15:09:02 PHMCSMTP02 sqlgrey: grey: get_reconnect_delay error: no connect in database for web...@de..., 78.40.49, adm...@de...
Mar 15 15:09:02 PHMCSMTP02 sqlgrey: warning: Use of uninitialized value $delay in concatenation (.) or string at /usr/sbin/sqlgrey line 2053.
Mar 15 15:09:02 PHMCSMTP02 sqlgrey: grey: reconnect ok: 78.40.49(78.40.49.241), web...@de... -> adm...@de... ()
Mar 15 15:09:02 PHMCSMTP02 sqlgrey: grey: from awl: 78.40.49, web...@de... added
Mar 15 15:09:02 PHMCSMTP02 postfix/pickup[15438]: DE3F311C9FB: uid=111 from=<sqlgrey>
Mar 15 15:09:02 PHMCSMTP02 sqlgrey: warning: Use of uninitialized value $DBI::errstr in concatenation (.) or string at /usr/sbin/sqlgrey line 237.
Mar 15 15:09:02 PHMCSMTP02 sqlgrey: dbaccess: warning: couldn't do query:#012INSERT INTO from_awl (sender_name, sender_domain, src, first_seen, last_seen) VALUES('webmaster','de
cade.fr','78.40.49','error: nothing in connect',NOW()):#012, reconnecting to DB


Mar 10 20:56:48 PHMCSMTP02 sqlgrey: grey: reconnect ok: 88.191.81(88.191.81.9), bo...@ph... -> vg...@ka... (00:08:25.241069)
Mar 10 20:56:48 PHMCSMTP02 sqlgrey: grey: from awl: 88.191.81, bo...@ph... added
Mar 10 20:56:48 PHMCSMTP02 postfix/pickup[18078]: 94CF911C9FC: uid=111 from=<sqlgrey>
Mar 10 20:56:48 PHMCSMTP02 sqlgrey: warning: Use of uninitialized value $DBI::errstr in concatenation (.) or string at /usr/sbin/sqlgrey line 237.
Mar 10 20:56:48 PHMCSMTP02 sqlgrey: dbaccess: warning: couldn't do query:#012INSERT INTO from_awl (sender_name, sender_domain, src, first_seen, last_seen) VALUES('bounce','phpli
st.fr','88.191.81','2010-03-10 20:52:12.482616',NOW()):#012, reconnecting to DB
Mar 10 20:56:48 PHMCSMTP02 postfix/qmgr[12199]: 94CF911C9FC: from=<sq...@PH...>, size=441, nrcpt=1 (queue active)

Thanks

Bastien