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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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