Error in logs: `Java::OrgPostgresqlUtil::PSQLException : This connection has been closed`

Knowledge Drop

Last tested: Aug 17, 2010
 

Possible reasons for seeing this error message include:

  • The connection between Looker and the DB closed before the query could finish executing (timeout error)
  • There could be a "networking" component involved that's forcing the connection between Looker and the database to close after a certain amount of time. This usually is in the forms of either a "proxy" or a "load balancer" that's in front of our database. Usually, if there is a networking component involved with this behavior, there is a consistent amount of time before our connection to the database get's closed off (i.e it's always 60 seconds).

This content is subject to limited support.                

Version history
Last update:
‎07-07-2021 01:12 PM
Updated by: