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