>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