[
https://jira.duraspace.org/browse/DS-796?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18602#action_18602
]
Graham Triggs commented on DS-796:
----------------------------------
I wouldn't want to contradict your DBA, but that description doesn't make any
sense.
DSPACE_USER is the login / schema that you are using for the database, and
SYS_C007905 is the name of the constraint, which you would need to look up in
the data dictionary to see what it is operating on. ie:
select UCC.CONSTRAINT_NAME, UCC.COLUMN_NAME, UC.CONSTRAINT_TYPE,
UC.SEARCH_CONDITION, UC2.TABLE_NAME as REFERENCES_TABLE
from USER_CONS_COLUMNS UCC, USER_CONSTRAINTS UC, USER_CONSTRAINTS UC2
where UCC.CONSTRAINT_NAME = UC.CONSTRAINT_NAME
and UC.R_CONSTRAINT_NAME = UC2.CONSTRAINT_NAME(+)
and UCC.CONSTRAINT_NAME='SYS_C007905'
However, looking at your stack trace, the constraint appears to be violated
whilst processing HandleManager.createHandle() - which is assigning a handle
(prefix + next value in handle sequence) to the community. This would occur if
you already have handles in the handle table, but the sequence is not set to
provide the next value as being at least one higher than the largest suffix of
your already allocated handles.
If you recreate handle_seq to start with a value that avoids collisions, you
should get past this error.
> Adding a Community throws ORA-0001 error
> ----------------------------------------
>
> Key: DS-796
> URL: https://jira.duraspace.org/browse/DS-796
> Project: DSpace
> Issue Type: Bug
> Affects Versions: 1.6.2
> Environment: Red Hat Enterprise 5
> Oracle 11g
> Reporter: Bert Lensch
>
> While trying to add a top-level community, or a sub-community to our DSpace
> community, we received an Internal Server Error. Looking through the logs, I
> noticed that trying to add a community causes Oracle to throw a ORA-0001
> error:
> 2011-01-07 09:14:32,848 WARN org.dspace.app.webui.servlet.DSpaceServlet @
> blen...@georgiasouthern.edu:session_id=1232A007BC7400C3524C38F490C87A6B:ip_addr=141.x.x.x:database_error:java.sql.SQLException\colon;
> ORA-00001\colon; unique constraint (DSPACE_USER.SYS_C007905) violated
> java.sql.SQLException: ORA-00001: unique constraint (DSPACE_USER.SYS_C007905)
> violated
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
> at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
> at
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
> at
> org.dspace.storage.rdbms.DatabaseManager.execute(DatabaseManager.java:1429)
> at
> org.dspace.storage.rdbms.DatabaseManager.update(DatabaseManager.java:781)
> at org.dspace.handle.HandleManager.createHandle(HandleManager.java:172)
> at org.dspace.content.Community.create(Community.java:205)
> at org.dspace.content.Community.createSubcommunity(Community.java:845)
> at
> org.dspace.app.webui.servlet.admin.EditCommunitiesServlet.processConfirmEditCommunity(EditCommunitiesServlet.java:520)
> at
> org.dspace.app.webui.servlet.admin.EditCommunitiesServlet.doDSPost(EditCommunitiesServlet.java:237)
> 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:710)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
> at
> org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
> at
> org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
> 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(StandardEngineValve.java:108)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
> at java.lang.Thread.run(Thread.java:636)
> Has anyone else seen this error before, or lend any insight on how to fix
> this problem? We only have a handful of communities and items installed on
> the server, so I wouldn't think we would be out of ID's or have problems with
> duplicate community names.
> Thanks.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.duraspace.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Dspace-devel mailing list
Dspace-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-devel
