[Users] engine-setup fails on NFS ISO Domain
Juan Hernandez
juan.hernandez at redhat.com
Tue Jun 19 08:39:30 UTC 2012
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: fix.sql
Type: text/x-sql
Size: 1035 bytes
Desc: not available
URL: <http://lists.ovirt.org/pipermail/users/attachments/20120619/a87ec8ca/attachment-0001.bin>
More information about the Users
mailing list