I found the largest value of metadata_field_id in
metadatafieldregistry had outgrown last_value in
metadatafieldregistry_seq [1,2], piecing together search results of
similar `duplicate key' errors, I got it to accept further metadata
field names after using [3].
-- #1 - get largest metadata_field_id
SELECT metadata_field_id,element,qualifier FROM metadatafieldregistry ORDER BY
metadata_field_id DESC;
-- #2 - get last value
SELECT * from metadatafieldregistry_seq;
-- #3 - set value in #2 to #1
-- ## - where N is a Number (see page 222 ; chapter 9.12 of the 8.1 postgresql
manual for more)
SELECT setval('metadatafieldregistry_seq', N);
Best wishes,
-- Van Ly
________________________________
From: Van Ly
Sent: Mon 18/05/2009 1:05 PM
To: DSpace-tech@lists.sourceforge.net
Subject: 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:
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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech