Online 7.11UC1 DR problem
Posted in 1996
I'm having a problem (it's occurred 3 times in the last 2 months) with DR. My config is Solaris 2.4 on sparc
20's and Informix Online 7.11UC1. My problem is is that when the primary crashes so does the secondary.
Thanks for your help, here are my log files:
PRIMARY:
15:17:31 Checkpoint Completed: duration was 1 seconds.
Tue Jan 2 15:46:08 1996
15:46:08 DR: DRAUTO is 2 (Reverse)
15:46:10 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
15:46:11 DR: Trying to connect to secondary server ...
15:46:26 (4) connection rejected - no calls allowed for sqlexec
15:46:26 listener-thread: err = -27002: No connections are allowed in OnLine quiescent mode.
15:46:27 (10) connection rejected - no calls allowed for sqlexec
15:46:27 listener-thread: err = -27002: No connections are allowed in OnLine quiescent mode.
15:47:58 DR: Cannot connect to secondary server
15:47:58 DR: Turned off on primary server
15:47:58 Physical Recovery Started.
15:48:00 DR: Trying to connect to secondary server ...
15:48:00 Physical Recovery Complete: 128 Pages Restored.
15:48:00 Logical Recovery Started.
15:48:02 DR: Primary server connected
15:48:04 Logical Recovery Complete. 27 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
15:48:04 Dataskip is now OFF for all dbspaces
15:48:05 (30) connection rejected - no calls allowed for sqlexec
15:48:05 listener-thread: err = -27002: No connections are allowed in OnLine quiescent mode.
15:48:05 (36) connection rejected - no calls allowed for sqlexec
15:48:05 listener-thread: err = -27002: No connections are allowed in OnLine quiescent mode.
15:48:05 Checkpoint Completed: duration was 1 seconds.
15:48:05 Dropping temporary TBLspace 100020, recovering 16 pages.
15:48:05 Dropping temporary TBLspace 100021, recovering 8 pages.
15:48:05 Dropping temporary TBLspace 100022, recovering 16 pages.
15:48:05 Dropping temporary TBLspace 100023, recovering 16 pages.
15:48:05 Dropping temporary TBLspace 100024, recovering 16 pages.
15:48:05 Dropping temporary TBLspace 100025, recovering 16 pages.
15:48:05 Dropping temporary TBLspace 100026, recovering 16 pages.
15:48:05 Dropping temporary TBLspace 100027, recovering 16 pages.
15:48:06 On-Line Mode
15:48:08 Logical Log 738 Complete.
15:48:08 DR: Sending log 738, size 5000 pages, 34.12% used
15:48:14 DR: Sending log 739 (current), size 5000 pages, 0.00% used
15:48:14 DR: Sending Logical Logs Completed
15:48:18 DR: Primary server operational
15:48:20 Checkpoint Completed: duration was 0 seconds.
SECONDARY:
15:16:58 Checkpoint Completed: duration was 0 seconds.
15:28:04 DR: ping timeout
15:28:04 DR: Receive error
15:28:05 DR: Receive Btree error
15:28:06 DR: Turned off on secondary server
15:28:13 Logical Recovery Complete. 31758 Committed, 20 Rolled Back, 0 Open, 0 Bad Locks
15:28:13 Dropping temporary TBLspace 100020, recovering 16 pages.
15:28:13 Assert Failed: Logical Logging error for 'PERASE' in 'logput'
15:28:13 Who: Session(16, informix@saturn, 380, 16)
Thread(30, ontape, e2b3f1c, 1)
15:28:13 Results: OnLine must abort
15:28:13 Action: Reinitialize shared memory
15:28:13 See Also: /u/informix/tmp/af.916fbdd
15:28:13 rslog.c, line 3707, thread 25, proc id 365, OnLine must abort.
15:28:13 PANIC: Attempting to bring system down
Tue Jan 2 15:47:13 1996
15:47:13 DR: DRAUTO is 2 (Reverse)
15:47:15 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
15:47:15 DR: Logs already cleared
15:47:15 DR: Trying to connect to primary server ...
15:47:17 Physical Recovery Started.
15:47:18 Physical Recovery Complete: 106 Pages Restored.
15:47:18 Dataskip is now OFF for all dbspaces
15:47:18 Recovery Mode
15:47:25 DR: Secondary server connected
15:47:29 DR: Failure recovery from disk in progress ...
15:47:30 Logical Recovery Started.
15:47:31 Start Logical Recovery - Start Log 738, End Log ?
15:47:31 Starting Log Position - 738 0x683018
15:47:40 Checkpoint Completed: duration was 0 seconds.
15:47:41 DR: Secondary server operational
15:47:45 Checkpoint Completed: duration was 0 seconds.
15:53:01 Checkpoint Completed: duration was 0 seconds.