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

[Grooz, M. (r. iT) <Mar...@re...>]

Hi Karl,

I always see only one Connection to the database?! So if you're right there must be a query limit per connection or something.

Kind regards

Marc


-----Ursprüngliche Nachricht-----
Von: Karl O. Pinc [mailto:ko...@me...] 
Gesendet: Mittwoch, 18. Dezember 2013 17:32
An: SQLgrey users mailing-list
Betreff: Re: [Sqlgrey-users] #Error Messages in Log

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

------------------------------------------------------------------------------
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