play.api.Application$$anon$1: Execution exception[[PersistenceException: ERROR executing DML bindLog[] error[Cannot delete or update a parent row: a foreign key constraint fails (`yona`.`project_visitation`, CONSTRAINT `fk_project_visitation_project_31` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`))]]]

GitHub | pokev25 | 5 months ago
  1. 0

    프로젝트 삭제 오류

    GitHub | 5 months ago | pokev25
    play.api.Application$$anon$1: Execution exception[[PersistenceException: ERROR executing DML bindLog[] error[Cannot delete or update a parent row: a foreign key constraint fails (`yona`.`project_visitation`, CONSTRAINT `fk_project_visitation_project_31` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`))]]]
  2. 0

    [Sponge SQL] Foreign key error on using set group.

    GitHub | 4 months ago | cartman-2000
    java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`mc_pex`.`pex_inheritance`, CONSTRAINT `inheritance_segment_fk` FOREIGN KEY (`segment`) REFERENCES `pex_segments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) Query is: INSERT INTO pex_inheritance (`segment`, `parent`) VALUES (?, ?)
  3. 0

    yobi0.8.2 -> yona1.0.0 마이그레이션 시 에러발생

    GitHub | 5 months ago | tonovation
    org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [INSERT INTO LABEL (ID, NAME, CATEGORY) VALUES (?, ?, ?)]; Duplicate entry 'Language-TeX' for key 'uq_label_1'; nested exception is java.sql.BatchUpdateException: Duplicate entry 'Language-TeX' for key 'uq_label_1'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Exceceptions seen when instances are started.

    GitHub | 9 months ago | sangeethah
    org.jooq.exception.DataAccessException: SQL [update `config_item_status` set `config_item_status`.`requested_version` = (`config_item_status`.`requested_version` + ?), `config_item_status`.`requested_updated` = ? where (`config_item_status`.`name` = ? and `config_item_status`.`resource_type` = ? and `config_item_status`.`resource_id` = ?)]; Deadlock found when trying to get lock; try restarting transaction
  6. 0

    "Deadlock found when trying to get lock; try restarting transaction" seen in logs.

    GitHub | 8 months ago | sangeethah
    org.jooq.exception.DataAccessException: SQL [update `host` set `host`.`data` = ? where `host`.`id` = ?]; Deadlock found when trying to get lock; try restarting transaction

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.mariadb.jdbc.internal.util.dao.QueryException

      Cannot delete or update a parent row: a foreign key constraint fails (`yona`.`project_visitation`, CONSTRAINT `fk_project_visitation_project_31` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`))

      at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult()
    2. org.mariadb.jdbc
      AbstractQueryProtocol.executePreparedQuery
      1. org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:479)[org.mariadb.jdbc.mariadb-java-client-1.3.6.jar:na]
      2. org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:592)[org.mariadb.jdbc.mariadb-java-client-1.3.6.jar:na]
      2 frames
    3. mariadb-java-client
      MariaDbServerPreparedStatement.executeUpdate
      1. org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:279)[org.mariadb.jdbc.mariadb-java-client-1.3.6.jar:na]
      2. org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:369)[org.mariadb.jdbc.mariadb-java-client-1.3.6.jar:na]
      3. org.mariadb.jdbc.MariaDbServerPreparedStatement.executeUpdate(MariaDbServerPreparedStatement.java:347)[org.mariadb.jdbc.mariadb-java-client-1.3.6.jar:na]
      3 frames
    4. BoneCP :: Core Library
      PreparedStatementHandle.executeUpdate
      1. com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:205)[com.jolbox.bonecp-0.8.0.RELEASE.jar:na]
      1 frame
    5. avaje-ebeanorm
      Ebean.delete
      1. com.avaje.ebeaninternal.server.type.DataBind.executeUpdate(DataBind.java:55)[org.avaje.ebeanorm.avaje-ebeanorm-3.3.4.jar:na]
      2. com.avaje.ebeaninternal.server.persist.dml.DeleteHandler.execute(DeleteHandler.java:53)[org.avaje.ebeanorm.avaje-ebeanorm-3.3.4.jar:na]
      3. com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:86)[org.avaje.ebeanorm.avaje-ebeanorm-3.3.4.jar:na]
      4. com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.delete(DmlBeanPersister.java:48)[org.avaje.ebeanorm.avaje-ebeanorm-3.3.4.jar:na]
      5. com.avaje.ebeaninternal.server.persist.DefaultPersistExecute.executeDeleteBean(DefaultPersistExecute.java:99)[org.avaje.ebeanorm.avaje-ebeanorm-3.3.4.jar:na]
      6. com.avaje.ebeaninternal.server.core.PersistRequestBean.executeNow(PersistRequestBean.java:456)[org.avaje.ebeanorm.avaje-ebeanorm-3.3.4.jar:na]
      7. com.avaje.ebeaninternal.server.core.PersistRequestBean.executeOrQueue(PersistRequestBean.java:478)[org.avaje.ebeanorm.avaje-ebeanorm-3.3.4.jar:na]
      8. com.avaje.ebeaninternal.server.persist.DefaultPersister.delete(DefaultPersister.java:592)[org.avaje.ebeanorm.avaje-ebeanorm-3.3.4.jar:na]
      9. com.avaje.ebeaninternal.server.persist.DefaultPersister.delete(DefaultPersister.java:396)[org.avaje.ebeanorm.avaje-ebeanorm-3.3.4.jar:na]
      10. com.avaje.ebeaninternal.server.core.DefaultServer.delete(DefaultServer.java:1867)[org.avaje.ebeanorm.avaje-ebeanorm-3.3.4.jar:na]
      11. com.avaje.ebeaninternal.server.core.DefaultServer.delete(DefaultServer.java:1857)[org.avaje.ebeanorm.avaje-ebeanorm-3.3.4.jar:na]
      12. com.avaje.ebean.Ebean.delete(Ebean.java:596)[org.avaje.ebeanorm.avaje-ebeanorm-3.3.4.jar:na]
      12 frames
    6. Play Ebean
      Model.delete
      1. play.db.ebean.Model.delete(Model.java:171)[com.typesafe.play.play-java-ebean_2.10-2.3.6.jar:2.3.6]
      1 frame
    7. models
      Project.delete
      1. models.Project.delete(Project.java:674)[yona.yona-1.0.2.jar:1.0.2]
      1 frame
    8. controllers
      ProjectApp.deleteProject
      1. controllers.ProjectApp.deleteProject(ProjectApp.java:342)[yona.yona-1.0.2.jar:1.0.2]
      1 frame
    9. Unknown
      Routes$$anonfun$routes$1$$anonfun$applyOrElse$103$$anonfun$apply$103.apply
      1. Routes$$anonfun$routes$1$$anonfun$applyOrElse$103$$anonfun$apply$103.apply(routes_routing.scala:2450)[yona.yona-1.0.2.jar:na]
      2. Routes$$anonfun$routes$1$$anonfun$applyOrElse$103$$anonfun$apply$103.apply(routes_routing.scala:2450)[yona.yona-1.0.2.jar:na]
      2 frames
    10. Play
      JavaAction$$anon$1.call
      1. play.core.Router$HandlerInvokerFactory$$anon$4.resultCall(Router.scala:264)[com.typesafe.play.play_2.10-2.3.6.jar:2.3.6]
      2. play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.invocation(Router.scala:255)[com.typesafe.play.play_2.10-2.3.6.jar:2.3.6]
      3. play.core.j.JavaAction$$anon$1.call(JavaAction.scala:55)[com.typesafe.play.play_2.10-2.3.6.jar:2.3.6]
      3 frames
    11. Unknown
      Global$1.call
      1. Global$1.call(Global.java:190)[yona.yona-1.0.2.jar:na]
      1 frame
    12. actions
      AbstractProjectCheckAction.call
      1. actions.AnonymousCheckAction.call(AnonymousCheckAction.java:57)[yona.yona-1.0.2.jar:1.0.2]
      2. actions.IsAllowedAction.call(IsAllowedAction.java:69)[yona.yona-1.0.2.jar:1.0.2]
      3. actions.AbstractProjectCheckAction.call(AbstractProjectCheckAction.java:85)[yona.yona-1.0.2.jar:1.0.2]
      3 frames
    13. Play Ebean
      TransactionalAction$1.call
      1. play.db.ebean.TransactionalAction$1.call(TransactionalAction.java:21)[com.typesafe.play.play-java-ebean_2.10-2.3.6.jar:2.3.6]
      2. play.db.ebean.TransactionalAction$1.call(TransactionalAction.java:18)[com.typesafe.play.play-java-ebean_2.10-2.3.6.jar:2.3.6]
      2 frames
    14. avaje-ebeanorm
      Ebean.execute
      1. com.avaje.ebeaninternal.server.core.DefaultServer.execute(DefaultServer.java:715)[org.avaje.ebeanorm.avaje-ebeanorm-3.3.4.jar:na]
      2. com.avaje.ebeaninternal.server.core.DefaultServer.execute(DefaultServer.java:709)[org.avaje.ebeanorm.avaje-ebeanorm-3.3.4.jar:na]
      3. com.avaje.ebean.Ebean.execute(Ebean.java:1264)[org.avaje.ebeanorm.avaje-ebeanorm-3.3.4.jar:na]
      3 frames
    15. Play Ebean
      TransactionalAction.call
      1. play.db.ebean.TransactionalAction.call(TransactionalAction.java:18)[com.typesafe.play.play-java-ebean_2.10-2.3.6.jar:2.3.6]
      1 frame
    16. Play
      JavaAction$$anonfun$11.apply
      1. play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82)[com.typesafe.play.play_2.10-2.3.6.jar:2.3.6]
      2. play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82)[com.typesafe.play.play_2.10-2.3.6.jar:2.3.6]
      2 frames
    17. Scala
      Future$PromiseCompletingRunnable.run
      1. scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24)[org.scala-lang.scala-library-2.10.4.jar:na]
      2. scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24)[org.scala-lang.scala-library-2.10.4.jar:na]
      2 frames
    18. Play
      HttpExecutionContext$$anon$2.run
      1. play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:40)[com.typesafe.play.play_2.10-2.3.6.jar:2.3.6]
      1 frame
    19. Play Iteratees
      Execution$trampoline$.execute
      1. play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46)[com.typesafe.play.play-iteratees_2.10-2.3.6.jar:2.3.6]
      1 frame
    20. Play
      HttpExecutionContext.execute
      1. play.core.j.HttpExecutionContext.execute(HttpExecutionContext.scala:32)[com.typesafe.play.play_2.10-2.3.6.jar:2.3.6]
      1 frame
    21. Scala
      Future$.apply
      1. scala.concurrent.impl.Future$.apply(Future.scala:31)[org.scala-lang.scala-library-2.10.4.jar:na]
      2. scala.concurrent.Future$.apply(Future.scala:485)[org.scala-lang.scala-library-2.10.4.jar:na]
      2 frames
    22. Play
      Action$$anonfun$apply$1$$anonfun$apply$4.apply
      1. play.core.j.JavaAction$class.apply(JavaAction.scala:82)[com.typesafe.play.play_2.10-2.3.6.jar:2.3.6]
      2. play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.apply(Router.scala:252)[com.typesafe.play.play_2.10-2.3.6.jar:2.3.6]
      3. play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130)[com.typesafe.play.play_2.10-2.3.6.jar:2.3.6]
      4. play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130)[com.typesafe.play.play_2.10-2.3.6.jar:2.3.6]
      5. play.utils.Threads$.withContextClassLoader(Threads.scala:21)[com.typesafe.play.play_2.10-2.3.6.jar:2.3.6]
      6. play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:129)[com.typesafe.play.play_2.10-2.3.6.jar:2.3.6]
      7. play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:128)[com.typesafe.play.play_2.10-2.3.6.jar:2.3.6]
      7 frames
    23. Scala
      Option.map
      1. scala.Option.map(Option.scala:145)[org.scala-lang.scala-library-2.10.4.jar:na]
      1 frame
    24. Play
      Action$$anonfun$apply$1.apply
      1. play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:128)[com.typesafe.play.play_2.10-2.3.6.jar:2.3.6]
      2. play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:121)[com.typesafe.play.play_2.10-2.3.6.jar:2.3.6]
      2 frames
    25. Play Iteratees
      Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply
      1. play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483)[com.typesafe.play.play-iteratees_2.10-2.3.6.jar:2.3.6]
      2. play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483)[com.typesafe.play.play-iteratees_2.10-2.3.6.jar:2.3.6]
      3. play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519)[com.typesafe.play.play-iteratees_2.10-2.3.6.jar:2.3.6]
      4. play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519)[com.typesafe.play.play-iteratees_2.10-2.3.6.jar:2.3.6]
      5. play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496)[com.typesafe.play.play-iteratees_2.10-2.3.6.jar:2.3.6]
      6. play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496)[com.typesafe.play.play-iteratees_2.10-2.3.6.jar:2.3.6]
      6 frames
    26. Scala
      Future$PromiseCompletingRunnable.run
      1. scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24)[org.scala-lang.scala-library-2.10.4.jar:na]
      2. scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24)[org.scala-lang.scala-library-2.10.4.jar:na]
      2 frames
    27. Akka Actor
      ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec
      1. akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41)[com.typesafe.akka.akka-actor_2.10-2.3.4.jar:na]
      2. akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393)[com.typesafe.akka.akka-actor_2.10-2.3.4.jar:na]
      2 frames
    28. Scala
      ForkJoinWorkerThread.run
      1. scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)[org.scala-lang.scala-library-2.10.4.jar:na]
      2. scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)[org.scala-lang.scala-library-2.10.4.jar:na]
      3. scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)[org.scala-lang.scala-library-2.10.4.jar:na]
      4. scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)[org.scala-lang.scala-library-2.10.4.jar:na]
      4 frames