Bug 858643 - [backup] using pg_dump --column-inserts slows down the restore process
Summary: [backup] using pg_dump --column-inserts slows down the restore process
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine
Version: 3.1.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 3.1.0
Assignee: Alex Lourie
QA Contact: Pavel Stehlik
URL:
Whiteboard: infra integration
Depends On: 858640
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-09-19 09:53 UTC by Eli Mesika
Modified: 2014-06-11 02:19 UTC (History)
11 users (show)

Fixed In Version: si21
Doc Type: Enhancement
Doc Text:
--no tech note required
Clone Of: 858640
Environment:
Last Closed: 2012-12-04 19:16:38 UTC
oVirt Team: ---
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHSA-2012:1506 0 normal SHIPPED_LIVE Important: Red Hat Enterprise Virtualization Manager 3.1 2012-12-04 23:58:40 UTC

Description Eli Mesika 2012-09-19 09:53:47 UTC
+++ This bug was initially created as a clone of Bug #858640 +++

Description of problem:

Using the "--column-inserts" argument for pg_dump, increases the DB restore tens of times compared to not using it. Suggestion is to remove that param by default.

Version-Release number of selected component (if applicable):

rhev 3.0, rhev 3.1

How reproducible:

Always

Steps to Reproduce:
1. Generate a backup of rhevm and rhevm-history DB using pg_dump --column-inserts (check additional info)
2. Restore the backup

  
Actual results:

For big enough databases (10+ Gbs) I've seen the process can take from 30minutes to 2 hours

Expected results:

DB restore finishes in a few minutes, usually in less than a minute.

Additional info:

https://access.redhat.com/knowledge/docs/en-US/Red_Hat_Enterprise_Virtualization/3.0/html/Administration_Guide/Administration_Guide-Backing_Up.html#Administration_Guide-BU_Database_BU

And RHEV 3.1 beta backup.sh script

Comment 1 Itamar Heim 2012-09-19 10:11:53 UTC
this may also be relevant/affecting the installer which backsup the db

Comment 2 Eli Mesika 2012-09-23 11:14:28 UTC
http://gerrit.ovirt.org/#/c/8134/

Comment 3 Eli Mesika 2012-09-24 15:57:43 UTC
fixed in commit : 3a1c398

Comment 6 Pavel Stehlik 2012-10-08 14:48:52 UTC
FailedQA - si20 - only backupdb.sh script contains the new option - the default for rhevm-upgrade is still '--column-inserts'.
rhevm-setup-3.1.0-20.el6ev.noarch

Comment 8 Alex Lourie 2012-10-15 16:56:18 UTC
Patch posted for review:
http://gerrit.ovirt.org/#/c/8566/

Comment 10 Moran Goldboim 2012-10-16 13:20:15 UTC
as for now --column-inserts was removed from setup scripts, and open a bz866964 to track the move of usage in backup.sh- 
bz#866964 - rhevm-upgrade and rhevm-cleanup should use backup.sh to backup DB

Comment 11 Pavel Stehlik 2012-10-19 12:53:18 UTC
ok - si21.1

Comment 14 errata-xmlrpc 2012-12-04 19:16:38 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHSA-2012-1506.html


Note You need to log in before you can comment on or make changes to this bug.