KNOWLEDGE BASE

Error "Internal RELEASE failed" Creating Extract from PostgreSQL Database


Published: 10 Dec 2014
Last Modified Date: 03 Nov 2017

Issue

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."

Environment

  • Tableau Desktop
  • Tableau Online
  • Postgres

Resolution

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.

 

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.
Did this article resolve the issue?