Bug #36173 Issues after online table alter
Submitted: 17 Apr 2008 8:47 Modified: 23 Nov 2008 4:11
Reporter: Rocky Liu Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:mysqlcom-5.1.23-ndb-6.3.10-telco OS:Linux (Fedora Core5)
Assigned to: Assigned Account CPU Architecture:Any
Tags: add, alter, Drop

[17 Apr 2008 8:47] Rocky Liu
Description:
Hi,

We are using mysql cluster for our storage. We have Java code runing create table  commands when system starts up. While when the system upgrades, we will run the jdbc command per the version without restart my sql.
e.g when system is upgrating from 1.0.0.1 to 1.0.0.2, the sql statemens below 1.0.0.2 will be excuted through jdbc.
My issues are:
1. Only add column/drop column are used in our system. While we offten met errors like "failed to create table cm.##xxx".
After we change the sql conf, this issues seldom occur.

2. when we delete data from several tables as a transaction, we got "no record found in table ..." while we excuting update like "delete from tableX where ...". This is strange since if we just run this command self, we didnt get such error.

Thanks,
Rocky

How to repeat:
This happended in our setup. While the error is really strange and not repeatable. But the possibility we met it is very high.
[23 Oct 2008 4:11] Martin Skold
Please verify that this is a problem with online alter table,
use keyword ONLINE. Adding columns with default values will
currently not be online.
[24 Nov 2008 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".