user-revoke-access - Incorrect error is shown while revoking access from database on which doesn't have access

Bug #1302405 reported by shweta
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack DBaaS (Trove)
Confirmed
Low
Preeti

Bug Description

STEPS TO REPRODUCE:
1. create a user ( if doesn't exists)
ubuntu@shweta-test:~$ trove user-list b3e56616-fec8-4ff3-a31a-0260e80c5744
+-------+------+-----------+
| name | host | databases |
+-------+------+-----------+
| user1 | % | |
+-------+------+-----------+

2. Create database

ubuntu@shweta-test:~$ trove database-list b3e56616-fec8-4ff3-a31a-0260e80c5744
+--------------------+
| name |
+--------------------+
| database1 |
| performance_schema |
| test |
+--------------------+

3. Run user-revoke-access API using correct user and database. But user shouldn't have access on database.
ubuntu@shweta-test:~$ trove user-revoke-access b3e56616-fec8-4ff3-a31a-0260e80c5744 user1 database1
ERROR: Database database1 cannot be found on the instance

4. Incorrect error message is shown "Database database1 cannot be found on the instance" even when database exists on the instance.

shweta (shweta)
Changed in trove:
assignee: nobody → shweta (shweta)
Changed in trove:
assignee: shweta (shweta) → Deepika Goswami (deepika-goswami)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to trove (master)

Fix proposed to branch: master
Review: https://review.openstack.org/86258

Changed in trove:
status: New → In Progress
Changed in trove:
importance: Undecided → Low
milestone: none → juno-1
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on trove (master)

Change abandoned by Nikhil Manchanda (<email address hidden>) on branch: master
Review: https://review.openstack.org/86258
Reason: Review clean up.

Abandoning since the last update > 3 weeks ago.

Please restore if patch is still in progress.

Revision history for this message
Nikhil Manchanda (slicknik) wrote :

Deepika: Any update on the status of this bugfix? Thanks!

Changed in trove:
milestone: juno-1 → juno-2
Changed in trove:
milestone: juno-2 → juno-3
Changed in trove:
milestone: juno-3 → next
Revision history for this message
OpenStack Infra (hudson-openstack) wrote :

Change abandoned by Nikhil Manchanda (<email address hidden>) on branch: master
Review: https://review.openstack.org/86258
Reason: Abandoning patches that have a negative review and are older than 4 weeks as part of a house-keeping sweep. Please feel free to restore the patch if it is still actively being worked on.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to trove (master)

Fix proposed to branch: master
Review: https://review.openstack.org/142090

Changed in trove:
assignee: Deepika Goswami (deepika-goswami) → Sushil Kumar (sushil-kumar2)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on trove (master)

Change abandoned by amrith (<email address hidden>) on branch: master
Review: https://review.openstack.org/142090
Reason: abandoning for inactivity.

Amrith Kumar (amrith)
Changed in trove:
assignee: Sushil Kumar (sushil-kumar2) → nobody
status: In Progress → Confirmed
Preeti (pandey-preeti1)
Changed in trove:
assignee: nobody → Preeti (pandey-preeti1)
Revision history for this message
Preeti (pandey-preeti1) wrote :

While replicating the issue , after giving the command "trove create <name><flavor-id>" , the instance is going in an error state. Because of this a database cannot be associated to that instance. A bug is also raised for the same ( https://bugs.launchpad.net/trove/+bug/1352916 ). Can anyone help in solving the issue ?

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.