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

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?