Re: [HACKERS] 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: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] 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 2 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 [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] 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 2 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] 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 [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] 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 2 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 4: Don't 'kill -9' the postmaster
Re: [HACKERS] 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 robustcassini limit cputime unlimited filesizeunlimited datasize2097152 kbytes stacksize 524288 kbytes coredumpsizeunlimited memoryuse 524288 kbytes vmemoryuse 2097152 kbytes descriptors 2500 threads 1024 robustcassini systune |grep shm group: shm (statically changeable) sshmseg = 2000 (0x7d0) shmmni = 1064 (0x428) shmmin = 1 (0x1) shmmax = 214748365 (0xccd) robustcassini hinv CPU: MIPS R1 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 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] 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 [EMAIL PROTECTED] To: Luis Alberto Amigo Navarro [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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 filesizeunlimited datasize2097152 kbytes stacksize 524288 kbytes coredumpsizeunlimited 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 (0xccd) robust@cassini hinv CPU: MIPS R1 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 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] 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 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
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 2 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 [EMAIL PROTECTED] 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
