RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144)
Viru, have you tried looking into the MySQL errro 144 ?, you may have to issue the myisamchk with the -force option and see if that helps marcos oliva -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 6:42 PM To: Struts Users Mailing List Cc: Subject: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear All, I am very sorry to ask MySQL releted question in Struts group.. i am facing this problem since one week but couldn't able to sovle... could any one faced following error before..? while accessing table called vip_detail_tab, i m getting following error.. Can't open file: 'vip_detail_tab.MYD'. (errno: 144) i feel this table may corrupted.. expecting some ray of hope from this group..:( Regards, viru - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Can't open file: 'vip_detail_tab.MYD'. (errno: 144)
Dear Marcos, Thanks for immediate your response... Yaa, when i tried 'myisamchk -f vip_detail_tab' command, i got following error... Checking MyISAM file: /var/lib/mysql/db_slcs/vip_detail_tab Data records: 39642 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed and last repair failed - check file-size myisamchk: warning: Size of indexfile is: 1992704 Should be: 1024 - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 myisamchk: error: Can't read indexpage from filepos: -1 - recovering (with sort) MyISAM-table '/var/lib/mysql/db_slcs/vip_detail_tab.MYI' Data records: 39642 - Fixing index 1 myisamchk: Error writing file '/var/lib/mysql/db_slcs/vip_detail_tab.TMD' (Errcode: 28) myisamchk: error: 28 when writing to datafile MyISAM-table '/var/lib/mysql/db_slcs/vip_detail_tab' is not fixed because of errors Try fixing it by using the --safe-recover (-o) or the --force (-f) option with warm regards, viru - Original Message - From: Marcos Oliva [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Thursday, November 27, 2003 11:53 AM Subject: RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Viru, have you tried looking into the MySQL errro 144 ?, you may have to issue the myisamchk with the -force option and see if that helps marcos oliva -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 6:42 PM To: Struts Users Mailing List Cc: Subject: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear All, I am very sorry to ask MySQL releted question in Struts group.. i am facing this problem since one week but couldn't able to sovle... could any one faced following error before..? while accessing table called vip_detail_tab, i m getting following error.. Can't open file: 'vip_detail_tab.MYD'. (errno: 144) i feel this table may corrupted.. expecting some ray of hope from this group..:( Regards, viru - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144)
Viru, Ok then have you tried using the REPAIR TABLE QUICK or else try dumping the data from the table to a delim file and recreating the table . marcos -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 7:03 PM To: Struts Users Mailing List Cc: Subject: Re: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear Marcos, Thanks for immediate your response... Yaa, when i tried 'myisamchk -f vip_detail_tab' command, i got following error... Checking MyISAM file: /var/lib/mysql/db_slcs/vip_detail_tab Data records: 39642 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed and last repair failed - check file-size myisamchk: warning: Size of indexfile is: 1992704 Should be: 1024 - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 myisamchk: error: Can't read indexpage from filepos: -1 - recovering (with sort) MyISAM-table '/var/lib/mysql/db_slcs/vip_detail_tab.MYI' Data records: 39642 - Fixing index 1 myisamchk: Error writing file '/var/lib/mysql/db_slcs/vip_detail_tab.TMD' (Errcode: 28) myisamchk: error: 28 when writing to datafile MyISAM-table '/var/lib/mysql/db_slcs/vip_detail_tab' is not fixed because of errors Try fixing it by using the --safe-recover (-o) or the --force (-f) option with warm regards, viru - Original Message - From: Marcos Oliva [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Thursday, November 27, 2003 11:53 AM Subject: RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Viru, have you tried looking into the MySQL errro 144 ?, you may have to issue the myisamchk with the -force option and see if that helps marcos oliva -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 6:42 PM To: Struts Users Mailing List Cc: Subject: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear All, I am very sorry to ask MySQL releted question in Struts group.. i am facing this problem since one week but couldn't able to sovle... could any one faced following error before..? while accessing table called vip_detail_tab, i m getting following error.. Can't open file: 'vip_detail_tab.MYD'. (errno: 144) i feel this table may corrupted.. expecting some ray of hope from this group..:( Regards, viru - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144)
Hai Viru, even i had the same problem some time back could fix it with this below command mysqlrepair table vip_detail_tab; u can look at the help options under mysql command prompt srinivas Marcos Oliva [EMAIL PROTECTED] wrote: Viru, have you tried looking into the MySQL errro 144 ?, you may have to issue the myisamchk with the -force option and see if that helps marcos oliva -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 6:42 PM To: Struts Users Mailing List Cc: Subject: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear All, I am very sorry to ask MySQL releted question in Struts group.. i am facing this problem since one week but couldn't able to sovle... could any one faced following error before..? while accessing table called vip_detail_tab, i m getting following error.. Can't open file: 'vip_detail_tab.MYD'. (errno: 144) i feel this table may corrupted.. expecting some ray of hope from this group..:( Regards, viru - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
Re: Can't open file: 'vip_detail_tab.MYD'. (errno: 144)
Dear Marcos, I tried using REPAIR TABLE vip_detail_tab QUICK, i got following error, +++--+-- -+ | Table | Op | Msg_type | Msg_text | +++--+-- -+ | db_slcs.vip_detail_tab | repair | error| Couldn't fix table with quick recovery: Found wrong number of deleted records | | db_slcs.vip_detail_tab | repair | error| Run recovery again without -q | | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | status | Operation failed | +++--+-- -+ 5 rows in set (1.06 sec) Regards, viru - Original Message - From: Marcos Oliva [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Thursday, November 27, 2003 12:09 PM Subject: RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Viru, Ok then have you tried using the REPAIR TABLE QUICK or else try dumping the data from the table to a delim file and recreating the table . marcos -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 7:03 PM To: Struts Users Mailing List Cc: Subject: Re: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear Marcos, Thanks for immediate your response... Yaa, when i tried 'myisamchk -f vip_detail_tab' command, i got following error... Checking MyISAM file: /var/lib/mysql/db_slcs/vip_detail_tab Data records: 39642 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed and last repair failed - check file-size myisamchk: warning: Size of indexfile is: 1992704 Should be: 1024 - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 myisamchk: error: Can't read indexpage from filepos: -1 - recovering (with sort) MyISAM-table '/var/lib/mysql/db_slcs/vip_detail_tab.MYI' Data records: 39642 - Fixing index 1 myisamchk: Error writing file '/var/lib/mysql/db_slcs/vip_detail_tab.TMD' (Errcode: 28) myisamchk: error: 28 when writing to datafile MyISAM-table '/var/lib/mysql/db_slcs/vip_detail_tab' is not fixed because of errors Try fixing it by using the --safe-recover (-o) or the --force (-f) option with warm regards, viru - Original Message - From: Marcos Oliva [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Thursday, November 27, 2003 11:53 AM Subject: RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Viru, have you tried looking into the MySQL errro 144 ?, you may have to issue the myisamchk with the -force option and see if that helps marcos oliva -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 6:42 PM To: Struts Users Mailing List Cc: Subject: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear All, I am very sorry to ask MySQL releted question in Struts group.. i am facing this problem since one week but couldn't able to sovle... could any one faced following error before..? while accessing table called vip_detail_tab, i m getting following error.. Can't open file: 'vip_detail_tab.MYD'. (errno: 144) i feel this table may corrupted.. expecting some ray of hope from this group..:( Regards, viru -- -- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144)
Viru, do not run the recovery quick, just run it as repair table marcos -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 7:17 PM To: Struts Users Mailing List Cc: Subject: Re: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear Marcos, I tried using REPAIR TABLE vip_detail_tab QUICK, i got following error, +++--+-- -+ | Table | Op | Msg_type | Msg_text | +++--+-- -+ | db_slcs.vip_detail_tab | repair | error| Couldn't fix table with quick recovery: Found wrong number of deleted records | | db_slcs.vip_detail_tab | repair | error| Run recovery again without -q | | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | status | Operation failed | +++--+-- -+ 5 rows in set (1.06 sec) Regards, viru - Original Message - From: Marcos Oliva [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Thursday, November 27, 2003 12:09 PM Subject: RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Viru, Ok then have you tried using the REPAIR TABLE QUICK or else try dumping the data from the table to a delim file and recreating the table . marcos -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 7:03 PM To: Struts Users Mailing List Cc: Subject: Re: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear Marcos, Thanks for immediate your response... Yaa, when i tried 'myisamchk -f vip_detail_tab' command, i got following error... Checking MyISAM file: /var/lib/mysql/db_slcs/vip_detail_tab Data records: 39642 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed and last repair failed - check file-size myisamchk: warning: Size of indexfile is: 1992704 Should be: 1024 - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 myisamchk: error: Can't read indexpage from filepos: -1 - recovering (with sort) MyISAM-table '/var/lib/mysql/db_slcs/vip_detail_tab.MYI' Data records: 39642 - Fixing index 1 myisamchk: Error writing file '/var/lib/mysql/db_slcs/vip_detail_tab.TMD' (Errcode: 28) myisamchk: error: 28 when writing to datafile MyISAM-table '/var/lib/mysql/db_slcs/vip_detail_tab' is not fixed because of errors Try fixing it by using the --safe-recover (-o) or the --force (-f) option with warm regards, viru - Original Message - From: Marcos Oliva [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Thursday, November 27, 2003 11:53 AM Subject: RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Viru, have you tried looking into the MySQL errro 144 ?, you may have to issue the myisamchk with the -force option and see if that helps marcos oliva -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 6:42 PM To: Struts Users Mailing List Cc: Subject: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear All, I am very sorry to ask MySQL releted question in Struts group.. i am facing this problem since one week but couldn't able to sovle... could any one faced following error before..? while accessing table called vip_detail_tab, i m getting following error.. Can't open file: 'vip_detail_tab.MYD'. (errno: 144) i feel this table may corrupted.. expecting some ray of hope from
Re: Can't open file: 'vip_detail_tab.MYD'. (errno: 144)
Dear Srinivas, I tried this option too like, REPAIR TABLE vip_detail_tab QUICK, but i got following error.. +++--+-- -+ | Table | Op | Msg_type | Msg_text | +++--+-- -+ | db_slcs.vip_detail_tab | repair | error| Couldn't fix table with quick recovery: Found wrong number of deleted records | | db_slcs.vip_detail_tab | repair | error| Run recovery again without -q | | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | status | Operation failed | +++--+-- -+ 5 rows in set (1.06 sec) facing critical problem... regards, viru - Original Message - From: chekuri raju [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Thursday, November 27, 2003 12:16 PM Subject: RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Hai Viru, even i had the same problem some time back could fix it with this below command mysqlrepair table vip_detail_tab; u can look at the help options under mysql command prompt srinivas Marcos Oliva [EMAIL PROTECTED] wrote: Viru, have you tried looking into the MySQL errro 144 ?, you may have to issue the myisamchk with the -force option and see if that helps marcos oliva -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 6:42 PM To: Struts Users Mailing List Cc: Subject: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear All, I am very sorry to ask MySQL releted question in Struts group.. i am facing this problem since one week but couldn't able to sovle... could any one faced following error before..? while accessing table called vip_detail_tab, i m getting following error.. Can't open file: 'vip_detail_tab.MYD'. (errno: 144) i feel this table may corrupted.. expecting some ray of hope from this group..:( Regards, viru - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Can't open file: 'vip_detail_tab.MYD'. (errno: 144)
Dear Marcos, still getting error after running 'repair table vip_detail_tab', +++--+-+ | Table | Op | Msg_type | Msg_text| +++--+-+ | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | status | Operation failed| +++--+-+ regards, viru - Original Message - From: Marcos Oliva [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Thursday, November 27, 2003 12:20 PM Subject: RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Viru, do not run the recovery quick, just run it as repair table marcos -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 7:17 PM To: Struts Users Mailing List Cc: Subject: Re: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear Marcos, I tried using REPAIR TABLE vip_detail_tab QUICK, i got following error, +++--+-- -+ | Table | Op | Msg_type | Msg_text | +++--+-- -+ | db_slcs.vip_detail_tab | repair | error| Couldn't fix table with quick recovery: Found wrong number of deleted records | | db_slcs.vip_detail_tab | repair | error| Run recovery again without -q | | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | status | Operation failed | +++--+-- -+ 5 rows in set (1.06 sec) Regards, viru - Original Message - From: Marcos Oliva [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Thursday, November 27, 2003 12:09 PM Subject: RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Viru, Ok then have you tried using the REPAIR TABLE QUICK or else try dumping the data from the table to a delim file and recreating the table . marcos -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 7:03 PM To: Struts Users Mailing List Cc: Subject: Re: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear Marcos, Thanks for immediate your response... Yaa, when i tried 'myisamchk -f vip_detail_tab' command, i got following error... Checking MyISAM file: /var/lib/mysql/db_slcs/vip_detail_tab Data records: 39642 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed and last repair failed - check file-size myisamchk: warning: Size of indexfile is: 1992704 Should be: 1024 - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 myisamchk: error: Can't read indexpage from filepos: -1 - recovering (with sort) MyISAM-table '/var/lib/mysql/db_slcs/vip_detail_tab.MYI' Data records: 39642 - Fixing index 1 myisamchk: Error writing file '/var/lib/mysql/db_slcs/vip_detail_tab.TMD' (Errcode: 28) myisamchk: error: 28 when writing to datafile MyISAM-table '/var/lib/mysql/db_slcs/vip_detail_tab' is not fixed because of errors Try fixing it by using the --safe-recover (-o) or the --force (-f) option with warm regards, viru - Original Message - From: Marcos Oliva [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Thursday, November 27, 2003 11:53 AM Subject: RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Viru, have you tried looking into the MySQL errro 144 ?, you may have to issue the myisamchk with the -force option and see if that helps marcos oliva -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 6:42 PM To: Struts Users Mailing List Cc: Subject: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear All, I am very sorry to ask MySQL releted question in Struts group.. i am facing this problem since one week but couldn't able to sovle... could any one faced following error before..? while accessing table called vip_detail_tab, i m getting following error.. Can't open file: 'vip_detail_tab.MYD'. (errno: 144) i feel this table may corrupted.. expecting some ray of hope from this group..:( Regards, viru
RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144)
Viru, try dumping the records of the table to a delim file and then delete and re-create the table it seems that it is a lost cause with REPAIR .. marcos -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 7:31 PM To: Struts Users Mailing List Cc: Subject: Re: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear Marcos, still getting error after running 'repair table vip_detail_tab', +++--+-+ | Table | Op | Msg_type | Msg_text| +++--+-+ | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | status | Operation failed| +++--+-+ regards, viru - Original Message - From: Marcos Oliva [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Thursday, November 27, 2003 12:20 PM Subject: RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Viru, do not run the recovery quick, just run it as repair table marcos -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 7:17 PM To: Struts Users Mailing List Cc: Subject: Re: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear Marcos, I tried using REPAIR TABLE vip_detail_tab QUICK, i got following error, +++--+-- -+ | Table | Op | Msg_type | Msg_text | +++--+-- -+ | db_slcs.vip_detail_tab | repair | error| Couldn't fix table with quick recovery: Found wrong number of deleted records | | db_slcs.vip_detail_tab | repair | error| Run recovery again without -q | | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | status | Operation failed | +++--+-- -+ 5 rows in set (1.06 sec) Regards, viru - Original Message - From: Marcos Oliva [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Thursday, November 27, 2003 12:09 PM Subject: RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Viru, Ok then have you tried using the REPAIR TABLE QUICK or else try dumping the data from the table to a delim file and recreating the table . marcos -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 7:03 PM To: Struts Users Mailing List Cc: Subject: Re: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear Marcos, Thanks for immediate your response... Yaa, when i tried 'myisamchk -f vip_detail_tab' command, i got following error... Checking MyISAM file: /var/lib/mysql/db_slcs/vip_detail_tab Data records: 39642 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed and last repair failed - check file-size myisamchk: warning: Size of indexfile is: 1992704 Should be: 1024 - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 myisamchk: error: Can't read indexpage from filepos: -1 - recovering (with sort) MyISAM-table '/var/lib/mysql/db_slcs/vip_detail_tab.MYI' Data records: 39642 - Fixing index 1 myisamchk: Error writing file '/var/lib/mysql/db_slcs/vip_detail_tab.TMD' (Errcode
RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144)
Viru, | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile error 28 means that you do not have more room on the device where MySQL resides.. please check your disk file space where MySQL is. marcos oliva -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 7:24 PM To: Struts Users Mailing List Cc: Subject: Re: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear Srinivas, I tried this option too like, REPAIR TABLE vip_detail_tab QUICK, but i got following error.. +++--+-- -+ | Table | Op | Msg_type | Msg_text | +++--+-- -+ | db_slcs.vip_detail_tab | repair | error| Couldn't fix table with quick recovery: Found wrong number of deleted records | | db_slcs.vip_detail_tab | repair | error| Run recovery again without -q | | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | error| 28 when writing to datafile | | db_slcs.vip_detail_tab | repair | status | Operation failed | +++--+-- -+ 5 rows in set (1.06 sec) facing critical problem... regards, viru - Original Message - From: chekuri raju [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Thursday, November 27, 2003 12:16 PM Subject: RE: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Hai Viru, even i had the same problem some time back could fix it with this below command mysqlrepair table vip_detail_tab; u can look at the help options under mysql command prompt srinivas Marcos Oliva [EMAIL PROTECTED] wrote: Viru, have you tried looking into the MySQL errro 144 ?, you may have to issue the myisamchk with the -force option and see if that helps marcos oliva -Original Message- From: virupaksha [mailto:[EMAIL PROTECTED] Sent: Wed 11/26/2003 6:42 PM To: Struts Users Mailing List Cc: Subject: Can't open file: 'vip_detail_tab.MYD'. (errno: 144) Dear All, I am very sorry to ask MySQL releted question in Struts group.. i am facing this problem since one week but couldn't able to sovle... could any one faced following error before..? while accessing table called vip_detail_tab, i m getting following error.. Can't open file: 'vip_detail_tab.MYD'. (errno: 144) i feel this table may corrupted.. expecting some ray of hope from this group..:( Regards, viru - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]