[Engine-devel] 转发：Re: function insertstorage_domain_static(uuid, ...) does not exist

[Sandro Bonazzola]

Il 08/03/2013 16:34, Juan Hernandez ha scritto:
> On 03/08/2013 04:33 PM, Sandro Bonazzola wrote:
>> Il 07/03/2013 16:40, Juan Hernandez ha scritto:
>>>
>>> Yes, I think it is a bug. To workaround it try to add the new
>>> parameter to the inst_sp.sql file. In line 31 you will see this:
>>>
>>> perform
>>> Insertstorage_domain_static(v_storage_domain_id,cast(v_connection_id
>>> as varchar(250)),v_name,1,2,'0',0);
>>>
>>> I think it can be fixed adding the new parameter as follows:
>>>
>>> perform
>>> Insertstorage_domain_static(v_storage_domain_id,cast(v_connection_id
>>> as varchar(250)),v_name,v_name,1,2,'0',0);
>>>
>>> This is just using the name of the storage domain as description.
>>>
>>> Once you have modified that file you will have to repeat the
>>> installation.
>>>
>>> If that solves the problem then we may need to apply the following
>>> patch to the source code:
>>>
>>> diff --git a/backend/manager/dbscripts/inst_sp.sql
>>> b/backend/manager/dbscripts/inst_sp.sql
>>> index 82e8502..a4dcd20 100644
>>> --- a/backend/manager/dbscripts/inst_sp.sql
>>> +++ b/backend/manager/dbscripts/inst_sp.sql
>>> @@ -28,7 +28,7 @@ BEGIN
>>>           -- Insert storage server connection info
>>>           perform
>>> Insertstorage_server_connections(v_connection,cast(v_connection_id as
>>> varchar(250)),NULL,NULL,NULL,NULL,1,NULL,NULL,N
>>>           -- Insert storage domain static info
>>> -        perform
>>> Insertstorage_domain_static(v_storage_domain_id,cast(v_connection_id
>>> as varchar(250)),v_name,1,2,'0',0);
>>> +        perform
>>> Insertstorage_domain_static(v_storage_domain_id,cast(v_connection_id
>>> as varchar(250)),v_name,v_name,1,2,'0',0);
>>>           -- Insert storage domain dynamic  info
>>>           perform
>>> Insertstorage_domain_dynamic(v_available,v_storage_domain_id,v_used);
>>>       end if;
>>>
>>> Would you mind submitting it to gerrit?
>>
>> Hi Juan,
>> I've tried the fix you suggested while working on another bug and it
>> worked for me.
>> Has anybody already submitted the patch to gerrit?
>>
>
> I think it hasn't been submitted, would you be so kind to submit it?
>
Sure, here itis: http://gerrit.ovirt.org/12881