紧急求助，执行了一个sql，一直没有反应，再执行onmode -kz，数据库起不来了

cpmax

版本是IBM Informix Dynamic Server Version 10.00.FC1
以下是日志
17:30:13  Maximum server connections 161
17:30:14  IBM Informix Dynamic Server Stopped.

17:31:34  IBM Informix Dynamic Server Started.

Tue Apr 22 17:31:34 2008

17:31:34  Event alarms enabled.  ALARMPROG = '/usr/informix/etc/alarmprogram.sh'
17:31:34  Booting Language <c> from module <>
17:31:34  Loading Module <CNULL>
17:31:34  Booting Language <builtin> from module <>
17:31:34  Loading Module <BUILTINNULL>
17:31:39  DR: DRAUTO is 0 (Off)
17:31:39  IBM Informix Dynamic Server Version 10.00.FC1     Software Serial Number AAA#B000000
17:31:41  IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

17:31:41  Physical Recovery Started at Page (2:478062).
17:31:42  Assert Failed: Physical log recovery error
17:31:42  IBM Informix Dynamic Server Version 10.00.FC1   
17:31:42   Who: Session(12, informix@dgmobapp, 0, 0x11034cae
                Thread(24, fast_rec, 110313d08, 3)
                File: rsrecvr.c Line: 905
17:31:42   Results: Physical Recovery Aborted.
17:31:42   Action: Retry and/or restore
17:31:42  stack trace for pid 27551 written to /tmp/af.400b07e
17:31:42   See Also: /tmp/af.400b07e, shmem.400b07e.0
17:31:56  Physical log recovery error
17:32:16  Cannot Restore to Checkpoint.
17:48:31  IBM Informix Dynamic Server Started.
17:48:31  shmget: [EEXIST][17]: key 52564801: shared memory already exists
17:48:31  mt_shm_init: can't create resident segment

17:49:17  IBM Informix Dynamic Server Started.
17:49:17  shmget: [EEXIST][17]: key 52564801: shared memory already exists
17:49:17  mt_shm_init: can't create resident segment

17:50:37  IBM Informix Dynamic Server Started.
17:50:37  shmget: [EEXIST][17]: key 52564801: shared memory already exists
17:50:37  mt_shm_init: can't create resident segment

18:00:20  Logical Log 146 - Backup Started
18:00:20  I/O read chunk 3, pagenum 250053, pagecnt 7 --> errno = 9
18:00:20  Logical Log 146 - Backup Aborted
          Error reading from the disk, Error No. = 9.

18:03:42  IBM Informix Dynamic Server Started.
18:03:42  shmget: [EEXIST][17]: key 52564801: shared memory already exists
18:03:42  mt_shm_init: can't create resident segment

18:53:14  IBM Informix Dynamic Server Started.
18:53:14  shmget: [EEXIST][17]: key 52564801: shared memory already exists
18:53:14  mt_shm_init: can't create resident segment

19:38:33  IBM Informix Dynamic Server Started.
19:38:33  shmget: [EEXIST][17]: key 52564801: shared memory already exists
19:38:33  mt_shm_init: can't create resident segment

09:05:42  IBM Informix Dynamic Server Started.

Wed Apr 23 09:05:43 2008

09:05:43  Event alarms enabled.  ALARMPROG = '/usr/informix/etc/alarmprogram.sh'
09:05:43  Booting Language <c> from module <>
09:05:43  Loading Module <CNULL>
09:05:43  Booting Language <builtin> from module <>
09:05:43  Loading Module <BUILTINNULL>
09:05:48  DR: DRAUTO is 0 (Off)
09:05:48  IBM Informix Dynamic Server Version 10.00.FC1     Software Serial Number AAA#B000000
09:05:50  IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

09:05:50  Physical Recovery Started at Page (2:478062).
09:05:51  Assert Failed: Physical log recovery error
09:05:51  IBM Informix Dynamic Server Version 10.00.FC1   
09:05:51   Who: Session(12, informix@dgmobapp, 0, 0x11034cae
                Thread(24, fast_rec, 110313d08, 3)
                File: rsrecvr.c Line: 905
09:05:51   Results: Physical Recovery Aborted.
09:05:51   Action: Retry and/or restore
09:05:51  stack trace for pid 32455 written to /tmp/af.4008b6f
09:05:51   See Also: /tmp/af.4008b6f, shmem.4008b6f.0
09:05:57  Physical log recovery error
09:05:58  Cannot Restore to Checkpoint.
09:22:39  IBM Informix Dynamic Server Started.
09:22:39  shmget: [EEXIST][17]: key 52564801: shared memory already exists
09:22:39  mt_shm_init: can't create resident segment

cpmax

顶，快急死了。高手来看下啊

liaosnet

额.........从日志上看是从物理日志恢复错误........
09:05:51  Assert Failed: Physical log recovery error

09:05:57  Physical log recovery error
09:05:58  Cannot Restore to Checkpoint.

物理日志恢复错误..你要先看看物理日志所在的dbspace是否存在问题,比如CHUNK是否已经损坏...

[ 本帖最后由 liaosnet 于 2008-4-23 10:26 编辑 ]

cpmax

那要怎么做呢？麻烦详细指点下，万分感谢！

cpmax

顶！

3sane

还有：
18:00:20  Logical Log 146 - Backup Started
18:00:20  I/O read chunk 3, pagenum 250053, pagecnt 7 --> errno = 9
18:00:20  Logical Log 146 - Backup Aborted
          Error reading from the disk, Error No. = 9.

估计磁盘是有问题了，只能恢复了

liaosnet

做个dd测试.
dd if="<逻辑日志CHUNK文件>" of=/dev/null

如果可以正常读写,那还好..若是测试失败..恢复吧..

hanyu

要做好数据备份工作呀