oncheck -cI dbname -y 为什么不能修复错误呢?请教高手!!!

ahui_g

informix 7,运行下面sql提示出错,$ dbaccess sales_ann << !
>; select sum(t07pmonth) from t07_annuity
>; !

Database selected.

  244: Could not do a physical-order read to fetch next row.

  172: ISAM error:  Unexpected internal error
Error in line 1
Near character position 38

Database closed.

用oncheck -cI sales_ann:t07_annuity -y,提示如下:$ pwd
/usr/informix
$ oncheck -cI sales_ann:t07_annuity -y

Validating indexes for sales_ann:salesmis.t07_annuity...
                Index  100_1
Could not check rowids and perform data<->;index check
ISAM error:  Unexpected internal error

WARNING: Check of index  100_1 was not completed.

上面的问题怎么解决阿,请高手指点.

大梦

大家快来看看呀！

muzx

把你online.log文件中与出错信息有关的内容贴出来！

netkey

有些就是没法修复，只能重建表

ahui_g

21:06:11  Assert Failed: rowalterTOTYPECHG: rvaldata for conversion from the
oldtype 0x3 to newtype 0x5 returned 0xfffffb4f

21:06:11  Informix Dynamic Server Version 7.31.UC5
21:06:11   Who: Session(639, salesmis@ytbak, 11252, 520617876)
Thread(2067, sqlexec, 1f059fdc, 1)
File: rssupp.c Line: 2658
21:06:11   Results: altering older version row to latest version failed
21:06:11   See Also: /dev/null/af.bfbe9c2, shmem.bfbe9c2.0
21:06:11  Unable to create output file '/dev/null/shmem.bfbe9c2.0' errno = 20
21:06:11  Assert Failed: read_record: decompress_row, source = 149d417d, target
= 1f53f56c
21:06:11  Informix Dynamic Server Version 7.31.UC5
21:06:11   Who: Session(639, salesmis@ytbak, 11252, 520617876)
                Thread(2067, sqlexec, 1f059fdc, 1)
                File: rsread.c Line: 2522
21:06:11   Results: Record not read
21:06:11   Action: Please notify Informix Technical Support.
21:06:11   See Also: /dev/null/af.bfbe9c2, shmem.bfbe9c2.1
21:06:11  Unable to create output file '/dev/null/shmem.bfbe9c2.1' errno = 20
21:06:11  read_record: invalid rowid = 23be04, partnum = 700319

muzx

原帖由 "ahui_g" 发表：
21:06:11 See Also: /dev/null/af.bfbe9c2, shmem.bfbe9c2.0
21:06:11 Unable to create output file '/dev/null/shmem.bfbe9c2.0' errno = 20

你的/dev/null是否被什么文件覆盖？（他还是一个设备文件吗？）
你的系统将出错信息af.bfbe9c2给扔了(/dev/null)
建议将此文件发给ibm!请求帮助!

hero99zy

Oncheck -cI 只能修复索引,如果索引也修复不了,那只能将索引删掉重新建立了.另外,如果表的数据损坏,只能从其他备份来回复.

大梦

[quote]原帖由 "hero99zy"]Oncheck -cI 只能修复索引,如果索引也修复不了,那只能将索引删掉重新建立了.另外,如果表的数据损坏,只能从其他备份来回复.[/quote 发表：
他的那个索引是系统自己建的，好象是100_1之类的，删除不掉吧！

我问了他了，他没得备份！
好惨！