Hi!
Just an update to this thread: the replication
failure of auto-inc columns has probably been
traced. Replication assumes that auto-inc
values for a multiline insert or
INSERT INTO ... SELECT ... are assigned strictly
consecutively, while InnoDB assigns them in parallel.
A symptom of the bug is that you get a duplicate
key error in the slave. A similar failure can happen
in a roll-forward recovery using the binlog.
This is fixed in 3.23.43, due out next week.
Regards,
Heikki Tuuri
http://www.innodb.com
(database sql)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
