Help

[RESOL]Echec de la restauration de la BDD de Windows à Linux

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
kimblue
Member II
‎22 Apr 2010 1:25 PM

[RESOL]Echec de la restauration de la BDD de Windows à Linux

Bonjour,

J'ai effectué un dump de la BDD alfresco vers la BDD Linux, et je n'arrive plus à redémarrer Alfresco. Dans la log catalina j'ai l'erreur suivante : 

CompilerOracle: exclude org/apache/lucene/index/IndexReader$1.doBody
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger.mergeIndexes
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger.mergeDeletions
Apr 22, 2010 11:59:27 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Apr 22, 2010 11:59:27 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 332 ms
Apr 22, 2010 11:59:27 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Apr 22, 2010 11:59:27 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
Apr 22, 2010 11:59:28 AM org.apache.catalina.core.StandardContext addApplicationListener
INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.
11:59:31,606  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
11:59:31,607  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
11:59:31,607  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/produit/alfresco/tomcat/shared/classes/alfresco-global.properties]
11:59:31,676  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
11:59:36,831  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/produit/alfresco/tomcat/shared/classes/alfresco/extension/subsystems/Authentication/ldap-ad/ldap-ad1/ldap-ad-authentication.properties]
11:59:44,845  INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
11:59:46,555  INFO  [domain.schema.SchemaBootstrap] Executing database script /produit/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-2699974831280648981.sql (Copied from classpath:alfresco/dbscripts/upgrade/3.2/org.hibernate.dialect.MySQLInnoDBDialect/child-assoc-qname-crc.sql).
11:59:56,460  INFO  [domain.schema.SchemaBootstrap] Executing database script /produit/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-217914587822121891.sql (Copied from classpath:alfresco/dbscripts/upgrade/3.1/org.hibernate.dialect.MySQLInnoDBDialect/IPv6-patch.sql).
11:59:56,484  INFO  [domain.schema.SchemaBootstrap] All executed statements:  /produit/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-All_Statements-5808581068837459119.sql.
11:59:57,701  INFO  [domain.schema.SchemaBootstrap] Normalized schema (pre-bootstrap)  dumped to file /produit/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-3742125931030457047-Startup.xml.
11:59:57,702  INFO  [domain.schema.SchemaBootstrap] Normalized schema (post-bootstrap) dumped to file /produit/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-136064640657351529.xml.
11:59:57,702  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
11:59:57,714  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
11:59:57,717  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
11:59:58,992  WARN  [node.index.FullIndexRecoveryComponent] The indexes are not synchronized with the database.
11:59:59,350  INFO  [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /data/mysql/alfresco
11:59:59,438  ERROR [repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: System content not found in content store.
11:59:59,438  ERROR [repo.admin.ConfigurationChecker] Ensure that the 'dir.root' property is pointing to the correct data location.
11:59:59,441  ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 03220000 Ensure that the 'dir.root' property is pointing to the correct data location.
        at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:338)
        at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:74)
        at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:186)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:327)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:253)
        at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:190)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
        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:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Apr 22, 2010 11:59:59 AM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Apr 22, 2010 11:59:59 AM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
Apr 22, 2010 12:00:00 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Apr 22, 2010 12:00:00 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 33149 ms
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Est-ce que quelqu'un aurait une idée ?
0 Kudos
Reply
7 Replies
christophes
Member II
‎22 Apr 2010 1:56 PM

Re: [RESOL]Echec de la restauration de la BDD de Windows à Linux

As-tu aussi déplacer les répertoires contenus dans alf_data? Il faut savoir que la BDD ne contient pas tout, il n'y a pas les fichiers ni les index Lucene. Si tu veux que cela fonctionne, tu dois aussi déplacer ce répertoire et tout ce qu'il contient à l'endroit défini dans le fichier repository.properties à la variable dir.root.

Christophe
0 Kudos
Reply
kimblue
Member II
‎22 Apr 2010 3:10 PM

Re: [RESOL]Echec de la restauration de la BDD de Windows à Linux

Merci de ton retour.

Effectivement je n'ai pas encore déplacer ces fichiers.

Sur la machine Linux les répertoires audit.contentstore, contentstore, contentstore.deleted, lucene-indexes, oouser sont dans /data/mysql/alfresco. Mais ce n'est pas le chemin spécifié dans le fichier repository.properties (dir.root=./alf_data).

Est-ce qu'il faut que je déplace mes répertoires dans /data/alf_data (que je vais créer) ou bien je peux modifier la valeur du champ dir.root ?
0 Kudos
Reply
christophes
Member II
‎23 Apr 2010 8:30 AM

Re: [RESOL]Echec de la restauration de la BDD de Windows à Linux

Si tu crées le répertoire /data/alf_data, il faut changer la valeur de la propriété dir.root en conséquence.

Christophe
0 Kudos
Reply
kimblue
Member II
‎26 Apr 2010 9:21 AM

Re: [RESOL]Echec de la restauration de la BDD de Windows à Linux

Bonjour,

J'ai récupéré toutes les données d'Alfresco sur Windows et je les ai mises sur la machine Linux. J'ai modifié le fichier repository.properties en mettant le chemin pour la variable dir.root=./data/alfresco/alf_data

J'ai toujours la même erreur après avoir redémarré Alfresco.

Il y a un autre fichier alfresco-global.properties où il y a la variable dir.root et là j'ai mis le chemin de la BDD dir.root=/data/mysql/alfresco

Quel fichier est pris en compte ?
0 Kudos
Reply
kimblue
Member II
‎26 Apr 2010 9:55 AM

Re: [RESOL]Echec de la restauration de la BDD de Windows à Linux

Voici la log complète : 

CompilerOracle: exclude org/apache/lucene/index/IndexReader$1.doBody
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger.mergeIndexes
CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger.mergeDeletions
Apr 26, 2010 10:07:34 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Apr 26, 2010 10:07:34 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 332 ms
Apr 26, 2010 10:07:34 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Apr 26, 2010 10:07:34 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
Apr 26, 2010 10:07:35 AM org.apache.catalina.core.StandardContext addApplicationListener
INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.
10:07:38,844  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
10:07:38,845  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
10:07:38,845  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/produit/alfresco/tomcat/shared/classes/alfresco-global.properties]
10:07:38,914  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
10:07:43,957  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/produit/alfresco/tomcat/shared/classes/alfresco/extension/subsystems/Authentication/ldap-ad/ldap-ad1/ldap-ad-authentication.properties]
10:07:52,661  INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
10:07:57,980  INFO  [domain.schema.SchemaBootstrap] No changes were made to the schema.
10:08:00,692  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
10:08:00,711  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
10:08:00,715  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
10:08:02,440  WARN  [node.index.FullIndexRecoveryComponent] The indexes are not synchronized with the database.
10:08:02,498  WARN  [node.index.AVMFullIndexRecoveryComponent]     Index for avm store sitestore is out of date
10:08:02,910  INFO  [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /data/mysql/alfresco
10:08:02,978  ERROR [repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: Indexes not found for 7 stores.
10:08:02,978  INFO  [repo.admin.ConfigurationChecker] You may set 'index.recovery.mode=FULL' if you need to rebuild the indexes.
10:08:02,978  ERROR [repo.admin.ConfigurationChecker] CONTENT INTEGRITY ERROR: System content not found in content store.
10:08:02,978  ERROR [repo.admin.ConfigurationChecker] Ensure that the 'dir.root' property is pointing to the correct data location.
10:08:02,981  ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 03260000 Ensure that the 'dir.root' property is pointing to the correct data location.
        at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:338)
        at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:74)
        at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:186)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:327)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:253)
        at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:190)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
        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:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Apr 26, 2010 10:08:02 AM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Apr 26, 2010 10:08:02 AM org.apache.catalina.core.StandardContext start
SEVERE: Context [/alfresco] startup failed due to previous errors
log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
Apr 26, 2010 10:08:04 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Apr 26, 2010 10:08:04 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 29523 ms
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
0 Kudos
Reply
christophes
Member II
‎26 Apr 2010 10:21 AM

Re: [RESOL]Echec de la restauration de la BDD de Windows à Linux

Depuis la version 3.x (je ne sais plus exactement laquelle), je crois que le fichier pris en compte est alfresco-global.properties où il faut mettre la même ligne que dans l'autre; càd dir.root=./data/alfresco/alf_data. Le "dir.root" doit toujours pointer sur le répertoire alf_data.

Christophe
0 Kudos
Reply
kimblue
Member II
‎26 Apr 2010 10:46 AM

Re: [RESOL]Echec de la restauration de la BDD de Windows à Linux

Merci,

J'ai mis la même valeur dans le fichier alfresco-global.properties et le problème est corrigé. :-)

Toutes mes données sont présentes sur Alfresco Linux.
0 Kudos
Reply
The Archive

Content from pre 2016 and from language groups that have been closed.

Content is read-only.

We use cookies on this site to enhance your user experience

By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods).   If you are not ok with these terms, please do not use this website.