[pmacct-discussion] Strange SQL-Error

2009-04-13 Thread Johannes Formann
Hello, I'll get this kind of error: Apr 13 15:27:15 server pmacctd[1341]: ERROR ( default/mysql ): Duplicate entry '0-00:1c:c0:74:5b:e9-00:00:0c:07:ac:6a-0-84.38.64.216-79.221.203.' for key 1 Apr 13 15:27:15 server kernel: pmacctd[1341]: segfault at f7002991 ip f7bfa9ca sp

Re: [pmacct-discussion] Strange SQL-Error

2009-04-13 Thread Johannes Formann
Hello, I'll get this kind of error: Apr 13 15:27:15 server pmacctd[1341]: ERROR ( default/mysql ): Duplicate entry '0-00:1c:c0:74:5b:e9-00:00:0c:07:ac:6a-0-84.38.64.216-79.221.203.' for key 1 I get this as well. It means that the primary key is not long enough to make the records

Re: [pmacct-discussion] Strange SQL-Error

2009-04-13 Thread Chris Wilson
Hi Johannes, On Mon, 13 Apr 2009, Johannes Formann wrote: Apr 13 15:27:15 server kernel: pmacctd[1341]: segfault at f7002991 ip f7bfa9ca sp ffb88334 error 4 in libpthread-2.3.6.so[f7bf2000+e000] I think I got it (using a written coredump): Yes, that's it, thanks. I'm

Re: [pmacct-discussion] Strange SQL-Error

2009-04-13 Thread Chris Wilson
Hi Johannes, On Mon, 13 Apr 2009, Johannes Formann wrote: I'm not sure why flows is in your aggregate set since flows are already aggregated into flows in all cases by pmacctd, as far as I know (please correct me if I'm wrong). flow isn't in the primary key. I didn't say it was, but it

Re: [pmacct-discussion] Strange SQL-Error

2009-04-13 Thread Johannes Formann
Chris Wilson ch...@aptivate.org wrote: On Mon, 13 Apr 2009, Johannes Formann wrote: Hi Chris, Apr 13 15:27:15 server kernel: pmacctd[1341]: segfault at f7002991 ip f7bfa9ca sp ffb88334 error 4 in libpthread-2.3.6.so[f7bf2000+e000] I think I got it (using a written

Re: [pmacct-discussion] Strange SQL-Error

2009-04-13 Thread Chris Wilson
Hi Johannes, On Mon, 13 Apr 2009, Johannes Formann wrote: Paolo, this looks weird to me. pthread_getspecific() should not crash, that makes me think that the heap has been trashed (stack looks generally OK as the backtrace is OK). Perhaps a Valgrind is in order? Any static or fixed-size

Re: [pmacct-discussion] Strange SQL-Error

2009-04-13 Thread Johannes Formann
Johannes Formann mlm...@formann.de wrote: Hello, I'll get this kind of error: Apr 13 15:27:15 server pmacctd[1341]: ERROR ( default/mysql ): Duplicate entry '0-00:1c:c0:74:5b:e9-00:00:0c:07:ac:6a-0-84.38.64.216-79.221.203.' for key 1 Apr 13 15:27:15 server kernel: pmacctd[1341]: segfault

Re: [pmacct-discussion] Strange SQL-Error

2009-04-13 Thread Johannes Formann
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?

Re: [pmacct-discussion] Strange SQL-Error

2009-04-13 Thread Chris Wilson
Hi Johannes, On Mon, 13 Apr 2009, Johannes Formann wrote: 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?

Re: [pmacct-discussion] Strange SQL-Error

2009-04-13 Thread Paolo Lucente
Hi Johannes, Chris, Thanks to the both of you for progressing troubleshooting of the problem. A lot of interesting elements are already there but there is something not clear yet about the nature of this issue: * The SEGV appears to be in a pthread_getspecific() call while the MySQL plugin

Re: [pmacct-discussion] Strange SQL-Error

2009-04-13 Thread Johannes Formann
Paolo Lucente pa...@pmacct.net wrote: Hi Paolo, * The SEGV appears to be in a pthread_getspecific() call while the MySQL plugin does not do any pthread-related call. Also a simple inet_ntoa() should not do that. Did you by any chance compile the package with the --enable-threads