>Description:
If an update is made to a master using the syntax
'INSERT INTO database.table' etc... on a mysql connection
where no 'USE database' command has been given then the updates
are written to the master binary log correctly, and update
the slave correctly. If 'log-slave-updates' is enabled on the
slave, however, the update is *not* recorded in the slave's
binary log, and thus any slaves-of-slaves do not get the update.
The same is true if a 'USE' command has been given to a database
other than the one into which the INSERT command is writing.
Everything works correctly if updates are only made to the database
which has been made current using 'USE'. The absence of the info
in the binary log means that it is only slaves-of-slaves which get out
of sync.
>How-To-Repeat:
Setup a master/salve pair with log-slave-updates enabled on the
slave. Set up a second slave replicationg from the first slave.
Connect to the master databasse withotu specifying a current
database and then make an insserts using the syntax 'database.table'
to specify the table. If you check the slave the insert will be there,
but if you check the slave-of-slave then it will not be present.
Examination of the binary logs will show that the update is not
present in the slave log file.
>Fix:
For home written code then always connecting to a specific database
willl work around the problem. Users of products such as
sql4Xmanager cannot do this, however, and thus this bug affects them
badly.
>Submitter-Id:
[EMAIL PROTECTED]
>Originator:
Pete French
>Organization:
First Call Group
>MySQL support:
none
>Synopsis:
Master updates donot get logged in slave log without current database
>Severity: serious
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.51 (Source distribution)
>Environment:
System: FreeBSD dilbert.firstcallgroup.co.uk 4.6-STABLE FreeBSD 4.6-STABLE #0: Mon Jul
22 13:06:39 BST 2002
[EMAIL PROTECTED]:/usr/obj/usr/src/sys/DILBERT i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.4 20020320 [FreeBSD]
Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1225086 Jul 22 13:48 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 9 Jul 22 13:48 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 584944 Jul 22 13:48 /usr/lib/libc.so.4
Configure command: ./configure --with-berkeley-db
Perl: This is perl, version 5.005_03 built for i386-freebsd
---------------------------------------------------------------------
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
