Support intro
Sorry to hear you’re facing problems
help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.
In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:
example
Or for longer, use three backticks above and below the code snippet:
longer
example
here
Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can
Nextcloud version (eg, 20.0.5): 25.0.6
Operating system and version (eg, Ubuntu 20.04): Linux nextpi 5.15.61-v7l+ #1579 SMP Fri Aug 26 11:13:03 BST 2022 armv7l
Apache or nginx version (eg, Apache 2.4.25): Apache 2.4.54
PHP version (eg, 7.4): PHP 8.0.1
The issue you are facing:
Before this problem occurred, I’ve got a lot of “1213 Deadlock found”-messages as they are already described in
that I assume are the cause for the current problem. After a restart of the computer with the client I now get the following error-message
The error doesn’t go away. I’ve looked through the apache logs where I don’t see any error messages and the client debug log only contains essentially the same information that can be seen in the GUI:
2022-10-18 09:12:30:884 [ warning nextcloud.sync.networkjob C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\abstractnetworkjob.cpp:224 ]: QNetworkReply::ProtocolFailure "Die Daten sind verfälscht" QVariant(int, 207)
2022-10-18 09:12:30:884 [ warning nextcloud.sync.credentials.webflow C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\creds\webflowcredentials.cpp:228 ]: QNetworkReply::ProtocolFailure
2022-10-18 09:12:30:884 [ warning nextcloud.sync.credentials.webflow C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\creds\webflowcredentials.cpp:229 ]: "Die Daten sind verfälscht"
2022-10-18 09:12:30:884 [ info nextcloud.sync.networkjob.lscol C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\networkjobs.cpp:395 ]: LSCOL of QUrl("http://nextcloud.example.com/nextcloud/remote.php/dav/files/user/SynchData/HumbleBundle/Ebooks/Mercury - Computer Productivity & Coding/3D Printing/CH08/Figures") FINISHED WITH STATUS "ProtocolFailure Die Daten sind verfälscht"
2022-10-18 09:12:30:884 [ warning nextcloud.sync.networkjob.lscol C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\networkjobs.cpp:315 ]: ERROR "Vorzeitiges Ende des Dokuments." ""
2022-10-18 09:12:30:884 [ warning nextcloud.sync.discovery C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\discoveryphase.cpp:589 ]: LSCOL job error "Die Daten sind verfälscht" 207 QNetworkReply::ProtocolFailure
2022-10-18 09:12:30:884 [ warning sync.discovery C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\libsync\discovery.cpp:1746 ]: Server error in directory "Ebooks/Mercury - Computer Productivity & Coding/3D Printing/CH08/Figures" 207
2022-10-18 09:12:30:884 [ warning nextcloud.gui.activity C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\tray\usermodel.cpp:493 ]: Item "F:\\Owncloud\\Humble Bundle" retrieved resulted in "Der Server hat während des Lesens des Verzeichnisses \"Ebooks/Mercury - Computer Productivity & Coding/3D Printing/CH08/Figures\" mit einem Fehler geantwortet: Die Daten sind verfälscht"
2022-10-18 09:12:30:884 [ info nextcloud.gui.activity C:\Users\sysadmin\AppData\Local\Temp\2\windows-11567\client-building\desktop\src\gui\tray\activitylistmodel.cpp:551 ]: Error successfully added to the notification list: "Der Server hat während des Lesens des Verzeichnisses \"Ebooks/Mercury - Computer Productivity & Coding/3D Printing/CH08/Figures\" mit einem Fehler geantwortet: Die Daten sind verfälscht"
Is this the first time you’ve seen this error? (Y/N): Y
Steps to replicate it:
I’m not sure how to replicate it
The output of your Nextcloud log in Admin > Logging:
The last entry before I got this error in the client is one of the serialization-errors that I’ve mentioned
[index] Fehler: OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at <<closure>>
0. /var/www/nextcloud/lib/private/DB/ConnectionAdapter.php line 109
OC\DB\Exceptions\DbalException::wrap()
1. /var/www/nextcloud/lib/private/Lock/DBLockingProvider.php line 132
OC\DB\ConnectionAdapter->insertIgnoreConflict()
2. /var/www/nextcloud/lib/private/Lock/DBLockingProvider.php line 178
OC\Lock\DBLockingProvider->initLockField()
3. /var/www/nextcloud/lib/private/Files/Storage/Common.php line 758
OC\Lock\DBLockingProvider->acquireLock()
4. /var/www/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php line 610
OC\Files\Storage\Common->acquireLock()
5. /var/www/nextcloud/lib/private/Files/Cache/Scanner.php line 149
OC\Files\Storage\Wrapper\Wrapper->acquireLock()
6. /var/www/nextcloud/lib/private/Files/Cache/LocalRootScanner.php line 31
OC\Files\Cache\Scanner->scanFile()
7. /var/www/nextcloud/lib/private/Files/Cache/Scanner.php line 438
OC\Files\Cache\LocalRootScanner->scanFile()
8. /var/www/nextcloud/lib/private/Files/Cache/Scanner.php line 390
OC\Files\Cache\Scanner->handleChildren()
9. /var/www/nextcloud/lib/private/Files/Cache/Scanner.php line 342
OC\Files\Cache\Scanner->scanChildren()
10. /var/www/nextcloud/lib/private/Files/Cache/LocalRootScanner.php line 39
OC\Files\Cache\Scanner->scan()
11. /var/www/nextcloud/lib/private/Files/View.php line 1350
OC\Files\Cache\LocalRootScanner->scan()
12. /var/www/nextcloud/lib/private/Files/View.php line 1390
OC\Files\View->getCacheEntry()
13. /var/www/nextcloud/lib/private/Files/Node/Root.php line 205
OC\Files\View->getFileInfo()
14. <<closure>>
OC\Files\Node\Root->get()
15. /var/www/nextcloud/lib/private/Files/Node/LazyFolder.php line 72
call_user_func_array()
16. /var/www/nextcloud/lib/private/Files/Node/LazyFolder.php line 149
OC\Files\Node\LazyFolder->__call()
17. /var/www/nextcloud/lib/private/Files/AppData/AppData.php line 107
OC\Files\Node\LazyFolder->get()
18. /var/www/nextcloud/lib/private/Files/AppData/AppData.php line 156
OC\Files\AppData\AppData->getAppDataFolder()
19. /var/www/nextcloud/lib/private/Preview/Storage/Root.php line 74
OC\Files\AppData\AppData->newFolder()
20. /var/www/nextcloud/lib/private/Preview/Generator.php line 573
OC\Preview\Storage\Root->newFolder()
21. /var/www/nextcloud/lib/private/Preview/Generator.php line 134
OC\Preview\Generator->getPreviewFolder()
22. /var/www/nextcloud/lib/private/Preview/Generator.php line 111
OC\Preview\Generator->generatePreviews()
23. /var/www/nextcloud/lib/private/PreviewManager.php line 212
OC\Preview\Generator->getPreview()
24. /var/www/nextcloud/core/Controller/PreviewController.php line 169
OC\PreviewManager->getPreview()
25. /var/www/nextcloud/core/Controller/PreviewController.php line 142
OC\Core\Controller\PreviewController->fetchPreview()
26. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 225
OC\Core\Controller\PreviewController->getPreviewByFileId()
27. /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 133
OC\AppFramework\Http\Dispatcher->executeController()
28. /var/www/nextcloud/lib/private/AppFramework/App.php line 172
OC\AppFramework\Http\Dispatcher->dispatch()
29. /var/www/nextcloud/lib/private/Route/Router.php line 298
OC\AppFramework\App::main()
30. /var/www/nextcloud/lib/base.php line 1030
OC\Route\Router->match()
31. /var/www/nextcloud/index.php line 36
OC::handleRequest()
GET /nextcloud/index.php/core/preview?fileId=739&c=b7e23c5ef451def82b211194f4358143&x=250&y=250&forceIcon=0&a=1
from 192.168.1.40 by user at 2022-10-18T07:04:44+00:00```
The output of your Apache/nginx/system log in /var/log/____
:
The Apache error.log only shows the serialization error:
[Tue Oct 18 09:04:33.761922 2022] [php:error] [pid 18041] [client 192.168.1.40:51000] PHP Fatal error: Uncaught PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transac...
The installation is “single-user”, i.e. only I’m using it. Only one client was uploading data at the time of the “serialization error” (but I assume parallel uploads were taking place).
How can I find out what data have been “falsified” and how can I fix this? How can all these serialization errors be fixed. The thread I’ve linked to above is quite old and seem to have a “no fix, just live with it until it’s fixed”-solution.