[Engine-devel] function insertstorage_domain_static(uuid, ...) does not exist

Thu Mar 7 12:00:51 UTC 2013

On 03/07/2013 12:43 PM, Barak Azulay wrote:
> Shu,
>
> A few notes.
>
> 1 - you are tring to create iso domain on /
>      'select   ('ab22b419-6381-4f0a-8b46-aa72c81edbb5', 'ISO_DOMAIN', 'ead292ee-14dd-40f9-b06b-f2250f7594a9', 'localhost.localdomain:/ISO', 0, 0)'
> 2 - your host name is localhost.localdomain
>
> But those doesn't look like the real problem here.
>
> I assume you are running it on F18 ?
>
> Can we get the full installation log?
>
> Thanks
> Barak

Commit 5ca1ec0337d921f1057321da2688ad2a014b8ffb added a parameter to the 
stored procedure, but engine-setup calls  inst_add_iso_storage_domain 
(in inst_sp.sql) which in turn calls insertstorage_domain_static, and 
that call hasn't been updated.

>
>
>
>
>
>
>
> ----- Original Message -----
>> From: "Shu Ming" <shuming at linux.vnet.ibm.com>
>> To: engine-devel at ovirt.org, "Doron Fediuck" <dfediuck at redhat.com>
>> Sent: Thursday, March 7, 2013 7:39:29 AM
>> Subject: Re: [Engine-devel] function insertstorage_domain_static(uuid, ...) does not exist
>>
>>
>>
>> Doron,
>>
>> Do you get any idea about it?
>>
>> startup_002 at sina.cn :
>>
>>
>>
>> Hi,
>>
>> I built the oVirt engine RPM packages from the latest oVirt engine
>> source code and setup a yum installation server with these packages.
>> I can successfully install the RPM packages on my oVirt engine test
>> server. But when the "engine-setup" command was used to setup the
>> engine sever, the following errors were encountered from
>> engine-setup log. It seems that inst_add_iso_storage_domain was not
>> created properly for psql. Any clue to this problem?
>>
>> 2013-03-05 20:02:19::DEBUG::nfsutils::192::root:: Generating unique
>> uuid
>> 2013-03-05 20:02:19::DEBUG::common_utils::501::root:: running sql
>> query 'select inst_add_iso_storage_domain
>> ('ab22b419-6381-4f0a-8b46-aa72c81edbb5', 'ISO_DOMAIN',
>> 'ead292ee-14dd-40f9-b06b-f2250f7594a9',
>> 'localhost.localdomain:/ISO', 0, 0)' on db server: 'localhost'.
>> 2013-03-05 20:02:19::DEBUG::common_utils::454::root:: Executing
>> command --> '/usr/bin/psql -h localhost -p 5432 -U engine -d engine
>> -c select inst_add_iso_storage_domain
>> ('ab22b419-6381-4f0a-8b46-aa72c81edbb5', 'ISO_DOMAIN',
>> 'ead292ee-14dd-40f9-b06b-f2250f7594a9',
>> 'localhost.localdomain:/ISO', 0, 0)' in working directory '/root'
>> 2013-03-05 20:02:19::DEBUG::common_utils::492::root:: output =
>> 2013-03-05 20:02:19::DEBUG::common_utils::493::root:: stderr = ERROR:
>> NUM:42883, DETAILS:function insertstorage_domain_static(uuid,
>> character varying, character varying, integer, integer, unknown,
>> integer) does not exist
>>
>> 2013-03-05 20:02:19::DEBUG::common_utils::494::root:: retcode = 1
>> 2013-03-05 20:02:19::ERROR::engine-setup::1809::root:: Traceback
>> (most recent call last):
>> File "/bin/engine-setup", line 1804, in _configNfsShare
>> _addIsoDomaintoDB(controller.CONF["sd_uuid"],
>> controller.CONF["ISO_DOMAIN_NAME"])
>> File "/bin/engine-setup", line 1860, 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 510, in
>> execRemoteSqlCommand
>> return execCmd(cmdList=cmd, failOnError=failOnError, msg=errMsg,
>> envDict=getPgEnv())
>> File "/usr/share/ovirt-engine/scripts/common_utils.py", line 497, in
>> execCmd
>> raise Exception(msg)
>> Exception: Failed inserting ISO domain into engine db
>>
>> 2013-03-05 20:02:19::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 "/bin/engine-setup", line 1810, in _configNfsShare
>> raise Exception(output_messages.ERR_FAILED_CFG_NFS_SHARE)
>> Exception: Failed to configure NFS share on this host
>>
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1992::root:: *** The
>> following params were used as user input:
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root::
>> override-httpd-config: yes
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root:: http-port: 80
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root:: https-port:
>> 443
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root::
>> random-passwords: no
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root:: mac-range:
>> 00:1A:4A:A8:01:00-00:1A:4A:A8:01:FF
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root:: host-fqdn:
>> localhost.localdomain
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root:: auth-pass:
>> ********
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root:: org-name:
>> localdomain
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root::
>> application-mode: virt
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root::
>> default-dc-type: NFS
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root::
>> db-remote-install: local
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root:: db-host:
>> localhost
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root:: db-local-pass:
>> ********
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root:: nfs-mp: /ISO
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root::
>> iso-domain-name: ISO_DOMAIN
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root:: config-nfs:
>> yes
>> 2013-03-05 20:02:19::DEBUG::engine-setup::1997::root::
>> firewall-manager: iptables
>> 2013-03-05 20:02:19::ERROR::engine-setup::2413::root:: Traceback
>> (most recent call last):
>> File "/bin/engine-setup", line 2407, in <module>
>> main(confFile)
>> File "/bin/engine-setup", line 2190, in main
>>
>>
>> _______________________________________________
>> Engine-devel mailing list Engine-devel at ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/engine-devel
>>
>> --
>> ---
>> 舒明 Shu Ming
>> Open Virtualization Engineerning; CSTL, IBM Corp.
>> Tel: 86-10-82451626  Tieline: 9051626 E-mail: shuming at cn.ibm.com or
>> shuming at linux.vnet.ibm.com Address: 3/F Ring Building, ZhongGuanCun
>> Software Park, Haidian District, Beijing 100193, PRC
>> _______________________________________________
>> Engine-devel mailing list
>> Engine-devel at ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/engine-devel
>>
> _______________________________________________
> Engine-devel mailing list
> Engine-devel at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/engine-devel
>

-- 
Dirección Comercial: C/Jose Bardasano Baos, 9, Edif. Gorbea 3, planta 
3ºD, 28016 Madrid, Spain
Inscrita en el Reg. Mercantil de Madrid – C.I.F. B82657941 - Red Hat S.L.