- 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 is crashed --> -->Hello, --> -->I have "mysql-standard-4.0.16-pc-linux-i686" installed on a 4gig mem, -->2cpu system, RH 9. -->I have a large table (Data records: 72426930) that is now giving me this -->error "Error 127" -->when doing selects... --> -->This is my first crash of any kind with Mysql. So I'm a liitle confused -->on what I should do. -->The manual states -->use myisamchk, then you read further and it says use REPAIR TABLE... --> -->I'm confused can someone give me a 1 to end step on repairing this -->table?? --> -->At this point I brought my mysqld down. --> -->Tried running this: -->[root]# myisamchk -r Nov03 -->- recovering (with keycache) MyISAM-table 'Nov03' -->Data records: 72426930 -->myisamchk: error: Can't create new tempfile: '/opt/logs/Nov03.TMD' -->MyISAM-table 'Nov03' is not fixed because of errors -->Try fixing it by using the --safe-recover (-o) or the --force (-f) option --> -->So I tried this: -->[root]# myisamchk -rf Nov03 -->[EMAIL PROTECTED] ip_logs]# myisamchk -rf Nov03 -->- recovering (with keycache) MyISAM-table 'Nov03' -->Data records: 72426930 -->5939000 --> -->It looks like its doing something --> -->my data dir and the table in question: -->-rw-rw---- 1 mysql mysql 8812359152 Nov 11 01:25 Nov03.MYD -->-rw-rw---- 1 mysql mysql 5346325504 Nov 11 14:52 Nov03.MYI -->-rw-rw---- 1 mysql mysql 631242752 Nov 11 14:52 Nov03.TMD --> -->Please advise... Good you turned off mysql and ran this command. If you didn't you would just cause further corruption. Next the TMD file means that as myisamchk repairs, this temp file above is appended as the datafile is compared to the index file. This is to ensure that the source data file is not modified (yet) in case of row loss. If you need to recover the lost rows that occur during this repair (source data file will be stored in a .BAK file) then it's possible. So, what you need to do right now is wait till that 631242752 file size equals the 8812359152 file size. Myisamchk will report how many rows have been lost if any during the end of the repair. --> -->Thanks -->Rob --> --> --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
