Re: [ADMIN] Postgres Crash

2011-05-23 Thread digant
Hi Thanks for the info. Where was it fixed? in postgres or nmap? do you know also the version? br, Antonio -- View this message in context: http://postgresql.1045698.n5.nabble.com/Postgres-Crash-tp3299776p4418707.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- S

Re: [ADMIN] Postgres Crash

2011-03-17 Thread agfk
Tom Lane-2 wrote: > > Samuel Stearns writes: >> Yes, with gssapi. > > Well, then we have our smoking gun, but it's still not clear *why* > the setsockopt() call failed. > > regards, tom lane > I know why it failed. I just had two independent

Re: [ADMIN] Postgres crash during low-traffic period, need advice.

2010-12-20 Thread Benoit Clennett-Sirois
work_mem is not set in the config file, so it's using the default setting.. On Mon, Dec 20, 2010 at 9:34 AM, Scott Marlowe wrote: > On Mon, Dec 20, 2010 at 6:41 AM, Benoit Clennett-Sirois > wrote: >> Hi, >> >> We have a front-end server taking care of Nginx, memcached and >> Postgresql. Last nig

Re: [ADMIN] Postgres crash during low-traffic period, need advice.

2010-12-20 Thread Benoit Clennett-Sirois
On Mon, Dec 20, 2010 at 9:29 AM, wrote: > Zitat von Benoit Clennett-Sirois : > >> Hi, >> >> We have a front-end server taking care of Nginx, memcached and >> Postgresql. Last night the postgres daemon crashed (traffic was very >> low at that time) with the following error: >> >> 2010-12-20 03:34:

Re: [ADMIN] Postgres crash during low-traffic period, need advice.

2010-12-20 Thread Scott Marlowe
On Mon, Dec 20, 2010 at 6:41 AM, Benoit Clennett-Sirois wrote: > Hi, > > We have a front-end server taking care of Nginx, memcached and > Postgresql. Last night the postgres daemon crashed (traffic was very > low at that time) with the following error: > > 2010-12-20 03:34:30 EST DETAIL:  Failed s

Re: [ADMIN] Postgres crash during low-traffic period, need advice.

2010-12-20 Thread lst_hoe02
Zitat von Benoit Clennett-Sirois : Hi, We have a front-end server taking care of Nginx, memcached and Postgresql. Last night the postgres daemon crashed (traffic was very low at that time) with the following error: 2010-12-20 03:34:30 EST DETAIL:  Failed system call was shmget(key=5432001, siz

[ADMIN] Postgres crash during low-traffic period, need advice.

2010-12-20 Thread Benoit Clennett-Sirois
Hi, We have a front-end server taking care of Nginx, memcached and Postgresql. Last night the postgres daemon crashed (traffic was very low at that time) with the following error: 2010-12-20 03:34:30 EST DETAIL:  Failed system call was shmget(key=5432001, size=1124474880, 03600). 2010-12-20 03:34

Re: [ADMIN] Postgres Crash

2010-12-11 Thread Samuel Stearns
] Postgres Crash Samuel Stearns writes: > I'm getting info from our sysadmins that we can't re-compile because we don't > have the sun compiler. Is this fixed in a later release of postgres? The fix will be in next week's releases. regards, to

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Samuel Stearns
So will that be an 8.3.13? Sam -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Friday, 10 December 2010 3:32 PM To: Samuel Stearns Cc: Shoaib Mir; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgres Crash Samuel Stearns writes: > I'm getting info

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Tom Lane
Samuel Stearns writes: > I'm getting info from our sysadmins that we can't re-compile because we don't > have the sun compiler. Is this fixed in a later release of postgres? The fix will be in next week's releases. regards, tom lane -- Sent via pgsql-admin mailing lis

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Samuel Stearns
muel Stearns Cc: Shoaib Mir; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgres Crash Samuel Stearns writes: > Yes, with gssapi. Well, then we have our smoking gun, but it's still not clear *why* the setsockopt() call failed. regards, tom lane -- Sent via p

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Samuel Stearns
us] Sent: Friday, 10 December 2010 3:22 PM To: Samuel Stearns Cc: Shoaib Mir; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgres Crash Samuel Stearns writes: > Yes, with gssapi. Well, then we have our smoking gun, but it's still not clear *why* the setsock

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Tom Lane
Samuel Stearns writes: > Yes, with gssapi. Well, then we have our smoking gun, but it's still not clear *why* the setsockopt() call failed. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://w

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Samuel Stearns
Tom, Yes, with gssapi. Sam -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Friday, 10 December 2010 3:02 PM To: Samuel Stearns Cc: Shoaib Mir; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgres Crash Samuel Stearns writes: > Its not our build - its the

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Tom Lane
Samuel Stearns writes: > Its not our build - its the one downloaded some the postgres homepage > from http://www.postgresql.org/ftp/binary/v8.3.12/solaris/solaris10/i386/ pg_config --configure would tell you how it was built. regards, tom lane -- Sent via pgsql-admin ma

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Samuel Stearns
; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgres Crash Samuel Stearns writes: > Could it possibly be this?: > http://postgresql.1045698.n5.nabble.com/BUG-5731-postmaster-sometimes-dumps-core-when-handling-local-connections-td3239029.html Yeah, I'd just been off digging through

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Tom Lane
Samuel Stearns writes: > Could it possibly be this?: > http://postgresql.1045698.n5.nabble.com/BUG-5731-postmaster-sometimes-dumps-core-when-handling-local-connections-td3239029.html Yeah, I'd just been off digging through the code to arrive at that same theory. Did you build with GSSAPI suppor

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Tom Lane
Samuel Stearns writes: > [r...@udrv] # pstack /root/core > core '/root/core' of 771: /opt/postgres/8.3-community/bin/postmaster -F > 081a8562 ConnCreate (5) + b6 > 081a791b ServerLoop (8047e68, 83b7930, 2, fead58be, 8047e68, 83c28b8) + db > 081a73f1 PostmasterMain (2, 83b7930) + ab5 >

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Samuel Stearns
Cc: Shoaib Mir; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgres Crash Samuel Stearns writes: > Tom, no useful messages in the log prior. I do have a 47M core dump. What > should I do with that? If you use gdb, try $ gdb /path/to/postmaster /path/to/corefile g

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Samuel Stearns
.org Subject: Re: [ADMIN] Postgres Crash Samuel Stearns writes: > Tom, no useful messages in the log prior. I do have a 47M core dump. What > should I do with that? If you use gdb, try $ gdb /path/to/postmaster /path/to/corefile gdb> bt ... useful info here .

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Tom Lane
Samuel Stearns writes: > Tom, no useful messages in the log prior. I do have a 47M core dump. What > should I do with that? If you use gdb, try $ gdb /path/to/postmaster /path/to/corefile gdb> bt ... useful info here ... gdb> quit I think the preferred debugge

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Samuel Stearns
Yes. From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Shoaib Mir Sent: Friday, 10 December 2010 2:06 PM To: Samuel Stearns Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgres Crash On Fri, Dec 10, 2010 at 2:33 PM, Samuel Stearns

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Shoaib Mir
On Fri, Dec 10, 2010 at 2:33 PM, Samuel Stearns wrote: > Thanks Tom and Shoaib, > > > > Shoaib, I did not delete postmaster.pid. I killed the children and > re-started successfully. > > > So is the database server all good and working fine now?? -- Shoaib Mir http://shoaibmir.wordpress.com/

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Samuel Stearns
2010 2:00 PM To: Samuel Stearns Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgres Crash On Fri, Dec 10, 2010 at 2:17 PM, Samuel Stearns mailto:sstea...@internode.com.au>> wrote: Howdy, Environment: Solaris 10 Postgres 8.3.12 Postgres crashed and left 26 postmaster processes act

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Shoaib Mir
On Fri, Dec 10, 2010 at 2:17 PM, Samuel Stearns wrote: > Howdy, > > > > Environment: > > > > Solaris 10 > > Postgres 8.3.12 > > > > Postgres crashed and left 26 postmaster processes active in it’s wake. > Killed the children and re-started postgres successfully. Messages from the > log: > > > > D

Re: [ADMIN] Postgres Crash

2010-12-09 Thread Tom Lane
Samuel Stearns writes: > Environment: > Solaris 10 > Postgres 8.3.12 > Postgres crashed and left 26 postmaster processes active in it's wake. > Killed the children and re-started postgres successfully. Messages from the > log: > Dec 10 11:52:15 udrv postgres[771]: [ID 748848 local0.info] [6

[ADMIN] Postgres Crash

2010-12-09 Thread Samuel Stearns
Howdy, Environment: Solaris 10 Postgres 8.3.12 Postgres crashed and left 26 postmaster processes active in it's wake. Killed the children and re-started postgres successfully. Messages from the log: Dec 10 11:52:15 udrv postgres[771]: [ID 748848 local0.info] [6-1] host=,user=,db= LOG: sets