Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

QAN-API returns Unsupported NaN error for MongoDB

Description

  1. Install PMM server and client

  2. Enable Profiling in Mongo and then enable MongoDB monitoring

  3. Run some queries, like:

    db.runCommand({ update: "myColl", updates: [ { q: { category: "cafe", status: "a" }, u: { $set: { status: "Updated" } } } ] }) db.myCol.insert({ _id: 2, category: "cafe", status: "a" })

  1. Wait for a couple of min and check MongoDB QAN . MongoDB QAN shows these queries in Top

  2. Repeat step 3-4 in a few hours
    Result: PMM Server returns : "No data. Please check pmm-client and database configurations on selected instance.", but then I checked request, which QAN sent, https://10.10.11.50/qan-api/qan/profile/fe33986d0c02440a4992d1f5b3dd40e4?begin=2017-09-11T06:04:32&end=2017-09-11T07:04:32&offset=0 it returned "Server Error:
    json: unsupported value: NaN

Additionally, an error occurred when rendering the error page:

Template errors/200.json not found."

How to test

None

How to document

None

Smart Checklist

Activity

Nailya Kutlubaeva February 1, 2018 at 7:11 AM

I can't reproduce this error with 1.7
I'm closing the issue. if I find this error again, I'll create new issue.

Kamil Dziedzic October 9, 2017 at 12:06 PM

I can't reproduce this, can someone else try this out?

Roma Novikov September 15, 2017 at 1:17 PM

ok. so this is  what and should solve ... for low load instances. it probably exists in MySQL too 

Nailya Kutlubaeva September 14, 2017 at 12:00 PM
Edited

For PMM 1.3.0 I repeated again with the new steps:

  1. Add mongodb:queries to monitoring

  2. Execute 10 times the next queries:

    db.book.insert( { " name" : "learn php", "date_created" : 1483604909, "date_modified" : 1483612417, "exp_date" : 1556648999, "status" : "1" }, { "name" : "learn java", "date_created" : 1483604909, "date_modified" : 1483612417, "exp_date" : 1556648999, "status" : "1" }, { "name" : "learn javascript", "date_created" : 1483604909, "date_modified" : 1483612417, "exp_date" : 1556648999, "status" : "1"} ) db.book.find()

  3. Check that data shows up in QAN

  4. Wait for an hour (there is no any data generated at this period)

  5. Try to check data for the last hr
    Result: QAN2 returns : "No data. Please check pmm-client and database configurations on selected instance." and QAN returns: "QAN API error.
    Check the /var/log/qan-api.log file in docker container for more information. "and JS-error ""Server Error:
    json: unsupported value: NaN
    Additionally, an error occurred when rendering the error page:
    Template errors/200.json not found.""

Michael Coburn September 12, 2017 at 12:44 PM

- as discussed

  1. Create a reproducible set of steps for this Bug

  2. Determine if it affects multiple installations? or is it only 's?

  3. Classify as 1.3.0 or not

Cannot Reproduce

Details

Assignee

Reporter

Priority

Components

Story Points

Affects versions

Smart Checklist

Created September 11, 2017 at 7:13 AM
Updated November 13, 2024 at 8:33 AM
Resolved February 1, 2018 at 7:11 AM

Flag notifications