Loading

Error "Internal RELEASE failed" Creating Extract from PostgreSQL Database

Udgivelsesdato: Apr 13, 2024
Beskrivelse
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.
Løsning
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.

 
Vidensartikelnummer

001474115

 
Indlæser
Salesforce Help | Article