问题解决了吗?我也碰到类似问题
mysql> insert into Billinfo values('',456,123456789,130282,222,333,'2012.3.24','2057','40','2','38','xianjin',444);
ERROR 1114 (HY000): The table 'Billinfo' is full
这时看表数据条数才53万条
mysql> select count(1) from Billinfo;
+----------+
| count(1) |
+----------+
| 537007 |
+----------+
磁盘空间也没满:
mysql> SELECT TABLESPACE_NAME, FILE_NAME, EXTENT_SIZE*TOTAL_EXTENTS/1024/1024 AS TOTAL_MB, EXTENT_SIZE*FREE_EXTENTS/1024/1024 AS FREE_MB, EXTRA FROM information_schema.FILES WHERE FILE_TYPE="DATAFILE";
+-----------------+------------+----------------+---------------+----------------+
| TABLESPACE_NAME | FILE_NAME | TOTAL_MB | FREE_MB | EXTRA |
+-----------------+------------+----------------+---------------+----------------+
| ts_1 | data_1.dat | 10240.00000000 | 9926.00000000 | CLUSTER_NODE=2 |
| ts_1 | data_1.dat | 10240.00000000 | 9927.00000000 | CLUSTER_NODE=3 |
+-----------------+------------+----------------+---------------+----------------+
2 rows in set (0.00 sec)
他表的语句为:
| Billinfo | CREATE TABLE `Billinfo` (
`bill_id` int(11) NOT NULL AUTO_INCREMENT,
`ter_id` int(11) DEFAULT NULL,
`tax_reg_id` int(11) DEFAULT NULL,
`payer_id` int(11) DEFAULT NULL,
`tem_id` int(11) DEFAULT NULL,
`tran_serial_num` int(11) DEFAULT NULL,
`date_issued` varchar(56) DEFAULT NULL,
`time_issued` varchar(56) DEFAULT NULL,
`total_in_figures` float DEFAULT NULL,
`discount_amount` float DEFAULT NULL,
`amount_receivable` float DEFAULT NULL,
`payment_type` varchar(56) DEFAULT NULL,
`cashier_num` int(11) DEFAULT NULL,
PRIMARY KEY (`bill_id`),
KEY `Billinfo_id` (`bill_id`)
) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 |
不知道是哪出问题了,请高手指点