Skip navigation links

MySQL Forums :: Cluster :: ERROR 1105 (HY000): Failed to open 'table', error while unpacking from engine


Advanced Search

ERROR 1105 (HY000): Failed to open 'table', error while unpacking from engine
Posted by: anand kumar ()
Date: March 31, 2006 11:58AM

Hi All,

I m in a deep trouble. I implemented the db cluster using 3 servers.
2 ndb nodes and 1 management server.

The cluster mode db ran for a week prefectly but with not much load.
100 TPS per day.

I put this mode for the testing purpose.

But suddenly my both to the mysql ndb server stop responding.
I restarted both of the mysql again and tried to access the record.

But everytime i ran the query on the database i got the same error.

ERROR 1105 (HY000): Failed to open 'table', error while unpacking from engine

I don't know how to recover my data.

In the clustered mode i tried not to put the big table in the ndb mode.
In the db there was a table with 3.5 million records. I made the table engine as myisam.

The rocking part is the myisam table is still existing and i am able to fetch the records.

But all the ndb engine table got corrupted.

I m right now no where. I don't know where to go.

Pls help help help

Thanks

Anand

Options: ReplyQuote


Subject Views Written By Posted
ERROR 1105 (HY000): Failed to open 'table', error while unpacking from engine 8735 anand kumar 03/31/2006 11:58AM
Re: ERROR 1105 (HY000): Failed to open 'table', error while unpacking from engine 3101 Stewart Smith 04/02/2006 06:15PM
Re: ERROR 1105 (HY000): Failed to open 'table', error while unpacking from engine 2669 anand kumar 04/07/2006 06:14AM
Re: ERROR 1105 (HY000): Failed to open 'table', error while unpacking from engine 2374 Jon Gabrielson 04/10/2006 09:31AM
Re: ERROR 1105 (HY000): Failed to open 'table', error while unpacking from engine 4087 Jon Gabrielson 04/10/2006 09:43AM
Re: ERROR 1105 (HY000): Failed to open 'table', error while unpacking from engine 2224 Jon Gabrielson 04/10/2006 10:58AM
Re: ERROR 1105 (HY000): Failed to open 'table', error while unpacking from engine 2306 anand kumar 04/10/2006 12:50PM
Re: ERROR 1105 (HY000): Failed to open 'table', error while unpacking from engine 2352 Jonathan Miller 04/11/2006 09:35PM


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.