Re: [Users] engine-setup fails on NFS ISO Domain

On 06/19/2012 01:56 AM, Trey Dockendorf wrote: > > My first attempt installing engine failed on the ISO domain so I > skipped it and continued on.  I've now gone back to try and > troubleshoot this and so far this is what I'm getting... > > This is the failure log information > > > 2012-06-18 18:26:09::DEBUG::common_utils::335::root:: output = > Starting NFS services:  [  OK  ] > Starting NFS mountd: [  OK  ] > Starting NFS daemon: [  OK  ] > > 2012-06-18 18:26:09::DEBUG::common_utils::336::root:: stderr = > 2012-06-18 18:26:09::DEBUG::common_utils::337::root:: retcode = 0 > 2012-06-18 18:26:09::DEBUG::nfsutils::101::root:: Generating unique uuid > 2012-06-18 18:26:09::DEBUG::nfsutils::106::root:: creating iso domain > for /isodomain. uuid: 58ee5a2c-13dc-48bb-8fa2-ad4b8efefb9e > 2012-06-18 18:26:09::DEBUG::nfsutils::115::root:: creating empty files > 2012-06-18 18:26:09::DEBUG::nfsutils::122::root:: writing metadata > 2012-06-18 18:26:09::DEBUG::nfsutils::65::root:: generating metadata > 2012-06-18 18:26:09::DEBUG::nfsutils::77::root:: checksum of metadata > is 2030813e3089682bd753c1776ad88f9b13e406f7 > 2012-06-18 18:26:09::DEBUG::nfsutils::80::root:: writing metadata file > (/isodomain/58ee5a2c-13dc-48bb-8fa2-ad4b8efefb9e/dom_md/metadata) > 2012-06-18 18:26:10::DEBUG::nfsutils::128::root:: setting directories > &  files permissions to 36:36 > 2012-06-18 18:26:10::DEBUG::engine-setup::1614::root:: Adding iso domain > into DB > 2012-06-18 18:26:10::DEBUG::common_utils::350::root:: running sql > query 'select inst_add_iso_storage_domain > ('58ee5a2c-13dc-48bb-8fa2-ad4b8efefb9e', 'ISODomain', > 'dc-vmarchitect.tamu.edu:/isodomain', 0, 0)' on db server: > 'localhost'. > 2012-06-18 18:26:10::DEBUG::common_utils::286::root:: cmd = > /usr/bin/psql -h localhost -p 5432 -U engine -d engine -c "select > inst_add_iso_storage_domain ('58ee5a2c-13dc-48bb-8fa2-ad4b8efefb9e', > 'ISODomain', 'dc-vmarchitect.tamu.edu:/isodomain', 0, 0)" > 2012-06-18 18:26:10::DEBUG::common_utils::291::root:: output = > 2012-06-18 18:26:10::DEBUG::common_utils::292::root:: stderr = ERROR: > NUM:42883, DETAILS:function insertstorage_server_connections(character > varying, character varying, unknown, unknown, unknown, unknown, > integer, unknown, unknown, unknown) does not exist > > 2012-06-18 18:26:10::DEBUG::common_utils::293::root:: retcode = 1 > 2012-06-18 18:26:10::ERROR::engine-setup::1587::root:: Traceback (most > recent call last): >   File "/usr/bin/engine-setup", line 1582, in _configNfsShare >     _addIsoDomaintoDB(controller.CONF["sd_uuid"], > controller.CONF["ISO_DOMAIN_NAME"]) >   File "/usr/bin/engine-setup", line 1616, in _addIsoDomaintoDB >     utils.execRemoteSqlCommand(getDbUser(), getDbHostName(), > getDbPort(), basedefs.DB_NAME, sqlQuery, True, > output_messages.ERR_FAILED_INSERT_ISO_DOMAIN%(basedefs.DB_NAME)) >   File "/usr/share/ovirt-engine/scripts/common_utils.py", line 352, in > execRemoteSqlCommand >     return execExternalCmd(cmd, failOnError, errMsg) >   File "/usr/share/ovirt-engine/scripts/common_utils.py", line 296, in > execExternalCmd >     raise Exception(msg) > Exception: Failed inserting ISO domain into engine db > > 2012-06-18 18:26:10::DEBUG::setup_sequences::62::root:: Traceback > (most recent call last): >   File "/usr/share/ovirt-engine/scripts/setup_sequences.py", line 60, in > run >     function() >   File "/usr/bin/engine-setup", line 1588, in _configNfsShare >     raise Exception(output_messages.ERR_FAILED_CFG_NFS_SHARE) > Exception: Failed to configure NFS share on this host > > 2012-06-18 18:26:10::DEBUG::engine-setup::1814::root:: *** The > following params were used as user input: > 2012-06-18 18:26:10::DEBUG::engine-setup::1819::root:: > override-httpd-config: yes > 2012-06-18 18:26:10::DEBUG::engine-setup::1819::root:: http-port: 80 > 2012-06-18 18:26:10::DEBUG::engine-setup::1819::root:: https-port: 443 > 2012-06-18 18:26:10::DEBUG::engine-setup::1819::root:: mac-range: > 00:1A:4A:C2:4C:00-00:1A:4A:C2:4C:FF > 2012-06-18 18:26:10::DEBUG::engine-setup::1819::root:: host-fqdn: > dc-vmarchitect.tamu.edu > 2012-06-18 18:26:10::DEBUG::engine-setup::1819::root:: auth-pass: ******** > 2012-06-18 18:26:10::DEBUG::engine-setup::1819::root:: org-name: > Academy for Advanced Telecommunications and Learning Technology > 2012-06-18 18:26:10::DEBUG::engine-setup::1819::root:: default-dc-type: > ISCSI > 2012-06-18 18:26:10::DEBUG::engine-setup::1819::root:: db-remote-install: > local > 2012-06-18 18:26:10::DEBUG::engine-setup::1819::root:: db-host: localhost > 2012-06-18 18:26:10::DEBUG::engine-setup::1819::root:: db-local-pass: > ******** > 2012-06-18 18:26:10::DEBUG::engine-setup::1819::root:: nfs-mp: /isodomain > 2012-06-18 18:26:10::DEBUG::engine-setup::1819::root:: > iso-domain-name: ISODomain > 2012-06-18 18:26:10::DEBUG::engine-setup::1819::root:: config-nfs: yes > 2012-06-18 18:26:10::DEBUG::engine-setup::1819::root:: override-iptables: > yes > 2012-06-18 18:26:10::ERROR::engine-setup::2447::root:: Traceback (most > recent call last): >   File "/usr/bin/engine-setup", line 2441, in<module> >     main(confFile) >   File "/usr/bin/engine-setup", line 2230, in main >     runSequences() >   File "/usr/bin/engine-setup", line 2176, in runSequences >     controller.runAllSequences() >   File "/usr/share/ovirt-engine/scripts/setup_controller.py", line 54, > in runAllSequences >     sequence.run() >   File "/usr/share/ovirt-engine/scripts/setup_sequences.py", line 154, in > run >     step.run() >   File "/usr/share/ovirt-engine/scripts/setup_sequences.py", line 60, in > run >     function() >   File "/usr/bin/engine-setup", line 1588, in _configNfsShare >     raise Exception(output_messages.ERR_FAILED_CFG_NFS_SHARE) > Exception: Failed to configure NFS share on this host > > > I tried executing the SQL query and get this error > > engine=>  select inst_add_iso_storage_domain > ('58ee5a2c-13dc-48bb-8fa2-ad4b8efefb9e', 'ISODomain', > 'dc-vmarchitect.tamu.edu:/isodomain', 0, 0); > ERROR:  NUM:42883, DETAILS:function > insertstorage_server_connections(character varying, character varying, > unknown, unknown, unknown, unknown, integer, unknown, unknown, > unknown) does not exist > > > Executing the following shows that the function exists: > > psql -h localhost -p 5432 -U engine -d engine -c "select * from > pg_proc where proname='insertstorage_server_connections'" shows that > function. > > Any other troubleshooting steps to help figure out what's going wrong? We used to have a bug related to that stored procedure that was fixed in this change: http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=commit;h=7bc90021a34b... The better solution would be to use a newer version, but meanwhile, if you need a workaround, you can replace the inst_add_iso_storage_domain stored procedure with the one in the attached file: # psql -U engine engine=> \i fix.sql CREATE FUNCTION engine=> \q