KNOWLEDGE BASE

PostgreSQL Extracts Fail to Refresh with Error "Connectionless Failure: ERROR: prepared statement "S_2" already exists"


Published: 04 May 2021
Last Modified Date: 10 May 2021

Issue

Extract refreshes for Postgres data sources may fail with the following error:

"Connectionless Failure ( status code = 10000, ERROR: prepared statement "S_2" already exists Unable to connect to the PostgreSQL server "". Check that the server is running and that you have access privileges to the requested database. )"

Environment

  • Tableau Online 
  • Tableau Desktop
  • Tableau Server
  • PostgreSQL

Resolution

Configure the PostgreSQL "Pooling mode" to "session", as described here

Cause

PostgreSQL database pooling is misconfigured for Tableau. 
Did this article resolve the issue?