Skip to content

SELECT 1 query not closed, it causes ps cannot able to do vacuum #94

@Abdulsametileri

Description

@Abdulsametileri
pid   |        duration         |          query_start          |       transaction_start       |        state        |                 user                 |                                query
---------+-------------------------+-------------------------------+-------------------------------+---------------------+--------------------------------------+---------------------------------------------------------------------
 2115263 | 17 days 06:16:46.746987 | 2026-03-09 14:09:31.699907+03 | 2026-02-20 07:53:01.698915+03 | idle in transaction | user_x              | SELECT 1

Postgre cannot able to do vacuum because of tx is opened. The team started a snapshot 17 days ago and finished but we cannot able to close related conns.

Metadata

Metadata

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions