Hi Slava, On Mon, Nov 30, 2009 at 03:03:41PM +0200, Slava Dubrovskiy wrote:
> I see such errors: > > [ ... ] > > DEBUG ( t2/mysql ): 3 VALUES statements sent to the MySQL server. > ERROR ( t2/mysql ): Duplicate entry '0-5-2009-11-28 02:00:00' for key 1 > > [ ... ] > > DEBUG ( t1/mysql ): 400 VALUES statements sent to the MySQL server. > ERROR ( t1/mysql ): Duplicate entry > '0-0.0.0.0-208.94.173.101-0-0-udp-2009-11-28 02:00:00' for key 1 Thanks for the extensive logging. You should be referring to the two errors above, right? To better pin-point where the issue is, it's good rule to remove the sql_multi_values: this allows to see precisely which SQL statement is causing the issue. From there you can check whether effectively this is something already in the database and why. The fact that you don't see anything written into the database when such errors pop up is normal due to the combination of the sql_multi_values and sql_dont_try_update directives. A multi-value query is effectively a single statement; so if one component fails it negatively affects all the others. If this doesn't help; feel free to send me further SQL output, commenting out the sql_multi_values. Perhaps this will get too extensive; in such a case, send it privately and then we can summarize over here. Cheers, Paolo _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists