Re: [GENERAL] org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command

2017-08-02 Thread Melvin Davidson 
On Wed, Aug 2, 2017 at 9:42 AM, Emi  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@postgresql.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
*
-- 
*Melvin Davidson*
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

Re: [GENERAL] org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command

2017-08-02 Thread Albe Laurenz 
Emi wrote:
> 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?

You could look into the PostgreSQL server log.

An administrator killed your session, or statement_timeout was exceeded.

Yours,
Laurenz Albe

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