Nextcloud: Operation Cancelled & Server Locks Errors

AlyRagab

Hi All,

I have an issue using the Nextcloud version " Latest " with Nextcloud App version 13.0.2 " "Stable "
and we are using the OpenLDAP for access , when a user has shared a specific files to other user and want to sync what he is working on using the Desktop Client , we have the message as " Operation Cancelled & Server Locks "

when i checked the logs it was " deadlock found when trying to get lock try restarting transaction "
and according to this link from SOF Deadlock-Issue
want to know why the database locks the files , it is supposed to allow only one sync access for the owner , so any dvice ?

Thanks in advance.

AlyRagab

The problem is solved after the below changes on the Databases:

SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;

To verify :

SELECT @@GLOBAL.tx_isolation, @@tx_isolation

JaredBusch

I do not use LDAP for access rights.

I have also never had that error.

Sorry to be of little help.

AlyRagab

The solution from the database settings side "Mariadb" according to the below 2 links:
i will check it and post if the issue is resolved.

SOF Reference
Owncloud Reference

scottalanmiller

@alyragab said in Nextcloud: Operation Cancelled & Server Locks Errors:

The solution from the database settings side "Mariadb" according to the below 2 links:
i will check it and post if the issue is resolved.

SOF Reference

This is for code you wrote yourself. Won't be very useful here.

scottalanmiller

Check the system logs. This could be caused by an error, including bad blocks on the disks.

AlyRagab

The problem is solved after the below changes on the Databases:

SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;

To verify :

SELECT @@GLOBAL.tx_isolation, @@tx_isolation

Solved Nextcloud: Operation Cancelled & Server Locks Errors