MySQL Bugs: #25275: SINGLE USER MODE prevents ALTER on non-ndb tables for other mysqld nodes

Bug #25275	SINGLE USER MODE prevents ALTER on non-ndb tables for other mysqld nodes
Submitted:	26 Dec 2006 4:47	Modified:	2 Apr 2007 8:40
Reporter:	Sean Pringle	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	5.0.30	OS:
Assigned to:	Tomas Ulin	CPU Architecture:	Any

Description:
Entering SINGLE USER MODE for one mysqld node prevents any other mysqld node from altering any local myisam tables and returns a non-intuitive error message.

How to repeat:
On mysqld node id 4:

CREATE TABLE ndb_table (id int auto_increment primary key) engine=ndb;

On mysqld node id 5:

CREATE TABLE myisam_table (id int auto_increment primary key) engine=myisam;

On mgmd node:

ENTER SINGLE USER MODE 4

On mysqld node id 5:

ALTER TABLE myisam_table ADD stuff int;

Example error message:

ERROR 1050 (42S01): Table '#sql-423c_2' already exists

Suggested fix:
The error message probably indicates a temporary table could not be created during the alter process? In the context of ALTER TABLE the error message is not very intuitive.

If this is a limitation of ALTER TABLE in SINGLE USER MODE (ie, the same root cause as bug #12365 [http://bugs.mysql.com/12365] for CREATE TABLE?) then perhaps it could simply be documented as such in the manual, 15.7.4. Single User Mode.

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/20967

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/21320

not pushed yet

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/21570

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/22768

ChangeSet@1.2397, 2007-03-23 13:52:03+01:00, tomas@whalegate.ndb.mysql.com +13 -0
  Bug #25275 SINGLE USER MODE prevents ALTER on non-ndb tables for other mysqld nodes

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/22795

ChangeSet@1.2398, 2007-03-23 17:07:33+01:00, tomas@whalegate.ndb.mysql.com +1 -0
  Bug #25275 SINGLE USER MODE prevents ALTER on non-ndb tables for other mysqld nodes

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/23108

ChangeSet@1.2423, 2007-03-28 10:10:27+02:00, tomas@whalegate.ndb.mysql.com +2 -0
  Bug #25275 SINGLE USER MODE prevents ALTER on non-ndb tables for other mysqld nodes
  - test case

Pushed into 5.0.40

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented bigfix in 5.0.40 changelog.

NOTE: This bug did not appear to affect 5.1.