10:32 a.m.
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--
11:08 a.m.
On Wed, Mar 21, 2018 at 4:32 PM, Marcos Michel Martinez Perez <
mmartinezp(a)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
11:12 a.m.
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
11:22 a.m.
On Wed, Mar 21, 2018 at 5:12 PM, Marcos Michel Martinez Perez
<mmartinezp(a)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
1:24 p.m.
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--
2:19 p.m.
Il mer 21 mar 2018, 18:25 Marcos Michel Martinez Perez <mmartinezp(a)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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
2:29 p.m.
# 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
5:14 p.m.
Hi Marcos,
On Wed, Mar 21, 2018 at 2:29 PM, Marcos Michel Martinez Perez
<mmartinezp(a)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(a)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
4:12 a.m.
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'
4:40 a.m.
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(a)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...
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
2467
days inactive
2468
days old
9 comments
4 participants
participants (4)
-
Douglas Landgraf -
Marcos Michel Martinez Perez -
Sandro Bonazzola -
Yedidyah Bar David