Search Postgresql Archives

Re: Connections closing due to "terminating connection due to administrator command"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



If you are running Linux (please ALWAYS give the O/S ), then this could have been caused by the sys admin doing a system shutdown.

Otherwise, anyone that can sudo to postgres could also have potentially issued a
pg_ctl stop.

I strongly suggest you review the _system_ logs for a possible hint as to whom could have done that. Also, consider adding the user name into the log prefix
( #   %u = user name )

On Mon, Jul 27, 2015 at 9:39 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 07/27/2015 02:16 AM, Herouth Maoz wrote:
Hello everybody.

In the past week, it has happened to us twice already that we got an
exception from our Java application, due to PostgreSQL "terminating
connection due to administrator command”.

The problem is that I’m the administrator, and I issued no such command.

On the first opportunity that it happened, the PostgreSQL server
actually seemed to have spontaneously shut itself down and restarted:

2015-07-21 15:37:59 IDT LOG:  received fast shutdown request
2015-07-21 15:37:59 IDT LOG:  aborting any active transactions
2015-07-21 15:37:59 IDT FATAL:  terminating connection due to
administrator command

2015-07-21 15:38:01 IDT LOG:  shutting down
2015-07-21 15:38:02 IDT LOG:  database system is shut down
2015-07-21 15:40:16 IDT LOG:  database system was shut down at
2015-07-21 15:38:02 IDT

On today’s occasion, the server seems to be continuing as usual, and
there is nothing whatsoever in the log.

So my questions are:

  * Given that I did not terminate any backend connection interactively,
    why did I get a  "terminating connection due to administrator
    command” message? Is there any situation where this message is
    issued without the administrator being involved?

This error message comes from intervention by a program external to Postgres:

http://www.postgresql.org/message-id/4564.1284559661@xxxxxxxxxxxxx

So what OS and version are you running?

What does the Java app do besides accessing the database?

Do you have other programs that monitor/control the database?


  * What could have caused the shutdown on the 21st of July? Again, I
    did not issue a shutdown request for that server, and the machine
    didn’t restart.

Is there anything in logs before the above that might give a clue?



The server is running PostgreSQL 9.1.16.

Thank you,
Herouth



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux