MySQL Forums
Forum List  »  Quality Assurance

Error code 1114: The table is full
Posted by: Cedric Pillonel
Date: June 15, 2012 06:02AM

When inserting a new item into a table, I get the following error:

Unable to insert into RBSRecordTable, error code 1114: The table 'RBSRecordTable' is full

select count(*) from RBSRecordTable;
+----------+
| count(*) |
+----------+
| 23967602 |
+----------+
1 row in set (0.02 sec)

I have about 24 millions entries in that table. Is that the max?

I am running MySQL 4.1.22 on RH Linux ES 4, 32bits. All my tables are using the MyISAM engine. I have enough disk space, my ibdata1 file is about 10Gb. Here is my "my.cnf" file:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
log-bin
binlog-do-db=Billing

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

The file "RBSRecordTable.MYD" is about 4GB. I think that is the problem, on linux this is the max file size. Can you confirm that the MySQL error is due to the file size limit of Linux?

Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
Error code 1114: The table is full
7560
June 15, 2012 06:02AM


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.