My favorites | Sign in
Project Home Downloads Wiki Issues Source
New issue   Search
for
  Advanced search   Search tips   Subscriptions
Issue 737: Create a new group fails due to duplicate primary key
1 person starred this issue and may be notified of changes. Back to list
Status:  Duplicate
Merged:  issue 518
Owner:  ----
Closed:  Jun 2011


Sign in to add a comment
 
Reported by robertr...@gmail.com, Sep 24, 2010
Affected Version: 2.1.5

What steps will reproduce the problem?
1.Restart Gerrit
2. Create a new group.

What is the expected output? What do you see instead?

instead of a new group, I see an "internal server error" message.  The error_log has this:

[2010-09-24 15:23:07,768] WARN  / : Error in createGroup
com.google.gwtorm.client.OrmException: insert failure on account_groups
....
Caused by: java.sql.BatchUpdateException: Duplicate entry '1' for key 'PRIMARY'
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443)
        at com.google.gwtorm.jdbc.JdbcAccess.execute(JdbcAccess.java:293)
        at com.google.gwtorm.jdbc.JdbcAccess.doInsert(JdbcAccess.java:171)
        ... 52 more


Please provide any additional information below.

Each time I try to create a new group , the index in the above error message increases, so eventually I can create a new group if I keep trying.

I'm using mysql 5.1.41 on Ubuntu 10.04. 

Sep 28, 2010
#1 robertr...@gmail.com
I also see same kind of failure when new users try to create accounts:


[2010-09-27 10:07:41,625] ERROR com.google.gerrit.httpd.auth.openid.OpenIdServiceImpl : OpenID authentication failure
com.google.gerrit.server.account.AccountException: Authentication error
...
Caused by: com.google.gwtorm.client.OrmException: insert failure on accounts
...
Caused by: java.sql.BatchUpdateException: Duplicate entry '3' for key 'PRIMARY'
...
Oct 12, 2010
#2 robertr...@gmail.com
This is a dupe if  Issue 518 . 
Jun 20, 2011
#3 sop@google.com
(No comment was entered for this change.)
Status: Duplicate
Mergedinto: 518
Sign in to add a comment

Powered by Google Project Hosting