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]
