Informix无法启动,请教高手解答!
在informix中执行长事务load命令的时候遇到中断,数据库就无法启动:具体情况如下:
用onmode -ky将数据库关闭,在初始化的时候就报rootvg太小,但是数据库的参数并没有改动过,然后进入startup菜单执行初始化就报错:Unable to open input file 's'
Unable to open input file 'c'
然后/tmp目录的文件迅速增长,很快就100%,整个屏幕就不断的闪烁显示:
/home/informix/etc/evidence.sh: There is not enough space in the file system
然后查看online.log 文件
显示为:
10:01:52Informix Dynamic Server Version 7.31.UC5
10:01:52 Who: Session(11, informix@wzcbM85, 0, 1879538260)
Thread(45, xchg_1.8, 700573bc, 3)
File: rstrans.c Line: 2197
10:01:52 Results: Log record (OLDRSAM:HINSERT) in log 1822, offset 0x3c7c40 wa
s not rolled back
10:01:52 Action: Use 'onlog' to view the transaction and repair manually.
10:01:56 See Also: /tmp/af.415b792, shmem.415b792.11
10:01:56Error writing '/tmp/shmem.415b792.11' errno = 28
10:01:56Assert Failed: Rollback error 126
10:01:56Informix Dynamic Server Version 7.31.UC5
10:01:56 Who: Session(11, informix@wzcbM85, 0, 1879538260)
Thread(45, xchg_1.8, 700573bc, 3)
File: rsextlog.c Line: 1450
10:01:56 Results: Log record (OLDRSAM:HINSERT) in log 1822, offset 0x3c7c40 wa
s not rolled back
10:01:56 Action: Use 'onlog' to view the transaction and repair manually.
现在不知道怎么解决了,请高手指点!
回复 #1 ycc21 的帖子
/home/informix/etc/evidence.sh只是在数据库异常时收集当时的数据库状态，但是你的/tmp文件系统太小了，确实写不完。rootvg不足是操作系统还是数据库报？估计数据库在长事务回滚时出错或被kill掉了，把/tmp清理一下加大一下，看看提示的那个af开头的文件。 先扩一下/tmp再说吧
页:
[1]