<div dir="ltr"><br><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><span class="gmail-"><br>
</span>As Didi mentioned, we are looking for errors in the below files/dir.<br>
Do you mind to take a look and share the error message?<br>
<br>
/var/log/ovirt-engine/setup/*<br>
/var/opt/rh/rh-postgresql95/<wbr>lib/pgsql/data/pg_log<br>
/var/log/messages<br>
<span class="gmail-HOEnZb"><font color="#888888"><br><br></font></span></blockquote><div><br></div><div>Didi, Eli, can you please have a look?</div><div><br></div><div><br></div><div><br></div><div>Looking at the logs Marcos shared with me I see:</div><div><br></div><div><div><div>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', '</div><div>-u', 'engine_20180321150206', '-d', 'engine_20180321150206', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20180321150115-jjxbh3.log', '-c', 'apply'], rc=1</div><div>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'</div><div>, 'engine_20180321150206', '-d', 'engine_20180321150206', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20180321150115-jjxbh3.log', '-c', 'apply'] stdout:</div><div>Creating schema engine_20180321150206@localhost:5432/engine_20180321150206</div><div>Creating fresh schema</div><div>Creating tables...</div><div>Creating functions...</div><div><br></div><div>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'</div><div>, 'engine_20180321150206', '-d', 'engine_20180321150206', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20180321150115-jjxbh3.log', '-c', 'apply'] stderr:</div><div>psql:/usr/share/ovirt-engine/dbscripts/create_functions.sql:1095: ERROR: must be owner of function uuid_generate_v1</div><div>FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/create_functions.sql</div><div><br></div><div>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</div><div>.sql</div><div>2018-03-21 15:02:30,375-0400 DEBUG otopi.context context._executeMethod:143 method exception</div><div>Traceback (most recent call last):</div><div> File "/usr/lib/python2.7/site-packages/otopi/context.py", line 133, in _executeMethod</div><div> method['method']()</div><div> File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db/schema.py", line 430, in _misc</div><div> raise RuntimeError(_('Engine schema refresh failed'))</div><div>RuntimeError: Engine schema refresh failed</div><div>2018-03-21 15:02:30,376-0400 ERROR otopi.context context._executeMethod:152 Failed to execute stage 'Misc configuration': Engine schema refresh failed</div><div>2018-03-21 15:02:30,377-0400 DEBUG otopi.transaction transaction.abort:119 aborting 'DWH Engine database Transaction'</div><div>2018-03-21 15:02:30,377-0400 DEBUG otopi.transaction transaction.abort:119 aborting 'Database Transaction'</div></div></div><div><br></div><div><br></div><div> A few lines above in the log I see:</div><div><br></div><div><div>********* QUERY **********</div><div>CREATE OR REPLACE FUNCTION uuid_generate_v1()</div><div>RETURNS uuid STABLE</div><div>AS $PROCEDURE$</div><div>DECLARE</div><div> v_val BIGINT;</div><div> v_4_1_part CHAR(4);</div><div> v_4_2_part CHAR(4);</div><div> v_4_3_part CHAR(4);</div><div> v_8_part CHAR(8);</div><div> v_12_part CHAR(12);</div><div> v_4_part_max INT;</div><div>BEGIN</div><div> PERFORM setseed(random());</div><div><br></div><div> -- The only part we should use modulo is the 4 digit part, all the</div><div> -- rest are really big numbers (i.e 16^8 - 1 and 16^12 - 1)</div><div> -- The use of round(random() * 1000 is for getting a different id</div><div> -- for DC/Cluster in different installations</div><div> v_4_part_max = 65535;-- this is 16^4 -1</div><div><br></div><div> v_val := nextval('uuid_sequence');</div><div> v_4_1_part := lpad(to_hex((v_val + (round(random() * 1000))::BIGINT)), 4, '0');</div><div> v_4_2_part := lpad(to_hex((v_val + (round(random() * 1000))::BIGINT)), 4, '0');</div><div> v_4_3_part := lpad(to_hex((v_val + (round(random() * 1000))::BIGINT)), 4, '0');</div><div><br></div><div> -- generate this part using the clock timestamp</div><div> v_8_part := lpad(to_hex(cast(FLOOR(EXTRACT(EPOCH FROM clock_timestamp())) as bigint)), 8 , '0');</div><div><br></div><div> v_12_part := lpad(to_hex((v_val + (round(random() * 1000))::BIGINT)), 12, '0');</div><div><br></div><div> RETURN v_8_part || v_4_1_part || v_4_2_part || v_4_3_part || v_12_part;</div><div>END;$PROCEDURE$</div><div>LANGUAGE plpgsql;</div><div>**************************</div></div><div><br></div><div>The log is OVESETUP_CORE/generatedByVersion=str:'4.2.1.7'</div><div><br></div><div><br></div></div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
</div></div>