Re: statement_timeout issue - Mailing list pgsql-general

From Andres Freund
Subject Re: statement_timeout issue
Date
Msg-id 20180504172224.x6fr2rnlobanc32j@alap3.anarazel.de
Whole thread Raw
In response to statement_timeout issue  (Ian Harding <harding.ian@gmail.com>)
Responses Re: statement_timeout issue  (Ian Harding <harding.ian@gmail.com>)
List pgsql-general
Hi,

On 2018-05-04 09:52:35 -0700, Ian Harding wrote:
> I know there are a lot of moving parts to this issue but I think I've
> eliminated most of them and the problem comes down to the postgresql server
> generating a statement_timeout error after 10 seconds when the connection
> statement_timeout is actually set to 15 minutes.
> 
> My web server gets a database handle which it keeps for the duration of the
> function that generates the response.  Multiple queries can be sent and
> will use the same handle.
> 
> After getting the handle I issue "show statement_timeout" and log the
> result which shows 15 minutes.
> 
> 84876:May  4 08:31:06 seattle-vm-1-0 nsd: STATEMENT_TIMEOUT IS:
> 84877-May  4 08:31:06 seattle-vm-1-0 nsd: statement_timeout = 15min
> 
> Then I send a query, and it generates a statement_timeout error after 10
> seconds.
> 
> The log has a CONTEXT which indicates a foreign key lookup was going on at
> the time which is fine...
> 
> 2018-05-04 04:05:20 PDT [62028]: [82-1] ERROR:  canceling statement due to
> statement timeout
> 2018-05-04 04:05:20 PDT [62028]: [83-1] CONTEXT:  SQL statement "SELECT 1
> FROM ONLY "public"."clients" x WHERE "c_id" OPERATOR(pg_catalog.=) $1 FOR
> KEY SHARE OF x"
> 2018-05-04 04:05:20 PDT [62028]: [84-1] STATEMENT:  INSERT /*
> 
> Is there anything I'm not thinking of?

Probably some part of your application, or a function you're calling
from there, is setting a different timeout.

Greetings,

Andres Freund


pgsql-general by date:

Previous
From: Ian Harding
Date:
Subject: statement_timeout issue
Next
From: Adrian Klaver
Date:
Subject: Re: statement_timeout issue