Re: [Sqlgrey-users] #Error Messages in Log

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

Hi Marc,

Then there's a db connectivity problem of some sort.
Something that prevents the db from even seeing
the connection attempt.  (Unless your db is so
lame it's not logging something.)

By the by, I don't believe that these messages
are in indication that any mail is lost, etc.
They are notifications of an unexpected condition.

Perhaps your db has concurrency problems?  (I always
use Postgres because it's always been most featurefull
and caused the fewest headaches.)

On 12/18/2013 10:25:51 AM, Grooz, Marc (regio iT) wrote:
> Hi Karl,
> 
> the syslog, db log and db error log are empty of error messages in
> that time.
> 
> Kind regards
> 
> Marc
> 
> -----Ursprüngliche Nachricht-----
> Von: Karl O. Pinc [mailto:ko...@me...] 
> Gesendet: Dienstag, 17. Dezember 2013 16:48
> An: SQLgrey users mailing-list
> Betreff: Re: [Sqlgrey-users] #Error Messages in Log
> 
> On 12/17/2013 01:53:14 AM, Grooz, Marc (regio iT) wrote:
> > Hi,
> > 
> > i configure tree servers with dbcluster support. They only use one 
> > Database as readhost and dbhost. Sometimes I get these error
> > messages:
> > 
> > sqlgrey: dbaccess: warning: couldn't do query:#012INSERT INTO
> from_awl 
> > (sender_name, sender_domain, src, first_seen, last_seen)
> > VALUES('-undef-','-undef-','x','2013-12-16
> > 08:40:16',NOW()):#012Duplicate entry 'x--undef---undef-' for key 
> > 'PRIMARY', reconnecting to DB
> > 
> > any idea?
> 
> Always the usual to check first.  (And always easy to forget.) What 
> do
> the db logs and the os logs say?
> 
> 
> Karl <ko...@me...>
> Free Software:  "You don't pay back, you pay forward."
>                  -- Robert A. Heinlein
> 
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most
> IT organizations don't have a clear picture of how application
> performance affects their revenue. With AppDynamics, you get 100%
> visibility into your Java,.NET, & PHP application. Start your 15-day
> FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/
> ostg.clktrk
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
> 
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most
> IT 
> organizations don't have a clear picture of how application
> performance 
> affects their revenue. With AppDynamics, you get 100% visibility into
> your 
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
> AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/
> ostg.clktrk
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
> 
> 




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