Re: Question: Create table fails after switch from 4.0.18-4.1.10

[Noah White]

Heikki,

I dropped the database and checked that the directory was removed from the mySQL Data directory, which it was.

I re-ran the table creation statements and got the same error. When I checked the appropriate data directory I saw the .frm files for the tables which had been made but the table is question did not have one there.

Looking at the log file (.err file in the Data directory) did not shed any light either. I've attached the log file below. As you can see there's nothing in there which looks relevant.

The only exception I get is through the driver:

2005-02-22 14:51:00,534 [TP-Processor2] ERROR com.wonka.setup.MySqlServerSetup - processSqlFile: SQL error:
java.sql.SQLException: Can't create table '.\test_vs\vir_label_set_fields.frm' (errno: 121)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)

Looking in test_vs's data directory I do not see the vir_label_set_fields.frm file so there's nothing in the way or being created. There are .frm files for the other two tables which this one references. So those are in place beforehand which is good.

Again this all worked fine under 4.0.18 w/J-connector 3.0.7 stable.

Any other thoughts to try? Thanks,

-Noah


Log file -

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
050221 12:29:59 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
050221 12:29:59 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
050221 12:30:00 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
050221 12:30:09 InnoDB: Started; log sequence number 0 0
C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for connections.
Version: '4.1.10-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
050221 15:46:10 [Note] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Normal shutdown

050221 15:46:11 InnoDB: Starting shutdown...
050221 15:46:50 InnoDB: Started; log sequence number 0 43634
C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for connections.
Version: '4.1.10-nt' socket: '' port: 3306 MySQL Community Edition (GPL