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, 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