PMM Query Analytics doesn't work with mongodb

Hello,

I’m running percona mongodb server in a docker with the following config in
docker-compose.yml:

mongo:
image: percona/percona-server-mongodb
command: --dbpath=/data/db -profile=2 -slowms=200 -rateLimit=100
restart: always
ports:
- "27017:27017"

The info from the DDBB about the Profiling is:

db.getProfilingStatus()
{
"was" : 2,
"slowms" : 200,
"ratelimit" : 100,
"sampleRate" : 1.0
}

Also, I created the user with permissions:

[
{
"_id" : "admin.admin",
"userId" : UUID("be9ad6ca-d3f2-4901-a7ae-d63b1bfedbbc"),
"user" : "admin",
"db" : "admin",
"roles" : [
{
"role" : "root",
"db" : "admin"
}
],
"mechanisms" : [
"SCRAM-SHA-1",
"SCRAM-SHA-256"
]
},
{
"_id" : "admin.mongodb_exporter",
"userId" : UUID("64fb0978-1a56-4b6d-a4df-57ec66e0a422"),
"user" : "mongodb_exporter",
"db" : "admin",
"roles" : [
{
"role" : "clusterMonitor",
"db" : "admin"
},
{
"role" : "read",
"db" : "MyDb1"
},
{
"role" : "read",
"db" : "Mydb2"
},
{
"role" : "read",
"db" : "local"
},
{
"role" : "read",
"db" : "admin"
}
],
"mechanisms" : [
"SCRAM-SHA-1",
"SCRAM-SHA-256"
]
}
]

But PMM is not working, that is the message:

Can anyone help me, please?

Many thanks!

Hello everybody!

Can anyone help me?

Many thanks!

You need to configure profiling in mongodb, but the cons when we enable profiling will sometime hurt the performance. I think, there’s a link how to Configuring profiling in Mongodb on the message.

Hello Agus Syafaat,

Yes, I do the config, and the query to mongodb shows the profiling is activated as I need, but query analitics doesn’t work till…

Can u review my config and tell me if isn’t correct?

Many thanks!

Can anyone help me, please?

Many thanks!

Hi rpedrero

Would you be able to record this in our JIRA system so that the PMM engineers can take a better look, please?

There are guidelines on how to make your report here: [URL]https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/50690-pmm-troubleshooting-and-how-to-report-a-bug[/URL]

Thank you!