Duplicate entries in the RHEVM UI
Issue
After the /var filesystem became full or corrupted, the low-level postgres DB was corrupted and allowed duplicate entries into a table that should have been protected by a primary key constraint. This problem will manifest itself in several different ways, including:
- Duplicate entries in the UI - When the duplicate is something that you can click on via the UI, you will notice that all instances if the duplicate are highlighted
- Odd behavior in the UI - Apart from item duplication, other actions using the UI do not perform as expected (migrations, for example, have no "OK" or "Cancel" buttons).
- Differing row counts between
select count(<primary_key>)
andselect count(DISTINCT <primary_Key>)
in theengine
database
Environment
- Red Hat Enterprise Virtualization (RHEV) 3.1
- Postgresql 8.4
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.