Hi Johannes, To get more verbosity you have to disable the sql_multi_values feature; that's what causing the rather compact and un-helpful output. Would that be an option for you? Also, was wondering: any chance the "0.0.0.0" bit bucket entry is collecting > 4GB traffic in 5 minutes time? In such a case, the solution is to go with 64-bit counters. Let me know.
Cheers, Paolo PS: very verbose outputs are very much welcome but go in private email (perhaps compressed) :-) On Thu, Aug 06, 2009 at 07:33:57PM +0200, Johannes Formann wrote: > Paolo Lucente <pa...@pmacct.net> wrote: > > Hi Paolo, > > > If it's not something in this sense, i would ask you to turn > > on debugging on one of the two plugins (debug[inbound]: true > > for example) and check what SQL queries are causing such > > duplication. If it's not too much sensible data, you can > > let me have a look aswell at the debug log by sending it > > privately. > > I'd turn up debug, ca I make ist more verbose, I'll think this is not so > helping: > > Aug 6 17:21:53 traffic pmacctd[19363]: INFO ( default/core ): Start logging > ... > Aug 6 17:21:53 traffic pmacctd[19363]: INFO ( inbound/mysql ): Pipe size > obtained: 110592 / 4000. > Aug 6 17:21:53 traffic pmacctd[19365]: DEBUG ( /etc/pmacct/networks ): > (networks table IPv4) AS: 0, net: 54260000, mask: ffff0000 > Aug 6 17:21:53 traffic pmacctd[19365]: DEBUG ( /etc/pmacct/networks ): > (networks table IPv4) AS: 0, net: c32a7200, mask: ffffff00 > Aug 6 17:21:53 traffic pmacctd[19365]: DEBUG ( /etc/pmacct/networks ): > (networks table IPv4) AS: 0, net: c32a7300, mask: ffffff00 > Aug 6 17:21:53 traffic pmacctd[19365]: DEBUG ( /etc/pmacct/networks ): IPv4 > Networks Cache successfully created: 99991 entries. > Aug 6 17:21:53 traffic pmacctd[19365]: DEBUG ( /etc/pmacct/networks ): > (networks table IPv6) AS: 0, net: 0:0:0:0, mask: 0:0:0:0 > Aug 6 17:21:53 traffic pmacctd[19365]: DEBUG ( /etc/pmacct/networks ): IPv6 > Networks Cache successfully created: 32771 entries. > Aug 6 17:21:53 traffic pmacctd[19363]: OK ( default/core ): link type is: 1 > Aug 6 17:25:06 traffic pmacctd[19372]: ( inbound/mysql ) *** Purging cache - > START *** > Aug 6 17:25:06 traffic pmacctd[19372]: DEBUG ( inbound/mysql ): 1933 VALUES > statements sent to the MySQL server. > Aug 6 17:25:06 traffic pmacctd[19372]: ( inbound/mysql ) *** Purging cache - > END (QN: 1934, ET: 0) *** > Aug 6 17:30:06 traffic pmacctd[19800]: ( inbound/mysql ) *** Purging cache - > START *** > Aug 6 17:30:06 traffic pmacctd[19800]: DEBUG ( inbound/mysql ): 1976 VALUES > statements sent to the MySQL server. > Aug 6 17:30:06 traffic pmacctd[19800]: ERROR ( inbound/mysql ): Duplicate > entry '2009-08-06 17:25:00-0.0.0.0' for key 1#012 > Aug 6 17:30:06 traffic pmacctd[19800]: ( inbound/mysql ) *** Purging cache - > END (QN: 1977, ET: 0) *** > Aug 6 17:30:11 traffic pmacctd[19801]: ERROR ( outbound/mysql ): Duplicate > entry '2009-08-06 17:25:00-0.0.0.0' for key 1#012 > > > greetings > > Johannes _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists