You just need to reset sequence metadatafieldregistry_seq to
max(metadata_field_id) + 1 and then retry it. I ran into this problem when we
migrated from Test to Prod since we had added new registry fields in Test.
Best,
Sue
[email protected]<mailto:[email protected]>
NASA Langley Research Center
NCI Information Systems, Inc.
Information Management Branch
(757) 224-4074
________________________________
From: Van Ly [mailto:[email protected]]
Sent: Sunday, May 17, 2009 11:05 PM
To: [email protected]
Subject: [Dspace-tech] metadatafieldregistry_pkey duplicate key error
Hello everyone,
Has anyone worked around or fixed this kind of `PSQLException: ERROR: duplicate
key' internal error.
#2 occurs When trying to add dublin core and qualifier labels (on 1.4.2 DSpace
+ Postgresql 8.1.11) similar to:
description.exhibit
description.exhibitHost
description.exhibitCity
description.exhibitCountry
description.exhibitCategory
description.exhibitImpact
Kind regards,
-- Van Ly
-- #2 - specifically in the case of already having
## description.exhibitHost
## description.exhibition
## adding description.exhibit fails
2009-05-18 12:52:45,935 WARN org.dspace.app.webui.servlet.DSpaceServlet @ name\
@place:session_id=F32DD4066DD475B8841A2A2204961B9A:ip_addr=1.2\
.3.4:database_error:org.postgresql.util.PSQLException: ERROR: duplicate key \
violates unique constraint "metadatafieldregistry_pkey"
org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constra\
int "metadatafieldregistry_pkey"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryE\
xecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecuto\
rImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.j\
ava:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Sta\
tement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstrac\
tJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJd\
bc2Statement.java:308)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(De\
legatingPreparedStatement.java:101)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(De\
legatingPreparedStatement.java:101)
at org.dspace.storage.rdbms.DatabaseManager.execute(DatabaseManager.jav\
a:1492)
at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java\
:815)
at org.dspace.content.MetadataField.create(MetadataField.java:281)
at org.dspace.app.webui.servlet.admin.MetadataFieldRegistryServlet.doDS\
Post(MetadataFieldRegistryServlet.java:166)
at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServ\
let.java:147)
at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java\
:105)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App\
licationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application\
FilterChain.java:188)
at org.dspace.app.webui.filter.AdminOnlyFilter.doFilter(AdminOnlyFilter\
.java:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App\
licationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application\
FilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapper\
Valve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContext\
Valve.java:174)
at org.dspace.storage.rdbms.DatabaseManager.execute(DatabaseManager.jav\
a:1492)
at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java\
:815)
at org.dspace.content.MetadataField.create(MetadataField.java:281)
at org.dspace.app.webui.servlet.admin.MetadataFieldRegistryServlet.doDS\
Post(MetadataFieldRegistryServlet.java:166)
at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServ\
let.java:147)
at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java\
:105)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App\
licationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application\
FilterChain.java:188)
at org.dspace.app.webui.filter.AdminOnlyFilter.doFilter(AdminOnlyFilter\
.java:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App\
licationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application\
FilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapper\
Valve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContext\
Valve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.\
java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.\
java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVa\
lve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.ja\
va:151)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200\
)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.j\
ava:703)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSoc\
ket.java:895)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Thread\
Pool.java:689)
at java.lang.Thread.run(Thread.java:595)
2009-05-18 12:52:57,527 INFO org.dspace.app.webui.servlet.BitstreamServlet @ a\
nonymous:session_id=157ADD11CE0F8BE314B9FB7F04571258:ip_addr=1.2.3.4:view_b\
itstream:bitstream_id=3631
-- #1 - error on 1.4.2 dspace when adding dublin core + qualifier metadata
field names
2009-05-01 16:59:00,779 WARN org.dspace.app.webui.servlet.DSpaceServlet @
n...@place:session_id=26E928194B87010F40C262E69A217EED:ip_addr=1.2.3.4:database_error:org.postgresql.util.PSQLException<mailto:n...@place:session_id=26E928194B87010F40C262E69A217EED:ip_addr=1.2.3.4:database_error:org.postgresql.util.PSQLException>:
ERROR: duplicate key \
violates unique constraint "metadatafieldregistry_pkey"
org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constra\
int "metadatafieldregistry_pkey"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryE\
xecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecuto\
rImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.j\
ava:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Sta\
tement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstrac\
tJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJd\
bc2Statement.java:308)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(De\
legatingPreparedStatement.java:101)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(De\
legatingPreparedStatement.java:101)
at org.dspace.storage.rdbms.DatabaseManager.execute(DatabaseManager.jav\
a:1492)
at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java\
:815)
at org.dspace.content.MetadataField.create(MetadataField.java:281)
at org.dspace.app.webui.servlet.admin.MetadataFieldRegistryServlet.doDS\
Post(MetadataFieldRegistryServlet.java:166)
at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServ\
let.java:147)
at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java\
:105)
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables
unlimited royalty-free distribution of the report engine
for externally facing server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
