Voila maintenant 15 jours que j'ai Installé Alfresco...

[ridisc30]

Bonjour,
Voila maintenant 15 jours que j'ai Installé Alfresco "Version: Community Network - v1.3.0" sous Windows XP PRO SP2. L'install à été faite grâce au package "alfresco-1.3.0-windows-community.exe".
Il fonctionne parfaitement (grace à l'aide précieuse trouvé dans ce forum), mais j'ai un soucis de plantage quotidien le soir lorsque les bureaux sont fermé et que personne n'utilise plus Alfresco.
Lorsque je reviens tous les matins, le serveur n'est plus accessible ni par l'intranet http://adresse_ip:8080/alfresco ni par l'acces réseau ou par FTP !
En regardent sur le PC qui heberge Alfresco dans la fenêtre "TOMCAT" en mode console, je peux voir un message d'erreur
** END NESTED EXCEPTION ** etc…
Je vous joins ci-dessous la totalité de la fenêtre.

CompilerOracle: exclude org/apache/lucene/index/IndexReader$1 doBody
11 sept. 2006 10:40:03 org.apache.catalina.core.AprLifecycleListener lifecycleEv
ent
INFO: The Apache Portable Runtime which allows optimal performance in production
 environments was not found on the java.library.path: C:Program Filesalfresco-
1.3.0javabin;.;C:WINDOWSsystem32;C:WINDOWS;C:Program Filesalfresco-1.3.0
javabin;C:Program Filesalfresco-1.3.0bin;C:Program Filesalfresco-1.3.0tom
catbin;C:Program Filesalfresco-1.3.0bin;C:WINDOWSsystem32;C:WINDOWS;C:WI
NDOWSSystem32Wbem;C:Program FilesESTsoftALZip;C:Program FilesESTsoftALZ
ip
11 sept. 2006 10:40:04 org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initialisation de Coyote HTTP/1.1 sur http-8080
11 sept. 2006 10:40:04 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 4586 ms
11 sept. 2006 10:40:04 org.apache.catalina.core.StandardService start
INFO: DÚmarrage du service Catalina
11 sept. 2006 10:40:04 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.12
11 sept. 2006 10:40:04 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
11 sept. 2006 10:40:11 org.apache.catalina.startup.HostConfig deployWAR
INFO: DÚploiement de l'archive alfresco.war de l'application web
11 sept. 2006 10:41:41 net.sf.joott.uno.UnoConnection connect
INFO: connecting using "socket,host=localhost,port=8100,tcpNoDelay=1"…
11 sept. 2006 10:41:42 net.sf.joott.uno.UnoConnection connect
INFO: connected
11 sept. 2006 10:41:42 net.sf.joott.uno.UnoConnection connect
INFO: connecting using "socket,host=localhost,port=8100,tcpNoDelay=1"…
11 sept. 2006 10:41:42 net.sf.joott.uno.UnoConnection connect
INFO: connected
10:41:48,666 INFO  [admin.patch.PatchExecuter] VÚrification des correctifs Ó app
liquer …
10:41:49,297 INFO  [admin.patch.PatchExecuter] Aucun correctif requis.
10:41:51,501 INFO  [service.descriptor.DescriptorService] Alfresco JVM - v1.5.0_
06-b05; maximum heap size 506,313MB
10:41:51,551 INFO  [service.descriptor.DescriptorService] Alfresco started (Comm
unity Network): Current version 1.3.0 schema 14 - Installed version 1.3.0 schema
 14
11 sept. 2006 10:42:01 org.apache.coyote.http11.Http11BaseProtocol start
INFO: DÚmarrage de Coyote HTTP/1.1 sur http-8080
11 sept. 2006 10:42:01 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
11 sept. 2006 10:42:03 org.apache.catalina.startup.Catalina start
INFO: Server startup in 119312 ms
### Excluding compile:  org.apache.lucene.index.IndexReader$1::doBody
17:22:06,953 WARN  [node.integrity.IntegrityChecker] Found 1 integrity violation
s:
Duplicate child associations are not allowed:
   Association: Association[ class=ClassDef [ name={http://www.alfresco.org/mode
l/content/1.0}folder], name={http://www.alfresco.org/model/content/1.0}contains,
 target class={http://www.alfresco.org/model/system/1.0}base, source role=null,
target role=null]
   Name: {http://www.alfresco.org/model/rule/1.0}rules
08:04:54,997 ERROR [hibernate.transaction.JDBCTransaction] JDBC begin failed
com.mysql.jdbc.CommunicationsException: Communications link failure due to under
lying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: recv failed

STACKTRACE:

java.net.SocketException: Software caused connection abort: recv failed
        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.read(SocketInputStream.java:129)
        at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.ja
va:113)
        at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNe
cessary(ReadAheadInputStream.java:160)
        at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.ja
va:188)
        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1902)
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)
        at com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyCon
nection.java:781)
        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:
63)
        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290
)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegi
n(HibernateTransactionManager.java:520)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.getTransaction(AbstractPlatformTransactionManager.java:282)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupport.java:225)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:89)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:170)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:176)
        at $Proxy7.getMD4HashedPassword(Unknown Source)
        at org.alfresco.filesys.server.auth.ntlm.AlfrescoAuthenticator.doMD4User
Authentication(AlfrescoAuthenticator.java:256)
        at org.alfresco.filesys.server.auth.ntlm.AlfrescoAuthenticator.authentic
ateUser(AlfrescoAuthenticator.java:144)
        at org.alfresco.filesys.server.auth.CifsAuthenticator.processSessionSetu
p(CifsAuthenticator.java:496)
        at org.alfresco.filesys.smb.server.NTProtocolHandler.procSessionSetup(NT
ProtocolHandler.java:399)
        at org.alfresco.filesys.smb.server.NTProtocolHandler.runProtocol(NTProto
colHandler.java:213)
        at org.alfresco.filesys.smb.server.SMBSrvSession.runHandler(SMBSrvSessio
n.java:1662)
        at org.alfresco.filesys.smb.server.SMBSrvSession.run(SMBSrvSession.java:
1563)
        at java.lang.Thread.run(Thread.java:595)


** END NESTED EXCEPTION **



Last packet sent to the server was 110 ms ago.
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2563)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)
        at com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyCon
nection.java:781)
        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:
63)
        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290
)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegi
n(HibernateTransactionManager.java:520)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.getTransaction(AbstractPlatformTransactionManager.java:282)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupport.java:225)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:89)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:170)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:176)
        at $Proxy7.getMD4HashedPassword(Unknown Source)
        at org.alfresco.filesys.server.auth.ntlm.AlfrescoAuthenticator.doMD4User
Authentication(AlfrescoAuthenticator.java:256)
        at org.alfresco.filesys.server.auth.ntlm.AlfrescoAuthenticator.authentic
ateUser(AlfrescoAuthenticator.java:144)
        at org.alfresco.filesys.server.auth.CifsAuthenticator.processSessionSetu
p(CifsAuthenticator.java:496)
        at org.alfresco.filesys.smb.server.NTProtocolHandler.procSessionSetup(NT
ProtocolHandler.java:399)
        at org.alfresco.filesys.smb.server.NTProtocolHandler.runProtocol(NTProto
colHandler.java:213)
        at org.alfresco.filesys.smb.server.SMBSrvSession.runHandler(SMBSrvSessio
n.java:1662)
        at org.alfresco.filesys.smb.server.SMBSrvSession.run(SMBSrvSession.java:
1563)
        at java.lang.Thread.run(Thread.java:595)
08:04:55,067 ERROR [alfresco.smb.protocol] Closing session due to exception
org.springframework.transaction.CannotCreateTransactionException: Could not open
 Hibernate Session for transaction; nested exception is org.hibernate.Transactio
nException: JDBC begin failed:
org.hibernate.TransactionException: JDBC begin failed:
        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:
68)
        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290
)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegi
n(HibernateTransactionManager.java:520)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.getTransaction(AbstractPlatformTransactionManager.java:282)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupport.java:225)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:89)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:170)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:176)
        at $Proxy7.getMD4HashedPassword(Unknown Source)
        at org.alfresco.filesys.server.auth.ntlm.AlfrescoAuthenticator.doMD4User
Authentication(AlfrescoAuthenticator.java:256)
        at org.alfresco.filesys.server.auth.ntlm.AlfrescoAuthenticator.authentic
ateUser(AlfrescoAuthenticator.java:144)
        at org.alfresco.filesys.server.auth.CifsAuthenticator.processSessionSetu
p(CifsAuthenticator.java:496)
        at org.alfresco.filesys.smb.server.NTProtocolHandler.procSessionSetup(NT
ProtocolHandler.java:399)
        at org.alfresco.filesys.smb.server.NTProtocolHandler.runProtocol(NTProto
colHandler.java:213)
        at org.alfresco.filesys.smb.server.SMBSrvSession.runHandler(SMBSrvSessio
n.java:1662)
        at org.alfresco.filesys.smb.server.SMBSrvSession.run(SMBSrvSession.java:
1563)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure d
ue to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Software caused connection abort: recv failed

STACKTRACE:

java.net.SocketException: Software caused connection abort: recv failed
        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.read(SocketInputStream.java:129)
        at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.ja
va:113)
        at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNe
cessary(ReadAheadInputStream.java:160)
        at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.ja
va:188)
        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1902)
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)
        at com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyCon
nection.java:781)
        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:
63)
        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290
)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegi
n(HibernateTransactionManager.java:520)
        at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.getTransaction(AbstractPlatformTransactionManager.java:282)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupport.java:225)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:89)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:170)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:176)
        at $Proxy7.getMD4HashedPassword(Unknown Source)
        at org.alfresco.filesys.server.auth.ntlm.AlfrescoAuthenticator.doMD4User
Authentication(AlfrescoAuthenticator.java:256)
        at org.alfresco.filesys.server.auth.ntlm.AlfrescoAuthenticator.authentic
ateUser(AlfrescoAuthenticator.java:144)
        at org.alfresco.filesys.server.auth.CifsAuthenticator.processSessionSetu
p(CifsAuthenticator.java:496)
        at org.alfresco.filesys.smb.server.NTProtocolHandler.procSessionSetup(NT
ProtocolHandler.java:399)
        at org.alfresco.filesys.smb.server.NTProtocolHandler.runProtocol(NTProto
colHandler.java:213)
        at org.alfresco.filesys.smb.server.SMBSrvSession.runHandler(SMBSrvSessio
n.java:1662)
        at org.alfresco.filesys.smb.server.SMBSrvSession.run(SMBSrvSession.java:
1563)
        at java.lang.Thread.run(Thread.java:595)


** END NESTED EXCEPTION **



Last packet sent to the server was 110 ms ago.
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2563)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
        at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913)
        at com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyCon
nection.java:781)
        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:
63)
        … 16 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Est ce qu quelqu'un a déja eu le problème ?

A savoir quand même que le PC a été installé au minima avec seulement un Antivirus AVAST 4.7 + un Firewall "Kerio 4.3" que j'ai d'ailleur désactivé temporairement.

[bmagnier]

Bonjour

Il s'agit d'un problème survenant lors d'une inactivité prolongée de la connection à la base de données.
La solution (donnée ici) est la suivante:

- modifier le fichier core-services-context.xml ([Répertoire d'installation alfresco]/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/) en ajoutant au bean dataSource ("<bean id=dataSource…") la propriété maxIdleTime de la façon suivante

   <property name="maxIdleTime" > 
      <value>${db.pool.maxIdleTime}</value> 
   </property>‍‍‍

- modifier le fichier repository.properties (même emplacement) en ajoutant

db.pool.maxIdleTime=120‍

dans la section "#Database configration"

A bientôt

[ridisc30]

Merci beaucoup.

C'est super car ça à marché !
Un grand merci à toi pour cette réponse rapide et efficace

Par contre, jai une autre petite question :

Dans la ligne ci-dessous le "120" correspond à un temps de combien ? 2 heures ou 120 jours ou autre chose ?
db.pool.maxIdleTime=120

Encore merci

[thomasb]

Dans la ligne ci-dessous le "120" correspond à un temps de combien ? 2 heures ou 120 jours ou autre chose ?
db.pool.maxIdleTime=120

2 minutes !

Comme indiqué sur cette page, si on ne met rien (valeur par défaut: 0), les connexions inutilisées du pool n'expirent jamais.

C'est ce qui je suppose cause le problème puisque MySQL les recycle de son côté (d'où les erreurs de connexion interrompue). Avec une valeur dans maxIdleTime, on recycle nos connexions inutilisées (ici après 2 minutes d'inactivité), elles n'ont donc pas le temps d'être interrompues par MySQL. Juste une supposition…