Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1538716

Summary:	[Docs][RFE] Document that remote or manually configured databases need 'work_mem = 8192' in postgresql.conf
Product:	Red Hat Enterprise Virtualization Manager	Reporter:	Jiri Belka <jbelka>
Component:	Documentation	Assignee:	Emma Heftman <eheftman>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Tahlia Richardson <trichard>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	4.2.0	CC:	eheftman, lbopf, lsurette, mperina, rbalakri, srevivo, ykaul
Target Milestone:	ovirt-4.2.2	Keywords:	FutureFeature, Triaged
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
URL:	https://access.redhat.com/documentation/en-us/red_hat_virtualization/4.2-beta/html/installation_guide/appe-preparing_a_remote_postgresql_database_for_use_with_the_red_hat_enterprise_virtualization_manager
Whiteboard:	docs-accepted
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2018-03-14 14:26:46 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	Docs	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:	1510432
Bug Blocks:

Description Jiri Belka 2018-01-25 16:09:02 UTC

Description of problem:

https://access.redhat.com/documentation/en-us/red_hat_virtualization/4.2-beta/html/installation_guide/appe-preparing_a_remote_postgresql_database_for_use_with_the_red_hat_enterprise_virtualization_manager

for remote db postgresql.conf needs 'work_mem = 8192'. i would almost bet that i saw it somewhere in docs as my previous remote db env has this manually set.

if not set, this happens:

2018-01-25 16:48:29,096+0100 DEBUG otopi.context context.dumpEnvironment:833 ENV OVESETUP_DB/invalidConfigItems=list:'[{'name': 'Engine', 'current': '4096', 'key': 'work_mem', 'e
xpected': 8192, 'format_str': '{key} required to be at least {expected}', 'pg_host': '**FILTERED**.example.com'}]'
2018-01-25 16:48:29,097+0100 DEBUG otopi.context context.dumpEnvironment:837 ENVIRONMENT DUMP - END
2018-01-25 16:48:29,099+0100 DEBUG otopi.context context._executeMethod:128 Stage customization METHOD otopi.plugins.ovirt_engine_setup.ovirt_engine.db.configuration.Plugin._cust
omization
2018-01-25 16:48:29,100+0100 DEBUG otopi.plugins.otopi.dialog.human dialog.__logString:204 DIALOG:SEND                
2018-01-25 16:48:29,100+0100 DEBUG otopi.plugins.otopi.dialog.human dialog.__logString:204 DIALOG:SEND                 Found the following problems in PostgreSQL configuration fo
r the Engine database:
2018-01-25 16:48:29,101+0100 DEBUG otopi.plugins.otopi.dialog.human dialog.__logString:204 DIALOG:SEND                  work_mem required to be at least 8192
2018-01-25 16:48:29,101+0100 DEBUG otopi.plugins.otopi.dialog.human dialog.__logString:204 DIALOG:SEND                 Please set:
2018-01-25 16:48:29,102+0100 DEBUG otopi.plugins.otopi.dialog.human dialog.__logString:204 DIALOG:SEND                  work_mem = 8192
2018-01-25 16:48:29,102+0100 DEBUG otopi.plugins.otopi.dialog.human dialog.__logString:204 DIALOG:SEND                 in postgresql.conf on '**FILTERED**.example.com'. Its locat
ion is usually /var/lib/pgsql/data , or somewhere under /etc/postgresql* .
2018-01-25 16:48:29,103+0100 DEBUG otopi.context context._executeMethod:143 method exception
Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/otopi/context.py", line 133, in _executeMethod
    method['method']()
  File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db/configuration.py", line 245, in _customization
    'Please fix PostgreSQL configuration and retry.'
RuntimeError: Please fix PostgreSQL configuration and retry.
2018-01-25 16:48:29,105+0100 ERROR otopi.context context._executeMethod:152 Failed to execute stage 'Environment customization': Please fix PostgreSQL configuration and retry.

Comment 1 Lucy Bopf 2018-02-16 07:02:20 UTC

Thanks for reporting, Jiri,

Martin, I'd like to get your ack here first, since you reviewed the same section recently for bug 1534928. Is the parameter that Jiri suggests here required for all setups?

Comment 2 Martin Perina 2018-02-16 08:35:52 UTC

(In reply to Lucy Bopf from comment #1)
> Thanks for reporting, Jiri,
> 
> Martin, I'd like to get your ack here first, since you reviewed the same
> section recently for bug 1534928. Is the parameter that Jiri suggests here
> required for all setups?

I've just find out that it was added as a part of fix for BZ1510432, but unfortunately it was not documented there. I've just fixed the Doc Text for BZ1510432, so yes, please add this new requirement into the list of existing requirements for unmanaged local or remote engine databases.

Comment 3 Lucy Bopf 2018-02-22 06:54:10 UTC

Thanks for confirming, Martin.

We'll review this one in the context of the next beta milestone.

Comment 4 Lucy Bopf 2018-02-22 06:56:07 UTC

Accepting into beta 3 program and assigning to Emma for review.

Comment 13 Emma Heftman 2018-03-14 14:26:46 UTC

The updated documentation has been published and is available here:

https://access.redhat.com/documentation/en-us/red_hat_virtualization/4.2-beta/html-single/installation_guide/#appe-Preparing_a_Remote_PostgreSQL_Database_for_Use_with_the_Red_Hat_Enterprise_Virtualization_Manager