MySQL Forums
Forum List  »  NDB clusters

Got error 1601 'Out extents, tablespace full' from NDB
Posted by: Michał Herman
Date: October 16, 2013 07:19AM

I am trying to do some tests on MySQL Cluster.
I am creating my database using following commands:

CREATE DATABASE test1;
use test1;
CREATE LOGFILE GROUP lg1
ADD UNDOFILE 'undofile.dat'
ENGINE = NDB;
CREATE TABLESPACE ts1
ADD DATAFILE 'datafile.dat'
USE LOGFILE GROUP lg1
ENGINE = NDB;
CREATE TABLE `dane` (
`id` int(11) NOT NULL,
`data` blob NOT NULL,
PRIMARY KEY (`id`)
)
TABLESPACE ts1 STORAGE DISK
engine=ndb;

Then I populate table with some data and random blobs 50KB each. But I am getting following error:

mysql> INSERT INTO dane(id, data) VALUES(3790, randomBlob(51200));
ERROR 1114 (HY000): The table 'dane' is full
mysql> show warnings;
+---------+------+--------------------------------------------------------+
| Level | Code | Message |
+---------+------+--------------------------------------------------------+
| Warning | 1296 | Got error 1601 'Out extents, tablespace full' from NDB |
| Error | 1114 | The table 'dane' is full |
+---------+------+--------------------------------------------------------+
2 rows in set (0,00 sec)

mysql> select count(*) from dane;
+----------+
| count(*) |
+----------+
| 2507 |
+----------+
1 row in set (0,03 sec)

It is not cluster memory usage problem:

ndb_mgm> ALL REPORT MEMORYUSAGE
Connected to Management Server at: localhost:1186
Node 3: Data usage is 6%(164 32K pages of total 2560)
Node 3: Index usage is 7%(178 8K pages of total 2432)

2500*50KB ~= 1GB
I have this error any time I am trying to insert more than 1GB of blobs.
How I can extend size of this tablespace?

Options: ReplyQuote


Subject
Views
Written By
Posted
Got error 1601 'Out extents, tablespace full' from NDB
2015
October 16, 2013 07:19AM


Sorry, you can't reply to this topic. It has been closed.

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.