[Users] Import VMs from abandoned Storage Domain
Alex Leonhardt
alex.tuxx at gmail.com
Tue Jan 15 23:26:14 UTC 2013
ok, that last one was my fault i think - i thought the DB restore I did was
100% fail, but it wasnt ... removed all the DB entries that I could
identify and the VMs are restoring now ...
On 15 January 2013 23:16, Alex Leonhardt <alex.tuxx at gmail.com> 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 at 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> |
>>> www.vsearchcloud.com <http://www.vsearchcloud.com> |
>>>
>>>
>>> ______________________________**_________________
>>> Users mailing list
>>> Users at 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 | www.vsearchcloud.com |
>
--
| RHCE | Senior Systems Engineer | www.vcore.co | www.vsearchcloud.com |
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20130115/13e14d3e/attachment-0001.html>
More information about the Users
mailing list