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
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)
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
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?
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]
ERROR 1030: Got error 127 from table handler?
Hi everyone! I recently bought Mr. DuBois' MySQL book and got through the tutorials just fine. Since I wanted to venture into the wild without the help of the tutorials, I decided to make a project of my own. I have a guitar magazine collection with song transcriptions and all; I own around 60 so everytime I want to look up a song I have to go through most of the mags to find the song I'm looking for. Enter MySQL! I created a DB called 'tabs' and three tables: 'artist', 'song' and 'mag'. On the 'artist' table I have two columns: artist_name and artist_id, the latter is not null by default and auto incremented. On 'mag', I have five columns: mag_name, month, year, song_id and artist_id. And on 'song', song_name and song_id. As you can see, 'mag' is the link between 'artist' and 'song'. I started going through every magazine adding rows to every table succesfully. I ran test queries using the 'source' command and a text file. Everything was working just fine at that point. On day 3, I was almost done adding all the records to the tables when I ran a test query and all off a sudden I get a ERROR 1030: Got error 127 from table handler error message. I hadn't experienced ANY errors up to this point. The weird thing is I only got this type of message on the 'mag' and 'song' tables; 'artist' works just fine. I get this error message even with ordinary 'SELECT * FROM mag;' queries. As far as I know, all the tables are of the same kind: MySQL standard table type. So, MySQL gurus out there... what can I do to solve this problem? Is there a way I can recover all the info I added on the 'mag' and 'song' tables? Thanx in advance! - Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month!
re: Re: What is the cause (and the fix) for Error 1030: Got error 127 from table handler ...?
On Thursday 20 March 2003 21:56, dleetest at kw dot com wrote: It seems that this error occurs only when I try to access mysql tables with many rows. Just wonder if anyone knows what is the cause and how to prevent it. There are a lot of possible causes. Check these link, they can help you to find causes of table coruption: http://www.mysql.com/doc/en/Corrupted_MyISAM_tables.html http://www.mysql.com/doc/en/Crashing.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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: What is the cause (and the fix) for Error 1030: Got error 127 from table handler ...?
It seems that this error occurs only when I try to access mysql tables with many rows. Just wonder if anyone knows what is the cause and how to prevent it. Thanks in advance! Danny - 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
ERROR 1030: Got error 127 from table handler
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
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
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
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
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 - 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
ERROR 1030: Got error 127 from table handler
Hi folks! I have a question for you all... I've got two separate mysql servers running on one machine. Both are 3.22.23b but used for separate instances of separate webservers. I'm having trouble with the 1030: Got error 127 from table handler error on only one of the servers. Here's the scoop. I get the error when I combine running a slow query (one that takes a couple of seconds to actually execute) and then another query that hits the same table. If I start the slow query in one instance of the mysql client and then the other query in another instance of the client (connecting to the same server) the first will proceed and the second will give the 1030 error. When the slow query is not running if I run the second query it executes and returns results without a problem. Now the confusing thing is that only one of the two servers is showing this problem. I was wondering if someone could help point me in the direction of figuring out what the difference is in the configuration so that I can fix the one! Thanks, -Chris - This message was sent using WebMail Pro. http://webmail.hostnoc.net/ - 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
Ideas?: ERROR 1030: Got error 127 from table handler
Is there a common cause to the following problem?: mysql select parent_referral from referral; ERROR 1030: Got error 127 from table handler I can run a describe on the table and I can sucessfully run: select count(*) from referral but if I try to actually query the data in the table I get the above problem. Our system is running 3.22.23b and we're only having the problem with the largest table in our database (it's got about 75k records in it with 13 fields total file size of the ISD is about 65 megs) -Chris - 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: Ideas?: ERROR 1030: Got error 127 from table handler
Is there a common cause to the following problem?: mysql select parent_referral from referral; ERROR 1030: Got error 127 from table handler chris@mirage:~$ perror 127 Error code 127: Unknown error: 127 127 = Record-file is crashed chris@mirage:~$ Our system is running 3.22.23b and we're only having the problem with the largest table in our database (it's got about 75k records in it with 13 fields total file size of the ISD is about 65 megs) Since you're using 3.22, you can use isamchk to repair the table. Check http://www.mysql.com/doc/R/e/Repair.html, most of the information there is the same except you can't use REPAIR TABLE with 3.22, and you have to replace myisamchk with isamchk. - 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
Problem with corrupted System (internal error 1030:Got error 127 from table handler)
Hi again, I've sorted this problem out by rtfm. Used 'REPAIR TABLE tablename' and got most of the records back. regards, Dave database,sql,query -- Don't hit me!! I'm in the Twilight Zone!!! email: [EMAIL PROTECTED] web: www.largesalad.co.uk/DJMsoft - 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
Problem with corrupted System (internal error 1030:Got error 127 from table handler)
Hi, A client has had some sort of disk failure and several files from one of my projects disappeared or were corrupted along with some system files I have replaced the files from my own backups and have the web/php based interface working again, but I get the following when trying to access mysql: internal error 1030:Got error 127 from table handler This occurs whether using the web/php based interface, mysqladmin or direct in mysql. A system of elimination shows that one particular table is corrupt. All records up to a certain 'id' can be retrieved, beyond this, the above error occurs. It obviously doesn't allow any sort of wild card or camparison select to work. Is there any way to restore this table short of dropping and re-creating? Please CC me as I am not subscribed to the list. TIA Dave -- Don't hit me!! I'm in the Twilight Zone!!! email: [EMAIL PROTECTED] web: www.largesalad.co.uk/DJMsoft - 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
ERROR 1030: Got error 127 from table handler
ERROR 1030: Got error 127 from table handler I get this error when I try to execute SQL statements using any of my tables I'm terrified that I've lost all my data If you know how I can fix this up please email me [EMAIL PROTECTED] asap Thanks, Lido - 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
