MySQL Bugs: #36547: SET GLOBAL ndb_extra

Bug #36547	SET GLOBAL ndb_extra_logging crashes mysqld
Submitted:	6 May 22:12	Modified:	9 May 21:09
Reporter:	Jon Stephens
Status:	Closed
Category:	Server: Cluster	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 Svensson	Target Version:
Triage:	D1 (Critical)

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.

Thank you for the report.

Verified as described.

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

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

Pushed into 5.1.24-ndb-6.2.14

Pushed into 5.1.24-ndb-6.3.13

Pushed into 5.1.23-ndb-6.4.0

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.

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

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

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)