Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 2290417

Summary:	Listing servers per project is very slow
Product:	Red Hat OpenStack	Reporter:	Jakub Libosvar <jlibosva>
Component:	openstack-neutron	Assignee:	OSP Team <rhos-maint>
Status:	CLOSED DUPLICATE	QA Contact:	Eran Kuris <ekuris>
Severity:	urgent	Docs Contact:
Priority:	unspecified
Version:	17.1 (Wallaby)	CC:	chrisw, scohen
Target Milestone:	---	Keywords:	Regression
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2024-06-04 16:58:59 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Jakub Libosvar 2024-06-04 16:43:51 UTC

Description of problem:
server list --project command queries all ports belonging to all servers in that project. Neutron then creates a cartesian product across all tables making it very huge table to query. This is caused by upstream patch https://review.opendev.org/c/openstack/neutron/+/891580/3/neutron/db/models/tag.py

Version-Release number of selected component (if applicable):
17.1.3

How reproducible:
Always

Steps to Reproduce:
1. Create lot of VMs under one project
2. Add lot of security groups and tags
3.

Actual results:
It's slow

Expected results:
Not slow

Additional info:

Comment 1 Jakub Libosvar 2024-06-04 16:58:59 UTC


*** This bug has been marked as a duplicate of bug 2290400 ***