Re: crashes with postgresql 7.2.1 on IRIX 6.5 - Mailing list pgsql-hackers

From Luis Alberto Amigo Navarro
Subject Re: crashes with postgresql 7.2.1 on IRIX 6.5
Date
Msg-id 010101c27ab1$f98888f0$cab990c1@atc.unican.es
Whole thread Raw
In response to crashes with postgresql 7.2.1 on IRIX 6.5  (Nicolae Mihalache <mache@abcpages.com>)
List pgsql-hackers
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
>
>




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PREPARE / EXECUTE
Next
From: Nicolae Mihalache
Date:
Subject: Re: crashes with postgresql 7.2.1 on IRIX 6.5