`nextcloud` SQL error `Database is locked` when using selective sync list

[shahzebs]

How to use GitHub

• Please use the 👍 reaction to show that you are affected by the same issue.
• Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
• Subscribe to receive notifications on status change and new comments.

Expected behaviour

When running the nextcloudcmd cli tool with --unsyncedfolders <path to file with selective sync list> I expect the selective sync to complete within reasonable time and without errors.

Actual behaviour

With a selective sync file formatted as

folder1/
folder2/

I get the following log outputs when doing a selective sync:

06-09 19:57:41:706 [ debug nextcloud.sync.database.sql ]    [ OCC::SqlQuery::exec ]:    SQL exec "SELECT path FROM selectivesync WHERE type=?1"
06-09 19:57:41:706 [ debug nextcloud.sync.database.sql ]    [ OCC::SqlQuery::bindValue ]:   SQL bind 1 1
06-09 19:57:41:706 [ debug nextcloud.sync.database.sql ]    [ OCC::SqlQuery::exec ]:    SQL exec "DELETE FROM selectivesync WHERE type == ?1"
06-09 19:59:23:977 [ warning nextcloud.sync.database.sql ]: Sqlite exec statement error: 5 "database is locked" in "DELETE FROM selectivesync WHERE type == ?1"
06-09 19:59:23:977 [ warning nextcloud.sync.database ]: SQL error when deleting selective sync list ("folder1/", "folder2/") "database is locked"
06-09 19:59:23:980 [ debug nextcloud.sync.database.sql ]    [ OCC::SqlQuery::bindValue ]:   SQL bind 1 "folder1/"
06-09 19:59:23:980 [ debug nextcloud.sync.database.sql ]    [ OCC::SqlQuery::bindValue ]:   SQL bind 2 1
06-09 19:59:23:980 [ debug nextcloud.sync.database.sql ]    [ OCC::SqlQuery::exec ]:    SQL exec "INSERT INTO selectivesync VALUES (?1, ?2)"
06-09 20:01:06:251 [ warning nextcloud.sync.database.sql ]: Sqlite exec statement error: 5 "database is locked" in "INSERT INTO selectivesync VALUES (?1, ?2)"
06-09 20:01:06:251 [ warning nextcloud.sync.database ]: SQL error when inserting into selective sync 1 "folder1/" "database is locked"
06-09 20:01:06:251 [ debug nextcloud.sync.database.sql ]    [ OCC::SqlQuery::bindValue ]:   SQL bind 1 "folder2/"
06-09 20:01:06:251 [ debug nextcloud.sync.database.sql ]    [ OCC::SqlQuery::bindValue ]:   SQL bind 2 1
06-09 20:01:06:251 [ debug nextcloud.sync.database.sql ]    [ OCC::SqlQuery::exec ]:    SQL exec "INSERT INTO selectivesync VALUES (?1, ?2)"
06-09 20:02:48:523 [ warning nextcloud.sync.database.sql ]: Sqlite exec statement error: 5 "database is locked" in "INSERT INTO selectivesync VALUES (?1, ?2)"
06-09 20:02:48:523 [ warning nextcloud.sync.database ]: SQL error when inserting into selective sync 1 "folder2/" "database is locked"

The selective sync takes a long time, much longer than syncing non-selectively. Note the time stamps 19:57:41 to 19:59:23. But the sync is correct, i.e. the remote folders I want to exclude are excluded from the sync.

Steps to reproduce

1. Sync files to a new source directory with selective sync. It should complete normally.
2. Do another selective sync run and this starts happening.

Client configuration

Client version: Nextcloud version 3.2.2git Git revision 04afaa1fe62133480272ba5e660dd5f773356cd6 Using Qt 5.15.2, built against Qt 5.15.2 Using 'OpenSSL 1.1.1k 25 Mar 2021' Running on Arch Linux, x86_64

Operating system: Arch Linux

Server configuration

Nextcloud version: latest docker image

Storage backend (external storage): mariadb latest docker image

[github-actions[bot]]

This bug report did not receive an update in the last 4 weeks. Please take a look again and update the issue with new details, otherwise the issue will be automatically closed in 2 weeks. Thank you!

[github-actions[bot]]

This bug report is getting automatically closed due to no answer since the issue has been staled. Thank you!

[aHcVolle]

is there any fix yet?

[sebastianschauenburg]

had a similar issue, but in my case it was 'fixed' by removing the line in the unsyncedfolders file (which is a list containing the unsynced folders). In my case the unsynced folder mentioned, was not present anymore on the server side.

[mayonezo]

Same issue for me. Additionally, I would really appreciate documentation or an example of an unsyncedfolders file.

[Haelle]

same issue here

[rainbowbreeze]

Likewise. Both for the error, and fo a working example of a --unsyncedfolders file