Description of problem: User is not deleted from users_details_history db after it was deleted from engine db Version-Release number of selected component (if applicable): How reproducible: Have a setup with oVirt and oVirt DWH Steps to Reproduce: 1.Add a AD domain using engine-manage-domains 2.Add a new user from AD 3.User is synced to the users_details_history table in DWH DB 4.Remove the user you had added in 2) Actual results: User is removed from engine users table but is not deleted from DWH users_details_history table Expected results: User should be deleted from users_details_history DWH after it was removed from the users engine table Additional info:
This is by design if the user gets a delete date after deletion. Yaniv
This is what I have got on the DWH side after deletion : ovirt_engine_history=# select * from users_details_history; -[ RECORD 1 ]---+------------------------------------- user_id | 518f2d93-ab2d-42a4-af41-f7295d3c97f5 first_name | yair_group_member2 last_name | domain | qa.lab.tlv.redhat.com username | yair_group_member2 department | user_role_title | email | external_id | 0814faaf-5f98-4ab8-8e1b-e38de16f0fdd active | t create_date | 2014-07-29 17:11:35.31+03 update_date | delete_date | -[ RECORD 2 ]---+------------------------------------- user_id | fdfc627c-d875-11e0-90f0-83df133b58cc first_name | admin last_name | domain | internal username | admin department | user_role_title | email | external_id | fdfc627c-d875-11e0-90f0-83df133b58cc active | t create_date | 2014-07-29 10:53:35.471+03 update_date | 2014-07-29 17:06:18.305+03 delete_date | I expect to get at least the delete_date for the 1st record
tested on vt2.2, delete date was set correctly after user was deleted from engine
oVirt 3.5 has been released and should include the fix for this issue.