PostgreSQL Discussion - postmaster going down own its on

Author

postmaster going down own its on

surabhi.ahuja

2006-04-07, 7:34 am

hi, is it possible for postmaster to go doen on its own?

all what the logs say is FATAL: terminating connection dur to administrator's command.

thanks,
regards
Surabhi

James Cradock

2006-04-07, 7:34 am

It's not normal.

What's the installation? OS, applications connecting to the server, etc.

On Apr 7, 2006, at 8:20 AM, surabhi.ahuja wrote:

> hi, is it possible for postmaster to go doen on its own?
>
> all what the logs say is FATAL: terminating connection dur to
> administrator's command.
>
> thanks,
> regards
> Surabhi

Richard Huxton

2006-04-07, 9:29 am

surabhi.ahuja wrote:
> hi, is it possible for postmaster to go doen on its own?
>
> all what the logs say is FATAL: terminating connection dur to
> administrator's command.

Someone or something is issuing a kill command. It couldn't be the
infamous Linux out-of-memory handler, could it? Check your system logs
for details.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Douglas McNaught

2006-04-07, 9:29 am

Richard Huxton <dev@archonet.com> writes:

> surabhi.ahuja wrote:
>
> Someone or something is issuing a kill command. It couldn't be the
> infamous Linux out-of-memory handler, could it? Check your system logs
> for details.

I'm not sure it's that--the OOM killer uses SIGKILL which would take
down the server before it could write that log entry.

-Doug

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Richard Huxton

2006-04-07, 9:29 am

Douglas McNaught wrote:
> Richard Huxton <dev@archonet.com> writes:
>
>
> I'm not sure it's that--the OOM killer uses SIGKILL which would take
> down the server before it could write that log entry.

Hmm... (tests it) you're right. What would be sending SIGTERM to a backend?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Martijn van Oosterhout

2006-04-07, 9:29 am

On Fri, Apr 07, 2006 at 03:03:09PM +0100, Richard Huxton wrote:
>
> Hmm... (tests it) you're right. What would be sending SIGTERM to a backend?

The only other thing I've ever heard of is some systems do a sigterm
when you pass a quota limit?

Not sure though,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Tom Lane

2006-04-07, 11:27 am

Martijn van Oosterhout <kleptog@svana.org> writes:
> On Fri, Apr 07, 2006 at 03:03:09PM +0100, Richard Huxton wrote:
[color=darkred]
> The only other thing I've ever heard of is some systems do a sigterm
> when you pass a quota limit?

Could be. The actual standard use of SIGTERM is to kill processes
belonging to your terminal process group when you log out. So, for
example, manually starting the postmaster from a terminal window and
then closing that window could cause this to happen.

I suppose the OP is bright enough to have noticed the connection between
closing the window and losing the postmaster, so it's probably not quite
that simple, but anyway something like this is what to look for.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Douglas McNaught

2006-04-07, 11:27 am

Tom Lane <tgl@sss.pgh.pa.us> writes:

> Martijn van Oosterhout <kleptog@svana.org> writes:
>
>
> Could be. The actual standard use of SIGTERM is to kill processes
> belonging to your terminal process group when you log out. So, for
> example, manually starting the postmaster from a terminal window and
> then closing that window could cause this to happen.

I thought that was SIGHUP?

-Doug

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Tom Lane

2006-04-07, 11:27 am

Douglas McNaught <doug@mcnaught.org> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
[color=darkred]
> I thought that was SIGHUP?

Doh. Not enough caffeine absorbed yet.

As penance, here's a comment that I think is actually correct: sending
SIGINT to the postmaster will make it turn around and send SIGTERM to
all the backends. So there are two different explanations for the
backends giving the "administrator command" error: either some outside
force sent them SIGTERM directly, or some outside force sent the
postmaster SIGINT. The SIGINT-the-postmaster theory is the more likely,
I suspect, and that again could be associated with having carelessly
left the postmaster attached to one's terminal. In any case, the first
thing to do is look in the postmaster log and see if you see a message
about "received fast shutdown request", which would be proof one way or
the other.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

surabhi.ahuja

2006-04-08, 11:26 am

the scenario in which the above took place was somewhat like this
we have a script to stop some of the processes running in the background.

this script was run, and all the processes got stopped

then another script will start these processes one after the other in background
that script was run, and postmaster also got started.

and then all of a sudden, it went down.

thanks for the suggestions, i ll also look into the log essages and look for
"received fast shutdown" message.

but in case the postmaster received a fast shutdown signal, when the above mentioned script (to stop all processes in background).

but again the script to start the processes including postmaster was run

and at that time, postmaster did start, then how come it suddently went down.

will provide u with more info on the same,

thanks,
regards
surabhi

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Fri 4/7/2006 8:51 PM
To: Douglas McNaught
Cc: Martijn van Oosterhout; Richard Huxton; surabhi.ahuja; pgsql-general@postgresql.org
Subject: Re: [GENERAL] postmaster going down own its on

********************
***
Your mail has been scanned by InterScan VirusWall.
***********-***********

Douglas McNaught <doug@mcnaught.org> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
[color=darkred]
> I thought that was SIGHUP?

Doh. Not enough caffeine absorbed yet.

As penance, here's a comment that I think is actually correct: sending
SIGINT to the postmaster will make it turn around and send SIGTERM to
all the backends. So there are two different explanations for the
backends giving the "administrator command" error: either some outside
force sent them SIGTERM directly, or some outside force sent the
postmaster SIGINT. The SIGINT-the-postmaster theory is the more likely,
I suspect, and that again could be associated with having carelessly
left the postmaster attached to one's terminal. In any case, the first
thing to do is look in the postmaster log and see if you see a message
about "received fast shutdown request", which would be proof one way or
the other.

regards, tom lane

Martijn van Oosterhout

2006-04-08, 11:26 am

On Sat, Apr 08, 2006 at 08:02:04PM +0530, surabhi.ahuja wrote:
>
> the scenario in which the above took place was somewhat like this
> we have a script to stop some of the processes running in the background.
>
> this script was run, and all the processes got stopped
>
> then another script will start these processes one after the other in background
> that script was run, and postmaster also got started.
>
> and then all of a sudden, it went down.

So you stopped it and it stopped. You started it up again, and you say
it stopped again.

I'm sorry, you're going to have to post your logs before we can help
you further. When you stop the postmaster you are sending a shutdown
request, so it's not totally surprising that that message appears.

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Sponsored Links