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 Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs