MySQL Forums
Forum List  »  MyISAM

Error 127 / Error_code: 1030
Posted by: Andrew Hunt
Date: June 06, 2006 11:27AM

I'm hoping that somebody here may be familiar with this issue, as specific information seems fairly obscure.

We've got a Master --> Slave replication setup using MySQL 4.1.19 on RHES 4. The master server processed a query with no problems, however it's causing the slave to choke producing the following error:

[ERROR] Slave: Error 'Got error 127 from storage engine' on query. Default database: 'newco'. Query: 'UPDATE LOW_PRIORITY merged_stat_session SET end_date = 1148507735, total_pages_website = total_pages_website + 1 WHERE session_key = '9109A169914391026818C2AC0D24F025.worker2'', Error_code: 1030

This is a fairly common query format for out system and has not created any problems in the past. From what I have been able to track down online the error code 1030 translates to:

#
Error: 1030 SQLSTATE: HY000 (ER_GET_ERRNO)
Message: Got error %d from storage engine

Suggested fixes I've encountererd have ranged everywhere from repairing the table (which checks out as perfectly fine now) to increasing the max_row_length setting. I'm starting to grasp at straws here trying to track down the root of the problem, so if anybody has any thoughts to point me in the right direction, it would be greatly appreciated.

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Error 127 / Error_code: 1030
6579
June 06, 2006 11:27AM
2749
June 08, 2006 12:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.