Bug #69994 Unable to store fragment during LCP. NDBFS Error: 1217
Submitted: 12 Aug 2013 11:59 Modified: 13 Jan 2016 14:05
Reporter: olivier chaze Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:mysql-5.6.11 ndb-7.3.2 OS:Linux (SLC 6.2)
Assigned to: CPU Architecture:Any
Tags: NDBFS ndbmtd error1217 LCP

[12 Aug 2013 11:59] olivier chaze 
Description:
After a while all data nodes go down with the following error when using ndbmtd :

Time: Monday 12 August 2013 - 13:20:24
Status: Unknown
Message: No message slogan found (please report a bug if you get this error code) (Unknown)
Error: 1217
Error data: Unable to store fragment during LCP. NDBFS Error: 1217
Error object: DBLQH (Line: 14211) 0x00000002
Program: ndbmtd
Pid: 3666 thr: 2
Version: mysql-5.6.11 ndb-7.3.2
Trace: /var/lib/mysql-cluster/ndb_10_trace.log.4 [t1..t7]

How to repeat:
I've no idea...It happens twice in a month.
I'm not running out of memory nor disk space.
[13 Nov 2014 13:15] Mikael Ronström 
Thanks for the bug report. The bug is that while scanning the table for records to write to the LCP
we run out of operation records in DBLQH.

The workaround for you is to increase MaxNoOfConcurrentOperations.

The real fix is that we have prioritised allocation of scans for LCP since they have to work.

Thanks for reporting this issue.
[13 Jan 2016 14:05] Jon Stephens 
Duplicate of BUG#76741.