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

PMM Query Analytics doesn't work with mongodb

rpedrerorpedrero ContributorCurrent User Role Novice
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!

Comments

  • rpedrerorpedrero Contributor Current User Role Novice
    Hello everybody!

    Can anyone help me?

    Many thanks!
  • Agus SyafaatAgus Syafaat Entrant Current User Role Novice
    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.
  • rpedrerorpedrero Contributor Current User Role Novice
    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!
  • rpedrerorpedrero Contributor Current User Role Novice
    Can anyone help me, please?

    Many thanks!
  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    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: https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/50690-pmm-troubleshooting-and-how-to-report-a-bug

    Thank you!
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.