求助：执行sql语句时提示空间不足（-264），isam error -131

junxy

执行sql语句时提示空间不足，但我查看数据库空间够用，为什么？

amiescort

不是很清楚情况
是否介意给出具体的操作步骤及出错提示

onlywxw

ISAM error: no free disk space.

Not enough contiguous free disk space is available to complete the current operation. For C-ISAM programs, if transaction logging is in use, roll back the current transaction. Make some disk space available, and run the program again. For SQL products, roll back the current transaction, if possible. Contact the system administrator about acquiring more disk space for databases.
根据以上错误代号说明，看你应该怎么做，我觉得你应该先检查一下你的磁盘空间或你的文件系统有什么异常没有。

junxy

执行一个sql语句,提示: could not write to temporary file.

junxy

264 Could not write to a temporary file.

The database server created a temporary file in the directory that the DBTEMP environment variable (or /tmp by default on UNIX systems) specifies, but it encountered an error when it tried to write data into the file. Check the accompanying ISAM error code, and look for operating-system error messages that might give more information. Possibly a hardware failure occurred, or the disk is full. Since Version 5.01, the INFORMIX-SE database server uses the DBTEMP environment variable, but Informix Dynamic Server and INFORMIX-OnLine Dynamic Server do not.
但我发现tmp还有很多空间啊?

纳兰婷

是不是安装时DATA分区给少了造成的

junxy

我把数据库重起，执行提示cannot add index!索引空间还有好多！
什么原因呢？

diablocom

是不是unique的索引?
是不是里面数据本身有重复的.

大梦

临时空间小了~~~

horse

整理你的临时空间。