# PMM-SERVER mongodb:queries (dev-enable)

**URL:** <https://forums.percona.com/t/pmm-server-mongodb-queries-dev-enable/5664>\
**Category:** PMM 1.x\
**Created:** [June 7, 2017, 4:45pm UTC](https://forums.percona.com/t/pmm-server-mongodb-queries-dev-enable/5664 "2017-06-07T16:45:06Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![erino](https://avatars.discourse-cdn.com/v4/letter/e/ecb155/32.png) [@erino](https://forums.percona.com/u/erino)\
**Post date:** [June 7, 2017, 4:45pm UTC](https://forums.percona.com/t/pmm-server-mongodb-queries-dev-enable/5664/1 "2017-06-07T16:45:06Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [June 8, 2017, 1:47am UTC](https://forums.percona.com/t/pmm-server-mongodb-queries-dev-enable/5664/2 "2017-06-08T01:47:32Z")

</div>

Hi [erino](https://percona.vanillacommunities.com/profile/x/x/37784),

Do you use [url][http://pmm-server-ip/qan2/[/url]](http://pmm-server-ip/qan2/%5B/url%5D) interface?

---

<div class="post-metadata">

**Author:** ![erino](https://avatars.discourse-cdn.com/v4/letter/e/ecb155/32.png) [@erino](https://forums.percona.com/u/erino)\
**Post date:** [June 8, 2017, 1:21pm UTC](https://forums.percona.com/t/pmm-server-mongodb-queries-dev-enable/5664/3 "2017-06-08T13:21:13Z")

</div>

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…

---

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [June 9, 2017, 12:41am UTC](https://forums.percona.com/t/pmm-server-mongodb-queries-dev-enable/5664/4 "2017-06-09T00:41:35Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [June 13, 2017, 1:42pm UTC](https://forums.percona.com/t/pmm-server-mongodb-queries-dev-enable/5664/5 "2017-06-13T13:42:42Z")

</div>

[erino](https://percona.vanillacommunities.com/profile/x/x/37784) , [LIST=1]  
[_]Do you get query results from Primaries, or just Secondaries, or is it that none of the MongoDB nodes report queries ?  
[_]Confirming you have mongodb:queries configured, can you give us output of:

```auto
pmm-admin list

```

[\*]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): [url][https://jira.percona.com/projects/PMM/issues/PMM-931[/url]](https://jira.percona.com/projects/PMM/issues/PMM-931%5B/url%5D)  
[/LIST]

---

<div class="post-metadata">

**Author:** ![erino](https://avatars.discourse-cdn.com/v4/letter/e/ecb155/32.png) [@erino](https://forums.percona.com/u/erino)\
**Post date:** [June 13, 2017, 4:51pm UTC](https://forums.percona.com/t/pmm-server-mongodb-queries-dev-enable/5664/6 "2017-06-13T16:51:02Z")

</div>

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 /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.

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [June 14, 2017, 12:53pm UTC](https://forums.percona.com/t/pmm-server-mongodb-queries-dev-enable/5664/7 "2017-06-14T12:53:28Z")

</div>

Hi [erino](https://percona.vanillacommunities.com/profile/x/x/37784) , 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,

---

<div class="post-metadata">

**Author:** ![erino](https://avatars.discourse-cdn.com/v4/letter/e/ecb155/32.png) [@erino](https://forums.percona.com/u/erino)\
**Post date:** [June 15, 2017, 1:22pm UTC](https://forums.percona.com/t/pmm-server-mongodb-queries-dev-enable/5664/8 "2017-06-15T13:22:10Z")

</div>

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).

---

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [June 16, 2017, 4:36am UTC](https://forums.percona.com/t/pmm-server-mongodb-queries-dev-enable/5664/9 "2017-06-16T04:36:14Z")

</div>

> [@](#):
>
> 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](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…

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [June 21, 2017, 2:09pm UTC](https://forums.percona.com/t/pmm-server-mongodb-queries-dev-enable/5664/10 "2017-06-21T14:09:22Z")

</div>

Hi [erino](https://percona.vanillacommunities.com/profile/x/x/37784) , sorry for the delay, [kamil-dziedzic](https://percona.vanillacommunities.com/profile/x/x/22198) 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.  
[url][https://gist.github.com/arvenil/a4ae344eceb6e4d3141c9fc92ccdcbbc[/url]](https://gist.github.com/arvenil/a4ae344eceb6e4d3141c9fc92ccdcbbc%5B/url%5D)  
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!  
[url][[PMM-1016] QAN should advise profiling be enabled in MongoDB - Percona JIRA](https://jira.percona.com/browse/PMM-1016%5B/url%5D)

---

<div class="post-metadata">

**Author:** ![razvan1](https://avatars.discourse-cdn.com/v4/letter/r/a698b9/32.png) [@razvan1](https://forums.percona.com/u/razvan1)\
**Post date:** [June 25, 2017, 9:27am UTC](https://forums.percona.com/t/pmm-server-mongodb-queries-dev-enable/5664/11 "2017-06-25T09:27:54Z")

</div>

Hello,

[Michael Coburn](https://percona.vanillacommunities.com/profile/x/x/22577) 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?

---

<div class="post-metadata">

**Author:** ![razvan1](https://avatars.discourse-cdn.com/v4/letter/r/a698b9/32.png) [@razvan1](https://forums.percona.com/u/razvan1)\
**Post date:** [June 25, 2017, 9:35am UTC](https://forums.percona.com/t/pmm-server-mongodb-queries-dev-enable/5664/12 "2017-06-25T09:35:45Z")

</div>

Hello [Michael Coburn](https://percona.vanillacommunities.com/profile/x/x/22577) ,

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?

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [June 26, 2017, 6:55am UTC](https://forums.percona.com/t/pmm-server-mongodb-queries-dev-enable/5664/13 "2017-06-26T06:55:16Z")

</div>

[razvan1](https://percona.vanillacommunities.com/profile/x/x/39242) , are there logs on disk for the MongoDB queries? Can you try the tcpdump as provided by [erino](https://percona.vanillacommunities.com/profile/x/x/37784) in [url][https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/48680-pmm-server-mongodb-queries-dev-enable?p=48701#post48701[/url]](https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/48680-pmm-server-mongodb-queries-dev-enable?p=48701#post48701%5B/url%5D) and let us know if queries are hitting QAN application? Thanks,
