>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
