Viru,
No problem I am glad I was able to help I am from El Salvador living in USA Los Angeles
marcos oliva
-----Original Message-----
From: virupaksha [mailto:[EMAIL PROTECTED]
Sent: Wed 11/26/2003 10:26 PM
To: Struts Users Mailing List
Cc:
Subject: Thanks for your great help...!
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
