Bug #25117 mysql hangs if during creating logfile group or tablespace one ndbd was stopped

Submitted: 17 Dec 2006 8:19 Modified: 26 Dec 2006 16:32
Reporter: Serge Kozlov Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Disk Data Severity:S3 (Non-critical)
Version:mysql-5.1 OS:Linux (Linux FC4)
Assigned to: Assigned Account CPU Architecture:Any
Tags: 5.1.15-bk

[17 Dec 2006 8:19] Serge Kozlov
Description:
There is a cluster with 2 replicas and 2 data nodes. Mysql hangs if during creating files of logfile group or tablespace the data node was stopped.

How to repeat:
1. Start cluster.

2. Start mysql (client):
 ./mysql -uroot

3. Start ndb_mgm

4. Try to create log file group:

mysql> create logfile group lg1 add undofile 'undofile.dat' initial_size 100M undo_buffer_size 1 engine=ndb;

5. Stop one data node during creating logfile group. 

6. Results are:
 a) In fact undofile.dat is created but not available.
 b) Stopped node couldn't start again
 c) Cluster log contains following records:
2006-12-15 09:14:03 [MgmSrvr] INFO     -- Node 2: DICT: lock bs: 1 ops: 1 poll:
1 cnt: 320 queue: 3
2006-12-15 09:14:10 [MgmSrvr] INFO     -- Node 2: DICT: lock bs: 1 ops: 1 poll:
1 cnt: 384 queue: 3
2006-12-15 09:14:17 [MgmSrvr] INFO     -- Node 2: DICT: lock bs: 1 ops: 1 poll:
1 cnt: 448 queue: 3
2006-12-15 09:14:24 [MgmSrvr] INFO     -- Node 2: DICT: lock bs: 1 ops: 1 poll:
1 cnt: 512 queue: 3
2006-12-15 09:15:19 [MgmSrvr] INFO     -- Node 2: DICT: lock bs: 1 ops: 1 poll:
1 cnt: 1024 queue: 3
[17 Dec 2006 8:53] Serge Kozlov
I stopped non-master node

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.