From: Doug Sisk
Date: March 22 1999 9:23pm
Subject: Can't drop tables!
List-Archive: http://lists.mysql.com/mysql/802
Message-Id: <36F6B4D9.D7459E25@lucent.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


>Description:
        Can't drop tables!
>How-To-Repeat:
        mysql> create table t (I int(4), S varchar(20));
        Query OK, 0 rows affected (0.01 sec)

        mysql> drop table t;
        ERROR 2000: Unknown table 't'
        mysql> Bye                                            
>Fix:
        Work around by shutting down mysqld and removing files. Not
        good for temporary tables though.

>Submitter-Id:  <submitter ID>
>Originator:    
>Organization:
 Lucent Technologies
>MySQL support: email support
>Synopsis:      Can't drop tables
>Severity:      serious
>Priority:      medium
>Category:      mysql
>Class:         
>Release:       mysql-3.22.20a (Source distribution)
>Server: /usr/bin/mysqladmin  Ver 7.8 Distrib 3.22.20a, for pc-linux-gnu on i686
TCX Datakonsult AB, by Monty

Server version          3.22.20a-log
Protocol version        9
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 10 min 20 sec

Threads: 1  Questions: 40  Slow queries: 0  Opens: 30  Flush tables: 1 
Open tables: 26
>Environment:
        
System: Linux neade5 2.2.3 #6 Sat Mar 20 10:00:28 EST 1999 i586 unknown
Architecture: i586

Some paths:  /usr/local/bin/perl /usr/bin/make /usr/bin/gmake
/usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.7.2.3/specs
gcc version 2.7.2.3
Compilation info: CC='egcs'  CFLAGS='-O6 -mpentium
-fomit-frame-pointer'  CXX='egcs'  CXXFLAGS='-O6 -mpentium
-fomit-frame-pointer               -felide-constructors  -fno-exceptions
-fno-rtti'  LDFLAGS=''
Configure command: ./configure  --without-debug --enable-shared
--enable-assembler --with-unix-socket-path=/var/lib/mysql/mysql.sock
--with-mysqld-user=mysql --prefix=/ --exec-prefix=/usr
--libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
--localstatedir=/var/lib/mysql --infodir=/usr/info
--includedir=/usr/include --mandir=/usr/man
Perl: This is perl, version 5.004_04 built for i386-linux