Johannes Formann <mlm...@formann.de> wrote: Hi Chris,
> >> Apr 13 17:20:01 server1 pmacctd[12419]: ERROR ( default/mysql ): > >> Duplicate entry > >> '0-00:1b:8f:61:55:c9-00:1c:c0:ab:8a:48-0-91.22.172.35-84.38.74.24' for > >> key 1 > > > > As this crash is so early, perhaps the thread isn't initialised properly? > > Well, the first update (into the complet empty table) was successfull, > and I think that has used the same kid of thread. I have now a guess whre the "duplicated" keys error come from: Assume the updates are done at :30 with sql_history_roundoff: 1h and sql_refresh_time: 3600 (1h) (so long for simplifikation) at 0:30 for each recorded flow a row is inserted with the timestamp 0:00 at 1:30 for log flow a row is inserted for 0:00 and 1:00 ... at least if I understood the dokumentation right, that makes the error, since to identical inserts should be done... greetings Johannes _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists