- 论坛徽章:
- 0
|
请问informix本身会自动调用SQL执行查询系统表的信息吗?
下面是online.log下的,DB突然出现Page Check Error,然后重启后又发现chunk down.
Bad Page应该出现在是系统表,理由是在af.5e3987ec文件中查找到SQL:
Current SQL statement :
select count(unique tabname) from systabnames t, sysptnhdr p where
t.partnum=p.partnum and p.nextsiz > (select MAX(leng) * 2.00 from
syschfree f, syschktab c, sysdbspaces d where f.chknum=c.chknum and
c.dbsnum=d.dbsnum and d.name=DBINFO('DBSPACE',p.partnum))
online.log:
03:30:52 Assert Failed: Page Check Error in prfrexts:bad chunk free list
03:30:52 Informix Dynamic Server Version 7.31.UD3
03:30:52 Who: Session(2251304, informix@c01a03, 15437, -122263122
Thread(2251345, sqlexec, b71d8e60, 1)
File: rsdebug.c Line: 1025
03:30:52 Results: Possible inconsistencies in a Chunk Freelist page
03:30:52 Action: Run 'oncheck -ce' and/or restore affected DBSpace
03:30:52 stack trace for pid 1657 written to /home/informix/ifxdmp/af.5e3987ec
03:31:04 See Also: /home/informix/ifxdmp/af.5e3987ec, shmem.5e3987ec.0
03:32:07 Checkpoint Completed: duration was 1 seconds.
03:32:07 Checkpoint loguniq 2547535, logpos 0x4b04c
03:47:30 Event alarms enabled. ALARMPROG = '/usr/informix/etc/no_log.sh'
03:47:35 DR: DRAUTO is 0 (Off)
03:47:36 Informix Dynamic Server Version 7.31.UD3 Software Serial Number AAA#A891975
03:47:36 Assert Failed: chunk failed sanity check
03:47:36 Informix Dynamic Server Version 7.31.UD3
03:47:36 Who: Session(1, informix@c01a03, 0, -1237295080)
Thread(13, main_loop(), b63dc018, 1)
File: rspartn.c Line: 7319
03:47:36 Results: Chunk 57 is being taken OFFLINE.
03:47:36 Action: Restore chunk from archive. If this is a temporary dbspace |
|