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

QAN for PMM server PostgreSQL doesn't work

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: 2.1.0
    • Fix Version/s: 2.1.0
    • Component/s: PMM Agent, PMM Server
    • Labels:
      None
    • Story Points:
      0
    • Sprint:
      Platform Sprint 2
    • Needs Review:
      Yes
    • Needs QA:
      Yes

      Description

      STR:

      1. Install the latest PMM server 201910311720
      2. Open PMM Inventory page
      3. Check QAN PostgreSQL PgStatements Agent status

      Given result: Agent has Waiting status and QAN page doesn't have any query
      And there are a lot of errors in pmm-agent.log inside PMM-server:

       ERRO[2019-11-01T08:54:00.000+00:00] failed to query pg_stat_statements: pq: relation "pg_stat_statements" does not exist  agentID=/agent_id/2b35c7a1-4abb-42dd-8d20-3263445e6259 component=agent-builtin type=qan_postgresql_pgstatements_agent

      Expected result: QAN for Postgres PMM server works ok

      I checked previous build and found that the problem appeared after Oct 21

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned
                Reporter:
                nailya.kutlubaeva Nailya Kutlubaeva
                Votes:
                0 Vote for this issue
                Watchers:
                2 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 day, 2 hours, 16 minutes
                    1d 2h 16m