Oninit cdi / Archive
Talk to an expert →

HDR exception error

Posted in 2007

Topics: High Availability & Replication, Error Codes & Troubleshooting, Versions, Editions & End-of-Life

Long Nguyen — — source: IIUG Forums & Mailing Lists

Hi all, We have just (for the 1st time) encountered an error which brought down the secondary database and stopped HDR connection (IDS 10.00.FC4W3): 10:51:51 Assert Failed: No Exception Handler 10:51:51 Who: Session(1, informix@drminetdata, 0, 1504be940) Thread(35, dr_secrcv, 150489a60, 1) File: mtex.c Line: 435 10:51:51 Results: Exception Caught. Type: MT_EX_OS, Context: mem 10:51:51 Action: Please notify IBM Informix Technical Support. 10:51:51 Stack for thread: 35 dr_secrcv 10:51:55 invoke_alarm(): mt_exec failed, status 256, errno 0 10:51:55 PANIC: Attempting to bring system down. ...... The database was offline after then.... Has anybody ever come across this HDR problem? Regards, Long Huy Nguyen MIS(Analyst Programmer) Ruralco Limited P.O.Box 515 Wentworthville NSW 2145 (Ph) 02 9688 8528 (Fax) 02 9896 7763 lnguyen@ruralco.com.au

↪ replying to Long Nguyen
Mohamed Marwan — — source: IIUG Forums & Mailing Lists

Hi, I think that there is a problem in the physical media of the replication pair machine. Regards, Mohammad Marwan. Senior DBA and Unix administrator IBM - DB2 - Certified Solutions Expert Oracle Certified Associate Mediterranean Smart Cards Company 92 Eltahrir st., Dokki, Cairo, Egypt. Tel: +20(2) 3331457 Mobile: +2 0122449825 Mail: mmarwan@mscc.com.eg www.mscc.com.eg -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Long Nguyen Sent: Wednesday, January 03, 2007 6:07 AM To: ids@iiug.org Subject: HDR exception error [8079] Hi all, We have just (for the 1st time) encountered an error which brought down the secondary database and stopped HDR connection (IDS 10.00.FC4W3): 10:51:51 Assert Failed: No Exception Handler 10:51:51 Who: Session(1, informix@drminetdata, 0, 1504be940) Thread(35, dr_secrcv, 150489a60, 1) File: mtex.c Line: 435 10:51:51 Results: Exception Caught. Type: MT_EX_OS, Context: mem 10:51:51 Action: Please notify IBM Informix Technical Support. 10:51:51 Stack for thread: 35 dr_secrcv 10:51:55 invoke_alarm(): mt_exec failed, status 256, errno 0 10:51:55 PANIC: Attempting to bring system down. ....... The database was offline after then.... Has anybody ever come across this HDR problem? Regards, Long Huy Nguyen MIS(Analyst Programmer) Ruralco Limited P.O.Box 515 Wentworthville NSW 2145 (Ph) 02 9688 8528 (Fax) 02 9896 7763 lnguyen@ruralco.com.au ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Mohamed Marwan
Long Nguyen — — source: IIUG Forums & Mailing Lists

HI Mohamed, Can you please elaborate a bit more on this?. I have checked with the Unix admin. and he told me the medium at the DR site has been no problem so far. Long N. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> "Mohamed Marwan" <mmarwan@mscc.com To: ids@iiug.org .eg> cc: Sent by: Subject: RE: HDR exception error [8081] ids-bounces@iiug. org 03/01/2007 07:03 PM Please respond to ids Hi, I think that there is a problem in the physical media of the replication pair machine. Regards, Mohammad Marwan. Senior DBA and Unix administrator IBM - DB2 - Certified Solutions Expert Oracle Certified Associate Mediterranean Smart Cards Company 92 Eltahrir st., Dokki, Cairo, Egypt. Tel: +20(2) 3331457 Mobile: +2 0122449825 Mail: mmarwan@mscc.com.eg www.mscc.com.eg -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Long Nguyen Sent: Wednesday, January 03, 2007 6:07 AM To: ids@iiug.org Subject: HDR exception error [8079] Hi all, We have just (for the 1st time) encountered an error which brought down the secondary database and stopped HDR connection (IDS 10.00.FC4W3): 10:51:51 Assert Failed: No Exception Handler 10:51:51 Who: Session(1, informix@drminetdata, 0, 1504be940) Thread(35, dr_secrcv, 150489a60, 1) File: mtex.c Line: 435 10:51:51 Results: Exception Caught. Type: MT_EX_OS, Context: mem 10:51:51 Action: Please notify IBM Informix Technical Support. 10:51:51 Stack for thread: 35 dr_secrcv 10:51:55 invoke_alarm(): mt_exec failed, status 256, errno 0 10:51:55 PANIC: Attempting to bring system down. ........ The database was offline after then.... Has anybody ever come across this HDR problem? Regards, Long Huy Nguyen MIS(Analyst Programmer) Ruralco Limited P.O.Box 515 Wentworthville NSW 2145 (Ph) 02 9688 8528 (Fax) 02 9896 7763 lnguyen@ruralco.com.au ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Long Nguyen
Mohamed Marwan — — source: IIUG Forums & Mailing Lists

Sure, you may check the action mentioned in the online.log file, I guess it will be to apply oncheck -cI ..... command. Regards, Mohammad Marwan. Senior DBA and Unix administrator IBM - DB2 - Certified Solutions Expert Oracle Certified Associate Mediterranean Smart Cards Company 92 Eltahrir st., Dokki, Cairo, Egypt. Tel: +20(2) 3331457 Mobile: +2 0122449825 Mail: mmarwan@mscc.com.eg www.mscc.com.eg -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Long Nguyen Sent: Thursday, January 04, 2007 1:49 AM To: ids@iiug.org Subject: RE: HDR exception error [8096] HI Mohamed, Can you please elaborate a bit more on this?. I have checked with the Unix admin. and he told me the medium at the DR site has been no problem so far. Long N. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> "Mohamed Marwan" <mmarwan@mscc.com To: ids@iiug.org ..eg> cc: Sent by: Subject: RE: HDR exception error [8081] ids-bounces@iiug. org 03/01/2007 07:03 PM Please respond to ids Hi, I think that there is a problem in the physical media of the replication pair machine. Regards, Mohammad Marwan. Senior DBA and Unix administrator IBM - DB2 - Certified Solutions Expert Oracle Certified Associate Mediterranean Smart Cards Company 92 Eltahrir st., Dokki, Cairo, Egypt. Tel: +20(2) 3331457 Mobile: +2 0122449825 Mail: mmarwan@mscc.com.eg www.mscc.com.eg -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Long Nguyen Sent: Wednesday, January 03, 2007 6:07 AM To: ids@iiug.org Subject: HDR exception error [8079] Hi all, We have just (for the 1st time) encountered an error which brought down the secondary database and stopped HDR connection (IDS 10.00.FC4W3): 10:51:51 Assert Failed: No Exception Handler 10:51:51 Who: Session(1, informix@drminetdata, 0, 1504be940) Thread(35, dr_secrcv, 150489a60, 1) File: mtex.c Line: 435 10:51:51 Results: Exception Caught. Type: MT_EX_OS, Context: mem 10:51:51 Action: Please notify IBM Informix Technical Support. 10:51:51 Stack for thread: 35 dr_secrcv 10:51:55 invoke_alarm(): mt_exec failed, status 256, errno 0 10:51:55 PANIC: Attempting to bring system down. ......... The database was offline after then.... Has anybody ever come across this HDR problem? Regards, Long Huy Nguyen MIS(Analyst Programmer) Ruralco Limited P.O.Box 515 Wentworthville NSW 2145 (Ph) 02 9688 8528 (Fax) 02 9896 7763 lnguyen@ruralco.com.au ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This e-mail (including attachments) is classified as Mediterranean Smart Cards Company confidential and proprietary information The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, and information) and not to disclose to any third party without the prior written consent of Mediterranean Smart Cards Company. Recipient will be held liable for any unauthorized disclosure. It is intended solely for the addressee. Unless you are the addressee, you may not read, copy, use or store this e-mail in any way, or permit others to. If you have received it in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

↪ replying to Mohamed Marwan
Long Nguyen — — source: IIUG Forums & Mailing Lists

We are very familiar with "oncheck -cI or -cDI ..." command (often do before executing "onmode -d index ..." to send the corrupted index to the secondary database. But the contents of this af file is not for oncheck -cI because it is somehow related to a previous error in whcih "DBchunk 32 is offline". And I believe this DBchunk offline is the accumulative result of so many "inconsistencies" errors (that involves the oncheck -cI or -CDI) before. I just don't know the cause. Now we have decided to "re-boot" the DR ciste from time to time to reduce this problem. We'll just re-booted yesterday and it seems OK (clean) so far. Only one af file is created (also referred to the same big file's index corruption on the DR site). Maybe the network transfer facilty is not good enough to handle the transfer of this big file (IT is alode noted that we don't encounter data corruption for this file but only one of its indexes is corrupted somehow after the transfer to the DR side). Long N. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> "Mohamed Marwan" <mmarwan@mscc.com To: ids@iiug.org .eg> cc: Sent by: Subject: RE: HDR exception error [8102] ids-bounces@iiug. org 04/01/2007 08:05 PM Please respond to ids Sure, you may check the action mentioned in the online.log file, I guess it will be to apply oncheck -cI ..... command. Regards, Mohammad Marwan. Senior DBA and Unix administrator IBM - DB2 - Certified Solutions Expert Oracle Certified Associate Mediterranean Smart Cards Company 92 Eltahrir st., Dokki, Cairo, Egypt. Tel: +20(2) 3331457 Mobile: +2 0122449825 Mail: mmarwan@mscc.com.eg www.mscc.com.eg -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Long Nguyen Sent: Thursday, January 04, 2007 1:49 AM To: ids@iiug.org Subject: RE: HDR exception error [8096] HI Mohamed, Can you please elaborate a bit more on this?. I have checked with the Unix admin. and he told me the medium at the DR site has been no problem so far. Long N. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> "Mohamed Marwan" <mmarwan@mscc.com To: ids@iiug.org ...eg> cc: Sent by: Subject: RE: HDR exception error [8081] ids-bounces@iiug. org 03/01/2007 07:03 PM Please respond to ids Hi, I think that there is a problem in the physical media of the replication pair machine. Regards, Mohammad Marwan. Senior DBA and Unix administrator IBM - DB2 - Certified Solutions Expert Oracle Certified Associate Mediterranean Smart Cards Company 92 Eltahrir st., Dokki, Cairo, Egypt. Tel: +20(2) 3331457 Mobile: +2 0122449825 Mail: mmarwan@mscc.com.eg www.mscc.com.eg -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Long Nguyen Sent: Wednesday, January 03, 2007 6:07 AM To: ids@iiug.org Subject: HDR exception error [8079] Hi all, We have just (for the 1st time) encountered an error which brought down the secondary database and stopped HDR connection (IDS 10.00.FC4W3): 10:51:51 Assert Failed: No Exception Handler 10:51:51 Who: Session(1, informix@drminetdata, 0, 1504be940) Thread(35, dr_secrcv, 150489a60, 1) File: mtex.c Line: 435 10:51:51 Results: Exception Caught. Type: MT_EX_OS, Context: mem 10:51:51 Action: Please notify IBM Informix Technical Support. 10:51:51 Stack for thread: 35 dr_secrcv 10:51:55 invoke_alarm(): mt_exec failed, status 256, errno 0 10:51:55 PANIC: Attempting to bring system down. .......... The database was offline after then.... Has anybody ever come across this HDR problem? Regards, Long Huy Nguyen MIS(Analyst Programmer) Ruralco Limited P.O.Box 515 Wentworthville NSW 2145 (Ph) 02 9688 8528 (Fax) 02 9896 7763 lnguyen@ruralco.com.au ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This e-mail (including attachments) is classified as Mediterranean Smart Cards Company confidential and proprietary information The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, and information) and not to disclose to any third party without the prior written consent of Mediterranean Smart Cards Company. Recipient will be held liable for any unauthorized disclosure. It is intended solely for the addressee. Unless you are the addressee, you may not read, copy, use or store this e-mail in any way, or permit others to. If you have received it in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary