Yes, thats what I am concern about. But, I am trying reproduce the senerio.
Thanks for the great help. If I possibly be able to reporduce the error
I'll surely open a bug for the same.
--
Thanks and Regards,
Manasi Save
>
> On Oct 27, 2009, at 09:45 , Manasi Save wrote:
> ..
>> For Example:- Right now on Node A auto_increment for table Customer is
>> 54662 and on Node B it is 54689.
>> It is tryin to insert record for ID 54650 which is already exists. Why
>> this is happening I have no clue.
>
>
> You're really using auto_increment? I mean, the application is not
> getting the MAX(id) from the table and uses that?
>
> If you can setup a simple test case with 1 data node, 2 sql nodes and
> reproduce this. Open a bug report.
> The above should not happen (I mean, inserting records with IDs under
> the auto_inc value)
>
> Cheers,
> Geert
>
> --
> Geert Vanderkelen, MySQL Senior Support Engineer
> Sun Microsystems GmbH Sonnenallee 1, D-85551 Kirchheim-Heimstetten
>
> Geschaeftsfuehrer: Thomas Schröder, Wolfgang Engels, Wolf Frenkel
> Vorsitz d. Aufs.rat.: Martin Haering HRB MUC 161028
>
>
>
>
