Re: [Sqlgrey-users] Frequent disconnect/reconnect issues

[Karl O. P. <ko...@me...>]

On Wed, 19 Aug 2015 13:33:49 -0400
Alex <mys...@gm...> wrote:

> Hi guys,
> 
> I'm still having database problems. Can someone tell me under what
> circumstances the database would expect to see a value that doesn't
> exist?
> 
> Aug 19 00:07:39 mail02 sqlgrey: dbaccess: warning: couldn't do
> query:#012INSERT INTO from_awl (sender_name, sender_domain, src,
> first_seen, last_seen)
> VALUES('shimvebvl','uwerim.ru','91.121.21','2015-08-19
> 00:00:57',NOW()):#012, reconnecting to DB
> 
> And why this would cause a disconnect/reconnect to occur?

I believe you have it backwards.  The message
says it can't insert the value.  Because it can't
insert the value you wouldn't expect to see the
value in the db.  It's probably not inserting the
value because it's connection to the db is broken.
So it tries to reconnect to the db.

Something, somewhere, probably not in sqlgrey,
probably not even in perl -- although all these
probablies are just a guess, is breaking the 
connection to the db.

As I mentioned before, the most straightforward
approach is to instrument your db and get logs
of when connections break or otherwise go away.
Your db must know when this happens.


Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein