Hi Shobana!
I suspect this exception is due to a concurrency conflict. What
isolation level do you use for MySQL?
Oliver
2006/7/3, Krishnan, Shobana (Cognizant) <[EMAIL PROTECTED]>:
>
> Hi,
>
> I'm using Slide with MYSQL and tried load testing the application with
> 300 concurrent threads.
>
> I get the following Exception:
>
>
>
> 18:08:09,271 INFO [STDOUT] http-0.0.0.0-8080-29, 03-Jul-2006 18:08:08,
> root, ACL, 409 "Conflict", 486 ms, /files/jul_i_188
>
> 18:08:09,289 INFO [STDOUT] http-0.0.0.0-8080-9, 03-Jul-2006 18:08:09,
> root, PROPFIND, 207 "Multi-Status", 32 ms, /
>
> 18:08:09,290 INFO [STDOUT] 03 Jul 2006 18:08:09 -
> org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter - ERROR - SQL
> error (0) stateS1009 on /files: Parameter index out of range (173 >
> number of parameters, which is 172).
>
> 18:08:09,293 INFO [STDOUT] java.sql.SQLException: Parameter index out
> of range (173 > number of parameters, which is 172).
>
> 18:08:09,295 INFO [STDOUT] at
> com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2085
> )
>
> 18:08:09,295 INFO [STDOUT] at
> com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:1182)
>
> 18:08:09,295 INFO [STDOUT] at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegating
> PreparedStatement.java:131)
>
> 18:08:09,296 INFO [STDOUT] at
> org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter.clearBinding(MySqlRD
> BMSAdapter.java:227)
>
> 18:08:09,296 INFO [STDOUT] at
> org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(Stand
> ardRDBMSAdapter.java:152)
>
> 18:08:09,298 INFO [STDOUT] at
> org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(Stand
> ardRDBMSAdapter.java:107)
>
> 18:08:09,298 INFO [STDOUT] at
> org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.storeObject(Abstrac
> tRDBMSStore.java:432)
>
> 18:08:09,298 INFO [STDOUT] at
> org.apache.slide.store.AbstractStore.storeObject(AbstractStore.java:729)
>
> 18:08:09,298 INFO [STDOUT] at
> org.apache.slide.store.ExtendedStore.storeObject(ExtendedStore.java:629)
>
> 18:08:09,298 INFO [STDOUT] at
> org.apache.slide.structure.StructureImpl.store(StructureImpl.java:479)
>
> 18:08:09,298 INFO [STDOUT] at
> org.apache.slide.structure.StructureImpl.create(StructureImpl.java:368)
>
> 18:08:09,299 INFO [STDOUT] at
> org.apache.slide.webdav.method.MkcolMethod.executeRequest(MkcolMethod.ja
> va:204)
>
> 18:08:09,299 INFO [STDOUT] at
> org.apache.slide.webdav.method.AbstractWebdavMethod.executeRedirect(Abst
> ractWebdavMethod.java:583)
>
> 18:08:09,299 INFO [STDOUT] at
> org.apache.slide.webdav.method.AbstractWebdavMethod.run(AbstractWebdavMe
> thod.java:416)
>
> 18:08:09,304 INFO [STDOUT] at
> org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:159)
>
> 18:08:09,304 INFO [STDOUT] at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
>
> 18:08:09,304 INFO [STDOUT] at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:252)
>
> 18:08:09,304 INFO [STDOUT] at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
>
> 18:08:09,305 INFO [STDOUT] at
> org.apache.slide.webdav.filter.LogFilter.doFilter(LogFilter.java:147)
>
> 18:08:09,305 INFO [STDOUT] at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:202)
>
> 18:08:09,305 INFO [STDOUT] at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
>
> 18:08:09,305 INFO [STDOUT] at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilte
> r.java:81)
>
> 18:08:09,305 INFO [STDOUT] at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:202)
>
> 18:08:09,306 INFO [STDOUT] at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
>
> 18:08:09,306 INFO [STDOUT] at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
> e.java:213)
>
> 18:08:09,306 INFO [STDOUT] at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
> e.java:178)
>
> 18:08:09,306 INFO [STDOUT] at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipa
> lValve.java:39)
>
> 18:08:09,306 INFO [STDOUT] at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAs
> sociationValve.java:153)
>
> 18:08:09,306 INFO [STDOUT] at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticator
> Base.java:482)
>
> 18:08:09,306 INFO [STDOUT] at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.j
> ava:59)
>
> 18:08:09,307 INFO [STDOUT] at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
> :126)
>
> 18:08:09,307 INFO [STDOUT] at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
> :105)
>
> 18:08:09,307 INFO [STDOUT] at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
> java:107)
>
> 18:08:09,307 INFO [STDOUT] at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
> 48)
>
> 18:08:09,307 INFO [STDOUT] at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:85
> 6)
>
> 18:08:09,307 INFO [STDOUT] at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
> onnection(Http11Protocol.java:744)
>
> 18:08:09,308 INFO [STDOUT] at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
> .java:527)
>
> 18:08:09,317 INFO [STDOUT] at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorker
> Thread.java:112)
>
> 18:08:09,318 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595)
>
> 18:08:09,318 INFO [STDOUT]
> org.apache.slide.common.ServiceAccessException: Service
> [EMAIL PROTECTED] access error :
> Parameter index out of range (173 > number of parameters, which is 172).
>
> 18:08:09,319 INFO [STDOUT] at
> org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createException(S
> tandardRDBMSAdapter.java:1501)
>
> 18:08:09,299 INFO [STDOUT] http-0.0.0.0-8080-6, 03-Jul-2006 18:08:08,
> root, ACL, 200 "OK", 652 ms, /files/jul_i_186
>
> 18:08:09,319 INFO [STDOUT] at
> org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter.createException(MySq
> lRDBMSAdapter.java:69)
>
> 18:08:09,331 INFO [STDOUT] at
> org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(Stand
> ardRDBMSAdapter.java:213)
>
> 18:08:09,332 INFO [STDOUT] at
> org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(Stand
> ardRDBMSAdapter.java:107)
>
> 18:08:09,332 INFO [STDOUT] at
> org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.storeObject(Abstrac
> tRDBMSStore.java:432)
>
> 18:08:09,332 INFO [STDOUT] at
> org.apache.slide.store.AbstractStore.storeObject(AbstractStore.java:729)
>
> 18:08:09,332 INFO [STDOUT] at
> org.apache.slide.store.ExtendedStore.storeObject(ExtendedStore.java:629)
>
> 18:08:09,334 INFO [STDOUT] at
> org.apache.slide.structure.StructureImpl.store(StructureImpl.java:479)
>
> 18:08:09,334 INFO [STDOUT] at
> org.apache.slide.structure.StructureImpl.create(StructureImpl.java:368)
>
> 18:08:09,334 INFO [STDOUT] at
> org.apache.slide.webdav.method.MkcolMethod.executeRequest(MkcolMethod.ja
> va:204)
>
> 18:08:09,345 INFO [STDOUT] at
> org.apache.slide.webdav.method.AbstractWebdavMethod.executeRedirect(Abst
> ractWebdavMethod.java:583)
>
> 18:08:09,345 INFO [STDOUT] at
> org.apache.slide.webdav.method.AbstractWebdavMethod.run(AbstractWebdavMe
> thod.java:416)
>
> 18:08:09,346 INFO [STDOUT] at
> org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:159)
>
> 18:08:09,346 INFO [STDOUT] at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
>
> 18:08:09,346 INFO [STDOUT] at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:252)
>
> 18:08:09,346 INFO [STDOUT] at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
>
> 18:08:09,346 INFO [STDOUT] at
> org.apache.slide.webdav.filter.LogFilter.doFilter(LogFilter.java:147)
>
> 18:08:09,346 INFO [STDOUT] at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:202)
>
> 18:08:09,346 INFO [STDOUT] at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
>
> 18:08:09,346 INFO [STDOUT] at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilte
> r.java:81)
>
> 18:08:09,346 INFO [STDOUT] at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:202)
>
> 18:08:09,347 INFO [STDOUT] at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
>
> 18:08:09,347 INFO [STDOUT] at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
> e.java:213)
>
> 18:08:09,347 INFO [STDOUT] at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
> e.java:178)
>
> 18:08:09,347 INFO [STDOUT] at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipa
> lValve.java:39)
>
> 18:08:09,347 INFO [STDOUT] at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAs
> sociationValve.java:153)
>
> 18:08:09,348 INFO [STDOUT] at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticator
> Base.java:482)
>
> 18:08:09,348 INFO [STDOUT] at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.j
> ava:59)
>
> 18:08:09,348 INFO [STDOUT] at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
> :126)
>
> 18:08:09,348 INFO [STDOUT] at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
> :105)
>
> 18:08:09,348 INFO [STDOUT] at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
> java:107)
>
> 18:08:09,349 INFO [STDOUT] at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
> 48)
>
> 18:08:09,349 INFO [STDOUT] at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:85
> 6)
>
> 18:08:09,349 INFO [STDOUT] at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
> onnection(Http11Protocol.java:744)
>
> 18:08:09,349 INFO [STDOUT] at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
> .java:527)
>
> 18:08:09,349 INFO [STDOUT] at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorker
> Thread.java:112)
>
> 18:08:09,350 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595)
>
>
>
> Am totally clueless as to why I get the ServiceAccessException. Any help
> in the regard will be really appreciated.
>
>
>
> Thanks,
>
> Shobana
>
>
>
>
>
> This e-mail and any files transmitted with it are for the sole use of the
intended recipient(s) and may contain confidential and privileged information.
> If you are not the intended recipient, please contact the sender by reply
e-mail and destroy all copies of the original message.
> Any unauthorized review, use, disclosure, dissemination, forwarding, printing
or copying of this email or any action taken in reliance on this e-mail is strictly
> prohibited and may be unlawful.
>
> Visit us at http://www.cognizant.com
>
