From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | Herouth Maoz <herouth(at)unicell(dot)co(dot)il>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Connections closing due to "terminating connection due to administrator command" |
Date: | 2015-07-27 13:55:00 |
Message-ID: | CANu8FiwqkjuXjJc_=rvSyMt2KYAj71e42u50KpeAZ+J46bMzLQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com>
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@sss.pgh.pa.us
>
> 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(dot)klaver(at)aklaver(dot)com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Sabino Mullane | 2015-07-27 13:55:49 | Re: This utility can only upgrade to PostgreSQL version 9.4 |
Previous Message | papa | 2015-07-27 13:54:46 | Re: I lost my password |