Bug #69009 ndbrequire(lcpId == SYSFILE->latestLCP_ID) hit in DBDIH (Line: 14180)
Submitted: 19 Apr 2013 9:55 Modified: 19 May 2016 11:55
Reporter: Hartmut Holzgraefe Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:mysql-cluster-7.2.10 OS:Linux
Assigned to: MySQL Verification Team CPU Architecture:Any

[19 Apr 2013 9:55] Hartmut Holzgraefe 
Description:
Hit while trying to import a mysqldump 

Time: Thursday 18 April 2013 - 13:50:38
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: 14180) 0x00000002
Program: ndbmtd
Pid: 1412 thr: 0
Version: mysql-5.5.29 ndb-7.2.10
Trace: /data/mysqlcluster//ndb_6_trace.log.2 [t1..t4]

How to repeat:
No idea, only seen once so far ...
[19 Apr 2013 9:58] Hartmut Holzgraefe 
ndb_6_trace.log.2

Attachment: ndb_6_trace.log.2 (application/octet-stream, text), 1.85 MiB.
[19 Apr 2013 9:58] Hartmut Holzgraefe 
ndb_6_trace.log.2_t1

Attachment: ndb_6_trace.log.2_t1 (application/octet-stream, text), 978.27 KiB.
[19 Apr 2013 9:58] Hartmut Holzgraefe 
ndb_6_trace.log.2_t2

Attachment: ndb_6_trace.log.2_t2 (application/octet-stream, text), 1.43 MiB.
[19 Apr 2013 9:59] Hartmut Holzgraefe 
ndb_6_trace.log.2_t3

Attachment: ndb_6_trace.log.2_t3 (application/octet-stream, text), 1.44 MiB.
[19 May 2016 11:55] MySQL Verification Team 
reproducing on 7.2.10 and 7.2.12, can't reproduce on 7.2.24 nor on 7.4.10
[26 Oct 2017 8:24] Daniël van Eeden 
Something very similar happened to me with 7.6.3 (DMR).

I did an "ALTER TABLE <table> ENGINE=ndbcluster" on a 530MiB InnoDB table.
Then two data nodes (different node groups) failed.
About 30m earlier another node finished recovery after it failed for a different reason.

Time: Thursday 26 October 2017 - 10:07:15
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: 21938) 0x00000006 Check lcpId == ((Sysfile *)&sysfileData[0])->latestLCP_ID failed
Program: ndbmtd
Pid: 26658 thr: 0
Version: mysql-5.7.18 ndb-7.6.3
Trace file name: ndb_7_trace.log.2
Trace file path: /var/lib/mysql-cluster/ndb_7_trace.log.2 [t1..t18]
***EOM***

Time: Thursday 26 October 2017 - 10:06:21
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: 21938) 0x00000006 Check lcpId == ((Sysfile *)&sysfileData[0])->latestLCP_ID failed
Program: ndbmtd
Pid: 12937 thr: 0
Version: mysql-5.7.18 ndb-7.6.3
Trace file name: ndb_3_trace.log.2
Trace file path: /var/lib/mysql-cluster/ndb_3_trace.log.2 [t1..t18]
***EOM***
[20 Mar 2018 14:28] Frazer Clement 
In both cases there is some bulk insert activity occurring.

Would be good to see the trace files for the more recent reproduction.