Bug #55963 insufficient debug info when DBDICT encounters restart problem

• Submitted: 13 Aug 2010 6:38
• Modified: 14 Aug 2010 6:16
• Reporter: Jonas Oreland
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: mysql-5.1-telco-6.3
• OS: Any
• Assigned to: Jonas Oreland
• CPU Architecture: Any

[13 Aug 2010 6:38] Jonas Oreland

Description:
Sometimes, rarely, almost never, DBDICT which manages dictionary inside
ndbd, encounters error during system/node restarts

When this happens, it's almost impossible to understand what the problem is...

This patch adds a new config parameter: "DictTrace" which is an integer
specifying trace-level if DBDICT.

Default is that value is undefined, which means it will be same as before this patch.

A value of 0 - means no trace
A value of 1 - means printout (to ndb_X_out.log) create/drop table.

These are all that is currently implemented.
The tracelevel can also be set as an environment variable before starting ndbd
e.g
sh> DICT_TRACE=0 ndbd --nodaemon

How to repeat:
.

Suggested fix:
.

[13 Aug 2010 6:46] Jonas Oreland

Note: value 1 - means that create/drop is traced even when not during restart.

[13 Aug 2010 6:48] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/115637

3248 Jonas Oreland	2010-08-13
      ndb - bug#55963 - Add DictTrace config variable

[13 Aug 2010 9:09] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/115650

3249 Jonas Oreland	2010-08-13
      ndb - bug#55963 - post review, use eventlogger to get date-time too

[13 Aug 2010 9:34] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/115653

3681 Jonas Oreland	2010-08-13
      ndb - bug#55963 - 70 specific trace improvements

[13 Aug 2010 10:03] Bugs System

Pushed into mysql-5.1-telco-7.0 5.1.47-ndb-7.0.17 (revid:[e-mail]-20100813093143-349gmbpcn6j20jz1) (version source revid:[e-mail]-20100813093143-349gmbpcn6j20jz1) (merge vers: 5.1.47-ndb-7.0.17) (pib:20)

[13 Aug 2010 10:05] Bugs System

Pushed into mysql-5.1-telco-6.3 5.1.47-ndb-6.3.36 (revid:[e-mail]-20100813082428-3wqgwgwrqehc20l2) (version source revid:[e-mail]-20100813082428-3wqgwgwrqehc20l2) (merge vers: 5.1.47-ndb-6.3.36) (pib:20)

[13 Aug 2010 15:03] Jonas Oreland

pushed to 6.3.36, 7.0.17 and 7.1.6

[14 Aug 2010 6:16] Jon Stephens

Documented bugfix in the NDB-6.3.36, 7.0.17, and 7.1.2 changelogs, as follows:

      Added the DictTrace data node configuration parameter, for
      use in debugging NDB code.

Closed.

[3 Sep 2010 14:14] Jon Stephens

My previous comment contains a typo, and should have began, "Documented bugfix in the NDB-6.3.36, 7.0.17, and 7.1.6 changelogs..."; the changelog entry was added to the 7.1.6 changelog as per Jonas' comment.