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

mongodb:queries and mysql:queries not working from same host

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Won't Fix
    • Affects Version/s: 1.3.1
    • Fix Version/s: None
    • Component/s: QAN Agent
    • Labels:

      Description

       

       

      if i start mysql+mongodb queries monitoring only mysql working.

      pmm-admin add mongodb:queries --uri=mongodb://user:pass@localhost:27017/databaseName

      > db.getProfilingLevel()
      2

       

      /var/log/pmm-mongodb-queries-0.log

      # Version: percona-qan-agent 1.3.1
      # Basedir: /usr/local/percona/qan-agent
      # PID: 31442
      # API: xxxx:8181/qan-api
      # UUID: e7c5fe8b72af4dd26d45466605e96c4d
      2017/10/05 01:03:19.809192 main.go:163: Starting agent...
      2017/10/05 01:03:19.810124 main.go:331: Agent is ready
      2017/10/05 01:03:19.813555 main.go:204: API is ready
      2017/10/05 01:03:20.952583 WARNING agent ws error: EOF
      2017/10/05 01:03:20.952634 WARNING agent Lost connection to API, reconnecting
      2017/10/05 01:03:24.218020 WARNING agent ws error: EOF
      2017/10/05 01:03:24.218071 WARNING agent Lost connection to API, reconnecting
      2017/10/05 01:03:31.330338 WARNING agent ws error: EOF
      2017/10/05 01:03:31.330438 WARNING agent Lost connection to API, reconnecting

      root@server:/var/log# cat /etc/issue.net
      Debian GNU/Linux 8

       

      /var/log/qan-api.log

      2017/10/04 22:05:25.810 127.0.0.1 0 27.231269ms WS /agents/e7c5fe8b72af4dd26d45466605e96c4d/data
      2017/10/04 22:05:27.001 127.0.0.1 0 1.219486ms WS /agents/e7c5fe8b72af4dd26d45466605e96c4d/data
      WARN 2017/10/04 22:06:17 ws.go:102: [Agent.Cmd] agent_id=2 0.0.9 http://kolay Failed to add to directory: duplicate agent
      2017/10/04 22:06:17.616 127.0.0.1 0 105.230508ms WS /agents/e7c5fe8b72af4dd26d45466605e96c4d/cmd
      2017/10/04 22:06:21.999 127.0.0.1 0 5.176623553s WS /agents/e7c5fe8b72af4dd26d45466605e96c4d/data
      2017/10/04 22:06:28 mysql.go:184: WARNING: %!s(int=47) duplicate query class metrics: start_ts='2017-10-04 22:05:00.001057305 +0000 UTC': MySQL 0fddd078039743a15209b5c51d245728
      2017/10/04 22:06:28 mysql.go:248: WARNING: duplicate global metrics: start_ts='2017-10-04 22:05:00.001057305 +0000 UTC': MySQL 0fddd078039743a15209b5c51d245728
      2017/10/04 22:06:29 mysql.go:184: WARNING: %!s(int=47) duplicate query class metrics: start_ts='2017-10-04 22:05:00.00144396 +0000 UTC': MySQL 0fddd078039743a15209b5c51d245728
      2017/10/04 22:06:29 mysql.go:248: WARNING: duplicate global metrics: start_ts='2017-10-04 22:05:00.00144396 +0000 UTC': MySQL 0fddd078039743a15209b5c51d245728
      2017/10/04 22:06:28.810 127.0.0.1 0 428.470049ms WS /agents/e7c5fe8b72af4dd26d45466605e96c4d/data
      2017/10/04 22:06:30.001 127.0.0.1 0 1.258397ms WS /agents/e7c5fe8b72af4dd26d45466605e96c4d/data
      WARN 2017/10/04 22:07:17 ws.go:102: [Agent.Cmd] agent_id=2 0.0.9 http://kolay Failed to add to directory: duplicate agent
      2017/10/04 22:07:17.722 127.0.0.1 0 95.485481ms WS /agents/e7c5fe8b72af4dd26d45466605e96c4d/cmd
      2017/10/04 22:07:24.999 127.0.0.1 0 5.247379658s WS /agents/e7c5fe8b72af4dd26d45466605e96c4d/data
      2017/10/04 22:07:31 mysql.go:184: WARNING: %!s(int=47) duplicate query class metrics: start_ts='2017-10-04 22:06:00.001074568 +0000 UTC': MySQL 0fddd078039743a15209b5c51d245728
      2017/10/04 22:07:31 mysql.go:248: WARNING: duplicate global metrics: start_ts='2017-10-04 22:06:00.001074568 +0000 UTC': MySQL 0fddd078039743a15209b5c51d245728
      2017/10/04 22:07:31 mysql.go:184: WARNING: %!s(int=47) duplicate query class metrics: start_ts='2017-10-04 22:06:00.001457819 +0000 UTC': MySQL 0fddd078039743a15209b5c51d245728
      2017/10/04 22:07:31 mysql.go:248: WARNING: duplicate global metrics: start_ts='2017-10-04 22:06:00.001457819 +0000 UTC': MySQL 0fddd078039743a15209b5c51d245728
      2017/10/04 22:07:31.810 127.0.0.1 0 156.7257ms WS /agents/e7c5fe8b72af4dd26d45466605e96c4d/data
      2017/10/04 22:07:33.001 127.0.0.1 0 1.668755ms WS /agents/e7c5fe8b72af4dd26d45466605e96c4d/data

       

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                nailya.kutlubaeva Nailya Kutlubaeva
                Reporter:
                kingem kadir mutlu
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: