Back to bug 1388433

Who When What Removed Added
Red Hat Bugzilla Rules Engine 2016-10-25 10:44:24 UTC Flags testing_ack? planning_ack?
Martin Perina 2016-10-25 12:25:51 UTC CC mperina
Target Milestone --- ovirt-4.1.0-alpha
Flags ovirt-4.1.0?
Martin Perina 2016-10-25 12:40:31 UTC Blocks 1388462
Martin Perina 2016-10-25 15:13:10 UTC Summary change auto-vacuum configuration defaults [RFE] change auto-vacuum configuration defaults to match oVirt db usage
Red Hat Bugzilla Rules Engine 2016-10-25 15:13:14 UTC Keywords FutureFeature
Martin Perina 2016-10-25 15:13:38 UTC Summary [RFE] change auto-vacuum configuration defaults to match oVirt db usage [RFE] Change auto-vacuum configuration defaults to match oVirt db usage
Michal Skrivanek 2016-11-03 10:06:04 UTC CC michal.skrivanek
Severity unspecified high
Yedidyah Bar David 2016-11-03 12:51:52 UTC CC didi
Yaniv Lavi 2016-11-07 10:39:35 UTC CC ydary
Target Milestone ovirt-4.1.0-alpha ovirt-4.2.0
Flags ovirt-4.1? ovirt-4.2?
Martin Perina 2016-11-07 10:54:55 UTC CC rgolan
Yaniv Lavi 2016-11-15 11:19:07 UTC Flags needinfo?(mperina)
Martin Perina 2016-11-16 10:07:39 UTC Assignee sbonazzo rgolan
Target Milestone ovirt-4.2.0 ovirt-4.1.0-alpha
oVirt Team Integration Infra
Flags needinfo?(mperina) ovirt-4.2? ovirt-4.1?
Martin Perina 2016-11-16 10:08:10 UTC Component Setup.Engine Database.Core
Assignee rgolan emesika
Martin Perina 2016-11-16 10:08:26 UTC Assignee emesika rgolan
Pavel Stehlik 2016-11-16 15:20:55 UTC QA Contact pstehlik lleistne
Flags testing_ack? testing_ack+
Lukas Svaty 2016-12-01 13:49:32 UTC CC lsvaty
Flags testing_plan_complete-
Yaniv Lavi 2016-12-08 14:40:03 UTC Target Milestone ovirt-4.1.0-alpha ovirt-4.1.0-beta
Yaniv Lavi 2016-12-11 14:41:38 UTC CC ydary
Oved Ourfali 2016-12-14 08:56:05 UTC Blocks 1388462
Julio Entrena Perez 2016-12-20 09:50:54 UTC Link ID oVirt gerrit 68676
Status NEW POST
CC jentrena
Yaniv Kaul 2016-12-22 13:43:10 UTC CC mgoldboi
Target Milestone ovirt-4.1.0-beta ovirt-4.2.0
Flags needinfo?(mgoldboi)
Red Hat Bugzilla Rules Engine 2016-12-22 13:43:19 UTC Flags ovirt-4.1? ovirt-4.2?
Moran Goldboim 2016-12-26 14:22:41 UTC Flags needinfo?(mgoldboi) planning_ack? planning_ack+
Red Hat Bugzilla Rules Engine 2016-12-26 14:22:48 UTC Flags ovirt-4.2? ovirt-4.2+
Moran Goldboim 2016-12-26 14:41:12 UTC Target Milestone ovirt-4.2.0 ovirt-4.1.0-beta
Flags ovirt-4.2+ ovirt-4.1+
Roy Golan 2016-12-27 09:31:34 UTC See Also https://bugzilla.redhat.com/show_bug.cgi?id=1393270
Shirly Radco 2017-01-10 12:26:36 UTC Blocks 1411756
Martin Perina 2017-01-13 14:03:24 UTC Link ID oVirt gerrit 70309
Blocks 1393270
Martin Perina 2017-01-14 20:36:43 UTC Target Milestone ovirt-4.1.0-beta ovirt-4.1.1
Yedidyah Bar David 2017-02-13 14:17:52 UTC Link ID oVirt gerrit 70454
Link ID oVirt gerrit 70422
Link ID oVirt gerrit 71889
Link ID oVirt gerrit 72111
Link ID oVirt gerrit 71889
Martin Perina 2017-02-13 14:41:29 UTC Link ID oVirt gerrit 71889
Status POST MODIFIED
Roy Golan 2017-02-15 09:00:00 UTC Doc Text * there is a documentation bug opened for this one, see Bug 1411756

Feature:
Configure the engine's postgres with more aggressive vacuum daemon configuration.

Reason:
To prevent the frequently updates tables from piling up garbage and avoid or minimize the risk of disk flood and tx id wrap around

Result: The engine tables remain healthy, dead rows are collected in timely manner, disk space usage is correlated with the real amount of data kept.
Doc Type If docs needed, set a value Enhancement
Sandro Bonazzola 2017-02-16 13:53:38 UTC Target Release --- 4.1.1.2
Sandro Bonazzola 2017-02-16 14:30:46 UTC Status MODIFIED ON_QA
Lucie Leistnerova 2017-03-02 15:39:07 UTC Status ON_QA ASSIGNED
Red Hat Bugzilla Rules Engine 2017-03-02 15:39:13 UTC Target Release 4.1.1.2 ---
Martin Perina 2017-03-06 13:47:59 UTC Flags needinfo?(rgolan)
Oved Ourfali 2017-03-15 09:34:17 UTC Link ID oVirt gerrit 73818
Status ASSIGNED POST
Link ID oVirt gerrit 73942
CC oourfali
Flags needinfo?(rgolan)
Yaniv Kaul 2017-03-16 10:48:03 UTC Target Milestone ovirt-4.1.1 ovirt-4.1.2
Lucie Leistnerova 2017-05-02 14:34:08 UTC Link ID oVirt gerrit 74572
Link ID oVirt gerrit 74573
Link ID oVirt gerrit 74574
Link ID oVirt gerrit 74316
Status POST MODIFIED
Status MODIFIED ON_QA
Status ON_QA ASSIGNED
Oved Ourfali 2017-05-02 16:34:49 UTC Flags needinfo?(rgolan)
Roy Golan 2017-05-03 09:12:43 UTC CC lleistne
Flags needinfo?(rgolan) needinfo?(rgolan) needinfo?(rgolan) needinfo?(lleistne)
Lucie Leistnerova 2017-05-03 10:58:57 UTC Blocks 1447624
Lucie Leistnerova 2017-05-03 11:03:35 UTC Status ASSIGNED VERIFIED
Flags needinfo?(lleistne)
Sandro Bonazzola 2017-05-04 13:46:22 UTC CC rhev-integ-dev
Sandro Bonazzola 2017-05-12 06:47:21 UTC Target Release --- 4.1.2
Sandro Bonazzola 2017-05-23 08:19:50 UTC Status VERIFIED CLOSED
Resolution --- CURRENTRELEASE
Last Closed 2017-05-23 04:19:50 UTC
Emma Heftman 2017-06-26 09:01:24 UTC CC eheftman
Doc Text * there is a documentation bug opened for this one, see Bug 1411756

Feature:
Configure the engine's postgres with more aggressive vacuum daemon configuration.

Reason:
To prevent the frequently updates tables from piling up garbage and avoid or minimize the risk of disk flood and tx id wrap around

Result: The engine tables remain healthy, dead rows are collected in timely manner, disk space usage is correlated with the real amount of data kept.
Previously, the Manager’s PostgreSQL tables that were frequently updated would fill up with obsolete data, creating the risk of disk flooding and transaction ID wraparound issues.

This release has introduced a more aggressive vacuum daemon configuration for collecting obsolete rows. This enables the Manager’s tables to remain healthy, and for disk space usage to be better correlated with the actual amount of kept data.

Back to bug 1388433