Not the answer you need?
Register and ask your own question!

PMM-SERVER mongodb:queries (dev-enable)

erinoerino ContributorInactive User Role Beginner
I really love PMM. I've got a couple of MySQL RDS & a couple of ec2 mongoDB clusters. I really would love to see the queries on mongoDB clusters. but it doesn't seem to work.
pmm-admin 1.1.4
MongoDB 2.6.9

Is my Mongo just too old?

Comments

  • MykolaMykola Percona Percona Staff Role
    Hi erino,

    Do you use http://pmm-server-ip/qan2/ interface?
  • erinoerino Contributor Inactive User Role Beginner
    Damn forgot that qan2 bit. However, when I go there it shows no data (I went back 5 days). However doing this:
    tcpdump dst port 27017 -A -s 1400 |grep query > /tmp/queries.txt
    gave me lots of data....
  • MykolaMykola Percona Percona Staff Role
    qan2 is experimental, so it is possible to catch the bug.
    can you share a screen shot with no data?
    maybe you see any javascript errors in console (in "Developer Tools").
    I will share your response with our developers
  • Michael CoburnMichael Coburn Principal Architect, Percona Percona Staff Role
    erino ,
    1. Do you get query results from Primaries, or just Secondaries, or is it that none of the MongoDB nodes report queries ?
    2. Confirming you have mongodb:queries configured, can you give us output of:
      pmm-admin list
      
    3. You might be affected by a bug in 1.1.4 , perhaps try using 1.1.3 agent, or watch this ticket for when we release a fix (possibly going to push a hotfix, still debating this internally): https://jira.percona.com/projects/PMM/issues/PMM-931
  • erinoerino Contributor Inactive User Role Beginner
    I only monitor the Primary (keeps my PMM server instance smaller not to have everything).
    pmm-admin list
    mongodb:queries ############### - YES localhost:##### query_examples=true
    linux:metrics ############### 42000 YES -
    mongodb:metrics ############### 42003 YES localhost:#####

    I went to <PMM-SERVER>/qan2 and didn't notice that the default db was NOT mongo & for a second there I was all excited to have queries.... I just get the No data for selected time-range.

    I will keep my eyes peeled for the next hotfix.
  • Michael CoburnMichael Coburn Principal Architect, Percona Percona Staff Role
    Hi erino , I don't have a solution for you yet - we're discussing this internally, and look for an update in next day or two here on the forums. Thanks,
  • erinoerino Contributor Inactive User Role Beginner
    Just to add a bit more. The percona-qan-age took over one whole CPU. top had this:
    965 root 20 0 218164 14144 7120 R 99.7 0.2 294:18.87 percona-qan-age

    I removed it like this:
    pmm-admin rm --dev-enable mongodb:queries

    This aws instance is an m4.large. MongoDB is not that large (about 7.2GB).
  • MykolaMykola Percona Percona Staff Role
    The percona-qan-age took over one whole CPU.
    Oh, I think we need to reproduce the issue...

    jfyi 2.6.9 is unsupported officially by MongoDB, Inc. - see https://www.mongodb.com/support-policy

    what operating system do you use?
    do you use upstream MongoDB Community Server 2.6.9? (not MongoDB Enterprise Server and not Percona Server for MongoDB)

    I will try to reproduce situation and show it to our PMM developers...
  • Michael CoburnMichael Coburn Principal Architect, Percona Percona Staff Role
    Hi erino , sorry for the delay, kamil-dziedzic wrote up a good summary of what is likely going on here, tl;dr; profiing isn't enabled by default, so while you have the agent running, it is possible that mongod isn't generating anything to analyse and submit to QAN2. If this is the case, I suggest you take a look at this gist and see if it helps.
    https://gist.github.com/arvenil/a4ae344eceb6e4d3141c9fc92ccdcbbc
    Based on your feedback we'll improve how pmm-admin works with something like this proposal - but we'd love to hear your comments directly in this issue as well!
    https://jira.percona.com/browse/PMM-1016
  • razvan1razvan1 Entrant Legacy User Role Beginner
    Hello,

    Michael Coburn I have enable Profiling on Percona MongoDB and still nothing shows on QAN2 dashboard.
    Profiling is enable in mode 2 (all) with slowms at 20.
    In PMM logs nothing strange shows.
    Can you help me please to fix this?
  • razvan1razvan1 Entrant Legacy User Role Beginner
    Hello Michael Coburn ,

    I and using percona mongodb have enabled profiling from config, not only for one db, but on QAN2 dashboard nothing shows. Also checking pmm logs i don't saw anything strange there to guide me for more research.
    Should i do something else to have QAN2 working?
  • Michael CoburnMichael Coburn Principal Architect, Percona Percona Staff Role
    razvan1 , are there logs on disk for the MongoDB queries? Can you try the tcpdump as provided by erino in https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/48680-pmm-server-mongodb-queries-dev-enable?p=48701#post48701 and let us know if queries are hitting QAN application? Thanks,
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.