com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'XYZ' for key 'PRIMARY'

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

Samebug tips

,

Check whether privilege has the "not null" restriction. If so it always has to have a value and can never be null.

A different reason could be a wrong implementation of a foreign key. Check whether you always correctly insert/update in both tables.

,

Nothing is wrong with the database. When it gives you those errors, it's telling you that you are trying to input "nothing" (null) into a column that doesn't allow it. Fix it by removing the not null constraint or by passing a value to that field.

Solutions on the web

via GitHub by erocs
, 1 year ago
via GitHub by erocs
, 2 years ago
Duplicate entry 'UUID REMOVED' for key 'PRIMARY'
via GitHub by tinchoabbate
, 5 months ago
Cannot delete or update a parent row: **a foreign key constraint fails (`java`.`articulos_secciones`, CONSTRAINT `articulo` FOREIGN KEY (`idArticulo`) REFERENCES `articulos` (`idArticulo`) ON DELETE NO ACTION ON UPDATE NO ACTION)**
via Stack Overflow by Paul Statham
, 2 years ago
Duplicate entry '7-1' for key 'PRIMARY'
via jboss.org by Unknown author, 2 years ago
Duplicate entry 'Jane Austin' for key 'PRIMARY'
via Google Groups by praveenm, 2 years ago
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'XYZ' for key 'PRIMARY'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.Util.getInstance(Util.java:387)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:934)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2470)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2617)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2550)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1192)
at vg.civcraft.mc.bettershards.database.DatabaseManager.savePlayerData(DatabaseManager.java:327)
at vg.civcraft.mc.bettershards.misc.CustomWorldNBTStorage.save(CustomWorldNBTStorage.java:54)
at net.minecraft.server.v1_10_R1.PlayerList.savePlayerFile(PlayerList.java:315)
at net.minecraft.server.v1_10_R1.PlayerList.disconnect(PlayerList.java:389)
at net.minecraft.server.v1_10_R1.PlayerConnection.a(PlayerConnection.java:1058)
at net.minecraft.server.v1_10_R1.PlayerConnection.disconnect(PlayerConnection.java:243)
at org.bukkit.craftbukkit.v1_10_R1.entity.CraftPlayer.kickPlayer(CraftPlayer.java:218)
at fr.neatmonster.nocheatplus.command.actions.KickCommand.kick(KickCommand.java:54)
at fr.neatmonster.nocheatplus.command.actions.KickCommand.onCommand(KickCommand.java:47)
at fr.neatmonster.nocheatplus.command.NoCheatPlusCommand.onCommand(NoCheatPlusCommand.java:162)
at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
at org.bukkit.craftbukkit.v1_10_R1.CraftServer.dispatchCommand(CraftServer.java:646)
at fr.neatmonster.nocheatplus.command.actions.delay.DelayCommand$1.run(DelayCommand.java:48)
at org.bukkit.craftbukkit.v1_10_R1.scheduler.CraftTask.run(CraftTask.java:71)
at org.bukkit.craftbukkit.v1_10_R1.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:350)
at net.minecraft.server.v1_10_R1.MinecraftServer.D(MinecraftServer.java:741)
at net.minecraft.server.v1_10_R1.DedicatedServer.D(DedicatedServer.java:399)
at net.minecraft.server.v1_10_R1.MinecraftServer.C(MinecraftServer.java:672)
at net.minecraft.server.v1_10_R1.MinecraftServer.run(MinecraftServer.java:571)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

6 times, 1 week ago
Once, 1 week ago
5 times, 4 weeks ago
4 times, 1 month ago
2 times, 1 month ago

Write tip

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