From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: REPLICATION BUG
>Description:
The bug manifests itself in the following situation. A temporary
table has been created on the master server. A query is executed
using an alias for that temporary table. The connection is dropped
without explicitly dropping that temporary table. In the binary log,
mysql records a drop of the temporary table using the table alias.
When the replication server reads this command, it is unaware of a
table of this name and replication is dropped.
>How-To-Repeat:
# Perl code sample
#!/usr/local/bin/perl5 -w
use DBI;
my $dbh = DBI->connect("DBI:mysql:DBNAME:DBHOST:DBPORT", "User",
"Password");
$dbh->do("CREATE TEMPORARY TABLE tmpTableBug(tempField int not null)");
$dbh->do("SELECT TableAlias.tempField FROM tmpTableBug AS TableAlias");
$dbh->do("CREATE TEMPORARY TABLE tmpTableOk(tempField int not null)");
$dbh->do("SELECT tempField FROM tmpTableOk");
$dbh->disconnect;
# Server will log "drop table APES.tmpTableOk,APES.TableAlias;"
>Fix:
Explicitly drop temporary table
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: none
>Synopsis: TEMPORARY TABLE DROP causes disconnect of replication slave.
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.41 (Source distribution)
>Environment:
System: SunOS flotsam 5.8 Generic_108528-08 sun4u sparc SUNW,Ultra-4
Architecture: sun4
Some paths: /bin/perl /usr/local/bin/make /usr/local/bin/gcc
/opt/SUNWspro.5.0/SC5.0/bin/cc
GCC: Reading specs from
/usr/local/gcc-2.95.2-sl/lib/gcc-lib/sparc-sun-solaris2.6/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='/usr/local/gcc-2.95.2-sl/bin/gcc
-R/usr/local/gcc-2.95.2-sl/lib' CFLAGS=''
CXX='/usr/local/gcc-2.95.2-sl/bin/g++ -R/usr/local/gcc-2.95.2-sl/lib'
CXXFLAGS='' LDFLAGS=''
LIBC:
-rw-r--r-- 1 root bin 1759264 Jun 29 2001 /lib/libc.a
lrwxrwxrwx 1 root root 11 Aug 22 20:13 /lib/libc.so ->
./libc.so.1
-rwxr-xr-x 1 root bin 1136692 Jun 29 2001 /lib/libc.so.1
-rw-r--r-- 1 root bin 1759264 Jun 29 2001 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Aug 22 20:13 /usr/lib/libc.so ->
./libc.so.1
-rwxr-xr-x 1 root bin 1136692 Jun 29 2001 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/unique/apps/mysql-3.23.41
--with-innodb --without-docs
Perl: This is perl, version 5.005_03 built for sun4-solaris
---------------------------------------------------------------------
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
