Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2006
    Posts
    5

    Unanswered: Informix process expired frequently

    Hi,
    We have an Informix server where informix process are expired (down) frequently and also it is core dumping.I have attached the core files and also the error messages.Can anybody help me this?

    Online.log
    ---------
    02:00:21 IBM Informix Dynamic Server Version 9.40.UC4X3
    02:00:21 Who: Session(340, vnmadm@172.30.218.29, 24716, 191e9e88)
    Thread(370, sqlexec, 192656e8, 3)
    File: mtex.c Line: 431
    02:00:21 Results: Exception Caught. Type: MT_EX_OS, Context: mem
    02:00:21 Action: Please notify IBM Informix Technical Support.
    02:00:21 stack trace for pid 1843 written to /tmp/af.55a7c94
    02:00:21 See Also: /tmp/af.55a7c94, shmem.55a7c94.0
    02:00:21 listener-thread: err = -14565: oserr = 0: errstr = : CSS: error reading data.

    02:01:03 mtex.c, line 431, thread 370, proc id 1843, No Exception Handler.
    02:01:07 Fatal error in ADM VP at mt.c:12323
    02:01:07 Unexpected virtual processor termination, pid = 1843, exit = 0x100

    02:01:07 PANIC: Attempting to bring system down
    09:17:08 IBM Informix Dynamic Server Started.

    Tue Mar 28 09:17:09 2006

    09:17:09 Event alarms enabled. ALARMPROG = '/usr/users/informix72/etc/log_full.sh'
    09:17:10 Booting Language <c> from module <>
    09:17:10 Loading Module <CNULL>
    09:17:10 Booting Language <builtin> from module <>
    09:17:10 Loading Module <BUILTINNULL>
    09:17:14 Requested shared memory segment size rounded from 664KB to 1024KB
    09:17:14 IBM Informix Dynamic Server Version 9.40.UC4X3 Software Serial Number AAA#B000000
    09:17:15 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

    09:17:15 Physical Recovery Started at Page (1:1090).
    09:17:15 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
    09:17:15 Logical Recovery Started.
    09:17:15 10 recovery worker threads will be started.
    09:17:18 Logical Recovery has reached the transaction cleanup phase.
    09:17:18 Logical Recovery Complete.
    4 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

    09:17:19 Dataskip is now OFF for all dbspaces
    09:17:20 Checkpoint Completed: duration was 1 seconds.
    09:17:20 Checkpoint loguniq 142, logpos 0x50018, timestamp: 0x9bbb1e6

    09:17:20 Maximum server connections 0
    09:17:20 On-Line Mode
    09:17:49 Checkpoint Completed: duration was 0 seconds.
    09:17:49 Checkpoint loguniq 142, logpos 0x51018, timestamp: 0x9bbbf65

    09:17:49 Maximum server connections 8
    09:18:38 Booting Language <spl> from module <>
    09:18:38 Loading Module <SPLNULL>
    11:17:49 Checkpoint Completed: duration was 0 seconds.
    11:17:49 Checkpoint loguniq 142, logpos 0x52018, timestamp: 0x9bc1457

    11:17:49 Maximum server connections 13
    11:59:45 Logical Log 142 Complete, timestamp: 0x9bc3d07.
    11:59:47 Process exited with return code 156: /bin/sh /bin/sh -c /usr/users/informix72/etc/log_full.sh 2 23 "Logical Log 142 Complete, timestamp: 0x9bc3d07." "Logical
    11:59:47 Logical Log 143 Complete, timestamp: 0x9bc45d5.
    11:59:48 Process exited with return code 156: /bin/sh /bin/sh -c /usr/users/informix72/etc/log_full.sh 2 23 "Logical Log 143 Complete, timestamp: 0x9bc45d5." "Logical
    12:01:47 Logical Log 144 Complete, timestamp: 0x9bc5b9c.
    12:01:48 Process exited with return code 156: /bin/sh /bin/sh -c /usr/users/informix72/etc/log_full.sh 2 23 "Logical Log 144 Complete, timestamp: 0x9bc5b9c." "Logical
    13:17:49 Checkpoint Completed: duration was 0 seconds.
    13:17:49 Checkpoint loguniq 145, logpos 0xec018, timestamp: 0x9bc85eb

    13:17:49 Maximum server connections 13
    15:17:49 Checkpoint Completed: duration was 0 seconds.
    15:17:49 Checkpoint loguniq 145, logpos 0xed0c8, timestamp: 0x9bcf51f

    15:17:49 Maximum server connections 14
    17:17:49 Checkpoint Completed: duration was 0 seconds.
    17:17:49 Checkpoint loguniq 145, logpos 0xee018, timestamp: 0x9bd7deb

    17:17:49 Maximum server connections 14
    19:17:49 Checkpoint Completed: duration was 0 seconds.
    19:17:49 Checkpoint loguniq 145, logpos 0xef018, timestamp: 0x9be15cc

    19:17:49 Maximum server connections 14
    21:17:49 Checkpoint Completed: duration was 0 seconds.
    21:17:49 Checkpoint loguniq 145, logpos 0xf0124, timestamp: 0x9bebbf1

    21:17:49 Maximum server connections 14
    23:17:49 Checkpoint Completed: duration was 0 seconds.
    23:17:49 Checkpoint loguniq 145, logpos 0xf1018, timestamp: 0x9bf32e9

    23:17:49 Maximum server connections 14

    Wed Mar 29 01:17:49 2006

    01:17:49 Checkpoint Completed: duration was 0 seconds.
    01:17:49 Checkpoint loguniq 145, logpos 0xf2018, timestamp: 0x9bfb57e

    01:17:49 Maximum server connections 14
    02:00:22 Assert Failed: No Exception Handler
    02:00:22 IBM Informix Dynamic Server Version 9.40.UC4X3
    02:00:22 Who: Session(45, vnmadm@172.30.218.29, 5374, 15228900)
    Thread(67, sqlexec, 151fd628, 3)
    File: mtex.c Line: 431
    02:00:22 Results: Exception Caught. Type: MT_EX_OS, Context: mem
    02:00:22 Action: Please notify IBM Informix Technical Support.
    02:00:22 stack trace for pid 21243 written to /tmp/af.42bce16
    02:00:22 See Also: /tmp/af.42bce16, shmem.42bce16.0
    02:00:22 listener-thread: err = -14565: oserr = 0: errstr = : CSS: error reading data.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    Maybe is a bug, but check the memory resource with onstat -g seg.
    Maybe you need add memory.

    Gustavo.

  3. #3
    Join Date
    Nov 2004
    Posts
    60
    Memory could also be faulty i.e. hardware error. I guess it crashes when you start pumping some transactions through it?

  4. #4
    Join Date
    May 2006
    Location
    Virginia
    Posts
    6
    Looks like it's failing at the same time every day. I'd check to see what processes and queries are running at that time. You are probably hitting a bug anyway.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •