>Description:
A slave replication only one of many databases from a master
will fail with a "error 'Can't read dir of './otherdb/' (Errcode: 2)
on query 'DROP DATABASE otherdb' if the slave was not replicating
that database.
>How-To-Repeat:
Create a master with 2 databases (gooddb & otherdb).
Setup replication, allowing both databases to be replicated.
Create a slave to replicate from the master with the line
"replicate-do-db=gooddb" in my.cnf.
After all is up and running on the master do a "DROP DATABASE otherdb"
The slave will get the above error, even though it wasn't repicating
that database it will try and remove the directory.
>Fix:
>Submitter-Id: <submitter ID>
>Originator: James Housley
>Organization:
>MySQL support: none
>Synopsis: DROPing DATABASE can halt a replication slave.
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.49 (FreeBSD port: mysql-server-3.23.49)
>Server: /usr/local/bin/mysqladmin Ver 8.23 Distrib 3.23.49, for portbld-freebsd4.4
>on i386
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.49-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 9 days 7 hours 59 min 22 sec
Threads: 2 Questions: 11134282 Slow queries: 53 Opens: 784 Flush tables: 1 Open
tables: 256 Queries per second avg: 13.808
>Environment:
System: FreeBSD dt4-sfo.downloadtech.net 4.4-STABLE FreeBSD 4.4-STABLE #0: Sat Nov 24
13:02:08 PST 2001 [EMAIL PROTECTED]:/usr/src/sys/compile/DG 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.3 20010315 (release) [FreeBSD]
Compilation info: CC='cc' CFLAGS='-O -pipe ' CXX='cc' CXXFLAGS='-O -pipe
-felide-constructors -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1205812 Nov 24 13:55 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 9 Nov 24 13:55 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 573100 Nov 24 13:55 /usr/lib/libc.so.4
Configure command: ./configure --localstatedir=/var/db/mysql --without-perl
--without-debug --without-readline --without-bench --with-mit-threads=no
--with-libwrap --with-low-memory '--with-comment=FreeBSD port: mysql-server-3.23.49'
--enable-assembler --with-berkeley-db --with-innodb --with-mysqld-ldflags=--static
--prefix=/usr/local i386-portbld-freebsd4.4
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
