Hi all, I always get a lot of errors like this when using pmacct on a MySQL database:
Oct 2 06:26:01 fen-fw pmacctd[16237]: ERROR ( default/mysql ): Duplicate entry '0----0-0-0-217.160.76.21-10.0.156.226-4949-33730-tcp-0-2008-10-0' for key 1 Oct 2 06:26:01 fen-fw pmacctd[16239]: ERROR ( default/mysql ): Duplicate entry '0----0-0-0-217.160.76.21-10.0.156.226-4949-33730-tcp-0-2008-10-0' for key 1 (I didn't paste that line twice, there really are two identical lines in the log). After I delete the primary key, I get duplicate rows in the database, like this: mysql> select ip_src,ip_dst,src_port,dst_port,stamp_inserted from acct_v6 where ip_src="10.0.156.1" and ip_dst="10.0.156.210" and src_port=53 and dst_port=56556 and stamp_inserted="2008-10-02 10:43:00"; +------------+--------------+----------+----------+---------------------+ | ip_src | ip_dst | src_port | dst_port | stamp_inserted | +------------+--------------+----------+----------+---------------------+ | 10.0.156.1 | 10.0.156.210 | 53 | 56556 | 2008-10-02 10:43:00 | | 10.0.156.1 | 10.0.156.210 | 53 | 56556 | 2008-10-02 10:43:00 | | 10.0.156.1 | 10.0.156.210 | 53 | 56556 | 2008-10-02 10:43:00 | +------------+--------------+----------+----------+---------------------+ 3 rows in set (0.00 sec) (I've omitted the other columns, but they really are all identical). The configuration is: aggregate: src_host, src_port, dst_host, dst_port, proto sql_history: 1m sql_history_roundoff: m sql_table_version: 6 sql_refresh_time: 60 sql_multi_values: 1024000 sql_dont_try_update: true sql_optimize_clauses: true Does anyone have any ideas about what might cause this? I'm using pmacct 0.9.1 on this server. I know it's old, but it's what comes with Ubuntu Dapper. Cheers, Chris. -- Aptivate | http://www.aptivate.org | Phone: +44 1223 760887 The Humanitarian Centre, Fenner's, Gresham Road, Cambridge CB1 2ES Aptivate is a not-for-profit company registered in England and Wales with company number 04980791. _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists