no cluster list with a large number of virtual servers

[someconservator]

Deployment Type

Self-hosted

NetBox Version

v4.2.2

Python Version

3.11

Steps to Reproduce

add a large number of virtual servers (for ex 100К)

1. select .../virtualization/virtual-machines/
2. select Filters
3. click inside Cluster box.
4. see "No results found"

Expected Behavior

list of clusters

Observed Behavior

no list of clusters

[jnovinger]

Thank you for opening a bug report, @someconservator . Unfortunately, the information you have provided is not sufficient for someone else to attempt to reproduce the reported behavior. Each bug report must include detailed steps that someone else can follow on a clean, empty NetBox installation to reproduce the exact problem you're experiencing.

These instructions should include the creation of any involved objects, any configuration changes, and complete accounting of the actions being taken. Be sure that your report does not reference data on the public NetBox demo, as that is subject to change at any time by an outside party and cannot be relied upon for bug reports.

Additionally, I note that this is reported against v4.2.2. Please verify the behavior in the current release (v4.3.2).

[someconservator]

O! Sorry! Additional steps:
a) the respective clusters mast be created.
b) most of those 100K+ servers must be associated with one of them.

Also, we can't repeat this error on the latest working version yet due to the large number of netbox users who take a long time to approve upgrades. and i'm afraid we'll always be behind. i reported this just in case, suddenly nothing has changed in this place in the new versions. Just reported what I could. Maybe it will be useful...

By the way, reducing the number of servers predictably removed the problem, so I believe it is somehow related to the ORM and and presumably with the fact that netbox makes here its request not just for clusters, but also for all servers associated with them.