CIFS disconections in alfresco 3.0

[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?

[dmatejka]

Problem is partialy solved by setting proper values in:

tomcat/webapps/alfresco/WEB-INF/classes/alfresco/file-servers.properties

This solved database errors. What is still there is:

- java.io.IOException: Connection reset by peer
- org.alfresco.service.cmr.repository.InvalidNodeRefException: Node does not exist: workspace://SpacesStore/2ab79587-f0a6-4f57-b63b-aa50049a6948

[alberto]

I'm testing 3 stable and I'm also having both problems. What settings did you use in tomcat/webapps/alfresco/WEB-INF/classes/alfresco/file-servers.properties to get rid of the first problem?
Another problem that I'm having and it often appears around the same time is UserTransaction being garbage collected without a commit() or rollback(). Does it happen to you too?

[dmatejka]

Hi,
settings should reflect your network setup:

cifs.localname=${localname}    -> you can leave it like this
cifs.domain=            -> your windows domain/workgroup
cifs.broadcast=192.168.1.255    -> your network broadcast address -> ifconfig | grep Bcast

this will help with cifs share problems.

We have installed 3 Labs STABLE recently.. but had no time to test CIFS thoroughly yet..

hope this helps a bit..

[alberto]

Same thing that I have.
I'll keep testing

[dmatejka]

well.. we are having serious troubles with CIFS's stability now..

we have tried all the builds available till today and we cannot get CIFS running correctly… still disconnecting and not working properly.. ends up with not working at all at least once per testing day…

there is an issue raised https://issues.alfresco.com/jira/browse/ETHREEOH-1553
that we had commented on 06-Mar-09 10:22 AM and it seems that we had not been alone who encounter this problems.

kind of frustrated now as whole our implementation of alfresco is counting with CIFS protocol because our files, in the workflow, contains links to the other documents and these links MUST by in CIFS format (anybody ever working in DTP with Adobe InDesign under Windows knows what I am talking about).

We had some problems when running alfresco 2.1, but it was usable.
Now we would love to customize our internal user interface and also offer some of the services to our customers using alfresco GUI. Unfortunately, we do not have any java full-time coder available. From this point of view SHARE would be close to the ideal solution… easy flex integration would be the best.

We are now facing a dilemma what to do as waiting for the "stable of the stable" seems not having end..

Or does anybody have alfresco 3.0 working and using CIFS in their workflow?  ..if yes there is a chance we are doing something wrong.. but I swear, we have tried everything..