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

[Juan Hernandez]

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?

-- 
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.