Tenant timeout loading #321

Closed
opened 2025-12-29 16:20:51 +01:00 by adam · 3 comments
Owner

Originally created by @alarido on GitHub (Aug 3, 2016).

I have a big tenant thousands of IP addresses, hundreds of prefixes, vrfs, connections, devices, ... when I go to the tenant view it timeouts:

https://netbox.server/tenancy/tenants/MYBIGTENANT/

I have been increasing timeout from default to several minutes, but it does not load anyways, it always timeouts, database and netbox server load is low:

Apache proxy error:

Proxy Error

The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request GET /tenancy/tenants/MYBIGTENANT/.

Reason: Error reading from remote server

supervisord netbox log error:

2016-08-03 09:28:33 [37301] [ERROR] WORKER TIMEOUT (pid:37306)

Originally created by @alarido on GitHub (Aug 3, 2016). I have a big tenant thousands of IP addresses, hundreds of prefixes, vrfs, connections, devices, ... when I go to the tenant view it timeouts: https://netbox.server/tenancy/tenants/MYBIGTENANT/ I have been increasing timeout from default to several minutes, but it does not load anyways, it always timeouts, database and netbox server load is low: Apache proxy error: ``` Proxy Error The proxy server received an invalid response from an upstream server. The proxy server could not handle the request GET /tenancy/tenants/MYBIGTENANT/. Reason: Error reading from remote server ``` supervisord netbox log error: `2016-08-03 09:28:33 [37301] [ERROR] WORKER TIMEOUT (pid:37306)`
adam added the type: bug label 2025-12-29 16:20:51 +01:00
adam closed this issue 2025-12-29 16:20:51 +01:00
Author
Owner

@jeremystretch commented on GitHub (Aug 3, 2016):

@alarido I suspect that the way we're annotating stats for the tenant in a single query is causing a database performance issue. I've rewritten the view to use a simple, discrete COUNT() for each statistic now. Could you try pulling down the develop branch and seeing if it solves the issue for you?

@jeremystretch commented on GitHub (Aug 3, 2016): @alarido I suspect that the way we're annotating stats for the tenant in a single query is causing a database performance issue. I've rewritten the view to use a simple, discrete `COUNT()` for each statistic now. Could you try pulling down the `develop` branch and seeing if it solves the issue for you?
Author
Owner

@jeremystretch commented on GitHub (Aug 3, 2016):

Should be fixed in v1.4.1 but please let me know if you still experience the problem.

@jeremystretch commented on GitHub (Aug 3, 2016): Should be fixed in v1.4.1 but please let me know if you still experience the problem.
Author
Owner

@alarido commented on GitHub (Aug 4, 2016):

It is fixed, thanks.

@alarido commented on GitHub (Aug 4, 2016): It is fixed, thanks.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#321