Question

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

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!

Sign In or Sign Up to Answer