"ls -l" results for the file. -rwxrwxrwx 1 mysql mysql 5863636992 Feb 19 05:20 TBL_FORUM_MSG_BODY.ibd
Tried su to mysql user. able to cat the above file. "lsattr" results for the file. ------------- TBL_FORUM_MSG_BODY.ibd Hope that helps. Regards, Rithish. -----Original Message----- From: Ady Wicaksono [mailto:[EMAIL PROTECTED] Sent: Thursday, February 23, 2006 5:50 PM To: Logan, David (SST - Adelaide) Cc: Rithish Saralaya; MySQL general mailing list Subject: Re: error 1016 : cant open ibd file even though it exists Try to help Please give us the "ls -l" result of this file, also make sure that the owner of mysql process could read this file how to test? Try to "su" to mysql user, and try to open the file, using "cat" or other command If you can't, maybe parent directory is not permitted this user to read , then fix it Please also give us "lsattr" result of this file, maybe file attribute not permitt mysql user to read this file Good luck Logan, David (SST - Adelaide) wrote: >Hi Rithish, > >I'm all out of ideas with this one, sorry I can't be of more help. >Perhaps Mr Tuuri or others with more nouse than myself can help. > >Regards > > > >--------------------------------------------------------------- >********** _/ ********** David Logan >******* _/ ******* ITO Delivery Specialist - Database >***** _/ ***** Hewlett-Packard Australia Ltd >**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED] >**** _/ _/ _/ _/ **** Desk: +618 8408 4273 >**** _/ _/ _/_/_/ **** Mobile: 0417 268 665 >***** _/ ****** >****** _/ ******** Postal: 148 Frome Street, >******** _/ ********** Adelaide SA 5001 > Australia >i n v e n t >--------------------------------------------------------------- > >-----Original Message----- >From: Rithish Saralaya [mailto:[EMAIL PROTECTED] >Sent: Thursday, 23 February 2006 5:02 PM >To: Logan, David (SST - Adelaide); MySQL general mailing list >Subject: RE: error 1016 : cant open ibd file even though it exists > >Hello David. Thanks for the prompt response. > >The permissions were the first thing that I checked when I got the >error. In >fact, I even tried giving 777 permissions on the .ibd files. No results. > >Regards, >Rithish. > > >-----Original Message----- >From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] >Sent: Thursday, February 23, 2006 10:42 AM >To: Rithish Saralaya; MySQL general mailing list >Subject: RE: error 1016 : cant open ibd file even though it exists > > >Hi Rithish, > >Please check your ownership/permissions > >hambone ~ $ perror 1 >OS error code 1: Not owner >hambone ~ $ > >Regards > > > >--------------------------------------------------------------- >********** _/ ********** David Logan >******* _/ ******* ITO Delivery Specialist - Database >***** _/ ***** Hewlett-Packard Australia Ltd >**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED] >**** _/ _/ _/ _/ **** Desk: +618 8408 4273 >**** _/ _/ _/_/_/ **** Mobile: 0417 268 665 >***** _/ ****** >****** _/ ******** Postal: 148 Frome Street, >******** _/ ********** Adelaide SA 5001 > Australia >i n v e n t >--------------------------------------------------------------- > >-----Original Message----- >From: Rithish Saralaya [mailto:[EMAIL PROTECTED] >Sent: Thursday, 23 February 2006 3:43 PM >To: MySQL general mailing list >Subject: error 1016 : cant open ibd file even though it exists > >Hello. > >I get the following error when I try to query a table in a particular >database (test). The error is generated for all tables within that >database. >However, 'mysql' database works fine. > >ERROR 1016 (HY000): Can't open file: 'TBL_FORUM_MSG_BODY.ibd' (errno: 1) > >However, I have noticed that both the .frm and the .ibd file exists for >the >table TBL_FORUM_MSG_BODY. Then why the error? I looked into the error >log >and it is as follows > >060222 15:14:09 InnoDB error: >Cannot find table test/TBL_FORUM_MSG_BODY from the internal data >dictionary >of InnoDB though the .frm file for the table exists. Maybe you >have deleted and recreated InnoDB data files but have forgotten >to delete the corresponding .frm files of InnoDB tables, or you >have moved .frm files to another database? >Look from section 15.1 of http://www.innodb.com/ibman.html >how you can resolve the problem. >060222 15:14:09 [ERROR] /usr/sbin/mysqld: Can't open file: >'TBL_FORUM_MSG_BODY.ibd' (errno: 1) > > >I tried restarting MySQL service in the hope that INNoDB will recognise >the >files properly, but to no avail. Is there a way to find and correct what >has >gone wrong? Someone please say 'yes'... > >I am on MySQL 4.1.11 with InnoDB as the storage engine and with >per-table >tablespace. > >Regards, >Rithish. > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
