Bug #46298 Cluster log stats has aborted counts for PK reads on table with CLOB column
Submitted: 20 Jul 2009 6:22 Modified: 11 Aug 2009 9:30
Reporter: Alexander Yu Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:mysql-5.1-telco-7.0 OS:Any
Assigned to:
Tags: cluster log, MySQL Cluster
Triage: Triaged: D4 (Minor) / R6 (Needs Assessment) / E6 (Needs Assessment)

[20 Jul 2009 6:22] Alexander Yu
Description:

The cluster log statistics shows erroneous 'Abort Count' when doing PK reads on table with CLOB column.

--
2009-07-20 08:07:39 [MgmSrvr] INFO     -- Node 4: Trans. Count = 5280, Commit Count = 0, Read Count = 5280, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 15840, Concurrent Operations = 0, Abort Count = 5281 Scans = 0 Range scans = 0
2009-07-20 08:07:42 [MgmSrvr] INFO     -- Node 4: Operations=5201
2009-07-20 08:07:43 [MgmSrvr] INFO     -- Node 3: Operations=0
2009-07-20 08:07:43 [MgmSrvr] INFO     -- Node 3: Trans. Count = 0, Commit Count = 0, Read Count = 0, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 0, Concurrent Operations = 0, Abort Count = 0 Scans = 0 Range scans = 0
2009-07-20 08:07:44 [MgmSrvr] INFO     -- Node 4: Trans. Count = 5164, Commit Count = 0, Read Count = 5164, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 15492, Concurrent Operations = 1, Abort Count = 5163 Scans = 0 Range scans = 0
2009-07-20 08:07:47 [MgmSrvr] INFO     -- Node 4: Operations=5220
2009-07-20 08:07:48 [MgmSrvr] INFO     -- Node 3: Operations=0
2009-07-20 08:07:48 [MgmSrvr] INFO     -- Node 3: Trans. Count = 0, Commit Count = 0, Read Count = 0, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 0, Concurrent Operations = 0, Abort Count = 0 Scans = 0 Range scans = 0
2009-07-20 08:07:49 [MgmSrvr] INFO     -- Node 4: Trans. Count = 5305, Commit Count = 0, Read Count = 5305, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 15915, Concurrent Operations = 0, Abort Count = 5306 Scans = 0 Range scans = 0
2009-07-20 08:07:52 [MgmSrvr] INFO     -- Node 4: Operations=5340
2009-07-20 08:07:53 [MgmSrvr] INFO     -- Node 3: Operations=0
2009-07-20 08:07:53 [MgmSrvr] INFO     -- Node 3: Trans. Count = 0, Commit Count = 0, Read Count = 0, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 0, Concurrent Operations = 0, Abort Count = 0 Scans = 0 Range scans = 0
2009-07-20 08:07:54 [MgmSrvr] INFO     -- Node 4: Trans. Count = 5297, Commit Count = 0, Read Count = 5297, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 15891, Concurrent Operations = 0, Abort Count = 5297 Scans = 0 Range scans = 0

How to repeat:
create table t1 (id int auto_increment primary key, name text) engine ndb;
insert into t1(name) values ('1234567890');
insert into t1(name) select name from t1;
..

mysqlslap --create-schema=test --query='select * from t1 where id=40' --iterations=10000

Suggested fix:
Fix log output.
[10 Aug 2009 19:04] Sveta Smirnova
Thank you for the report.

Please confirm if you mean " erroneous 'Abort Count'" are 'Abort Count' values greater than 0
[11 Aug 2009 9:30] Sveta Smirnova
No feedback needed. Verified as described.