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