Обсуждение: 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
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 > >
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 controller0 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
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 > >
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
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 >
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 > >