org.h2.jdbc.JdbcBatchUpdateException: Unique index or primary key violation: "CONSTRAINT_INDEX_B ON PUBLIC.PEX_RANK_LADDERS(NAME, SUBJECT) VALUES ('default', 4, 4)"; SQL statement: INSERT INTO pex_rank_ladders (`name`, `subject`) VALUES (?, ?) [23505-192]

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 5igm
, 1 year ago
Unique index or primary key violation: "CONSTRAINT_INDEX_B ON PUBLIC.PEX_RANK_LADDERS(NAME, SUBJECT) VALUES ('default', 4, 4)"; SQL statement: INSERT INTO pex_rank_ladders (`name`, `subject`) VALUES (?, ?) [23505-192]
via Stack Overflow by Mançaux Pierre-Alexandre
, 1 year ago
NULL not allowed for column "ID_GARE"; SQL statement: INSERT INTO TBL_ASSOC_LANGUE_CODE_BE_GARE (CODE_BE, ID_GARE, ID_LANGUE) VALUES (?, ?, ?) [23502-192]
via Stack Overflow by user2724522
, 2 years ago
NULL not allowed for column "CUSTOMER_ID"; SQL statement**: insert into storage (custumer_id, dvd_id) values (?, ?) [23502-156]
via Google Groups by Kenton Garner, 2 years ago
Statement was canceled or the session timed out; SQL statement: DELETE CDS_HISTORY WHERE MSGDATE <= ? LIMIT 10000 [57014-182]
via Stack Overflow by Andna
, 2 years ago
Referential integrity constraint violation: "FK415AFE694BC8D057: PUBLIC.QUESTIONSET_QUESTION FOREIGN KEY(QUESTIONS_ID) REFERENCES PUBLIC.QUESTION(ID) (200)"; SQL statement: insert into QuestionSet_Question (QuestionSet_id, questions_id) values (?, ?) [23506-168]
via bukkit.org by Unknown author, 7 months ago
Hexadecimal string with odd number of char acters: "69.142.116.45"; SQL statement: INSERT INTO bbdata (date, player, action, world, x, y, z, type, data, rbacked) V ALUES (?,?,?,?,?,?,?,?,?,0) -- (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, 0) [90003-15 3]
org.h2.jdbc.JdbcBatchUpdateException: Unique index or primary key violation: "CONSTRAINT_INDEX_B ON PUBLIC.PEX_RANK_LADDERS(NAME, SUBJECT) VALUES ('default', 4, 4)"; SQL statement: INSERT INTO pex_rank_ladders (`name`, `subject`) VALUES (?, ?) [23505-192]
at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1208)
at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128)
at ninja.leaping.permissionsex.backend.sql.SqlDao.lambda$setRankLadder$8(SqlDao.java:769)
at ninja.leaping.permissionsex.backend.sql.SqlDao.executeInTransaction(SqlDao.java:224)
at ninja.leaping.permissionsex.backend.sql.SqlDao.setRankLadder(SqlDao.java:748)
at ninja.leaping.permissionsex.backend.sql.SqlDataStore.lambda$setRankLadderInternal$7(SqlDataStore.java:287)
at ninja.leaping.permissionsex.util.Util.lambda$asyncFailableFuture$1(Util.java:93)
at org.spongepowered.api.scheduler.Task$Builder.lambda$execute$0(Task.java:138)
at org.spongepowered.common.scheduler.SchedulerBase.lambda$startTask$0(SchedulerBase.java:177)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago

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