Good afternoon,
In the past 2 days my Nextcloud instance removed 50GB of data from my server. I don’t know why.
So today I noticed that and tried to restore the folders. Restoring of the files didn’t go as planned.
I can see the restored folders in the webview. Some of them with the name (restored) after it and some not. and some are duplicated. So the same folder with and without “(restored)” appended to it.
The files in the folders which have been restored (with and without “(restored)” appended to them) I cannot open.
.txt files just open as blanc files in the webview
When I try to download the files I get a HTTP ERROR 503.
In the errors I see signature failed.
I can download those files from the server(with ssh) and decrypt them myself with the corresponding encryption files. and they are correct then. but this will be a tedious thing to do with all my files.
Nextcloud version (eg, 18.0.2): 19.0.0
Nextcloud client windows : 3.0.1
Operating system and version (eg, Ubuntu 20.04): Ubuntu 20.04
Apache or nginx version (eg, Apache 2.4.25):
PHP version (eg, 7.1):
Is this the first time you’ve seen this error? (Y/N): Y
Steps to replicate it:
I have no steps on how to replicate this
Someone an idea on how to fix the “corrupted” items? and on how to get rid of the duplicate folders?
And maybe also an answer on why the files were removed in the first place. other account/client it didn’t happen to.
There is also no logic in which folders were removed. some top folders some lower level folders.
Log file:
restoring error log(formatted):
[webdav] Fatal: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'UPDATE `filecache` SET `storage` = ?, `path_hash` = MD5(CONCAT(?, SUBSTR(`path`, ?))), `path` = CONCAT(?, SUBSTR(`path`, ?)) WHERE (`storage` = ?) AND (`path` LIKE ?)' with params [3, "files_encryption\/keys\/files\/Niels\/Factorio (restored)", 64, "files_encryption\/keys\/files\/Niels\/Factorio (restored)", 64, 3, "files\\_encryption\/keys\/files\\_trashbin\/files\/Factorio.d1600288347\/%"]:
SQLSTATE[HY000]: General error: 1206 The total number of locks exceeds the lock table size at <<closure>>
0. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169
Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exception oc ... e", Doctrine\DBAL\Dr ... ]})
1. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 145
Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "An exception oc ... e")
2. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 1063
Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "UPDATE `filecac ... )", {1: 3,2: "files_ ... "})
3. /var/www/html/lib/private/DB/Connection.php line 214
Doctrine\DBAL\Connection->executeUpdate("UPDATE `filecac ... )", [3,"files_encryp ... "], [1,2,1,2,1,1,2])
4. /var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 203
OC\DB\Connection->executeUpdate("UPDATE `filecac ... )", {dcValue1: "file ... "}, {dcValue1: 2,dcV ... 2})
5. /var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php line 216
Doctrine\DBAL\Query\QueryBuilder->execute()
6. /var/www/html/lib/private/Files/Cache/Cache.php line 647
OC\DB\QueryBuilder\QueryBuilder->execute()
7. /var/www/html/lib/private/Files/Cache/Cache.php line 585
OC\Files\Cache\Cache->moveFromCache(OC\Files\Cache\HomeCache {}, "files_encryptio ... 7", "files_encryptio ... )")
8. /var/www/html/lib/private/Files/Cache/Updater.php line 196
OC\Files\Cache\Cache->move("files_encryptio ... 7", "files_encryptio ... )")
9. /var/www/html/lib/private/Files/View.php line 335
OC\Files\Cache\Updater->renameFromStorage(OCA\Files_Trashb ... }}, "files_encryptio ... 7", "files_encryptio ... )")
10. /var/www/html/lib/private/Files/View.php line 830
OC\Files\View->renameUpdate(OCA\Files_Trashb ... }}, OCA\Files_Trashb ... }}, "files_encryptio ... 7", "files_encryptio ... )")
11. /var/www/html/lib/private/Encryption/Keys/Storage.php line 277
OC\Files\View->rename("/niels/files_en ... 7", "/niels/files_en ... )")
12. /var/www/html/lib/private/Files/Storage/Wrapper/Encryption.php line 293
OC\Encryption\Keys\Storage->renameKeys("/niels/files_tr ... 7", "/niels/files/Niels/Factorio (restored)")
13. /var/www/html/lib/private/Files/Storage/Wrapper/Wrapper.php line 278
OC\Files\Storage\Wrapper\Encryption->rename("files_trashbin/ ... 7", "files/Niels/Factorio (restored)")
14. /var/www/html/lib/private/Files/View.php line 816
OC\Files\Storage\Wrapper\Wrapper->rename("files_trashbin/ ... 7", "files/Niels/Factorio (restored)")
15. /var/www/html/apps/files_trashbin/lib/Trashbin.php line 452
OC\Files\View->rename("/files_trashbin ... 7", "/files/Niels/Factorio (restored)")
16. /var/www/html/apps/files_trashbin/lib/Trash/LegacyTrashBackend.php line 85
OCA\Files_Trashbin\Trashbin::restore("/Factorio.d1600288347", "Factorio", 1600288347)
17. /var/www/html/apps/files_trashbin/lib/Trash/TrashManager.php line 65
OCA\Files_Trashbin\Trash\LegacyTrashBackend->restoreItem(OCA\Files_Trashbin\Trash\TrashItem {})
18. /var/www/html/apps/files_trashbin/lib/Sabre/AbstractTrash.php line 94
OCA\Files_Trashbin\Trash\TrashManager->restoreItem(OCA\Files_Trashbin\Trash\TrashItem {})
19. /var/www/html/apps/files_trashbin/lib/Sabre/RestoreFolder.php line 76
OCA\Files_Trashbin\Sabre\AbstractTrash->restore()
20. /var/www/html/3rdparty/sabre/dav/lib/DAV/Tree.php line 164
OCA\Files_Trashbin\Sabre\RestoreFolder->moveInto("Factorio.d1600288347", "trashbin/niels/ ... 7", OCA\Files_Trashbin\Sabre\TrashFolder {})
21. /var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 641
Sabre\DAV\Tree->move("trashbin/niels/ ... 7", "trashbin/niels/ ... 7")
22. /var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
Sabre\DAV\CorePlugin->httpMove(Sabre\HTTP\Request {}, Sabre\HTTP\Response {})
23. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 474
Sabre\DAV\Server->emit("method:MOVE", [Sabre\HTTP\Requ ... }])
24. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 251
Sabre\DAV\Server->invokeMethod(Sabre\HTTP\Request {}, Sabre\HTTP\Response {})
25. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 319
Sabre\DAV\Server->start()
26. /var/www/html/apps/dav/lib/Server.php line 320
Sabre\DAV\Server->exec()
27. /var/www/html/apps/dav/appinfo/v2/remote.php line 35
OCA\DAV\Server->exec()
28. /var/www/html/remote.php line 167
require_once("/var/www/html/a ... p")
MOVE /remote.php/dav/trashbin/niels/trash/Factorio.d1600288347
from 86.94.249.172 by niels at 2020-09-18T10:57:46+00:00