From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
---|---|
To: | emilu(at)encs(dot)concordia(dot)ca |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command |
Date: | 2017-08-02 14:13:32 |
Message-ID: | CANu8FizF4W1GPwGt1EEsfvLyezVqMWqMKL-95GpFPP5Gw28LZQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Aug 2, 2017 at 9:42 AM, Emi <emilu(at)encs(dot)concordia(dot)ca> wrote:
> Hello,
>
> Running psql table updates() by using org.springframework.scheduling.quartz.JobDetailFactoryBean
> cronjob from web application. Got the following exception:
>
> org.postgresql.util.PSQLException: FATAL: terminating connection due to
> administrator command
>
>
> Re-run the same cronjob several times, and cannot re-generate the error.
>
> May I know what might cause the above error message please? And which log
> file(online doc) could help provide more detail information about this
> please?
>
> Thanks a lot.
> --
> psql version: PostgreSQL 8.3.18 on x86_64-unknown-linux-gnu
>
>
>
>
> --
> 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
>
This says it all: "terminating connection due to administrator command"
It means someone killed your session, either from the command line with
kill {the pid} or with SELECT pg_terminate_backend(pid);
*https://www.postgresql.org/docs/9.4/static/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL
<https://www.postgresql.org/docs/9.4/static/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL>*
--
*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 | John McKown | 2017-08-02 15:44:34 | bidirectional mapping? |
Previous Message | Albe Laurenz | 2017-08-02 14:10:28 | Re: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command |