Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-7958

Databases cannot be deleted while Postgres is being monitored

Details

    • 5
    • Yes
    • Yes
    • Yes
    • Hide

      reproduce the steps in description

      Show
      reproduce the steps in description

    Description

      User impact: User can't remove database
      STR:

      1. Install PMM 2.16.0
      2. Add Postgres to monitoring (with pg_stat_statements or pg_stat_monitor) # Connect to Postgres
      3. 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.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              nailya.kutlubaeva Nailya Kutlubaeva
              Votes:
              0 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1 hour
                  1h

                  Smart Checklist