Bug #18537 Creating tables are interrupting if in that time stop Master node

• Submitted: 27 Mar 2006 10:44
• Modified: 29 Mar 2006 7:25
• Reporter: Serge Kozlov
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S2 (Serious)
• Version: 5.1.9 (beta)
• OS: Linux (FC4)
• CPU Architecture: Any

[27 Mar 2006 10:44] Serge Kozlov

Description:
Run load_tpcb.pl script abd try to stop Master ndbd node. Following error appears: 

DBD::mysql::st execute failed: Can't create table 'TPCB.history' (errno: 702) at
 ./load_tpcb.pl line 285.
Create Table Error: Can't create table 'TPCB.history' (errno: 702) at ./load_tpc
b.pl line 285.

How to repeat:
1. Start cluster witj 2 replicas and 2 ndbd nodes
2. Run ndb_mgm
3. Run ./load_tpcb.pl ndb16 3306 root BLANK ndb
4. Try stop the master node (_id_ STOP) when load_tpcb.pl is still creating tables.
5. load_tpcb.pl interupted with 702 .

[27 Mar 2006 18:59] Jonas Oreland

Schema operation is currently not node fail safe.
The exptected behavior is that if master node fails,
  then dictionary is locked.

This should be documented if it's not the case.

There is a WL for making dict NF safe

[27 Mar 2006 19:38] Serge Kozlov

Such behaviour is correct for cluster with 2 replicas and 2 ndbd nodes?

[29 Mar 2006 7:25] Jon Stephens

Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).

Additional info:

Added info as item to 4.1/5.0/5.1 Cluster Limitations. Closed bug.

[29 Mar 2006 7:30] Jon Stephens

Changed claissification to Server:Docs.