Table Is Full Error On a Disk Data (dd) Table (Doc ID 2090767.1)

Last updated on MARCH 09, 2017

Applies to:

MySQL Cluster - Version 6.1 and later
Information in this document applies to any platform.

Goal

Getting a "table is full" error on a disk data (dd) table:

mysql> insert into test.t1 select * from test.t2 where a=284031;
ERROR 1114 (HY000): The table 't1' is full

mysql> show warnings;
+-------+------+-----------------------------------+
| Level | Code | Message                           |
+-------+------+-----------------------------------+
| Error | 1114 | The table 't1' is full |
+-------+------+-----------------------------------+
1 row in set (0.00 sec)

Looking at the extents it seems there are no free_extents even though data has been DELETED:

mysql> SELECT file_name, file_type, total_extents, free_extents, extra FROM INFORMATION_SCHEMA.files WHERE file_type='DATAFILE';
+------------+-----------+---------------+--------------+----------------+
| file_name  | file_type | total_extents | free_extents | extra          |
+------------+-----------+---------------+--------------+----------------+
| data_1.dat | DATAFILE  | 16            | 0            | CLUSTER_NODE=4 |
| data_1.dat | DATAFILE  | 16            | 0            | CLUSTER_NODE=5 |
| data_1.dat | DATAFILE  | 16            | 0            | CLUSTER_NODE=6 |
| data_1.dat | DATAFILE  | 16            | 0            | CLUSTER_NODE=7 |
+------------+-----------+---------------+--------------+----------------+
4 rows in set (0.02 sec)

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms