MySQL Forums
Forum List  »  NDB clusters

Re: ERROR 1105 (HY000): Failed to open 'table', error while unpacking from engine
Posted by: anand kumar
Date: April 07, 2006 06:14AM

Thanks for the reply.

1. i am using 5.0.16-standard on the linux 4.0 enterprise version.
2. Nodes stopped responding i.e connectivity lost from the management server.
3. I copied all the myisam table frm,myd etc files to this new db from the existing one. And changed the engine by using alter table name engine=ndbcluster;

Hope the information will help you to analyis the problem better.

Regards,
Anand

Database nodes were having logs. The details are as follows:

JAM CONTENTS up->down left->right ?=not block entry
BLOCK ADDR ADDR ADDR ADDR ADDR ADDR ADDR ADDR
?070048
DBTUP 028100
DBTUX 040064 080051 080067 070068 070071 070048
DBTUP 028100
DBTUX 040064 080051 080067 070068 070071 070048
DBTUP 028100
DBTUX 040064 080051 080067 070068 070071 070048
DBTUP 028100
DBTUP 028506
DBLQH 002586
DBTC 004042
DBTUP 002032
CMVMI 000481 000489
QMGR 001830 001841 001873 001880 002753 002756 002775 002777
002785 002785 002788 002785 002785 002785 002785 002785
QMGR 000151 002129 002131
QMGR 002171
DBDIH 013766 002209 002918
CMVMI 000385 000389 000403
QMGR 002232 002257 002261 002267 002269 002296 002301
QMGR 002322 002336 002336 002336 002336 002336 002336 002336
002336 002336 002336 002336 002336 002336 002336 002336
002336 002336 002336 002336 002336 002336 002336 002336
003851 003851 003851 003198
DBDIH 011678 011686 011690 011696 011699 011696 011719
QMGR 003205 003216 003254 003263 003279 003292 003355 003811
003813 003823

--------------- Signal ----------------
r.bn: 252 "QMGR", r.proc: 2, r.sigId: 738355 gsn: 343 "PREP_FAILCONF" prio: 0
s.bn: 252 "QMGR", s.proc: 2, s.sigId: 738354 length: 2 trace: 8 #sec: 0 fragInf: 0
H'00000002 H'00000002
--------------- Signal ----------------
r.bn: 252 "QMGR", r.proc: 2, r.sigId: 738354 gsn: 126 "CLOSE_COMCONF" prio: 0
s.bn: 254 "CMVMI", s.proc: 2, s.sigId: 738353 length: 19 trace: 8 #sec: 0 fragInf: 0
xxxBlockRef = (252, 2) failNo = 2 noOfNodes = 1
Nodes: 3
--------------- Signal ----------------
r.bn: 249 "DBTUP", r.proc: 2, r.sigId: 734262 gsn: 164 "CONTINUEB" prio: 1
s.bn: 249 "DBTUP", s.proc: 2, s.sigId: 734261 length: 2 trace: 0 #sec: 0 fragInf: 0
H'00000009 H'00000000
--------------- Signal ----------------
r.bn: 249 "DBTUP", r.proc: 2, r.sigId: 734261 gsn: 164 "CONTINUEB" prio: 1
s.bn: 249 "DBTUP", s.proc: 2, s.sigId: 734260 length: 2 trace: 0 #sec: 0 fragInf: 0
H'00000009 H'00000000
--------------- Signal ----------------
r.bn: 249 "DBTUP", r.proc: 2, r.sigId: 734260 gsn: 164 "CONTINUEB" prio: 1
s.bn: 249 "DBTUP", s.proc: 2, s.sigId: 734259 length: 2 trace: 0 #sec: 0 fragInf: 0
H'00000009 H'00000000
--------------- Signal ----------------
r.bn: 249 "DBTUP", r.proc: 2, r.sigId: 734259 gsn: 164 "CONTINUEB" prio: 1
s.bn: 249 "DBTUP", s.proc: 2, s.sigId: 734258 length: 2 trace: 0 #sec: 0 fragInf: 0
H'00000009 H'00000000
--------------- Signal ----------------
r.bn: 249 "DBTUP", r.proc: 2, r.sigId: 734258 gsn: 164 "CONTINUEB" prio: 1
s.bn: 249 "DBTUP", s.proc: 2, s.sigId: 734257 length: 2 trace: 0 #sec: 0 fragInf: 0
H'00000009 H'00000000
--------------- Signal ----------------
r.bn: 249 "DBTUP", r.proc: 2, r.sigId: 734257 gsn: 164 "CONTINUEB" prio: 1
s.bn: 249 "DBTUP", s.proc: 2, s.sigId: 734256 length: 2 trace: 0 #sec: 0 fragInf: 0
H'00000009 H'00000000
--------------- Signal ----------------
r.bn: 249 "DBTUP", r.proc: 2, r.sigId: 734256 gsn: 164 "CONTINUEB" prio: 1
s.bn: 249 "DBTUP", s.proc: 2, s.sigId: 734255 length: 2 trace: 0 #sec: 0 fragInf: 0
H'00000009 H'00000000
--------------- Signal ----------------
r.bn: 249 "DBTUP", r.proc: 2, r.sigId: 734255 gsn: 164 "CONTINUEB" prio: 1
s.bn: 249 "DBTUP", s.proc: 2, s.sigId: 734254 length: 2 trace: 0 #sec: 0 fragInf: 0
H'00000009 H'00000000
--------------- Signal ----------------
r.bn: 249 "DBTUP", r.proc: 2, r.sigId: 734254 gsn: 164 "CONTINUEB" prio: 1
s.bn: 249 "DBTUP", s.proc: 2, s.sigId: 734253 length: 2 trace: 0 #sec: 0 fragInf: 0
H'00000009 H'00000000
--------------- Signal ----------------
r.bn: 249 "DBTUP", r.proc: 2, r.sigId: 734253 gsn: 164 "CONTINUEB" prio: 1
s.bn: 249 "DBTUP", s.proc: 2, s.sigId: 734252 length: 2 trace: 0 #sec: 0 fragInf: 0
H'00000009 H'00000000

Options: ReplyQuote




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.