Postgrest Server Does'nt respond for DB error SQL Error [57014]: ERROR: canceling statement due to statement timeout . #3360
-
Environment
If postgrest is trying to update a row which has an active DB ExclusiveLock . Postgrest doesnt reponds with any error/timeout. Steps to reproduce 2.Confirm Lock is acquired 3.Update request from Postgrest **This request doesnt give any response..it running indefinitely. 4.Update request through sql query Results in below error: |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
statement_timeout is 0 by default, i.e. it's disabled. https://postgresqlco.nf/doc/en/param/statement_timeout/
Likely your Once you connect to PostgREST with a user that has statement_timeout set, you should get the same error. Note: PostgREST has first class support for statement_timeout: https://postgrest.org/en/v12/references/transactions.html#impersonated-role-settings |
Beta Was this translation helpful? Give feedback.
statement_timeout is 0 by default, i.e. it's disabled. https://postgresqlco.nf/doc/en/param/statement_timeout/
Likely your
abc
user has a non 0 statement_timeout that's why you get the error. with your python clientOnce you connect to PostgREST with a user that has statement_timeout set, you should get the same error.
Note: PostgREST has first class support for statement_timeout: https://postgrest.org/en/v12/references/transactions.html#impersonated-role-settings