Unable to perform a RHEV-M backup.

Solution Verified - Updated -

Environment

  • Red Hat Enterprise Virtualization 3.5
  • Red Hat Enterprise Linux Server release 6.6
  • openssl-1.0.1e-30.el6_6.11.x86_64

Issue

  • Unable to perform a full RHEV-M backup (setting scope to ALL).
# /usr/bin/engine-backup --mode=backup --scope=all --file="/var/lib/ovirt-engine-backups/engine-backup-$(date +%Y%m%d%H%M%S).tar.bz2" --log=/var/log/ovirt-engine-backups.log
Backing up:
- Files
- Engine database 'engine'
- DWH database 'ovirt_engine_history'
FATAL: Database ovirt_engine_history backup failed

Resolution

Root Cause

  • Postgres is unable to transfer data more then 2 GB across an SSL-encrypted connection.

  • The ovirt_engine_history database size is 4830 MB which is greater then 2GB. To determine database size, please refer to the Diagnostic Steps below and/or contact Red Hat Technical Support for assistance.

Diagnostic Steps

  • The log output file specified in the '/usr/bin/engine-backup' command shows the following error when backing up the dwh database.
2015-09-11 16:28:30 9086: Start of engine-backup mode backup scope all file /var/lib/ovirt-engine-backups/backup.20150911162830.tar.bz2
2015-09-11 16:28:30 9086: Backing up:
2015-09-11 16:28:30 9086: Generating pgpass
2015-09-11 16:28:30 9086: Creating temp folder /tmp/engine-backup.WkiR4A1UUB/tar
2015-09-11 16:28:30 9086: - Files
2015-09-11 16:28:30 9086: Backing up files to /tmp/engine-backup.WkiR4A1UUB/tar/files
2015-09-11 16:28:31 9086: - Engine database 'engine'
2015-09-11 16:28:31 9086: Backing up database to /tmp/engine-backup.WkiR4A1UUB/tar/db/engine_backup.db
2015-09-11 16:28:33 9086: - DWH database 'ovirt_engine_history'
2015-09-11 16:28:33 9086: Backing up dwh database to /tmp/engine-backup.WkiR4A1UUB/tar/db/dwh_backup.db
pg_dump: Dumping the contents of table "vm_disk_samples_history" failed: PQgetCopyData() failed.
pg_dump: Error message from server: SSL error: unexpected message
pg_dump: The command was: COPY public.vm_disk_samples_history (history_id, history_datetime, image_id, vm_disk_status, minutes_in_status, vm_disk_actual_size_mb, read_rate_bytes_per_second, read_latency_seconds, write_rate_bytes_per_second, write_latency_seconds, flush_latency_seconds, vm_disk_configuration_version, vm_disk_id) TO stdout;
2015-09-11 16:30:24 9086: FATAL: Database ovirt_engine_history backup failed"
  • Default 'ssl_renegotiation_limit' for the database is 512 MB. Additional information on ssl_renegotiation_limit parameter.
 ssl_renegotiation_limit | 524288                            | kB
  • The 'ovirt_engine_history' database is about 3.7 GB.
 pg_size_pretty 
----------------
 4830 MB
(1 row)

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Comments