Nextcloud: Operation Cancelled & Server Locks Errors



  • 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.



  • 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


  • I do not use LDAP for access rights.

    I have also never had that error.

    Sorry to be of little help.



  • 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



  • @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.



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



  • 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

Log in to reply