javax.persistence.PersistenceException: ERROR executing DML bindLog[] error[[SQLITE_CONSTRAINT] Abort due to constraint violation (PRIMARY KEY must be unique)]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via GitHub by andris155
, 1 year ago
ERROR executing DML bindLog[] error[[SQLITE_CONSTRAINT] Abort due to constraint violation (PRIMARY KEY must be unique)]
via avaje.org by Unknown author, 2 years ago
ERROR executing DML bindLog[Binding Insert [list_data] set[listId=1, name=test, ]] error[Duplicate entry '1' for key 1]
via Google Groups by sunkid, 6 months ago
ERROR executing DML bindLog[Binding Insert [list_data] set[listId=1, name=test, ]] error[Duplicate entry '1' for key 1]
via GitHub by PinoyLifeCraft
, 1 year ago
ERROR executing DML bindLog[] error[assertion failure: param count (11) != value count (22)]
via GitHub by Dimatert9
, 1 year ago
ERROR executing DML bindLog[] error[[SQLITE_CONSTRAINT_PRIMARYKEY] A PRIMARY KEY constraint failed (UNIQUE constraint failed: player_stats.id)]
via Google Groups by Juan, 6 months ago
ERROR executing DML bindLog[] error[Violación de indice de Unicidad ó Clave primaria: "PRIMARY_KEY_5 ON PUBLIC.LOCATIONS(ID)"\n Unique index or primary key violation: "PRIMARY_KEY_5 ON PUBLIC.LOCATIONS(ID)"; SQL statement:\n insert into locations (id, slug, parent_location_id) values (?,?,?) [23505-157]]
java.sql.SQLException: [SQLITE_CONSTRAINT] Abort due to constraint violation (PRIMARY KEY must be unique)
at org.sqlite.DB.newSQLException(DB.java:383)
at org.sqlite.DB.newSQLException(DB.java:387)
at org.sqlite.DB.execute(DB.java:342)
at org.sqlite.DB.executeUpdate(DB.java:363)
at org.sqlite.PrepStmt.executeUpdate(PrepStmt.java:85)
at com.avaje.ebeaninternal.server.lib.sql.ExtendedPreparedStatement.executeUpdate(ExtendedPreparedStatement.java:164)
at com.avaje.ebeaninternal.server.type.DataBind.executeUpdate(DataBind.java:74)
at com.avaje.ebeaninternal.server.persist.dml.InsertHandler.execute(InsertHandler.java:158)
at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:105)
at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.insert(DmlBeanPersister.java:76)
at com.avaje.ebeaninternal.server.persist.DefaultPersistExecute.executeInsertBean(DefaultPersistExecute.java:91)
at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeNow(PersistRequestBean.java:500)
at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeOrQueue(PersistRequestBean.java:530)
at com.avaje.ebeaninternal.server.persist.DefaultPersister.insert(DefaultPersister.java:406)
at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveVanillaInsert(DefaultPersister.java:377)
at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveVanillaRecurse(DefaultPersister.java:361)
at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveRecurse(DefaultPersister.java:308)
at com.avaje.ebeaninternal.server.persist.DefaultPersister.save(DefaultPersister.java:282)
at com.avaje.ebeaninternal.server.core.DefaultServer.save(DefaultServer.java:1820)
at com.github.games647.scoreboardstats.pvpstats.Database.lambda$setupDatabase$2(Database.java:227)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

36 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.