Windows Client hangs / 30% load

newnoob · December 23, 2022, 8:09pm

My Nextcloud Deskop Clients hangs / freezes with no way to close it via system tray icon - I have to use the taskmanager to stop the process.

Both 3.6.3 64bit ans 3.6.4 64bit show the same issue. Uninstalling and Reinstalling does´not fix it.

The last thing I remember I did, before the client freezed with processors-load, was copying / uploading some “Max for Live” Plugins for Ableton Live on a Nextcloudfolder locally on the Harddisk - but I don´t know how or if these files or the format interferes with client or server.

Right now I just can use Nextcloud via the browser interface. My server is latest version, latest updates.

Any hints appreciated.

newnoob · December 24, 2022, 9:52am

The load goes up to 35% AND the client freezes - no way to use it.

Daphne · December 24, 2022, 10:02am

maybe you can have a look in the desktop logs to see if there are any errors reported specific to the max for live file you mention.

You can check this page that explains how to create desktop client logs:

https://docs.nextcloud.com/desktop/latest/troubleshooting.html#obtaining-the-client-log-file

rg54 · December 28, 2022, 12:40am

Hello @newnoob, hello @Daphne ,

I have exactly the same behavior : versions 3.6.4 and 3.6.3 (64-bit) client on Windows 10 hangs, with one logical CPU core to 100%, as soon as there are files to synchronize from client folder to server.

Without any file changes to sync, client runs normally.

I have downgraded to 3.5.4 and 3.4.4 → same problem

After downgrade to version 3.3.6 → synchronization comes back to a normal behavior (new files are synced successfully). I haven’t done any other changes on server or client to make it work.

Server is on latest stable version available (25.0.2 to date).

In logs, hanging seems to occur on this line (because it’s the last one in the log file) :

2022-12-28 00:08:40:995 [ info nextcloud.sync.networkjob C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\libsync\abstractnetworkjob.cpp:361 ]:	OCC::PutMultiFileJob created for "https://cloud.xxxxxxxxxxx.yyy" + "" "OCC::BulkPropagatorJob"

drhirn · January 3, 2023, 10:20am

Had exactly the same problem.
Then I discovered a log line stating
WARNING: Unexpectedly slow connection, took 6000 msec for 36 bytes for
So I disabled bandwith throtteling in the settings. And it started syncing again.
But still not sure, if this was the reason.
Could you please try this too?

SchrauberGuru · January 3, 2023, 2:05pm

It is not a bandwith issue more than a Filehandle issue:

2023-01-03 14:35:48:867 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 “Documents/Auto/Ducato/Ducato Daten.zip”
2023-01-03 14:35:48:867 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 2 0
2023-01-03 14:35:48:867 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 3 0
2023-01-03 14:35:48:867 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 4 0
2023-01-03 14:35:48:867 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 5 115538
2023-01-03 14:35:48:867 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 6 1672752932
2023-01-03 14:35:48:867 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\common/ownsql.h:151 ] [ OCC::SqlQuery::bindValue ]: SQL bind 7 “MD5:a640cf08047736993f44bbfe82d2e04f”
2023-01-03 14:35:48:867 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\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-03 14:35:48:867 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\common\ownsql.cpp:328 ] [ OCC::SqlQuery::exec ]: Last exec affected 1 rows.
2023-01-03 14:35:48:867 [ debug nextcloud.sync.database C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\common\syncjournaldb.cpp:2418 ] [ OCC::SyncJournalDb::commitInternal ]: Transaction commit “Upload info” and starting new transaction
2023-01-03 14:35:48:869 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\common/ownsql.h:151 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 “Documents/Auto/Ducato/Ducato Daten.zip”
2023-01-03 14:35:48:869 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\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-03 14:35:48:869 [ info nextcloud.sync.propagator.bulkupload C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\libsync\bulkpropagatorjob.cpp:183 ]: “/Documents/Auto/Ducato/Ducato Daten.zip” transmission checksum “a640cf08047736993f44bbfe82d2e04f” “C:/Users/Oli/Nextcloud/Documents/Auto/Ducato/Ducato Daten.zip”
2023-01-03 14:35:48:870 [ info nextcloud.sync.accessmanager C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\libsync\accessmanager.cpp:78 ]: 4 “” “https://xxx.yyy.zzz/nextcloud/remote.php/dav/bulk” has X-Request-ID “9e2d9148-833e-4477-8791-769a78156970”
2023-01-03 14:35:48:870 [ debug nextcloud.sync.cookiejar C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\libsync\cookiejar.cpp:90 ] [ OCC::CookieJar::cookiesForUrl ]: QUrl(“https://xxx.yyy.zzz/nextcloud/remote.php/dav/bulk”) requests: (QNetworkCookie(“nc_sameSiteCookielax=true; secure; HttpOnly; expires=Fri, 31-Dec-2100 23:59:59 GMT; domain=xxx.yyy.zzz; path=/nextcloud”), QNetworkCookie(“nc_sameSiteCookiestrict=true; secure; HttpOnly; expires=Fri, 31-Dec-2100 23:59:59 GMT; domain=xxx.yyy.zzz; path=/nextcloud”), QNetworkCookie(“oc_sessionPassphrase=A7rVUIi4Ls5LZyN7Lq%2BXm2bAl1jF87diLKj%2F1wM9KeGo1535k0rgiqb7OmPYjd0w%2BGNK5F6MZ8K9A9e0NP1NzIIk5gmGVhZHUUTJwnzXYqKZ16YiUtCs1W2skVCadwzn; secure; HttpOnly; domain=xxx.yyy.zzz; path=/nextcloud”), QNetworkCookie(“ocwfxzospb44=qi5u8b0441llhio32kv1i85bci; secure; HttpOnly; domain=xxx.yyy.zzz; path=/nextcloud”))
2023-01-03 14:35:48:870 [ info nextcloud.sync.networkjob C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\libsync\abstractnetworkjob.cpp:361 ]: OCC::PutMultiFileJob created for “https://xxx.yyy.zzz/nextcloud” + “” “OCC::BulkPropagatorJob”
2023-01-03 14:36:25:094 [ debug nextcloud.gui.folderwatcher C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\gui\folderwatcher_win.cpp:160 ] [ OCC::WatcherThread::watchChanges ]: Skipping syncing of “C:/Users/Oli/Nextcloud/Documents/Auto”
2023-01-03 14:36:28:247 [ debug nextcloud.gui.folderwatcher C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\gui\folderwatcher_win.cpp:160 ] [ OCC::WatcherThread::watchChanges ]: Skipping syncing of “C:/Users/Oli/Nextcloud/Documents/Auto”
2023-01-03 14:36:32:949 [ debug nextcloud.gui.folderwatcher C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\gui\folderwatcher_win.cpp:160 ] [ OCC::WatcherThread::watchChanges ]: Skipping syncing of “C:/Users/Oli/Nextcloud/Documents/Auto/Duc”
2023-01-03 14:36:32:949 [ debug nextcloud.gui.folderwatcher C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\gui\folderwatcher_win.cpp:160 ] [ OCC::WatcherThread::watchChanges ]: Skipping syncing of “C:/Users/Oli/Nextcloud/Documents/Auto/Ducato”

It is not possible to create a new Folder also, as you can see. Win Client hang also and skip adding DIR.

Killing NC.exe and remove mentioned file or director bring Client back into synced Status.

This does not take affect on Apps, NConAndroid is sync well meantime.

2023-01-03 14:35:48:854 [ info nextcloud.sync.checksums C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\common\checksums.cpp:230 ]: Computing “MD5” checksum of “C:/Users/Oli/Nextcloud/Documents/Auto/Ducato/Ducato Daten.zip” in a thread

2023-01-03 14:35:48:867 [ debug nextcloud.sync.database.sql C:\Users\sysadmin\AppData\Local\Temp\2\windows-12824\client-building\desktop\src\common/ownsql.h:145 ] [ OCC::SqlQuery::bindValue ]: SQL bind 1 “Documents/Auto/Ducato/Ducato Daten.zip”

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

Seems for me sql coding within ownsql.cpp is wierd within current windows client.

I´ve uninsalled current version and did a install of 3.3.1-> sync will be done smoothly. New Folders andmentioned File above doesn´t bring up any issues…

BR
Oli

rg54 · January 20, 2023, 9:51pm

Hello all,

I’ve accepted the automated update to of 3.6.6 (by accident, to be honest ^^’ ), and problem seems to be resolved.
Anyway, it doesn’t produce any more on my machine, problematic files are now synced.

Thanks to the team for the fix !