topic help trouble with database mysql in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/help-trouble-with-database-mysql/m-p/262417#M215547 <HTML><HEAD></HEAD><BODY><SPAN>Hello everyone!</SPAN><BR /><SPAN>I have a big problem, I wanted to try to understand how work the backup and restore and so yesterday I tried to run the instruction to back up the database:</SPAN><BR /><SPAN>mysqldump-ualfresco palfresco alfresco-&gt; backup.sql</SPAN><BR /><SPAN>But today, i can not access anymore at alfresco, this is the log:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />26-nov-2010 9.50.25 org.apache.catalina.core.AprLifecycleListener init<BR />INFO: Loaded APR based Apache Tomcat Native library 1.1.20.<BR />26-nov-2010 9.50.26 org.apache.catalina.core.AprLifecycleListener init<BR />INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].<BR />26-nov-2010 9.50.28 org.apache.coyote.http11.Http11AprProtocol init<BR />INFO: Initializing Coyote HTTP/1.1 on http-8080<BR />26-nov-2010 9.50.28 org.apache.coyote.ajp.AjpAprProtocol init<BR />INFO: Initializing Coyote AJP/1.3 on ajp-8009<BR />26-nov-2010 9.50.28 org.apache.catalina.startup.Catalina load<BR />INFO: Initialization processed in 7229 ms<BR />26-nov-2010 9.50.30 org.apache.catalina.core.StandardService start<BR />INFO: Starting service Catalina<BR />26-nov-2010 9.50.30 org.apache.catalina.core.StandardEngine start<BR />INFO: Starting Servlet Engine: Apache Tomcat/6.0.26<BR />26-nov-2010 9.50.30 org.apache.catalina.startup.HostConfig deployDescriptor<BR />INFO: Deploying configuration descriptor alfresco.xml<BR />26-nov-2010 9.51.35 org.apache.catalina.core.StandardContext addApplicationListener<BR />INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.<BR />26-nov-2010 9.52.04 org.apache.catalina.core.ApplicationContext log<BR />INFO: Initializing Spring root WebApplicationContext<BR />26-nov-2010 9.56.28 org.apache.catalina.core.StandardContext listenerStart<BR />GRAVE: Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextLoaderListener<BR />org.alfresco.error.AlfrescoRuntimeException: 10260000 Ensure that the 'dir.root' property is pointing to the correct data location.<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:332)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:68)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:180)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:325)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:251)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:184)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:519)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:581)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)<BR />26-nov-2010 9.56.28 org.apache.catalina.core.StandardContext listenerStart<BR />GRAVE: Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener<BR />org.alfresco.error.AlfrescoRuntimeException: 10260000 Ensure that the 'dir.root' property is pointing to the correct data location.<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:332)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:68)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:180)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:325)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:251)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:184)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:97)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:78)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:294)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:858)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:419)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:261)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:192)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:519)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:581)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)<BR />26-nov-2010 9.56.28 org.apache.catalina.core.StandardContext start<BR />GRAVE: Error listenerStart<BR />26-nov-2010 9.56.28 org.apache.catalina.core.StandardContext start<BR />GRAVE: Context [/alfresco] startup failed due to previous errors<BR />26-nov-2010 9.56.28 org.apache.catalina.core.ApplicationContext log<BR />INFO: Closing Spring root WebApplicationContext<BR />26-nov-2010 9.56.28 org.apache.catalina.core.ApplicationContext log<BR />INFO: Shutting down log4j<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc<BR />GRAVE: A web application registered the JBDC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [DefaultScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [DefaultScheduler_Worker-2] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [DefaultScheduler_Worker-3] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [DefaultScheduler_Worker-4] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [DefaultScheduler_Worker-5] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [DefaultScheduler_Worker-6] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [DefaultScheduler_Worker-7] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [DefaultScheduler_Worker-8] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [DefaultScheduler_Worker-9] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [DefaultScheduler_Worker-10] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesStopTimerThread<BR />GRAVE: A web application appears to have started a TimerThread named [Timer-0] via the java.util.Timer API but has failed to stop it. To prevent a memory leak, the timer (and hence the associated thread) has been forcibly cancelled. <BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [Thread-13] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesStopTimerThread<BR />GRAVE: A web application appears to have started a TimerThread named [Timer-1] via the java.util.Timer API but has failed to stop it. To prevent a memory leak, the timer (and hence the associated thread) has been forcibly cancelled. <BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [Thread-21] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [Thread-22] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [MessageDispatcher] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [indexThread1] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [indexThread2] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [indexThread3] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [indexThread4] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [indexThread5] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [indexThread6] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [indexThread7] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [indexThread8] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [indexThread9] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [indexThread10] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearReferencesThreads<BR />GRAVE: A web application appears to have started a thread named [DefaultScheduler_QuartzSchedulerThread] but has failed to stop it. This is very likely to create a memory leak.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap<BR />GRAVE: A web application created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@42f045f2]) and a value of type [org.alfresco.util.CachingDateFormat] (value [yyyy-MM-dd]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap<BR />GRAVE: A web application created a ThreadLocal with key of type [null] (value [com.sun.xml.bind.v2.ClassFactory$1@2c803533]) and a value of type [java.util.WeakHashMap] (value [{class org.alfresco.repo.audit.model._3.DataGenerator=java.lang.ref.WeakReference@119ade0a, class org.alfresco.repo.audit.model._3.PathMap=java.lang.ref.WeakReference@4e676b8d, class org.alfresco.repo.audit.model._3.DataExtractor=java.lang.ref.WeakReference@67c61e31, class org.alfresco.repo.audit.model._3.RecordValue=java.lang.ref.WeakReference@7fe85830, class org.alfresco.repo.audit.model._3.DataExtractors=java.lang.ref.WeakReference@6ef5f8ea, class org.alfresco.repo.audit.model._3.AuditPath=java.lang.ref.WeakReference@56a9038f, class javax.xml.bind.annotation.W3CDomHandler=java.lang.ref.WeakReference@7228cdbb, class org.alfresco.repo.audit.model._3.DataGenerators=java.lang.ref.WeakReference@54daea8a, class org.alfresco.repo.audit.model._3.Application=java.lang.ref.WeakReference@705c358b, class org.alfresco.repo.audit.model._3.Audit=java.lang.ref.WeakReference@35bf724e, class org.alfresco.repo.audit.model._3.GenerateValue=java.lang.ref.WeakReference@2be97a73, class java.util.ArrayList=java.lang.ref.WeakReference@6d662a8a, class org.alfresco.repo.audit.model._3.PathMappings=java.lang.ref.WeakReference@4e730222}]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap<BR />GRAVE: A web application created a ThreadLocal with key of type [null] (value [com.sun.xml.bind.v2.runtime.Coordinator$1@60912e6a]) and a value of type [com.sun.xml.bind.v2.runtime.Coordinator[]] (value [[Lcom.sun.xml.bind.v2.runtime.Coordinator;@5b7e62ad]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap<BR />GRAVE: A web application created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@46807ac8]) and a value of type [org.alfresco.repo.search.impl.lucene.index.ReferenceCountingReadOnlyIndexReaderFactory.ReferenceCountingReadOnlyIndexReader] (value [org.alfresco.repo.search.impl.lucene.index.ReferenceCountingReadOnlyIndexReaderFactory$ReferenceCountingReadOnlyIndexReader@6adaf50c]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap<BR />GRAVE: A web application created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@2c8f544b]) and a value of type [com.ibatis.sqlmap.engine.mapping.result.ResultObjectFactoryUtil.FactorySettings] (value [com.ibatis.sqlmap.engine.mapping.result.ResultObjectFactoryUtil$FactorySettings@1895d74a]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap<BR />GRAVE: A web application created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@156947e2]) and a value of type [org.apache.cxf.bus.CXFBusImpl] (value [org.apache.cxf.bus.CXFBusImpl@32ee5169]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.<BR />26-nov-2010 9.56.28 org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap<BR />GRAVE: A web application created a ThreadLocal with key of type [org.alfresco.repo.security.authentication.AuthenticationUtil.ThreadLocalStack] (value [org.alfresco.repo.security.authentication.AuthenticationUtil$ThreadLocalStack@3c22de9e]) and a value of type [java.util.Stack] (value [[]]) but failed to remove it when the web application was stopped. To prevent a memory leak, the ThreadLocal has been forcibly removed.<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>I believe that are these the causes:</SPAN><BR /><SPAN>-Because of my inexperience I've executed the instruction while alfresco Was running</SPAN><BR /><SPAN>-Today afterI run alfresco i realised that the file backup.sql was still in the bin folder of mysql</SPAN><BR /><SPAN>I tried, after having stopped alfresco, to delete the file .sql from the folder and than I've deleted the folders in lucene-indexes and changed the code in repository.properties: index.recovery.mode = FULL</SPAN><BR /><SPAN>to do the reindexing, but does not work.</SPAN><BR /><SPAN>How can I restore my data?</SPAN><BR /><SPAN>help!!</SPAN></BODY></HTML> Fri, 26 Nov 2010 11:48:18 GMT xena 2010-11-26T11:48:18Z help trouble with database mysql https://connect.hyland.com/t5/alfresco-archive/help-trouble-with-database-mysql/m-p/262417#M215547 Hello everyone!I have a big problem, I wanted to try to understand how work the backup and restore and so yesterday I tried to run the instruction to back up the database:mysqldump-ualfresco palfresco alfresco-&gt; backup.sqlBut today, i can not access anymore at alfresco, this is the log:26-nov-201 Fri, 26 Nov 2010 11:48:18 GMT https://connect.hyland.com/t5/alfresco-archive/help-trouble-with-database-mysql/m-p/262417#M215547 xena 2010-11-26T11:48:18Z Re: help trouble with database mysql https://connect.hyland.com/t5/alfresco-archive/help-trouble-with-database-mysql/m-p/262418#M215548 <HTML><HEAD></HEAD><BODY><SPAN>Maybe check if you have a different setting for index.recovery.mode in alfresco-global.properties? Remember, alfresco-global.properties is included last, so those settings win <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Also alfresco-global.properties would be the canonical place to override builtin settings.</SPAN><BR /><BR /><SPAN>If this does not work out, check if</SPAN><BR /><BR /><SPAN>* Alfresco tables are still in database (+/- 90 tables)</SPAN><BR /><SPAN>* Data is still in &lt;dir.root&gt;/contentstore</SPAN><BR /><BR /><SPAN>to see if there is still hope&nbsp; :mrgreen: </SPAN><BR /><BR /><SPAN>HTH</SPAN><BR /><SPAN>Gyro</SPAN></BODY></HTML> Fri, 26 Nov 2010 14:08:56 GMT https://connect.hyland.com/t5/alfresco-archive/help-trouble-with-database-mysql/m-p/262418#M215548 gyro_gearless 2010-11-26T14:08:56Z