[Dspace-tech] Cannot insert a duplicate key into unique index handle_handle_key

[Mike Whyment]

We are in the process of uploading 194,000 PDF's via the import command into DSpace 1.2.2

Everything as gone OK up to around 78,000.

 

I just received the following error

Adding item from directory JR9530002350
      Loading dublin core from /dspace-2/JR/JR9530002350/dublin_core.xml
        Element: title Qualifier: none Value: 480. Some 6-alkyl-5- and 7-alkyl-8-aminoquinolines
        Element: contributor Qualifier: author Value: Long,R.
        Element: contributor Qualifier: author Value: Schofield,K.
        Element: subject Qualifier: none Value: 480
        Element: subject Qualifier: none Value: 6-alkyl-5-
        Element: subject Qualifier: none Value: 7-alkyl-8-aminoquinolines
        Element: date Qualifier: issued Value: 1953
        Element: description Qualifier: none Value: J. Chem. Soc. (1953) pp2350-2354
        Processing contents file: /dspace-2/JR/JR9530002350/contents
        Bitstream: JR9530002350.pdf
Processing handle file: handle
It appears there is no handle file -- generating one
java.sql.SQLException: ERROR:  Cannot insert a duplicate key into unique index handle_handle_key

 

        at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:142)
        at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
        at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:367)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
        at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:229)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
        at org.dspace.storage.rdbms.DatabaseManager.execute(DatabaseManager.java:1173)
        at org.dspace.storage.rdbms.DatabaseManager.update(DatabaseManager.java:568)
        at org.dspace.handle.HandleManager.createHandle(HandleManager.java:167)
        at org.dspace.content.InstallItem.installItem(InstallItem.java:132)
        at org.dspace.content.InstallItem.installItem(InstallItem.java:85)
        at org.dspace.app.itemimport.ItemImport.addItem(ItemImport.java:622)
        at org.dspace.app.itemimport.ItemImport.addItems(ItemImport.java:465)
        at org.dspace.app.itemimport.ItemImport.main(ItemImport.java:374)
java.sql.SQLException: ERROR:  Cannot insert a duplicate key into unique index handle_handle_key

After some hunting around I've discovered from the map file that it was trying to allocate the handle

123456789/79060

If I enter 123456789/76090 into a browser window I see it has already been assigned to another item in another collection called Analyst.

 

Analyst was the first community to be populated, its handles range from 2 through to 25150.  I have now discovered that at least 6 handles from Analyst are up in the 78000 region.

How is this possible?
How can I check if these are duplicates or originals?

 

I started with a fresh install of DSpace(1.2.2), Tomcat(5.5) and Postgresql (7.3).

 

Kind Regards

 

Mike Whyment

 

Web Developer

Web Team

University of Aberdeen

 

e. m.wh...@abdn.ac.uk

t. +44 1224 274487