topic Re: [RESOLU]Lenteur du démarrage Alfresco in Alfresco Archive

[RESOLU]Lenteur du démarrage Alfresco

kimblue — Tue, 01 Jun 2010 09:12:56 GMT

Bonjour,Version Alfresco : 3.2r2MySQL : 5.1.47Mon problème est que depuis que j'ai installé la nouvelle version de MySQL mon application met plus de 2h à démarrer :'( !!!Le processus java prend 200% du CPU !!! Je ne comprend pas pourquoi! Et je n'ai pas d'erreur dans la log :-(16:21:37,991 INFO [or

Re: [RESOLU]Lenteur du démarrage Alfresco

rguinot — Tue, 01 Jun 2010 11:52:26 GMT

Dans le log que vous avez fourni, vous faites une reconstruction complète des indexes, d'ou la longueur au démarrage.
plusieurs causes possibles :
- vous l'avez explicitement demandé via (index.recovery.mode=FULL) dans alfresco-global.properties ou repository.properties :
- vous avez des indexes corrompus, pour lesquels il manque au moins le reflet des 10 premières transactions, et il déclenche de lui même un rebuild full.

Re: [RESOLU]Lenteur du démarrage Alfresco

kimblue — Tue, 01 Jun 2010 12:32:10 GMT

Bonjour,

Merci pour votre retour.

Oui effectivement dans ma configuration j'ai mis la réindexation en mode FULL. Ca va faire un mois que j'ai installé Alfresco et je n'avais pas eu ce problème. Jusqu'à hier avec la montée de version de MySQL.

Là le redémarrage a bien planté :

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
1 juin 2010 10:41:32 org.apache.coyote.http11.Http11Protocol init
INFO: Initialisation de Coyote HTTP/1.1 sur http-8080
1 juin 2010 10:41:32 org.apache.coyote.http11.Http11Protocol init
INFO: Initialisation de Coyote HTTP/1.1 sur http-8443
1 juin 2010 10:41:32 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 828 ms
1 juin 2010 10:41:32 org.apache.catalina.core.StandardService start
INFO: DÃ¯Â¿Â½marrage du service Catalina
1 juin 2010 10:41:32 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
1 juin 2010 10:41:33 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:41:36,644  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
10:41:36,645  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
10:41:36,646  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/produit/alfresco/tomcat/shared/classes/alfresco-global.properties]
10:41:36,718  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
10:41:41,616  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:41:48,945  INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
10:41:51,338  INFO  [domain.schema.SchemaBootstrap] No changes were made to the schema.
10:41:52,231  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
10:41:52,241  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
10:41:52,244  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
### Excluding compile: org.alfresco.repo.search.impl.lucene.index.IndexInfo$Merger::mergeDeletions
10:50:13,709  INFO  [node.index.FullIndexRecoveryComponent] Index recovery started: 43Â 238 transactions.
10:50:15,081  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'thirdparty' subsystem, ID: [thirdparty, default]
10:50:15,162  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
10:50:15,865  WARN  [alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
10:50:15,865  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [thirdparty, default] complete
10:58:44,458  ERROR [index.AbstractReindexComponent.threads] Reindexer     3 failed with error: 05010001 Failed to prepare: requires rollback.
10:58:44,542  ERROR [index.AbstractReindexComponent.threads] Reindexer     5 failed with error: 05010003 Failed to prepare: requires rollback.
11:24:25,679  ERROR [index.AbstractReindexComponent.threads] Reindexer    11 failed with error: 05010007 Failed to prepare: requires rollback.
11:32:38,659  ERROR [index.AbstractReindexComponent.threads] Reindexer    13 failed with error: 05010005 Failed to prepare: requires rollback.
12:59:32,270  INFO  [node.index.FullIndexRecoveryComponent] 10 % complete.
13:26:34,749  ERROR [lucene.index.IndexInfo] Index merger failed to recover - suspending
java.lang.RuntimeException: Error during run with lock.
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2331)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo.access$4700(IndexInfo.java:144)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo$Merger.recoverImpl(IndexInfo.java:3241)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo$AbstractSchedulable.run(IndexInfo.java:3083)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:619)
Caused by: java.io.FileNotFoundException: /data/alfresco/alf_data/lucene-indexes/workspace/SpacesStore/01fc8117-d1d9-4934-9d91-2ee933b634a1/_0.frq (No such file or directory)
        at java.io.RandomAccessFile.open(Native Method)
        at java.io.RandomAccessFile.<init>(RandomAccessFile.java:212)
        at org.apache.lucene.store.FSDirectory$FSIndexInput$Descriptor.<init>(FSDirectory.java:552)
        at org.apache.lucene.store.FSDirectory$FSIndexInput.<init>(FSDirectory.java:582)
        at org.apache.lucene.store.FSDirectory.openInput(FSDirectory.java:488)
        at org.apache.lucene.store.FSDirectory.openInput(FSDirectory.java:482)
        at org.apache.lucene.store.Directory.copy(Directory.java:190)
        at org.apache.lucene.store.RAMDirectory.<init>(RAMDirectory.java:73)
        at org.apache.lucene.store.RAMDirectory.<init>(RAMDirectory.java:84)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo.buildReferenceCountingIndexReader(IndexInfo.java:2002)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo.access$1200(IndexInfo.java:144)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo$Merger$2.doWork(IndexInfo.java:3300)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2400)
        at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2320)
        … 6 more
13:26:34,893  ERROR [lucene.index.IndexInfo] Index merger has recovered - resuming …

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Dois-je changer la conf de la réindexation ?

Merci d'avance.

Re: [RESOLU]Lenteur du démarrage Alfresco

rguinot — Tue, 01 Jun 2010 12:44:33 GMT

votre platefome ne m'a pas l'air très propre :

[quote]10:58:44,458  ERROR [index.AbstractReindexComponent.threads] Reindexer     3 failed with error: 05010001 Failed to prepare: requires rollback.
10:58:44,542  ERROR [index.AbstractReindexComponent.threads] Reindexer     5 failed with error: 05010003 Failed to prepare: requires rollback.
11:24:25,679  ERROR [index.AbstractReindexComponent.threads] Reindexer    11 failed with error: 05010007 Failed to prepare: requires rollback.
11:32:38,659  ERROR [index.AbstractReindexComponent.threads] Reindexer    13 failed with error: 05010005 Failed to prepare: requires rollback.
[/quote]‍‍‍‍‍

Caused by: java.io.FileNotFoundException: /data/alfresco/alf_data/lucene-indexes/workspace/SpacesStore/01fc8117-d1d9-4934-9d91-2ee933b634a1/_0.frq (No such file or directory)
        at java.io.RandomAccessFile.open(Native Method)
‍‍‍

Avez vous supprimé vos indexes ? si vous ne disposez de backup, il vous faudra les reconstruire (après avoir vidé complètement le contenu du repertoire lucene-indexes). une fois reconstruit, vous devez replacer l'index.recovery.mode a VALIDATE ou a AUTO.

Re: [RESOLU]Lenteur du démarrage Alfresco

kimblue — Tue, 01 Jun 2010 13:03:04 GMT

Je suis d'accord avec vous sur le fait que ma plateforme n'est pas propre :

[quote]10:58:44,458  ERROR [index.AbstractReindexComponent.threads] Reindexer     3 failed with error: 05010001 Failed to prepare: requires rollback.
10:58:44,542  ERROR [index.AbstractReindexComponent.threads] Reindexer     5 failed with error: 05010003 Failed to prepare: requires rollback.
11:24:25,679  ERROR [index.AbstractReindexComponent.threads] Reindexer    11 failed with error: 05010007 Failed to prepare: requires rollback.
11:32:38,659  ERROR [index.AbstractReindexComponent.threads] Reindexer    13 failed with error: 05010005 Failed to prepare: requires rollback.
[/quote]‍‍‍‍‍

Je n'ai pas encore trouver le moyen de faire disparaître cette erreur 😞

Pour l'autre erreur :

Caused by: java.io.FileNotFoundException: /data/alfresco/alf_data/lucene-indexes/workspace/SpacesStore/01fc8117-d1d9-4934-9d91-2ee933b634a1/_0.frq (No such file or directory)
        at java.io.RandomAccessFile.open(Native Method)
‍‍‍

Je n'ai rien supprimé du tout. Le seul changement c'est la montée de version de MySQL.

Je vais essayer de remonter les données avec mon dump.

Re: [RESOLU]Lenteur du démarrage Alfresco

kimblue — Tue, 01 Jun 2010 14:51:47 GMT

En fait certain fichier avait pour propriétaire root et non l'utilisateur d'alfresco

J'ai changé les droits des fichiers et alfresco démarre mieux

Bon j'ai d'autre erreurs dans la log que je vais investiguer!

Merci