Problème démarrage Alfresco

[romainparis]

Bonjour!

Voilà, j'ai un sale souci…
Depuis deux jours, j'importe des fichiers sur Alfresco avec le FTP. Mais ce matin, il a planté. Et depuis, plus moyen de le redémarrer.
Lors du redémarrage, il m'affiche cette erreur dans le log :

13:37:21,950 ERROR [org.alfresco.repo.activities.post.lookup.PostLookup] Exception during select of postscom.ibatis.common.jdbc.exception.NestedSQLException:— The error occurred in alfresco/ibatis/#resource.dialect#/activities-common-SqlMap.xml.— The error occurred while executing query.— Check the               select           sequence_id as id,          activity_data as activityData,          activity_type as activityType,          post_user_id as userId,          post_date as postDate,          job_task_node as jobTaskNode,          site_network as siteNetwork,          app_tool as appTool,          status as status       from           alf_activity_post       where           status = ?           .— Check the SQL Statement (preparation failed).— Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.        at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)        at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)        at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)        at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94)        at org.alfresco.repo.domain.activities.ibatis.ActivityPostDAOImpl.selectPosts(ActivityPostDAOImpl.java:43)        at org.alfresco.repo.activities.post.lookup.PostLookup.execute(PostLookup.java:130)        at org.alfresco.repo.activities.post.lookup.PostLookupJob.execute(PostLookupJob.java:50)        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)        at java.lang.reflect.Constructor.newInstance(Constructor.java:532)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2214)        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781)        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)        at java.lang.reflect.Constructor.newInstance(Constructor.java:532)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)        at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)        at java.lang.reflect.Method.invoke(Method.java:616)        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)        at org.alfresco.util.AutoCommitInterceptor.invoke(AutoCommitInterceptor.java:35)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)        at $Proxy70.getConnection(Unknown Source) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)        at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:213)        at $Proxy181.prepareStatement(Unknown Source)        at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:541)        at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:219)        at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)        at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)        … 10 moreCaused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)        at java.lang.reflect.Constructor.newInstance(Constructor.java:532)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2140)        … 42 moreCaused by: java.net.ConnectException: Connection refused        at java.net.PlainSocketImpl.socketConnect(Native Method)        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193)        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384)        at java.net.Socket.connect(Socket.java:546)        at java.net.Socket.connect(Socket.java:495)        at java.net.Socket.<init>(Socket.java:392)        at java.net.Socket.<init>(Socket.java:235)        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)        … 43 more13:37:21,958 ERROR [org.alfresco.repo.activities.feed.AbstractFeedGenerator] Exception during generation of feedscom.ibatis.common.jdbc.exception.NestedSQLException:— The error occurred in alfresco/ibatis/#resource.dialect#/activities-common-SqlMap.xml.— The error occurred while executing query.— Check the        select max(sequence_id) as maxId       from alf_activity_post       where status = 'POSTED'    .— Check the SQL Statement (preparation failed).— Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.        at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)        at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120)        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)        at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)        at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:110)        at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:86)        at org.alfresco.repo.domain.activities.ibatis.ActivityPostDAOImpl.getMaxActivitySeq(ActivityPostDAOImpl.java:53)        at org.alfresco.repo.activities.feed.local.LocalFeedGenerator.generate(LocalFeedGenerator.java:59)        at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:137)        at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.        at sun.reflect.GeneratedConstructorAccessor384.newInstance(Unknown Source)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)        at java.lang.reflect.Constructor.newInstance(Constructor.java:532)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2214)        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781)        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)        at java.lang.reflect.Constructor.newInstance(Constructor.java:532)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)        at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)        at java.lang.reflect.Method.invoke(Method.java:616)        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)        at org.alfresco.util.AutoCommitInterceptor.invoke(AutoCommitInterceptor.java:35)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)        at $Proxy70.getConnection(Unknown Source)        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)        at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:213)        at $Proxy181.prepareStatement(Unknown Source)        at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:541)        at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:219)        at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)        at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)        … 12 moreCaused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)        at java.lang.reflect.Constructor.newInstance(Constructor.java:532)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2140)        … 44 moreCaused by: java.net.ConnectException: Connection refused        at java.net.PlainSocketImpl.socketConnect(Native Method)        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:193)        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:180)        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:384)        at java.net.Socket.connect(Socket.java:546)        at java.net.Socket.connect(Socket.java:495)        at java.net.Socket.<init>(Socket.java:392)        at java.net.Socket.<init>(Socket.java:235)        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)        … 45 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Pourtant, il n'y a jamais eu cette erreur auparavant!
Voilà. Pourtant, je peut aller dans MySql, avec la configuration existante. Mais la requête "select sequence_id as id, activity_data as activityData, activity_type as activityType, post_user_id as userId, post_date as postDate, job_task_node as jobTaskNode, site_network as siteNetwork,  app_tool as appTool, status as status from alf_activity_post where status = ?" me semble bizarre. Si je la met directement dans MySql, elle ne me retourne rien. Et la table alf_activity_post est totalement vide…

Auriez-vous une idée?

Cordialement,

Romain

[cleseach]

Bonjour,

L'erreur que vous indiquez n'empêche pas Alfresco de démarrer, vous devriez toujours disposer d'un Alfresco globalement fonctionnel (la conversion d'image en moins).

Pour résoudre votre problème, il faut indiquer le bon chemin vers ImageMagick dans le fichier alfresco-global.properties.
Les raisons pour lesquelles "ça fonctionnait avant et ça ne fonctionne plus maintenant" peuvent être nombreuses… mais j'imagine bien une montée de version des packages de votre serveur.

Le problème qui me semble le plus intéressant à régler pour vous est celui qui a conduit au plantage de votre serveur. Avez-vous pu identifier les causes ?

Cordialement,
Charles Le Seac'h

[romainparis]

Merci pour votre réponse.
En effet, après une comparaison par rapport aux logs précédent, ce n'est pas génant l'erreur ImageMagick.
Mais j'ai trouvé quelque chose de plus "interessant", j'ai modifié mon premier commentaire en conséquence.

[romainparis]

Là je redémarre le serveur tomcat, mais avec "index.recovery.mode=FULL" dans le alfresco-gobal.properties. On verra ce que ça donne…

[jayjayecl]

Je pronostiquerai davantage un problème de communication avec la BDD …

[cleseach]

Bonjour,

Je "plussoie" l'approche de Romain : votre log indique très clairement que la connexion est refusée.

J'en profite pour "moinsoyer" votre modification du premier post : ce type de modification en profondeur complique le suivi des sujets pour les lecteurs.

Cordialement,
Charles Le Seac'h

[romainparis]

Bonjour,

Et bien en effet, c'était bien un problème des index.
Suite à la ré-indexation, Alfresco tourne de nouveau.
Apparemment, la machine s'est arrêtée en plein transfert, donc il y avait un fichier incomplet présent, et Alfresco n'a pas vraiment aimé…

Merci de votre aide!
Je me permet de mettre en résolu.

[rguinot]

Effectivement, il vaut mieux creer un nouveau post plutot que d'en reutiliser un pour un sujet qui n'a rien à voir. on ne facture pas au post.

Caused by: java.net.ConnectException: Connection refused        at java.net.PlainSocketImpl.socketConnect(Native Method)        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:327)‍‍‍

Etes vous sur d'avoir fait le grant sur toutes les tables ? Quelle version de MySQL utilisez vous ? quelle version du driver ?