Re: [ovirt-users] moving storage and importing vms issue

Thu, 10 Sep 2015 03:51:13 -0700 

Hello,


----- Original Message -----

From: "Jiří Sléžka" <[email protected]>
To: [email protected]
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@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
[email protected]
http://lists.ovirt.org/mailman/listinfo/users




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
]

<<attachment: jiri_slezka.vcf>>

Attachment: smime.p7s
Description: Elektronicky podpis S/MIME

_______________________________________________
Users mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/users

Reply via email to