Hyland Community
Help
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: 

Alfresco utilise la CPU à 100% depuis plusieurs jours

dranakan
Champ on-the-rise
Champ on-the-rise

‎03-02-2010 02:17 AM

Hello,

J'ai besoin de votre aide. Sur un serveur qui est fonctionnel depuis plus d'un mois, Alfresco utilise, depuis quelques jours, la CPU à 100%. Je ne sais pas trop comment résoudre ce problème. J'utilise Alfresco 32.r2 (2440) avec Mysql (5.0.77 Source distribution)

J'ai effectué deux jstack (aperçu des processus java qui tournent) :

2010-03-01 14:10:04 : http://www.megaupload.com/?d=YO72F2ZE ou sur Jira: https://issues.alfresco.com/jira/secure/attachment/17070/jstack_alfresco_2010-03-01_141004.log

2010-03-02 07:57:11  : http://www.megaupload.com/?d=NWO1NQCH ou sur Jira https://issues.alfresco.com/jira/secure/attachment/17071/jstack_alfresco_2010-03-02_075711.log

TOP
top - 08:04:30 up 33 days,  8:21,  1 user,  load average: 1.00, 1.02, 1.04
Tasks:  57 total,   1 running,  56 sleeping,   0 stopped,   0 zombie
Cpu(s): 33.3%us, 23.5%sy,  0.0%ni, 43.0%id,  0.1%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   2097328k total,  1365344k used,   731984k free,    47776k buffers
Swap:  1081336k total,   119020k used,   962316k free,   869476k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 2120 alfresco  18   0 1453m 359m 4316 S 99.9 17.5   1073:58 java
…
‍‍‍‍‍‍‍‍‍‍

Dans les logs, rien de particulier, sauf, ci-dessous, mais cela n'est plus apparu depuis que j'ai redémarrer Alfresco. :
12:19:22,012  ERROR [org.alfresco.fileserver] org.alfresco.jlan.netbios.NetBIOSException: NBREQ Called name is not this server (GED)
12:19:22,013  ERROR [org.alfresco.fileserver]   at org.alfresco.jlan.smb.server.SMBSrvSession.procNetBIOSSessionRequest(SMBSrvSession.java:881)
12:19:22,013  ERROR [org.alfresco.fileserver]   at org.alfresco.jlan.smb.server.SMBSrvSession.processPacket(SMBSrvSession.java:1446)
12:19:22,013  ERROR [org.alfresco.fileserver]   at org.alfresco.jlan.smb.server.nio.NIOCIFSThreadRequest.runRequest(NIOCIFSThreadRequest.java:111)
12:19:22,013  ERROR [org.alfresco.fileserver]   at org.alfresco.jlan.server.thread.ThreadRequestPool$ThreadWorker.run(ThreadRequestPool.java:141)
12:19:22,013  ERROR [org.alfresco.fileserver]   at java.lang.Thread.run(Thread.java:619)
12:19:22,013  ERROR [org.alfresco.fileserver] org.alfresco.jlan.netbios.NetBIOSException: NBREQ Called name is not this server (GED)
12:19:22,013  ERROR [org.alfresco.fileserver]   at org.alfresco.jlan.smb.server.SMBSrvSession.procNetBIOSSessionRequest(SMBSrvSession.java:881)
12:19:22,013  ERROR [org.alfresco.fileserver]   at org.alfresco.jlan.smb.server.SMBSrvSession.processPacket(SMBSrvSession.java:1446)
12:19:22,013  ERROR [org.alfresco.fileserver]   at org.alfresco.jlan.smb.server.nio.NIOCIFSThreadRequest.runRequest(NIOCIFSThreadRequest.java:111)
12:19:22,013  ERROR [org.alfresco.fileserver]   at org.alfresco.jlan.server.thread.ThreadRequestPool$ThreadWorker.run(ThreadRequestPool.java:141)
12:19:22,013  ERROR [org.alfresco.fileserver]   at java.lang.Thread.run(Thread.java:619)
12:19:26,419  ERROR [repo.action.AsynchronousActionExecutionQueueImpl] Failed to execute asynchronous action: Action[ id=f9cacddb-0c61-418a-bd8d-3a5a1d6c79bc, node=workspace://SpacesStore/f9cacddb-0c61-418a-bd8d-3a5a1d6c79bc ]
org.hibernate.exception.GenericJDBCException: could not load an entity: [org.alfresco.repo.domain.hibernate.NodeImpl#11931]
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.loader.Loader.loadEntity(Loader.java:1874)
        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
        at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3049)
        at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:399)
        at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
        at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
        at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)
        at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getNodeOrNull(HibernateNodeDaoServiceImpl.java:797)
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getNodePair(HibernateNodeDaoServiceImpl.java:1185)
        at sun.reflect.GeneratedMethodAccessor212.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
..
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException
MESSAGE: The last packet successfully received from the server was237098 milliseconds ago.The last packet sent successfully to the server was 237098 milliseconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

STACKTRACE:

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was237098 milliseconds ago.The last packet sent successfully to the server was 237098 milliseconds ago, which  is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
        at sun.reflect.GeneratedConstructorAccessor371.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3270)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1932)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
        at org.hibernate.loader.Loader.doQuery(Loader.java:674)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
        at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)
        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
        at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3049)
        at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:399)

t org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
        at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
        at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)
        at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getNodeOrNull(HibernateNodeDaoServiceImpl.java:797)
        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getNodePair(HibernateNodeDaoServiceImpl.java:1185)
        at sun.reflect.GeneratedMethodAccessor212.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:68)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.invoke(DirtySessionMethodInterceptor.java:419)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invokeInternal(SingleEntryTransactionResourceInterceptor.java:169)
        at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invoke(SingleEntryTransactionResourceInterceptor.java:138)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy9.getNodePair(Unknown Source)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.exists(DbNodeServiceImpl.java:170)
        at sun.reflect.GeneratedMethodAccessor341.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy11.exists(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor341.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
        at $Proxy12.exists(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor341.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:306)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:306)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:274)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:274)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy11.exists(Unknown Source)
        at org.alfresco.repo.action.evaluator.ComparePropertyValueEvaluator.evaluateImpl(ComparePropertyValueEvaluator.java:179)
        at org.alfresco.repo.action.evaluator.CompareMimeTypeEvaluator.evaluateImpl(CompareMimeTypeEvaluator.java:90)
        at org.alfresco.repo.action.evaluator.ActionConditionEvaluatorAbstractBase.evaluate(ActionConditionEvaluatorAbstractBase.java:97)
        at org.alfresco.repo.action.ActionServiceImpl.evaluateSimpleCondition(ActionServiceImpl.java:490)
        at org.alfresco.repo.action.ActionServiceImpl.evaluateActionCondition(ActionServiceImpl.java:478)
        at org.alfresco.repo.action.ActionServiceImpl.evaluateAction(ActionServiceImpl.java:399)
        at org.alfresco.repo.action.ActionServiceImpl.executeActionImpl(ActionServiceImpl.java:645)
        at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper$1$1.execute(AsynchronousActionExecutionQueueImpl.java:369)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:327)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:234)
        at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper$1.doWork(AsynchronousActionExecutionQueueImpl.java:378)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:514)
        at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper.run(AsynchronousActionExecutionQueueImpl.java:381)
        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.net.SocketException: Broken pipe
        at java.net.SocketOutputStream.socketWrite0(Native Method)
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
        at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
        at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
        at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3251)
        … 88 more


** END NESTED EXCEPTION **


        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
        at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1115)
        at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4111)
        at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4077)
        at org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:193)
        at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:964)
        at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:92)
        … 85 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Quelqu'un a une idée de mon problème ?

Merci bien 🙂

(posté aussi sur le forum EN : http://forums.alfresco.com/en/viewtopic.php?f=8&t=21348&p=82506#p82506)
(sur Jira : https://issues.alfresco.com/jira/browse/ALF-1918)
Labels:
0 Kudos
22 REPLIES 22

dranakan
Champ on-the-rise
Champ on-the-rise

‎03-03-2010 09:18 AM

Je vais

Le wa est à reste à 0 (Kernel : 2.6.18-164.11.1.el5xen)

vmstat
watch vmstat
procs ———–memory———- —swap– —–io—- –system– —–cpu——
 r  b   swpd   free   buff  cache   si   so    bi    bo   in   cs us sy id wa st
 3  0 110596 437864  16724 1157128    2    3    19    15   12   14 34 24 41  0  0‍‍‍‍

iostat historique
iostat
Linux 2.6.18-164.11.1.el5xen (ged)      03/03/2010

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
          34.23    0.00   24.26    0.13    0.02   41.35

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
xvda              2.29        38.93        30.14  116567953   90241054
xvda1             0.00         0.00         0.00       2014         22
xvda2             2.29        38.93        30.14  116565787   90241032
dm-0              3.88        34.24        25.11  102516482   75199480
dm-1              1.21         4.69         5.02   14049024   15041552‍‍‍‍‍‍‍‍‍‍‍‍


iostat 10 rapports à 2 secondes d'intervalle les uns des autres

iostat -d 2 10
Linux 2.6.18-164.11.1.el5xen (ged)      03/03/2010

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
xvda              2.29        38.93        30.14  116567953   90239542
xvda1             0.00         0.00         0.00       2014         22
xvda2             2.29        38.93        30.14  116565787   90239520
dm-0              3.88        34.24        25.11  102516482   75197968
dm-1              1.21         4.69         5.02   14049024   15041552

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
xvda              0.00         0.00         0.00          0          0
xvda1             0.00         0.00         0.00          0          0
xvda2             0.00         0.00         0.00          0          0
dm-0              0.00         0.00         0.00          0          0
dm-1              0.00         0.00         0.00          0          0

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
xvda              0.00         0.00         0.00          0          0
xvda1             0.00         0.00         0.00          0          0
xvda2             0.00         0.00         0.00          0          0
dm-0              0.00         0.00         0.00          0          0
dm-1              0.00         0.00         0.00          0          0

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
xvda              1.49         0.00        55.72          0        112
xvda1             0.00         0.00         0.00          0          0
xvda2             1.49         0.00        55.72          0        112
dm-0              6.97         0.00        55.72          0        112
dm-1              0.00         0.00         0.00          0          0

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
xvda              0.00         0.00         0.00          0          0
xvda1             0.00         0.00         0.00          0          0
xvda2             0.00         0.00         0.00          0          0
dm-0              0.00         0.00         0.00          0          0
dm-1              0.00         0.00         0.00          0          0

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
xvda              0.00         0.00         0.00          0          0
xvda1             0.00         0.00         0.00          0          0
xvda2             0.00         0.00         0.00          0          0
dm-0              0.00         0.00         0.00          0          0
dm-1              0.00         0.00         0.00          0          0

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
xvda              0.00         0.00         0.00          0          0
xvda1             0.00         0.00         0.00          0          0
xvda2             0.00         0.00         0.00          0          0
dm-0              0.00         0.00         0.00          0          0
dm-1              0.00         0.00         0.00          0          0

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
xvda              0.00         0.00         0.00          0          0
xvda1             0.00         0.00         0.00          0          0
xvda2             0.00         0.00         0.00          0          0
dm-0              0.00         0.00         0.00          0          0
dm-1              0.00         0.00         0.00          0          0

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
xvda              0.00         0.00         0.00          0          0
xvda1             0.00         0.00         0.00          0          0
xvda2             0.00         0.00         0.00          0          0
dm-0              0.00         0.00         0.00          0          0
dm-1              0.00         0.00         0.00          0          0

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
xvda              6.47         0.00        63.68          0        128
xvda1             0.00         0.00         0.00          0          0
xvda2             6.47         0.00        63.68          0        128
dm-0              7.96         0.00        63.68          0        128
dm-1              0.00         0.00         0.00          0          0

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
0 Kudos

dranakan
Champ on-the-rise
Champ on-the-rise

‎03-04-2010 02:39 AM

Demain après-midi je vais transférer tout le alf_data et la base sur le disque local.

J'ai remarqué qu'avec un alf_stop.sh, Java tournait toujours. Ai je d'autre choix que de killer java pour l'arrêter :?:
Mysql pourrait être un ralentissement (comme vous me l'avez suggéré), ai je un moyen de savoir si alfresco est en attente sur mysql  :?:  Cela n'influencerai que lors de l'indexage en background car quand on ajoute des fichiers, ou demande de l'information, alfresco répond immédiatement.

Merci bien 🙂
0 Kudos

rguinot
Confirmed Champ
Confirmed Champ

‎03-04-2010 04:24 AM

pour savoir ce sur quoi il bloque, un thread dump vous le dira.
avant de corriger la config mysql / jvm, commencez en effet par mettre les indexes en local.
d'autre part, sur votre serveur avec 1 CPU monocore 2.3 Ghz, 2GB RAM, est-ce vraiment nécessaire de mettre Alfresco dans une machine virtuelle ? votre serveur héberge-t-il d'autres VM ?
0 Kudos

dranakan
Champ on-the-rise
Champ on-the-rise

‎03-04-2010 04:51 AM

la config mentionnée plus haut était celle de la VM. Il y a effectivement plusieurs VM sur le même serveur.

Merci.
0 Kudos

dranakan
Champ on-the-rise
Champ on-the-rise

‎03-05-2010 10:33 AM

J'ai été contraint de killer java pour éteindre Alfresco.

Le alf_data (dont l'indexe) et la base Mysql sont sur un deuxième disque dans la machine virtuelle (directement lié au serveur).

Cela fait plus d'une heure que le serveur fonctionne et la CPU est toujours à 100%. Il lui faut peut-être un peu de temps pour finir ces tâches… Je redonne des news lundi matin.

Merci
0 Kudos

dranakan
Champ on-the-rise
Champ on-the-rise

‎03-08-2010 02:17 AM

Hello,

La CPU est toujours utilisée de façon excessive par Alfresco…

top - 08:07:29 up 2 days, 17:49,  1 user,  load average: 1.05, 1.02, 1.00
Tasks:  58 total,   1 running,  57 sleeping,   0 stopped,   0 zombie
Cpu(s): 56.7%us, 41.9%sy,  0.0%ni,  1.3%id,  0.1%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   2097328k total,  2078184k used,    19144k free,    85832k buffers
Swap:  1081336k total,       36k used,  1081300k free,  1565096k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
15362 alfresco  18   0 1434m 342m  12m S 99.8 16.7   3828:09 java
‍‍‍‍‍‍‍‍‍

Le travaille se fait toujours avec pdfbox :
49.0% CPU Usage by Thread 'DefaultScheduler_Worker-6'
  3/10 snapshots sharing following 48 elements
    sun.nio.ch.FileDispatcher.read0(Native Method)
    sun.nio.ch.FileDispatcher.read(FileDispatcher.java:26)
    sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:233)
    sun.nio.ch.IOUtil.read(IOUtil.java:206)
    sun.nio.ch.FileChannelImpl.read(FileChannelImpl.java:144)
    org.alfresco.repo.content.AbstractContentAccessor$CallbackFileChannel.read(AbstractContentAccessor.java:422)
    sun.nio.ch.ChannelInputStream.read(ChannelInputStream.java:48)
    sun.nio.ch.ChannelInputStream.read(ChannelInputStream.java:92)
    sun.nio.ch.ChannelInputStream.read(ChannelInputStream.java:86)
    java.io.BufferedInputStream.read1(BufferedInputStream.java:256)
    java.io.BufferedInputStream.read(BufferedInputStream.java:317)
    java.io.BufferedInputStream.read1(BufferedInputStream.java:256)
    java.io.BufferedInputStream.read(BufferedInputStream.java:317)
    java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
    java.io.BufferedInputStream.read(BufferedInputStream.java:237)
    java.io.FilterInputStream.read(FilterInputStream.java:66)
    java.io.PushbackInputStream.read(PushbackInputStream.java:122)
    org.apache.pdfbox.io.PushBackInputStream.read(PushBackInputStream.java:84)
    org.apache.pdfbox.pdfparser.BaseParser.parseCOSDictionary(BaseParser.java:200)
    org.apache.pdfbox.pdfparser.BaseParser.parseDirObject(BaseParser.java:870)
    org.apache.pdfbox.pdfparser.BaseParser.parseCOSDictionaryValue(BaseParser.java:141)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Je remarque que Mysql n'apparaît jamais en tête de liste avec la commande TOP. Je pars du principe qu'il n'est pas le goulet d'étranglement (ai-je un moyen plus efficace pour savoir s'il y a de l'attente sur Mysql) ?
0 Kudos

dranakan
Champ on-the-rise
Champ on-the-rise

‎03-08-2010 05:36 AM

J'ai copié les données sur une autre GED. En redémarrant, l'indexation travaille aussi (utilisation de la CPU à 100%). Cela me permet de faire des tests.

Pour commencer, je vais changer les arguments de démarrage :

/usr/java/jdk1.6.0_17/bin/java -server -Xcomp -Xbatch -Xss1M -Xms1G -Xmx1500m -XX:+UseConcMarkSweepGC -XX:+CMSIncrementalMode -XX:NewSize=512m -XX:MaxPermSize=128M -XX:CMSInitiatingOccupancyFraction=80 -Dalfresco.home=/opt/Alfresco -Dcom.sun.management.jmxremote -XX:CompileCommand=exclude,org/apache/lucene/index/IndexReader$1,doBody -XX:CompileCommand=exclude,org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger,mergeIndexes -XX:CompileCommand=exclude,org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger,mergeDeletions -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=/opt/Alfresco/tomcat/conf/logging.properties -Djava.endorsed.dirs=/opt/Alfresco/tomcat/endorsed -classpath :/opt/Alfresco/tomcat/bin/bootstrap.jar -Dcatalina.base=/opt/Alfresco/tomcat -Dcatalina.home=/opt/Alfresco/tomcat -Djava.io.tmpdir=/opt/Alfresco/tomcat/temp org.apache.catalina.startup.Bootstrap start‍
La machine dipose de 2 GB de Ram.
http://wiki.alfresco.com/wiki/Repository_Hardware

Je vais laisser tourner 1 jour. Si cela n'a pas d'impact, je vais modifier ensuite la configuration de Mysql.
0 Kudos

dranakan
Champ on-the-rise
Champ on-the-rise

‎03-09-2010 03:50 AM

La CPU tourne toujours à fond… bien qu'aucun nouveau document ait été ajouté. Je vais laisser tourner encore moment.

Je ne pense pas que Mysql soit le ralentissement car si on regarde les processus, on voit qu'il ne travaille pas :

mysqladmin processlist -u root -p
Enter password:
+—–+———-+—————–+———-+———+——+——-+——– ———-+
| Id  | User     | Host            | db       | Command | Time | State | Info            |
+—–+———-+—————–+———-+———+——+——-+——– ———-+
| 323 | alfresco | localhost:47685 | alfresco | Sleep   | 22   |       |                |
| 324 | alfresco | localhost:47686 | alfresco | Sleep   | 682  |       |              |
| 325 | alfresco | localhost:47687 | alfresco | Sleep   | 7    |       |                   |
| 333 | root     | localhost       |          | Query   | 0    |       | show processlist |
+—–+———-+—————–+———-+———+——+——-+——————+‍‍‍‍‍‍‍‍‍‍

Serait-ce possible que l'indexage tourne en rond sur un document ? Est-il possible de savoir où il en est ? Par exemple qu'il dise j'ai indexé 456 fichiers sur 12'345.
Si quelqu'un a une idée…

Merci bien 🙂
0 Kudos

dranakan
Champ on-the-rise
Champ on-the-rise

‎03-09-2010 09:08 AM

J'ai tenté de désactiver le CIFS, pas de changement.

J'ai tenté un FULL indexage. J'ai été surpris car il a fait ça très rapidement (moins de 4 minutes pour 1600 PDFs). Juste après le redémarrage, il y a eu ceci :

14:38:37,535  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
14:38:37,599  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
14:38:37,601  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/opt/Alfresco/tomcat/shared/classes/alfresco-global.properties]
14:38:37,992  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
14:39:05,902  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from file [/opt/Alfresco/tomcat/shared/classes/alfresco/extension/subsystems/Authentication/ldap/ldap1/ldap-authentication.properties]
14:39:38,293  INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
14:39:40,757  INFO  [domain.schema.SchemaBootstrap] No changes were made to the schema.
14:39:41,346  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
14:39:41,489  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
14:39:41,590  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
14:39:53,221  INFO  [node.index.FullIndexRecoveryComponent] Index recovery started: 5,368 transactions.
14:39:53,377  INFO  [node.index.FullIndexRecoveryComponent]     10 % complete.
14:40:05,797  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'thirdparty' subsystem, ID: [thirdparty, default]
14:40:06,294  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
14:40:12,160  WARN  [alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
14:40:12,161  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [thirdparty, default] complete
14:40:30,729  ERROR [index.AbstractReindexComponent.threads] Reindexer     5 failed with error: 02090001 Failed to prepare: requires rollback.
### Excluding compile: org.alfresco.repo.search.impl.lucene.index.IndexInfo$Merger::mergeDeletions
14:40:31,176  ERROR [index.AbstractReindexComponent.threads] Reindexer     6 failed with error: 02090003 Failed to prepare: requires rollback.
14:40:34,536  ERROR [index.AbstractReindexComponent.threads] Reindexer     7 failed with error: 02090007 Failed to prepare: requires rollback.
### Excluding compile: org.alfresco.repo.search.impl.lucene.index.IndexInfo$Merger::mergeIndexes
14:40:34,873  ERROR [index.AbstractReindexComponent.threads] Reindexer     8 failed with error: 02090005 Failed to prepare: requires rollback.
14:40:39,774  INFO  [node.index.FullIndexRecoveryComponent]     20 % complete.
14:40:39,775  INFO  [node.index.FullIndexRecoveryComponent]     30 % complete.
14:40:46,578  INFO  [node.index.FullIndexRecoveryComponent]     40 % complete.
14:40:46,578  INFO  [node.index.FullIndexRecoveryComponent]     50 % complete.
14:40:50,605  INFO  [node.index.FullIndexRecoveryComponent]     60 % complete.
14:40:50,606  INFO  [node.index.FullIndexRecoveryComponent]     70 % complete.
14:40:53,752  INFO  [node.index.FullIndexRecoveryComponent]     80 % complete.
14:40:53,753  INFO  [node.index.FullIndexRecoveryComponent]     90 % complete.
14:40:56,798  INFO  [node.index.FullIndexRecoveryComponent]     100 % complete.
14:40:58,070  INFO  [node.index.FullIndexRecoveryComponent] Index recovery completed.
14:40:58,183  INFO  [node.index.AVMFullIndexRecoveryComponent] Rebuilding indexes for 1 AVM Stores
14:40:58,199  INFO  [node.index.AVMFullIndexRecoveryComponent]     Rebuilding index for sitestore
14:40:58,455  INFO  [node.index.AVMFullIndexRecoveryComponent]   Reindex   100% complete
14:40:58,455  INFO  [node.index.AVMFullIndexRecoveryComponent] Finished rebuilding indexes for AVM Stores
14:40:59,659  INFO  [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /backup/alf_data
14:40:59,694  INFO  [admin.patch.PatchExecuter] Checking for patches to apply …
14:41:00,155  INFO  [admin.patch.PatchExecuter] No patches were required.
14:41:00,308 User:System INFO  [repo.module.ModuleServiceImpl] Found 1 module(s).
14:41:00,570 User:System INFO  [repo.module.ModuleServiceImpl] Starting module 'ch.custom.alfresco.module.manageoffice' version 1.2.0.
14:41:00,744  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'fileServers' subsystem, ID: [fileServers, default]
14:41:01,313  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
14:41:02,582  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'Authentication' subsystem, ID: [Authentication, managed, passthru1]
14:41:02,599  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
14:41:03,167  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'Authentication' subsystem, ID: [Authentication, managed, passthru1] complete
14:41:03,167  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'Authentication' subsystem, ID: [Authentication, managed, ldap1]
14:41:03,200  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
14:41:04,329  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'Authentication' subsystem, ID: [Authentication, managed, ldap1] complete
14:41:04,437  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'fileServers' subsystem, ID: [fileServers, default] complete
14:41:04,437  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'imap' subsystem, ID: [imap, default]
14:41:04,445  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
14:41:04,790  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'imap' subsystem, ID: [imap, default] complete
14:41:04,896  INFO  [repo.usage.UserUsageTrackingComponent] Enabled - calculate missing user usages …
14:41:04,988  INFO  [repo.usage.UserUsageTrackingComponent] Found 0 users to recalculate
14:41:04,988  INFO  [repo.usage.UserUsageTrackingComponent] … calculated missing usages for 0 users
14:41:04,988  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'Synchronization' subsystem, ID: [Synchronization, default]
14:41:04,995  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
14:41:07,067  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'Synchronization' subsystem, ID: [Synchronization, default] complete
14:41:14,348  INFO  [service.descriptor.DescriptorService] Alfresco JVM - v1.6.0_17-b04; maximum heap size 1448.813MB
14:41:14,358  INFO  [service.descriptor.DescriptorService] Alfresco started (Community): Current version 3.2.0 (r2 2440) schema 3300 - Originally installed version 3.2.0 (r2 2440) schema 3300
14:41:30,459  INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'wcm_deployment_receiver' subsystem, ID: [wcm_deployment_receiver, default]
14:41:30,537  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
14:41:30,883  INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'wcm_deployment_receiver' subsystem, ID: [wcm_deployment_receiver, default] complete
Mar 9, 2010 2:41:36 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Mar 9, 2010 2:41:36 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 200360 ms
14:42:24,285  ERROR [pdfbox.filter.FlateFilter] Stop reading corrupt stream
14:42:32,232  ERROR [pdfbox.filter.FlateFilter] Stop reading corrupt stream
14:42:36,991  ERROR [pdfbox.filter.FlateFilter] Stop reading corrupt stream
14:42:42,989  ERROR [pdfbox.filter.FlateFilter] Stop reading corrupt stream
14:42:44,048  ERROR [pdfbox.filter.FlateFilter] Stop reading corrupt stream
14:42:49,617  ERROR [pdfbox.filter.FlateFilter] Stop reading corrupt stream
14:42:55,710  ERROR [pdfbox.filter.FlateFilter] Stop reading corrupt stream
14:42:57,667  ERROR [pdfbox.filter.FlateFilter] Stop reading corrupt stream

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
J'avais déjà vu ce problème (apparaissait de temps en temps :10x en deux mois) : http://forums.alfresco.com/en/viewtopic.php?f=8&t=24033
0 Kudos

dranakan
Champ on-the-rise
Champ on-the-rise

‎03-10-2010 03:43 AM

Hello,

Suivant les conseils de rguinot, j'ai amélioré la configuration de mysql (attention, je suis pas un expert en Mysql, j'ai juste incrémenté quelques champs).

/etc/my.cnf
[mysqld]
datadir=/backup/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /backup/mysql/
innodb_data_file_path = ibdata1:10M:autoextend

# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 512M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 128M ERROR IN Alfresco WHEN UNCOMMENT :  Failed to dump normalized, pre-upgrade schema to file.  Error: Incorrect information in file: './alfresco/JBPM_ACTION.frm'
innodb_log_buffer_size = 256M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_thread_concurrency=8
innodb_flush_method=O_DIRECT
transaction-isolation=READ-COMMITTED

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Effect sur le serveur Mysql
mysql> show variables;
+———————————+————————————————————+
| Variable_name                   | Value                                                      |
+———————————+————————————————————+
| auto_increment_increment        | 1                                                          |
| auto_increment_offset           | 1                                                          |
| automatic_sp_privileges         | ON                                                         |
| back_log                        | 50                                                         |
| basedir                         | /usr/                                                      |
| bdb_cache_size                  | 8384512                                                    |
| bdb_home                        | /backup/mysql/                                             |
| bdb_log_buffer_size             | 262144                                                     |
| bdb_logdir                      |                                                            |
| bdb_max_lock                    | 10000                                                      |
| bdb_shared_data                 | OFF                                                        |
| bdb_tmpdir                      | /tmp/                                                      |
| binlog_cache_size               | 32768                                                      |
| bulk_insert_buffer_size         | 8388608                                                    |
| character_set_client            | latin1                                                     |
| character_set_connection        | latin1                                                     |
| character_set_database          | latin1                                                     |
| character_set_filesystem        | binary                                                     |
| character_set_results           | latin1                                                     |
| character_set_server            | latin1                                                     |
| character_set_system            | utf8                                                       |
| character_sets_dir              | /usr/share/mysql/charsets/                                 |
| collation_connection            | latin1_swedish_ci                                          |
| collation_database              | latin1_swedish_ci                                          |
| collation_server                | latin1_swedish_ci                                          |
| completion_type                 | 0                                                          |
| concurrent_insert               | 1                                                          |
| connect_timeout                 | 10                                                         |
| datadir                         | /backup/mysql/                                             |
| date_format                     | %Y-%m-%d                                                   |
| datetime_format                 | %Y-%m-%d %H:%i:%s                                          |
| default_week_format             | 0                                                          |
| delay_key_write                 | ON                                                         |
| delayed_insert_limit            | 100                                                        |
| delayed_insert_timeout          | 300                                                        |
| delayed_queue_size              | 1000                                                       |
| div_precision_increment         | 4                                                          |
| keep_files_on_create            | OFF                                                        |
| engine_condition_pushdown       | OFF                                                        |
| expire_logs_days                | 0                                                          |
| flush                           | OFF                                                        |
| flush_time                      | 0                                                          |
| ft_boolean_syntax               | + -><()~*:""&|                                             |
| ft_max_word_len                 | 84                                                         |
| ft_min_word_len                 | 4                                                          |
| ft_query_expansion_limit        | 20                                                         |
| ft_stopword_file                | (built-in)                                                 |
| group_concat_max_len            | 1024                                                       |
| have_archive                    | NO                                                         |
| have_bdb                        | YES                                                        |
| have_blackhole_engine           | NO                                                         |
| have_compress                   | YES                                                        |
| have_crypt                      | YES                                                        |
| have_csv                        | NO                                                         |
| have_dynamic_loading            | YES                                                        |
| have_example_engine             | NO                                                         |
| have_federated_engine           | NO                                                         |
| have_geometry                   | YES                                                        |
| have_innodb                     | YES                                                        |
| have_isam                       | NO                                                         |
| have_merge_engine               | YES                                                        |
| have_ndbcluster                 | NO                                                         |
| have_openssl                    | DISABLED                                                   |
| have_ssl                        | DISABLED                                                   |
| have_query_cache                | YES                                                        |
| have_raid                       | NO                                                         |
| have_rtree_keys                 | YES                                                        |
| have_symlink                    | YES                                                        |
| hostname                        | ged-devel                                                  |
| init_connect                    |                                                            |
| init_file                       |                                                            |
| init_slave                      |                                                            |
| innodb_additional_mem_pool_size | 2097152                                                    |
| innodb_autoextend_increment     | 8                                                          |
| innodb_buffer_pool_awe_mem_mb   | 0                                                          |
| innodb_buffer_pool_size         | 536870912                                                  |
| innodb_checksums                | ON                                                         |
| innodb_commit_concurrency       | 0                                                          |
| innodb_concurrency_tickets      | 500                                                        |
| innodb_data_file_path           | ibdata1:10M:autoextend                                     |
| innodb_data_home_dir            |                                                            |
| innodb_adaptive_hash_index      | ON                                                         |
| innodb_doublewrite              | ON                                                         |
| innodb_fast_shutdown            | 1                                                          |
| innodb_file_io_threads          | 4                                                          |
| innodb_file_per_table           | OFF                                                        |
| innodb_flush_log_at_trx_commit  | 1                                                          |
| innodb_flush_method             | O_DIRECT                                                   |
| innodb_force_recovery           | 0                                                          |
| innodb_lock_wait_timeout        | 50                                                         |
| innodb_locks_unsafe_for_binlog  | OFF                                                        |
| innodb_log_arch_dir             |                                                            |
| innodb_log_archive              | OFF                                                        |
| innodb_log_buffer_size          | 268435456                                                  |
| innodb_log_file_size            | 5242880                                                    |
| innodb_log_files_in_group       | 2                                                          |
| innodb_log_group_home_dir       | ./                                                         |
| innodb_max_dirty_pages_pct      | 90                                                         |
| innodb_max_purge_lag            | 0                                                          |
| innodb_mirrored_log_groups      | 1                                                          |
| innodb_open_files               | 300                                                        |
| innodb_rollback_on_timeout      | OFF                                                        |
| innodb_support_xa               | ON                                                         |
| innodb_sync_spin_loops          | 20                                                         |
| innodb_table_locks              | ON                                                         |
| innodb_thread_concurrency       | 8                                                          |
| innodb_thread_sleep_delay       | 10000                                                      |
| interactive_timeout             | 28800                                                      |
| join_buffer_size                | 131072                                                     |
| key_buffer_size                 | 8384512                                                    |
| key_cache_age_threshold         | 300                                                        |
| key_cache_block_size            | 1024                                                       |
| key_cache_division_limit        | 100                                                        |
| language                        | /usr/share/mysql/english/                                  |
| large_files_support             | ON                                                         |
| large_page_size                 | 0                                                          |
| large_pages                     | OFF                                                        |
| lc_time_names                   | en_US                                                      |
| license                         | GPL                                                        |
| local_infile                    | ON                                                         |
| locked_in_memory                | OFF                                                        |
| log                             | OFF                                                        |
| log_bin                         | OFF                                                        |
| log_bin_trust_function_creators | OFF                                                        |
| log_error                       |                                                            |
| log_queries_not_using_indexes   | OFF                                                        |
| log_slave_updates               | OFF                                                        |
| log_slow_queries                | OFF                                                        |
| log_warnings                    | 1                                                          |
| long_query_time                 | 10                                                         |
| low_priority_updates            | OFF                                                        |
| lower_case_file_system          | OFF                                                        |
| lower_case_table_names          | 0                                                          |
| max_allowed_packet              | 1048576                                                    |
| max_binlog_cache_size           | 4294963200                                                 |
| max_binlog_size                 | 1073741824                                                 |
| max_connect_errors              | 10                                                         |
| max_connections                 | 100                                                        |
| max_delayed_threads             | 20                                                         |
| max_error_count                 | 64                                                         |
| max_heap_table_size             | 16777216                                                   |
| max_insert_delayed_threads      | 20                                                         |
| max_join_size                   | 4294967295                                                 |
| max_length_for_sort_data        | 1024                                                       |
| max_prepared_stmt_count         | 16382                                                      |
| max_relay_log_size              | 0                                                          |
| max_seeks_for_key               | 4294967295                                                 |
| max_sort_length                 | 1024                                                       |
| max_sp_recursion_depth          | 0                                                          |
| max_tmp_tables                  | 32                                                         |
| max_user_connections            | 0                                                          |
| max_write_lock_count            | 4294967295                                                 |
| multi_range_count               | 256                                                        |
| myisam_data_pointer_size        | 6                                                          |
| myisam_max_sort_file_size       | 2146435072                                                 |
| myisam_recover_options          | OFF                                                        |
| myisam_repair_threads           | 1                                                          |
| myisam_sort_buffer_size         | 8388608                                                    |
| myisam_stats_method             | nulls_unequal                                              |
| net_buffer_length               | 16384                                                      |
| net_read_timeout                | 30                                                         |
| net_retry_count                 | 10                                                         |
| net_write_timeout               | 60                                                         |
| new                             | OFF                                                        |
| old_passwords                   | ON                                                         |
| open_files_limit                | 1024                                                       |
| optimizer_prune_level           | 1                                                          |
| optimizer_search_depth          | 62                                                         |
| pid_file                        | /var/run/mysqld/mysqld.pid                                 |
| plugin_dir                      |                                                            |
| port                            | 3306                                                       |
| preload_buffer_size             | 32768                                                      |
| profiling                       | OFF                                                        |
| profiling_history_size          | 15                                                         |
| protocol_version                | 10                                                         |
| query_alloc_block_size          | 8192                                                       |
| query_cache_limit               | 1048576                                                    |
| query_cache_min_res_unit        | 4096                                                       |
| query_cache_size                | 0                                                          |
| query_cache_type                | ON                                                         |
| query_cache_wlock_invalidate    | OFF                                                        |
| query_prealloc_size             | 8192                                                       |
| range_alloc_block_size          | 4096                                                       |
| read_buffer_size                | 131072                                                     |
| read_only                       | OFF                                                        |
| read_rnd_buffer_size            | 262144                                                     |
| relay_log                       |                                                            |
| relay_log_index                 |                                                            |
| relay_log_info_file             | relay-log.info                                             |
| relay_log_purge                 | ON                                                         |
| relay_log_space_limit           | 0                                                          |
| rpl_recovery_rank               | 0                                                          |
| secure_auth                     | OFF                                                        |
| secure_file_priv                |                                                            |
| server_id                       | 0                                                          |
| skip_external_locking           | ON                                                         |
| skip_networking                 | OFF                                                        |
| skip_show_database              | OFF                                                        |
| slave_compressed_protocol       | OFF                                                        |
| slave_load_tmpdir               | /tmp/                                                      |
| slave_net_timeout               | 3600                                                       |
| slave_skip_errors               | OFF                                                        |
| slave_transaction_retries       | 10                                                         |
| slow_launch_time                | 2                                                          |
| socket                          | /var/lib/mysql/mysql.sock                                  |
| sort_buffer_size                | 2097144                                                    |
| sql_big_selects                 | ON                                                         |
| sql_mode                        |                                                            |
| sql_notes                       | ON                                                         |
| sql_warnings                    | OFF                                                        |
| ssl_ca                          |                                                            |
| ssl_capath                      |                                                            |
| ssl_cert                        |                                                            |
| ssl_cipher                      |                                                            |
| ssl_key                         |                                                            |
| storage_engine                  | MyISAM                                                     |
| sync_binlog                     | 0                                                          |
| sync_frm                        | ON                                                         |
| system_time_zone                | CET                                                        |
| table_cache                     | 64                                                         |
| table_lock_wait_timeout         | 50                                                         |
| table_type                      | MyISAM                                                     |
| thread_cache_size               | 0                                                          |
| thread_stack                    | 196608                                                     |
| time_format                     | %H:%i:%s                                                   |
| time_zone                       | SYSTEM                                                     |
| timed_mutexes                   | OFF                                                        |
| tmp_table_size                  | 33554432                                                   |
| tmpdir                          | /tmp/                                                      |
| transaction_alloc_block_size    | 8192                                                       |
| transaction_prealloc_size       | 4096                                                       |
| tx_isolation                    | READ-COMMITTED                                             |
| updatable_views_with_limit      | YES                                                        |
| version                         | 5.0.77                                                     |
| version_bdb                     | Sleepycat Software: Berkeley DB 4.1.24: (January 29, 2009) |
| version_comment                 | Source distribution                                        |
| version_compile_machine         | i686                                                       |
| version_compile_os              | redhat-linux-gnu                                           |
| wait_timeout                    | 28800                                                      |
+———————————+————————————————————+
239 rows in set (0.00 sec)

mysql>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍


Je note aussi que la CPU commence à s'affoler, après démarrage, uniquement quand j'envoie un document (peut importe sa provenance (PDF du scanner, PDF générer depuis Word, Document Word, …). Alfresco indique :

Mar 10, 2010 9:31:00 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Mar 10, 2010 9:31:00 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 143203 ms
09:32:47,789  ERROR [pdfbox.filter.FlateFilter] Stop reading corrupt stream
09:32:56,819  ERROR [pdfbox.filter.FlateFilter] Stop reading corrupt stream
09:33:01,131  ERROR [pdfbox.filter.FlateFilter] Stop reading corrupt stream
09:33:07,011  ERROR [pdfbox.filter.FlateFilter] Stop reading corrupt stream
09:33:08,923  ERROR [pdfbox.filter.FlateFilter] Stop reading corrupt stream
09:33:13,804  ERROR [pdfbox.filter.FlateFilter] Stop reading corrupt stream
09:33:19,382  ERROR [pdfbox.filter.FlateFilter] Stop reading corrupt stream
09:33:20,690  ERROR [pdfbox.filter.FlateFilter] Stop reading corrupt stream
‍‍‍‍‍‍‍‍‍‍‍‍‍
Après ceci, CPU à 100%, mais le serveur est parfaitement fonctionnel.

Besoin d'aide…
0 Kudos
Getting started

Tags

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.

Copyright © 2025 Khoros, LLC