One of our developers (William Hays) uncovered the solution to this problem being the removal of code from Item.delete() that removed the handle from the handle table. I've restored this code and it will be fixed in 1.5.1.
http://sourceforge.net/tracker/index.php? func=detail&aid=2102580&group_id=19984&atid=119984 -Mark On Aug 26, 2008, at 8:00 AM, rramos wrote: > > > 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 ------------------------------------------------------------------------- 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
