Horton

Re: Server goes to Recovery Mode when run a SQL

rob stone <floriparob@gmail.com>

View thread View on postgr.es
From: rob stone <floriparob@gmail.com>
To: PegoraroF10 <marcos@f10.com.br>, pgsql-general@postgresql.org
Date: 2019-02-04T05:57:10Z
Lists: pgsql-general 
Olá Marcos,



> My original query, which worked for some days and then went to
> recovery mode
> was ...

If it was working and then ceased to function, did any of the following
occur:-

1) Postgres version changed?
2) OS version changed?
3) Schema changes affecting the tables/views used in your query?

I assume that you have a development data base. Can you bump up the log
level on that, run the query and see any errors in the log.

Cheers,
Robert

Commits

  1. Be more careful about the shape of hashable subplan clauses.