[Ruby] My table, it is full

[Pete Higgins]

I've run into this problem before, and it was the fault of my linux distro's default configuration for mysql. Check your mysql configuration (/etc/mysql/my.cnf on my system). Gentoo's default is to have a max of 2 gigs for innodb data, so I turned that off:

#innodb_data_file_path = ibdata1:10M:autoextend:max:2048M
innodb_data_file_path = ibdata1:10M:autoextend


Pete Higgins

-----Original Message-----
From: ruby-bounces at zenspider.com [mailto:ruby-bounces at zenspider.com] On Behalf Of John Wulff
Sent: Wednesday, October 17, 2007 1:46 PM
To: Seattle Ruby Brigade!
Subject: [Ruby] My table, it is full

I'm getting this nasty error:Mysql::Error: The table 'content_terms' is
full: INSERT INTO content_terms...

Here is some extra info:
mysql> show table status like 'content_terms';
+---------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------+
| 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              |
+---------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------+
| content_terms | InnoDB |      10 | Compact    | 1069946 |             49 |
   53035008 |               0 |     57786368 |         0 |        1244152 |
2007-10-15 10:45:58 | NULL        | NULL       | latin1_swedish_ci |
NULL |                | InnoDB free: 4096 kB |
+---------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------+
1 row in set (0.06 sec)

Any tips or direction towards an applicable reference?

Google hasn't been very helpful so far.


Thanks.

--
John Wulff
_______________________________________________
Ruby at zenspider.com - Seattle.rb non-commercial list
http://www.zenspider.com/seattle.rb
http://www.zenspider.com/mailman/listinfo/ruby