Bug #25275 SINGLE USER MODE prevents ALTER on non-ndb tables for other mysqld nodes
Submitted: 26 Dec 2006 5:47 Modified: 2 Apr 2007 10:40
Reporter: Sean Pringle
Status: Closed
Category:Server: Cluster Severity:S3 (Non-critical)
Version:5.0.30 OS:
Assigned to: Tomas Ulin Target Version:

[26 Dec 2006 5:47] Sean Pringle 
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.
[2 Mar 2007 3:07] 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/20967
[7 Mar 2007 5:54] 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/21320
[9 Mar 2007 1:09] Tomas Ulin 
not pushed yet
[9 Mar 2007 10:42] 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/21570
[23 Mar 2007 13:39] 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/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
[23 Mar 2007 16:54] 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/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
[28 Mar 2007 9:56] 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/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
[30 Mar 2007 10:54] Bugs System 
Pushed into 5.0.40
[2 Apr 2007 10:40] Jon Stephens 
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.