dbTalk Databases Forums  

EDR 9.40.FC5 -> 9.21.UC2 crashes engine

comp.databases.informix comp.databases.informix


Discuss EDR 9.40.FC5 -> 9.21.UC2 crashes engine in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
dm
 
Posts: n/a

Default EDR 9.40.FC5 -> 9.21.UC2 crashes engine - 08-24-2005 , 02:16 AM






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:
Quote:
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:

Quote:
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
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< <

Quote:
From now, IDS failed to start - even with CDRBLOCKOUT -
and I had to cold restore it with ontape.

Stack from AF file:
Quote:
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,
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)
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< <<<<<<<<



Reply With Quote
  #2  
Old   
Madison Pruet
 
Posts: n/a

Default Re: EDR 9.40.FC5 -> 9.21.UC2 crashes engine - 08-24-2005 , 11:57 AM






Do you have a case number?

"dm" <dmelnik (AT) regent (DOT) ru> wrote

Quote:
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,
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)





Reply With Quote
  #3  
Old   
try_and_err@web.de
 
Posts: n/a

Default Re: EDR 9.40.FC5 -> 9.21.UC2 crashes engine - 08-25-2005 , 06:04 PM



To clarify some things (see below):
dm schrieb:
Quote:
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.
=> You must set "export CDRSITES_92x=3" on your 9.40'er version !

Quote:
`cdr define server` executed successfully. After that,
when I run `define replicate` & `start replicate` for
several tables in a batch, the primary engine crashed:
...
From now, IDS failed to start - even with CDRBLOCKOUT -
and I had to cold restore it with ontape.
=> Since 9.30 you can't use "CDRBLOCKOUT" (defunct), use "oninit -D"
instead (starts Informix without ER).

Regards,
try_and_err



Reply With Quote
  #4  
Old   
try_and_err@web.de
 
Posts: n/a

Default Re: EDR 9.40.FC5 -> 9.21.UC2 crashes engine - 08-25-2005 , 06:16 PM



it seems the day was to long:
"export CDRSITES_92x=9" was and is correct...


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.