List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:July 18 2002 11:08pm
Subject:Re: Replication in v4.0.2 not doing UPDATE
View as plain text  

Please provide more details. Does the problem happen also if you replicate
all tables, not just use the replicate-do-table directive?

What is the table definition like (print SHOW CREATE TABLE in the master as
well as slave)? Does it have foreign key constraints? Give an example of an
UPDATE statement which does not succeed. If you execute the UPDATE manually
on the slave, does it succeed then?

Best regards,

Heikki Tuuri
Innobase Oy
Order technical MySQL/InnoDB support at
See for the online manual and latest news on InnoDB

----- Original Message -----
From: "MySQL admin account" <mysql@stripped>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 18, 2002 9:20 PM
Subject: Replication in v4.0.2 not doing UPDATE

> >Description:
>         I am using MySQL v4.0.2 and I have set up a master database and 2
>         databases, all on separate Solaris machines. The replication works
>         when I INSERT or DELETE but does not perform my UPDATE statements.
I have
>         used 'mysqlbinlog' on the relay log on one of the slaves and the
>         statements are being sent to the slaves but they are not being
>         No errors have been generated to the error log and no errors are
shown when
>         a SHOW SLAVE STATUS is run. The slaves use replicate-do-table
directives in
>         the config file but the tables that I am trying to update are
listed and
>         I can INSERT into and DELETE from these tables that I am trying to
>         The UPDATE succeeds on the master. All of my tables are INNODB
> >How-To-Repeat:
>         When I run an UPDATE statement on my master database on replicated
>         it is not replicated to the slaves (even though the statement is
>         to the relay log on the slave servers).
> >Fix:
>         Unknown
> >Submitter-Id: miguelryan
> >Originator: MySQL admin account
> >Organization:  freelance consultant
> >MySQL support: none
> >Synopsis: Replication in v4.0.2 not doing UPDATE
> >Severity: critical
> >Priority: high
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-4.0.2-alpha (Source distribution)
> >Environment:
> System: SunOS ops-dev5 5.6 Generic_105181-28 sun4u sparc
> Architecture: sun4
> Some paths:  /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc
> GCC: Reading specs from
> gcc version 2.95.3 20010315 (release)
> Compilation info: CC='gcc'  CFLAGS='-O3 -fno-omit-frame-pointer'

CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -
fno-rtti'  LDFLAGS=''
> -rw-r--r--   1 bin      bin      1623504 Aug 24  2001 /lib/libc.a
> lrwxrwxrwx   1 root     root          11 Feb  9  2000 /lib/ ->
> -rwxr-xr-x   1 bin      bin      1024888 Aug 24  2001 /lib/
> -rw-r--r--   1 bin      bin      1623504 Aug 24  2001 /usr/lib/libc.a
> lrwxrwxrwx   1 root     root          11 Feb  9  2000 /usr/lib/ ->
> -rwxr-xr-x   1 bin      bin      1024888 Aug 24  2001 /usr/lib/
> Configure command:
./configure --prefix=/usr/local/mysql --with-extra-charsets=complex --with-s
erver-suffix= --enable-thread-safe-client --enable-local-infile --enable-ass
embler --disable-shared --with-innodb CC=gcc
'CFLAGS=-O3 -fno-omit-frame-pointer'
'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -
fno-rtti' CXX=gcc
> Perl: This is perl, version 5.005_03 built for sun4-solaris
> ---------------------------------------------------------------------
> Before posting, please check:
>   (the manual)
>           (the list archive)
> To request this thread, e-mail <mysql-thread114983@stripped>
> To unsubscribe, e-mail
> Trouble unsubscribing? Try:

Replication in v4.0.2 not doing UPDATEMySQL admin account18 Jul
Re: Replication in v4.0.2 not doing UPDATEHeikki Tuuri19 Jul