Capacity Metrics with mysql

[dioworld93]

Environment

• Nautobot version (Docker tag too if applicable):
• Python version: Python 3.9.20
• Database platform, version: mysql-server-8.0.36-1
• Middleware(s):

Steps to Reproduce

1. follow the guide to install capacity metrics. from the gui under apps , it is installed, the page say it supports mysql

Expected Behavior

When trying https://nautobot.xxx.com/api/plugins/capacity-metrics/app-metrics
should see the data, like demo.nautobot.com/api/plugins/capacity-metrics/app-metrics

Observed Behavior

{"error": "DISTINCT ON fields is not supported by this database backend", "exception": "NotSupportedError", "nautobot_version": "2.3.13", "python_version": "3.9.20"}
mysql database

[dioworld93]

And I tried enable the /metrics one from core , that one works with mysql

[glennmatthews]

Thanks for the report. What other apps do you have installed and enabled?

[dioworld93]

LifeCycle and floorplan

[glennmatthews]

This looks like a bug in nautobot-capacity-metrics, likely here and below in that same file. I'm going to forward this issue to that repository. Looks like a workaround in the interim might be to disable the jobs app metric specifically.

[dioworld93]

Thanks, Please let me know when this is fixed so can reinstall it.
and do you have to instructions for the workaround?
Thanks

[glennmatthews]

https://docs.nautobot.com/projects/capacity-metrics/en/latest/admin/install/#install-guide - see the section about configuring a PLUGINS_CONFIG, I'd imagine setting "Jobs": False as a part of that dict would be the workaround but I haven't tried it.

[dioworld93]

Thanks, Just tested it, it works.
I'll roll back the snapshot for now and wait for the bug fixed version.
Thanks

[gsnider2195]

We should either:

• Fix the 2 querysets that aren't working with mysql (do the deduplication in python)
• Document the features that are not supported in mysql and skip those features if the database backend is mysql