[Dspace-tech] ERROR: duplicate key violates unique constraint epersongroup_name_key
Hello, We're getting the error below when trying to add a submitter to certain collections. The problem was reported before. Our problem is following the same pattern. Is there a solution? when I am trying to create a delegated administrator from one collection I received the message of error printed at the end. I also want to point out we are updating from 1.2.1 to 1.4 and we have run the database schema_12-13 and 13-14, the new ones downloaded from cvs directory today. Other important thing is if the collection is created (not imported from 1.2.1) the problem disappears. For further detail we also have the language pack installed in our system. We need one answer as soon as possible in order to continue developing. Thanks in advance for all. 2008-07-15 15:19:15,234 WARN org.dspace.app.webui.servlet.DSpaceServlet @ [EMAIL PROTECTED]:session_id=36E830F8776EC76A1DCFE5A36D40B438:ip_addr=128. 128.169.158:database_error:org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint epersongroup_name_key org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint epersongroup_name_key at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse (QueryExecutorImpl.java:1525) at org.postgresql.core.v3.QueryExecutorImpl.processResults (QueryExecutorImpl.java:1309) at org.postgresql.core.v3.QueryExecutorImpl.execute (QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute (AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags (AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate (AbstractJdbc2Statement.java:308) 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:1462) at org.dspace.storage.rdbms.DatabaseManager.update (DatabaseManager.java:853) at org.dspace.eperson.Group.update(Group.java:965) at org.dspace.content.Collection.createSubmitters (Collection.java:565) at org.dspace.app.webui.servlet.admin.EditCommunitiesServlet.processConfirm EditCollection(EditCommunitiesServlet.java:577) at org.dspace.app.webui.servlet.admin.EditCommunitiesServlet.doDSPost (EditCommunitiesServlet.java:267) at org.dspace.app.webui.servlet.DSpaceServlet.processRequest (DSpaceServlet.java:147) at org.dspace.app.webui.servlet.DSpaceServlet.doPost (DSpaceServlet.java:105) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:193) at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter (RegisteredOnlyFilter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext (StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext (StandardPipeline.java:566) at org.apache.catalina.valves.CertificatesValve.invoke (CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline.invokeNext (StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke (StandardContext.java:2347) at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline.invokeNext (StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke (ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext (StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext (StandardPipeline.java:564) at
Re: [Dspace-tech] ERROR: duplicate key violates unique constraint epersongroup_name_key
Hi John, this seems to be a known meanwhile fixed bug, see: http://sourceforge.net/tracker/index.php?func=detailaid=1638565group_id=19984atid=119984 been fixed with http://sourceforge.net/tracker/index.php?func=detailaid=1638569group_id=19984atid=319984 hope that helps Claudia Hello, We're getting the error below when trying to add a submitter to certain collections. The problem was reported before. Our problem is following the same pattern. Is there a solution? when I am trying to create a delegated administrator from one collection I received the message of error printed at the end. I also want to point out we are updating from 1.2.1 to 1.4 and we have run the database schema_12-13 and 13-14, the new ones downloaded from cvs directory today. Other important thing is if the collection is created (not imported from 1.2.1) the problem disappears. For further detail we also have the language pack installed in our system. We need one answer as soon as possible in order to continue developing. Thanks in advance for all. 2008-07-15 15:19:15,234 WARN org.dspace.app.webui.servlet.DSpaceServlet @ [EMAIL PROTECTED]:session_id=36E830F8776EC76A1DCFE5A36D40B438:ip_addr=128. 128.169.158:database_error:org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint epersongroup_name_key org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint epersongroup_name_key at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse (QueryExecutorImpl.java:1525) at org.postgresql.core.v3.QueryExecutorImpl.processResults (QueryExecutorImpl.java:1309) at org.postgresql.core.v3.QueryExecutorImpl.execute (QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute (AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags (AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate (AbstractJdbc2Statement.java:308) 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:1462) at org.dspace.storage.rdbms.DatabaseManager.update (DatabaseManager.java:853) at org.dspace.eperson.Group.update(Group.java:965) at org.dspace.content.Collection.createSubmitters (Collection.java:565) at org.dspace.app.webui.servlet.admin.EditCommunitiesServlet.processConfirm EditCollection(EditCommunitiesServlet.java:577) at org.dspace.app.webui.servlet.admin.EditCommunitiesServlet.doDSPost (EditCommunitiesServlet.java:267) at org.dspace.app.webui.servlet.DSpaceServlet.processRequest (DSpaceServlet.java:147) at org.dspace.app.webui.servlet.DSpaceServlet.doPost (DSpaceServlet.java:105) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:193) at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter (RegisteredOnlyFilter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext (StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext (StandardPipeline.java:566) at org.apache.catalina.valves.CertificatesValve.invoke (CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline.invokeNext (StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke (StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke (ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke (StandardContext.java:2347) at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline.invokeNext (StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke