Dear Marcos, As you suggested me to check the file size, i checked the file size and it was full.. I have removed all unwanted data from the 'var' file and repaired the table using repair query.. now i can successfully run query on table..
Once again thanks for your help..... now a personal question, from which country you are..? With warm 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 xxxx > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > -------------------------------------------------------------------------- > -- > > ---- > > > > > > > --------------------------------------------------------------------- > > > 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] > > > > ---------------------------------------------------------------------------- ---- > --------------------------------------------------------------------- > 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]