Hi! At 05:19 PM 11/25/01 -0500, you wrote: >I think your diagnosis is correct. There is an FRM without a corresponding >InnoDB table. The question is, what causes this, and how do we prevent it?
Brent thinks the problem was a third-party software which crashed the server. >It appears to be a bug related to CREATE TABLE and DROP TABLE. I have found >it a good idea to commit and reconnect after creating an InnoDB table. > >Erik Regards, Heikki http://www.innodb.com -- Order commercial MySQL/InnoDB support at https://order.mysql.com/ >-----Original Message----- >From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, October 17, 2001 2:20 AM >To: [EMAIL PROTECTED] >Subject: Re: Need to repair InnoDb tables > > >Brent, > >maybe you have moved .frm files around? > >If there is an orphaned .frm file for a table >without a corresponding table inside InnoDB >data files you get the following errors: > >mysql> show tables; >+-----------------+ >| Tables_in_test2 | >+-----------------+ >| fare | >+-----------------+ >1 row in set (0.34 sec) > >mysql> describe fare; >ERROR 1016: Can't open file: 'fare.InnoDB'. (errno: 1) >mysql> drop table fare; >ERROR 1051: Unknown table 'fare' >mysql> > >and in the MySQL error log you get: > >011017 9:11:52 InnoDB: Started >mysqld: ready for connections >InnoDB: Cannot find table test2/fare from the internal data dictionary >InnoDB: of InnoDB though the .frm file for the table exists. Maybe you >InnoDB: have deleted and recreated InnoDB data files but have forgotten >InnoDB: to delete the corresponding .frm files of InnoDB tables? >InnoDB: Error: table test2/fare does not exist in the InnoDB internal >InnoDB: data dictionary though MySQL is trying to drop it. >InnoDB: Have you copied the .frm file of the table to the >InnoDB: MySQL database directory from another database? > >The way to fix the problem is to delete the .frm file >from the MySQL database directory in question. > >Regards, > >Heikki >http://www.innodb.com/ibman.html > >>In my sample database, all of the tables are InnoDb. For some reason 2 of >>the tables can no longer be accessed. I keep getting error 1016. >> >>1) Where can I find a list of error codes and their meanings? >>2) How do I fix an InnoDb table? >> >>TIA >> >>Brent >> >>mysql> show tables; >>+-------------------+ >>| Tables_in_isample | >>+-------------------+ >>| absence | >>| event | >>| member | >>| president | >>| score | >>| student | >>+-------------------+ >>6 rows in set (0.00 sec) >> >>mysql> describe absence; >>ERROR 1016: Can't open file: 'absence.InnoDB'. (errno: 1) >>mysql> describe president; >>ERROR 1016: Can't open file: 'president.InnoDB'. (errno: 1) >>mysql> select * from absence; >>ERROR 1016: Can't open file: 'absence.InnoDB'. (errno: 1) >>mysql> select * from president; >>ERROR 1016: Can't open file: 'president.InnoDB'. (errno: 1) >>mysql> drop table president; >>ERROR 1051: Unknown table 'president' >>mysql> drop table absence; >>ERROR 1051: Unknown table 'absence' >>mysql> >> > > > >--------------------------------------------------------------------- >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 > > --------------------------------------------------------------------- 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
