Backup RH(E)VM database fails with message:"missing chunk number for toast value"
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.