Oracle Store internal server error

[Muhammad Al Sebaeyie <sh...@gmail.com>]

Hi All,

We have recently started using Slide, we use slide 2.1 (binary downloaded 
from the Jakarta site) on tomcat 5.5.7 on a Solaris box. Tomcat is set with 
the -server and min and max heap JVM parameter. We have the JDBC Store on 
oracle 9iR2.

We have loaded the server with Approx 12 GBs of data, mostly Tiffs and pdfs 
of medium size (ranging 10K to 1MB) in a directory structure.
We are accessing the store from a web application using the client API. The 
DB Server has 2 schemas for two separate stores (we have a test and a 
staging webdav servers) so the total data on the oracle server approaches 30 
GB.

After loading the data, we noticed a significant slowdown in the 
performance, with MKCOL operations and PUT operations hanging for like 10 
secs or more sometimes and slide will be unavailable during that time. But 
we attributed that to Database tweaking due to the large binary size and 
were investigating that...

But then, Errors started occurring when version control method is called on 
newly created objects, or in the put methods themselves, causing the 
creation to fail. This occurs sporadically, and sometimes if the resource is 
retried seconds after the failure it works fine, we still don't know if this 
is a DB Error, or a network Error (there have been network problems 
recently) or some unresolved issues with the JDBC Oracle Store. I'd like to 
rule out the JDBC Store as the culprit, so anybody have any thoughts on why 
this is happening (attached below are the stack traces for three distinct 
errors that happen on version control and put), or does anybody have done a 
similar setup and it works with no problem? 

Please let me know, thanks in advance...

here is my domain.xml parameters

<parameter name="dbcpPooling">true</parameter>
<parameter name="maxPooledConnections">10</parameter>
<parameter name="isolation">SERIALIZABLE</parameter>
<parameter name="compress">false</parameter>

And here are the log info for the errors:

http-8087-Processor12, 12-Jul-2005 13:24:07, root, CHECKOUT, 404 "Not 
Found", 65 ms, /files/8763131/doc.REF1.tif
http-8087-Processor12, 12-Jul-2005 13:24:07, root, PUT, 201 "Created", 396 
ms, /files/8763131/doc.REF1.tif
12 Jul 2005 13:24:08 - 
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter - ERROR - SQL error 1 
on /history/63: ORA-00001: unique constraint (QUALIFILES.SYS_C004443) 
violated

java.sql.SQLException: ORA-00001: unique constraint (QUALIFILES.SYS_C004443) 
violated

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java
:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java
:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(
OraclePreparedStatement.java:589)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(
DelegatingPreparedStatement.java:101)
at 
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createRevisionDescriptor
(StandardRDBMSAdapter.java:644)
at 
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionDescriptor
(StandardRDBMSAdapter.java:1253)
at 
org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.storeRevisionDescriptor
(AbstractRDBMSStore.java:759)
at org.apache.slide.store.AbstractStore.storeRevisionDescriptor(
AbstractStore.java:1219)
at org.apache.slide.store.ExtendedStore.storeRevisionDescriptor(
ExtendedStore.java:912)
at org.apache.slide.structure.StructureImpl.store(StructureImpl.java:501)
at org.apache.slide.structure.StructureImpl.create(StructureImpl.java:379)
at org.apache.slide.webdav.util.VersioningHelper.versionControl(
VersioningHelper.java:317)
at org.apache.slide.webdav.method.VersionControlMethod.executeRequest(
VersionControlMethod.java:163)
at org.apache.slide.webdav.method.AbstractWebdavMethod.run(
AbstractWebdavMethod.java:405)
at org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:155)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.slide.common.ServiceAccessException: Service 
org.apache.slide.store.impl.rdbms.JDBCStore@1b6101e access error : 
ORA-00001: unique constraint (QUALIFILES.SYS_C004443) violated

at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createException(
StandardRDBMSAdapter.java:1404)
at 
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createRevisionDescriptor
(StandardRDBMSAdapter.java:650)
at 
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionDescriptor
(StandardRDBMSAdapter.java:1253)
at 
org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.storeRevisionDescriptor
(AbstractRDBMSStore.java:759)
at org.apache.slide.store.AbstractStore.storeRevisionDescriptor(
AbstractStore.java:1219)
at org.apache.slide.store.ExtendedStore.storeRevisionDescriptor(
ExtendedStore.java:912)
at org.apache.slide.structure.StructureImpl.store(StructureImpl.java:501)
at org.apache.slide.structure.StructureImpl.create(StructureImpl.java:379)
at org.apache.slide.webdav.util.VersioningHelper.versionControl(
VersioningHelper.java:317)
at org.apache.slide.webdav.method.VersionControlMethod.executeRequest(
VersionControlMethod.java:163)
at org.apache.slide.webdav.method.AbstractWebdavMethod.run(
AbstractWebdavMethod.java:405)
at org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:155)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.apache.slide.webdav.filter.LogFilter.doFilter(LogFilter.java:141)
http-8087-Processor12, 12-Jul-2005 13:24:07, root, VERSION-CONTROL, 500 
"Internal Server Error", 942 ms, /files/8763131/doc.REF1.tif

And

http-8087-Processor25, 12-Jul-2005 13:23:27, root, CHECKOUT, 404 "Not 
Found", 64 ms, /files/8763131/doc.HPHI.tif
12 Jul 2005 13:23:27 - 
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter - ERROR - SQL error 1 
on /files/8763131/doc.HPHI.tif: ORA-00001: unique constraint (
QUALIFILES.SYS_C004374) violated

java.sql.SQLException: ORA-00001: unique constraint (QUALIFILES.SYS_C004374) 
violated

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java
:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java
:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(
OraclePreparedStatement.java:589)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(
DelegatingPreparedStatement.java:101)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.assureUriId(
StandardRDBMSAdapter.java:1279)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.assureUriId(
StandardRDBMSAdapter.java:1283)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(
StandardRDBMSAdapter.java:101)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createObject(
StandardRDBMSAdapter.java:83)
at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.createObject(
AbstractRDBMSStore.java:443)
at org.apache.slide.store.AbstractStore.createObject(AbstractStore.java:670)
org.apache.slide.common.ServiceAccessException: Service 
org.apache.slide.store.impl.rdbms.JDBCStore@1b6101e access error : 
ORA-00001: unique constraint (QUALIFILES.SYS_C004374) violated

at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createException(
StandardRDBMSAdapter.java:1404)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(
StandardRDBMSAdapter.java:191)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createObject(
StandardRDBMSAdapter.java:83)
at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.createObject(
AbstractRDBMSStore.java:443)
at org.apache.slide.store.AbstractStore.createObject(AbstractStore.java:670)
at org.apache.slide.store.ExtendedStore.createObject(ExtendedStore.java:602)
at org.apache.slide.structure.StructureImpl.create(StructureImpl.java:354)
at org.apache.slide.webdav.method.PutMethod.executeRequest(PutMethod.java
:298)
at org.apache.slide.webdav.method.AbstractWebdavMethod.run(
AbstractWebdavMethod.java:405)
at org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:155)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
http-8087-Processor25, 12-Jul-2005 13:23:27, root, PUT, 500 "Internal Server 
Error", 125 ms, /files/8763131/doc.HPHI.tif

And

http-8087-Processor25, 12-Jul-2005 13:25:11, root, CHECKOUT, 200 "OK", 281 
ms, /files/8763131/doc.HPHI.tif
12 Jul 2005 13:25:12 - 
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter - ERROR - 
java.io.IOException: ORA-08177: can't serialize access for this transaction

java.io.IOException: ORA-08177: can't serialize access for this transaction

at oracle.jdbc.dbaccess.DBError.SQLToIOException(DBError.java:716)
at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(
OracleBlobOutputStream.java:279)
at oracle.jdbc.driver.OracleBlobOutputStream.flush(
OracleBlobOutputStream.java:215)
at org.apache.slide.store.impl.rdbms.OracleRDBMSAdapter.storeContent(
OracleRDBMSAdapter.java:158)
at 
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionContent(
StandardRDBMSAdapter.java:1101)
at 
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionContent(
StandardRDBMSAdapter.java:1065)
at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.storeRevisionContent
(AbstractRDBMSStore.java:843)
at org.apache.slide.store.AbstractStore.storeRevisionContent(
AbstractStore.java:1387)
at org.apache.slide.store.ExtendedStore.storeRevisionContent(
ExtendedStore.java:533)
at org.apache.slide.content.ContentImpl.store(ContentImpl.java:1018)
at org.apache.slide.webdav.method.PutMethod.executeRequest(PutMethod.java
:270)
at org.apache.slide.webdav.method.AbstractWebdavMethod.run(
AbstractWebdavMethod.java:405)
at org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:155)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

java.io.IOException: ORA-08177: can't serialize access for this transaction

at oracle.jdbc.dbaccess.DBError.SQLToIOException(DBError.java:716)
at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(
OracleBlobOutputStream.java:279)
at oracle.jdbc.driver.OracleBlobOutputStream.flush(
OracleBlobOutputStream.java:215)
at org.apache.slide.store.impl.rdbms.OracleRDBMSAdapter.storeContent(
OracleRDBMSAdapter.java:158)
at 
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionContent(
StandardRDBMSAdapter.java:1101)
at 
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionContent(
StandardRDBMSAdapter.java:1065)
at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.storeRevisionContent
(AbstractRDBMSStore.java:843)
at org.apache.slide.store.AbstractStore.storeRevisionContent(
AbstractStore.java:1387)
at org.apache.slide.store.ExtendedStore.storeRevisionContent(
ExtendedStore.java:533)
at org.apache.slide.content.ContentImpl.store(ContentImpl.java:1018)
at org.apache.slide.webdav.method.PutMethod.executeRequest(PutMethod.java
:270)
at org.apache.slide.webdav.method.AbstractWebdavMethod.run(
AbstractWebdavMethod.java:405)
at org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:155)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

http-8087-Processor25, 12-Jul-2005 13:25:12, root, PUT, 500 "Internal Server 
Error", 274 ms, /files/8763131/doc.HPHI.tif

-- 
Best Regards,
Muhammad Alsebaey