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 out
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
received
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 received
the same 127 error. The update queries
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]
Subject: Re: table error 127
:[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,
Thanks for the suggestion. I ran myisamchk on the table and
it said it was
corrupted. So I
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 the
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
Jonathan Patton wrote:
I have mysql setup on two computers
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 obscure
]; 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 ever since I upgraded from MySQL 3
to 4. I actually have set up a cron to check