|
»
Frequently MyISAM TABLE corruption.....Pls help
|
View:
New views
6 Messages
—
Rating Filter:
Alert me
|
 |
Frequently MyISAM TABLE corruption.....Pls help
by Nilnandan
::
Rate this Message:
Hello all,
I have one server which has mysql 5.0.27 installed. There is one table named table1. that table has 122000 records..It has 114 fields and 22 indexes. Now this table always been corrupt. I have try to found the solution but i couldn't. Pls help me ASAP. I have used CHECK and REPAIR option I have given here the output..... 070509 4:06:17 [ERROR] /usr/sbin/mysqld: Table 'table1' is marked as crashed and should be repaired 070509 4:06:17 [ERROR] /usr/sbin/mysqld: Sort aborted Database changed mysql> check table table1; +----------------------+-------+----------+----------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +----------------------+-------+----------+----------------------------------------------------+ | DB1.table1 | check | error | Wrong bytesec: 111-110-115 at linkstart: 583497784 | | DB1.table1 | check | error | Corrupt | +----------------------+-------+----------+----------------------------------------------------+ 2 rows in set (4.41 sec) mysql> repair table table1; +----------------------+--------+----------+---------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +----------------------+--------+----------+---------------------------------------------------------+ | DB1.table1 | repair | info | Wrong bytesec: 111-110-115 at 583497784; Skipped | | DB1.table1 | repair | info | Found block that points outside data file at 583497848 | | DB1.table1 | repair | info | Found block that points outside data file at 583497912 | | DB1.table1 | repair | info | Found block with too small length at 583498656; Skipped | | DB1.table1 | repair | info | Found block with too small length at 583498964; Skipped | | DB1.table1 | repair | info | Found block with too small length at 583498988; Skipped | | DB1.table1 | repair | info | Found block with too small length at 583499040; Skipped | | DB1.table1 | repair | info | Found block with too small length at 583499120; Skipped | | DB1.table1 | repair | info | Found block with too small length at 583499176; Skipped | | DB1.table1 | repair | info | Found block with too small length at 583499204; Skipped | | DB1.table1 | repair | info | Found block with too small length at 583499312; Skipped | | DB1.table1 | repair | info | Found block with too small length at 583499368; Skipped | | DB1.table1 | repair | info | Found block with too small length at 583499396; Skipped | | DB1.table1 | repair | info | Found block with too small length at 583499420; Skipped | | DB1.table1 | repair | info | Found block with too small length at 583499448; Skipped | | DB1.table1 | repair | info | Found block with too small length at 583499504; Skipped | | DB1.table1 | repair | status | I have also used myisamchk command and its output is: Checking MyISAM file: /var/lib/mysql5/DB1/table1.MYI Data records: 122089 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check data record references index: 3 - check data record references index: 4 - check data record references index: 5 - check data record references index: 6 - check data record references index: 7 - check data record references index: 8 - check data record references index: 9 - check data record references index: 10 - check data record references index: 11 - check data record references index: 12 - check data record references index: 13 - check data record references index: 14 - check data record references index: 15 - check data record references index: 16 - check data record references index: 17 - check data record references index: 18 - check data record references index: 19 - check data record references index: 20 - check data record references index: 21 - check data record references index: 22 - check records and index references - recovering (with sort) MyISAM-table '/var/lib/mysql5/DB1/table1.MYI' Data records: 122089 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 - Fixing index 6 - Fixing index 7 - Fixing index 8 - Fixing index 9 - Fixing index 10 - Fixing index 11 - Fixing index 12 - Fixing index 13 - Fixing index 14 - Fixing index 15 - Fixing index 16 - Fixing index 17 - Fixing index 18 - Fixing index 19 - Fixing index 20 - Fixing index 21 - Fixing index 22 So, pls help me ASAP.....Thanks in advance... regards, Nilnandan Joshi DBA - INDIA |
|
|
Re: Frequently MyISAM TABLE corruption.....Pls help
by Gerald L. Clark-2
::
Rate this Message:
Nilnandan wrote:
> Hello all, > > I have one server which has mysql 5.0.27 installed. There is one table named > table1. > that table has 122000 records..It has 114 fields and 22 indexes. > > Now this table always been corrupt. I have try to found the solution but i > couldn't. > Pls help me ASAP. I have used CHECK and REPAIR option I have given here the > output..... > > 070509 4:06:17 [ERROR] /usr/sbin/mysqld: Table 'table1' is marked as > crashed and should be repaired > 070509 4:06:17 [ERROR] /usr/sbin/mysqld: Sort aborted > > Has either reached the file size limit of your filesystem, or the default maximum MyISAM size? -- Gerald L. Clark Supplier Systems Corporation -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=lists@... |
|
|
Re: Frequently MyISAM TABLE corruption.....Pls help
by Nilnandan
::
Rate this Message:
Hello Gerald,
Data_length Max_data_length Index_length 596483288 281474976710655 33758208 580 MB is table size and 32MB is index size..... The default maximum MyISAM size is 4GB. Now, tell me where is an issue....? regards, Nilnandan Joshi DBA-SDU Juriscape
|
|
|
Re: Frequently MyISAM TABLE corruption.....Pls help
by Dan Buettner-2
::
Rate this Message:
Some additional resources for fixing corrupt MyISAM tables:
http://dev.mysql.com/doc/refman/5.0/en/myisam-table-problems.html http://dev.mysql.com/doc/refman/5.0/en/myisamchk.html http://dev.mysql.com/doc/refman/5.0/en/table-maintenance.html , especially: http://dev.mysql.com/doc/refman/5.0/en/repair.html I don't know for sure as it will depend on your data and your indices, but with 580 MB of data, 122000 records, and 22 indices, I would expect that your index file should be larger than it is (just 32 MB). I would suggest that perhaps your index file is corrupt and needs to be rebuilt - look at the stage 2 and stage 3 procedures mentioned in the repair page (last URL above). Be sure to make backup copies! Read it and understand it before you do it! Best of luck, Dan On 5/10/07, Nilnandan <nandan_it@...> wrote: > > > Hello Gerald, > > Data_length Max_data_length Index_length > 596483288 281474976710655 33758208 > > 580 MB is table size and 32MB is index size..... > The default maximum MyISAM size is 4GB. > > Now, tell me where is an issue....? > > regards, > Nilnandan Joshi > DBA-SDU > Juriscape > > > > Gerald L. Clark-2 wrote: > > > > Nilnandan wrote: > >> Hello all, > >> > >> I have one server which has mysql 5.0.27 installed. There is one table > >> named > >> table1. > >> that table has 122000 records..It has 114 fields and 22 indexes. > >> > >> Now this table always been corrupt. I have try to found the solution > but > >> i > >> couldn't. > >> Pls help me ASAP. I have used CHECK and REPAIR option I have given here > >> the > >> output..... > >> > >> 070509 4:06:17 [ERROR] /usr/sbin/mysqld: Table 'table1' is marked as > >> crashed and should be repaired > >> 070509 4:06:17 [ERROR] /usr/sbin/mysqld: Sort aborted > >> > > > How big is the index file? the data file? > > Has either reached the file size limit of your filesystem, > > or the default maximum MyISAM size? > > > > > > -- > > Gerald L. Clark > > Supplier Systems Corporation > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql?unsub=lists@... > > > > > > > > -- > View this message in context: > http://www.nabble.com/Frequently-MyISAM-TABLE-corruption.....Pls-help-tf3715472.html#a10412877 > Sent from the MySQL - General mailing list archive at Nabble.com. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=drbuettner@... > > |
|
|
Re: Frequently MyISAM TABLE corruption.....Pls help
by Nilnandan
::
Rate this Message:
hello
I am still facing the same problem.. MyISAM table corruption....I am getting following errors mysql> use DB1; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> check table tables1; +----------------------+-------+----------+---------------------------------+ | Table | Op | Msg_type | Msg_text | +----------------------+-------+----------+---------------------------------+ | DB1.tables1 | check | error | Found wrong record at 967175516 | | DB1.tables1 | check | error | Corrupt | +----------------------+-------+----------+---------------------------------+ 2 rows in set (8.53 sec) ================================================================================================== ERROR LOG ========================================================================== Version: '5.0.27-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL) 070702 1:16:18 [ERROR] /usr/sbin/mysqld: Table 'tables1' is marked as crashed and should be repaired 070702 1:16:18 [ERROR] /usr/sbin/mysqld: Sort aborted 070702 1:19:43 [ERROR] Got error 127 when reading table './DB1/tables1' 070702 1:19:54 [ERROR] Got error 127 when reading table './DB1/tables1' 070702 1:20:05 [ERROR] Got error 127 when reading table './DB1/tables1' 070702 1:20:22 [ERROR] Got error 127 when reading table './DB1/tables1' 070702 1:21:24 [ERROR] Got error 127 when reading table './DB1/tables1' 070702 1:22:16 [ERROR] Got error 127 when reading table './DB1/tables1' 070702 1:22:17 [ERROR] /usr/sbin/mysqld: Table 'tables1' is marked as crashed and should be repaired 070702 1:22:17 [ERROR] /usr/sbin/mysqld: Sort aborted Database changed mysql> repair table tables1; +----------------------+--------+----------+---------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +----------------------+--------+----------+---------------------------------------------------------+ | DB1.tables1 | repair | info | Key 1 - Found wrong stored record at 967175516 | | DB1.tables1 | repair | info | Found block that points outside data file at 967175964 | | DB1.tables1 | repair | info | Found block that points outside data file at 967176068 | | DB1.tables1 | repair | info | Found block that points outside data file at 967176168 | | DB1.tables1 | repair | info | Found block that points outside data file at 967176296 | | DB1.tables1 | repair | info | Found block that points outside data file at 967176484 | | DB1.tables1 | repair | info | Found block that points outside data file at 967176588 | | DB1.tables1 | repair | info | Found block with too small length at 967177484; Skipped | | DB1.tables1 | repair | warning | Number of rows changed from 186252 to 186251 | | DB1.tables1 | repair | status | OK | +----------------------+--------+----------+---------------------------------------------------------+ 10 rows in set (1 min 27.77 sec) PLS help me ASAP..........Its frequently corrupted..It is very important table Regards, Nilnandan Joshi DBA-INDIA
|
|
|
Re: Frequently MyISAM TABLE corruption.....Pls help
by ViSolve DB Team-2
::
Rate this Message:
Hi,
Pls try altering the engine type from 'MyISAM' to 'InnoDB' mysql > alter table `tablename` ENGINE='InnoDB'; Just try out. I'm not sure. But there are issues over 'MyISAM' engine' and table corruption. Pls look into the link http://dev.mysql.com/doc/refman/5.0/en/corrupted-myisam-tables.html about mysqleers comments. Thanks ViSolve DB Team. ----- Original Message ----- From: "Nilnandan" <nandan_it@...> To: <mysql@...> Sent: Monday, July 02, 2007 3:58 PM Subject: Re: Frequently MyISAM TABLE corruption.....Pls help > > hello > > I am still facing the same problem.. > MyISAM table corruption....I am getting following errors > > mysql> use DB1; > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Database changed > mysql> check table tables1; > > +----------------------+-------+----------+---------------------------------+ > | Table | Op | Msg_type | Msg_text > | > +----------------------+-------+----------+---------------------------------+ > | DB1.tables1 | check | error | Found wrong record at 967175516 | > | DB1.tables1 | check | error | Corrupt | > +----------------------+-------+----------+---------------------------------+ > > 2 rows in set (8.53 sec) > > ================================================================================================== > ERROR LOG > ========================================================================== > > Version: '5.0.27-standard-log' socket: '/var/lib/mysql/mysql.sock' port: > 3306 MySQL Community Edition - Standard (GPL) > > 070702 1:16:18 [ERROR] /usr/sbin/mysqld: Table 'tables1' is marked as > crashed and should be repaired > 070702 1:16:18 [ERROR] /usr/sbin/mysqld: Sort aborted > 070702 1:19:43 [ERROR] Got error 127 when reading table './DB1/tables1' > 070702 1:19:54 [ERROR] Got error 127 when reading table './DB1/tables1' > 070702 1:20:05 [ERROR] Got error 127 when reading table './DB1/tables1' > 070702 1:20:22 [ERROR] Got error 127 when reading table './DB1/tables1' > 070702 1:21:24 [ERROR] Got error 127 when reading table './DB1/tables1' > 070702 1:22:16 [ERROR] Got error 127 when reading table './DB1/tables1' > 070702 1:22:17 [ERROR] /usr/sbin/mysqld: Table 'tables1' is marked as > crashed and should be repaired > 070702 1:22:17 [ERROR] /usr/sbin/mysqld: Sort aborted > > > Database changed > > mysql> repair table tables1; > > +----------------------+--------+----------+---------------------------------------------------------+ > | Table | Op | Msg_type | Msg_text > | > +----------------------+--------+----------+---------------------------------------------------------+ > | DB1.tables1 | repair | info | Key 1 - Found wrong stored record at > 967175516 | > | DB1.tables1 | repair | info | Found block that points outside data > file at 967175964 | > | DB1.tables1 | repair | info | Found block that points outside data > file at 967176068 | > | DB1.tables1 | repair | info | Found block that points outside data > file at 967176168 | > | DB1.tables1 | repair | info | Found block that points outside data > file at 967176296 | > | DB1.tables1 | repair | info | Found block that points outside data > file at 967176484 | > | DB1.tables1 | repair | info | Found block that points outside data > file at 967176588 | > | DB1.tables1 | repair | info | Found block with too small length at > 967177484; Skipped | > | DB1.tables1 | repair | warning | Number of rows changed from 186252 to > 186251 | > | DB1.tables1 | repair | status | OK > | > +----------------------+--------+----------+---------------------------------------------------------+ > 10 rows in set (1 min 27.77 sec) > > > PLS help me ASAP..........Its frequently corrupted..It is very important > table > > Regards, > > Nilnandan Joshi > DBA-INDIA > > > > > > Nilnandan wrote: >> >> Hello Gerald, >> >> Data_length Max_data_length Index_length >> 596483288 281474976710655 33758208 >> >> 580 MB is table size and 32MB is index size..... >> The default maximum MyISAM size is 4GB. >> >> Now, tell me where is an issue....? >> >> regards, >> Nilnandan Joshi >> DBA-SDU >> Juriscape >> >> >> >> Gerald L. Clark-2 wrote: >>> >>> Nilnandan wrote: >>>> Hello all, >>>> >>>> I have one server which has mysql 5.0.27 installed. There is one table >>>> named >>>> table1. >>>> that table has 122000 records..It has 114 fields and 22 indexes. >>>> >>>> Now this table always been corrupt. I have try to found the solution >>>> but >>>> i >>>> couldn't. >>>> Pls help me ASAP. I have used CHECK and REPAIR option I have given here >>>> the >>>> output..... >>>> >>>> 070509 4:06:17 [ERROR] /usr/sbin/mysqld: Table 'table1' is marked as >>>> crashed and should be repaired >>>> 070509 4:06:17 [ERROR] /usr/sbin/mysqld: Sort aborted >>>> > >>> How big is the index file? the data file? >>> Has either reached the file size limit of your filesystem, >>> or the default maximum MyISAM size? >>> >>> >>> -- >>> Gerald L. Clark >>> Supplier Systems Corporation >>> >>> -- >>> MySQL General Mailing List >>> For list archives: http://lists.mysql.com/mysql >>> To unsubscribe: http://lists.mysql.com/mysql?unsub=lists@... >>> >>> >>> >> >> > > -- > View this message in context: > http://www.nabble.com/Frequently-MyISAM-TABLE-corruption.....Pls-help-tf3715472.html#a11391620 > Sent from the MySQL - General mailing list archive at Nabble.com. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=mysqlsupport@... > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.476 / Virus Database: 269.9.14/883 - Release Date: 7/1/2007 > 12:19 PM > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=lists@... |
| Free embeddable forum powered by Nabble | Forum Help |
