MySQL HEAP-table is "full"

[kullervo]

I have a MySQL 4.1.19 database with some HEAP tables. I could not insert more rows in one of the tables when it had grown to 704044 rows. The error message MySQL outputs is
"ERROR 1114 (HY000): The table 'shws' is full"

"mysql> SHOW TABLE STATUS;
+------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-------------------+----------+----------------+---------+
¦ Name ¦ Engine ¦ Version ¦ Row_format ¦ Rows ¦ Avg_row_length ¦ Data_length ¦ Max_data_length ¦ Index_length ¦ Data_free ¦ Auto_increment ¦ Create_time ¦ Update_time ¦ Check_time ¦ Collation ¦ Checksum ¦ Create_options ¦ Comment ¦
+------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-------------------+----------+----------------+---------+
¦ shws ¦ HEAP ¦ 9 ¦ Fixed ¦ 704044 ¦ 13 ¦ 11286720 ¦ 9087650 ¦ 5899448 ¦ 0 ¦ NULL ¦ NULL ¦ NULL ¦ NULL ¦ latin1_swedish_ci ¦ NULL ¦ ¦ ¦
+------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-------------------+----------+----------------+---------+
5 rows in set (0.00 sec)"

"max_heap_table_size" is 33554432 which is less then Data_length above (11286720).

What is the problem?

[justageek]

Sounds like you may have just run out of total system memory?

JAG

[kullervo]

That is not the problem. There is 8GiB unused swap. When I removed 1 row from the table, I was able to insert 1 new.

I searched mysql's bug database again and found out that this is a bug. [bugs.mysql.com...]

Thank you for the reply