Re: replication blues

2003-09-18 Thread Victoria Reznichenko
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

Re: replication blues

2003-09-18 Thread Bogdan TARU
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

Re: replication blues

2003-09-17 Thread Victoria Reznichenko
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

replication blues

2003-09-09 Thread Bogdan TARU
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

Re: replication blues

2003-08-18 Thread Primaria Falticeni SDU
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

Re: replication blues

2003-08-15 Thread Victoria Reznichenko
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: >>

replication blues

2003-08-14 Thread Bogdan TARU
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

Re: replication blues

2003-08-14 Thread Primaria Falticeni SDU
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

Re: replication blues

2003-08-14 Thread Victoria Reznichenko
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