请教informix高手,程序做insert 操作偶尔出 -271 错误。

henrytian

请教informix高手,程序做insert 操作偶尔出 -271 错误，检查数据库空间，没有问题，所的最大数量配置为100万个。请教高手，谁预见过此等错误，如何解决，谢谢！！

findufo

1。onstat -d 检查相关的CHUNKS是否有空间
2。排除锁表的可能，过一会儿再试

参考下面：
First, confirm that your table file is not corrupted or truncated by using the bcheck or secheck utilities. If you have verified the file's integrity, then the most likely cause of your problem is that you have locked your table file or a record within the table. This is a normal event in multi-user programs; generally you can recover by rolling back the current transaction, waiting a short time, and then re-executing the transaction. Here are some specifics:

For interactive SQL, redo the operation.

henrytian

谢谢，
我查过，
它是偶尔出，重做一次就好了！！

henrytian

但，如何避免这种错误呢？

wjj9912130

注意自已的作業.
主要是鎖表了.

mxf6666

估计是索表！

ifx

看看ISAM错误号

zhan_yl

有可能是你操作的表被别人锁住，你检查以下你的交换空间是不是比较小，交换空间不够也会报full disk