Bonjour,
j'ai supprimé la base et je l'ai reconstruite avec db_remove.sql et db_setup.sql de /opt/alfresco/extras/database/mysql. Alfresco se lance, j'ai la page d'accueil mais je ne peux me connecter (message: "impossible de se connecter - nom d'utilisateur/mot de passe inconnu").
Dans alfresco.log j'ai l'erreur suivante : ERROR [org.alfresco.repo.avm.OrphanReaper] Garbage collector error
org.hibernate.exception.SQLGrammarException: could not execute query
Y-at'il un problème de script pour MySql?
Merci de votre aide
alfresco.log:
18:56:26,784 WARN [org.springframework.remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
18:56:36,150 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-1265.sql (Generated).
18:56:38,396 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-1266.sql (Copied from classpath:alfresco/dbscripts/create/2.0/org.hibernate.dialect.MySQLInnoDBDialect/AlfrescoPostCreate-2.0-FKIndexes.sql).
18:56:38,398 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] All executed statements written to file /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-All_Statements-1267.sql.
18:58:42,559 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Récupération de lindex débutée : {0} transactions.
18:58:42,730 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 10 % achevé.
18:58:42,785 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 30 % achevé.
18:58:42,824 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 50 % achevé.
18:58:42,871 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 60 % achevé.
18:58:55,429 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 80 % achevé.
18:58:55,507 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] 100 % achevé.
18:58:55,516 INFO [org.alfresco.repo.node.index.FullIndexRecoveryComponent] Récupération de l'index achevée.
18:58:55,548 INFO [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /opt/alfresco/alf_data
18:58:55,589 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Vérification des correctifs à appliquer …
18:58:56,374 INFO [org.alfresco.repo.admin.patch.PatchExecuter]
=== Correctif Appliqué ===
ID : patch.wcmFolders
RESULTAT :
The Web Projects folder was successfully created: workspace://SpacesStore/3d8c7500-8189-11dc-b70f-696c28f92f27
The Web Forms folder was successfully created: workspace://SpacesStore/3d8c7500-8189-11dc-b70f-696c28f92f27
=====================================
18:58:56,380 INFO [org.alfresco.repo.module.ModuleServiceImpl] Found 0 module(s).
18:58:56,550 ERROR [org.alfresco.smb.protocol] Failed to get local domain/workgroup name, using default of WORKGROUP
18:58:56,551 ERROR [org.alfresco.smb.protocol] (This may be due to firewall settings or incorrect <broadcast> setting)
18:58:56,941 INFO [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - v1.6.0_02-b05; maximum heap size 506,313MB
18:58:56,941 INFO [org.alfresco.service.descriptor.DescriptorService] Alfresco started (Community Network): Current version 2.1.0 (R1 443) schema 62 - Installed version 2.1.0 (R1 443) schema 62
18:59:29,382 ERROR [org.alfresco.repo.avm.OrphanReaper] Garbage collector error
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2214)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
at org.hibernate.loader.Loader.list(Loader.java:2090)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:388)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.alfresco.repo.avm.hibernate.AVMNodeDAOHibernate.getOrphans(AVMNodeDAOHibernate.java:143)
at org.alfresco.repo.avm.OrphanReaper$1TxnWork.doWork(OrphanReaper.java:252)
at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:189)
at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:89)
at org.alfresco.repo.avm.OrphanReaper.doBatch(OrphanReaper.java:344)
at org.alfresco.repo.avm.OrphanReaper.execute(OrphanReaper.java:57)
at org.alfresco.repo.avm.OrphanReaperJob.execute(OrphanReaperJob.java:44)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select childentry1_.child_id from avm_child_entries childentry1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2211)
