informix 错误，附日志，帮忙看一下

uuuvvv

09:14:38  Checkpoint Completed:  duration was 0 seconds.
09:19:38  Checkpoint Completed:  duration was 0 seconds.
09:23:36  I/O read chunk 3, pagenum 1290, pagecnt 1 --> errno = 5
09:23:43  I/O read chunk 4, pagenum 982765, pagecnt 1 --> errno = 5
09:23:44  I/O read chunk 4, pagenum 595168, pagecnt 1 --> errno = 5
09:23:55  I/O read chunk 4, pagenum 595168, pagecnt 1 --> errno = 5
09:23:58  I/O read chunk 3, pagenum 586, pagecnt 1 --> errno = 5
。。。。
09:24:29  I/O read chunk 3, pagenum 586, pagecnt 1 --> errno = 5
09:24:29  I/O read chunk 4, pagenum 982765, pagecnt 1 --> errno = 5
09:24:38  Checkpoint Completed:  duration was 0 seconds.
09:25:40  I/O read chunk 3, pagenum 632, pagecnt 1 --> errno = 5
09:25:40  I/O read chunk 4, pagenum 622765, pagecnt 1 --> errno = 5
09:25:45  I/O read chunk 1, pagenum 125532, pagecnt 1 --> errno = 5
09:25:45  Assert Failed: Dynamic Server must abort
09:25:45  Informix Dynamic Server Version 7.31.FC5   
09:25:45   Who: Session(184, apps@tasvr1, 21005, 42527904)
                Thread(535, sqlexec, 2028590b8, 1)
                File: rslog.c Line: 3180
09:25:45   Results: Dynamic Server must abort
09:25:45   Action: Reinitialize shared memory
09:25:53   See Also: /tmp/af.5ff5e2a, shmem.5ff5e2a.0
09:25:59  rslog.c, line 3180, thread 535, proc id 1724, Dynamic Server must abort.
09:25:59  PANIC: Attempting to bring system down

Wed Jan 11 09:35:12 2006

09:35:12  Event alarms enabled.  ALARMPROG = '/usr/informix/etc/no_log.sh'
09:35:12  rsinit: Can not open /dev/sysdev0, not reading time from kernel memory.
09:35:12  Timer_vp: Can not open /dev/sysdev0, not reading time from kernel memory
09:35:17  DR: DRAUTO is 0 (Off)
09:35:18  Informix Dynamic Server Version 7.31.FC5    Software Serial Number AAC#J617441
09:35:49  (7) connection rejected - no calls allowed for sqlexec
09:35:49  listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

09:35:50  ( connection rejected - no calls allowed for sqlexec
09:35:50  listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

09:35:51  (9) connection rejected - no calls allowed for sqlexec
09:35:51  listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

。。。。。

09:36:22  (49) connection rejected - no calls allowed for sqlexec
09:36:22  listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.

09:36:22  Informix Dynamic Server Initialized -- Shared Memory Initialized.
09:36:22  Physical Recovery Started.
09:36:23  Physical Recovery Complete: 0 Pages Restored.
09:36:23  Logical Recovery Started.
09:36:42  I/O read chunk 4, pagenum 622574, pagecnt 1 --> errno = 5
09:36:43  Assert Failed: Rowid 0x7c01 not found for delete in partnum 200028, key 5
09:36:43  Informix Dynamic Server Version 7.31.FC5   
09:36:43   Who: Session(53, informix@tasvr1, 0, 4252972
                Thread(28, fast_rec, 202857be8, 1)
                File: rsnode.c Line: 2227
09:36:43   Results: Delete failed
09:36:43   Action: Run 'oncheck -cI test:"apps".acctdetail#acctdet_idx3'
09:36:50   See Also: /tmp/af.4046129, shmem.4046129.0
09:36:52  Assert Failed: No Exception Handler
09:36:52  Informix Dynamic Server Version 7.31.FC5   
09:36:52   Who: Session(53, informix@tasvr1, 0, 4252972
                Thread(28, fast_rec, 202857be8, 1)
                File: mtex.c Line: 446
09:36:52   Results: Exception Caught. Type: MT_EX_OS, Context: mem
09:36:52   Action: Please notify Informix Technical Support.

Wed Jan 11 09:45:41 2006

09:45:41  Event alarms enabled.  ALARMPROG = '/usr/informix/etc/no_log.sh'
09:45:41  rsinit: Can not open /dev/sysdev0, not reading time from kernel memory.
09:45:41  Timer_vp: Can not open /dev/sysdev0, not reading time from kernel memory
09:45:47  DR: DRAUTO is 0 (Off)
09:45:47  Informix Dynamic Server Version 7.31.FC5    Software Serial Number AAC#J617441
09:46:52  Informix Dynamic Server Initialized -- Shared Memory Initialized.
09:46:52  Physical Recovery Started.
09:46:52  Physical Recovery Complete: 0 Pages Restored.
09:46:52  Logical Recovery Started.
09:46:55  Logical Recovery Complete.
        9 Committed, 1 Rolled Back, 0 Open, 0 Bad Locks

09:46:55  Onconfig parameter CDR_LOGDELTA modified from 3 to 30.
09:46:55  Dataskip is now OFF for all dbspaces
09:46:56  On-Line Mode
09:46:56  Checkpoint Completed:  duration was 0 seconds.
09:49:35  I/O read chunk 3, pagenum 2735, pagecnt 1 --> errno = 5
09:49:37  I/O read chunk 4, pagenum 596658, pagecnt 1 --> errno = 5
09:49:40  I/O read chunk 3, pagenum 2719, pagecnt 1 --> errno = 5
09:49:41  I/O read chunk 3, pagenum 46, pagecnt 1 --> errno = 5
09:49:41  Assert Failed: pthdrpage:ptalloc:bad bfget
09:49:41  Informix Dynamic Server Version 7.31.FC5   
09:49:41   Who: Session(14, apps@tasvr1, 1932, 42528816)
                Thread(46, sqlexec, 2028582d8, 1)
                File: rspartn.c Line: 5408
09:49:41   Results: Cannot use TBLSpace page for TBLSpace 2097195
09:49:41   Action: Run 'oncheck -pt 2097195'
09:49:42   See Also: /tmp/af.416642f
09:49:43  I/O read chunk 4, pagenum 984249, pagecnt 1 --> errno = 5
09:49:47  I/O read chunk 3, pagenum 46, pagecnt 1 --> errno = 5
09:49:47  Assert Failed: pthdrpage:ptalloc:bad bfget
09:49:47  Informix Dynamic Server Version 7.31.FC5   
09:49:47   Who: Session(14, apps@tasvr1, 1932, 42528816)
                Thread(46, sqlexec, 2028582d8, 1)
                File: rspartn.c Line: 5408
09:49:47   Results: Cannot use TBLSpace page for TBLSpace 2097195
09:49:47   Action: Run 'oncheck -pt 2097195'
09:49:48   See Also: /tmp/af.416642f
09:49:54  I/O read chunk 4, pagenum 983450, pagecnt 1 --> errno = 5
09:49:54  I/O read chunk 4, pagenum 984191, pagecnt 1 --> errno = 5
09:50:00  I/O read chunk 4, pagenum 627493, pagecnt 1 --> errno = 5
09:50:20  I/O read chunk 4, pagenum 981360, pagecnt 1 --> errno = 5
09:50:25  I/O read chunk 4, pagenum 639333, pagecnt 1 --> errno = 5
09:50:27  I/O read chunk 4, pagenum 984191, pagecnt 1 --> errno = 5
09:50:30  I/O read chunk 4, pagenum 641051, pagecnt 1 --> errno = 5
09:50:32  I/O read chunk 4, pagenum 983216, pagecnt 1 --> errno = 5
09:50:35  I/O read chunk 1, pagenum 125602, pagecnt 1 --> errno = 5
09:50:36  Assert Failed: Dynamic Server must abort
09:50:36  Informix Dynamic Server Version 7.31.FC5   
09:50:36   Who: Session(16, apps@tasvr1, 1777, 42529272)
                Thread(48, sqlexec, 2028590b8, 1)
                File: rslog.c Line: 3180
09:50:36   Results: Dynamic Server must abort
09:50:36   Action: Reinitialize shared memory
09:50:43   See Also: /tmp/af.4186431, shmem.4186431.0
09:50:47  rslog.c, line 3180, thread 48, proc id 1670, Dynamic Server must abort.
09:50:47  PANIC: Attempting to bring system down

uuuvvv

请高手指点，谢谢阿

join

我不是高手，个人感觉像硬件问题。

uuuvvv

我也认为是硬件问题，但是这是个双机系统（alpha ds20e x 2  + StorgeWork 3000）， 切换到另一台上,很少出现此问题

IFMXDBA

it looks like something wrong with the disk adapter/controller in one box.  Informix uses OS kernal services to access the raw devices, ioctl, read/write, etc.  The error 5 was an OS error, which is defined in /usr/include/errno.h,  "I/O error".  I would like to suggest you try to check the OS system diagnosis info.

uuuvvv

say thanks to INFORMXDBA, i ' ll check it.

imkdk

并非整个chunk全部坏掉，而是部分chunk中的页不能访问，看上去非常像磁盘硬件问题。
建议楼主按照系统提示，先运行oncheck检查chunk页，并在oncheck提示是否修复时选择（YES）修复。
oncheck -pt 2097195