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

Postgresql agent QAN bad DSN

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Duplicate
    • Affects Version/s: 2.0.0
    • Fix Version/s: None
    • Component/s: PMM Agent
    • Labels:
      None
    • Story Points:
      0
    • Sprint:
      Platform Sprint 2

      Description

      Hi Percona.

       

      I've deployed pmm-client on PostgreSQL 11.5 nodes on debian systems.

      It worked pretty well for deployement, however there one issue with the QAN agent.

      The DSN generated for the connection to the database does not contains the postgres database, so the pmm_user cannot connect and query the pg_stat_statements table.

      Here are the logs from pmm-agent and the faulty DSN:

      Oct  1 09:05:11 db-geocible-01 pmm-agent[13458]:       type: QAN_POSTGRESQL_PGSTATEMENTS_AGENT
      Oct  1 09:05:11 db-geocible-01 pmm-agent[13458]:       dsn: "postgres://pmm_user:XXXXXXXX@127.0.0.1:5432?connect_timeout=1&sslmode=disable"
      

       

      The one for the postgres_exporter is correct however:

      Oct  1 09:05:11 db-geocible-01 pmm-agent[13458]:   type: POSTGRESQL_SERVICE
      Oct  1 09:05:11 db-geocible-01 pmm-agent[13458]:   dsn: "postgres://pmm_user:XXXXXX@127.0.0.1:5432/postgres?connect_timeout=2&sslmode=disable"

      Thanks.

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned
                Reporter:
                lcorbes Laurent CORBES
                Votes:
                0 Vote for this issue
                Watchers:
                4 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 - 10 minutes
                    10m