[Users] engine-setup fails on NFS ISO Domain

Tue Jun 19 16:26:24 UTC 2012

On Tue, Jun 19, 2012 at 3:39 AM, Juan Hernandez
<juan.hernandez at redhat.com> wrote:
> 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=7bc90021a34b6e03f50fecab9721cf904d2f8226
>
> 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
>
>

I replace that function in
/usr/share/ovirt-engine/dbscripts/inst_sp.sql with the one from
fix.sql and the engine-setup made it past the ISO Domain setup and
successfully completed.

Thanks!
- Trey