[Bug 588802] [NEW] Unable to create a new volume from a snapshot

[Carlos Perelló Marín]

Public bug reported:

We are no able to create a new volume based on an existing snapshot.

We tried using bigger volumes than the original volume from where the
snapshot was created and also using the same size, but in both cases, we
get the same error:

17:56:11 [JDBCExceptionReporter:pool-10-thread-1]  ERROR Couldn't perform the operation prepareStatement: You can't perform any operations on this connection. It has been automatica
lly closed by Proxool for some reason (see logs).
17:56:11 [AbstractFlushingEventListener:pool-10-thread-1]  ERROR Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not insert: [edu.ucsb.eucalyptus.cloud.entities.AOEVolumeInfo]
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2295)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2688)
        at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
        at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
        at com.eucalyptus.util.TxHandle.commit(TxHandle.java:104)
        at com.eucalyptus.util.EntityWrapper.commit(EntityWrapper.java:173)        at edu.ucsb.eucalyptus.storage.LVM2Manager$VolumeEntityWrapperManager.finish(LVM2Manager.java:952)
        at edu.ucsb.eucalyptus.storage.LVM2Manager$VolumeEntityWrapperManager.access$400(LVM2Manager.java:841)
        at edu.ucsb.eucalyptus.storage.LVM2Manager.createVolume(LVM2Manager.java:507)
        at edu.ucsb.eucalyptus.cloud.ws.BlockStorage$VolumeCreator.run(BlockStorage.java:779)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:636)
Caused by: java.sql.SQLException: Couldn't perform the operation prepareStatement: You can't perform any operations on this connection. It has been automatically closed by Proxool f
or some reason (see logs).
        at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:207)
        at $Proxy27.prepareStatement(Unknown Source)        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:116)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
        at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252)
        ... 20 more
17:56:11 [JDBCTransaction:pool-10-thread-1]  ERROR Could not toggle autocommit
java.sql.SQLException: Couldn't perform the operation setAutoCommit: You can't perform any operations on this connection. It has been automatically closed by Proxool for some reason
 (see logs).
        at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:207)
        at $Proxy27.setAutoCommit(Unknown Source)
        at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:228)
        at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:220)
        at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:196)
        at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:66)
        at com.eucalyptus.util.TxHandle.commit(TxHandle.java:104)
        at com.eucalyptus.util.EntityWrapper.commit(EntityWrapper.java:173)
        at edu.ucsb.eucalyptus.storage.LVM2Manager$VolumeEntityWrapperManager.finish(LVM2Manager.java:952)
        at edu.ucsb.eucalyptus.storage.LVM2Manager$VolumeEntityWrapperManager.access$400(LVM2Manager.java:841)
        at edu.ucsb.eucalyptus.storage.LVM2Manager.createVolume(LVM2Manager.java:507)
        at edu.ucsb.eucalyptus.cloud.ws.BlockStorage$VolumeCreator.run(BlockStorage.java:779)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:636)
17:56:11 [JDBCTransaction:pool-10-thread-1]  ERROR JDBC rollback failed
java.sql.SQLException: Couldn't perform the operation rollback: You can't perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).
        at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:207)
        at $Proxy27.rollback(Unknown Source)
        at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:217)
        at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:196)
        at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:66)
        at com.eucalyptus.util.TxHandle.commit(TxHandle.java:104)
        at com.eucalyptus.util.EntityWrapper.commit(EntityWrapper.java:173)
        at edu.ucsb.eucalyptus.storage.LVM2Manager$VolumeEntityWrapperManager.finish(LVM2Manager.java:952)
        at edu.ucsb.eucalyptus.storage.LVM2Manager$VolumeEntityWrapperManager.access$400(LVM2Manager.java:841)
        at edu.ucsb.eucalyptus.storage.LVM2Manager.createVolume(LVM2Manager.java:507)
        at edu.ucsb.eucalyptus.cloud.ws.BlockStorage$VolumeCreator.run(BlockStorage.java:779)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:636)


I looked into all Eucalyptus logs at /var/log/eucalyptus, but I didn't find anything about Proxool, except for other errors similar to this one.

I'm using Ubuntu 10.04 with a fresh installation of Eucalyptus.

** Affects: eucalyptus (Ubuntu)
     Importance: Undecided
         Status: New

-- 
Unable to create a new volume from a snapshot
https://bugs.launchpad.net/bugs/588802
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to eucalyptus in ubuntu.