02.12.2009 12:49, Paolo Lucente пишет: > >> Is it possible use it? And it working good. Problem only when I stop it. >> > It has to be identified what is causing it. The problem it flags is > duplicates within the primary key. This is because the UPDATE query > cannot be used as part of the sql_dont_try_update (which, once again > gives better performances, so good it is enabled). > > You should get a few examples of which rows are clashing (take one > duplicate error message and search for that row in the database). > If stopping-starting-stopping pmacct in a very short sequence you > might obvioulsy have to clean up the database for the test to be > consistent. Verify whether the clash makes sense or not - given > your schema and configuration. > I give schema and configuration on the first email. And I clean up database before every test.
As I see - problem in tables t1 and td. ERROR ( t2/mysql ): Duplicate entry '0-5-2009-11-28 02:00:00' for key 1 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 But I don't understand why it working good when make insert every hour and not work when I stop it. (No records in DB with stamp_inserted 2009-11-28 02:00:00 when it stops) And probably better not use sql_multi_values when daemon get signal to stop and have sql_dont_try_update: true > One last note: last time you posted your config, i recall you did > enable 'nfacctd_time_new' which is recommended when using NetFlow > in conjunction with these SQL directives. Is it still the case, > right? > Yes. I have nfacctd_time_new: true But any way thanks for point me not use sql_multi_values. I'll use it only for t3, t4 where used sql_dont_try_update[t3]: false -- WBR, Dubrovskiy Vyacheslav
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
