Results 1 to 5 of 5

Thread: HPL failpoint

  1. #1
    Join Date
    Feb 2003
    Posts
    60

    Unanswered: HPL failpoint

    Hi all,

    We're running IDS 9.4 on AIX 5.1 on a pSeries 650 with 6 procs.

    We're loading simple ASCII data in a normal table, and HPL dies randomly with the following error:


    HPL failpoint: 11014

    10:27:39 pl_main.c, line 569, thread -1, proc id 1597612, Segmentation Violation.
    10:27:39 PANIC: Attempting to bring system down



    The instance stays online, but:
    + onstat works OK
    + onmode hangs
    + ipcs shows the IPCs
    + open connections die and it's impossible to open new ones.
    + Only thing to do: ipcrm of memory segments and semaphore, and kill of oninit processes.


    Nothing in online.log.



    Any idea?

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

    Re: HPL failpoint

    Originally posted by prae
    Hi all,

    We're running IDS 9.4 on AIX 5.1 on a pSeries 650 with 6 procs.

    We're loading simple ASCII data in a normal table, and HPL dies randomly with the following error:


    HPL failpoint: 11014

    10:27:39 pl_main.c, line 569, thread -1, proc id 1597612, Segmentation Violation.
    10:27:39 PANIC: Attempting to bring system down



    The instance stays online, but:
    + onstat works OK
    + onmode hangs
    + ipcs shows the IPCs
    + open connections die and it's impossible to open new ones.
    + Only thing to do: ipcrm of memory segments and semaphore, and kill of oninit processes.


    Nothing in online.log.



    Any idea?
    Hi,

    Please change $INFORMIXSERVER to TCP/IP connection and re-run the process.

    Gustavo.

  3. #3
    Join Date
    Feb 2003
    Posts
    60

    already TCP/IP

    This is already the case.
    The problem occurs randomly, meaning that we can run 5 onpload without any issue,a nd then, suddenly, it happens.
    Note: we always have only 1 onpload running at a time.

  4. #4
    Join Date
    Feb 2004
    Posts
    32
    can you post the following
    onstat -g seg
    /etc/system |grep -i shm

    -Abraham

  5. #5
    Join Date
    Feb 2003
    Posts
    60

    ipcs

    IBM Informix Dynamic Server Version 9.40.FC2 -- On-Line -- Up 28 days 21:09:34 -- 4419152 Kbytes

    Segment Summary:
    id key addr size ovhd class blkused blkfree
    12976147 1381451777 700000000000000 3956080640 539376 R 965835 5
    3145746 1381451778 7000000f0000000 563101696 17800 V 15801 121675
    1179671 1381451779 700000120000000 1507328 664 M 335 33
    917526 1381451780 700000130000000 1507328 664 M 331 37
    1048597 1381451781 700000140000000 1507328 664 M 331 37
    1048596 1381451782 700000150000000 1507328 664 M 331 37

    Total: - - 4525211648 - - 982964 121824

    (* segment locked in memory)






    /etc/system does not exist on my AIX5.1, but I guess you're looking for that output:

    informix@BACKUP:/home/informix#ipcs
    IPC status from /dev/mem as of Fri Mar 5 09:27:57 CUT 2004
    T ID KEY MODE OWNER GROUP
    Message Queues:
    q 0 0x4107001c -Rrw-rw---- root printq
    q 655361 0x0000000d -Rrw-rw-rw- root system
    q 655362 0xffffffff --rw-rw-rw- root system
    q 655363 0xffffffff -Rrw-rw-rw- root system

    Shared Memory:
    m 786432 0x580008f2 --rw-rw-rw- root system
    m 1 0xe4663d62 --rw-rw-rw- root system
    m 2 0x9308e451 --rw-rw-rw- root system
    m 3 0x52e74b4f --rw-rw-rw- root system
    m 4 0xc76283cc --rw-rw-rw- root system
    m 5 0x298ee665 --rw-rw-rw- root system
    m 6 0xffffffff --rw-rw---- root system
    m 7 0x00000019 --rw-rw-rw- root system
    m 8 0x0d002998 --rw-rw-rw- root system
    m 7733257 0x0000000d --rw-rw-rw- root system
    m 2490378 0x00061003 --rw------- cadb sys
    m 2228235 0x00000cae --rw-rw-rw- root system
    m 1087504396 0x52564803 --rw-rw-rw- bankq bank
    m 3407885 0x00000ca7 --rw-rw-rw- root system
    m 4325391 0x00060862 --rw------- cadb sys
    m 4587536 0x43426a6c --rw-rw-rw- root system
    m 786449 0x4341a48c --rw-rw-rw- root system
    m 3145746 0x52574802 --rw-rw---- informix informix
    m 12976147 0x52574801 --rw-rw---- informix informix
    m 1048596 0x52574806 --rw-rw-rw- informix informix
    m 1048597 0x52574805 --rw-rw-rw- informix informix
    m 917526 0x52574804 --rw-rw-rw- informix informix
    m 1179671 0x52574803 --rw-rw-rw- informix informix
    m 131096 0x52564801 --rw-rw---- bankq bank
    m 131097 0x52564802 --rw-rw---- bankq bank
    m 1514799133 0x00000ca5 --rw-rw-rw- root system
    m 1285423137 0xffffffff --rw-rw---- root system
    m 1434452010 0x4342dbc2 --rw-rw-rw- root system
    m 1766064173 0x52564804 --rw-rw-rw- bankq bank
    m 315621422 0xffffffff --rw-rw---- root system
    m 151388208 0x4341969e --rw-rw-rw- root system
    Semaphores:
    s 1048576 0x580008f2 --ra-ra-ra- root system
    s 786433 0x440008f2 --ra-ra-ra- root system
    s 131074 0xe4663d62 --ra-ra-ra- root system
    s 3 0x6200292f --ra-r--r-- root system
    s 4 0xffffffff --ra-ra-ra- root system
    s 5 0xffffffff --ra-ra-ra- root system
    s 131078 0x00000019 --ra-ra-ra- root system
    s 131079 0x660091fb --ra-ra-r-- root system
    s 7733256 0x0000000d --ra-ra-ra- root system
    s 11534345 0x0105f012 --ra-ra-ra- root system
    s 15073290 0x0105f01a --ra-ra-ra- root system
    s 10092555 0x00000cae --ra-ra-ra- root system
    s 7602188 0xffffffff --ra-ra-ra- root system
    s 655373 0x0105f015 --ra-ra-ra- root system
    s 1179662 0x43426a6c --ra-ra-ra- root system
    s 1179663 0x4155000e --ra------- cadb sys
    s 1703952 0x431f0013 --ra------- cadb sys
    s 1703953 0x4342dbc2 --ra-ra-ra- root system
    s 31195155 0x4341a48c --ra-ra-ra- root system
    s 1179668 00000000 --ra-ra-ra- informix informix
    s 1310741 00000000 --ra-ra-ra- informix informix
    s 1441814 00000000 --ra-ra-ra- informix informix
    s 1310743 00000000 --ra-ra-ra- informix informix
    s 1048600 00000000 --ra-ra-ra- informix informix
    s 1835033 00000000 --ra-ra-ra- informix informix
    s 1703962 00000000 --ra-ra-ra- informix informix
    s 1048603 0xffffffff --ra-ra---- informix informix
    s 1048604 00000000 --ra-ra-ra- informix informix
    s 131101 00000000 --ra-ra-ra- bankq bank
    s 131102 0xffffffff --ra-ra---- bankq bank
    s 131103 00000000 --ra-ra-ra- bankq bank
    s 131104 00000000 --ra-ra-ra- bankq bank
    s 131105 00000000 --ra-ra-ra- bankq bank
    s 20709410 0x0100286e --ra------- root system
    s 23199779 0x415d0011 --ra------- cadb sys
    s 32243748 0x8667002f --ra------- cadb sys
    s 51773477 0xffffffff --ra------- uniq uniqgrp
    s 51773478 0xffffffff --ra------- uniq uniqgrp
    s 6422567 0xffffffff --ra------- uniq uniqgrp
    s 6422568 0xffffffff --ra------- uniq uniqgrp
    s 524329 0xffffffff --ra------- uniq uniqgrp
    s 1048618 0xffffffff --ra------- uniq uniqgrp
    s 1048619 0xffffffff --ra------- uniq uniqgrp
    s 524332 0xffffffff --ra------- uniq uniqgrp
    s 524333 0xffffffff --ra------- uniq uniqgrp
    s 1159987247 0x4341969e --ra-ra-ra- root system

Posting Permissions

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