Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
Postgres query stop after 10 minutes
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