- 论坛徽章:
- 0
|
情况是这样的：informix数据库一共65个逻辑日志，主从机切换了一下，过了两天，报逻辑日志满了。
切换时的日志
18:36:06 Checkpoint Completed: duration was 0 seconds.
18:38:32 Checkpoint Completed: duration was 0 seconds.
18:38:33 Informix Dynamic Server Stopped.
Sun Aug 7 18:39:31 2005
18:39:31 Event alarms enabled. ALARMPROG = '/ah/informix/etc/log_full.sh'
18:39:36 DR: DRAUTO is 2 (Reverse)
18:39:36 Informix Dynamic Server Version 7.31.UC6 Software Serial Number AAC#J936499
18:39:39 Informix Dynamic Server Initialized -- Shared Memory Initialized.
18:39:39 DR: Trying to connect to secondary server ...
18:39:40 DR: Primary server now Secondary
18:39:42 Physical Recovery Started.
18:39:42 Physical Recovery Complete: 0 Pages Restored.
18:39:42 Dataskip is now OFF for all dbspaces
18:39:42 Recovery Mode
18:39:43 DR: Secondary server connected
18:39:44 DR: Failure recovery from disk in progress ...
18:39:45 Logical Recovery Started.
18:39:45 Start Logical Recovery - Start Log 68916, End Log ?
18:39:45 Starting Log Position - 68916 0xc5f018
18:41:26 DR: Receive error
18:41:26 DR: Failure recovery error (6)
18:41:27 DR: Turned off on secondary server
18:41:32 Assert Failed: No Exception Handler
18:41:32 Informix Dynamic Server Version 7.31.UC6
18:41:32 Who: Session(10, informix@ahsmp2, 298, 280594760)
Thread(23, dr_secrcv, 10b7228c, 1)
File: mtex.c Line: 446
18:41:32 Results: Exception Caught. Type: MT_EX_OS, Context: mem
18:41:32 Action: Please notify Informix Technical Support.
18:41:38 See Also: /tmp/af.3ffe55c, shmem.3ffe55c.0
18:41:42 mtex.c, line 446, thread 23, proc id 18644, No Exception Handler.
18:41:42 PANIC: Attempting to bring system down
Sun Aug 7 18:43:14 2005
18:43:14 Event alarms enabled. ALARMPROG = '/ah/informix/etc/log_full.sh'
18:43:19 DR: DRAUTO is 2 (Reverse)
18:43:19 Informix Dynamic Server Version 7.31.UC6 Software Serial Number AAC#J936499
18:43:23 Informix Dynamic Server Initialized -- Shared Memory Initialized.
18:43:23 DR: Logs will be cleared during logical recovery
18:43:23 DR: Trying to connect to primary server ...
18:43:25 Physical Recovery Started.
18:43:25 Physical Recovery Complete: 0 Pages Restored.
18:43:25 Dataskip is now OFF for all dbspaces
18:43:25 Recovery Mode
18:43:26 DR: Secondary server connected
18:44:45 DR: Failure recovery from disk in progress ...
18:44:47 Logical Recovery Started.
18:44:47 Start Logical Recovery - Start Log 68916, End Log ?
18:44:47 Starting Log Position - 68916 0xc5f018
18:46:36 Checkpoint Completed: duration was 0 seconds.
18:46:43 Checkpoint Completed: duration was 0 seconds.
18:46:43 DR: Secondary server operational
18:46:44 Checkpoint Completed: duration was 0 seconds.
18:47:09 DR: Receive error
18:47:10 DR: Turned off on secondary server
18:47:17 Logical Recovery Complete.
1 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
18:47:17 Logical Recovery Complete.
18:47:17 DR: new type = standard
18:47:17 DR: new type = primary, secondary server name = ahsmp2
18:47:17 DR: Trying to connect to secondary server ...
18:47:18 On-Line Mode
18:47:18 Logical Log 68917 Complete.
18:47:18 Checkpoint Completed: duration was 0 seconds.
18:47:22 Process exited with return code 142: /bin/sh /bin/sh -c /ah/informix/etc/log_full.sh 2 23 "Logical Log 68917 Complete." "Logical Log 68917 Complete."
18:48:06 DR: Primary server connected
18:48:07 DR: Sending log 68917, size 10000 pages, 0.04 percent used
18:48:07 DR: Sending log 68918 (current), size 10000 pages, 0.03 percent used
18:49:49 DR: Sending Logical Logs Completed
18:49:51 DR: Primary server operational
18:49:51 DR: LBU_PRESERVE turned on while primary
18:49:52 Checkpoint Completed: duration was 0 seconds.
18:54:55 Checkpoint Completed: duration was 0 seconds.
报逻辑日志满的时候日志：
02:58:27 Process exited with return code 142: /bin/sh /bin/sh -c /ah/informix/etc/log_full.sh 2 23 "Logical Log 68977 Complete." "Logical Log 68977 Complete."
03:02:22 Checkpoint Completed: duration was 0 seconds.
03:02:34 Logical Log 68978 Complete.
03:02:36 Process exited with return code 142: /bin/sh /bin/sh -c /ah/informix/etc/log_full.sh 2 23 "Logical Log 68978 Complete." "Logical Log 68978 Complete."
03:06:51 Logical Log 68979 Complete.
03:06:54 Process exited with return code 142: /bin/sh /bin/sh -c /ah/informix/etc/log_full.sh 2 23 "Logical Log 68979 Complete." "Logical Log 68979 Complete."
03:07:22 Checkpoint Completed: duration was 0 seconds.
03:11:25 Logical log files are almost full - backup is needed.
03:11:26 Logical Log 68980 Complete.
03:11:29 Process exited with return code 142: /bin/sh /bin/sh -c /ah/informix/etc/log_full.sh 2 23 "Logical Log 68980 Complete." "Logical Log 68980 Complete."
03:12:23 Checkpoint Completed: duration was 0 seconds.
03:17:23 Checkpoint Completed: duration was 0 seconds.
08:14:39 (14147) connection rejected - no calls allowed for onload
08:14:39 listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.
08:15:25 (1414 connection rejected - no calls allowed for onload
08:15:25 listener-thread: err = -27002: oserr = 0: errstr = : No connections are allowed in Dynamic Server quiescent mode.
08:21:03 Informix Dynamic Server Stopped.
切换的时候报了个panic错，是不是和它有关系？在此先谢谢各位了 |
|
免费注册
发表于 2005-08-11 12:07
