Michael, > > On 5/24/10 10:22 AM, Michael Scheidell wrote: > >> Found it, and I think it has to do with INNODB, auto_increment and > >> partition tables (if you use real partition tables on maddr) > >> if you do, I suspect you will see some of those log entries below. > >> (unless you are using mysql 5.1.21 or below). > >> they MIGHT fix it in 5.1.47. > Might have fixed it. > somewhere after 5.1.40, an innodb auto_increment lock problem was resolved. > Seems if you have parallel sessions, with a multi-cpu box, (and maybe > partitioning?), you can have two sessions generate the same id. > > problem might have been introduced in 5.1.23, and fixed in 5.1.41, 42, > 43, 44, 45 46, or 47.
Glad to hear it, thanks for your investigation! Mark ------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user Please visit http://www.ijs.si/software/amavisd/ regularly For administrativa requests please send email to rainer at openantivirus dot org