Just do a check and repair: (or just repair to fix it)
CHECK TABLE your_table
REPAIR TABLE your_table
- Original Message -
From: "Jacob Joseph" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 22, 2003 12:36 PM
Subject: Error: 127
Hi All,
I have a MySQL4.0 installat
e Pattishall
-->Subject: RE: Error 127 = Record-file is crashed
-->
-->Thank you for the reply
-->
-->Before you replied I killed the first "myisamchk" thinking I should
do
-->"REPAIR TABLE"
-->Then your email came and I killed the "REPAIR TABLE"
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: rmck [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, November 11, 2003 3:17 PM
-->To: [EMAIL PROTECTED]
-->Subject: Error 127 = Record-file i
Redhat 7.3
Kernel linux-2.4.18-3
Rgds
Terence
- Original Message -
From: "Richard Gabriel" <[EMAIL PROTECTED]>
To: "Terence" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, August 12, 2003 2:02 AM
Subject: Re: Error 127, some questions
W
What OS/kernel are you running? Thanks.
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
- Original Message -
From: "Terence" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 11, 2003 2:28 AM
Subject: Error 127, some questions
> Dear List,
>
Hi!
On Jul 14, Dan wrote:
> Hi all.
>
> I have a MyISAM table ( MySQL-4.0.13) that will get truncated every
> month, and around 1,000,000 records imported into it. The import process
> consists of a 'load data infile' operation, followed by some updates to
> extract data and dump it somewhere
John,
Saturday, August 10, 2002, 4:32:37 AM, you wrote:
JP> I keep getting a problem with our MySQL database, I know what error 127 is
JP> ('Record-file is crashed / Network is down'), it keeps occuring on several
JP> tables that are frequently accessed by our website.
JP> I can fix the problem
Ian,
Friday, July 05, 2002, 4:11:37 PM, you wrote:
IH> Every time we move our database onto new hardware (ie. Pentium 4) we get
IH> errors 127 and 134 within the mysql error logfile. When we then run the
IH> check (i.e. CHECK TABLE tablename EXTENDED) on the databases the status
IH> comes back as
Hi,
actually I know about current problem in 3.23.49a on linux at least -
there's something weird with the cache I think. I've posted some reports
with my ideas to the bugs list already. For you:
I can get rid of such problems whenever they appear by doing :
mysqladmin flush-tables
They disappe
maxim,
Friday, April 05, 2002, 2:35:01 PM, you wrote:
m> What is .. the "Got error 127 from table handwler"
m> Pl send me error table ...
$ perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed
You can try to repair your table using myisamchk
or REPAIR TABLE statem
able to
proceed.
Hope that helps you.
Dave Lake
>From: "Diehl, Jeffrey" <[EMAIL PROTECTED]>
>To: "'Chris Bolt '" <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '"
><[EMAIL PROTECTED]>
>Subject: RE: Error 127 from table
> I'm using 3.22.27 and am getting an error when I submit queries.
>
> I do a select * from table where...
>
> And it gives me:
>
> ERROR 1030: Got error 127 from table handler
chris@entropy:~$ perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed
Run isamchk -r on the ta
> Go error 127 from table handler.. fixed itself in about 10 minutes..
> don't know what this is or why it happened.. anyone know?
>
> It happened while doing an update SQL command to a table.
> I'm not even sure what it means.. can't find any error codes.
Try running perror 127
---
in the mysql command line, try this:
use databasename;
repair table tablename;
(repeat that last line for each of your tables)
I haven't tried myisamchk at all. This is what I use.
Walter
At 12:13 PM -0400 7/25/01, Marko Andrus wrote:
>Hi-
>
>I am getting error 127 and I cant seem to get the m
Cesar Cabrera wrote:
>
> Hello and thanks,
>
> can you tell me where can I get information about the errors
> presented by MySQL? I have that kind of trouble each time the server (the
> machine) crash and it's no solved after myisamchk with any option.
>
a) perror [error number
Hello and thanks,
can you tell me where can I get information about the errors
presented by MySQL? I have that kind of trouble each time the server (the
machine) crash and it's no solved after myisamchk with any option.
thanks again,
Cesar A. Cabrera E.
On Tue, 27 Mar 2001, Sascha Eversmeier wrote:
> Hi,
>
> could anyone of you please take a look at this message:
> 'MySQL said: Got error 127 from table handler'
>
> This occurs when trying to access a specific table, like 'select * from
> someTab', but it works when appending ' limit 0, X'.
>
Yes, make sure you shutdown the server before running isamchk.
mohamed Abd El-Samei Mohamed wrote:
>
> Thanks for help .,
> I tried it but also got the same error
>
> any other advice
>
> "Gerald L. Clark" wrote:
> >
> > Run isamchk on your tables.
> >
> > mohamed Abd El-Samei Mohamed wrote:
>
Thanks for help .,
I tried it but also got the same error
any other advice
"Gerald L. Clark" wrote:
>
> Run isamchk on your tables.
>
> mohamed Abd El-Samei Mohamed wrote:
> >
> > Dear all i need help
> > i have mysql-3.22.26a over unix solairs 7
> > when i try to apply query from the consol
Run isamchk on your tables.
mohamed Abd El-Samei Mohamed wrote:
>
> Dear all i need help
> i have mysql-3.22.26a over unix solairs 7
> when i try to apply query from the console to retrieve some information
> i got that error
>
> ERROR 1030: Got error 127 from table handler
>
> please help ..
I tried. It doesn't work. It sais "Table 'absences' is read-only". I
checked the files absences.* and owner is user mysql and permissions are
644.
Any ideas?
On Sat, 10 Mar 2001, Siim Einfeldt aka Itpunk wrote:
>
> Try REPAIR TABLE absences; This should do the trick:-)
>
> > Hy!
> >
> > I have
Try REPAIR TABLE absences; This should do the trick:-)
> Hy!
>
> I have a problem I couldn't solve by my one. Here is a sample of mysql
> client output:
>
> mysql> use lumina;
> Database changed
> mysql> select * from absences;
> ERROR 1030: Got error 127 from table handler
>
> The table absence
>Hello everybody,
>
>About two hours ago I had a system crash and one of my MySQL databases was
>extensively used at the same time. When the system went back up, the
>table (the
>table has 37000 rows) that was used at the time of the crash started
>to give me
>the error
>: Got error: 1030: Got e
mysqladmin shutdown
myisamchk -o ./*.MYI
myisamchk -r ./*.MYI
(or isamchk if you are using the old isam tables)
then restart mysql.
- Original Message -
From: "Frédéric Bonjour" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 1:05 PM
Subject: Error 127: tabl
24 matches
Mail list logo
