When Using Foreign Keys (FKs), Data Node Crash With Internal Error 2341 In Data: DbtcMain.cpp (Doc ID 2116886.1)

Last updated on DECEMBER 28, 2016

Applies to:

MySQL Cluster - Version 7.3 to 7.5 [Release 7.3 to 7.5]
Information in this document applies to any platform.

Symptoms

Data node crashes with error:

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: DbtcMain.cpp
Error object: DBTC (Line: 18885) 0x00000002
Program: ndbmtd
Pid: 16710 thr: 0
Version: mysql-5.6.24 ndb-7.3.9
Trace: /home/iilyin/dist/mcm_data/clusters/my/2/data/ndb_2_trace.log.1[t1..t4]

The JAM Trace the internal error may look like this:

DbtcMain.cpp 04260 04313 04727 04192 04201 04229 04856 16920 04313
04727 04192 04201 04229 04856 16920 04260 04313 04727
04192 04201 04229 04856 16920 04313 04727 04192 04201
04229 04856 16920 04313 04727 04192 04201 04229 04856
16920 04260 04313 04727 04192 04201 04229 04856 16920
15310 15355 15358 15373 15396 15421 15436 16950 16956
16959 16968 17054 18290
SimulatedBlock.cpp 01820
.
--------------- Signal ----------------
r.bn: 245 "DBTC", r.proc: 4, r.sigId: 307520460 gsn: 527 "FIRE_TRIG_ORD"
prio: 1
s.bn: 249/4 "DBTUP", s.proc: 3, s.sigId: 14296819 length: 11 trace: 1 #sec: 3
fragInf: 0
TriggerId: 13 TriggerEvent: insert
UserRef: (13, 0) User data: 4b5ef
Signal: PK=2 BEFORE=0 AFTER=2
--------------- Signal ----------------
r.bn: 245 "DBTC", r.proc: 4, r.sigId: 307520459 gsn: 342 "PACKED_SIGNAL"
prio: 1
s.bn: 247/3 "DBLQH", s.proc: 4, s.sigId: 744860293 length: 7 trace: 1 #sec: 0
fragInf: 0
Signal data: H'4000018f H'0004b9e5 H'06f70004 H'00000000 H'0041aff0
H'00301400 H'00000000
--------- Begin Packed Signals --------


The issue cannot be reproduced at will, but here's a test case:

  1. Set up a 2 data node cluster
  2. Create the following tables  

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms