...@pmacct.net
[mailto:pmacct-discussion-boun...@pmacct.net] På vegne af Paolo Lucente
Sendt: 12. september 2010 01:32
Til: pmacct-discussion@pmacct.net
Emne: Re: [pmacct-discussion] duplicates...
Hi Thomas,
This very likely answers why you are not seeing all you expect in the database.
Reason you
Lucente
Sendt: 12. september 2010 01:32
Til: pmacct-discussion@pmacct.net
Emne: Re: [pmacct-discussion] duplicates...
Hi Thomas,
This very likely answers why you are not seeing all you expect in the database.
Reason you get duplicates is pmacct is trying to insert into the database more
than once
-Oprindelig meddelelse-
Fra: pmacct-discussion-boun...@pmacct.net
[mailto:pmacct-discussion-boun...@pmacct.net] P? vegne af Paolo Lucente
Sendt: 12. september 2010 01:32
Til: pmacct-discussion@pmacct.net
Emne: Re: [pmacct-discussion] duplicates...
Hi Thomas,
This very likely
-Oprindelig meddelelse-
Fra: Paolo Lucente [mailto:pa...@pmacct.net]
Sendt: 12. september 2010 20:42
Til: Thomas Raabo - ZitCom A/S
Cc: pmacct-discussion@pmacct.net
Emne: Re: SV: [pmacct-discussion] duplicates...
Hi Thomas,
UPDATEs are resource intensive and hence take more time for the database
Once every 10 min iam getting some errors
DEBUG ( default/mysql ): purging process (CAUSE: safe action)
( default/mysql ) *** Purging cache - START ***
DEBUG ( default/mysql ): 568 VALUES statements sent to the MySQL server.
ERROR ( default/mysql ): Duplicate entry
Hi Thomas,
This very likely answers why you are not seeing all you expect
in the database. Reason you get duplicates is pmacct is trying
to insert into the database more than once per 600 seconds (as
per your configuration) and sql_dont_try_update is set to true.
So quickest work-around is to