Re: [GENERAL] postmaster crashing

2003-09-05 Thread psql-mail
Tom Lane writes: > That has nothing whatever to do with how much memory the kernel will let > any one process have. Check what ulimit settings the postmaster is > running under (particularly -d, -m, -v). My ulimit settings you requested look ok (others included for info) ulimit -d, -m, -v : un

Re: [GENERAL] postmaster crashing

2003-09-04 Thread Tom Lane
[EMAIL PROTECTED] writes: > #0 SN_create_env (S_size=0, I_size=2, B_size=1) at api.c:6 > 6 z->p = create_s(); Hm. Is it possible you're running out of memory? If the crash is right there, and not inside create_s(), it seems like a null return from calloc is the only explanation. This

Re: [GENERAL] postmaster crashing

2003-09-04 Thread psql-mail
First - apologies for the stuff about "i don't understand why there's only one core file", i now have a post-it note now saying "ulimit gets reset at reboot" (i assume thats what happened). So please find below a potentially more useful core file gdb output: Core was generated by `postgres: mat

Re: [GENERAL] postmaster crashing

2003-09-04 Thread psql-mail
> [EMAIL PROTECTED] writes: > > I have set "ulimit -c unlimited" as you sugested, > > i then copied postmaster to /home/postgres > > and ran it as postgres from there... > > but still no core files. Where should they appear? > > In $PGDATA/base/yourdbnumber/core (under some OSes the file name mi

Re: [GENERAL] postmaster crashing

2003-09-04 Thread Tom Lane
[EMAIL PROTECTED] writes: > I have set "ulimit -c unlimited" as you sugested, > i then copied postmaster to /home/postgres > and ran it as postgres from there... > but still no core files. Where should they appear? In $PGDATA/base/yourdbnumber/core (under some OSes the file name might be "core" p

Re: [GENERAL] postmaster crashing

2003-09-04 Thread psql-mail
> From: Tom Lane <[EMAIL PROTECTED]> > > [EMAIL PROTECTED] writes: > > How do i get the core files to examine? There never seem to be any > > produced, even outside the debuggers. > > Most likely you have launched the postmaster under "ulimit -c 0", which > prevents core dumps. This seems to

[GENERAL] postmaster crashing

2003-09-03 Thread psql-mail
I have been trying to find out more about the postmaster crashing, but things seem to be getting stranger! I am experiencing problems running postmaster in gdb too (see end of message) I will put all the information in this posting for completness, apologies for the duplicated sections. I am r