"SET SEARCH_PATH" Transaction Hangs in Idle State in Postgres #42862
Labels
.Backend
Priority:P3
Cosmetic bugs, minor bugs with a clear workaround
.Team/BackendComponents
also known as BEC
Type:Bug
Product defects
Describe the bug
When Metabase launches a query is executed against the app db to set the "search_path" variable in Postgres. The transaction never leaves the "idle in transaction" state.
To Reproduce
SELECT pid ,datname ,usename ,application_name ,client_hostname ,client_port ,backend_start ,query_start ,query ,state
FROM pg_stat_activity
WHERE state = 'idle in transaction';
Note that the pid with the "set search_path" query in it never resolves.
Expected behavior
The transaction should complete.
Logs
No response
Information about your Metabase installation
Severity
Unclear on if this impacts anything other than leaving a single process hanging since this is already the default setting for this value in Postgres
Additional context
No response
The text was updated successfully, but these errors were encountered: