Hi,
So out of the blue, my server started spitting out sql error messages into the log.
[webdav] Fatal: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[XX001]: Data corrupted: 7 ERROR: could not read block 856 in file "base/16385/16802": read only 4096 of 8192 bytes at <<closure>>
0. /var/www/html/3rdparty/doctrine/dbal/src/Connection.php line 1780
Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
1. /var/www/html/3rdparty/doctrine/dbal/src/Connection.php line 1719
Doctrine\DBAL\Connection->handleDriverException()
2. /var/www/html/3rdparty/doctrine/dbal/src/Statement.php line 193
Doctrine\DBAL\Connection->convertExceptionDuringQuery()
3. /var/www/html/lib/private/DB/PreparedStatement.php line 87
Doctrine\DBAL\Statement->execute()
4. /var/www/html/apps/dav/lib/DAV/CustomPropertiesBackend.php line 219
OC\DB\PreparedStatement->execute()
5. /var/www/html/3rdparty/sabre/dav/lib/DAV/PropertyStorage/Plugin.php line 141
OCA\DAV\DAV\CustomPropertiesBackend->move()
6. /var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
Sabre\DAV\PropertyStorage\Plugin->afterMove()
7. /var/www/html/apps/dav/lib/Upload/ChunkingPlugin.php line 104
Sabre\DAV\Server->emit()
8. /var/www/html/apps/dav/lib/Upload/ChunkingPlugin.php line 76
OCA\DAV\Upload\ChunkingPlugin->performMove()
9. /var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
OCA\DAV\Upload\ChunkingPlugin->beforeMove()
10. /var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php line 603
Sabre\DAV\Server->emit()
11. /var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php line 89
Sabre\DAV\CorePlugin->httpMove()
12. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 472
Sabre\DAV\Server->emit()
13. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 253
Sabre\DAV\Server->invokeMethod()
14. /var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php line 321
Sabre\DAV\Server->start()
15. /var/www/html/apps/dav/lib/Server.php line 358
Sabre\DAV\Server->exec()
16. /var/www/html/apps/dav/appinfo/v2/remote.php line 35
OCA\DAV\Server->exec()
17. /var/www/html/remote.php line 166
require_once("/var/www/html/a ... p")
MOVE /nextcloud/remote.php/dav/uploads/*/ed88041faedb07328d654144ea19ff35/.file
from 104.163.177.103 by * at 2022-10-24T03:28:51+00:00
It spit out so much of this error, the server crashed. When I checked on the VM (it’s an Univention VM, inside a Proxmox machine) The Nextcloud web GUI wasn’t available, but the Uninvention management protal still, so only the docker crashed. When I restarted the whole VM it did not boot first. I had to fix one of the univention’s partition. It started up again I got back my Nextcloud, well sort of…
I got a bunch of similar error and most visible error is for now, that my calendars and tasks won’t load.
The interesting this is, that I went back over the log and it seems the error messages started shortly before the the whole crash.
Anybody any idea, How can I fix my Nextcloud? What could have cause such a fatal error? And how can I prevent this in the future? (It’s a Ryzen system, with ECC memory and a 4 months old NVME SSD)
There was two mobile client upload high volume of pictures and videos, while the crash happend.