Duplicate entries in the RHEVM UI

Solution Verified - Updated -

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>) and select count(DISTINCT <primary_Key>) in the engine 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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In