Bogdan TARU <[EMAIL PROTECTED]> wrote:
>
> Read the bug report, but couldn't find if the problem was fixed in 4.0.14
> or not...
>
Yes, it's fixed.
http://www.mysql.com/doc/en/News-4.0.14.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is s
Hi Victoria,
Read the bug report, but couldn't find if the problem was fixed in 4.0.14
or not...
bogdan
iCom Media AG
Kirchweg 36
Koln, 50858
Germany
Phone: +49-(0)221-485-689-16
Fax : +49-(0)221-485-689-20
Mobile:+49-(0)173-269-76-62
On Wed, 17 Sep 2
Bogdan TARU <[EMAIL PROTECTED]> wrote:
>
> So, back to the problems with auto_increment columns and replication
> problems. I have noticed this problem always occures when using INSERT
> SELECT syntax with an auto_increment key
>
> simple example:
>
> CREATE TABLE test1 (value INT);
> INSERT INT
Hi everyone,
So, back to the problems with auto_increment columns and replication
problems. I have noticed this problem always occures when using INSERT
SELECT syntax with an auto_increment key
simple example:
CREATE TABLE test1 (value INT);
INSERT INTO test1 SET value=1;
INSERT INTO t
IL PROTECTED]>
Sent: Friday, August 15, 2003 1:04 PM
Subject: Re: replication blues
> "Primaria Falticeni SDU" <[EMAIL PROTECTED]> wrote:
> > I met the same problem
>
> Problem with auto_increment column?
> If so I wasn't able to repeat it with master_co
gt; Iulian
> - Original Message -
> From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, August 12, 2003 9:49 PM
> Subject: Re: replication blues
>
>
>> Bogdan TARU <[EMAIL PROTECTED]> wrote:
>>
Hi guys,
I've got a weirdo problem with replicating a database. Sometimes I get
some duplicate keys problems for _only_ one table. There is nothing
special about this table, it looks like:
+--+--+--+-+-++
| Fiel
then. I mean conflicts
from the late of the update slave <- master.
Iulian
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 12, 2003 9:49 PM
Subject: Re: replication blues
> Bogdan TARU <[E
Bogdan TARU <[EMAIL PROTECTED]> wrote:
> And data is inserted into it with simple inserts, w/o specifing the id
> (it's autoincrementing).
>
> With a little debugging, I have located the problem. If I run 'alter
> table xxx auto_increment=1' on both the master and the slave (this table
> is empty