Loading

Error "Internal RELEASE failed" Creating Extract from PostgreSQL Database

Data pubblicazione: Apr 13, 2024
Descrizione
When creating an extract of a PostgreSQL database, the following error might occur:

"FATAL: terminating connection due to conflict with recovery

internal RELEASE failed

Unable to create extract"

or

"Error fetching next group.;

Internal savepoint error

Unable to create extract."

Cause

Postgresql doesn't allow temp tables to be written on a database that is a hot standby since it's in read-only mode.

When the parameter 'hot_standby' is set to true on a standby server, the server will start accepting connections after the restoration has reached a consistent state. All connections that follow will be read-only connections; even temporary tables can not be used.
Risoluzione
Work with your PostgreSQL DBA to consider the needs of your replication strategy. For example, setting the Hot Standby parameter on the Postgres Server to False will allow temporary tables to be created.

 
Numero articolo Knowledge

001474115

 
Caricamento
Salesforce Help | Article