Bug #82103 Document DUMP 7021

Submitted: 5 Jul 2016 0:04 Modified: 21 Jul 2016 11:52
Reporter: Jesper wisborg Krogh Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Documentation Severity:S3 (Non-critical)
Version:7.4 OS:Any
Assigned to: CPU Architecture:Any

[5 Jul 2016 0:04] Jesper wisborg Krogh
Description:
Currently DUMP 7021 is not documented. DUMP 7021 is the same as DUMP 7015 but for a single table. When debugging specific tables, it can be useful to reduce the output of 7015 to just that/those table(s) in question.

DUMP 7021 takes a single table id as an argument:

shell$ ndb_show_tables
...
id    type                 state    logging database     schema   name
...
12    UserTable            Online   Yes     world        def      City

shell$ ndb_mgm -e "ALL DUMP 7021 12"
Connected to Management Server at: localhost:1186
Sending dump signal with data:
0x00001b6d 0x0000000c 
Sending dump signal with data:
0x00001b6d 0x0000000c

The Cluster log now contains something like:

2016-07-05 09:59:22 [MgmtSrvr] INFO     -- Node 1: Table 12: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2016-07-05 09:59:22 [MgmtSrvr] INFO     -- Node 1:  Fragment 0: noLcpReplicas==0  0(on 1)=32(Idle) 1(on 2)=32(Idle)
2016-07-05 09:59:22 [MgmtSrvr] INFO     -- Node 1:  Fragment 1: noLcpReplicas==0  0(on 1)=32(Idle) 1(on 2)=32(Idle)
2016-07-05 09:59:23 [MgmtSrvr] INFO     -- Node 2: Table 12: TabCopyStatus: 0 TabUpdateStatus: 0 TabLcpStatus: 3
2016-07-05 09:59:23 [MgmtSrvr] INFO     -- Node 2:  Fragment 0: noLcpReplicas==0  0(on 1)=32(Idle) 1(on 2)=32(Idle)
2016-07-05 09:59:23 [MgmtSrvr] INFO     -- Node 2:  Fragment 1: noLcpReplicas==0  0(on 1)=32(Idle) 1(on 2)=32(Idle)

How to repeat:
See http://dev.mysql.com/doc/ndbapi/en/ndb-internals-dump-commands.html - DUMP 7021 is missing.

Suggested fix:
Add a page for 7021 and probably change the page for 7015 to note it's the same as 7021 for each table and refer to 7021 for details.
[21 Jul 2016 11:52] Jon Stephens
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.