This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Error 135 "No more room in record file" with enough space on FS

Hi,

We are operating a database with the following characteristics : - running on a 3-node cluster, - Maria DB 10.6.7 version - innoDB storage format - ubuntu 20.04

When we try to create a table in our Database, we get the following error:

create database un_test1;
Query OK, 1 row affected (0.015 sec)
use un_test1;
Database changed
CREATE TABLE `t6` ( `t6` integer );
ERROR 1005 (HY000): Can't create table `un_test1`.`t6` (errno: 135 "No more room in record file")

We proceeded to the following verifications: - Number of existing tables in the cluster = 280 - Available space on the fs = 200 GB - Full restart of the 3 nodes

We are not able to create a table in our database. The create table described above is done in an empty database. We have also tried to create a table in other databases of this cluster, with the same issue.

Does anyone have an idea on what to check, both on the cluster structure or on the OS level ?

Thanks !

Steven

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.