Question

Postgres query stop after 10 minutes

Posted January 21, 2021 783 views
DigitalOcean Managed PostgreSQL DatabaseNeeds Product Answer

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
edited by bobbyiliev
Submit an answer

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!