MySQL Forums
Forum List  »  NDB clusters

Re: cant restore a backup
Posted by: Christian Tölle
Date: June 13, 2017 01:34AM

if i try to do it again, (after i create the database wich has temp. imported and drop it again) it stops on the same table with

"Create table `pl_new_2/def/plan_datei_version` failed: 4009: Cluster Failure"

after that, both datanodes are down!


file: ndb_4_out.log

2017-06-13 09:16:58 [ndbd] INFO -- /export/home/pb2/build/sb_0-22875044-1490679582.39/release/mysql-cluster-gpl-7.5.6/storage/ndb/src/kernel/blocks/dbdih/DbdihMain.cpp
2017-06-13 09:16:58 [ndbd] INFO -- DBDIH (Line: 24247) 0x00000002 Check false failed
2017-06-13 09:16:58 [ndbd] INFO -- Error handler shutting down system
2017-06-13 09:16:58 [ndbd] INFO -- Error handler shutdown completed - exiting
2017-06-13 09:16:58 [ndbd] ALERT -- Node 3: Forced node shutdown completed. Caused by error 2341: 'Internal program error (failed ndbrequire)(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.

exactly the same for node 4.

file: ndb_3_error.log

Time: Tuesday 13 June 2017 - 09:16:58
Status: Temporary error, restart node
Message: Internal program error (failed ndbrequire) (Internal error, programming error or missing error message, please report a bug)
Error: 2341
Error data: DbdihMain.cpp
Error object: DBDIH (Line: 24247) 0x00000002 Check false failed
Program: ndbd
Pid: 15108
Version: mysql-5.7.18 ndb-7.5.6
Trace file name: ndb_3_trace.log.2
Trace file path: /var/lib/mysql/ndb_3_trace.log.2 [t1..t1]
***EOM***

also exactly the same for node 4.



the tail of the trace_log:


--------------- Signal ----------------
r.bn: 249 "DBTUP", r.proc: 3, r.sigId: 1397043 gsn: 433 "TUPFRAGREQ" prio: 1
s.bn: 247 "DBLQH", s.proc: 3, s.sigId: 1397042 length: 12 trace: 0 #sec: 0 fragInf: 0
H'00000000 H'00f70003 H'00000000 H'000000ca H'00000001 H'00000000 H'00000000
H'00000027 H'00000000 H'ffffff00 H'00000000 H'00000001
--------------- Signal ----------------
r.bn: 247 "DBLQH", r.proc: 3, r.sigId: 1397042 gsn: 95 "ACCFRAGCONF" prio: 1
s.bn: 248 "DBACC", s.proc: 3, s.sigId: 1397041 length: 7 trace: 0 #sec: 0 fragInf: 0
H'00000000 H'ffffff00 H'00000001 H'ffffff00 H'0000004a H'ffffff00 H'00000006
--------------- Signal ----------------
r.bn: 248 "DBACC", r.proc: 3, r.sigId: 1397041 gsn: 97 "ACCFRAGREQ" prio: 1
s.bn: 247 "DBLQH", s.proc: 3, s.sigId: 1397040 length: 12 trace: 0 #sec: 0 fragInf: 0
H'00000000 H'00f70003 H'000000ca H'00000000 H'00000001 H'00000001 H'00000050
H'0000004e H'00000006 H'00000000 H'00000000 H'00000001
--------------- Signal ----------------
r.bn: 247 "DBLQH", r.proc: 3, r.sigId: 1397040 gsn: 313 "LQHFRAGREQ" prio: 1
s.bn: 250 "DBDICT", s.proc: 3, s.sigId: 1397039 length: 23 trace: 0 #sec: 0 fragInf: 0
senderData: 50332680 senderRef: fa0003 tableId: 202 fragmentId: 1 localKeyLength: 1 maxLoadFactor: 80 minLoadFactor: 78
kValue: 6 lh3DistrBits: 0 lh3PageBits: 0
keyLength: 1
maxRowsLow/High: 0/0 minRowsLow/High: 39/0
nextLCP: 0

Options: ReplyQuote


Subject
Views
Written By
Posted
1046
June 12, 2017 03:27AM
Re: cant restore a backup
670
June 13, 2017 01:34AM
535
June 13, 2017 04:07AM
454
June 13, 2017 08:39AM
591
June 13, 2017 08:39AM
502
June 13, 2017 02:17PM


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.