Re: [Users] Import VMs from abandoned Storage Domain

Wednesday, 16 January 2013

i'm assuming you didn't re-install your engine, so it still has these 
disks in its db.
in 3.2, you can import to new vm/disks without deleting the previous ones).
is this a clean install of engine, or a revival of the engine which 
storage got lost?

On 01/16/2013 01:16 AM, Alex Leonhardt wrote:
...
 i'm now getting :

 2013-01-15 23:14:58,934 INFO
 [org.ovirt.engine.core.bll.ImportVmCommand] (pool-3-thread-47)
 [215749c1] Running command: ImportVmCommand internal: false. Entities
 affected :  ID: 9bd4735c-a02b-403a-8e66-c5679b70e137 Type: Storage
 2013-01-15 23:14:58,940 ERROR
 [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector]
 (pool-3-thread-47) [215749c1] Try to add duplicate values with same
 name. Type: UNASSIGNED. Value: vmname
 2013-01-15 23:14:58,949 ERROR
 [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector]
 (pool-3-thread-47) [215749c1] Try to add duplicate values with same
 name. Type: UNASSIGNED. Value: vmname
 2013-01-15 23:14:58,972 INFO
 [org.ovirt.engine.core.utils.transaction.TransactionSupport]
 (pool-3-thread-47) [215749c1] transaction rolled back
 2013-01-15 23:14:58,973 ERROR
 [org.ovirt.engine.core.bll.ImportVmCommand] (pool-3-thread-47)
 [215749c1] Command org.ovirt.engine.core.bll.ImportVmCommand throw
 exception: org.springframework.dao.DataIntegrityViolationException:
 CallableStatementCallback; SQL [{call insertbasedisk(?, ?, ?, ?, ?, ?,
 ?, ?, ?)}]; ERROR: duplicate key value violates unique constraint "pk_disks"
    Where: SQL statement "INSERT INTO base_disks( disk_id,
 disk_interface, wipe_after_delete, propagate_errors, disk_alias,
 disk_description, shareable, boot, allow_snapshot) VALUES(  $1 ,  $2 ,
 $3 ,  $4 ,  $5 ,  $6 ,  $7 ,  $8 ,  $9 )"
 PL/pgSQL function "insertbasedisk" line 2 at SQL statement; nested
 exception is org.postgresql.util.PSQLException: ERROR: duplicate key
 value violates unique constraint "pk_disks"
    Where: SQL statement "INSERT INTO base_disks( disk_id,
 disk_interface, wipe_after_delete, propagate_errors, disk_alias,
 disk_description, shareable, boot, allow_snapshot) VALUES(  $1 ,  $2 ,
 $3 ,  $4 ,  $5 ,  $6 ,  $7 ,  $8 ,  $9 )"
 PL/pgSQL function "insertbasedisk" line 2 at SQL statement
      at

org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:228)
 [spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]
      at

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
 [spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]
      at
 org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:952)
[spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]
      at
 org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:985)
 [spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]
      at

org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:368)
 [spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]
      at

org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:342)
 [spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]
      at
 org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:164)
 [spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]
      at

org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:124)
 [engine-dal.jar:]
      at

org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeModification(SimpleJdbcCallsHandler.java:37)
 [engine-dal.jar:]
      at

org.ovirt.engine.core.dao.DefaultGenericDaoDbFacade.save(DefaultGenericDaoDbFacade.java:93)
 [engine-dal.jar:]
      at

org.ovirt.engine.core.bll.ImportVmCommand.addVmImagesAndSnapshots(ImportVmCommand.java:638)
 [engine-bll.jar:]
      at
 org.ovirt.engine.core.bll.ImportVmCommand.access$200(ImportVmCommand.java:76)
 [engine-bll.jar:]
      at
 org.ovirt.engine.core.bll.ImportVmCommand$4.runInTransaction(ImportVmCommand.java:501)
 [engine-bll.jar:]
      at
 org.ovirt.engine.core.bll.ImportVmCommand$4.runInTransaction(ImportVmCommand.java:497)
 [engine-bll.jar:]
      at

org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInNewTransaction(TransactionSupport.java:204)
 [engine-utils.jar:]
      at
 org.ovirt.engine.core.bll.ImportVmCommand.processImages(ImportVmCommand.java:497)
 [engine-bll.jar:]
      at
 org.ovirt.engine.core.bll.ImportVmCommand.executeCommand(ImportVmCommand.java:477)
 [engine-bll.jar:]
      at
 org.ovirt.engine.core.bll.CommandBase.ExecuteWithoutTransaction(CommandBase.java:804)
 [engine-bll.jar:]
      at

org.ovirt.engine.core.bll.CommandBase.executeActionInTransactionScope(CommandBase.java:896)
 [engine-bll.jar:]
      at
 org.ovirt.engine.core.bll.CommandBase.runInTransaction(CommandBase.java:1203)
 [engine-bll.jar:]
      at

org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInSuppressed(TransactionSupport.java:168)
 [engine-utils.jar:]
      at

org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInScope(TransactionSupport.java:107)
 [engine-utils.jar:]
      at
 org.ovirt.engine.core.bll.CommandBase.Execute(CommandBase.java:911)
 [engine-bll.jar:]
      at
 org.ovirt.engine.core.bll.CommandBase.ExecuteAction(CommandBase.java:268)
[engine-bll.jar:]
      at

org.ovirt.engine.core.bll.MultipleActionsRunner.executeValidatedCommands(MultipleActionsRunner.java:182)
 [engine-bll.jar:]
      at

org.ovirt.engine.core.bll.MultipleActionsRunner.RunCommands(MultipleActionsRunner.java:162)
 [engine-bll.jar:]
      at
 org.ovirt.engine.core.bll.MultipleActionsRunner$1.run(MultipleActionsRunner.java:84)
 [engine-bll.jar:]
      at

org.ovirt.engine.core.utils.threadpool.ThreadPoolUtil$InternalWrapperRunnable.run(ThreadPoolUtil.java:64)
 [engine-utils.jar:]
      at
 java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
 [rt.jar:1.6.0_24]
      at
 java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
 [rt.jar:1.6.0_24]
      at java.util.concurrent.FutureTask.run(FutureTask.java:166)
 [rt.jar:1.6.0_24]
      at
 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
 [rt.jar:1.6.0_24]
      at
 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
 [rt.jar:1.6.0_24]
      at java.lang.Thread.run(Thread.java:679) [rt.jar:1.6.0_24]
 Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value
 violates unique constraint "pk_disks"
    Where: SQL statement "INSERT INTO base_disks( disk_id,
 disk_interface, wipe_after_delete, propagate_errors, disk_alias,
 disk_description, shareable, boot, allow_snapshot) VALUES(  $1 ,  $2 ,
 $3 ,  $4 ,  $5 ,  $6 ,  $7 ,  $8 ,  $9 )"
 PL/pgSQL function "insertbasedisk" line 2 at SQL statement
      at

org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
 [postgresql-jdbc.jar:]
      at
 org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
 [postgresql-jdbc.jar:]
      at
 org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
 [postgresql-jdbc.jar:]
      at
 org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
 [postgresql-jdbc.jar:]
      at

org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
 [postgresql-jdbc.jar:]
      at
 org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:360)
 [postgresql-jdbc.jar:]
      at

org.jboss.jca.adapters.jdbc.CachedPreparedStatement.execute(CachedPreparedStatement.java:297)
      at

org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)
      at

org.springframework.jdbc.core.JdbcTemplate$5.doInCallableStatement(JdbcTemplate.java:987)
 [spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]
      at
 org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:936)
[spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]
      ... 31 more

 _after_ successfully importing 1 VM ...

 Alex

 On 15 January 2013 22:00, Itamar Heim <iheim(a)redhat.com
 <mailto:iheim@redhat.com>> wrote:

     On 01/15/2013 10:24 PM, Alex Leonhardt wrote:

         Hi,

         Am trying to import VMs from an abandoned storage pool -

         all I'm getting is this :

         2013-01-15 20:21:05,958 INFO
         [org.ovirt.engine.core.__vdsbroker.irsbroker.__GetVmsInfoVDSCommand]
         (ajp--0.0.0.0-8009-16) START, GetVmsInfoVDSCommand(__storagePoolId =
         38a9ac9d-fe31-4003-8111-__3ac741470b6e, ignoreFailoverLimit = false,
         compatabilityVersion = null, storageDomainId =
         b9c2cf06-73ea-4dd4-900b-__3af322ab223d, vmIdList = null), log
         id: 65b1c9a8
         2013-01-15 20:21:06,013 INFO
         [org.ovirt.engine.core.__vdsbroker.irsbroker.__GetVmsInfoVDSCommand]
         (ajp--0.0.0.0-8009-16) FINISH, GetVmsInfoVDSCommand, log id:
         65b1c9a8
         2013-01-15 20:21:06,036 INFO
         [org.ovirt.engine.core.__vdsbroker.irsbroker.__GetVmsInfoVDSCommand]
         (ajp--0.0.0.0-8009-11) START, GetVmsInfoVDSCommand(__storagePoolId =
         38a9ac9d-fe31-4003-8111-__3ac741470b6e, ignoreFailoverLimit = false,
         compatabilityVersion = null, storageDomainId =
         b9c2cf06-73ea-4dd4-900b-__3af322ab223d, vmIdList = null), log
         id: 7b0bc172
         2013-01-15 20:21:06,085 INFO
         [org.ovirt.engine.core.__vdsbroker.irsbroker.__GetVmsInfoVDSCommand]
         (ajp--0.0.0.0-8009-11) FINISH, GetVmsInfoVDSCommand, log id:
         7b0bc172
         2013-01-15 20:21:06,928 INFO
         [org.ovirt.engine.core.__vdsbroker.irsbroker.__GetImageDomainsListVDSCommand]
         (ajp--0.0.0.0-8009-11)
         START, GetImageDomainsListVDSCommand(__storagePoolId =
         38a9ac9d-fe31-4003-8111-__3ac741470b6e, ignoreFailoverLimit = false,
         compatabilityVersion = null, imageGroupId =
         8d41be6c-a586-4bb6-be4b-__f1241a4bf088), log id: 79952c27
         2013-01-15 20:21:06,951 INFO
         [org.ovirt.engine.core.__vdsbroker.irsbroker.__GetImageDomainsListVDSCommand]
         (ajp--0.0.0.0-8009-11)
         FINISH, GetImageDomainsListVDSCommand, return: [], log id: 79952c27
         2013-01-15 20:21:06,954 INFO
         [org.ovirt.engine.core.__vdsbroker.irsbroker.__DoesImageExistVDSCommand]
         (ajp--0.0.0.0-8009-11) START,
         DoesImageExistVDSCommand(__storagePoolId =
         38a9ac9d-fe31-4003-8111-__3ac741470b6e, ignoreFailoverLimit = false,
         compatabilityVersion = null, storageDomainId =
         b9c2cf06-73ea-4dd4-900b-__3af322ab223d, imageGroupId =
         8d41be6c-a586-4bb6-be4b-__f1241a4bf088, imageId =
         a4782145-626c-4a6e-9e1e-__fce5f1dd8f78), log id: 3085f2cd
         2013-01-15 20:21:06,993 INFO
         [org.ovirt.engine.core.__vdsbroker.irsbroker.__DoesImageExistVDSCommand]
         (ajp--0.0.0.0-8009-11) FINISH, DoesImageExistVDSCommand, return:
         true,
         log id: 3085f2cd
         2013-01-15 20:21:07,039 INFO
         [org.ovirt.engine.core.bll.__ImportVmCommand] (pool-3-thread-48)
         [8991b34]
         Running command: ImportVmCommand internal: false. Entities
         affected :
         ID: b756284f-06f9-44cd-ba45-__6cac3486fe37 Type: Storage
         2013-01-15 20:21:07,040 ERROR
         [org.ovirt.engine.core.dal.__dbbroker.auditloghandling.__AuditLogDirector]
         (pool-3-thread-48) [8991b34] Try to add duplicate values with
         same name.
         Type: UNASSIGNED. Value: vmname
         2013-01-15 20:21:07,045 ERROR
         [org.ovirt.engine.core.dal.__dbbroker.auditloghandling.__AuditLogDirector]
         (pool-3-thread-48) [8991b34] Try to add duplicate values with
         same name.
         Type: UNASSIGNED. Value: vmname
         2013-01-15 20:21:07,049 INFO
         [org.ovirt.engine.core.utils.__transaction.__TransactionSupport]
         (pool-3-thread-48) [8991b34] transaction rolled back
         2013-01-15 20:21:07,050 ERROR
         [org.ovirt.engine.core.bll.__ImportVmCommand] (pool-3-thread-48)
         [8991b34]
         Command org.ovirt.engine.core.bll.__ImportVmCommand throw exception:
         java.lang.__StringIndexOutOfBoundsExceptio__n: String index out
         of range: 6
               at

java.lang.__AbstractStringBuilder.__deleteCharAt(__AbstractStringBuilder.java:__766)
         [rt.jar:1.6.0_24]
               at
         java.lang.StringBuilder.__deleteCharAt(StringBuilder.__java:280)
         [rt.jar:1.6.0_24]
               at

org.ovirt.engine.core.bll.__ImportVmCommand.__auditInvalidInterfaces(__ImportVmCommand.java:933)
         [engine-bll.jar:]
               at

org.ovirt.engine.core.bll.__ImportVmCommand.AddVmNetwork(__ImportVmCommand.java:801)
         [engine-bll.jar:]
               at

org.ovirt.engine.core.bll.__ImportVmCommand$3.__runInTransaction(__ImportVmCommand.java:488)
         [engine-bll.jar:]
               at

org.ovirt.engine.core.bll.__ImportVmCommand$3.__runInTransaction(__ImportVmCommand.java:482)
         [engine-bll.jar:]
               at

org.ovirt.engine.core.utils.__transaction.__TransactionSupport.__executeInNewTransaction(__TransactionSupport.java:204)
         [engine-utils.jar:]
               at

org.ovirt.engine.core.bll.__ImportVmCommand.addVmToDb(__ImportVmCommand.java:482)
         [engine-bll.jar:]
               at

org.ovirt.engine.core.bll.__ImportVmCommand.__executeCommand(__ImportVmCommand.java:476)
         [engine-bll.jar:]
               at

org.ovirt.engine.core.bll.__CommandBase.__ExecuteWithoutTransaction(__CommandBase.java:804)
         [engine-bll.jar:]
               at

org.ovirt.engine.core.bll.__CommandBase.__executeActionInTransactionScop__e(CommandBase.java:896)
         [engine-bll.jar:]
               at

org.ovirt.engine.core.bll.__CommandBase.runInTransaction(__CommandBase.java:1203)
         [engine-bll.jar:]
               at

org.ovirt.engine.core.utils.__transaction.__TransactionSupport.__executeInSuppressed(__TransactionSupport.java:168)
         [engine-utils.jar:]
               at

org.ovirt.engine.core.utils.__transaction.__TransactionSupport.__executeInScope(__TransactionSupport.java:107)
         [engine-utils.jar:]
               at
         org.ovirt.engine.core.bll.__CommandBase.Execute(__CommandBase.java:911)
         [engine-bll.jar:]
               at
         org.ovirt.engine.core.bll.__CommandBase.ExecuteAction(__CommandBase.java:268)
         [engine-bll.jar:]
               at

org.ovirt.engine.core.bll.__MultipleActionsRunner.__executeValidatedCommands(__MultipleActionsRunner.java:__182)
         [engine-bll.jar:]
               at

org.ovirt.engine.core.bll.__MultipleActionsRunner.__RunCommands(__MultipleActionsRunner.java:__162)
         [engine-bll.jar:]
               at

org.ovirt.engine.core.bll.__MultipleActionsRunner$1.run(__MultipleActionsRunner.java:84)
         [engine-bll.jar:]
               at

org.ovirt.engine.core.utils.__threadpool.ThreadPoolUtil$__InternalWrapperRunnable.run(__ThreadPoolUtil.java:64)
         [engine-utils.jar:]
               at
         java.util.concurrent.__Executors$RunnableAdapter.__call(Executors.java:471)
         [rt.jar:1.6.0_24]
               at
         java.util.concurrent.__FutureTask$Sync.innerRun(__FutureTask.java:334)
         [rt.jar:1.6.0_24]
               at
         java.util.concurrent.__FutureTask.run(FutureTask.__java:166)
         [rt.jar:1.6.0_24]
               at

java.util.concurrent.__ThreadPoolExecutor.runWorker(__ThreadPoolExecutor.java:1110)
         [rt.jar:1.6.0_24]
               at

java.util.concurrent.__ThreadPoolExecutor$Worker.run(__ThreadPoolExecutor.java:603)
         [rt.jar:1.6.0_24]
               at java.lang.Thread.run(Thread.__java:679) [rt.jar:1.6.0_24]

         2013-01-15 20:21:07,232 INFO
         [org.ovirt.engine.core.__vdsbroker.irsbroker.__GetVmsInfoVDSCommand]
         (ajp--0.0.0.0-8009-14) START, GetVmsInfoVDSCommand(__storagePoolId =
         38a9ac9d-fe31-4003-8111-__3ac741470b6e, ignoreFailoverLimit = false,
         compatabilityVersion = null, storageDomainId =
         b9c2cf06-73ea-4dd4-900b-__3af322ab223d, vmIdList = null), log
         id: 44689362
         2013-01-15 20:21:07,284 INFO
         [org.ovirt.engine.core.__vdsbroker.irsbroker.__GetVmsInfoVDSCommand]
         (ajp--0.0.0.0-8009-14) FINISH, GetVmsInfoVDSCommand, log id:
         44689362

         above only as I was somehow able to convince it, that it was a
         export
         domain ...

         question really is - how can i re-attach the Storage domain ??
         Ideally
         w/o having to re-import the VMs ... although i'd accept it as a work
         around - however - re-creating is out of question, it'll take me
         3 days
         ( and my job ) ...

         Alex

         --

         | RHCE | Senior Systems Engineer | www.vcore.co
         <http://www.vcore.co> <http://www.vcore.co> |
         www.vsearchcloud.com <http://www.vsearchcloud.com>
         <http://www.vsearchcloud.com> |

         _________________________________________________
         Users mailing list
         Users(a)ovirt.org <mailto:Users@ovirt.org>
         http://lists.ovirt.org/__mailman/listinfo/users
         <http://lists.ovirt.org/mailman/listinfo/users>

     easiest to check this if you can add the OVF causing the issue

 --

 | RHCE | Senior Systems Engineer | www.vcore.co <http://www.vcore.co> |
 www.vsearchcloud.com <http://www.vsearchcloud.com> | 

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

Re: [Users] Import VMs from abandoned Storage Domain