Skip to content

[Bug] Deleted the occupied PostgreSQL database session but actually did not delete it #11536

@allyxmiko

Description

@allyxmiko

Contact Information

No response

1Panel Version

v2.0.16

Problem Description

当PostgreSQL数据库存在被其他会话占用导致无法删除时。1Panel貌似不会对这种状态进行判断,可以直接在显示上删除,但实际并未删除数据库(因为数据库被会话占用无法删除)

在1Panel提示成功删除后,在pgAdmin4删除报错如下:
database "xxxxxx" is being accessed by other users
There are 2 other sessions using the database.

Steps to Reproduce

  1. 在1Panel删除被其他会话占用的数据库。
  2. 会提示删除成功,但实际无法删除。

The expected correct result

提示无法删除或者终止其他会话然后删除

Related log output

Additional Information

No response

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions