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

[Sandro Bonazzola]

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?
-- 
Sandro