Hi all,
after uploading a large file (5GB) to my GN (GN 3.12.7, Tomcat 8 on Ubuntu and external postgres) I find the following error in my gui (screenshot) and logs:
ERROR rolling back transaction
org.springframework.transaction.TransactionSystemException: Could not roll back JPA transaction; nested exception is javax.persistence.PersistenceException: unexpected error when rollbacking
Caused by: javax.persistence.PersistenceException: unexpected error when rollbacking
at org.hibernate.jpa.internal.TransactionImpl.rollback(TransactionImpl.java:111)
at org.springframework.orm.jpa.JpaTransactionManager.doRollback(JpaTransactionManager.java:544)
... 91 more
Caused by: org.hibernate.TransactionException: rollback failed
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)
at org.hibernate.jpa.internal.TransactionImpl.rollback(TransactionImpl.java:108)
... 92 more
Caused by: org.hibernate.TransactionException: unable to rollback against JDBC connection
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)
... 93 more
Caused by: java.sql.SQLException: Connection PoolingConnection: null is closed.
at org.apache.commons.dbcp2.DelegatingConnection.checkOpen(DelegatingConnection.java:594)
at org.apache.commons.dbcp2.DelegatingConnection.rollback(DelegatingConnection.java:471)
at org.apache.commons.dbcp2.DelegatingConnection.rollback(DelegatingConnection.java:473)
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)
... 94 more
Is this related to the quite big filesize?
Any help is much appreciated.
Thanks and kind regards
Andreas
It could be related to a closed database connection due to a long time used for uploading such a big file.
https://www.geocat.net
Juan Luis Rodriguez Ponce
Mobile:
E-mail: juanluisrp@anonymised.com
https://www.geocat.net
Veenderweg 13
6721 WD Bennekom
The Netherlands
Tel: +31318416664
#
---- On Wed, 09 Nov 2022 15:21:45 +0100 Andreas Böhme via GeoNetwork-users <geonetwork-users@lists.sourceforge.net> wrote ---
Hi all,
after uploading a large file (5GB) to my GN (GN 3.12.7, Tomcat 8 on
Ubuntu and external postgres) I find the following error in my gui
(screenshot) and logs:
ERROR rolling back transaction
org.springframework.transaction.TransactionSystemException: Could not
roll back JPA transaction; nested exception is
javax.persistence.PersistenceException: unexpected error when rollbacking
Caused by: javax.persistence.PersistenceException: unexpected error when
rollbacking
at
org.hibernate.jpa.internal.TransactionImpl.rollback(TransactionImpl.java:111)
at
org.springframework.orm.jpa.JpaTransactionManager.doRollback(JpaTransactionManager.java:544)
... 91 more
Caused by: org.hibernate.TransactionException: rollback failed
at
org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)
at
org.hibernate.jpa.internal.TransactionImpl.rollback(TransactionImpl.java:108)
... 92 more
Caused by: org.hibernate.TransactionException: unable to rollback
against JDBC connection
at
org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)
at
org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)
... 93 more
Caused by: java.sql.SQLException: Connection PoolingConnection: null is
closed.
at
org.apache.commons.dbcp2.DelegatingConnection.checkOpen(DelegatingConnection.java:594)
at
org.apache.commons.dbcp2.DelegatingConnection.rollback(DelegatingConnection.java:471)
at
org.apache.commons.dbcp2.DelegatingConnection.rollback(DelegatingConnection.java:473)
at
org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)
... 94 more
Is this related to the quite big filesize?
Any help is much appreciated.
Thanks and kind regards
Andreas
_______________________________________________
GeoNetwork-users mailing list
mailto:GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork