AnsweredAssumed Answered

CIFS disconections in alfresco 3.0

Question asked by dmatejka on Nov 28, 2008
Latest reply on Mar 31, 2009 by dmatejka
Hi,
we have encountered very bad CIFS performance on Alfresco.
Alfresco version: 3.0.0 (c 1316) schema 1000

When user opens file from alfresco cifs share for editing in associated
application and do Save from application, exception is thrown:

org.springframework.dao.CannotAcquireLockException: Hibernate operation:
could not update: [org.alfresco.
repo.domain.hibernate.NodeImpl#529]; SQL [update alf_node set version=?,
store_id=?, uuid=?, transaction_
id=?, node_deleted=?, type_qname_id=?, acl_id=?, audit_creator=?,
audit_created=?, audit_modifier=?, audi
t_modified=?, audit_accessed=? where id=? and version=?]; Lock wait timeout
exceeded; try restarting tran
saction; nested exception is java.sql.SQLException: Lock wait timeout
exceeded; try restarting transactio
n
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try
restarting transaction
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
        at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
        at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
        at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.
java:101)
        at
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:241
2)
        at
org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.
java:2312)
        at
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:261
2)

This happens mainly during Save from application (e.g. Indesign), but also while copping from local to mapped drive.
MySQLversion is 5.0.37. We are running on Slackware Linux.

This scenario is essential for our use case.. we had no luck in solving this problem for quite a long time now  :cry:  .

Does anybody has a solution or any idea how to solve this problem?

Outcomes