Undefined replicate crashes IDS

Hi, ER crashed destination server due to error in defining replicate. online.log look as: ------------------ 15:07:32 Logical Log 3297 Complete. 15:10:22 CDR GC peer request failed: message 1, error 39, CDR server 7 15:10:23 CDR GC peer request failed: message 3, error 31, CDR server 7 15:28:59 CDR CDRD_9: transaction aborted (Error in retrieving the replicate's attributes) 15:28:59 Assert Failed: No Exception Handler 15:28:59 Informix Dynamic Server 2000 Version 9.21.UC2 15:28:59 Who: Session(843, root@hermes2, 0, -1793780548) Thread(20852, CDRD_9, 9512cd18, 4) File: mtex.c Line: 405 15:28:59 Results: Exception Caught. Type: MT_EX_OS, Context: mem 15:28:59 Action: Please notify Informix Technical Support. 15:28:59 stack trace for pid 288 written to /usr/informix/crashes/af.555c588a 15:28:59 See Also: /usr/informix/crashes/af.555c588a `cdr error -an` at source server displays: ----------------------------- SERVER:SEQNO REVIEW TIME ERROR g_ganimed_ids:1 N 2004-01-05 15:10:22 39 GC operation define replicate 'RPL_h_real_2004' failed: illegal select clause sy[ntax] g_ganimed_ids:2 N 2004-01-05 15:10:22 31 GC operation start replicate 'RPL_h_real_2004' failed: undefined replicate Now each time I try to start up dest server it crashes with: ------------------------------- 16:11:17 Begin recreating indexes deferred during recovery. 16:11:17 On-Line Mode 16:11:17 Affinitied VP 1 to phys proc 1 16:11:17 Affinitied VP 3 to phys proc 2 16:11:17 Affinitied VP 4 to phys proc 3 16:11:18 Recreating index: 're1:"tecsys".h_real_2004-h_real_2004_3' 16:11:18 Recreating index: 're1:"tecsys".h_real_2004-h_real_2004_2' 16:11:18 Recreating index: 're1:"tecsys".h_real_2004-h_real_2004_1' 16:11:18 Recreating index: 're1:"tecsys".h_real_2004- 322_356' 16:11:18 Completed recreating indexes. 16:11:18 CDR GC: catalog recovery begin 16:11:22 CDR GC: cache query failed for repl/coll identifier 458848. 16:11:22 CDR GC: catalog recovery complete 16:11:22 CDR queuer initialization complete 16:11:25 CDR CDRD_0: transaction aborted (Error in retrieving the replicate's attributes) 16:11:25 Assert Failed: No Exception Handler 16:11:25 Informix Dynamic Server 2000 Version 9.21.UC2 16:11:25 Who: Session(28, root@hermes2, 0, -1793796368) Thread(78, CDRD_0, 951232b8, 4) File: mtex.c Line: 405 16:11:25 Results: Exception Caught. Type: MT_EX_OS, Context: mem 16:11:25 Action: Please notify Informix Technical Support. 16:11:25 stack trace for pid 12490 written to /usr/informix/crashes/af.436627d 16:11:25 See Also: /usr/informix/crashes/af.436627d 16:11:35 mtex.c, line 405, thread 78, proc id 12490, No Exception Handler. 16:11:35 Fatal error in ADM VP at mt.c:11375 16:11:35 Unexpected virtual processor termination, pid = 12490, exit =0x100 16:11:36 PANIC: Attempting to bring system down Please, how can I bring up dest server without having to stop/start the whole ER? Hopefully, Denis Melnikov

9.21 uses the environment variable CDRBLOCKOUT to start the engine without ER. I'd like to see the stack trace. There was a problem with ER trying to print an ATS file when it could not get to the description of the replicated row. I'm guessing that is causing the problem, but would need to see the stack to determine that. "Denis Melnikov" <dm'Inik@r'gent.r'> wrote in message news:btbqh0$i5i$1@n6.co.ru... > Hi, > > ER crashed destination server due to error in defining replicate. > > online.log look as: > ------------------ > > 15:07:32 Logical Log 3297 Complete. > 15:10:22 CDR GC peer request failed: message 1, error 39, CDR server 7 > 15:10:23 CDR GC peer request failed: message 3, error 31, CDR server 7 > 15:28:59 CDR CDRD_9: transaction aborted (Error in retrieving the > replicate's attributes) > 15:28:59 Assert Failed: No Exception Handler > 15:28:59 Informix Dynamic Server 2000 Version 9.21.UC2 > 15:28:59 Who: Session(843, root@hermes2, 0, -1793780548) > Thread(20852, CDRD_9, 9512cd18, 4) > File: mtex.c Line: 405 > 15:28:59 Results: Exception Caught. Type: MT_EX_OS, Context: mem > 15:28:59 Action: Please notify Informix Technical Support. > 15:28:59 stack trace for pid 288 written to > /usr/informix/crashes/af.555c588a > 15:28:59 See Also: /usr/informix/crashes/af.555c588a> > `cdr error -an` at source server displays: > ----------------------------- > > SERVER:SEQNO REVIEW TIME ERROR > g_ganimed_ids:1 N 2004-01-05 15:10:22 39 > GC operation define replicate 'RPL_h_real_2004' failed: illegal select > clause sy[ntax] > g_ganimed_ids:2 N 2004-01-05 15:10:22 31 > GC operation start replicate 'RPL_h_real_2004' failed: undefined replicate > > Now each time I try to start up dest server it crashes with: > ------------------------------- > > 16:11:17 Begin recreating indexes deferred during recovery. > 16:11:17 On-Line Mode > 16:11:17 Affinitied VP 1 to phys proc 1 > 16:11:17 Affinitied VP 3 to phys proc 2 > 16:11:17 Affinitied VP 4 to phys proc 3 > 16:11:18 Recreating index: 're1:"tecsys".h_real_2004-h_real_2004_3' > 16:11:18 Recreating index: 're1:"tecsys".h_real_2004-h_real_2004_2' > 16:11:18 Recreating index: 're1:"tecsys".h_real_2004-h_real_2004_1' > 16:11:18 Recreating index: 're1:"tecsys".h_real_2004- 322_356' > 16:11:18 Completed recreating indexes. > 16:11:18 CDR GC: catalog recovery begin > 16:11:22 CDR GC: cache query failed for repl/coll identifier 458848. > 16:11:22 CDR GC: catalog recovery complete > 16:11:22 CDR queuer initialization complete > 16:11:25 CDR CDRD_0: transaction aborted (Error in retrieving the > replicate's attributes) > 16:11:25 Assert Failed: No Exception Handler > 16:11:25 Informix Dynamic Server 2000 Version 9.21.UC2 > 16:11:25 Who: Session(28, root@hermes2, 0, -1793796368) > Thread(78, CDRD_0, 951232b8, 4) > File: mtex.c Line: 405 > 16:11:25 Results: Exception Caught. Type: MT_EX_OS, Context: mem > 16:11:25 Action: Please notify Informix Technical Support. > 16:11:25 stack trace for pid 12490 written to > /usr/informix/crashes/af.436627d > 16:11:25 See Also: /usr/informix/crashes/af.436627d > 16:11:35 mtex.c, line 405, thread 78, proc id 12490, No Exception Handler. > 16:11:35 Fatal error in ADM VP at mt.c:11375 > 16:11:35 Unexpected virtual processor termination, pid = 12490, exit => 0x100 > 16:11:36 PANIC: Attempting to bring system down> > Please, how can I bring up dest server without having to stop/start > the whole ER? > > Hopefully, > Denis Melnikov > >

Is it what you need? ===========------------- - - - - - - /usr/informix/server/bin/onstat -g stk 20852 light: Informix Dynamic Server 2000 Version 9.21.UC2 -- On-Line -- Up 16 days 00:24 52 -- 1654784 Kbytes Stack for thread: 20852 CDRD_9 base: 0x96b37018 len: 66048 pc: 0x085138eb tos: 0x96b45fd4state: running vp: 4 0x0852b06d (oninit)afhandler(0x96b460fc, 0xb, 0x969156a0) 0x0852aa6a (oninit)afcrash_interface(0x3, 0x8749ef0, 0x96b46574) 0x0852d57f (oninit)mt_ex_throw_sig(0x8749ef0, 0x96b46574, 0x96d1b648) 0x0850ca0e (oninit)afsig_handler(0x1, 0x8746534, 0x0) 0xdfbbd32f (*nosymtab*)0xdfbbd32f(0xb, 0x96b46960, 0x96b46760) 0xdfbca441 (*nosymtab*)0xdfbca441(0xb, 0x96b46960, 0x96b46760) 0xffffffff (*nosymtab*)0xffffffff(0xb, 0x96b46960, 0x96b46760) 0x085df288 (oninit)dsiSpool(0x6f, 0x96346708, 0x95c66020) 0x085da429 (oninit)dsiAbortTx(0x95c66020, 0x96b47080, 0x96b470f0) 0x085d999a (oninit)dsiResolverThread(0x95f2e0f8, 0x96346ef8, 0x96b47080) 0x085153a3 (oninit)startup (0x96346ef8, 0x0, 0x0) 0x00000000 (*nosymtab*)0x0 "Madison Pruet" <mpruet@comcast.net> '''''''/'''''''' ' '''''''' ''''''''': news:xzgKb.741616$HS4.5686487@attbi_s01... > 9.21 uses the environment variable CDRBLOCKOUT to start the engine without > ER. I'd like to see the stack trace. > > There was a problem with ER trying to print an ATS file when it could not > get to the description of the replicated row. I'm guessing that is causing > the problem, but would need to see the stack to determine that.

"Madison Pruet" <mpruet@comcast.net> '''''''/'''''''' ' '''''''' ''''''''': news:xzgKb.741616$HS4.5686487@attbi_s01... > 9.21 uses the environment variable CDRBLOCKOUT to start the engine without > ER. I'd like to see the stack trace. What if I set CDRBLOCKOUT, 'oninit', the engine start w/o ER, then 'onmode -ky', unset CDRBLOCKOUT, then 'oninit' again? The engine begin to apply spooled transactions including erroneous and crash again? Can I bring up my DEST server with no losses?

"Denis Melnikov" <dm'Inik@r'gent.r'> '''''''/'''''''' ' '''''''' ''''''''': news:btdq8f$ar6$1@n6.co.ru... > "Madison Pruet" <mpruet@comcast.net> '''''''/'''''''' ' '''''''' ''''''''': > news:xzgKb.741616$HS4.5686487@attbi_s01... > > 9.21 uses the environment variable CDRBLOCKOUT to start the engine without > > ER. I'd like to see the stack trace. > > What if I set CDRBLOCKOUT, 'oninit', the engine start w/o ER, then > 'onmode -ky', unset CDRBLOCKOUT, then 'oninit' again? The engine begin > to apply spooled transactions including erroneous and crash again? > Can I bring up my DEST server with no losses? P.S. I mean dest server is read only.