Snort Forums Archive

Archive Home » Snort Advanced » Duplicate database entry error when using Snort with MySQL clustering

Please note that the categories listed below represent an archived version of our forums pages. To view the current version and be able to post and reply to threads, please register and login here to go to the full forums pages.

[ Notice: Full Version of This Topic ]

Duplicate database entry error when using Snort with MySQL clustering

Posted by coolanks on April 22, 2005 14:59:28

Hi I am working on a project where we are using MySQL clustering and Snort is logging to one of the clustered databases. I am not using ACID. I am getting the duplicate database entry error messages every time I start Snort. Somehow the CID never starts with the last highest value but starts from 1 . But Snort works well when logging to a non-clustered database. Could you help me out?

Posted by chris on May 15, 2005 12:50:38

HI coolanks, I'm not sure if this report is related to your error, but I found there has a been a bug filed with mySql Dev, the auto increment counter seems to get a bit confused sometimes and gives a diplicate error warning, check out this page, maybe it applies to your situation ?

http://lists.mysql.com/cluster/1855.

This is in respones to another post regarding a duplicate entry error, here
http://lists.mysql.com/cluster/1875
The suggestion, is that a workaround maybe to use myISAM engine instead of the ndbcluster.
perhaps this might also be a possible avenue for you.
hope this helps
chris.