>Description: Replication halts on drop of ignored, temporary table >How-To-Repeat: [mysqld] replicate-ignore-table=curioscape.avstemp replicate-ignore-table=tias.avtemp replicate-ignore-table=inventory.availableQuantity replicate-ignore-table=inventory.thisItem replicate-ignore-table=inventory.auctionStatus replicate-ignore-table=inventory.itemTable replicate-ignore-table=orders.grossDemand replicate-ignore-table=orders.netDemand replicate-ignore-table=lionbrand.shippableOrders replicate-ignore-table=orders.shippedItems replicate-ignore-table=inventory.top_levels replicate-ignore-table=inventory.systemCatList replicate-ignore-table=inventory.itemTotals replicate-wild-ignore-table=tums.% replicate-wild-ignore-table=stats.% master-host=db1.tias.com master-user=slave master-password=[removed] log=db.log # master-port= server-id=2
mysql> show slave status; +--------------+-------------+-------------+---------------+---------------+----------+---------------+-----------------+---------------------+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +--------------+-------------+-------------+---------------+---------------+----------+---------------+-----------------+---------------------+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+ | db1.tias.com | slave | 3306 | 60 | spode-bin.259 | 53260121 | No | | | 1158 | Slave: query 'drop table lionbrand.shippableOrders,orders.netDemand,orders.grossDemand' partially completed on the master and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START; | 0 I looked up error 1158 in docs/mysqld_error.txt and its: #define ER_NET_READ_ERROR 1158 "Got an error reading communication packets", which doesn't look like an appropriateerror to ignore. But why is it even worrying about this when the request is to drop 3 temporary tables that are being ignored anyway? >Fix: >Submitter-Id: <submitter ID> >Originator: Mike Wexler >Organization: TIAS.COM >MySQL support: extended login support >Synopsis: replication stops when it shouldn't >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug | support >Release: mysql-3.23.49a (Official MySQL RPM) >Environment: System: Linux walker.tias.com 2.2.19-7.0.8enterprise #1 SMP Thu Jun 21 06:00:20 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/mh/perl /usr/bin/mh/make /usr/bin/mh/gmake /usr/bin/mh/gcc /usr/bin/mh/cc GCC: Reading specs from /usr/bin/mh/../lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-85) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Feb 8 21:18 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x 1 root root 5808375 Dec 8 07:04 /lib/libc-2.2.4.so -rw-r--r-- 1 root root 27315960 Dec 8 07:02 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Dec 8 07:02 /usr/lib/libc.so lrwxrwxrwx 1 root root 10 Sep 18 01:58 /usr/lib/libc-client.a -> c-client.a Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' CXX=gcc --------------------------------------------------------------------- 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