There is a delete bug where frequent deletes can cause table corruption. Upgrade to 4.0.18 -- I believe its been fixed by now.
> -----Original Message----- > From: Bhaskar Borthakur [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 21, 2004 1:30 PM > To: [EMAIL PROTECTED] > Subject: ERROR 1030: Got error 127 from table handler > > Hi > > I have been using MySQL server version 4.0.14 for the last six months in > our project and it was running just fine. We use Linux AS 3.0 (kernel > version 2.4.21-4.0.1.EL #1) > > However, since last week we started to get the following error : ERROR > 1030: Got error 127 from table handler ( please look below). > > This happens when we are doing some load testing on our application server > and there are around 20000 records in the table. We are doing only inserts > and deletes from the table at the total rate of around 90 operations per > second. Its has happened numerous time since the last few days. > > Could anyone please let me know why this is happening and how do i go > about > solving this. > > If I do repair table <table name>, it says that all the records are > corrupted since the pointer is outside data segment. Then it deletes all > the rows. However what I am looking for is a prevention of this problem > instead of a cure > > thanks a lot > bhaskar > > [EMAIL PROTECTED] ~]$ mysql -uccd_user -pccd_user > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 63458 to server version: 4.0.14-standard > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> use ccd_chkp_db; > 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> select * from USER_CACHE; > ERROR 1030: Got error 127 from table handler > > mysql> desc USER_CACHE; > +-----------------------+----------------------+------+-----+---------+--- > ----+ > | Field | Type | Null | Key | Default | > Extra | > +-----------------------+----------------------+------+-----+---------+--- > ----+ > | info_type | tinyint(3) unsigned | | | 0 | > | > | user_addr | varchar(64) | | PRI | | > | > | domain | varchar(255) | | PRI | | > | > | ip_version | tinyint(3) unsigned | | | 0 | > | > | ip_addr | tinyblob | | | | > | > | port | smallint(5) unsigned | | | 0 | > | > | security_key_k1 | tinyblob | | | | > | > | security_key_k2 | tinyblob | | | | > | > | reg_ttl | int(10) unsigned | | | 0 | > | > | cseq | int(10) unsigned | | | 0 | > | > | call_id | varchar(255) | | | | > | > | timestamp | int(10) unsigned | | | 0 | > | > | vocoder | smallint(5) unsigned | | | 0 | > | > | protocol_ver | tinyint(3) unsigned | | | 0 | > | > | sdb_flag | tinyint(3) unsigned | | | 0 | > | > | qsk_ttl | smallint(5) unsigned | | | 0 | > | > | time_zone | smallint(5) unsigned | | | 0 | > | > | home_carrier_id | tinyint(3) unsigned | | | 0 | > | > | current_carrier_id | tinyint(3) unsigned | | | 0 | > | > | region_id | tinyint(3) unsigned | | | 0 | > | > | omd | varchar(38) | | | | > | > | PNOffset | smallint(5) unsigned | | | 0 | > | > | sid | smallint(5) unsigned | | | 0 | > | > | nid | smallint(5) unsigned | | | 0 | > | > | restriction_size | int(10) unsigned | | | 0 | > | > | restrictions | mediumblob | YES | | NULL | > | > | request_uri_user_addr | varchar(16) | YES | | NULL | > | > | request_uri_domain | varchar(253) | YES | | NULL | > | > | subscriberId | varchar(64) | | | | > | > +-----------------------+----------------------+------+-----+---------+--- > ----+ > 29 rows in set (0.04 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
