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]
