Question
Postgres query stop after 10 minutes
- Posted on January 21, 2021
- DigitalOcean Managed PostgreSQL DatabaseNeeds Product Answer
Asked by efficientcapital
I have Managed Postgres instance, and a query that stops after 10 minutes.
The query is REFRESH MATERIALIZED VIEW xyz.
I kind looks like there is a limit for a query to run for 10 minutes. Can anyone tell what particular limit might come into play here?
The instance is 1 GB RAM / 1vCPU / 10 GB Disk / Primary only / FRA1.
The application is running spring boot and the Hikari connection pool.
First error message is 'SQLSTATE(57P01), ErrorCode(0)'
Second: FATAL: terminating connection due to administrator command; nested exception is org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command
Submit an answer
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!