Backup RH(E)VM database fails with message:"missing chunk number for toast value"

Solution Verified - Updated -

Issue

It is not possible to take backup of RH(E)VM database. The pg_dump fails with message:

pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  missing chunk number 0 for toast value 27029684 in pg_toast_1223696
pg_dump: The command was: COPY public.snapshots (snapshot_id, vm_id, snapshot_type, status, description, creation_date, app_list, vm_configuration, _create_date, _update_date, memory_volume) TO stdout;

Environment

  • Red Hat Enterprise Virtualization
  • Red Hat Virtualization

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
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.