Hi! 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 https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB ----- Original Message ----- From: "MySQL admin account" <[EMAIL PROTECTED]> 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 slave > databases, all on separate Solaris machines. The replication works fine > 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 UPDATE > statements are being sent to the slaves but they are not being executed. > 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 update. > The UPDATE succeeds on the master. All of my tables are INNODB type. > >How-To-Repeat: > When I run an UPDATE statement on my master database on replicated tables > it is not replicated to the slaves (even though the statement is replicated > 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 SUNW,UltraSPARC-IIi-cEngine > Architecture: sun4 > > Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc > GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs > gcc version 2.95.3 20010315 (release) > Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions - fno-rtti' LDFLAGS='' > LIBC: > -rw-r--r-- 1 bin bin 1623504 Aug 24 2001 /lib/libc.a > lrwxrwxrwx 1 root root 11 Feb 9 2000 /lib/libc.so -> ./libc.so.1 > -rwxr-xr-x 1 bin bin 1024888 Aug 24 2001 /lib/libc.so.1 > -rw-r--r-- 1 bin bin 1623504 Aug 24 2001 /usr/lib/libc.a > lrwxrwxrwx 1 root root 11 Feb 9 2000 /usr/lib/libc.so -> ./libc.so.1 > -rwxr-xr-x 1 bin bin 1024888 Aug 24 2001 /usr/lib/libc.so.1 > 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: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php