Details
-
Bug
-
Status: To Do
-
High
-
Resolution: Fixed
-
2.16.0, 2.31.0
-
None
-
5
-
Yes
-
Yes
-
Yes
-
Description
User impact: User can't remove database
STR:
- Install PMM 2.16.0
- Add Postgres to monitoring (with pg_stat_statements or pg_stat_monitor) # Connect to Postgres
- Try to execute creating and deleting some database
Actual result:postgres=# create database john; CREATE DATABASE postgres=# drop database john; ERROR: database "john" is being accessed by other users DETAIL: There is 1 other session using the database.
Expected result:
postgres=# create database bob; CREATE DATABASE postgres=# drop database bob; DROP DATABASE postgres=#
I
checked the same case in 2.15.1 and it worked ok.
I also checked the case for enabled pg_stat_statements and pg_stat_monitor but with the same result. When I removed monitoring of Postgres I was able to delete created database.