javax.persistence.PersistenceException: ERROR executing DML bindLog[] error[CONSTRAINT 'ck_n4user_state' failed for 'yona'.'n4user']

GitHub | enchantor | 4 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    GitHub comment 614#199984365

    GitHub | 1 year ago | ksperling
    javax.persistence.PersistenceException: Matches for the concatinated key columns where not found? I expect that the concatinated key was null, and this bean does not have ManyToOne assoc beans matching the primary key columns?
  2. 0

    Re: [ebean] Saving Object Graph with One-to-Many Relationship Fails

    Google Groups | 5 years ago | Josh Kamau
    javax.persistence.OptimisticLockException: Data has changed. updated [0] rows sql[delete from order_item where uuid=? and version=?] bind[Binding Delete [order_item] where[uuid=8463813c-5369-461a-a9be-345fc051dd26, version=null, ]]
  3. 0

    javax.persistence.OptimisticLockException: Data has changed. updated [0] rows

    Google Groups | 6 years ago | Thomas Zangl
    javax.persistence.OptimisticLockException: Data has changed. updated [0] rows
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    how to implement a base model for all models in play using ebean?

    Stack Overflow | 3 years ago | gaols
    java.lang.NoSuchMethodError: models.Order._ebean_getni_updatedAt()Ljava/util/Date;
  6. 0

    GitHub comment 167#48894679

    GitHub | 3 years ago | rbygrave
    javax.persistence.OptimisticLockException: Data has changed. updated [0] rows sql[update order_items set product_variant_uuid=?, amount=?, order_uuid=? where uuid=?] bind[null]
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

    CONSTRAINT 'ck_n4user_state' failed for 'yona'.'n4user'

    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.executeUpdate
    1. org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:279)
    2. org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:369)
    3. org.mariadb.jdbc.MariaDbServerPreparedStatement.executeUpdate(MariaDbServerPreparedStatement.java:347)
    3 frames
  4. BoneCP :: Core Library
    PreparedStatementHandle.executeUpdate
    1. com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:205)
    1 frame
  5. avaje-ebeanorm
    Ebean.save
    1. com.avaje.ebeaninternal.server.type.DataBind.executeUpdate(DataBind.java:55)
    2. com.avaje.ebeaninternal.server.persist.dml.InsertHandler.execute(InsertHandler.java:134)
    3. com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:86)
    4. com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.insert(DmlBeanPersister.java:57)
    5. com.avaje.ebeaninternal.server.persist.DefaultPersistExecute.executeInsertBean(DefaultPersistExecute.java:66)
    6. com.avaje.ebeaninternal.server.core.PersistRequestBean.executeNow(PersistRequestBean.java:448)
    7. com.avaje.ebeaninternal.server.core.PersistRequestBean.executeOrQueue(PersistRequestBean.java:478)
    8. com.avaje.ebeaninternal.server.persist.DefaultPersister.insert(DefaultPersister.java:331)
    9. com.avaje.ebeaninternal.server.persist.DefaultPersister.saveEnhanced(DefaultPersister.java:306)
    10. com.avaje.ebeaninternal.server.persist.DefaultPersister.saveRecurse(DefaultPersister.java:276)
    11. com.avaje.ebeaninternal.server.persist.DefaultPersister.save(DefaultPersister.java:244)
    12. com.avaje.ebeaninternal.server.core.DefaultServer.save(DefaultServer.java:1801)
    13. com.avaje.ebeaninternal.server.core.DefaultServer.save(DefaultServer.java:1779)
    14. com.avaje.ebean.Ebean.save(Ebean.java:526)
    15. com.avaje.ebean.Ebean.save(Ebean.java:533)
    15 frames
  6. utils
    YamlUtil.insertDataFromYaml
    1. utils.YamlUtil.insertDataFromYaml(YamlUtil.java:45)
    1 frame
  7. Unknown
    Global.onStart
    1. Global.insertInitialData(Global.java:161)
    2. Global.onStart(Global.java:139)
    2 frames
  8. Play
    Play$$anonfun$start$1$$anonfun$apply$mcV$sp$1.apply
    1. play.core.j.JavaGlobalSettingsAdapter.onStart(JavaGlobalSettingsAdapter.scala:22)
    2. play.api.GlobalPlugin.onStart(GlobalSettings.scala:220)
    3. play.api.Play$$anonfun$start$1$$anonfun$apply$mcV$sp$1.apply(Play.scala:91)
    4. play.api.Play$$anonfun$start$1$$anonfun$apply$mcV$sp$1.apply(Play.scala:91)
    4 frames
  9. Scala
    List.foreach
    1. scala.collection.immutable.List.foreach(List.scala:318)
    1 frame
  10. Play
    StaticApplication.<init>
    1. play.api.Play$$anonfun$start$1.apply$mcV$sp(Play.scala:91)
    2. play.api.Play$$anonfun$start$1.apply(Play.scala:91)
    3. play.api.Play$$anonfun$start$1.apply(Play.scala:91)
    4. play.utils.Threads$.withContextClassLoader(Threads.scala:21)
    5. play.api.Play$.start(Play.scala:90)
    6. play.core.StaticApplication.<init>(ApplicationProvider.scala:55)
    6 frames
  11. Play Server
    NettyServer$$anonfun$main$3.apply
    1. play.core.server.NettyServer$.createServer(NettyServer.scala:253)
    2. play.core.server.NettyServer$$anonfun$main$3.apply(NettyServer.scala:289)
    3. play.core.server.NettyServer$$anonfun$main$3.apply(NettyServer.scala:284)
    3 frames
  12. Scala
    Option.map
    1. scala.Option.map(Option.scala:145)
    1 frame
  13. Play Server
    NettyServer.main
    1. play.core.server.NettyServer$.main(NettyServer.scala:284)
    2. play.core.server.NettyServer.main(NettyServer.scala)
    2 frames