GeneratedValue does not get a unique new value

Question

I have my hibernate configured as follows:

Entity
@Table (name = "statuspaatelling")
public class StatusPaaTelling {

private Long statusPaaTellingId;

@Id
@Column(name = "statusPaaTellingID")
@GeneratedValue(strategy = GenerationType.AUTO)
public Long getStatusPaaTellingId() {
    return statusPaaTellingId;
}

When I was creating new elements it worked perfectly, but suddenly now it creates values that already exist. And I cant create new elements since i get duplicate entries for my Primary key. I am using a MySQL database.

Duplicate entry '3155220' for key 'PRIMARY'
Error Code: 1062
Call: INSERT INTO statuspaatelling (statusPaaTellingID, something) VALUES(?, ?)

I think it might first happened when i imported a dump of the database and switched to using that. I've also tried switching back with no luck, but they have the exact same setup so I should not matter. Anyone has any ideas why the GeneratedValue suddenly didn't work?

David Levesque · Accepted Answer · 2013-09-26 13:50:15Z

1

You are probably hitting this MySQL bug (opened 7 years ago!!!). If you read the comments, someone posted a workaround using sed to fix the MySQL dump, e.g.:

sed -i -e 's/ AUTO_INCREMENT=[0-9]\+//' mydump.sql

You could also pipe the output of mysqldump through that sed command.

answered Sep 26, 2013 at 13:50

David Levesque

22.5k8 gold badges70 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jinxen Over a year ago

Yes my dump did include AUTO_INCREMENT=xxx. And I got removed it by using the sed command, however it is still creating existing values.

David Levesque Over a year ago

Do you restart the process running Hibernate after you import the data?

Community · Accepted Answer · 2017-05-23 12:15:19Z

-1

Have you declared the column as Auto Increment?

http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html

If not declared the column as auto increment, please follow the below link:

ALTER table - adding AUTOINCREMENT in MySQL

edited May 23, 2017 at 12:15

CommunityBot

11 silver badge

answered Sep 26, 2013 at 13:04

santu

6952 gold badges7 silver badges24 bronze badges

1 Comment

Jinxen Over a year ago

Yes I have. CREATE TABLE statuspaatelling ( statusOppdatert datetime DEFAULT NULL, statusPaaTellingID int(11) NOT NULL AUTO_INCREMENT. I has worked before, just stopped working a day ago.

Collectives™ on Stack Overflow

GeneratedValue does not get a unique new value

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related