>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-server-suffix= --enable-thread-safe-client --enable-local-infile
--enable-assembler --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
