hello,
I have an application were rows are recorded every minute or so in bursts of
about 5-10 simultenous to a MyISAM table with AUTO_INCREMENT field. Though they
are saved in serial order (one of the other in a single row per insert) there
is very short time between each two inserts.
I am using mysql++ 1.7.40 and MySQL server and client 4.1.12.
I have noticed I am getting identical id after two different inserts.
This happen all the time, repeatedly. further more, the Id i get is an ID of
a 3rd insert happened before. (when requesting id for this insert i got the
wrong response)
I am using mysql++ Connection::insert_id() which calls mysql_insert_id().
I am invoking queries using store() or execute() getting the same effect.
any clues?
---------------------------------
All-new Yahoo! Mail - Fire up a more powerful email and get things done faster.
