EDR 9.40.FC5 -> 9.21.UC2 crashes engine
Posted in 2005
Topics: Backup & Restore, Error Codes & Troubleshooting, Networking & sqlhosts Configuration, Platform-Specific Issues, Versions, Editions & End-of-Life
Hi,
I have to set up EDR on two servers:
primary - SPARC Solaris 8, IDS 9.40.FC5;
read-only - Intel Solaris 7, IDS 9.21.UC2.
As ids_erep_docnotes_9.40.txt says I set CDRSITES_92x before starting
EDR as follows:
export CDRSITES_92x=9
Primary's sqlhosts:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
g_prim_ids group - - i=3
prim_ix_ids ontlitcp prim-ix sqlexec g=g_prim_ids
g_sec_ids group - - i=9
sec_ix_ids ontlitcp sec-ix sqlexec g=g_sec_ids
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
The same is secondary's sqlhosts.
`cdr define server` executed successfully. After that,
when I run `define replicate` & `start replicate` for
several tables in a batch, the primary engine crashed:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
12:28:10 Assert Failed: No Exception Handler
12:28:10 IBM Informix Dynamic Server Version 9.40.FC5
12:28:10 Who: Session(20, root@prim, 0, 1976c2d08)
Thread(47, CDRNsT9, 1976849e0, 3)
File: mtex.c Line: 431
12:28:10 Results: Exception Caught. Type: MT_EX_OS, Context: mem
12:28:10 Action: Please notify IBM Informix Technical Support.
12:28:10 stack trace for pid 2816 written to /tmp/af.4126e99
12:28:10 See Also: /tmp/af.4126e99
12:28:14 mtex.c, line 431, thread 47, proc id 2816, No Exception
Handler.
12:28:14 Fatal error in ADM VP at mt.c:12351
12:28:14 Unexpected virtual processor termination, pid = 2816, exit =0x100
12:28:15 PANIC: Attempting to bring system down
12:28:15 semctl: errno = 22
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
>From now, IDS failed to start - even with CDRBLOCKOUT -
and I had to cold restore it with ontape.
Stack from AF file:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
12:28:10 Stack for thread: 47 CDRNsT9
base: 0x00000001988eb000
len: 69632
pc: 0x000000010087eb14
tos: 0x00000001988fa6f1
state: running
vp: 1
0x10087eb14 oninit :: afstack + 0x34 sp=0x1988faef0(0x988dc1c0,
0x98875fc8, 0x1000009, 0x0, 0x0, 0x0)
0x100883914 oninit :: mt_ex_throw_sig + 0x300 sp=0x1988fb1c0
delta_sp=720(0xcd27c0, 0xe37758, 0x0, 0xef86d0, 0xe3ae08, 0x988dc1c0)
0x1008436a0 oninit :: afsig_handler + 0x158 sp=0x1988fb380
delta_sp=448(0xee30c8, 0x41b0, 0xe37718, 0xe37758, 0x4000, 0x0)
0xffffffff7dea7014 /usr/lib/sparcv9/libc.so.1 :: _setuid + 0x4c
sp=0x1988fb440 delta_sp=192(0xa, 0x988fb890, 0x988fb5b0, 0xa,
0x988fbb2c, 0x988d8810)
0x1009d9614 oninit :: genRapGetMessage + 0x200 sp=0x1988fb4f0
delta_sp=176(0x989bd9c0, 0xc28d8, 0xeeb480, 0x988fbb28, 0x988fbb24,
0x1)
0x1009d6298 oninit :: nifCompatSend + 0x26c sp=0x1988fba50
delta_sp=1376(0xedd040, 0xb3b44, 0x66000, 0xd25408, 0x0, 0x988d8548)
0x1009d54b0 oninit :: nifSend + 0x154 sp=0x1988fbb30
delta_sp=224(0x988d8810, 0x98875ca8, 0x660b8, 0xd25408, 0x988d8810,
0x988d8810)
0x1009d2c90 oninit :: nifiGenericStart + 0x1078 sp=0x1988fbbe0
delta_sp=176(0xcd8ff0, 0x988fbe4c, 0x988d8810, 0x46, 0x660b8,
0x988d8548)
0x1009819b4 oninit :: cdrTrampolineThread + 0xc0 sp=0x1988fbd90
delta_sp=432(0xcd09a0, 0x9d1c18, 0x988d8810, 0x983e0330, 0x988dc1c0,
0x0)
0x1008547f0 oninit :: startup + 0xfc sp=0x1988fbe50
delta_sp=192(0xf0dbd0, 0x6, 0xee30c8, 0x97019b50, 0x98801040,
0x97019ad8)
12:28:10
12:28:10 IBM Informix Dynamic Server Version 9.40.FC5 SoftwareSerial Number AAA#B000000
12:28:10 Assert Failed: No Exception Handler
12:28:10 Who: Session(20, root@prim, 0, 1976c4048)
Thread(47, CDRNsT9, 197688b20, 1)
File: mtex.c Line: 431
12:28:10 Results: Exception Caught. Type: MT_EX_OS, Context: mem
12:28:10 Action: Please notify IBM Informix Technical Support.
12:28:10 Stack for thread: 47 CDRNsT9
base: 0x00000001988eb000
len: 69632
pc: 0x000000010087eb14
tos: 0x00000001988f9f11
state: running
vp: 1
0x10087eb14 oninit :: afstack + 0x34 sp=0x1988fa710(0x988dc1c0,
0x98875fc8, 0x1000009, 0x0, 0xf02ef0, 0x988faca0)
0x10087db78 oninit :: afhandler + 0xaf8 sp=0x1988fa9e0
delta_sp=720(0xcd4de0, 0x97f4a028, 0x988fb280, 0x601, 0x1, 0xf0dbd0)
0x10087d070 oninit :: afcrash_interface + 0x4c sp=0x1988fb100
delta_sp=1824(0xe3ae38, 0x988fb280, 0x97f4a028, 0xe3ae50, 0x1af, 0x0)
0x1008839e0 oninit :: mt_ex_throw_sig + 0x3cc sp=0x1988fb1c0
delta_sp=192(0xcd27c0, 0xe37758, 0x0, 0xef86d0, 0xe3ae08, 0x988dc1c0)
0x1008436a0 oninit :: afsig_handler + 0x158 sp=0x1988fb380
delta_sp=448(0xee30c8, 0x41b0, 0xe37718, 0xe37758, 0x4000, 0x0)
0xffffffff7dea7014 /usr/lib/sparcv9/libc.so.1 :: _setuid + 0x4c
sp=0x1988fb440 delta_sp=192(0xa, 0x988fb890, 0x988fb5b0, 0xa,
0x988fbb2c, 0x988d8810)
0x1009d9614 oninit :: genRapGetMessage + 0x200 sp=0x1988fb4f0
delta_sp=176(0x989bd9c0, 0xc28d8, 0xeeb480, 0x988fbb28, 0x988fbb24,
0x1)
0x1009d6298 oninit :: nifCompatSend + 0x26c sp=0x1988fba50
delta_sp=1376(0xedd040, 0xb3b44, 0x66000, 0xd25408, 0x0, 0x988d8548)
0x1009d54b0 oninit :: nifSend + 0x154 sp=0x1988fbb30
delta_sp=224(0x988d8810, 0x98875ca8, 0x660b8, 0xd25408, 0x988d8810,
0x988d8810)
0x1009d2c90 oninit :: nifiGenericStart + 0x1078 sp=0x1988fbbe0
delta_sp=176(0xcd8ff0, 0x988fbe4c, 0x988d8810, 0x46, 0x660b8,
0x988d8548)
0x1009819b4 oninit :: cdrTrampolineThread + 0xc0 sp=0x1988fbd90
delta_sp=432(0xcd09a0, 0x9d1c18, 0x988d8810, 0x983e0330, 0x988dc1c0,
0x0)
0x1008547f0 oninit :: startup + 0xfc sp=0x1988fbe50
delta_sp=192(0xf0dbd0, 0x6, 0xee30c8, 0x97019b50, 0x98801040,
0x97019ad8)
===========------------- - - - - - -
/usr/informix/server/bin/onstat -g stk 47 light:
IBM Informix Dynamic Server Version 9.40.FC5 -- On-Line -- Up
00:00:22 -- 2834432 Kbytes
Stack for thread: 47 CDRNsT9
base: 0x00000001988eb000
len: 69632
pc: 0x00000001008510d0
tos: 0x00000001988fa131state: running
vp: 1
0x1008510d0 oninit :: mt_system + 0x11c sp=0x1988fa930(0xeda7b0,
0x988faca0, 0x97018c70, 0x3, 0x0, 0x988fab98)
0x10087df8c oninit :: afhandler + 0xf0c sp=0x1988fa9e0
delta_sp=176(0xcd4de8, 0xef86d0, 0x3, 0x601, 0x1, 0xf0dbd0)
0x10087d070 oninit :: afcrash_interface + 0x4c sp=0x1988fb100
delta_sp=1824(0xe3ae38, 0x988fb280, 0x97f4a028, 0xe3ae50, 0x1af, 0x0)
0x1008839e0 oninit :: mt_ex_throw_sig + 0x3cc sp=0x1988fb1c0
delta_sp=192(0xcd27c0, 0xe37758, 0x0, 0xef86d0, 0xe3ae08, 0x988dc1c0)
0x1008436a0 oninit :: afsig_handler + 0x158 sp=0x1988fb380
delta_sp=448(0xee30c8, 0x41b0, 0xe37718, 0xe37758, 0x4000, 0x0)
0xffffffff7dea7014 ?unknown? :: ?unknown? + 0x0 sp=0x1988fb440
delta_sp=192(0xa, 0x988fb890, 0x988fb5b0, 0xa, 0x988fbb2c, 0x988d8810)
0x1009d9614 oninit :: genRapGetMessage + 0x200 sp=0x1988fb4f0
delta_sp=176(0x989bd9c0, 0xc28d8, 0xeeb480, 0x988fbb28, 0x988fbb24,
0x1)
0x1009d6298 oninit :: nifCompatSend + 0x26c sp=0x1988fba50
delta_sp=1376(0xedd040, 0xb3b44, 0x66000, 0xd25408, 0x0, 0x988d8548)
0x1009d54b0 oninit :: nifSend + 0x154 sp=0x1988fbb30
delta_sp=224(0x988d8810, 0x98875ca8, 0x660b8, 0xd25408, 0x988d8810,
0x988d8810)
0x1009d2c90 oninit :: nifiGenericStart + 0x1078 sp=0x1988fbbe0
delta_sp=176(0xcd8ff0, 0x988fbe4c, 0x988d8810, 0x46, 0x660b8,
0x988d8548)
0x1009819b4 oninit :: cdr
Do you have a case number?
"dm" <dmelnik@regent.ru> wrote in message
news:1124867783.755977.104610@g49g2000cwa.googlegroups.com...
> Hi,
>
> I have to set up EDR on two servers:
> primary - SPARC Solaris 8, IDS 9.40.FC5;
> read-only - Intel Solaris 7, IDS 9.21.UC2.
>
> As ids_erep_docnotes_9.40.txt says I set CDRSITES_92x before starting
> EDR as follows:
>
> export CDRSITES_92x=9
>
> Primary's sqlhosts:
> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> g_prim_ids group - - i=3
> prim_ix_ids ontlitcp prim-ix sqlexec g=g_prim_ids
>
> g_sec_ids group - - i=9
> sec_ix_ids ontlitcp sec-ix sqlexec g=g_sec_ids
> <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
>
> The same is secondary's sqlhosts.
>
> `cdr define server` executed successfully. After that,
> when I run `define replicate` & `start replicate` for
> several tables in a batch, the primary engine crashed:
>
> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> 12:28:10 Assert Failed: No Exception Handler
> 12:28:10 IBM Informix Dynamic Server Version 9.40.FC5
> 12:28:10 Who: Session(20, root@prim, 0, 1976c2d08)
> Thread(47, CDRNsT9, 1976849e0, 3)
> File: mtex.c Line: 431
> 12:28:10 Results: Exception Caught. Type: MT_EX_OS, Context: mem
> 12:28:10 Action: Please notify IBM Informix Technical Support.
> 12:28:10 stack trace for pid 2816 written to /tmp/af.4126e99
> 12:28:10 See Also: /tmp/af.4126e99
> 12:28:14 mtex.c, line 431, thread 47, proc id 2816, No Exception
> Handler.
> 12:28:14 Fatal error in ADM VP at mt.c:12351
> 12:28:14 Unexpected virtual processor termination, pid = 2816, exit => 0x100
>
> 12:28:15 PANIC: Attempting to bring system down
> 12:28:15 semctl: errno = 22
> <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>
> >From now, IDS failed to start - even with CDRBLOCKOUT -
> and I had to cold restore it with ontape.
>
> Stack from AF file:
> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> 12:28:10 Stack for thread: 47 CDRNsT9>
> base: 0x00000001988eb000
> len: 69632
> pc: 0x000000010087eb14
> tos: 0x00000001988fa6f1
> state: running
> vp: 1
>
> 0x10087eb14 oninit :: afstack + 0x34 sp=0x1988faef0(0x988dc1c0,
> 0x98875fc8, 0x1000009, 0x0, 0x0, 0x0)
> 0x100883914 oninit :: mt_ex_throw_sig + 0x300 sp=0x1988fb1c0
> delta_sp=720(0xcd27c0, 0xe37758, 0x0, 0xef86d0, 0xe3ae08, 0x988dc1c0)
> 0x1008436a0 oninit :: afsig_handler + 0x158 sp=0x1988fb380
> delta_sp=448(0xee30c8, 0x41b0, 0xe37718, 0xe37758, 0x4000, 0x0)
> 0xffffffff7dea7014 /usr/lib/sparcv9/libc.so.1 :: _setuid + 0x4c
> sp=0x1988fb440 delta_sp=192(0xa, 0x988fb890, 0x988fb5b0, 0xa,
> 0x988fbb2c, 0x988d8810)
> 0x1009d9614 oninit :: genRapGetMessage + 0x200 sp=0x1988fb4f0
> delta_sp=176(0x989bd9c0, 0xc28d8, 0xeeb480, 0x988fbb28, 0x988fbb24,
> 0x1)
> 0x1009d6298 oninit :: nifCompatSend + 0x26c sp=0x1988fba50
> delta_sp=1376(0xedd040, 0xb3b44, 0x66000, 0xd25408, 0x0, 0x988d8548)
> 0x1009d54b0 oninit :: nifSend + 0x154 sp=0x1988fbb30
> delta_sp=224(0x988d8810, 0x98875ca8, 0x660b8, 0xd25408, 0x988d8810,
> 0x988d8810)
> 0x1009d2c90 oninit :: nifiGenericStart + 0x1078 sp=0x1988fbbe0
> delta_sp=176(0xcd8ff0, 0x988fbe4c, 0x988d8810, 0x46, 0x660b8,
> 0x988d8548)
> 0x1009819b4 oninit :: cdrTrampolineThread + 0xc0 sp=0x1988fbd90
> delta_sp=432(0xcd09a0, 0x9d1c18, 0x988d8810, 0x983e0330, 0x988dc1c0,
> 0x0)
> 0x1008547f0 oninit :: startup + 0xfc sp=0x1988fbe50
> delta_sp=192(0xf0dbd0, 0x6, 0xee30c8, 0x97019b50, 0x98801040,
> 0x97019ad8)
> 12:28:10
> 12:28:10 IBM Informix Dynamic Server Version 9.40.FC5 Software> Serial Number AAA#B000000
> 12:28:10 Assert Failed: No Exception Handler
> 12:28:10 Who: Session(20, root@prim, 0, 1976c4048)
> Thread(47, CDRNsT9, 197688b20, 1)
> File: mtex.c Line: 431
> 12:28:10 Results: Exception Caught. Type: MT_EX_OS, Context: mem
> 12:28:10 Action: Please notify IBM Informix Technical Support.
> 12:28:10 Stack for thread: 47 CDRNsT9>
> base: 0x00000001988eb000
> len: 69632
> pc: 0x000000010087eb14
> tos: 0x00000001988f9f11
> state: running
> vp: 1
>
> 0x10087eb14 oninit :: afstack + 0x34 sp=0x1988fa710(0x988dc1c0,
> 0x98875fc8, 0x1000009, 0x0, 0xf02ef0, 0x988faca0)
> 0x10087db78 oninit :: afhandler + 0xaf8 sp=0x1988fa9e0
> delta_sp=720(0xcd4de0, 0x97f4a028, 0x988fb280, 0x601, 0x1, 0xf0dbd0)
> 0x10087d070 oninit :: afcrash_interface + 0x4c sp=0x1988fb100
> delta_sp=1824(0xe3ae38, 0x988fb280, 0x97f4a028, 0xe3ae50, 0x1af, 0x0)
> 0x1008839e0 oninit :: mt_ex_throw_sig + 0x3cc sp=0x1988fb1c0
> delta_sp=192(0xcd27c0, 0xe37758, 0x0, 0xef86d0, 0xe3ae08, 0x988dc1c0)
> 0x1008436a0 oninit :: afsig_handler + 0x158 sp=0x1988fb380
> delta_sp=448(0xee30c8, 0x41b0, 0xe37718, 0xe37758, 0x4000, 0x0)
> 0xffffffff7dea7014 /usr/lib/sparcv9/libc.so.1 :: _setuid + 0x4c
> sp=0x1988fb440 delta_sp=192(0xa, 0x988fb890, 0x988fb5b0, 0xa,
> 0x988fbb2c, 0x988d8810)
> 0x1009d9614 oninit :: genRapGetMessage + 0x200 sp=0x1988fb4f0
> delta_sp=176(0x989bd9c0, 0xc28d8, 0xeeb480, 0x988fbb28, 0x988fbb24,
> 0x1)
> 0x1009d6298 oninit :: nifCompatSend + 0x26c sp=0x1988fba50
> delta_sp=1376(0xedd040, 0xb3b44, 0x66000, 0xd25408, 0x0, 0x988d8548)
> 0x1009d54b0 oninit :: nifSend + 0x154 sp=0x1988fbb30
> delta_sp=224(0x988d8810, 0x98875ca8, 0x660b8, 0xd25408, 0x988d8810,
> 0x988d8810)
> 0x1009d2c90 oninit :: nifiGenericStart + 0x1078 sp=0x1988fbbe0
> delta_sp=176(0xcd8ff0, 0x988fbe4c, 0x988d8810, 0x46, 0x660b8,
> 0x988d8548)
> 0x1009819b4 oninit :: cdrTrampolineThread + 0xc0 sp=0x1988fbd90
> delta_sp=432(0xcd09a0, 0x9d1c18, 0x988d8810, 0x983e0330, 0x988dc1c0,
> 0x0)
> 0x1008547f0 oninit :: startup + 0xfc sp=0x1988fbe50
> delta_sp=192(0xf0dbd0, 0x6, 0xee30c8, 0x97019b50, 0x98801040,
> 0x97019ad8)
>
> ===========------------- - - - - - -
> /usr/informix/server/bin/onstat -g stk 47 light:
>
> IBM Informix Dynamic Server Version 9.40.FC5 -- On-Line -- Up
> 00:00:22 -- 2834432 Kbytes>
> Stack for thread: 47 CDRNsT9
> base: 0x00000001988eb000
> len: 69632
> pc: 0x00000001008510d0
> tos: 0x00000001988fa131> state: running
> vp: 1
>
> 0x1008510d0 oninit :: mt_system + 0x11c sp=0x1988fa930(0xeda7b0,
> 0x988faca0, 0x97018c70, 0x3, 0x0, 0x988fab98)
> 0x10087df8c oninit :: afhandler + 0xf0c sp=0x1988fa9e0
> delta_sp=176(0xcd4de8, 0xef86d0, 0x3, 0x601, 0x1, 0xf0dbd0)
> 0x10087d070 oninit :: afcrash_interface + 0x4c sp=0x1988fb100
> delta_sp=1824(0xe3ae38, 0x988fb280, 0x97f4a028, 0xe3ae50, 0x1af, 0x0)
> 0x1008839e0 oninit :: mt_ex_throw_sig + 0x3cc sp=0x1988fb1c0
> delta_sp=192(0xcd27c0, 0xe37758, 0x0, 0xef86d0, 0xe3ae08, 0x988dc1c0)
> 0x1008436a0 oninit :: afsig_handler + 0x158 sp=0x1988fb380
> delta_sp=448(0xee30c8, 0x41b0, 0xe37718, 0xe37758, 0x4000, 0x0)
> 0xffffffff7dea7014 ?unknown? :: ?unknown? + 0x0 sp=0x1988fb440
> delta_sp=192(0xa, 0x988fb890, 0x988fb5b0, 0xa, 0x988fbb2c, 0x988d8810)
> 0x1009d9614 oninit :: genRapGetMessage + 0x200 sp=0x1988fb4f0
> delta_sp=176(0x989bd9c0, 0xc28d8, 0xeeb480, 0x988fbb28, 0x988fbb24,
> 0x
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g