Informix Instance Crash
Hello All, I have a occured a problem, in which my database instance get crashed and i have found the following error in the online.log file. Kindly help me in finding the root cause of this crash, so that i could avoid such crash in future. 06:07:48 Maximum server connections 117 06:08:53 stack trace for pid 25462 written to /u/informix/tmp/af.a9f4965 06:08:53 Assert Failed: No Exception Handler 06:08:53 IBM Informix Dynamic Server Version 10.00.FC5 06:08:53 Who: Session(2461, scmroot@10.10.10.3, -1, 119b44b68) Thread(1719, sqlexec, 119b366a8, 4) File: mtex.c Line: 472 06:08:53 Results: Exception Caught. Type: MT_EX_OS, Context: mem 06:08:53 Action: Please notify IBM Informix Technical Support. 06:08:53 stack trace for pid 25462 written to /u/informix/tmp/af.a9f4965 06:08:53 See Also: /u/informix/tmp/af.a9f4965, shmem.a9f4965.0 06:09:18 mtex.c, line 472, thread 1719, proc id 25462, No Exception Handler. 06:09:20 Fatal error in ADM VP at mt.c:13055 06:09:20 Unexpected virtual processor termination, pid = 25462, exit = 0x100 06:09:20 PANIC: Attempting to bring system down 06:16:30 IBM Informix Dynamic Server Started. 06:16:30 The number of configured CPU poll threads exceeds 'NUMCPUVPS'. NETTYPE 'ids_mcp06' poll threads started on NET VPs. I will be looking forward for the prompt response. NOTE: Also let me know how can i attach the /u/informix/tmp/af.a9f4965 for the reference, with this message? Let me know in case of any further assistance/query. Regards, Omer Saeed Khan
Hi, for a first (quick) analysis, the interesting part of the af-file is the function call stack trace of the thread that reported the problem. Usually this is at the beginning of the af-file, right after a repetition of the af-message as seen in the online.log file. Depending on configuration the af-file can be rather large. To be sure, keep it for future reference, as IBM Informix Tech Support will ask you for it when you open a call/case (PMR) for this problem. But to send in an e-mail to this list, the above described stack trace as an excerpt from the file, put as plain text into the e-mail (cut & paste) would be good enough to start with. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management IBM Deutschland GmbH Chairman of the Supervisory Board: Hans Ulrich Märki Board of Management: Martin Jetter (Chairman), Rudolf Bauer, Christian Diedrich, Christoph Grandpierre, Matthias Hartmann, Thomas Fell, Michael Diemer Corporate Seat: Stuttgart, Germany; Reg.-Gericht: Amtsgericht Stuttgart, HRB-Nr.: 14 562 WEEE-Reg.-Nr. DE 99369940 ids-bounces@iiug.org wrote on 21.06.2007 10:41:18: > Hello All, > > I have a occured a problem, in which my database instance get crashed and i > have found the following error in the online.log file. Kindly help me in > finding the root cause of this crash, so that i could avoid such crash in > future. > > 06:07:48 Maximum server connections 117 > 06:08:53 stack trace for pid 25462 written to /u/informix/tmp/af.a9f4965 > 06:08:53 Assert Failed: No Exception Handler > 06:08:53 IBM Informix Dynamic Server Version 10.00.FC5 > 06:08:53 Who: Session(2461, scmroot@10.10.10.3, -1, 119b44b68) > Thread(1719, sqlexec, 119b366a8, 4) > File: mtex.c Line: 472 > 06:08:53 Results: Exception Caught. Type: MT_EX_OS, Context: mem > 06:08:53 Action: Please notify IBM Informix Technical Support. > 06:08:53 stack trace for pid 25462 written to /u/informix/tmp/af.a9f4965 > 06:08:53 See Also: /u/informix/tmp/af.a9f4965, shmem.a9f4965.0 > 06:09:18 mtex.c, line 472, thread 1719, proc id 25462, No Exception Handler. > 06:09:20 Fatal error in ADM VP at mt.c:13055 > 06:09:20 Unexpected virtual processor termination, pid = 25462, exit = 0x100 > > 06:09:20 PANIC: Attempting to bring system down > 06:16:30 IBM Informix Dynamic Server Started. > 06:16:30 The number of configured CPU poll threads exceeds 'NUMCPUVPS'. > NETTYPE 'ids_mcp06' poll threads started on NET VPs. > > I will be looking forward for the prompt response. > > NOTE: Also let me know how can i attach the /u/informix/tmp/af.a9f4965 for the > reference, with this message? > > Let me know in case of any further assistance/query. > > Regards, > Omer Saeed Khan > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum.
> 06:16:30 The number of configured CPU poll threads exceeds 'NUMCPUVPS'. > NETTYPE 'ids_mcp06' poll threads started on NET VPs. It looks like you might have your NETTYPE parameters in the wrong order in your onconfig file. Guy ----- Original Message ---- From: OMER KHAN <oskhan@i2cinc.com> To: ids@iiug.org Sent: Thursday, June 21, 2007 1:41:18 AM Subject: Informix Instance Crash [9396] Hello All, I have a occured a problem, in which my database instance get crashed and i have found the following error in the online.log file. Kindly help me in finding the root cause of this crash, so that i could avoid such crash in future. 06:07:48 Maximum server connections 117 06:08:53 stack trace for pid 25462 written to /u/informix/tmp/af.a9f4965 06:08:53 Assert Failed: No Exception Handler 06:08:53 IBM Informix Dynamic Server Version 10.00.FC5 06:08:53 Who: Session(2461, scmroot@10.10.10.3, -1, 119b44b68) Thread(1719, sqlexec, 119b366a8, 4) File: mtex.c Line: 472 06:08:53 Results: Exception Caught. Type: MT_EX_OS, Context: mem 06:08:53 Action: Please notify IBM Informix Technical Support. 06:08:53 stack trace for pid 25462 written to /u/informix/tmp/af.a9f4965 06:08:53 See Also: /u/informix/tmp/af.a9f4965, shmem.a9f4965.0 06:09:18 mtex.c, line 472, thread 1719, proc id 25462, No Exception Handler. 06:09:20 Fatal error in ADM VP at mt.c:13055 06:09:20 Unexpected virtual processor termination, pid = 25462, exit = 0x100 06:09:20 PANIC: Attempting to bring system down 06:16:30 IBM Informix Dynamic Server Started. 06:16:30 The number of configured CPU poll threads exceeds 'NUMCPUVPS'. NETTYPE 'ids_mcp06' poll threads started on NET VPs. I will be looking forward for the prompt response. NOTE: Also let me know how can i attach the /u/informix/tmp/af.a9f4965 for the reference, with this message? Let me know in case of any further assistance/query. Regards, Omer Saeed Khan ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________________ ___ You snooze, you lose. Get messages ASAP with AutoCheck in the all-new Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/newmail_html.html