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.

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.

can you post the following
onstat -g seg
/etc/system |grep -i shm

-Abraham

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