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

cpmax 发表于 2008-04-23 10:08

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

17:31:34IBM Informix Dynamic Server Started.

Tue Apr 22 17:31:34 2008

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

17:31:41Physical Recovery Started at Page (2:478062).
17:31:42Assert Failed: Physical log recovery error
17:31:42IBM Informix Dynamic Server Version 10.00.FC1
17:31:42 Who: Session(12, informix@dgmobapp, 0, 0x11034cae8)
            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:42stack trace for pid 27551 written to /tmp/af.400b07e
17:31:42 See Also: /tmp/af.400b07e, shmem.400b07e.0
17:31:56Physical log recovery error
17:32:16Cannot Restore to Checkpoint.
17:48:31IBM Informix Dynamic Server Started.
17:48:31shmget: : key 52564801: shared memory already exists
17:48:31mt_shm_init: can't create resident segment

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

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

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

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

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

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

09:05:42IBM Informix Dynamic Server Started.

Wed Apr 23 09:05:43 2008

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

09:05:50Physical Recovery Started at Page (2:478062).
09:05:51Assert Failed: Physical log recovery error
09:05:51IBM Informix Dynamic Server Version 10.00.FC1
09:05:51 Who: Session(12, informix@dgmobapp, 0, 0x11034cae8)
            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:51stack trace for pid 32455 written to /tmp/af.4008b6f
09:05:51 See Also: /tmp/af.4008b6f, shmem.4008b6f.0
09:05:57Physical log recovery error
09:05:58Cannot Restore to Checkpoint.
09:22:39IBM Informix Dynamic Server Started.
09:22:39shmget: : key 52564801: shared memory already exists
09:22:39mt_shm_init: can't create resident segment

cpmax 发表于 2008-04-23 10:16

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

liaosnet 发表于 2008-04-23 10:21

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

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

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

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

cpmax 发表于 2008-04-23 10:42

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

cpmax 发表于 2008-04-23 10:53

顶！

3sane 发表于 2008-04-23 11:02

回复 #1 cpmax 的帖子

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

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

liaosnet 发表于 2008-04-23 11:08

回复 #4 cpmax 的帖子

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

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

czw1413_cn 发表于 2008-04-29 11:49

hanyu 发表于 2008-05-01 17:00

要做好数据备份工作呀

页: [1]

Chinaunix's Archiver