-
Bug
-
Resolution: Not a Bug
-
Normal
-
None
-
rhos-17.1.4
-
False
-
-
False
-
?
-
None
-
-
-
Moderate
Customer was facing issue with not being able to run the command openstack security group list.
The command failed with the following error [1]. We were able to single out the following project id using the following for loop [2][3] and remove several attributes that did not contain any data [4]. Customer can now issue a openstack security group list without error.
We have collected the neutron database (ovs-neutron.sql.gz). Please analyze to determine an RCA for the customer of how their neutron database ended up in this state.
SFDC: 04012751
[1]
openstack.exceptions.HttpException: HttpException: 500: Server Error for url: https://vl-ls-rhosp702.lb.videotron.ca:13696/v2.0/security-groups?fields=id&fields=name&fields=description&fields=project_id&fields=tags, Request Failed: internal server error while processing your request. clean_up ListSecurityGroup: HttpException: 500: Server Error for url: https://vl-ls-rhosp702.lb.videotron.ca:13696/v2.0/security-groups?fields=id&fields=name&fields=description&fields=project_id&fields=tags, Request Failed: internal server error while processing your request. END return value: 1.
[2]
for p in $( openstack project list -c ID -f value); do echo $p; openstack security group list – project-id $p; >/dev/null
[3]
1d64e40d4fd840a18aab15f91d379d7a HttpException: 500: Server Error for url: https://vl-ls-rhosp702.lb.videotron.ca:13696/v2.0/security-groups?fields=id&fields=name&fields=description&fields=project_id&fields=tags&project_id=1d64e40d4fd840a18aab15f91d379d7a&tenant_id=1d64e40d4fd840a18aab15f91d379d7a, Request Failed: internal server error while processing your request.
[4]
delete from standardattributes where id in ('18481','18541','18538','18535','18544','18532','18526','18529','18484');
- is triggering
-
OSPRH-15439 RCA OSPRH-15327
-
- Closed
-
