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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content