<div dir="ltr"><div>i'm now getting : <br><br><br>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<br>
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<br>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<br>
2013-01-15 23:14:58,972 INFO [org.ovirt.engine.core.utils.transaction.TransactionSupport] (pool-3-thread-47) [215749c1] transaction rolled back<br>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"<br>
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 )"<br>
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"<br> 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 )"<br>
PL/pgSQL function "insertbasedisk" line 2 at SQL statement<br> at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:228) [spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]<br>
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]<br> at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:952) [spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]<br>
at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:985) [spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]<br> at org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:368) [spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]<br>
at org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:342) [spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]<br> at org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:164) [spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]<br>
at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:124) [engine-dal.jar:]<br> at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeModification(SimpleJdbcCallsHandler.java:37) [engine-dal.jar:]<br>
at org.ovirt.engine.core.dao.DefaultGenericDaoDbFacade.save(DefaultGenericDaoDbFacade.java:93) [engine-dal.jar:]<br> at org.ovirt.engine.core.bll.ImportVmCommand.addVmImagesAndSnapshots(ImportVmCommand.java:638) [engine-bll.jar:]<br>
at org.ovirt.engine.core.bll.ImportVmCommand.access$200(ImportVmCommand.java:76) [engine-bll.jar:]<br> at org.ovirt.engine.core.bll.ImportVmCommand$4.runInTransaction(ImportVmCommand.java:501) [engine-bll.jar:]<br>
at org.ovirt.engine.core.bll.ImportVmCommand$4.runInTransaction(ImportVmCommand.java:497) [engine-bll.jar:]<br> at org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInNewTransaction(TransactionSupport.java:204) [engine-utils.jar:]<br>
at org.ovirt.engine.core.bll.ImportVmCommand.processImages(ImportVmCommand.java:497) [engine-bll.jar:]<br> at org.ovirt.engine.core.bll.ImportVmCommand.executeCommand(ImportVmCommand.java:477) [engine-bll.jar:]<br>
at org.ovirt.engine.core.bll.CommandBase.ExecuteWithoutTransaction(CommandBase.java:804) [engine-bll.jar:]<br> at org.ovirt.engine.core.bll.CommandBase.executeActionInTransactionScope(CommandBase.java:896) [engine-bll.jar:]<br>
at org.ovirt.engine.core.bll.CommandBase.runInTransaction(CommandBase.java:1203) [engine-bll.jar:]<br> at org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInSuppressed(TransactionSupport.java:168) [engine-utils.jar:]<br>
at org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInScope(TransactionSupport.java:107) [engine-utils.jar:]<br> at org.ovirt.engine.core.bll.CommandBase.Execute(CommandBase.java:911) [engine-bll.jar:]<br>
at org.ovirt.engine.core.bll.CommandBase.ExecuteAction(CommandBase.java:268) [engine-bll.jar:]<br> at org.ovirt.engine.core.bll.MultipleActionsRunner.executeValidatedCommands(MultipleActionsRunner.java:182) [engine-bll.jar:]<br>
at org.ovirt.engine.core.bll.MultipleActionsRunner.RunCommands(MultipleActionsRunner.java:162) [engine-bll.jar:]<br> at org.ovirt.engine.core.bll.MultipleActionsRunner$1.run(MultipleActionsRunner.java:84) [engine-bll.jar:]<br>
at org.ovirt.engine.core.utils.threadpool.ThreadPoolUtil$InternalWrapperRunnable.run(ThreadPoolUtil.java:64) [engine-utils.jar:]<br> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.6.0_24]<br>
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.6.0_24]<br> at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.6.0_24]<br> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.6.0_24]<br>
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.6.0_24]<br> at java.lang.Thread.run(Thread.java:679) [rt.jar:1.6.0_24]<br>Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "pk_disks"<br>
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 )"<br>
PL/pgSQL function "insertbasedisk" line 2 at SQL statement<br> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) [postgresql-jdbc.jar:]<br> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) [postgresql-jdbc.jar:]<br>
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) [postgresql-jdbc.jar:]<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) [postgresql-jdbc.jar:]<br>
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) [postgresql-jdbc.jar:]<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:360) [postgresql-jdbc.jar:]<br>
at org.jboss.jca.adapters.jdbc.CachedPreparedStatement.execute(CachedPreparedStatement.java:297)<br> at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)<br> at org.springframework.jdbc.core.JdbcTemplate$5.doInCallableStatement(JdbcTemplate.java:987) [spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]<br>
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:936) [spring-jdbc-2.5.6.SEC02.jar:2.5.6.SEC02]<br> ... 31 more<br><br><br></div>_after_ successfully importing 1 VM ... <br><div><br></div><div>
Alex<br><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 15 January 2013 22:00, Itamar Heim <span dir="ltr"><<a href="mailto:iheim@redhat.com" target="_blank">iheim@redhat.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On 01/15/2013 10:24 PM, Alex Leonhardt wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
Hi,<br>
<br>
Am trying to import VMs from an abandoned storage pool -<br>
<br>
all I'm getting is this :<br>
<br>
2013-01-15 20:21:05,958 INFO<br>
[org.ovirt.engine.core.<u></u>vdsbroker.irsbroker.<u></u>GetVmsInfoVDSCommand]<br>
(ajp--0.0.0.0-8009-16) START, GetVmsInfoVDSCommand(<u></u>storagePoolId =<br>
38a9ac9d-fe31-4003-8111-<u></u>3ac741470b6e, ignoreFailoverLimit = false,<br>
compatabilityVersion = null, storageDomainId =<br>
b9c2cf06-73ea-4dd4-900b-<u></u>3af322ab223d, vmIdList = null), log id: 65b1c9a8<br>
2013-01-15 20:21:06,013 INFO<br>
[org.ovirt.engine.core.<u></u>vdsbroker.irsbroker.<u></u>GetVmsInfoVDSCommand]<br>
(ajp--0.0.0.0-8009-16) FINISH, GetVmsInfoVDSCommand, log id: 65b1c9a8<br>
2013-01-15 20:21:06,036 INFO<br>
[org.ovirt.engine.core.<u></u>vdsbroker.irsbroker.<u></u>GetVmsInfoVDSCommand]<br>
(ajp--0.0.0.0-8009-11) START, GetVmsInfoVDSCommand(<u></u>storagePoolId =<br>
38a9ac9d-fe31-4003-8111-<u></u>3ac741470b6e, ignoreFailoverLimit = false,<br>
compatabilityVersion = null, storageDomainId =<br>
b9c2cf06-73ea-4dd4-900b-<u></u>3af322ab223d, vmIdList = null), log id: 7b0bc172<br>
2013-01-15 20:21:06,085 INFO<br>
[org.ovirt.engine.core.<u></u>vdsbroker.irsbroker.<u></u>GetVmsInfoVDSCommand]<br>
(ajp--0.0.0.0-8009-11) FINISH, GetVmsInfoVDSCommand, log id: 7b0bc172<br>
2013-01-15 20:21:06,928 INFO<br>
[org.ovirt.engine.core.<u></u>vdsbroker.irsbroker.<u></u>GetImageDomainsListVDSCommand] (ajp--0.0.0.0-8009-11)<br>
START, GetImageDomainsListVDSCommand(<u></u>storagePoolId =<br>
38a9ac9d-fe31-4003-8111-<u></u>3ac741470b6e, ignoreFailoverLimit = false,<br>
compatabilityVersion = null, imageGroupId =<br>
8d41be6c-a586-4bb6-be4b-<u></u>f1241a4bf088), log id: 79952c27<br>
2013-01-15 20:21:06,951 INFO<br>
[org.ovirt.engine.core.<u></u>vdsbroker.irsbroker.<u></u>GetImageDomainsListVDSCommand] (ajp--0.0.0.0-8009-11)<br>
FINISH, GetImageDomainsListVDSCommand, return: [], log id: 79952c27<br>
2013-01-15 20:21:06,954 INFO<br>
[org.ovirt.engine.core.<u></u>vdsbroker.irsbroker.<u></u>DoesImageExistVDSCommand]<br>
(ajp--0.0.0.0-8009-11) START, DoesImageExistVDSCommand(<u></u>storagePoolId =<br>
38a9ac9d-fe31-4003-8111-<u></u>3ac741470b6e, ignoreFailoverLimit = false,<br>
compatabilityVersion = null, storageDomainId =<br>
b9c2cf06-73ea-4dd4-900b-<u></u>3af322ab223d, imageGroupId =<br>
8d41be6c-a586-4bb6-be4b-<u></u>f1241a4bf088, imageId =<br>
a4782145-626c-4a6e-9e1e-<u></u>fce5f1dd8f78), log id: 3085f2cd<br>
2013-01-15 20:21:06,993 INFO<br>
[org.ovirt.engine.core.<u></u>vdsbroker.irsbroker.<u></u>DoesImageExistVDSCommand]<br>
(ajp--0.0.0.0-8009-11) FINISH, DoesImageExistVDSCommand, return: true,<br>
log id: 3085f2cd<br>
2013-01-15 20:21:07,039 INFO<br>
[org.ovirt.engine.core.bll.<u></u>ImportVmCommand] (pool-3-thread-48) [8991b34]<br>
Running command: ImportVmCommand internal: false. Entities affected :<br>
ID: b756284f-06f9-44cd-ba45-<u></u>6cac3486fe37 Type: Storage<br>
2013-01-15 20:21:07,040 ERROR<br>
[org.ovirt.engine.core.dal.<u></u>dbbroker.auditloghandling.<u></u>AuditLogDirector]<br>
(pool-3-thread-48) [8991b34] Try to add duplicate values with same name.<br>
Type: UNASSIGNED. Value: vmname<br>
2013-01-15 20:21:07,045 ERROR<br>
[org.ovirt.engine.core.dal.<u></u>dbbroker.auditloghandling.<u></u>AuditLogDirector]<br>
(pool-3-thread-48) [8991b34] Try to add duplicate values with same name.<br>
Type: UNASSIGNED. Value: vmname<br>
2013-01-15 20:21:07,049 INFO<br>
[org.ovirt.engine.core.utils.<u></u>transaction.<u></u>TransactionSupport]<br>
(pool-3-thread-48) [8991b34] transaction rolled back<br>
2013-01-15 20:21:07,050 ERROR<br>
[org.ovirt.engine.core.bll.<u></u>ImportVmCommand] (pool-3-thread-48) [8991b34]<br>
Command org.ovirt.engine.core.bll.<u></u>ImportVmCommand throw exception:<br>
java.lang.<u></u>StringIndexOutOfBoundsExceptio<u></u>n: String index out of range: 6<br>
at<br>
java.lang.<u></u>AbstractStringBuilder.<u></u>deleteCharAt(<u></u>AbstractStringBuilder.java:<u></u>766)<br>
[rt.jar:1.6.0_24]<br>
at java.lang.StringBuilder.<u></u>deleteCharAt(StringBuilder.<u></u>java:280)<br>
[rt.jar:1.6.0_24]<br>
at<br>
org.ovirt.engine.core.bll.<u></u>ImportVmCommand.<u></u>auditInvalidInterfaces(<u></u>ImportVmCommand.java:933)<br>
[engine-bll.jar:]<br>
at<br>
org.ovirt.engine.core.bll.<u></u>ImportVmCommand.AddVmNetwork(<u></u>ImportVmCommand.java:801)<br>
[engine-bll.jar:]<br>
at<br>
org.ovirt.engine.core.bll.<u></u>ImportVmCommand$3.<u></u>runInTransaction(<u></u>ImportVmCommand.java:488)<br>
[engine-bll.jar:]<br>
at<br>
org.ovirt.engine.core.bll.<u></u>ImportVmCommand$3.<u></u>runInTransaction(<u></u>ImportVmCommand.java:482)<br>
[engine-bll.jar:]<br>
at<br>
org.ovirt.engine.core.utils.<u></u>transaction.<u></u>TransactionSupport.<u></u>executeInNewTransaction(<u></u>TransactionSupport.java:204)<br>
[engine-utils.jar:]<br>
at<br>
org.ovirt.engine.core.bll.<u></u>ImportVmCommand.addVmToDb(<u></u>ImportVmCommand.java:482)<br>
[engine-bll.jar:]<br>
at<br>
org.ovirt.engine.core.bll.<u></u>ImportVmCommand.<u></u>executeCommand(<u></u>ImportVmCommand.java:476)<br>
[engine-bll.jar:]<br>
at<br>
org.ovirt.engine.core.bll.<u></u>CommandBase.<u></u>ExecuteWithoutTransaction(<u></u>CommandBase.java:804)<br>
[engine-bll.jar:]<br>
at<br>
org.ovirt.engine.core.bll.<u></u>CommandBase.<u></u>executeActionInTransactionScop<u></u>e(CommandBase.java:896)<br>
[engine-bll.jar:]<br>
at<br>
org.ovirt.engine.core.bll.<u></u>CommandBase.runInTransaction(<u></u>CommandBase.java:1203)<br>
[engine-bll.jar:]<br>
at<br>
org.ovirt.engine.core.utils.<u></u>transaction.<u></u>TransactionSupport.<u></u>executeInSuppressed(<u></u>TransactionSupport.java:168)<br>
[engine-utils.jar:]<br>
at<br>
org.ovirt.engine.core.utils.<u></u>transaction.<u></u>TransactionSupport.<u></u>executeInScope(<u></u>TransactionSupport.java:107)<br>
[engine-utils.jar:]<br>
at<br>
org.ovirt.engine.core.bll.<u></u>CommandBase.Execute(<u></u>CommandBase.java:911)<br>
[engine-bll.jar:]<br>
at<br>
org.ovirt.engine.core.bll.<u></u>CommandBase.ExecuteAction(<u></u>CommandBase.java:268) [engine-bll.jar:]<br>
at<br>
org.ovirt.engine.core.bll.<u></u>MultipleActionsRunner.<u></u>executeValidatedCommands(<u></u>MultipleActionsRunner.java:<u></u>182)<br>
[engine-bll.jar:]<br>
at<br>
org.ovirt.engine.core.bll.<u></u>MultipleActionsRunner.<u></u>RunCommands(<u></u>MultipleActionsRunner.java:<u></u>162)<br>
[engine-bll.jar:]<br>
at<br>
org.ovirt.engine.core.bll.<u></u>MultipleActionsRunner$1.run(<u></u>MultipleActionsRunner.java:84)<br>
[engine-bll.jar:]<br>
at<br>
org.ovirt.engine.core.utils.<u></u>threadpool.ThreadPoolUtil$<u></u>InternalWrapperRunnable.run(<u></u>ThreadPoolUtil.java:64)<br>
[engine-utils.jar:]<br>
at<br>
java.util.concurrent.<u></u>Executors$RunnableAdapter.<u></u>call(Executors.java:471)<br>
[rt.jar:1.6.0_24]<br>
at<br>
java.util.concurrent.<u></u>FutureTask$Sync.innerRun(<u></u>FutureTask.java:334)<br>
[rt.jar:1.6.0_24]<br>
at java.util.concurrent.<u></u>FutureTask.run(FutureTask.<u></u>java:166)<br>
[rt.jar:1.6.0_24]<br>
at<br>
java.util.concurrent.<u></u>ThreadPoolExecutor.runWorker(<u></u>ThreadPoolExecutor.java:1110)<br>
[rt.jar:1.6.0_24]<br>
at<br>
java.util.concurrent.<u></u>ThreadPoolExecutor$Worker.run(<u></u>ThreadPoolExecutor.java:603)<br>
[rt.jar:1.6.0_24]<br>
at java.lang.Thread.run(Thread.<u></u>java:679) [rt.jar:1.6.0_24]<br>
<br>
2013-01-15 20:21:07,232 INFO<br>
[org.ovirt.engine.core.<u></u>vdsbroker.irsbroker.<u></u>GetVmsInfoVDSCommand]<br>
(ajp--0.0.0.0-8009-14) START, GetVmsInfoVDSCommand(<u></u>storagePoolId =<br>
38a9ac9d-fe31-4003-8111-<u></u>3ac741470b6e, ignoreFailoverLimit = false,<br>
compatabilityVersion = null, storageDomainId =<br>
b9c2cf06-73ea-4dd4-900b-<u></u>3af322ab223d, vmIdList = null), log id: 44689362<br>
2013-01-15 20:21:07,284 INFO<br>
[org.ovirt.engine.core.<u></u>vdsbroker.irsbroker.<u></u>GetVmsInfoVDSCommand]<br>
(ajp--0.0.0.0-8009-14) FINISH, GetVmsInfoVDSCommand, log id: 44689362<br>
<br>
<br>
above only as I was somehow able to convince it, that it was a export<br>
domain ...<br>
<br>
<br>
question really is - how can i re-attach the Storage domain ?? Ideally<br>
w/o having to re-import the VMs ... although i'd accept it as a work<br>
around - however - re-creating is out of question, it'll take me 3 days<br>
( and my job ) ...<br>
<br>
Alex<br>
<br>
<br>
<br>
--<br>
<br></div></div>
| RHCE | Senior Systems Engineer | <a href="http://www.vcore.co" target="_blank">www.vcore.co</a> <<a href="http://www.vcore.co" target="_blank">http://www.vcore.co</a>> |<br>
<a href="http://www.vsearchcloud.com" target="_blank">www.vsearchcloud.com</a> <<a href="http://www.vsearchcloud.com" target="_blank">http://www.vsearchcloud.com</a>> |<br>
<br>
<br>
______________________________<u></u>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/<u></u>mailman/listinfo/users</a><br>
<br>
</blockquote>
<br>
easiest to check this if you can add the OVF causing the issue<br>
<br>
</blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr"><div><br></div>| RHCE | Senior Systems Engineer | <a href="http://www.vcore.co" target="_blank">www.vcore.co</a> | <a href="http://www.vsearchcloud.com" target="_blank">www.vsearchcloud.com</a> | <br>
</div>
</div>