SEO

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



--
View this message in context: http://www.nabble.com/Frequently-MyI...html#a10393479
Sent from the MySQL - General mailing list archive at Nabble.com.

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

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@nabble.com
>
>
>

--
View this message in context: http://www.nabble.com/Frequently-MyI...html#a10412877
Sent from the MySQL - General mailing list archive at Nabble.com.

Some additional resources for fixing corrupt MyISAM tables:
http://dev.mysql.com/doc/refman/5.0/...-problems.html
http://dev.mysql.com/doc/refman/5.0/en/myisamchk.html
http://dev.mysql.com/doc/refman/5.0/...intenance.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@hotmail.com> 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@nabble.com
> >
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Frequently-MyI...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@gmail.com
>
>

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@nabble.com
>>
>>
>>
>
>

--
View this message in context: http://www.nabble.com/Frequently-MyI...html#a11391620
Sent from the MySQL - General mailing list archive at Nabble.com.

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/...am-tables.html about
mysqleers comments.

Thanks
ViSolve DB Team.
----- Original Message -----
From: "Nilnandan" <nandan_it@hotmail.com>
To: <mysql@lists.mysql.com>
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@nabble.com
>>>
>>>
>>>
>>
>>
>
> --
> View this message in context:
> http://www.nabble.com/Frequently-MyI...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=m...rt@visolve.com
>
>
>
> --
> 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
>
>