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


Wed, 23 Oct 2002 17:57:57 +0200
Nicolae Mihalache <mache@abcpages.com>
crashes with postgresql 7.2.1 on IRIX 6.5
could send the output from:
limit
and
systune | grep shm
also, what kind of machine is
regards



----- Original Message ----- 
From: "Nicolae Mihalache" <mache@abcpages.com>
To: <lamigo@atc.unican.es>; <pgsql-hackers@postgresql.org>
Sent: Wednesday, October 23, 2002 5:57 PM
Subject: 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
> 
> 


Wed, 23 Oct 2002 18:05:01 +0200
"Luis Alberto Amigo Navarro" <lamigo@atc.unican.es>
Re: crashes with postgresql 7.2.1 on IRIX 6.5
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


Wed, 23 Oct 2002 18:09:07 +0200
Nicolae Mihalache <mache@abcpages.com>
Re: crashes with postgresql 7.2.1 on IRIX 6.5
System configuration looks fine to me, there is no upper limit, the only
configuration problem a can see is that stacksize limit is set to 512Mb when
u only have 256Mb ram, try "limit stacksize 65536" (64Mb)  a most serious
size, if it does not help I can't be of any more help.
If it helps u may need to change hard limit(this is a soft limit) with
systune.
Regards



----- Original Message -----
From: "Nicolae Mihalache" <mache@abcpages.com>
To: "Luis Alberto Amigo Navarro" <lamigo@atc.unican.es>
Cc: <pgsql-hackers@postgresql.org>
Sent: Wednesday, October 23, 2002 6:09 PM
Subject: Re: crashes with postgresql 7.2.1 on IRIX 6.5


> 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
>
>



Wed, 23 Oct 2002 18:33:53 +0200
"Luis Alberto Amigo Navarro" <lamigo@atc.unican.es>
Re: crashes with postgresql 7.2.1 on IRIX 6.5
Luis Alberto Amigo Navarro wrote:
> System configuration looks fine to me, there is no upper limit, the only
> configuration problem a can see is that stacksize limit is set to 512Mb when
> u only have 256Mb ram, try "limit stacksize 65536" (64Mb)  a most serious
> size, if it does not help I can't be of any more help.

No it does not help :(
Is there any place where I can download binaries for postgresql that 
include support for pltcl?

Thanks,
mache


Wed, 23 Oct 2002 18:46:41 +0200
Nicolae Mihalache <mache@abcpages.com>
Re: crashes with postgresql 7.2.1 on IRIX 6.5
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
> 


Wed, 23 Oct 2002 18:01:29 -0400 (EDT)
mache@abcpages.com
Re: crashes with postgresql 7.2.1 on IRIX 6.5
regression tests are tested and passed with IRIX 6.5.13 and 6.5.16 and
postgres from 7.1.3 to 7.2.2
there where previously passed tests with IRIX 6.5.5, but I don't know what
postgres versions
Regards


----- Original Message -----
From: <mache@abcpages.com>
To: <lamigo@atc.unican.es>; <pgsql-hackers@postgresql.org>
Sent: Thursday, October 24, 2002 12:01 AM
Subject: Re: [HACKERS] crashes with postgresql 7.2.1 on IRIX 6.5


> 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
>
>



Thu, 24 Oct 2002 10:24:01 +0200
"Luis Alberto Amigo Navarro" <lamigo@atc.unican.es>
Re: crashes with postgresql 7.2.1 on IRIX 6.5