Mysql #1030 - Got error 127 from table handler

MySQL, PostgreSQL, SQLite
mmichael29
Posts: 56
Joined: 2002-11-19 15:13

Mysql #1030 - Got error 127 from table handler

Post by mmichael29 » 2005-10-05 09:49

Hallo,

ich bekomm bei einer Tabelle mit 92 Einträgen folgenden Fehler:

#1030 - Got error 127 from table handler

Reparieren über phpmyadmin hat zur Folge, dass nur noch 2 Datensätze übrig bleiben, mysiamchk bringt das gleiche erschreckende Ergebnis. Habt Ihr noch ne Idee vielleicht?

User avatar
Joe User
Project Manager
Project Manager
Posts: 11598
Joined: 2003-02-27 01:00
Location: Hamburg

Re: Mysql #1030 - Got error 127 from table handler

Post by Joe User » 2005-10-05 10:36

PayPal.Me/JoeUserFreeBSD Remote Installation
Wings for LifeWings for Life World Run

„If there’s more than one possible outcome of a job or task, and one
of those outcomes will result in disaster or an undesirable consequence,
then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.

mmichael29
Posts: 56
Joined: 2002-11-19 15:13

mysql

Post by mmichael29 » 2005-10-05 10:53

suse 9.1 mysql 4.0.18

Logfiles hab ich ja keine, aber nen überhang von 20 byte.

xxxxxx 91 MyISAM 459,5 KB 20 Bytes

rep bringt folgende meldungen

usr_web73_1.mos_content repair info Wrong bytesec: 0-0-0 at 212416; Skipped
usr_web73_1.mos_content repair info Found block with too small length at 44; Skipped
usr_web73_1.mos_content repair info Wrong bytesec: 0-0-0 at 145316; Skipped
usr_web73_1.mos_content repair info Found block that points outside data file at 10028
usr_web73_1.mos_content repair info Found block that points outside data file at 10480
usr_web73_1.mos_content repair info Found block that points outside data file at 10808
usr_web73_1.mos_content repair info Found block that points outside data file at 12660
usr_web73_1.mos_content repair info Wrong bytesec: 0-0-0 at 173456; Skipped
usr_web73_1.mos_content repair warning Number of rows changed from 91 to 2


Genügt Euch das veilleicht?

Viele Grüße

Michael