You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-dev@jakarta.apache.org by "Krishnan, Shobana (Cognizant)" <Sh...@cognizant.com> on 2006/07/03 15:26:49 UTC
Problem with slide load testing
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
Re: Problem with slide load testing
Posted by Oliver Zeigermann <ol...@gmail.com>.
I recommend to have alook at
http://wiki.apache.org/jakarta-slide/ConcurrencyIssues
Oliver
2006/7/20, Oliver Zeigermann <ol...@gmail.com>:
> 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) <Sh...@cognizant.com>:
> >
> > 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
> >
>
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-dev-help@jakarta.apache.org
Re: Problem with slide load testing
Posted by Oliver Zeigermann <ol...@gmail.com>.
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) <Sh...@cognizant.com>:
>
> 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
>
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-dev-help@jakarta.apache.org