Also note that the MS-provided drivers are very, very 'sensitive'; move to jtds. :)

On 10 Dec 2004, at 12:41, Oliver Zeigermann wrote:

The MacroImpl.copy does not seem to cause any problems. Most likely
the blocking problems with SQLServer are due to the fine grain locking
which is the default one in CVS head. I will set up a page in the Wiki
that describes how all this concurrency stuff works and describes why
there can be problems. For now switching back to "full" from
"fine-grain":

            <parameter name="sequential-mode">full</parameter>

should fix this. Maybe you even would like to test the new
deadlock-retry stuff I described earlier. I will add SQLServer support
ASAP...

Anyway, I still have almost 80 errors with the file store. E.g.

testsuite\junit\xmltestcases\functional\copy\code\copy423.xml

complains about this:

  <exceuteStep>
    <method>LOCK</method>
    <url>/slide/files/test/help-doc.html</url>
    <XMLValueError>
      <path>/prop/lockdiscovery/activelock/principal-URL/href</path>
      <expectedValue>//slide/users/root</expectedValue>
      <receivedValue>/slide/users/root</receivedValue>
    </XMLValueError>
    <result>ERROR</result>
    <time>291</time>
  </exceuteStep>

I guess this is related to recent changes you have done, Stefan?

Oliver

On Thu, 9 Dec 2004 18:37:28 +0100, Oliver Zeigermann
<[EMAIL PROTECTED]> wrote:
I haven't worked with SQL Server for a while. But the only thing I
could imagine is the change in MacroImpl.copy that I made to allow
copying read only resources. Maybe this is the problem?

Oliver

On Thu, 09 Dec 2004 17:59:03 +0100, Stefan L�tzkendorf


<[EMAIL PROTECTED]> wrote:
Hello,
has any body experienced exceptions like this with MS SQL Server?

Some testcases are passing, some are failing, some are hanging.

(I'm on the HEAD)

Thanks Stefan

org.apache.slide.common.ServiceAccessException: Service [EMAIL PROTECTED] access error : [Microsoft][SQLServer 2000 Driver for
JDBC]System Exception: java.io.IOException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed..
at org.apache.slide.store.impl.rdbms.SQLServerRDBMSAdapter.createExcept ion(SQLServerRDBMSAdapter.java:77)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevision Content(StandardRDBMSAdapter.java:1086)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createRevisio nContent(StandardRDBMSAdapter.java:1037)
at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.createRevisionC ontent(AbstractRDBMSStore.java:836)
at org.apache.slide.store.AbstractStore.createRevisionContent(AbstractS tore.java:1434)
at org.apache.slide.store.ExtendedStore.createRevisionContent(ExtendedS tore.java:516)
at org.apache.slide.content.ContentImpl.create(ContentImpl.java:548)
at org.apache.slide.macro.MacroImpl.copyObject(MacroImpl.java:829)
at org.apache.slide.macro.MacroImpl.copy(MacroImpl.java:271)
at org.apache.slide.webdav.method.CopyMethod.executeRequest(CopyMethod. java:210)
at org.apache.slide.webdav.method.AbstractWebdavMethod.executeRedirect( AbstractWebdavMethod.java:572)
at org.apache.slide.webdav.method.AbstractWebdavMethod.run(AbstractWeb, davMethod.java:443)
at org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java: 151)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App licationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application FilterChain.java:157)
at org.apache.slide.webdav.filter.LogFilter.doFilter(LogFilter.java: 141)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App licationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application FilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapper Valve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardVal veContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.ja va:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(Standar dContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContext Valve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardVal veContext.java:104)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentic atorBase.java:540)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardVal veContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.ja va:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve. java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardVal veContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve. java:117)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardVal veContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.ja va:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVa lve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardVal veContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.ja va:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java: 929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java: 160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.jav a:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proc essConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.jav a:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Thread Pool.java:683)
at java.lang.Thread.run(Thread.java:534)
09 Dec 2004 17:42:55 - org.apache.slide.transaction.SlideTransaction - WARNING -
Rollback failure: Resource manager org.apache.slide.store.impl.rdbms.JDBCStore@
185f293 Error code XA_RBCOMMFAIL in Transaction 123 xid [EMAIL PROTECTED]@12d8acd in thread http-8081-Processor32
http-8081-Processor32, 09-Dez-2004 17:42:55, john2, COPY, 500 "Internal Server Error", 94 ms, /files/help-doc.html

-- Stefan L�tzkendorf -- [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to