thanks for your help. I am planning to test it out with a 4.0.18 server and see if the problem still persists.
I also went through all the bug fix reports in the link you sent below, however I could not find any bug fix related to this problem from 4.0.14, 15,16,17. I would appreciate it very much if you could let me know the bug fix number.
thanks again. bhaskar
At 05:51 PM 4/21/2004 -0700, Dathan Vance Pattishall wrote:
http://dev.mysql.com/doc/mysql/en/News-4.0.x.html
> -----Original Message----- > From: Bhaskar Borthakur [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 21, 2004 4:45 PM > To: Dathan Vance Pattishall; [EMAIL PROTECTED] > Subject: RE: ERROR 1030: Got error 127 from table handler > > At 04:42 PM 4/21/2004 -0700, Dathan Vance Pattishall wrote: > >There is a delete bug where frequent deletes can cause table corruption. > >Upgrade to 4.0.18 -- I believe its been fixed by now. > > > Is there a bug fix list that I can lookup on the net to make sure that > this > error has been fixed? > > thanks > bhaskar > > > > > -----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]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
