Cascaded Delete from /applicationInstance of running BeWan Application
ERROR SqlExceptionHelper Cannot delete or update a parent row: a foreign key constraint fails (execWareFrontend
.Instance
, CONSTRAINT FK_1b0amajp7xfy30jc6tgmh2txr
FOREIGN KEY (applicationInstance_id
) REFERENCES ApplicationInstance
(id
))
[error] application -
! @6opo1jg9c - Internal server error, for (DELETE) [/api/applicationInstance/1] ->
play.api.Application$$anon$1: Execution exception[[RollbackException: Error while committing the transaction]]
at play.api.Application$class.handleError(Application.scala:296) ~[com.typesafe.play.play_2.10-2.3.9.jar:2.3.9]
at play.api.DefaultApplication.handleError(Application.scala:402) [com.typesafe.play.play_2.10-2.3.9.jar:2.3.9]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun14
$anonfun$apply$1.applyOrElse(PlayDefaultUpstreamHandler.scala:205) [com.typesafe.play.play_2.10-2.3.9.jar:2.3.9]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun14
$anonfun$apply$1.applyOrElse(PlayDefaultUpstreamHandler.scala:202) [com.typesafe.play.play_2.10-2.3.9.jar:2.3.9]
at scala.runtime.AbstractPartialFunction.apply(AbstractPartialFunction.scala:33) [org.scala-lang.scala-library-2.10.4.jar:na]
Caused by: javax.persistence.RollbackException: Error while committing the transaction
at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:94) ~[org.hibernate.hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final]
at play.db.jpa.JPA$2.apply(JPA.java:193) ~[com.typesafe.play.play-java-jpa_2.10-2.3.9.jar:2.3.9]
at play.core.j.FPromiseHelper$anonfun
map$1.apply(FPromiseHelper.scala:98) ~[com.typesafe.play.play_2.10-2.3.9.jar:2.3.9]
at scala.util.Success$anonfun
map$1.apply(Try.scala:206) ~[org.scala-lang.scala-library-2.10.4.jar:na]
at scala.util.Try$.apply(Try.scala:161) [org.scala-lang.scala-library-2.10.4.jar:na]
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763) ~[org.hibernate.hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final]
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677) ~[org.hibernate.hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final]
at org.hibernate.jpa.internal.TransactionImpl.commit(TransactionImpl.java:82) ~[org.hibernate.hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final]
at play.db.jpa.JPA$2.apply(JPA.java:193) ~[com.typesafe.play.play-java-jpa_2.10-2.3.9.jar:2.3.9]
at play.core.j.FPromiseHelper$anonfun
map$1.apply(FPromiseHelper.scala:98) ~[com.typesafe.play.play_2.10-2.3.9.jar:2.3.9]
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:72) ~[org.hibernate.hibernate-core-4.3.5.Final.jar:4.3.5.Final]
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) ~[org.hibernate.hibernate-core-4.3.5.Final.jar:4.3.5.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) ~[org.hibernate.hibernate-core-4.3.5.Final.jar:4.3.5.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) ~[org.hibernate.hibernate-core-4.3.5.Final.jar:4.3.5.Final]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:190) ~[org.hibernate.hibernate-core-4.3.5.Final.jar:4.3.5.Final]
Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (execWareFrontend
.Instance
, CONSTRAINT FK_1b0amajp7xfy30jc6tgmh2txr
FOREIGN KEY (applicationInstance_id
) REFERENCES ApplicationInstance
(id
))
at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:132) ~[org.mariadb.jdbc.mariadb-java-client-1.1.7.jar:na]
at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) ~[org.mariadb.jdbc.mariadb-java-client-1.1.7.jar:na]
at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:264) ~[org.mariadb.jdbc.mariadb-java-client-1.1.7.jar:na]
at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:288) ~[org.mariadb.jdbc.mariadb-java-client-1.1.7.jar:na]
at org.mariadb.jdbc.MySQLStatement.executeUpdate(MySQLStatement.java:317) ~[org.mariadb.jdbc.mariadb-java-client-1.1.7.jar:na]
Caused by: org.mariadb.jdbc.internal.common.QueryException: Cannot delete or update a parent row: a foreign key constraint fails (execWareFrontend
.Instance
, CONSTRAINT FK_1b0amajp7xfy30jc6tgmh2txr
FOREIGN KEY (applicationInstance_id
) REFERENCES ApplicationInstance
(id
))
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:942) ~[org.mariadb.jdbc.mariadb-java-client-1.1.7.jar:na]
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:991) ~[org.mariadb.jdbc.mariadb-java-client-1.1.7.jar:na]
at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:281) ~[org.mariadb.jdbc.mariadb-java-client-1.1.7.jar:na]
at org.mariadb.jdbc.MySQLStatement.executeUpdate(MySQLStatement.java:317) ~[org.mariadb.jdbc.mariadb-java-client-1.1.7.jar:na]
at org.mariadb.jdbc.MySQLPreparedStatement.executeUpdate(MySQLPreparedStatement.java:156) ~[org.mariadb.jdbc.mariadb-java-client-1.1.7.jar:na]
[ERROR] [01/25/2016 16:11:21.094] [play-akka.actor.default-dispatcher-102] [akka.dispatch.Dispatcher] EntityManager is closed
java.lang.IllegalStateException: EntityManager is closed
at org.hibernate.jpa.internal.EntityManagerImpl.checkOpen(EntityManagerImpl.java:105)
at org.hibernate.jpa.internal.EntityManagerImpl.checkOpen(EntityManagerImpl.java:96)
at org.hibernate.jpa.internal.EntityManagerImpl.close(EntityManagerImpl.java:148)
at play.db.jpa.JPA$3.invoke(JPA.java:209)
at play.db.jpa.JPA$3.invoke(JPA.java:203)
at play.core.j.FPromiseHelper$anonfun
onFailure$1.applyOrElse(FPromiseHelper.scala:116)
at play.core.j.FPromiseHelper$anonfun
onFailure$1.applyOrElse(FPromiseHelper.scala:116)
at scala.concurrent.Future$anonfun
onFailure$1.apply(Future.scala:136)
at scala.concurrent.Future$anonfun
onFailure$1.apply(Future.scala:134)
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32)
at play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:40)
at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41)
at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393)
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
[error] a.d.Dispatcher - EntityManager is closed java.lang.IllegalStateException: EntityManager is closed at org.hibernate.jpa.internal.EntityManagerImpl.checkOpen(EntityManagerImpl.java:105) ~[org.hibernate.hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final] at org.hibernate.jpa.internal.EntityManagerImpl.checkOpen(EntityManagerImpl.java:96) ~[org.hibernate.hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final] at org.hibernate.jpa.internal.EntityManagerImpl.close(EntityManagerImpl.java:148) ~[org.hibernate.hibernate-entitymanager-4.3.5.Final.jar:4.3.5.Final] at play.db.jpa.JPA$3.invoke(JPA.java:209) ~[com.typesafe.play.play-java-jpa_2.10-2.3.9.jar:2.3.9] at play.db.jpa.JPA$3.invoke(JPA.java:203) ~[com.typesafe.play.play-java-jpa_2.10-2.3.9.jar:2.3.9]