[ovirt-users] moving storage and importing vms issue
Jiří Sléžka
jiri.slezka at slu.cz
Thu Sep 10 10:50:14 UTC 2015
Hello,
> ----- Original Message -----
>> From: "Jiří Sléžka" <jiri.slezka at slu.cz>
>> To: users at ovirt.org
>> Sent: Thursday, September 10, 2015 1:30:29 AM
>> Subject: [ovirt-users] moving storage and importing vms issue
>>
>> Hello,
>>
>> I am working on some consolidation of our RHEV/oVirt servers and I moved
>> one storage to new oVirt datacenter (put it into maintenance, detached
>> it from old and imported into new datacenter) which worked pretty good.
>>
>> Then I tried to import all the vms which worked also great except for
>> three of them.
>>
>> These vms are stucked in VM Import sub-tab and are quietly failing
>> import attempts (I can only see failed task "Importing VM clavius-winxp
>> from configuration to Cluster CIT-oVirt" but no related event and/or
>> explanation)
>>
>> There is only one host in this datacenter/cluster which is SPM. I can't
>> find anything interesting in vdsm.log (short span of import time is in
>> attachment).
>
> Can you please attach also engine.log ?
sure
well, here I can see an error... it looks like some db and/or snapshot
issue.
well and it looks like I lost also one secondary disk from one correctly
imported vm.
is there a way to show all images on some storage domain?
I found that my storage is this
[root at ovirt04 ~]# vdsClient -s 0 getStorageDomainInfo
088e7ed9-84c7-4fbd-a570-f37fa986a772
uuid = 088e7ed9-84c7-4fbd-a570-f37fa986a772
vguuid = MkMpr6-o9c1-LBUq-rZ0E-ZRSg-X31T-2aU1PV
state = OK
version = 3
role = Master
type = FCP
class = Data
pool = ['00000002-0002-0002-0002-0000000002b9']
name = oVirt-SlowStorage
but I have no luck with finding how to display all images on it.
Thanks,
Jiri
>
>>
>> Could you point me where should I look, please?
>>
>> Storage (FC) was formerly attached to RHEV3.5.3 on RHEL6.7 and was
>> imported into oVirt3.5.4 on CentOS7.1
>>
>> Thanks in advance,
>>
>> Jiri Slezka
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>
-------------- next part --------------
2015-09-10 00:10:44,822 INFO [org.ovirt.engine.core.bll.ImportVmFromConfigurationCommand] (ajp--127.0.0.1-8702-4) [b9c6b44] Lock Acquired to object EngineLock [exclusiveLocks= key: clavius-winxp value: VM_NAME
, sharedLocks= key: fb458ba1-10d2-4013-9fa4-4e2906f0ba11 value: REMOTE_VM
]
2015-09-10 00:10:44,844 INFO [org.ovirt.engine.core.vdsbroker.irsbroker.DoesImageExistVDSCommand] (ajp--127.0.0.1-8702-4) [b9c6b44] START, DoesImageExistVDSCommand( storagePoolId = 00000002-0002-0002-0002-0000000002b9, ignoreFailoverLimit = false, storageDomainId = 088e7ed9-84c7-4fbd-a570-f37fa986a772, imageGroupId = fb8f3165-5976-4094-9d37-ea0b09124547, imageId = cc83caa4-e366-4fd6-94b7-d16089aa29d6), log id: 68fe3d55
2015-09-10 00:10:45,183 INFO [org.ovirt.engine.core.vdsbroker.irsbroker.DoesImageExistVDSCommand] (ajp--127.0.0.1-8702-4) [b9c6b44] FINISH, DoesImageExistVDSCommand, return: true, log id: 68fe3d55
2015-09-10 00:10:45,184 INFO [org.ovirt.engine.core.vdsbroker.irsbroker.DoesImageExistVDSCommand] (ajp--127.0.0.1-8702-4) [b9c6b44] START, DoesImageExistVDSCommand( storagePoolId = 00000002-0002-0002-0002-0000000002b9, ignoreFailoverLimit = false, storageDomainId = 088e7ed9-84c7-4fbd-a570-f37fa986a772, imageGroupId = fb8f3165-5976-4094-9d37-ea0b09124547, imageId = 53c5003d-80de-4dfd-b5d8-50537a3a54d6), log id: 37e865fa
2015-09-10 00:10:45,370 INFO [org.ovirt.engine.core.vdsbroker.irsbroker.DoesImageExistVDSCommand] (ajp--127.0.0.1-8702-4) [b9c6b44] FINISH, DoesImageExistVDSCommand, return: true, log id: 37e865fa
2015-09-10 00:10:45,406 INFO [org.ovirt.engine.core.bll.ImportVmFromConfigurationCommand] (org.ovirt.thread.pool-8-thread-37) [b9c6b44] Running command: ImportVmFromConfigurationCommand internal: false. Entities affected : ID: 088e7ed9-84c7-4fbd-a570-f37fa986a772 Type: StorageAction group IMPORT_EXPORT_VM with role type ADMIN
2015-09-10 00:10:45,432 INFO [org.ovirt.engine.core.utils.transaction.TransactionSupport] (org.ovirt.thread.pool-8-thread-37) [b9c6b44] transaction rolled back
2015-09-10 00:10:45,433 ERROR [org.ovirt.engine.core.bll.ImportVmFromConfigurationCommand] (org.ovirt.thread.pool-8-thread-37) [b9c6b44] Command org.ovirt.engine.core.bll.ImportVmFromConfigurationCommand throw exception: org.springframework.dao.DuplicateKeyException: CallableStatementCallback; SQL [{call insertsnapshot(?, ?, ?, ?, ?, ?, ?, ?, ?)}]; ERROR: duplicate key value violates unique constraint "pk_snapshots"
Detail: Key (snapshot_id)=(00000000-0000-0000-0000-000000000000) already exists.
Where: SQL statement "INSERT INTO snapshots(
snapshot_id,
status,
vm_id,
snapshot_type,
description,
creation_date,
app_list,
vm_configuration,
memory_volume)
VALUES(
v_snapshot_id,
v_status,
v_vm_id,
v_snapshot_type,
v_description,
v_creation_date,
v_app_list,
v_vm_configuration,
v_memory_volume)"
PL/pgSQL function insertsnapshot(uuid,uuid,character varying,character varying,character varying,timestamp with time zone,text,text,character varying) line 3 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "pk_snapshots"
Detail: Key (snapshot_id)=(00000000-0000-0000-0000-000000000000) already exists.
Where: SQL statement "INSERT INTO snapshots(
snapshot_id,
status,
vm_id,
snapshot_type,
description,
creation_date,
app_list,
vm_configuration,
memory_volume)
VALUES(
v_snapshot_id,
v_status,
v_vm_id,
v_snapshot_type,
v_description,
v_creation_date,
v_app_list,
v_vm_configuration,
v_memory_volume)"
PL/pgSQL function insertsnapshot(uuid,uuid,character varying,character varying,character varying,timestamp with time zone,text,text,character varying) line 3 at SQL statement
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:241) [spring-jdbc.jar:3.1.1.RELEASE]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [spring-jdbc.jar:3.1.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1030) [spring-jdbc.jar:3.1.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1064) [spring-jdbc.jar:3.1.1.RELEASE]
at org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:388) [spring-jdbc.jar:3.1.1.RELEASE]
at org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:351) [spring-jdbc.jar:3.1.1.RELEASE]
at org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:181) [spring-jdbc.jar:3.1.1.RELEASE]
at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:141) [dal.jar:]
at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:136) [dal.jar:]
at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeModification(SimpleJdbcCallsHandler.java:74) [dal.jar:]
at org.ovirt.engine.core.dao.DefaultGenericDaoDbFacade.save(DefaultGenericDaoDbFacade.java:93) [dal.jar:]
at org.ovirt.engine.core.bll.ImportVmCommand.saveSnapshotIfNotExists(ImportVmCommand.java:1031) [bll.jar:]
at org.ovirt.engine.core.bll.ImportVmCommand.addVmImagesAndSnapshots(ImportVmCommand.java:919) [bll.jar:]
at org.ovirt.engine.core.bll.ImportVmCommand$4.runInTransaction(ImportVmCommand.java:737) [bll.jar:]
at org.ovirt.engine.core.bll.ImportVmCommand$4.runInTransaction(ImportVmCommand.java:733) [bll.jar:]
at org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInNewTransaction(TransactionSupport.java:210) [utils.jar:]
at org.ovirt.engine.core.bll.ImportVmCommand.processImages(ImportVmCommand.java:733) [bll.jar:]
at org.ovirt.engine.core.bll.ImportVmCommand.executeCommand(ImportVmCommand.java:702) [bll.jar:]
at org.ovirt.engine.core.bll.ImportVmFromConfigurationCommand.executeCommand(ImportVmFromConfigurationCommand.java:129) [bll.jar:]
at org.ovirt.engine.core.bll.CommandBase.executeWithoutTransaction(CommandBase.java:1193) [bll.jar:]
at org.ovirt.engine.core.bll.CommandBase.executeActionInTransactionScope(CommandBase.java:1332) [bll.jar:]
at org.ovirt.engine.core.bll.CommandBase.runInTransaction(CommandBase.java:1961) [bll.jar:]
at org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInSuppressed(TransactionSupport.java:174) [utils.jar:]
at org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInScope(TransactionSupport.java:116) [utils.jar:]
at org.ovirt.engine.core.bll.CommandBase.execute(CommandBase.java:1356) [bll.jar:]
at org.ovirt.engine.core.bll.CommandBase.executeAction(CommandBase.java:353) [bll.jar:]
at org.ovirt.engine.core.bll.MultipleActionsRunner.executeValidatedCommand(MultipleActionsRunner.java:193) [bll.jar:]
at org.ovirt.engine.core.bll.MultipleActionsRunner.runCommands(MultipleActionsRunner.java:160) [bll.jar:]
at org.ovirt.engine.core.bll.MultipleActionsRunner$2.run(MultipleActionsRunner.java:169) [bll.jar:]
at org.ovirt.engine.core.utils.threadpool.ThreadPoolUtil$InternalWrapperRunnable.run(ThreadPoolUtil.java:90) [utils.jar:]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.7.0_85]
at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_85]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_85]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_85]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_85]
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "pk_snapshots"
Detail: Key (snapshot_id)=(00000000-0000-0000-0000-000000000000) already exists.
Where: SQL statement "INSERT INTO snapshots(
snapshot_id,
status,
vm_id,
snapshot_type, description,
creation_date,
app_list,
vm_configuration,
memory_volume)
VALUES(
v_snapshot_id,
v_status,
v_vm_id,
v_snapshot_type,
v_description,
v_creation_date,
v_app_list,
v_vm_configuration,
v_memory_volume)"
PL/pgSQL function insertsnapshot(uuid,uuid,character varying,character varying,character varying,timestamp with time zone,text,text,character varying) line 3 at SQL statement
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)
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$6.doInCallableStatement(JdbcTemplate.java:1066) [spring-jdbc.jar:3.1.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1) [spring-jdbc.jar:3.1.1.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1014) [spring-jdbc.jar:3.1.1.RELEASE]
... 32 more
2015-09-10 00:10:45,480 INFO [org.ovirt.engine.core.bll.ImportVmFromConfigurationCommand] (org.ovirt.thread.pool-8-thread-37) [b9c6b44] Command [id=c974041f-2d04-497a-a1e6-0c066325c1ed]: Compensating NEW_ENTITY_ID of org.ovirt.engine.core.common.businessentities.VmStatistics; snapshot: fb458ba1-10d2-4013-9fa4-4e2906f0ba11.
2015-09-10 00:10:45,482 INFO [org.ovirt.engine.core.bll.ImportVmFromConfigurationCommand] (org.ovirt.thread.pool-8-thread-37) [b9c6b44] Command [id=c974041f-2d04-497a-a1e6-0c066325c1ed]: Compensating NEW_ENTITY_ID of org.ovirt.engine.core.common.businessentities.network.VmNetworkStatistics; snapshot: 994515f9-889e-491e-8f5b-eb798c7df5d9.
2015-09-10 00:10:45,484 INFO [org.ovirt.engine.core.bll.ImportVmFromConfigurationCommand] (org.ovirt.thread.pool-8-thread-37) [b9c6b44] Command [id=c974041f-2d04-497a-a1e6-0c066325c1ed]: Compensating NEW_ENTITY_ID of org.ovirt.engine.core.common.businessentities.network.VmNetworkInterface; snapshot: 994515f9-889e-491e-8f5b-eb798c7df5d9.
2015-09-10 00:10:45,487 INFO [org.ovirt.engine.core.bll.ImportVmFromConfigurationCommand] (org.ovirt.thread.pool-8-thread-37) [b9c6b44] Command [id=c974041f-2d04-497a-a1e6-0c066325c1ed]: Compensating NEW_ENTITY_ID of org.ovirt.engine.core.common.businessentities.VmDynamic; snapshot: fb458ba1-10d2-4013-9fa4-4e2906f0ba11.
2015-09-10 00:10:45,489 INFO [org.ovirt.engine.core.bll.ImportVmFromConfigurationCommand] (org.ovirt.thread.pool-8-thread-37) [b9c6b44] Command [id=c974041f-2d04-497a-a1e6-0c066325c1ed]: Compensating NEW_ENTITY_ID of org.ovirt.engine.core.common.businessentities.VmStatic; snapshot: fb458ba1-10d2-4013-9fa4-4e2906f0ba11.
2015-09-10 00:10:45,503 INFO [org.ovirt.engine.core.bll.ImportVmFromConfigurationCommand] (org.ovirt.thread.pool-8-thread-37) [b9c6b44] Lock freed to object EngineLock [exclusiveLocks= key: clavius-winxp value: VM_NAME
, sharedLocks= key: fb458ba1-10d2-4013-9fa4-4e2906f0ba11 value: REMOTE_VM
]
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jiri_slezka.vcf
Type: text/x-vcard
Size: 586 bytes
Desc: not available
URL: <http://lists.ovirt.org/pipermail/users/attachments/20150910/8a63bdd8/attachment-0001.vcf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3267 bytes
Desc: Elektronicky podpis S/MIME
URL: <http://lists.ovirt.org/pipermail/users/attachments/20150910/8a63bdd8/attachment-0001.p7s>
More information about the Users
mailing list