Fix race in Postgres user-list
Bug #1617464 reported by
Petr Malik
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack DBaaS (Trove) |
Fix Released
|
Medium
|
Petr Malik |
Bug Description
Certain postgresql operations take quite some time.
The current implementation of user-list suffers
from a race condition (manifested on the gate).
The list is constructed by first retrieving
all user names from the database and then querying
again for access rights of each of them.
Apart from being inefficient (need to query for every user)
if a change (say, rename) occurs in between, the code subsequently
attempts to retrieve permissions on a non-existing username and
fails.
Changed in trove: | |
milestone: | none → newton-1 |
Changed in trove: | |
assignee: | Petr Malik (pmalik) → Amrith (amrith) |
Changed in trove: | |
assignee: | Amrith (amrith) → Petr Malik (pmalik) |
To post a comment you must log in.
Fix proposed to branch: master /review. openstack. org/361477
Review: https:/