Informix crash

Posted in 2007

Topics: Error Codes & Troubleshooting, Logging & Checkpoints, Platform-Specific Issues, Versions, Editions & End-of-Life

Neil Truby — Sun, 29 Jul 2007 12:07:11 +0100 — source: Usenet: comp.databases.informix

IDS 10.0FC5 on AIX 5.3 Don't suppose much can be told from this, but has anyone any ideas about this failure yesterday?: 11:00:32 Maximum server connections 1145 11:04:20 Logical Log 29572 Complete, timestamp: 0xf00ac717. 11:04:21 Logical Log 29572 - Backup Started 11:04:23 Logical Log 29572 - Backup Completed 11:12:04 stack trace for pid 90576 written to /scratch/shmdumps/af.25d91674 11:12:04 Assert Failed: No Exception Handler 11:12:04 IBM Informix Dynamic Server Version 10.00.FC5 11:12:04 Who: Session(623836, xxxxxx@yyy-APP02, 25114, 7000002921e3a28) Thread(1712625, sqlexec, 7000002a4634d08, 11) File: mtex.c Line: 472 11:12:04 Results: Exception Caught. Type: MT_EX_OS, Context: mem 11:12:04 Action: Please notify IBM Informix Technical Support. 11:12:04 stack trace for pid 90576 written to /scratch/shmdumps/af.25d91674 11:12:04 See Also: /scratch/shmdumps/af.25d91674, shmem.25d91674.0 11:15:08 Logical Log 29573 Complete, timestamp: 0xf018a30c. 11:15:08 Logical Log 29573 - Backup Started 11:15:09 Logical Log 29573 - Backup Completed 11:15:32 Checkpoint Completed: duration was 0 seconds. 11:15:32 Checkpoint loguniq 29574, logpos 0x381018, timestamp: 0xf018d9b5 11:15:32 Maximum server connections 1145 11:17:00 mtex.c, line 472, thread 1712625, proc id 90576, No Exception Handler. 11:17:00 Fatal error in ADM VP at mt.c:13055 11:17:00 Unexpected virtual processor termination, pid = 90576, exit =0x100 11:17:00 PANIC: Attempting to bring system down -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com

↪ replying to Neil Truby

Neil Truby — Sun, 29 Jul 2007 12:47:46 +0100 — source: Usenet: comp.databases.informix

If anyone's really keen the af file is at http://homepage.ntlworld.com/neil.truby/ -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com "Neil Truby" <neil.truby@ardenta.com> wrote in message news:5h3an5F3ire6iU1@mid.individual.net... > IDS 10.0FC5 on AIX 5.3 > > Don't suppose much can be told from this, but has anyone any ideas about > this failure yesterday?: > > 11:00:32 Maximum server connections 1145 > 11:04:20 Logical Log 29572 Complete, timestamp: 0xf00ac717. > 11:04:21 Logical Log 29572 - Backup Started > 11:04:23 Logical Log 29572 - Backup Completed > 11:12:04 stack trace for pid 90576 written to > /scratch/shmdumps/af.25d91674 > 11:12:04 Assert Failed: No Exception Handler > 11:12:04 IBM Informix Dynamic Server Version 10.00.FC5 > 11:12:04 Who: Session(623836, xxxxxx@yyy-APP02, 25114, 7000002921e3a28) > Thread(1712625, sqlexec, 7000002a4634d08, 11) > File: mtex.c Line: 472 > 11:12:04 Results: Exception Caught. Type: MT_EX_OS, Context: mem > 11:12:04 Action: Please notify IBM Informix Technical Support. > 11:12:04 stack trace for pid 90576 written to > /scratch/shmdumps/af.25d91674 > 11:12:04 See Also: /scratch/shmdumps/af.25d91674, shmem.25d91674.0 > 11:15:08 Logical Log 29573 Complete, timestamp: 0xf018a30c. > 11:15:08 Logical Log 29573 - Backup Started > 11:15:09 Logical Log 29573 - Backup Completed > 11:15:32 Checkpoint Completed: duration was 0 seconds. > 11:15:32 Checkpoint loguniq 29574, logpos 0x381018, timestamp: 0xf018d9b5 > > 11:15:32 Maximum server connections 1145 > 11:17:00 mtex.c, line 472, thread 1712625, proc id 90576, No Exception > Handler. > 11:17:00 Fatal error in ADM VP at mt.c:13055 > 11:17:00 Unexpected virtual processor termination, pid = 90576, exit => 0x100 > > 11:17:00 PANIC: Attempting to bring system down> > -- > Neil Truby t:01932 724027 > Director m:07798 811708 > Ardenta Limited e:neil.truby@ardenta.com > >

↪ replying to Neil Truby

Obnoxio The Clown — Mon, 30 Jul 2007 00:25:34 +0100 (BST) — source: Usenet: comp.databases.informix

Neil Truby said: > IDS 10.0FC5 on AIX 5.3 > > Don't suppose much can be told from this, but has anyone any ideas about > this failure yesterday?: > > 11:00:32 Maximum server connections 1145 > 11:04:20 Logical Log 29572 Complete, timestamp: 0xf00ac717. > 11:04:21 Logical Log 29572 - Backup Started > 11:04:23 Logical Log 29572 - Backup Completed > 11:12:04 stack trace for pid 90576 written to > /scratch/shmdumps/af.25d91674 > 11:12:04 Assert Failed: No Exception Handler > 11:12:04 IBM Informix Dynamic Server Version 10.00.FC5 > 11:12:04 Who: Session(623836, xxxxxx@yyy-APP02, 25114, 7000002921e3a28) > Thread(1712625, sqlexec, 7000002a4634d08, 11) > File: mtex.c Line: 472 > 11:12:04 Results: Exception Caught. Type: MT_EX_OS, Context: mem > 11:12:04 Action: Please notify IBM Informix Technical Support. > 11:12:04 stack trace for pid 90576 written to > /scratch/shmdumps/af.25d91674 > 11:12:04 See Also: /scratch/shmdumps/af.25d91674, shmem.25d91674.0 > 11:15:08 Logical Log 29573 Complete, timestamp: 0xf018a30c. > 11:15:08 Logical Log 29573 - Backup Started > 11:15:09 Logical Log 29573 - Backup Completed > 11:15:32 Checkpoint Completed: duration was 0 seconds. > 11:15:32 Checkpoint loguniq 29574, logpos 0x381018, timestamp: 0xf018d9b5 > > 11:15:32 Maximum server connections 1145 > 11:17:00 mtex.c, line 472, thread 1712625, proc id 90576, No Exception > Handler. > 11:17:00 Fatal error in ADM VP at mt.c:13055 > 11:17:00 Unexpected virtual processor termination, pid = 90576, exit => 0x100 > > 11:17:00 PANIC: Attempting to bring system down Might help if I could see the AF? :o) -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo "Cluster in my trousers" -- Guy Bowerman -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

↪ replying to Neil Truby

david@smooth1.co.uk — Sun, 29 Jul 2007 17:22:02 -0700 — source: Usenet: comp.databases.informix

On 29 Jul, 12:47, "Neil Truby" <neil.tr...@ardenta.com> wrote: > If anyone's really keen the af file is athttp://homepage.ntlworld.com/neil.truby/ > > -- > Neil Truby t:01932 724027 > Director m:07798 811708 > Ardenta Limited e:neil.tr...@ardenta.com > > "Neil Truby" <neil.tr...@ardenta.com> wrote in message > > news:5h3an5F3ire6iU1@mid.individual.net... > > > > > IDS 10.0FC5 on AIX 5.3 > > > Don't suppose much can be told from this, but has anyone any ideas about > > this failure yesterday?: > > > 11:00:32 Maximum server connections 1145 > > 11:04:20 Logical Log 29572 Complete, timestamp: 0xf00ac717. > > 11:04:21 Logical Log 29572 - Backup Started > > 11:04:23 Logical Log 29572 - Backup Completed > > 11:12:04 stack trace for pid 90576 written to > > /scratch/shmdumps/af.25d91674 > > 11:12:04 Assert Failed: No Exception Handler > > 11:12:04 IBM Informix Dynamic Server Version 10.00.FC5 > > 11:12:04 Who: Session(623836, xxxxxx@yyy-APP02, 25114, 7000002921e3a28) > > Thread(1712625, sqlexec, 7000002a4634d08, 11) > > File: mtex.c Line: 472 > > 11:12:04 Results: Exception Caught. Type: MT_EX_OS, Context: mem > > 11:12:04 Action: Please notify IBM Informix Technical Support. > > 11:12:04 stack trace for pid 90576 written to > > /scratch/shmdumps/af.25d91674 > > 11:12:04 See Also: /scratch/shmdumps/af.25d91674, shmem.25d91674.0 > > 11:15:08 Logical Log 29573 Complete, timestamp: 0xf018a30c. > > 11:15:08 Logical Log 29573 - Backup Started > > 11:15:09 Logical Log 29573 - Backup Completed > > 11:15:32 Checkpoint Completed: duration was 0 seconds. > > 11:15:32 Checkpoint loguniq 29574, logpos 0x381018, timestamp: 0xf018d9b5 > > > 11:15:32 Maximum server connections 1145 > > 11:17:00 mtex.c, line 472, thread 1712625, proc id 90576, No Exception > > Handler. > > 11:17:00 Fatal error in ADM VP at mt.c:13055 > > 11:17:00 Unexpected virtual processor termination, pid = 90576, exit => > 0x100 > > > 11:17:00 PANIC: Attempting to bring system down> > > -- > > Neil Truby t:01932 724027 > > Director m:07798 811708 > > Ardenta Limited e:neil.tr...@ardenta.com- Hide quoted text - > > - Show quoted text - Well the session reported in the af file (1712625) 1. Had locked the "hash PC_ID" mutex. 2. Was part of session 623836 that had no current sql but had just received a -255 error. David.

↪ replying to Neil Truby

jprenaut@yahoo.com — Mon, 30 Jul 2007 07:17:14 -0700 — source: Usenet: comp.databases.informix

On Jul 29, 6:07 am, "Neil Truby" <neil.tr...@ardenta.com> wrote: > IDS 10.0FC5 on AIX 5.3 > > Don't suppose much can be told from this, but has anyone any ideas about > this failure yesterday?: > Well one of the most important pieces of the AF file doesn't appear to be working, and that's the stack unwind. It was only able to get to the signal handler and then it stops. So from just the AF file there's no way to tell what the thread was doing. Oddly this is the 2nd AF on a 10.00.FCx that I've seen recently where the stack didn't unwind properly. That really handicaps support in terms of trying to map this up to a known defect. I just did a quick test of 10.00.FC5 on an AIX box and crashed my server and the AF file did generate the stack unwind ok, so there might be something "odd" about the stack that caused the stack unwind code to fail and not produce output beyond the signal handler frame. The onstat -g stk all output in the AF file looks ok, so it doesn't look like all stack unwinding. So unfortunately, without the stack unwind and no current or previously parsed SQL statements in the AF file, there isn't much to tell other then the previously mentioned -255 SQL error. Jacques

Informix crash

Related threads

Glossary

Your privacy choices