Search Postgresql Archives

Re: Log full of: statement_timeout out of the valid range.

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

 



A. Kretschmer wrote:
> In response to Abraham, Danny :
> > Our setup is a real valid one. Looks like it has to do more with remote
> > connections.
> 
> No. 'statement_timeout out of the valid range' has nothing to do with
> remote connections.
> 
> > 
> > Any idea?
> 
> Show us your statement_timeout - setting. If you work with psql, just
> type:
> 
> show statement_timeout;
> 
> and show us the output.

Obviously, if the value is not valid, it's not getting applied, and thus
it won't show up in SHOW.  The '1h' value is valid; it is not the value
causing the log message.  The invalid value could come from anywhere.
It could be once per connection or once per query, if Danny is using
some middle layer that injects a "SET statement_timeout TO nnn" for
every query.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

[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