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

percona-qan-agent keeps trying to access second mysql:queries service even after removal

    Details

    • Type: Bug
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 1.17.0
    • Fix Version/s: None
    • Component/s: QAN Agent
    • Labels:
      None
    • Environment:

      CentOS Linux release 7.5.1804 (Core)

      client packages installed from rpm, latest docker image was used for server, both: 1.17.0

      Description

      ln -s /var/lib/mysql/mysql.sock /var/lib/mysql/mysql1.sock
      ln -s /var/lib/mysql/mysql.sock /var/lib/mysql/mysql2.sock
      pmm-admin add mysql:queries --help
      pmm-admin add mysql:queries --socket=/var/lib/mysql/mysql1.sock db1
      pmm-admin add mysql:queries --socket=/var/lib/mysql/mysql2.sock db2

      rm /var/lib/mysql/mysql2.sock
      pmm-admin remove mysql:queries db2

      /var/log/pmm-mysql-queries-0.log flooded with:

      2018/12/29 07:00:03.267086 WARNING qan-analyzer-mysql-dfe8b549 Cannot connect to MySQL root:***@unix(/var/lib/mysql/mysql2.sock): connect: no such file or directory: /var/lib/mysql/mysql2.sock
      2018/12/29 07:00:04.270995 WARNING qan-analyzer-mysql-dfe8b549 Cannot connect to MySQL root:***@unix(/var/lib/mysql/mysql2.sock): connect: no such file or directory: /var/lib/mysql/mysql2.sock

      Workaround, stop-start manually last standing service:

      pmm-admin stop mysql:queries db1
      pmm-admin start mysql:queries db1

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                nickolay.ihalainen Nickolay Ihalainen
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: