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'

GitHub | tonovation | 5 months ago
  1. 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'
  2. 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`))]]]
  3. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  6. 0

    Deadlock found when trying to get lock; try restarting transaction errors found when trying to update hosts.

    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

      Duplicate entry 'Language-TeX' for key 'uq_label_1'

      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)
      2. org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:592)
      2 frames
    3. mariadb-java-client
      MariaDbServerPreparedStatement.executeBatch
      1. org.mariadb.jdbc.MariaDbServerPreparedStatement.executeBatch(MariaDbServerPreparedStatement.java:228)
      1 frame
    4. BoneCP :: Core Library
      StatementHandle.executeBatch
      1. com.jolbox.bonecp.StatementHandle.executeBatch(StatementHandle.java:424)
      1 frame
    5. Spring Framework
      JdbcTemplate.batchUpdate
      1. org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005)
      2. org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989)
      3. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
      4. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673)
      5. org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989)
      5 frames
    6. data
      DataService.importData
      1. data.DefaultExchanger.batchUpdate(DefaultExchanger.java:319)
      2. data.DefaultExchanger.importDataFromArray(DefaultExchanger.java:307)
      3. data.DefaultExchanger.importData(DefaultExchanger.java:255)
      4. data.DataService.importData(DataService.java:196)
      4 frames
    7. controllers
      SiteApp.importData
      1. controllers.SiteApp.importData(SiteApp.java:314)
      1 frame
    8. Unknown
      Routes$$anonfun$routes$1$$anonfun$applyOrElse$54$$anonfun$apply$54.apply
      1. Routes$$anonfun$routes$1$$anonfun$applyOrElse$54$$anonfun$apply$54.apply(routes_routing.scala:2058)
      2. Routes$$anonfun$routes$1$$anonfun$applyOrElse$54$$anonfun$apply$54.apply(routes_routing.scala:2058)
      2 frames
    9. Play
      JavaAction$$anon$1.call
      1. play.core.Router$HandlerInvokerFactory$$anon$4.resultCall(Router.scala:264)
      2. play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.invocation(Router.scala:255)
      3. play.core.j.JavaAction$$anon$1.call(JavaAction.scala:55)
      3 frames
    10. Unknown
      Global$1.call
      1. Global$1.call(Global.java:190)
      1 frame
    11. actions
      AnonymousCheckAction.call
      1. actions.AnonymousCheckAction.call(AnonymousCheckAction.java:57)
      1 frame
    12. utils
      SiteManagerAuthAction.call
      1. utils.SiteManagerAuthAction.call(SiteManagerAuthAction.java:39)
      1 frame
    13. Play
      JavaAction$$anonfun$11.apply
      1. play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82)
      2. play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82)
      2 frames
    14. Scala
      Future$PromiseCompletingRunnable.run
      1. scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24)
      2. scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24)
      2 frames
    15. Play
      HttpExecutionContext$$anon$2.run
      1. play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:40)
      1 frame
    16. Play Iteratees
      Execution$trampoline$.execute
      1. play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46)
      1 frame
    17. Play
      HttpExecutionContext.execute
      1. play.core.j.HttpExecutionContext.execute(HttpExecutionContext.scala:32)
      1 frame
    18. Scala
      Future$.apply
      1. scala.concurrent.impl.Future$.apply(Future.scala:31)
      2. scala.concurrent.Future$.apply(Future.scala:485)
      2 frames
    19. Play
      Action$$anonfun$apply$1$$anonfun$apply$4.apply
      1. play.core.j.JavaAction$class.apply(JavaAction.scala:82)
      2. play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.apply(Router.scala:252)
      3. play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130)
      4. play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130)
      5. play.utils.Threads$.withContextClassLoader(Threads.scala:21)
      6. play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:129)
      7. play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:128)
      7 frames
    20. Scala
      Option.map
      1. scala.Option.map(Option.scala:145)
      1 frame
    21. Play
      Action$$anonfun$apply$1.apply
      1. play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:128)
      2. play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:121)
      2 frames
    22. Play Iteratees
      Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply
      1. play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483)
      2. play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483)
      3. play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519)
      4. play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519)
      5. play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496)
      6. play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496)
      6 frames
    23. Scala
      Future$PromiseCompletingRunnable.run
      1. scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24)
      2. scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24)
      2 frames
    24. Akka Actor
      ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec
      1. akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41)
      2. akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393)
      2 frames
    25. Scala
      ForkJoinWorkerThread.run
      1. scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
      2. scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
      3. scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
      4. scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
      4 frames