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

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

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