RE: ERROR 1030: Got error 127 from table handler
Hi dathan, 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 2 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
RE: ERROR 1030: Got error 127 from table handler
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 2 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]
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 2 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]
RE: ERROR 1030: Got error 127 from table handler
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 2 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
RE: ERROR 1030: Got error 127 from table handler
hows u're disk space? -Original Message- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 19:11 To: [EMAIL PROTECTED] Subject: ERROR 1030: Got error 127 from table handler /usr/local/mysql/bin/perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed I've been getting this allot lately from mysql-3.23.54-57. Things that are not the cause: - mySQL has not been improperly shut down - threads are not being killed off Pattern emerged: High Traffic DB up for a month or greater doing a constant 300 queries/sec Question: What is the cause of a Record-file crash? How can this be prevented? Jeremy Zawodny do you have any thoughts on a root cause? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ERROR 1030: Got error 127 from table handler
FilesystemSize Used Avail Use% Mounted on /dev/sda5 97G 9.0G 82G 10% Plenty of disk space. ---Original Message- --From: Tom Roos [mailto:[EMAIL PROTECTED] --Sent: Wednesday, September 10, 2003 10:23 AM --To: Dathan Vance Pattishall; [EMAIL PROTECTED] --Subject: RE: ERROR 1030: Got error 127 from table handler -- --hows u're disk space? -- ---Original Message- --From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] --Sent: 10 September 2003 19:11 --To: [EMAIL PROTECTED] --Subject: ERROR 1030: Got error 127 from table handler -- -- -- --/usr/local/mysql/bin/perror 127 --Error code 127: Unknown error 127 --127 = Record-file is crashed -- --I've been getting this allot lately from mysql-3.23.54-57. -- -- --Things that are not the cause: -- - mySQL has not been improperly shut down -- - threads are not being killed off -- -- --Pattern emerged: --High Traffic DB up for a month or greater doing a constant 300 --queries/sec -- -- --Question: What is the cause of a Record-file crash? How can this be --prevented? Jeremy Zawodny do you have any thoughts on a root cause? -- -- -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1030: Got error 127 from table handler
What kernel are you running? Also, try increasing the max open tables. That might help. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Dathan Vance Pattishall [EMAIL PROTECTED] To: 'Tom Roos' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:28 PM Subject: RE: ERROR 1030: Got error 127 from table handler FilesystemSize Used Avail Use% Mounted on /dev/sda5 97G 9.0G 82G 10% Plenty of disk space. ---Original Message- --From: Tom Roos [mailto:[EMAIL PROTECTED] --Sent: Wednesday, September 10, 2003 10:23 AM --To: Dathan Vance Pattishall; [EMAIL PROTECTED] --Subject: RE: ERROR 1030: Got error 127 from table handler -- --hows u're disk space? -- ---Original Message- --From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] --Sent: 10 September 2003 19:11 --To: [EMAIL PROTECTED] --Subject: ERROR 1030: Got error 127 from table handler -- -- -- --/usr/local/mysql/bin/perror 127 --Error code 127: Unknown error 127 --127 = Record-file is crashed -- --I've been getting this allot lately from mysql-3.23.54-57. -- -- --Things that are not the cause: -- - mySQL has not been improperly shut down -- - threads are not being killed off -- -- --Pattern emerged: --High Traffic DB up for a month or greater doing a constant 300 --queries/sec -- -- --Question: What is the cause of a Record-file crash? How can this be --prevented? Jeremy Zawodny do you have any thoughts on a root cause? -- -- -- -- 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]
RE: ERROR 1030: Got error 127 from table handler
I'm running RedHat 7.3 distro with 2.4.18-4smp #1 SMP The table in questions is -rw-r-1 mysqlmysql8.9k Jul 26 00:23 hasit.frm -rw-r-1 mysqlmysql994M Sep 10 09:59 hasit.MYD -rw-r-1 mysqlmysql681M Sep 10 09:59 hasit.MYI my my.cnf option [mysqld] skip-innodb skip-bdb skip-name-resolve skip-locking port=3306 socket=/var/lib/mysql/mysql.sock datadir=/var/lib/mysql # Helps inserts happen much faster set-variable= key_buffer=512M # keep allot more tables in memory set-variable= table_cache=1024 #Increase this value for faster ORDER BY or GROUP BY operations set-variable= sort_buffer=64M #If you do many sequential scans, you may want to increase this value set-variable= record_buffer=16M #use for when mysql is doing a check or repair set-variable= myisam_sort_buffer_size=64M set-variable= max_allowed_packet=16M set-variable= thread_cache=8 # Try number of CPU's*2 for thread_concurrency (Might only be used for Solaris) set-variable= thread_concurrency=8 set-variable= tmp_table_size=512 set-variable = max_connections=450 set-variable = back_log=20 set-variable = max_connect_errors=400 set-variable = wait_timeout=10 This is a RAID-5 with 128MB ICP Raid Card with 4GB of memory ---Original Message- --From: Richard Gabriel [mailto:[EMAIL PROTECTED] --Sent: Wednesday, September 10, 2003 10:32 AM --To: Dathan Vance Pattishall; [EMAIL PROTECTED] --Subject: Re: ERROR 1030: Got error 127 from table handler -- --What kernel are you running? -- --Also, try increasing the max open tables. That might help. -- --Richard Gabriel --Director of Technology, --CoreSense Inc. --(518) 306-3043 x3951 -- --- Original Message - --From: Dathan Vance Pattishall [EMAIL PROTECTED] --To: 'Tom Roos' [EMAIL PROTECTED]; [EMAIL PROTECTED] --Sent: Wednesday, September 10, 2003 1:28 PM --Subject: RE: ERROR 1030: Got error 127 from table handler -- -- -- FilesystemSize Used Avail Use% Mounted on -- /dev/sda5 97G 9.0G 82G 10% -- -- Plenty of disk space. -- -- ---Original Message- -- --From: Tom Roos [mailto:[EMAIL PROTECTED] -- --Sent: Wednesday, September 10, 2003 10:23 AM -- --To: Dathan Vance Pattishall; [EMAIL PROTECTED] -- --Subject: RE: ERROR 1030: Got error 127 from table handler -- -- -- --hows u're disk space? -- -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1030: Got error 127 from table handler
Are you running linux and is it SMP? Kernel version plz.. On Wed, 10 Sep 2003, Dathan Vance Pattishall wrote: /usr/local/mysql/bin/perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed I've been getting this allot lately from mysql-3.23.54-57. Things that are not the cause: - mySQL has not been improperly shut down - threads are not being killed off Pattern emerged: High Traffic DB up for a month or greater doing a constant 300 queries/sec Question: What is the cause of a Record-file crash? How can this be prevented? Jeremy Zawodny do you have any thoughts on a root cause? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1030: Got error 127 from table handler
On Wed, Sep 10, 2003 at 10:11:15AM -0700, Dathan Vance Pattishall wrote: /usr/local/mysql/bin/perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed I've been getting this allot lately from mysql-3.23.54-57. Things that are not the cause: - mySQL has not been improperly shut down - threads are not being killed off Pattern emerged: High Traffic DB up for a month or greater doing a constant 300 queries/sec Question: What is the cause of a Record-file crash? How can this be prevented? Jeremy Zawodny do you have any thoughts on a root cause? It could be a bug that's been fixed for a while. Any chance of upgrading to 4.0.xx on that machine? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 3 days, processed 119,386,790 queries (455/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1030: Got error 127 from table handler
I have been getting the same error every so often. It is only on a machine that does about 900 queries per second average. I am running a 2.4.20 kernel with MySQL 4.0.14. This only happens with MYISAM tables and only ones with high INSERTs and SELECTs. It seemed to get better after increasing the max open tables to 512. I don't have much more info than that unfortunately. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Dathan Vance Pattishall [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:47 PM Subject: Re: ERROR 1030: Got error 127 from table handler On Wed, Sep 10, 2003 at 10:11:15AM -0700, Dathan Vance Pattishall wrote: /usr/local/mysql/bin/perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed I've been getting this allot lately from mysql-3.23.54-57. Things that are not the cause: - mySQL has not been improperly shut down - threads are not being killed off Pattern emerged: High Traffic DB up for a month or greater doing a constant 300 queries/sec Question: What is the cause of a Record-file crash? How can this be prevented? Jeremy Zawodny do you have any thoughts on a root cause? It could be a bug that's been fixed for a while. Any chance of upgrading to 4.0.xx on that machine? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 3 days, processed 119,386,790 queries (455/sec. avg) -- 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]
RE: ERROR 1030: Got error 127 from table handler
Well I don't feel that 4.0.x is mature enough for my environment quite yet, although some replication features are actually needed (2 threads are better then one). I might do a small deploy for some search system and even ratio of write / read systems. Yahoo uses 4.0.x right? Have any show stoppers been experienced since its extensive usage? Can the query cache be disabled with something like skip-query-cache? Are 127 errors less apparent in the 4.0.x environment? ---Original Message- --From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] --Sent: Wednesday, September 10, 2003 10:48 AM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re: ERROR 1030: Got error 127 from table handler -- --On Wed, Sep 10, 2003 at 10:11:15AM -0700, Dathan Vance Pattishall wrote: -- -- /usr/local/mysql/bin/perror 127 -- Error code 127: Unknown error 127 -- 127 = Record-file is crashed -- -- I've been getting this allot lately from mysql-3.23.54-57. -- -- -- Things that are not the cause: -- - mySQL has not been improperly shut down -- - threads are not being killed off -- -- -- Pattern emerged: -- High Traffic DB up for a month or greater doing a constant 300 -- queries/sec -- -- Question: What is the cause of a Record-file crash? How can this be -- prevented? Jeremy Zawodny do you have any thoughts on a root cause? -- --It could be a bug that's been fixed for a while. -- --Any chance of upgrading to 4.0.xx on that machine? -- --Jeremy --Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! --[EMAIL PROTECTED] | http://jeremy.zawodny.com/ -- --MySQL 4.0.15-Yahoo-SMP: up 3 days, processed 119,386,790 queries --(455/sec. avg) -- --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]
Re: ERROR 1030: Got error 127 from table handler
On Wed, Sep 10, 2003 at 11:01:00AM -0700, Dathan Vance Pattishall wrote: Well I don't feel that 4.0.x is mature enough for my environment quite yet, although some replication features are actually needed (2 threads are better then one). I might do a small deploy for some search system and even ratio of write / read systems. Yahoo uses 4.0.x right? Right, we have a lot of 4.0.xx deployed. Have any show stoppers been experienced since its extensive usage? None that haven't been fixed by now. I'm working with one group here to track down a problem, but we're not sure what the source is yet. Too many variables have been changed. It may be FreeBSD, MySQL, or something else odd going on. Can the query cache be disabled with something like skip-query-cache? http://www.mysql.com/doc/en/Query_Cache_Configuration.html Are 127 errors less apparent in the 4.0.x environment? I really can't make a comparison on that. But 4.0.x is significantly better and faster in many ways. I wouldn't think of going back. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 3 days, processed 119,860,849 queries (452/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1030: Got error 127 from table handler
It seems that your table has been crashed. Try to check and repair your table. tl wrote: Hello MySQL, I do select: select SUM(IF((@a:=(( ( ((@data:= DATE_FORMAT(data,'%Y-%m-%d')) IN ('2001-11-10','2001-12-22','2001-12-29')) OR (WEEKDAY(data) IN ('0','1','2','3','4')) ) AND (HOUR(data) '19' AND HOUR(data) ='8') ) AND !(@data IN ('2001-07-06','2001-08-15','2001-11-01','2001-11-02','2001-12-24','2001-12-25','2001-12-26','2001-12-31','2002-01-01','2002-03-11','2002-04-01','2002-05-01','2002-08-15','2002-11-01','2002-12-25','2002-12-26')) )),in_s,'0')) as ipm, SUM(IF(@a, ot_s,'0')) as opm, SUM(IF(!@a, in_s,'0')) as inm, SUM(IF(!@a, ot_s,'0')) as onm FROM _stat_._stat_10_4_1_10 where DATE_FORMAT(data,'%Y-%m') = '2002-05' AND DATE_FORMAT(data,'%Y-%m-%d') BETWEEN '-00-00' AND '-00-00' ; got error: ERROR 1030: Got error 127 from table handler Please, HELP ME! Thank very much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1030: Got error 127 from table handler
tl, Tuesday, June 18, 2002, 2:40:36 PM, you wrote: t I do select: t select SUM(IF((@a:=(( ( ((@data:= DATE_FORMAT(data,'%Y-%m-%d')) IN ('2001-11-10','2001-12-22','2001-12-29')) OR (WEEKDAY(data) IN ('0','1','2','3','4')) ) AND (HOUR(data) '19' AND HOUR(data) t ='8') ) AND !(@data IN t ('2001-07-06','2001-08-15','2001-11-01','2001-11-02','2001-12-24','2001-12-25','2001-12-26','2001-12-31','2002-01-01','2002-03-11','2002-04-01','2002-05-01','2002-08-15','2002-11-01','2002-12-25','2002-12-26')) t )),in_s,'0')) as ipm, SUM(IF(@a, ot_s,'0')) as opm, SUM(IF(!@a, in_s,'0')) as inm, SUM(IF(!@a, ot_s,'0')) as onm FROM _stat_._stat_10_4_1_10 where DATE_FORMAT(data,'%Y-%m') = '2002-05' AND t DATE_FORMAT(data,'%Y-%m-%d') BETWEEN '-00-00' AND '-00-00' ; t got error: t ERROR 1030: Got error 127 from table handler It means that your table is broken. Repair it using REPAIR TABLE or myisamchk utility: http://www.mysql.com/doc/R/e/Repair.html t Please, HELP ME! t Thank very much. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 1030: Got error 127 from table handler
According to perror, error 127 = Record-file is crashed. This is a symptom of a corrupted table. Check out the MySQL manual, 4.4.6.9, How to Repair Tables. Specifically, try running myisamchk on the table. --Walt Weaver Bozeman, Montana -Original Message- From: Carter, Robert L (MN65) [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 7:31 AM To: '[EMAIL PROTECTED]' Subject: ERROR 1030: Got error 127 from table handler Can anyone shed some light on this? Have found that others have run into this (via Google) but no resolution and no hits at www.mysql.com. A count(*) query returns fine but trying to select the rows fails (see log snippet below). Regards, Bob mysql select count(*) from event where sid=9 and cid 694725; +--+ | count(*) | +--+ | 4925 | +--+ 1 row in set (0.01 sec) mysql select * from event where sid=9 and cid 694725 LIMIT 0, 10; ERROR 1030: Got error 127 from table handler mysql select * from event where sid=9 and cid 694725 LIMIT 0, 10; ERROR 1030: Got error 127 from table handler mysql select * from event where sid=9 and cid 694725; ERROR 1030: Got error 127 from table handler - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 1030: Got error 127 from table handler / Optimize Table
restart the MySQL server happened to me this week when I was copying files (and changing the schema) while the server was running HTH Dave -Original Message- From: Frederic Dhorne [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 15:32 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: ERROR 1030: Got error 127 from table handler / Optimize Table Hello, I am using mysql 3.23.38 on winnt. I have a table already filled with default value, that way we do only updates during our processing. One column is specified as not null in the table definition and it's also an index. everything was working fine, Until we decided to use Optimize Table. now I am not getting anymore all the rows. Moreover in some cases, I'm getting the following error: ERROR 1030: Got error 127 from table handler. is there anyway to move around this, while I keep the call to Optimize Table? PS: myisamchk -r -q doesn't generate any trouble. Thanks - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php