May be true, I did my tests with the 4.0 schema and it worked just fine. No idea what the original problem is. Anyway, use the 4.0 schema even for 4.1 and it should work.
Oliver On Mon, 06 Dec 2004 14:44:48 -0800, Mirko Froehlich <[EMAIL PROTECTED]> wrote: > I have upgraded my database to MySQL 4.1 and changed the adapter to > "MySql41RDBMSAdapter" in Domain.xml. I also dropped my old Slide > database and created a fresh database using the MySQL 4.1 Slide db > script. The first startup worked fine, and I was able to access the > repository through the WebDAV client API (note that I ran into the same > deadlock issues...). Now, every time I start Tomcat, I get the following > exceptions in the log. If I try to hit Slide using the browser, it > complains about the actions cache not being loaded and also spits out an > exception in the logs (at the bottom, below). Any ideas? > > -Mirko > > At startup: > ======== > > 06 Dec 2004 14:36:38 - org.apache.slide.common.XMLUnmarshaller - INFO - > Loading object / > 06 Dec 2004 14:36:38 - org.apache.slide.common.XMLUnmarshaller - INFO - > Object already exists at / > 06 Dec 2004 14:36:38 - > org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter - ERROR - SQL error > 1267 on /: General error message from server: "Illegal mix of collations > (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for > operation 'substr_index'" > org.apache.slide.common.ServiceAccessException: Service > [EMAIL PROTECTED] access error : > General error message from server: "Illegal mix of collations > (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for > operation 'substr_index'" > at > org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter.createException(MySqlRDBMSAdapter.java:66) > at > org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.retrieveRevisionDescriptors(StandardRDBMSAdapter.java:942) > at > org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.retrieveRevisionDescriptors(AbstractRDBMSStore.java:652) > at > org.apache.slide.store.AbstractStore.retrieveRevisionDescriptors(AbstractStore.java:996) > at > org.apache.slide.store.ExtendedStore.retrieveRevisionDescriptors(ExtendedStore.java:816) > at > org.apache.slide.content.ContentImpl.retrieve(ContentImpl.java:168) > at > org.apache.slide.common.XMLUnmarshaller.loadObjectRevision(XMLUnmarshaller.java:340) > at > org.apache.slide.common.XMLUnmarshaller.loadDefaultObjectRevision(XMLUnmarshaller.java:307) > at > org.apache.slide.common.XMLUnmarshaller.loadObjectNode(XMLUnmarshaller.java:237) > at > org.apache.slide.common.XMLUnmarshaller.unmarshal(XMLUnmarshaller.java:90) > at > org.apache.slide.common.NamespaceAccessTokenImpl.importData(NamespaceAccessTokenImpl.java:272) > at > org.apache.slide.common.Namespace.loadBaseData(Namespace.java:808) > at org.apache.slide.common.Domain.initNamespace(Domain.java:845) > at org.apache.slide.common.Domain.init(Domain.java:432) > at org.apache.slide.common.Domain.init(Domain.java:366) > at org.apache.slide.common.Domain.init(Domain.java:329) > at > org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:253) > at javax.servlet.GenericServlet.init(GenericServlet.java:211) > at > org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:195) > at > org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1029) > at > org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862) > at > org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4013) > at > org.apache.catalina.core.StandardContext.start(StandardContext.java:4357) > at > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823) > at > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) > at > org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595) > at > org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:277) > at > org.apache.catalina.core.StandardHost.install(StandardHost.java:832) > at > org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:617) > at > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:431) > at > org.apache.catalina.startup.HostConfig.start(HostConfig.java:968) > at > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349) > at > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091) > at > org.apache.catalina.core.StandardHost.start(StandardHost.java:789) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083) > at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478) > at > org.apache.catalina.core.StandardService.start(StandardService.java:480) > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:2313) > at org.apache.catalina.startup.Catalina.start(Catalina.java:556) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:284) > at > org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:422) > 06 Dec 2004 14:36:38 - org.apache.slide.common.Namespace - INFO - > Namespace base configuration was already done before > > When hitting the server: > ================= > > org.apache.slide.common.ServiceAccessException: Service > db(org.apache.slide.store.ExtendedStore) access error : Actions cache > not loaded > at > org.apache.slide.security.SecurityImpl.getActionAggregationClosureImpl(SecurityImpl.java:1471) > at > org.apache.slide.security.SecurityImpl.matchAction(SecurityImpl.java:1128) > at > org.apache.slide.security.ACLSecurityImpl.match(ACLSecurityImpl.java:321) > at > org.apache.slide.security.ACLSecurityImpl.evaluateAcl(ACLSecurityImpl.java:311) > at > org.apache.slide.security.ACLSecurityImpl.hasPermission(ACLSecurityImpl.java:134) > at > org.apache.slide.security.SecurityImpl.checkPermission(SecurityImpl.java:472) > at > org.apache.slide.security.SecurityImpl.checkCredentials(SecurityImpl.java:405) > at > org.apache.slide.structure.StructureImpl.retrieve(StructureImpl.java:179) > at > org.apache.slide.structure.StructureImpl.retrieve(StructureImpl.java:160) > at > org.apache.slide.webdav.method.AbstractWebdavMethod.run(AbstractWebdavMethod.java:387) > 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:237) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) > at > org.apache.slide.webdav.filter.LogFilter.doFilter(LogFilter.java:141) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) > at > org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at > org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: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.java:799) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) > at > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) > at java.lang.Thread.run(Thread.java:534) > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
