weird drop innodb table with skip-innodb

Remo Tex <[email protected]> Tue, 20 Dec 2005 08:32:47 +0200
Newsgroups gmane.comp.db.mysql.bugs
Message-ID <[email protected]>
I think while some engine is not runnig DDL, DML or any other commands 
shouldn't be executed against it at all! Then how come...

System:
   Microsoft Windows 2000
   5.00.2195
   Service Pack 4
P4 2.4GHz 512Mb RAM
mysql  Ver 14.12 Distrib 5.0.17, for Win32 (ia32)
innodb_file_per_table

Simple test case:
1. start mysql with:
#skip-innodb
innodb_file_per_table
2.
mysql> create database test;
Query OK, 1 row affected (0.02 sec)
mysql> use test;
Database changed
mysql> create table customers(a int, b char(16)) Engine=INNODB;
Query OK, 0 rows affected (0.13 sec)

mysql> insert into customers Values(1, 'a1');
Query OK, 1 row affected (0.03 sec)
// actually there could be *important data* in it! table/dir ...\test:
//customers.frm
//customers.ibd
//db.opt
3. stop mysql then start with skip-innodb and reconnect
4. At this point innodb is not runnig! Try Drop some innodb table(s):
mysql> drop table test.customers;
ERROR 6 (HY000): Error on delete of '.\test\customers.MYI' (Errcode: 2)
// fires too late - customers.frm *already DELETED*

I think this *shouldn't* happen while (innodb in this case) engine is 
*NOT Running* (I know I can recreate .frm file yet... accidents happen, 
and what if I dont have that table definition at hand :()

HTH ...and still waiting for solution

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]