Re: Problem with slide load testing

"Oliver Zeigermann" <[email protected]>
Newsgroups gmane.comp.jakarta.slide.devel
Message-ID <[email protected]> 
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
> org.apache.slide.store.impl.rdbms.JDBCStore@dec87 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
>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.