informix出错 提示 I/O read errno=9 ？请各位帮忙，谢谢
online.log 提示I/O read chunk 18, pagenum 2, pagecnt 1 --> errno = 9
13:28:53I/O read chunk 29, pagenum 2, pagecnt 1 --> errno = 9
13:28:53I/O read chunk 77, pagenum 2, pagecnt 1 --> errno = 9
13:28:53I/O read chunk 78, pagenum 2, pagecnt 1 --> errno = 9
13:28:55I/O read chunk 77, pagenum 2, pagecnt 1 --> errno = 9
13:28:55I/O read chunk 78, pagenum 2, pagecnt 1 --> errno = 9
13:29:49I/O read chunk 29, pagenum 2, pagecnt 1 --> errno = 9
I/O read chunk 14, pagenum 5018, pagecnt 1 --> errno = 9
15:37:19I/O read chunk 14, pagenum 5018, pagecnt 1 --> errno = 9
15:37:20Assert Failed: I/O read chunk 14, pagenum 5018, pagecnt 1 --> errno =
9
15:37:20Informix Dynamic Server Version 7.31.UC5
15:37:20 Who: Session(76, data@jck, 28721, -1337456444)
Thread(133, sqlexec, b045ee5c, 1)
File: rsnode.c Line: 2228
15:37:20 Results: Delete failed
15:37:20 Action: Run 'oncheck -cI data:"data".lonal# 699_803'
15:37:22 See Also: /INFORMIXTMP/af.46d76af, shmem.46d76af.0
15:37:52Process exited with return code 1: /bin/sh /bin/sh -c /usr/informix/lo
g_full.sh 4 2 "Index failure: 'data:"data".lonal# 699_803'." "I/O read
chunk
再过一会，数据库就会down掉了，重启后访问表lonal 就不能做insert delete 等操作了 从日志上看是CHUNK出现了问题......
请先尝试使用oncheck -cI data:data 来修复可能存在的表错识.
15:37:20 Action: Run 'oncheck -cI data:"data".lonal# 699_803'
若不能修复,则需要进一步检查CHUNK所在的磁盘是否存在故障....有故障的话,可能只有从备份中恢复数据了.
页:
[1]