com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'XYZ-UUID' 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.

Solutions on the web

via GitHub by erocs
, 1 year ago
Duplicate entry 'UUID REMOVED' for key 'PRIMARY'
via GitHub by tinchoabbate
, 3 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'
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'XYZ-UUID' 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.namelayer.database.GroupManagerDao.setDefaultGroup(GroupManagerDao.java:1044)
at vg.civcraft.mc.namelayer.group.DefaultGroupHandler.setDefaultGroup(DefaultGroupHandler.java:38)
at vg.civcraft.mc.namelayer.group.Group.setDefaultGroup(Group.java:425)
at vg.civcraft.mc.namelayer.listeners.PlayerListener.handleFirstJoin(PlayerListener.java:112)
at vg.civcraft.mc.namelayer.listeners.PlayerListener.playerJoinEvent(PlayerListener.java:37)
at sun.reflect.GeneratedMethodAccessor188.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:306)
at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:502)
at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:487)
at net.minecraft.server.v1_10_R1.PlayerList.onPlayerJoin(PlayerList.java:333)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
4 times, 4 months ago
Once, 3 weeks ago
3 times, 1 year ago
2 times, 2 months ago
70 more bugmates

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