ovirt do not start postgresql
This is a multi-part message in MIME format. --------------DEBED42361E0DEFD42D4DAC9 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable good morning list, can someone tell me how I can solve this error? [ ERROR ] Failed to execute stage 'Misc configuration': Failed to start=20 service 'rh-postgresql95-postgresql' [ INFO=C2=A0 ] Stage: Clean up =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Log file is locat= ed at=20 /var/log/ovirt-engine/setup/ovirt-engine-setup-20180321103734-b7svhc.log [ INFO=C2=A0 ] Generating answer file=20 '/var/lib/ovirt-engine/setup/answers/20180321103949-setup.conf' [ INFO=C2=A0 ] Stage: Pre-termination [ INFO=C2=A0 ] Stage: Termination [ ERROR ] Execution of setup failed UCIENCIA 2018: III Conferencia Cient=C3=ADfica Internacional de la Universidad de las Ciencias Inform=C3=A1ticas. =0ADel 24-26 de septiembre, 2018 http://uciencia.uci.cu http://eventos.uci.cu=0A --------------DEBED42361E0DEFD42D4DAC9 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html> <head> <meta http-equiv=3D"content-type" content=3D"text/html; charset=3Dutf= -8"> </head> <body text=3D"#000000" bgcolor=3D"#FFFFFF"> <p><span id=3D"result_box" class=3D"" lang=3D"en"><span class=3D"">go= od morning list, can someone tell me how I can solve this error?</= span></span></p> <p>[ ERROR ] Failed to execute stage 'Misc configuration': Failed to start service 'rh-postgresql95-postgresql'<br> [ INFO=C2=A0 ] Stage: Clean up<br> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Log file is = located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20180321103734-b7svh= c.log<br> [ INFO=C2=A0 ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20180321103949-setup.conf'<br> [ INFO=C2=A0 ] Stage: Pre-termination<br> [ INFO=C2=A0 ] Stage: Termination<br> [ ERROR ] Execution of setup failed<br> <br> </p> <br>= <html>=0A<body>=0A<div>=0A<img src=3D"https://www.uci.cu/sites/default/files/uciencia.jpg" >=0A</div>=0A</body>=0A</html>=0A <br>= </body> </html> --------------DEBED42361E0DEFD42D4DAC9--
On Wed, Mar 21, 2018 at 4:32 PM, Marcos Michel Martinez Perez < mmartinezp@uci.cu> wrote:
good morning list, can someone tell me how I can solve this error?
[ ERROR ] Failed to execute stage 'Misc configuration': Failed to start service 'rh-postgresql95-postgresql'
Please check/share relevant logs, including probably: /var/log/ovirt-engine/setup/* /var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log /var/log/messages Thanks, -- Didi
previous error [ ERROR ] schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/create_functions.sql UCIENCIA 2018: III Conferencia Científica Internacional de la Universidad de las Ciencias Informáticas. Del 24-26 de septiembre, 2018 http://uciencia.uci.cu http://eventos.uci.cu
On Wed, Mar 21, 2018 at 5:12 PM, Marcos Michel Martinez Perez <mmartinezp@uci.cu> wrote:
previous error
[ ERROR ] schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/create_functions.sql
Thanks. Please share the entire logs. You can use some file sharing service and add a a link to it. Best regards,
UCIENCIA 2018: III Conferencia Científica Internacional de la Universidad de las Ciencias Informáticas. Del 24-26 de septiembre, 2018 http://uciencia.uci.cu http://eventos.uci.cu
-- Didi
This is a multi-part message in MIME format. --------------7C31C842024E61DB70A50584 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable After performing the configuration of ovirt, that is, executing the=20 engine-config, and accepting or not the parameters that it asks for, the=20 wizard starts to make a series of configurations and then it throws me=20 this error. [ INFO=C2=A0 ] Stage: Transaction setup [ INFO=C2=A0 ] Stopping engine service [ INFO=C2=A0 ] Stopping ovirt-fence-kdump-listener service [ INFO=C2=A0 ] Stopping dwh service [ INFO=C2=A0 ] Stopping Image I/O Proxy service [ INFO=C2=A0 ] Stopping vmconsole-proxy service [ INFO=C2=A0 ] Stopping websocket-proxy service [ INFO=C2=A0 ] Stage: Misc configuration [ INFO=C2=A0 ] Stage: Package installation [ INFO=C2=A0 ] Stage: Misc configuration [ INFO=C2=A0 ] Upgrading CA [ INFO=C2=A0 ] Creating PostgreSQL 'engine' database [ INFO=C2=A0 ] Configuring PostgreSQL [ INFO=C2=A0 ] Creating PostgreSQL 'ovirt_engine_history' database [ INFO=C2=A0 ] Configuring PostgreSQL [ INFO=C2=A0 ] Creating CA [ INFO=C2=A0 ] Creating/refreshing DWH database schema [ INFO=C2=A0 ] Configuring Image I/O Proxy [ INFO=C2=A0 ] Setting up ovirt-vmconsole proxy helper PKI artifacts [ INFO=C2=A0 ] Setting up ovirt-vmconsole SSH PKI artifacts [ INFO=C2=A0 ] Configuring WebSocket Proxy [ INFO=C2=A0 ] Creating/refreshing Engine database schema [ ERROR ] schema.sh: FATAL: Cannot execute sql command:=20 --file=3D/usr/share/ovirt-engine/dbscripts/create_functions.sql [ ERROR ] Failed to execute stage 'Misc configuration': Engine schema=20 refresh failed [ INFO=C2=A0 ] Rolling back DWH database schema [ INFO=C2=A0 ] Clearing DWH database ovirt_engine_history_20180321121409 [ INFO=C2=A0 ] Rolling back database schema [ INFO=C2=A0 ] Clearing Engine database engine_20180321121404 [ INFO=C2=A0 ] Stage: Clean up =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Log file is locat= ed at=20 /var/log/ovirt-engine/setup/ovirt-engine-setup-20180321121319-mvrexc.log [ INFO=C2=A0 ] Generating answer file=20 '/var/lib/ovirt-engine/setup/answers/20180321121431-setup.conf' [ INFO=C2=A0 ] Stage: Pre-termination [ INFO=C2=A0 ] Stage: Termination [ ERROR ] Execution of setup failed UCIENCIA 2018: III Conferencia Cient=C3=ADfica Internacional de la Universidad de las Ciencias Inform=C3=A1ticas. =0ADel 24-26 de septiembre, 2018 http://uciencia.uci.cu http://eventos.uci.cu=0A --------------7C31C842024E61DB70A50584 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dutf= -8"> </head> <body text=3D"#000000" bgcolor=3D"#FFFFFF"> <p><span id=3D"result_box" class=3D"" lang=3D"en"><span class=3D"">Af= ter performing the configuration of ovirt, that is, executing the engine-config, and accepting or not the parameters that it asks for, the wizard starts to make a series of configurations and then it throws me this error.</span></span></p> <p>[ INFO=C2=A0 ] Stage: Transaction setup<br> [ INFO=C2=A0 ] Stopping engine service<br> [ INFO=C2=A0 ] Stopping ovirt-fence-kdump-listener service<br> [ INFO=C2=A0 ] Stopping dwh service<br> [ INFO=C2=A0 ] Stopping Image I/O Proxy service<br> [ INFO=C2=A0 ] Stopping vmconsole-proxy service<br> [ INFO=C2=A0 ] Stopping websocket-proxy service<br> [ INFO=C2=A0 ] Stage: Misc configuration<br> [ INFO=C2=A0 ] Stage: Package installation<br> [ INFO=C2=A0 ] Stage: Misc configuration<br> [ INFO=C2=A0 ] Upgrading CA<br> [ INFO=C2=A0 ] Creating PostgreSQL 'engine' database<br> [ INFO=C2=A0 ] Configuring PostgreSQL<br> [ INFO=C2=A0 ] Creating PostgreSQL 'ovirt_engine_history' database<= br> [ INFO=C2=A0 ] Configuring PostgreSQL<br> [ INFO=C2=A0 ] Creating CA<br> [ INFO=C2=A0 ] Creating/refreshing DWH database schema<br> [ INFO=C2=A0 ] Configuring Image I/O Proxy<br> [ INFO=C2=A0 ] Setting up ovirt-vmconsole proxy helper PKI artifact= s<br> [ INFO=C2=A0 ] Setting up ovirt-vmconsole SSH PKI artifacts<br> [ INFO=C2=A0 ] Configuring WebSocket Proxy<br> [ INFO=C2=A0 ] Creating/refreshing Engine database schema<br> [ ERROR ] schema.sh: FATAL: Cannot execute sql command: --file=3D/usr/share/ovirt-engine/dbscripts/create_functions.sql<br> [ ERROR ] Failed to execute stage 'Misc configuration': Engine schema refresh failed<br> [ INFO=C2=A0 ] Rolling back DWH database schema<br> [ INFO=C2=A0 ] Clearing DWH database ovirt_engine_history_20180321121409<br> [ INFO=C2=A0 ] Rolling back database schema<br> [ INFO=C2=A0 ] Clearing Engine database engine_20180321121404<br> [ INFO=C2=A0 ] Stage: Clean up<br> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Log file is = located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20180321121319-mvrex= c.log<br> [ INFO=C2=A0 ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20180321121431-setup.conf'<br> [ INFO=C2=A0 ] Stage: Pre-termination<br> [ INFO=C2=A0 ] Stage: Termination<br> [ ERROR ] Execution of setup failed<br> <br> </p> <br>= <html>=0A<body>=0A<div>=0A<img src=3D"https://www.uci.cu/sites/default/files/uciencia.jpg" >=0A</div>=0A</body>=0A</html>=0A <br>= </body> </html> --------------7C31C842024E61DB70A50584--
Il mer 21 mar 2018, 18:25 Marcos Michel Martinez Perez <mmartinezp@uci.cu> ha scritto:
After performing the configuration of ovirt, that is, executing the engine-config, and accepting or not the parameters that it asks for, the wizard starts to make a series of configurations and then it throws me this error.
[ INFO ] Stage: Transaction setup [ INFO ] Stopping engine service [ INFO ] Stopping ovirt-fence-kdump-listener service [ INFO ] Stopping dwh service [ INFO ] Stopping Image I/O Proxy service [ INFO ] Stopping vmconsole-proxy service [ INFO ] Stopping websocket-proxy service [ INFO ] Stage: Misc configuration [ INFO ] Stage: Package installation [ INFO ] Stage: Misc configuration [ INFO ] Upgrading CA [ INFO ] Creating PostgreSQL 'engine' database [ INFO ] Configuring PostgreSQL [ INFO ] Creating PostgreSQL 'ovirt_engine_history' database [ INFO ] Configuring PostgreSQL [ INFO ] Creating CA [ INFO ] Creating/refreshing DWH database schema [ INFO ] Configuring Image I/O Proxy [ INFO ] Setting up ovirt-vmconsole proxy helper PKI artifacts [ INFO ] Setting up ovirt-vmconsole SSH PKI artifacts [ INFO ] Configuring WebSocket Proxy [ INFO ] Creating/refreshing Engine database schema [ ERROR ] schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/create_functions.sql [ ERROR ] Failed to execute stage 'Misc configuration': Engine schema refresh failed [ INFO ] Rolling back DWH database schema [ INFO ] Clearing DWH database ovirt_engine_history_20180321121409 [ INFO ] Rolling back database schema [ INFO ] Clearing Engine database engine_20180321121404 [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20180321121319-mvrexc.log
Can you please share this log? [ INFO ] Generating answer file
'/var/lib/ovirt-engine/setup/answers/20180321121431-setup.conf' [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ ERROR ] Execution of setup failed
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
# action=setup [environment:default] OVESETUP_DIALOG/confirmSettings=bool:True OVESETUP_CONFIG/applicationMode=str:both OVESETUP_CONFIG/remoteEngineSetupStyle=none:None OVESETUP_CONFIG/sanWipeAfterDelete=bool:False OVESETUP_CONFIG/storageIsLocal=bool:False OVESETUP_CONFIG/firewallManager=none:None OVESETUP_CONFIG/remoteEngineHostRootPassword=none:None OVESETUP_CONFIG/firewallChangesReview=none:None OVESETUP_CONFIG/updateFirewall=bool:False OVESETUP_CONFIG/remoteEngineHostSshPort=none:None OVESETUP_CONFIG/fqdn=str:ovirt.sige.uci.cu OVESETUP_CONFIG/storageType=none:None OSETUP_RPMDISTRO/requireRollback=none:None OSETUP_RPMDISTRO/enableUpgrade=none:None OVESETUP_PROVISIONING/postgresProvisioningEnabled=bool:True OVESETUP_APACHE/configureRootRedirection=bool:True OVESETUP_APACHE/configureSsl=bool:True OVESETUP_DB/secured=bool:False OVESETUP_DB/fixDbConfiguration=none:None OVESETUP_DB/user=str:engine_20180321121404 OVESETUP_DB/dumper=str:pg_custom OVESETUP_DB/database=str:engine_20180321121404 OVESETUP_DB/fixDbViolations=none:None OVESETUP_DB/engineVacuumFull=none:None OVESETUP_DB/host=str:localhost OVESETUP_DB/port=int:5432 OVESETUP_DB/filter=none:None OVESETUP_DB/restoreJobs=int:2 OVESETUP_DB/securedHostValidation=bool:False OVESETUP_ENGINE_CORE/enable=bool:True OVESETUP_CORE/engineStop=none:None OVESETUP_SYSTEM/memCheckEnabled=bool:True OVESETUP_SYSTEM/nfsConfigEnabled=none:None OVESETUP_PKI/organization=str:sige.uci.cu OVESETUP_PKI/renew=none:None OVESETUP_CONFIG/isoDomainName=none:None OVESETUP_CONFIG/engineHeapMax=str:1024M OVESETUP_CONFIG/ignoreVdsgroupInNotifier=none:None OVESETUP_CONFIG/adminPassword=str:Ins03dmesa OVESETUP_CONFIG/isoDomainACL=none:None OVESETUP_CONFIG/isoDomainMountPoint=none:None OVESETUP_ENGINE_CONFIG/fqdn=str:ovirt.sige.uci.cu OVESETUP_CONFIG/engineDbBackupDir=str:/var/lib/ovirt-engine/backups OVESETUP_CONFIG/engineHeapMin=str:1024M OVESETUP_OVN/ovirtProviderOvn=bool:True OVESETUP_OVN/ovirtProviderOvnUser=str:admin@internal OVESETUP_OVN/ovirtProviderOvnPassword=str:Ins03dmesa OVESETUP_CONFIG/websocketProxyConfig=bool:True OVESETUP_DWH_CORE/enable=bool:True OVESETUP_DWH_CONFIG/scale=str:1 OVESETUP_DWH_CONFIG/dwhDbBackupDir=str:/var/lib/ovirt-engine-dwh/backups OVESETUP_DWH_DB/secured=bool:False OVESETUP_DWH_DB/restoreBackupLate=bool:True OVESETUP_DWH_DB/disconnectExistingDwh=none:None OVESETUP_DWH_DB/host=str:localhost OVESETUP_DWH_DB/user=str:ovirt_engine_history_20180321121409 OVESETUP_DWH_DB/dumper=str:pg_custom OVESETUP_DWH_DB/database=str:ovirt_engine_history_20180321121409 OVESETUP_DWH_DB/performBackup=none:None OVESETUP_DWH_DB/port=int:5432 OVESETUP_DWH_DB/filter=none:None OVESETUP_DWH_DB/restoreJobs=int:2 OVESETUP_DWH_DB/securedHostValidation=bool:False OVESETUP_DB/dwhVacuumFull=none:None OVESETUP_DWH_PROVISIONING/postgresProvisioningEnabled=bool:True OVESETUP_CONFIG/imageioProxyConfig=bool:True OVESETUP_VMCONSOLE_PROXY_CONFIG/vmconsoleProxyConfig=bool:True UCIENCIA 2018: III Conferencia Científica Internacional de la Universidad de las Ciencias Informáticas. Del 24-26 de septiembre, 2018 http://uciencia.uci.cu http://eventos.uci.cu
Hi Marcos, On Wed, Mar 21, 2018 at 2:29 PM, Marcos Michel Martinez Perez <mmartinezp@uci.cu> wrote:
# action=setup [environment:default] OVESETUP_DIALOG/confirmSettings=bool:True OVESETUP_CONFIG/applicationMode=str:both OVESETUP_CONFIG/remoteEngineSetupStyle=none:None OVESETUP_CONFIG/sanWipeAfterDelete=bool:False OVESETUP_CONFIG/storageIsLocal=bool:False OVESETUP_CONFIG/firewallManager=none:None OVESETUP_CONFIG/remoteEngineHostRootPassword=none:None OVESETUP_CONFIG/firewallChangesReview=none:None OVESETUP_CONFIG/updateFirewall=bool:False OVESETUP_CONFIG/remoteEngineHostSshPort=none:None OVESETUP_CONFIG/fqdn=str:ovirt.sige.uci.cu OVESETUP_CONFIG/storageType=none:None OSETUP_RPMDISTRO/requireRollback=none:None OSETUP_RPMDISTRO/enableUpgrade=none:None OVESETUP_PROVISIONING/postgresProvisioningEnabled=bool:True OVESETUP_APACHE/configureRootRedirection=bool:True OVESETUP_APACHE/configureSsl=bool:True OVESETUP_DB/secured=bool:False OVESETUP_DB/fixDbConfiguration=none:None OVESETUP_DB/user=str:engine_20180321121404 OVESETUP_DB/dumper=str:pg_custom OVESETUP_DB/database=str:engine_20180321121404 OVESETUP_DB/fixDbViolations=none:None OVESETUP_DB/engineVacuumFull=none:None OVESETUP_DB/host=str:localhost OVESETUP_DB/port=int:5432 OVESETUP_DB/filter=none:None OVESETUP_DB/restoreJobs=int:2 OVESETUP_DB/securedHostValidation=bool:False OVESETUP_ENGINE_CORE/enable=bool:True OVESETUP_CORE/engineStop=none:None OVESETUP_SYSTEM/memCheckEnabled=bool:True OVESETUP_SYSTEM/nfsConfigEnabled=none:None OVESETUP_PKI/organization=str:sige.uci.cu OVESETUP_PKI/renew=none:None OVESETUP_CONFIG/isoDomainName=none:None OVESETUP_CONFIG/engineHeapMax=str:1024M OVESETUP_CONFIG/ignoreVdsgroupInNotifier=none:None OVESETUP_CONFIG/adminPassword=str:Ins03dmesa OVESETUP_CONFIG/isoDomainACL=none:None OVESETUP_CONFIG/isoDomainMountPoint=none:None OVESETUP_ENGINE_CONFIG/fqdn=str:ovirt.sige.uci.cu OVESETUP_CONFIG/engineDbBackupDir=str:/var/lib/ovirt-engine/backups OVESETUP_CONFIG/engineHeapMin=str:1024M OVESETUP_OVN/ovirtProviderOvn=bool:True OVESETUP_OVN/ovirtProviderOvnUser=str:admin@internal OVESETUP_OVN/ovirtProviderOvnPassword=str:Ins03dmesa OVESETUP_CONFIG/websocketProxyConfig=bool:True OVESETUP_DWH_CORE/enable=bool:True OVESETUP_DWH_CONFIG/scale=str:1 OVESETUP_DWH_CONFIG/dwhDbBackupDir=str:/var/lib/ovirt-engine-dwh/backups OVESETUP_DWH_DB/secured=bool:False OVESETUP_DWH_DB/restoreBackupLate=bool:True OVESETUP_DWH_DB/disconnectExistingDwh=none:None OVESETUP_DWH_DB/host=str:localhost OVESETUP_DWH_DB/user=str:ovirt_engine_history_20180321121409 OVESETUP_DWH_DB/dumper=str:pg_custom OVESETUP_DWH_DB/database=str:ovirt_engine_history_20180321121409 OVESETUP_DWH_DB/performBackup=none:None OVESETUP_DWH_DB/port=int:5432 OVESETUP_DWH_DB/filter=none:None OVESETUP_DWH_DB/restoreJobs=int:2 OVESETUP_DWH_DB/securedHostValidation=bool:False OVESETUP_DB/dwhVacuumFull=none:None OVESETUP_DWH_PROVISIONING/postgresProvisioningEnabled=bool:True OVESETUP_CONFIG/imageioProxyConfig=bool:True OVESETUP_VMCONSOLE_PROXY_CONFIG/vmconsoleProxyConfig=bool:True
UCIENCIA 2018: III Conferencia Científica Internacional de la Universidad de las Ciencias Informáticas. Del 24-26 de septiembre, 2018 http://uciencia.uci.cu http://eventos.uci.cu _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
As Didi mentioned, we are looking for errors in the below files/dir. Do you mind to take a look and share the error message? /var/log/ovirt-engine/setup/* /var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log /var/log/messages -- Cheers Douglas
As Didi mentioned, we are looking for errors in the below files/dir. Do you mind to take a look and share the error message?
/var/log/ovirt-engine/setup/* /var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log /var/log/messages
Didi, Eli, can you please have a look? Looking at the logs Marcos shared with me I see: 2018-03-21 15:02:30,373-0400 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.executeRaw:863 execute-result: ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', ' -u', 'engine_20180321150206', '-d', 'engine_20180321150206', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20180321150115-jjxbh3.log', '-c', 'apply'], rc=1 2018-03-21 15:02:30,374-0400 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.execute:921 execute-output: ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u' , 'engine_20180321150206', '-d', 'engine_20180321150206', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20180321150115-jjxbh3.log', '-c', 'apply'] stdout: Creating schema engine_20180321150206@localhost:5432/engine_20180321150206 Creating fresh schema Creating tables... Creating functions... 2018-03-21 15:02:30,374-0400 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.execute:926 execute-output: ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u' , 'engine_20180321150206', '-d', 'engine_20180321150206', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20180321150115-jjxbh3.log', '-c', 'apply'] stderr: psql:/usr/share/ovirt-engine/dbscripts/create_functions.sql:1095: ERROR: must be owner of function uuid_generate_v1 FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/create_functions.sql 2018-03-21 15:02:30,374-0400 ERROR otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema schema._misc:428 schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/create_functions .sql 2018-03-21 15:02:30,375-0400 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/schema.py", line 430, in _misc raise RuntimeError(_('Engine schema refresh failed')) RuntimeError: Engine schema refresh failed 2018-03-21 15:02:30,376-0400 ERROR otopi.context context._executeMethod:152 Failed to execute stage 'Misc configuration': Engine schema refresh failed 2018-03-21 15:02:30,377-0400 DEBUG otopi.transaction transaction.abort:119 aborting 'DWH Engine database Transaction' 2018-03-21 15:02:30,377-0400 DEBUG otopi.transaction transaction.abort:119 aborting 'Database Transaction' A few lines above in the log I see: ********* QUERY ********** CREATE OR REPLACE FUNCTION uuid_generate_v1() RETURNS uuid STABLE AS $PROCEDURE$ DECLARE v_val BIGINT; v_4_1_part CHAR(4); v_4_2_part CHAR(4); v_4_3_part CHAR(4); v_8_part CHAR(8); v_12_part CHAR(12); v_4_part_max INT; BEGIN PERFORM setseed(random()); -- The only part we should use modulo is the 4 digit part, all the -- rest are really big numbers (i.e 16^8 - 1 and 16^12 - 1) -- The use of round(random() * 1000 is for getting a different id -- for DC/Cluster in different installations v_4_part_max = 65535;-- this is 16^4 -1 v_val := nextval('uuid_sequence'); v_4_1_part := lpad(to_hex((v_val + (round(random() * 1000))::BIGINT)), 4, '0'); v_4_2_part := lpad(to_hex((v_val + (round(random() * 1000))::BIGINT)), 4, '0'); v_4_3_part := lpad(to_hex((v_val + (round(random() * 1000))::BIGINT)), 4, '0'); -- generate this part using the clock timestamp v_8_part := lpad(to_hex(cast(FLOOR(EXTRACT(EPOCH FROM clock_timestamp())) as bigint)), 8 , '0'); v_12_part := lpad(to_hex((v_val + (round(random() * 1000))::BIGINT)), 12, '0'); RETURN v_8_part || v_4_1_part || v_4_2_part || v_4_3_part || v_12_part; END;$PROCEDURE$ LANGUAGE plpgsql; ************************** The log is OVESETUP_CORE/generatedByVersion=str:'4.2.1.7'
Hi all, It's very hard to debug this without getting a full picture of the state of the machine, including logs, versions, flow, etc. Some comments inside. On Thu, Mar 22, 2018 at 10:12 AM, Sandro Bonazzola <sbonazzo@redhat.com> wrote:
As Didi mentioned, we are looking for errors in the below files/dir. Do you mind to take a look and share the error message?
/var/log/ovirt-engine/setup/* /var/opt/rh/rh-postgresql95/lib/pgsql/data/pg_log /var/log/messages
Didi, Eli, can you please have a look?
Looking at the logs Marcos shared with me I see:
2018-03-21 15:02:30,373-0400 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.executeRaw:863 execute-result: ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', ' -u', 'engine_20180321150206', '-d', 'engine_20180321150206', '-l',
The fact that your database name is 'engine_20180321150206' most likely means you have/had some problem, see also: https://bugzilla.redhat.com/show_bug.cgi?id=1259782 Please check if you have other databases on your machine, why this one was created, etc. Some information to understand this can be found in the setup logs.
'/var/log/ovirt-engine/setup/ovirt-engine-setup-20180321150115-jjxbh3.log', '-c', 'apply'], rc=1 2018-03-21 15:02:30,374-0400 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.execute:921 execute-output: ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u' , 'engine_20180321150206', '-d', 'engine_20180321150206', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20180321150115-jjxbh3.log', '-c', 'apply'] stdout: Creating schema engine_20180321150206@localhost:5432/engine_20180321150206 Creating fresh schema Creating tables... Creating functions...
2018-03-21 15:02:30,374-0400 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.execute:926 execute-output: ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u' , 'engine_20180321150206', '-d', 'engine_20180321150206', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20180321150115-jjxbh3.log', '-c', 'apply'] stderr: psql:/usr/share/ovirt-engine/dbscripts/create_functions.sql:1095: ERROR: must be owner of function uuid_generate_v1 FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/create_functions.sql
2018-03-21 15:02:30,374-0400 ERROR otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema schema._misc:428 schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/create_functions .sql 2018-03-21 15:02:30,375-0400 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/schema.py", line 430, in _misc raise RuntimeError(_('Engine schema refresh failed')) RuntimeError: Engine schema refresh failed 2018-03-21 15:02:30,376-0400 ERROR otopi.context context._executeMethod:152 Failed to execute stage 'Misc configuration': Engine schema refresh failed 2018-03-21 15:02:30,377-0400 DEBUG otopi.transaction transaction.abort:119 aborting 'DWH Engine database Transaction' 2018-03-21 15:02:30,377-0400 DEBUG otopi.transaction transaction.abort:119 aborting 'Database Transaction'
A few lines above in the log I see:
********* QUERY ********** CREATE OR REPLACE FUNCTION uuid_generate_v1() RETURNS uuid STABLE AS $PROCEDURE$ DECLARE v_val BIGINT; v_4_1_part CHAR(4); v_4_2_part CHAR(4); v_4_3_part CHAR(4); v_8_part CHAR(8); v_12_part CHAR(12); v_4_part_max INT; BEGIN PERFORM setseed(random());
-- The only part we should use modulo is the 4 digit part, all the -- rest are really big numbers (i.e 16^8 - 1 and 16^12 - 1) -- The use of round(random() * 1000 is for getting a different id -- for DC/Cluster in different installations v_4_part_max = 65535;-- this is 16^4 -1
v_val := nextval('uuid_sequence'); v_4_1_part := lpad(to_hex((v_val + (round(random() * 1000))::BIGINT)), 4, '0'); v_4_2_part := lpad(to_hex((v_val + (round(random() * 1000))::BIGINT)), 4, '0'); v_4_3_part := lpad(to_hex((v_val + (round(random() * 1000))::BIGINT)), 4, '0');
-- generate this part using the clock timestamp v_8_part := lpad(to_hex(cast(FLOOR(EXTRACT(EPOCH FROM clock_timestamp())) as bigint)), 8 , '0');
v_12_part := lpad(to_hex((v_val + (round(random() * 1000))::BIGINT)), 12, '0');
RETURN v_8_part || v_4_1_part || v_4_2_part || v_4_3_part || v_12_part; END;$PROCEDURE$ LANGUAGE plpgsql; **************************
This function was removed by: https://gerrit.ovirt.org/#/c/84832/ which should be included in 4.2.1 : https://bugzilla.redhat.com/show_bug.cgi?id=1515635
The log is OVESETUP_CORE/generatedByVersion=str:'4.2.1.7'
So not sure how you still have it. I suggest to open a bug in bugzilla and attach a sosreport of the machine. You can use this link: https://bugzilla.redhat.com/enter_bug.cgi?alias=&assigned_to=sbonazzo%40redhat.com&attach_text=&blocked=&bug_file_loc=http%3A%2F%2F&bug_severity=unspecified&bug_status=NEW&cf_build_id=&cf_category=---&cf_clone_of=&cf_cloudforms_team=---&cf_compliance_control_group=---&cf_compliance_level=---&cf_crm=&cf_cust_facing=---&cf_devel_whiteboard=&cf_docs_score=&cf_documentation_action=---&cf_environment=&cf_internal_whiteboard=&cf_mount_type=---&cf_ovirt_team=Integration&cf_pm_score=&cf_regression_status=---&cf_story_points=---&cf_subsystem_team=---&cf_type=Bug&comment=Description%20of%20problem%3A%0D%0A%0D%0A%0D%0AVersion-Release%20number%20of%20selected%20component%20%28if%20applicable%29%3A%0D%0A%0D%0A%0D%0AHow%20reproducible%3A%0D%0A%0D%0A%0D%0ASteps%20to%20Reproduce%3A%0D%0A1.%0D%0A2.%0D%0A3.%0D%0A%0D%0AActual%20results%3A%0D%0A%0D%0A%0D%0AExpected%20results%3A%0D%0A%0D%0A%0D%0AAdditional%20info%3A%0D%0A&component=Setup.Engine&contenttypeentry=&contenttypemethod=autodetect&contenttypeselection=text%2Fplain&data=&deadline=&defined_cf_layered_products=&defined_cf_partner=&defined_groups=1&defined_rh_sub_component=0&dependson=&description=&docs_contact=&estimated_time=&external_bug_id_1=&external_id_1=0&flag_type-155=X&flag_type-16=X&flag_type-415=X&flag_type-817=X&flag_type-818=X&flag_type-819=X&flag_type-820=X&flag_type-821=X&flag_type-823=X&form_name=enter_bug&keywords=&maketemplate=Remember%20values%20as%20bookmarkable%20template&op_sys=Unspecified&priority=unspecified&product=ovirt-engine&qa_contact=pstehlik%40redhat.com&rep_platform=Unspecified&requestee_type-155=&requestee_type-16=&rh_sub_component=&short_desc=&status_whiteboard=&target_milestone=---&target_release=---&version=4.2.0 My guess for the reason of the failure: You updated the setup packages to 4.2.1.7, but the engine itself failed to update - either because you ran engine-setup with '--offline' or because you removed the repos, they were unavailable, something like that. Even if I am right, I'd still try to understand why it tries to use database engine_20180321150206, as there might be some other problems. Best regards, -- Didi
participants (4)
-
Douglas Landgraf -
Marcos Michel Martinez Perez -
Sandro Bonazzola -
Yedidyah Bar David