1 message in com.mysql.lists.clusterFailed to alloc log space for drop ta...
FromSent OnAttachments
Abhijat Vatsyayan12 Mar 2008 00:06 
Subject:Failed to alloc log space for drop table: 236 ERROR
From:Abhijat Vatsyayan (abhi@gmail.com)
Date:03/12/2008 12:06:29 AM
List:com.mysql.lists.cluster

I am using mysql-5.1.23-rc-linux-i686-glibc23 on CentOS 5 and trying to setup a cluster of 2 data nodes, 2 management nodes and 2 SQL nodes using cluster disk data tables. After importing about 70 tables and corresponding data, I get "ERROR 1005 (HY000) at line 1: Can't create table ..(errno: 136)". When I look into the cluster logs, I see "Failed to alloc log space for drop table: 236 ERROR ". How do I change the size of log space? I tried the usual google searches and searches on MySQL website but looks like I am not using the correct search terms.

Here is how I am creating my disk data objects

CREATE LOGFILE GROUP hp_proto ADD UNDOFILE 'hp_proto_undo_1.dat'

INITIAL_SIZE 2048M

UNDO_BUFFER_SIZE 32M

ENGINE NDB;

ALTER LOGFILE GROUP hp_proto ADD UNDOFILE 'hp_proto_undo_2.dat' INITIAL_SIZE 2048M

ENGINE NDB;

CREATE TABLESPACE hp_proto_ts ADD DATAFILE 'hp_proto_data_1.dat' USE LOGFILE GROUP hp_proto

INITIAL_SIZE 4048M ENGINE=NDB;

ALTER TABLESPACE hp_proto_ts ADD DATAFILE 'hp_proto_data_2.dat'

INITIAL_SIZE 4048M ENGINE=NDB;

Which log space does the message "Failed to alloc log space for drop table:" refer to and how do I configure it (increase it I suppose)?

Abhijat