标题: 紧急求助，执行了一个sql，一直没有反应，再执行onmode -kz，数据库起不来了 [打印本页] 作者: cpmax 时间: 2008-04-23 10:08 标题: 紧急求助，执行了一个sql，一直没有反应，再执行onmode -kz，数据库起不来了 版本是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
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 时间: 2008-04-23 10:16
顶，快急死了。高手来看下啊作者: liaosnet 时间: 2008-04-23 10:21
额.........从日志上看是从物理日志恢复错误........
09:05:51 Assert Failed: Physical log recovery error
09:05:57 Physical log recovery error
09:05:58 Cannot Restore to Checkpoint.
