I also get this issue on 1.5.0 production version. Any one knows if this was fixed ?
Karo Salminen wrote: > > Hi, > > there might be something to be resolved in ImportItem in 1.5 alpha. At > least, I'm experiencing problems when importing and trying to replace a > previously submitted item (using the same handle). > > I was running 'import -r -e [EMAIL PROTECTED] -c 123456789/9 -s 123456789/9 > -m > dspace.map' after exporting the same collection from DSpace and making > some changes to a items, and got the following error from PostgreSQL. I > was got no errors whatsoever when exporting and replacing items in > similar manner with DSpace 1.4.1. > > "... > Bitstream: marc.bib > Processing handle file: handle > read handle: '123456789/10' > org.postgresql.util.PSQLException: ERROR: duplicate key violates unique > constraint "handle_handle_key" > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:300) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) > at > org.dspace.storage.rdbms.DatabaseManager.execute(DatabaseManager.java:1263) > at > org.dspace.storage.rdbms.DatabaseManager.update(DatabaseManager.java:624) > at > org.dspace.handle.HandleManager.createHandle(HandleManager.java:197) > at > org.dspace.content.InstallItem.installItem(InstallItem.java:114) > at > org.dspace.app.itemimport.ItemImport.addItem(ItemImport.java:667) > at > org.dspace.app.itemimport.ItemImport.addItems(ItemImport.java:510) > at org.dspace.app.itemimport.ItemImport.main(ItemImport.java:417) > org.postgresql.util.PSQLException: ERROR: duplicate key violates unique > constraint "handle_handle_key" " > -- > Karo Salminen > sovellussuunnittelija Systems Analyst > Kirjastoverkkopalvelut National Library Network Services > Kansalliskirjasto National Library of Finland > PL 26 (Teollisuuskatu 23) > 00014 Helsingin yliopisto > puh. (09) 191 44593 > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Dspace-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-devel > > -- View this message in context: http://www.nabble.com/Facing-postgresql-problems-when-replacing-items-with-import-%28only-in-1.5-alpha%29-tp13876908p19163766.html Sent from the DSpace - Devel mailing list archive at Nabble.com. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Dspace-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-devel
