>Description:
Hi!
My name is Ales Perme. A college of mine Samo Login gave me this adress, which was
given to him by Monty, to report MySQL bugs to. The first bug report today from me is
connected with replication.
Our production comprizes of Windows and Linux machines. MySQL verson we are using on
production is 3.23.36-log and on our development setting 3.23.49-nt-log. On both of
these versions we experiance the same bug.
We experiance replication problems in the following configurations:
1. Windows NT 4 (master) ----- > Windows NT 4 (slave)
2. Windows NT 4 (master) ----- > Linux (slave)
Linux to Linux and Linux to Windows works okay.
The problem is as follows:
Suppose we have a database called "Trident3-P-0", with exactly that case! We replicate
that database to the secondary with another name, with replication parameter
replicate-rewrite-db. This is a part of my.cnf file with these settings on the slave
machine:
replicate-rewrite-db=Trident3-P-0->Trident3-S-0
replicate-rewrite-db=Trident3-P-1->Trident3-S-1
replicate-rewrite-db=Trident3-P-2->Trident3-S-2
I usualy connect to MySQL server running Windows NT 4.0 with "mysql -h
master.hostname.domain -u user -ppassword" and with a USE statement change the active
database to "Trident3-P-0". Whatever I do on that databese on master now DOES NOT
replicate to slave. I trided to use all kinds of cases when changing the database on
master - no change of replication behaviour!
>Fix:
Now, I found out that if instead of using "USE" I use "\r" command then the
replication magicaly starts to work. So if I type "\r Trident3-P-0" instead of "USE
Trident3-P-0" then the replication to "Trident3-S-0" on the slave machine starts to
work.
Replication also works if I connect to the database at the time of establishing
connection with the server. So if I connect to the master server using "mysql -h
master.hostname.domain -u user -p password Trident3-P-0" then replication also works.
The problem applyes to configurations when we replicate from windows master to windows
slave or windows master to linux slave. Obviously there is a problem with the windows
version of mysql.
With best regards,
Ales Perme
IT Manager
Novifroum Ltd.
Stegne 31
Ljubljana
S L O V E N I A
>Submitter-Id: <submitter ID>
>Originator: Ales Perme
>Organization: Noviforum Ltd.
>MySQL support: none
>Synopsis: Replication problems
>Severity: critical
>>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.42 (Official MySQL binary)
>Server: /export/software/mysql/bin/mysqladmin Ver 8.21 Distrib 3.23.42, for
>pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.42-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 7 days 10 min 2 sec
Threads: 12 Questions: 133693547 Slow queries: 1244 Opens: 366 Flush tables: 13
Open tables: 90 Queries per second avg: 220.834
>Environment:
System: Linux majstr1 2.4.18 #1 SMP tor mar 19 19:43:16 CET 2002 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3
-mpentium -felide-constructors' LDFLAGS='-static'
LIBC:
lrwxrwxrwx 1 root root 13 sep 21 2001 /lib/libc.so.6 -> libc-2.2.3.so
-rwxr-xr-x 1 root root 4783716 maj 26 2001 /lib/libc-2.2.3.so
-rw-r--r-- 1 root root 24721042 maj 26 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 maj 26 2001 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-assembler
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared
---------------------------------------------------------------------
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
