crashes with postgresql 7.2.1 on IRIX 6.5

Hello!

I'm tring to move a database and an application from linux to IRIX and I
have some problems getting postgresql to work on IRIX.
My problem is that postgres crashes is killed by the kernel because of
(this is from /var/log/SYSLOG):
"unix: |$(0x6db)ALERT: Process [postgres] pid 105818 killed: not enough
memory to lock stack"
This happens when running the regression tests at the trigger and also
when I try to import my db schema that I've dump with pg_dump on the
linux machine.
Unfortunately I have not much experience with IRIX, so I don't know if
it is postgres fault or is a bad configuration. What I've tried to do is
to increase the "maxkmem" kernel parameter from 2000 to 20000 but it
makes no difference. The machine has 256MB ram and when running postgres
seems to take no more than 15MB.

Some system information:
uname -a: "IRIX cassini 6.5 04101931 IP32 mips"
cc -version: "MIPSpro Compilers: Version 7.2.1"
src/templates/irix5 file:
CC=cc
CFLAGS='-O2'
LDFLAGS='-O2 -lcurses -n32'

configure command:
./configure --prefix=/disk1/users/robust/famous/local --with-tcl
--with-includes=/disk1/users/robust/famous/local/include
--with-libraries=/disk1/users/robust/famous/local/lib --disable-locale
--without-java --without-CXX

Thank you for any ideea that can help,
Nicolae Mihalache

Luis Alberto Amigo Navarro wrote:

could send the output from:
limit
and
systune | grep shm
also, what kind of machine is
regards

robust@cassini> limit
cputime unlimited
filesize unlimited
datasize 2097152 kbytes
stacksize 524288 kbytes
coredumpsize unlimited
memoryuse 524288 kbytes
vmemoryuse 2097152 kbytes
descriptors 2500
threads 1024

robust@cassini> systune |grep shm
group: shm (statically changeable)
sshmseg = 2000 (0x7d0)
shmmni = 1064 (0x428)
shmmin = 1 (0x1)
shmmax = 214748365 (0xccccccd)

robust@cassini> hinv
CPU: MIPS R10000 Processor Chip Revision: 2.7
FPU: MIPS R10010 Floating Point Chip Revision: 0.0
1 195 MHZ IP32 Processor
Main memory size: 256 Mbytes
Secondary unified instruction/data cache size: 1 Mbyte on Processor 0
Instruction cache size: 32 Kbytes
Data cache size: 32 Kbytes
FLASH PROM version 4.17
Integral SCSI controller 0: Version ADAPTEC 7880
Disk drive: unit 2 on SCSI controller 0
CDROM: unit 4 on SCSI controller 0
Integral SCSI controller 1: Version ADAPTEC 7880
Disk drive: unit 5 on SCSI controller 1
On-board serial ports: tty1
On-board serial ports: tty2
On-board EPP/ECP parallel port
CRM graphics installed
Integral Ethernet: ec0, version 1
Iris Audio Processor: version A3 revision 0
Video: MVP unit 0 version 1.4
AV: AV2 Card version 0, Camera not connected.
Vice: TRE
IEEE 1394 High performance serial bus controller 0: Type: OHCI, Version
0x104C-1 0

Hello!

I'm tring to move a database and an application from linux to IRIX and I
have some problems getting postgresql to work on IRIX.
My problem is that postgres crashes is killed by the kernel because of
(this is from /var/log/SYSLOG):
"unix: |$(0x6db)ALERT: Process [postgres] pid 105818 killed: not enough
memory to lock stack"
This happens when running the regression tests at the trigger and also
when I try to import my db schema that I've dump with pg_dump on the
linux machine.
Unfortunately I have not much experience with IRIX, so I don't know if
it is postgres fault or is a bad configuration. What I've tried to do is
to increase the "maxkmem" kernel parameter from 2000 to 20000 but it
makes no difference. The machine has 256MB ram and when running postgres
seems to take no more than 15MB.

Some system information:
uname -a: "IRIX cassini 6.5 04101931 IP32 mips"
cc -version: "MIPSpro Compilers: Version 7.2.1"
src/templates/irix5 file:
CC=cc
CFLAGS='-O2'
LDFLAGS='-O2 -lcurses -n32'

configure command:
./configure --prefix=/disk1/users/robust/famous/local --with-tcl
--with-includes=/disk1/users/robust/famous/local/include
--with-libraries=/disk1/users/robust/famous/local/lib --disable-locale
--without-java --without-CXX

Thank you for any ideea that can help,
Nicolae Mihalache

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Hello again to everybody!

I've just downloaded and installed a binary version of postgresql 7.1.1
from ftp.postgresql.org and I have the same bad results: crashes during
regression tests. Can please someone confirm me that the binary version
posted there is able to pass all the regression tests? This way I will
know that the problem is somwere in my IRIX setup.

Thank you,
mache

On Wed, 23 Oct 2002, Nicolae Mihalache wrote:

Hello!

I'm tring to move a database and an application from linux to IRIX and I
have some problems getting postgresql to work on IRIX.
My problem is that postgres crashes is killed by the kernel because of
(this is from /var/log/SYSLOG):
"unix: |$(0x6db)ALERT: Process [postgres] pid 105818 killed: not enough
memory to lock stack"
This happens when running the regression tests at the trigger and also
when I try to import my db schema that I've dump with pg_dump on the
linux machine.
Unfortunately I have not much experience with IRIX, so I don't know if
it is postgres fault or is a bad configuration. What I've tried to do is
to increase the "maxkmem" kernel parameter from 2000 to 20000 but it
makes no difference. The machine has 256MB ram and when running postgres
seems to take no more than 15MB.

Some system information:
uname -a: "IRIX cassini 6.5 04101931 IP32 mips"
cc -version: "MIPSpro Compilers: Version 7.2.1"
src/templates/irix5 file:
CC=cc
CFLAGS='-O2'
LDFLAGS='-O2 -lcurses -n32'

configure command:
./configure --prefix=/disk1/users/robust/famous/local --with-tcl
--with-includes=/disk1/users/robust/famous/local/include
--with-libraries=/disk1/users/robust/famous/local/lib --disable-locale
--without-java --without-CXX

Thank you for any ideea that can help,
Nicolae Mihalache

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org