Nextcloud still blocking during the synchronization

ℹ️ Support
1

[details=“Support intro”]

In this log I replaced the real domain with MY_ISTANCE_URL

2023-01-30 09:39:48:096 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 “Musica/Dandies/Progetti/test/Ltest/Backup/test_20230130T080705.145634.sesx”

2023-01-30 09:39:48:096 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 2 0

2023-01-30 09:39:48:096 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 3 0

2023-01-30 09:39:48:096 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 4 0

2023-01-30 09:39:48:096 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 5 134241

2023-01-30 09:39:48:096 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 6 1675062425

2023-01-30 09:39:48:096 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\common/ownsql.h:151 ] [ OCC::SqlQuery::bindValue ]: SQL bind 7 “MD5:fc5231d34e5176401d8fa12d5d5ae5f6”

2023-01-30 09:39:48:096 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\common\ownsql.cpp:295 ] [ OCC::SqlQuery::exec ]: SQL exec “INSERT OR REPLACE INTO uploadinfo (path, chunk, transferid, errorcount, size, modtime, contentChecksum) VALUES ( ?1 , ?2, ?3 , ?4 , ?5, ?6 , ?7 )”

2023-01-30 09:39:48:096 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\common\ownsql.cpp:328 ] [ OCC::SqlQuery::exec ]: Last exec affected 1 rows.

2023-01-30 09:39:48:096 [ debug nextcloud.sync.database C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\common\syncjournaldb.cpp:2418 ] [ OCC::SyncJournalDb::commitInternal ]: Transaction commit “Upload info” and starting new transaction

2023-01-30 09:39:48:096 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\common/ownsql.h:151 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 “Musica/Dandies/Progetti/test/test/Backup/test_20230130T080705.145634.sesx”

2023-01-30 09:39:48:096 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\common\ownsql.cpp:295 ] [ OCC::SqlQuery::exec ]: SQL exec “SELECT baseFileId, baseModtime, baseEtag, basePath FROM conflicts WHERE path=?1;”

2023-01-30 09:39:48:096 [ info nextcloud.sync.propagator.bulkupload C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\libsync\bulkpropagatorjob.cpp:183 ]: “/Musica/Dandies/Progetti/test/test/Backup/test_20230130T080705.145634.sesx” transmission checksum “fc5231d34e5176401d8fa12d5d5ae5f6” “D:/Users/riki_/Desktop/CantaCloud/Musica/Dandies/Progetti/test/test/Backup/test_20230130T080705.145634.sesx”

2023-01-30 09:39:48:097 [ info nextcloud.sync.accessmanager C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\libsync\accessmanager.cpp:78 ]: 4 “” “MY_ISTANCE_URL/remote.php/dav/bulk” has X-Request-ID “477f9608-f288-4f3f-95cc-6ca0157acbc8”

2023-01-30 09:39:48:098 [ debug nextcloud.sync.cookiejar C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\libsync\cookiejar.cpp:90 ] [ OCC::CookieJar::cookiesForUrl ]: QUrl(“MY_ISTANCE_URL/remote.php/dav/bulk”) requests: (QNetworkCookie(“__Host-nc_sameSiteCookielax=true; secure; HttpOnly; expires=Fri, 31-Dec-2100 23:59:59 GMT; domain=MY_ISTANCE_URL; path=/”), QNetworkCookie(“__Host-nc_sameSiteCookiestrict=true; secure; HttpOnly; expires=Fri, 31-Dec-2100 23:59:59 GMT; domain=MY_ISTANCE_URL; path=/”), QNetworkCookie(“oc_sessionPassphrase=GzSnIsdHcTrCGiPlwIJWY22bGk72%2FOCb%2FOGEVfjaEe30GKxt7CxTk9B1%2BXkizbKawNSx5R4NuoK0tsW%2BoRUDHzq%2BXzatZ6SMbahr6bZBXpz3PUyDNNFgweUF8E5UJ6pZ; secure; HttpOnly; domain=MY_ISTANCE_URL; path=/”), QNetworkCookie(“oc2h2fma3pza=d926g3qdgpa94jddvbc5tu44dd; secure; HttpOnly; domain=MY_ISTANCE_URL; path=/”))

2023-01-30 09:39:48:098 [ info nextcloud.sync.networkjob C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\libsync\abstractnetworkjob.cpp:361 ]: OCC::PutMultiFileJob created for “MY_ISTANCE_URL” + “” “OCC::BulkPropagatorJob”

2023-01-30 09:39:48:098 [ info nextcloud.sync.propagator.root.directory C:\Users\sysadmin\AppData\Local\Temp\2\windows-13476\client-building\desktop\src\libsync\owncloudpropagator.cpp:1285 ]: scheduleSelfOrChild OCC::PropagatorJob::Running pending uploads 0 subjobs state OCC::PropagatorJob::Running

Nextcloud version 25.0.3
Operating system and version Ubuntu 20.04.5 LTS
Apache or nginx version 2.4.41
PHP version 7.4.3

Hi! Some times ago I deleted all files from table oc_filecache and I launch the command to make the scan files.

Now everytime that i start the client during the synchronization when it find a new file or folder crash and not sync it. I try everything but it stil crash, I do not know what to do

2

Sorry i can not really help. But because of the quote above i found this issue and this issue. Maybe something with small files.

Is this correct. Do you use Nextcloud 20.0.3? Maybe you can upgrade Nextcloud and Nextcloud client to solve your problem.

3

No sorry! I don’t understand why I didn’t change the version when I created the topic, anyway it’s version 25.0.3

1 Like
4

Can you change the Windows Nextcloud Desktop version? Which version do you use?

Releases · nextcloud/desktop · GitHub

https://download.nextcloud.com/desktop/releases/Windows/

5

Actually I have this: clientVersion=3.6.6stable-Win64 (build 20230119) I must update it?

6

I tried to remove all file from client and restart the sync, from server to my pc. But everytime that I add a new file, the problem return:

2023-02-27 07:52:25:735 [ debug nextcloud.sync.database C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\common\syncjournaldb.cpp:2660 ] [ OCC::SyncJournalDb::commitInternal ]: Transaction commit “Upload info” and starting new transaction

2023-02-27 07:52:25:735 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\common/ownsql.h:151 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 “Musica/test/Progetti/TEST/Backup/TEST_20230226T185831.417858.sesx”

2023-02-27 07:52:25:735 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\common\ownsql.cpp:295 ] [ OCC::SqlQuery::exec ]: SQL exec “SELECT baseFileId, baseModtime, baseEtag, basePath FROM conflicts WHERE path=?1;”

2023-02-27 07:52:25:735 [ info nextcloud.sync.propagator.bulkupload C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\libsync\bulkpropagatorjob.cpp:183 ]: “/Musica/test/Progetti/TEST/Backup/TEST_20230226T185831.417858.sesx” transmission checksum “8088506f183f53f8cd1ebe01709d3dbd” “D:/Users/riki_/Desktop/CantaCloud/Musica/test/Progetti/TEST/Backup/TEST_20230226T185831.417858.sesx”

2023-02-27 07:52:25:736 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 “Musica/test/Progetti/TEST/Backup/TEST_20230226T185231.396274.sesx”

2023-02-27 07:52:25:736 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 2 0

2023-02-27 07:52:25:736 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 3 0

2023-02-27 07:52:25:736 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 4 0

2023-02-27 07:52:25:736 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 5 112766

2023-02-27 07:52:25:736 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 6 1677433951

2023-02-27 07:52:25:736 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\common/ownsql.h:151 ] [ OCC::SqlQuery::bindValue ]: SQL bind 7 “MD5:36dc9465d81457052a0d934776557c14”

2023-02-27 07:52:25:736 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\common\ownsql.cpp:295 ] [ OCC::SqlQuery::exec ]: SQL exec “INSERT OR REPLACE INTO uploadinfo (path, chunk, transferid, errorcount, size, modtime, contentChecksum) VALUES ( ?1 , ?2, ?3 , ?4 , ?5, ?6 , ?7 )”

2023-02-27 07:52:25:737 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\common\ownsql.cpp:328 ] [ OCC::SqlQuery::exec ]: Last exec affected 1 rows.

2023-02-27 07:52:25:737 [ debug nextcloud.sync.database C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\common\syncjournaldb.cpp:2660 ] [ OCC::SyncJournalDb::commitInternal ]: Transaction commit “Upload info” and starting new transaction

2023-02-27 07:52:25:737 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\common/ownsql.h:151 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 “Musica/test/Progetti/TEST/Backup/TEST_20230226T185231.396274.sesx”

2023-02-27 07:52:25:737 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\common\ownsql.cpp:295 ] [ OCC::SqlQuery::exec ]: SQL exec “SELECT baseFileId, baseModtime, baseEtag, basePath FROM conflicts WHERE path=?1;”

2023-02-27 07:52:25:737 [ info nextcloud.sync.propagator.bulkupload C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\libsync\bulkpropagatorjob.cpp:183 ]: “/Musica/test/Progetti/TEST/Backup/TEST_20230226T185231.396274.sesx” transmission checksum “36dc9465d81457052a0d934776557c14” “D:/Users/riki_/Desktop/CantaCloud/Musica/test/Progetti/TEST/Backup/TEST_20230226T185231.396274.sesx”

2023-02-27 07:52:25:745 [ info nextcloud.sync.accessmanager C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\libsync\accessmanager.cpp:78 ]: 4 “” “MY_NEXTCLOUD_URL/remote.php/dav/bulk” has X-Request-ID “f6b32b84-39d4-415e-ae10-a5435b50ddac”

2023-02-27 07:52:25:745 [ debug nextcloud.sync.cookiejar C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\libsync\cookiejar.cpp:90 ] [ OCC::CookieJar::cookiesForUrl ]: QUrl(“MY_NEXTCLOUD_URL/remote.php/dav/bulk”) requests: (QNetworkCookie(“__Host-nc_sameSiteCookielax=true; secure; HttpOnly; expires=Fri, 31-Dec-2100 23:59:59 GMT; domain=cantacloud.ddns.net; path=/”), QNetworkCookie(“__Host-nc_sameSiteCookiestrict=true; secure; HttpOnly; expires=Fri, 31-Dec-2100 23:59:59 GMT; domain=cantacloud.ddns.net; path=/”), QNetworkCookie(“oc_sessionPassphrase=kl86fInzavbyQQ3TK4XNSlDTBr4%2BdHIJPnAY4rkB%2FCJkhqAgmQ5a%2BerDozWQOaSb3WefD%2FMHKIltBoyoQ6kczlX%2Fm3XkC9S9gmB6D3ArXbIOb84NeFPWIW92r4v6UIIE; secure; HttpOnly; domain=cantacloud.ddns.net; path=/”), QNetworkCookie(“oc2h2fma3pza=k0o0nanmhh8311mobsoij7n88l; secure; HttpOnly; domain=cantacloud.ddns.net; path=/”))

2023-02-27 07:52:25:746 [ info nextcloud.sync.networkjob C:\Users\sysadmin\AppData\Local\Temp\windows-13808\client-building\desktop\src\libsync\abstractnetworkjob.cpp:358 ]: OCC::PutMultiFileJob created for “MY_NEXTCLOUD_URL” + “” “OCC::BulkPropagatorJob”

Why???

7

I resolved unistalling the Nextcloud Windows client and installing the Owncloud Windows client -_-.
This is not a win.

1 Like
8

I have the same issue on macos nextcloud command line client (version 3.8.1git - build 14890) , it blocks with the last log line saying
[ info nextcloud.sync.accessmanager ]: 4 “” “https://[…]/remote.php/dav/bulk” has X-Request-ID “XXXX”
and then nothing happening any more.