IDS down while program start work..
Posted in 2007
HI,all
HP-UX mscp1 B.11.11 U with IDS 9.40FC7W4
1.the server mscp1 start and to be SECONDARY of HDR at 00:01:41
2.the mscp2 (the PRIMARY) dbimport the datebase scp20 about 00:09
3.after finish dbimport scp20, switch mscp1 from SECONDARY to PRIMARY at 00:26
4.the program connect to DB,the error occur.
online.log follow
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Sat Sep 15 00:01:41 2007
00:01:41 Warning: ONCONFIG dump directory (DUMPDIR)
'/tellinshare/sms/informixdump' has insecure permissions
00:01:41 Event alarms enabled. ALARMPROG = '/opt/informix/etc/alarmprogram.sh'
00:01:41 Dynamically allocated new virtual shared memory segment (size 8436KB)
00:01:41 Booting Language <c> from module <>
00:01:41 Loading Module <CNULL>
00:01:41 Booting Language <builtin> from module <>
00:01:41 Loading Module <BUILTINNULL>
00:01:47 Dynamically allocated new message shared memory segment (size 672KB)
00:01:47 IBM Informix Dynamic Server Version 9.40.FC7W4 Software Serial Number
AAA#B000000
00:01:48 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:01:49 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
00:01:49 DR: Reservation of the last logical log for log backup turned on
00:01:49 Data replication type and state information reset. To start DR, use
the 'onmode -d' command and wait for the pair to be operational,
before shutting down the database server
00:01:49 Dataskip is now OFF for all dbspaces
00:01:49 Restartable Restore has been DISABLED
00:01:49 Recovery Mode
00:01:54 Physical Restore of rootdbs, logdbs, phydbs, workdbs started.
00:02:03 Checkpoint Completed: duration was 0 seconds.
00:02:03 Checkpoint loguniq 5847, logpos 0x195018, timestamp: 0xcac20a0a
00:02:03 Maximum server connections 0
00:02:03 Checkpoint Completed: duration was 0 seconds.
00:02:03 Checkpoint loguniq 5847, logpos 0x195018, timestamp: 0xcac20a12
00:02:03 Maximum server connections 0
00:02:03 Checkpoint Completed: duration was 0 seconds.
00:02:03 Checkpoint loguniq 5847, logpos 0x195018, timestamp: 0xcac20a1a
00:02:03 Maximum server connections 0
00:05:10 Checkpoint Completed: duration was 0 seconds.
00:05:10 Checkpoint loguniq 5847, logpos 0x195018, timestamp: 0xcac20a21
00:05:10 Maximum server connections 0
00:05:11 Physical Restore of rootdbs, logdbs, phydbs, workdbs Completed.
00:05:11 Checkpoint Completed: duration was 0 seconds.
00:05:11 Checkpoint loguniq 5847, logpos 0x195018, timestamp: 0xcac20a26
00:05:11 Maximum server connections 0
00:05:56 DR: Reservation of the last logical log for log backup turned off
00:05:56 DR: new type = secondary, primary server name = mscp_server2_net
00:05:56 DR: Trying to connect to primary server = mscp_server2_net
00:05:59 DR: Secondary server connected
00:05:59 DR: Secondary server needs failure recovery
00:06:00 DR: Failure recovery from disk in progress ...
00:06:00 Logical Recovery Started.
00:06:00 10 recovery worker threads will be started.
00:06:00 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:06:00 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:06:00 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:06:00 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:06:00 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:06:00 Start Logical Recovery - Start Log 5847, End Log ?
00:06:00 Starting Log Position - 5847 0x195018
00:06:00 Clearing the physical and logical logs has started
00:08:10 Cleared 1952 MB of the physical and logical logs in 131 seconds
00:08:13 DR: Secondary server operational
00:08:13 Checkpoint Completed: duration was 0 seconds.
00:08:13 Checkpoint loguniq 5847, logpos 0x198018, timestamp: 0xcac20a4f
00:08:13 Maximum server connections 0
00:09:41 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:09:46 Booting Language <spl> from module <>
00:09:46 Loading Module <SPLNULL>
00:26:31 Checkpoint Completed: duration was 0 seconds.
00:26:31 Checkpoint loguniq 5847, logpos 0x19c018, timestamp: 0xcac23ca9
00:26:31 Maximum server connections 23
00:26:32 DR: Receive error in thread dr_secrcv [id: 36]
00:26:32 ASF Echo-Thread Server: asfcode = -25582: oserr = 4: errstr = :
Network connection is broken.
System error = 4.
00:26:34 DR: Turned off on secondary server
00:26:41 Logical Recovery has reached the transaction cleanup phase.
00:26:41 Logical Recovery Complete.
32 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
00:26:41 Logical Recovery Complete.
00:26:42 Quiescent Mode
00:26:42 Checkpoint Completed: duration was 0 seconds.
00:26:42 Checkpoint loguniq 5847, logpos 0x19d018, timestamp: 0xcac23cb4
00:26:42 Maximum server connections 23
00:26:42 DR: Reservation of the last logical log for log backup turned on
00:26:42 DR: new type = standard
00:26:43 On-Line Mode
00:26:43 DR: new type = primary, secondary server name = mscp_server2_net
00:26:43 DR: Trying to connect to secondary server = mscp_server2_net
00:26:43 DR: Cannot connect to secondary server
00:26:43 DR: Turned off on primary server
00:30:42 DR: Primary server connected
00:30:42 DR: Secondary server needs failure recovery
00:30:43 DR: Sending log 5847 (current), size 50000 pages, 0.83 percent used
00:30:44 DR: Sending Logical Logs Completed
00:30:45 DR: Primary server operational
00:30:46 Checkpoint Completed: duration was 0 seconds.
00:30:46 Checkpoint loguniq 5847, logpos 0x1a2018, timestamp: 0xcac24888
00:30:46 Maximum server connections 25
00:46:42 stack trace for pid 22543 written to
/tellinshare/sms/informixdump/af.46abaf2
00:46:42 Assert Failed: No Exception Handler
00:46:42 IBM Informix Dynamic Server Version 9.40.FC7W4
00:46:42 Who: Session(93, tellin@mscp1, 12705, c0000000188b00e8)
Thread(130, sqlexec, c00000001887bf60, 1)
File: mtex.c Line: 435
00:46:42 Results: Exception Caught. Type: MT_EX_OS, Context: mem
00:46:42 Action: Please notify IBM Informix Technical Support.
00:46:42 stack trace for pid 22543 written to
/tellinshare/sms/informixdump/af.46abaf2
00:46:42 See Also: /tellinshare/sms/informixdump/af.46abaf2, shmem.46abaf2.0
00:46:48 mtex.c, line 435, thread 130, proc id 22543, No Exception Handler.
00:46:48 The Master Daemon Died
00:46:49 PANIC: Attempting to bring system down
af.46abaf2 follow.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
00:46:42 Stack for thread: 130 sqlexec
base: 0xc00000001c450000
len: 36864
pc: 0x0000000000000000
tos: 0xc00000001c4530e0
state: running
vp: 1
( 0) 0x40000000008a73e8 legacy_hp_afstack + 0x258 [/opt/informix/bin/oninit]
( 1) 0x40000000008a6a3c afstack + 0x5c [/opt/informix/bin/oninit]
( 2) 0x40000000008abd6c mt_ex_throw_sig + 0x29c [/opt/informix/bin/oninit]
( 3) 0x400000000086f248 afsig_handler + 0xf8 [/opt/informix/bin/oninit]
( 4) 0xc0000000003f8bf0 _sigreturn [/usr/lib/pa20_64/libc.2]
( 5) 0x4000000000625a50 rowalter + 0xa8 [/opt/informix/bin/oninit]
( 6) 0x4000000000625700 decompress_row + 0x80 [/opt/informix/bin/oninit]
( 7) 0x40000000005b2ccc read_reco