Re: table error 127

2003-08-14 Thread walt
On Tuesday 05 August 2003 09:06 am, Richard Gabriel wrote: > My database experiences a similar effect, but I can't pinpoint the specific > queries because it gets thousands per second. I have not noticed the > problem on a machine that is only used occasionally. Is there a way to get > queries ou

Re: table error 127

2003-08-07 Thread walt
On Tuesday 05 August 2003 08:58 am, Jonathan Patton wrote: > Walt, > > Thanks for the suggestion. I ran myisamchk on the table and it said it was > corrupted. So I ran myismachk on the table with the -r and it said the > table was fixed. I then ran the update queries I was running before and > rece

RE: table error 127

2003-08-06 Thread Jonathan Patton
-Original Message- > From: walt [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 05, 2003 10:18 AM > To: Jonathan Patton > Cc: [EMAIL PROTECTED] > Subject: Re: table error 127 > > > On Tuesday 05 August 2003 08:58 am, Jonathan Patton wrote: > > Walt, > > >

RE: table error 127

2003-08-06 Thread Jonathan Patton
t the problem or at least eliminate that problem from this problem. Also, could it be the backup is corrupted? Jonathan > -Original Message- > From: walt [mailto:[EMAIL PROTECTED] > Sent: Monday, August 04, 2003 12:12 PM > To: Jonathan Patton > Cc: [EMAIL PROTECTED] > Subje

Re: table error 127

2003-08-06 Thread Richard Gabriel
Sent: Tuesday, August 05, 2003 8:58 AM Subject: RE: table error 127 Walt, Thanks for the suggestion. I ran myisamchk on the table and it said it was corrupted. So I ran myismachk on the table with the -r and it said the table was fixed. I then ran the update queries I was running before and receiv

Fw: table error 127

2003-08-04 Thread Richard Gabriel
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: "Richard Gabriel" <[EMAIL PROTECTED]> Sent: Sunday, August 04, 2002 3:16 PM Subject: Ynt: table error 127 > *This message was transferred with a trial version of CommuniGate(tm) Pro* > i got same err (once) o

Re: table error 127

2003-08-04 Thread Richard Gabriel
hard Gabriel" <[EMAIL PROTECTED]>; "Jonathan Patton" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, August 04, 2003 2:26 PM Subject: Re: table error 127 On Monday 04 August 2003 02:10 pm, Richard Gabriel wrote: > I have been getting this type of error

Re: table error 127

2003-08-04 Thread walt
On Monday 04 August 2003 02:10 pm, Richard Gabriel wrote: > I have been getting this type of error ever since I upgraded from MySQL 3 > to 4. I actually have set up a cron to check/repair tables hourly because > of this. The following diagnoses have been suggested, but I would bet it's > an obscu

Re: table error 127

2003-08-04 Thread Richard Gabriel
iel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: "walt" <[EMAIL PROTECTED]> To: "Jonathan Patton" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, August 04, 2003 12:11 PM Subject: Re: table error 127 &

Re: table error 127

2003-08-04 Thread walt
Jonathan Patton wrote: > > I have mysql setup on two computers with identical databases. When I run a group of > queries on the one computer I get back an error 127 which I checked on an it appears > to be a table corruption error. On the other computer, the queries run fine. Since > I had all

table error 127

2003-08-04 Thread Jonathan Patton
I have mysql setup on two computers with identical databases. When I run a group of queries on the one computer I get back an error 127 which I checked on an it appears to be a table corruption error. On the other computer, the queries run fine. Since I had all the data for the table in questio