Bug #36547 SET GLOBAL ndb_extra_logging crashes mysqld
Submitted: 6 May 2008 20:12 Modified: 9 May 2008 19:09
Reporter: Jon Stephens Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:5.1-telco-6.2-bk, 5.1-telco-6.3-bk, 5.1-telco-6.4-bk, 5.1-bk OS:Linux (openSUSE 10.2/64-bit)
Assigned to: Magnus BlÄudd CPU Architecture:Any

[6 May 2008 20:12] Jon Stephens
Description:
Trying to set the value of ndb_extra_logging as a server variable crashes the server.

Makes no difference whether server was started with --ndb-extra-logging option or not.

How to repeat:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.24-ndb-6.3.13-debug Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SHOW VARIABLES LIKE 'ndb_extra%';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| ndb_extra_logging | 1     |
+-------------------+-------+
1 row in set (0.00 sec)

mysql> SET NDB_EXTRA_LOGGING=1;
ERROR 1229 (HY000): Variable 'ndb_extra_logging' is a GLOBAL variable and should be set with SET GLOBAL
mysql> SHOW VARIABLES LIKE 'ndb_extra%';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| ndb_extra_logging | 1     |
+-------------------+-------+
1 row in set (0.00 sec)

mysql> SET GLOBAL NDB_EXTRA_LOGGING=1;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> 080506 21:53:02 mysqld_safe Number of processes running now: 0
080506 21:53:02 mysqld_safe mysqld restarted

mysql> SHOW VARIABLES LIKE 'ndb_extra%';
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    2
Current database: *** NONE ***

+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| ndb_extra_logging | 1     |
+-------------------+-------+
1 row in set (0.01 sec)

mysql>                            

Suggested fix:
Variable's value should be set.

OR

User should be prevented from using this as a server variable.
[6 May 2008 21:08] Sveta Smirnova
Thank you for the report.

Verified as described.
[7 May 2008 14:44] 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/46461

ChangeSet@1.2579, 2008-05-07 16:43:32+02:00, msvensson@pilot.(none) +3 -0
  Bug#36547 SET GLOBAL ndb_extra_logging crashes mysqld
   - Change type of ndb_extr_logging variable in the args list
[8 May 2008 11:20] 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/46504

ChangeSet@1.2600, 2008-05-08 13:20:29+02:00, msvensson@pilot.(none) +3 -0
  Bug#36547 SET GLOBAL ndb_extra_logging crashes mysqld
   - Change type of ndb_extr_logging variable in the args list
[9 May 2008 10:12] Bugs System
Pushed into 5.1.24-ndb-6.2.14
[9 May 2008 10:22] Bugs System
Pushed into 5.1.24-ndb-6.3.13
[9 May 2008 17:59] Bugs System
Pushed into 5.1.23-ndb-6.4.0
[9 May 2008 19:09] Jon Stephens
Documented in the 5.1.24-ndb-6.2.16 and 5.1.24-ndb-6.3.14 changelogs as follows:

        SET GLOBAL ndb_extra_logging caused mysqld to crash.
[7 Aug 2008 13:35] 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/51102

2655 jonas@mysql.com	2008-08-07 [merge]
      merge 5.1-telco-6.2-merge to 6.0-ndb
[7 Aug 2008 13:37] 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/51103

2655 jonas@mysql.com	2008-08-07 [merge]
      merge 5.1-telco-6.2-merge to 6.0-ndb
[8 Aug 2008 9:40] 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/51181

2655 jonas@mysql.com	2008-08-08 [merge]
      merge telco-6.2-merge to 6.0-ndb - Take 2 (now using bzr merge even less)
[12 Dec 2008 23:28] Bugs System
Pushed into 6.0.6-alpha  (revid:sp1r-msvensson@pilot.(none)-20080507144332-09546) (version source revid:jonas@mysql.com-20080808094047-4e1yiarqa2t3opg3) (pib:5)