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(DISTINCT <primary_Key>)in the
- Red Hat Enterprise Virtualization (RHEV) 3.1
- Postgresql 8.4
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.