nextCloudCmd throws error 'Sqlite exec statement error: 5 "database is locked"'

[pb-businessacts]

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

nextCloudCmd shoud start and work.

Actual behaviour

I get the error 'Sqlite exec statement error: 5 "database is locked" (see screenshot) and somtimes after a long waitingtime the synchronisation starts.

Steps to reproduce

1. Start nexcloudCmd for initialize the clientside files
2. After initial sychronisation start nextcloudCmd again

My call:
"C:\Program Files (x86)\appdir\nextcloudcmd.exe" --trust --path "sellify_documents_dev/sellifyontoursync" --non-interactive -u myuser -p mypassword --unsyncedfolders "C:\Program Files (x86)\IgnoreLists\default_ignore.txt" C:\sellify_documents https://myserver/nextcloud

Client configuration

Client version:
Nextcloud version 3.3.2stable-Win64 (build 20210826)
Git revision 50453d9
Using Qt 5.12.9, built against Qt 5.12.9
Using 'OpenSSL 1.1.1g 21 Apr 2020'
Running on Windows Server 2016 (10.0), x86_64

Operating system:
Windows Server 2019 Standard 64bit

OS language:
German

Installation path of client:

Storage backend (external storage):
Networkdrive

[FlexW]

Is your nextcloud client running? You probably need to stop it. The database gets locked exclusively by it.

[pb-businessacts]

No, nextCloudClient is not running on this machine.

[Tachi107]

Maybe this happens because the exclusive lock is not released when nextcloudcmd terminates?

Edit: this seems related to #3422 and maybe #3222

[github-actions]

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!

[Senth]

I get the same problem, and with 10+ folders to sync, this means my sync takes approx 10min when I used selective sync.

Also commenting so this issue won't be closed like the two others :(

[beardhatcode]

I also have this issue with:

Nextcloud version 3.3.6git
Git revision 6d3270dd251db42293233d5622a610ea172dabef
Using Qt 5.15.3, built against Qt 5.15.3
Using 'OpenSSL 1.1.1l  24 Aug 2021'
Running on NixOS 22.05 (Quokka), x86_64

[uwe347]

Same problem with:

$ nextcloudcmd --version
Nextcloud version 3.4.0-20211129.184724.c004db207-1.0~focal1
Using Qt 5.12.8, built against Qt 5.12.8
Using 'OpenSSL 1.1.1f  31 Mar 2020'
Running on Ubuntu 20.04.3 LTS, x86_64

I observed that this only happens together with option --unsyncedfolders. Logging output shows:

12-01 09:23:47:292 [ info nextcloud.sync.database ]:	sqlite3 version "3.31.1"
12-01 09:23:47:292 [ info nextcloud.sync.database ]:	sqlite3 locking_mode= "exclusive"
12-01 09:23:47:292 [ info nextcloud.sync.database ]:	sqlite3 journal_mode= "wal"
12-01 09:23:47:292 [ info nextcloud.sync.database ]:	sqlite3 synchronous= "NORMAL"
12-01 09:25:29:542 [ warning nextcloud.sync.database.sql ]:	Sqlite exec statement error: 5 "database is locked" in "UPDATE metadata SET md5='_invalid_' WHERE (?1 == path OR (?1 > (path||'/') AND ?1 < (path||'0'))) AND type == 2;"
12-01 09:27:11:788 [ warning nextcloud.sync.database.sql ]:	Sqlite exec statement error: 5 "database is locked" in "DELETE FROM selectivesync WHERE type == ?1"
12-01 09:27:11:788 [ warning nextcloud.sync.database ]:	SQL error when deleting selective sync list ("Archiv/", "weitereDOTX/") "database is locked"
12-01 09:28:54:030 [ warning nextcloud.sync.database.sql ]:	Sqlite exec statement error: 5 "database is locked" in "INSERT INTO selectivesync VALUES (?1, ?2)"
12-01 09:28:54:030 [ warning nextcloud.sync.database ]:	SQL error when inserting into selective sync 1 "Archiv/" "database is locked"
12-01 09:30:36:282 [ warning nextcloud.sync.database.sql ]:	Sqlite exec statement error: 5 "database is locked" in "INSERT INTO selectivesync VALUES (?1, ?2)"
12-01 09:30:36:282 [ warning nextcloud.sync.database ]:	SQL error when inserting into selective sync 1 "weitereDOTX/" "database is locked"
12-01 09:30:36:282 [ warning nextcloud.sync.database ]:	ERROR committing to the database: "cannot commit transaction - SQL statements in progress"

After this, syncing resumes quite normally - but a change in my --unsyncedfolders -file is not obeyed. This is not surprising since the above "warning"-Message tells "SQL error when inserting into selective sync" (in that case i added the line "weitereDOTX" to my --unsyncedfolders -file, which before had only one line: "Archiv"). So fixing this bug is not only necessary to avoid the "database locked" -delay (which takes about five minutes), but also to bring any change in --unsyncedfolders -file to work.

[github-actions]

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!

[beardhatcode]

Problem still exists on 3.4.1 fa32c10

$ nextcloudcmd --version
Nextcloud version 3.4.1git
Git revision fa32c100148925092c9a320e6f8e2e0130b9cb6a
Using Qt 5.15.3, built against Qt 5.15.3
Using 'OpenSSL 1.1.1l  24 Aug 2021'
Running on NixOS 22.05 (Quokka), x86_64