Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 948282

Summary: Transaction errror during CreateSnapshotFromTemplate (child of AddVmCommand)
Product: Red Hat Enterprise Virtualization Manager Reporter: Yair Zaslavsky <yzaslavs>
Component: ovirt-engineAssignee: Roy Golan <rgolan>
Status: CLOSED ERRATA QA Contact: Leonid Natapov <lnatapov>
Severity: urgent Docs Contact:
Priority: urgent    
Version: 3.2.0CC: acathrow, bazulay, dyasny, hateya, iheim, italkohe, lpeer, michal.skrivanek, oourfali, rgolan, Rhev-m-bugs, tdosek, yaliu, yeylon, ykaul
Target Milestone: ---Keywords: ZStream
Target Release: 3.2.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: virt
Fixed In Version: sf14 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 956743 (view as bug list) Environment:
Last Closed: 2013-06-10 21:40:13 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 947069, 956743    
Attachments:
Description Flags
transaction error none

Description Yair Zaslavsky 2013-04-04 13:42:57 UTC 
Description of problem:

In a deployment with more than 1000 VMs a transaction error occurred during CreateSnapshotFromTemplate command (a child command of AddVmCommand) -

.common.asynctasks.AsyncTaskParameters), polling hasn't started yet..
2013-03-02 20:42:43,884 ERROR [org.ovirt.engine.core.bll.CreateSnapshotFromTemplateCommand] (pool-3-thread-45) [1af3d2eb] Command org.ovirt.engine.core.bll.CreateSnapshotFromTemplateCommand throw exception: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000460: Error checking for a transaction
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE]
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1001) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE]
        at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1064) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE]
        at org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:388) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE]
        at org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:351) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE]
        at org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:181) [spring-jdbc-3.1.1.RELEASE.jar:3.1.1.RELEASE]
        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.BaseImagesCommand.AddDiskImageToDb(BaseImagesCommand.java:299) [engine-bll.jar:]
        at org.ovirt.engine.core.bll.CreateSnapshotCommand.executeCommand(CreateSnapshotCommand.java:56) [engine-bll.jar:]
        at org.ovirt.engine.core.bll.CommandBase.executeWithoutTransaction(CommandBase.java:876) [engine-bll.jar:]
        at org.ovirt.engine.core.bll.CommandBase.executeActionInTransactionScope(CommandBase.java:973) [engine-bll.jar:]




Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.
  
Actual results:


Expected results:


Additional info:
Comment 1 Yair Zaslavsky 2013-04-04 13:46:38 UTC 
Created attachment 731596 [details]
transaction error
Comment 5 Yair Zaslavsky 2013-04-08 11:18:55 UTC 
More information - this happened during AddVmPoolWithVms command.
Comment 10 Leonid Natapov 2013-05-06 13:16:58 UTC 
sf15. tested with 200 Vms. No transaction error. Pool wit 200 Vms was successfully created.
Comment 14 errata-xmlrpc 2013-06-10 21:40:13 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHSA-2013-0888.html