Multiple files malformed, how screwed am I?

ℹ️ Support
1

Nextcloud version 15.0.2
Operating system and version Unraid 6.7.0-rc4

The issue you are facing:

occ $ files:scan --all
Starting scan for user 1 out of 4 (admin)
Home storage for user admin not writable
Make sure you're running the scan command only as the user the web server runs as
Starting scan for user 2 out of 4 (redacted)
Exception during scan: An exception occurred while executing 'INSERT INTO "oc_file_locks" ("key", "lock", "ttl") VALUES(?, ?, ?)' with params ["files\/0a9889376074b365a19ba7f2db412dbc", -1, 1550700
101:
SQLSTATE[HY000]: General error: 11 database disk image is malformed]
#0 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractSQLiteDriver->convertException('An exception oc...', Object(Doctrine\DBAL\D
river\PDOException))
#1 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1015): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOSqlite\Driver), Objec
t(Doctrine\DBAL\Driver\PDOException), 'INSERT INTO "oc...', Array)
#2 /config/www/nextcloud/lib/private/DB/Connection.php(216): Doctrine\DBAL\Connection->executeUpdate('INSERT INTO "oc...', Array, Array)
#3 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(208): OC\DB\Connection->executeUpdate('INSERT INTO "oc...', Array, Array)
#4 /config/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(214): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /config/www/nextcloud/lib/private/Lock/DBLockingProvider.php(144): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /config/www/nextcloud/lib/private/Lock/DBLockingProvider.php(207): OC\Lock\DBLockingProvider->initLockField('files/0a9889376...', -1)
#7 /config/www/nextcloud/lib/private/Files/Storage/Common.php(714): OC\Lock\DBLockingProvider->acquireLock('files/0a9889376...', 2)
#8 /config/www/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php(593): OC\Files\Storage\Common->acquireLock('scanner::', 2, Object(OC\Lock\DBLockingProvider))
#9 /config/www/nextcloud/lib/private/Files/Cache/Scanner.php(331): OC\Files\Storage\Wrapper\Wrapper->acquireLock('scanner::', 2, Object(OC\Lock\DBLockingProvider))
#10 /config/www/nextcloud/lib/private/Files/Utils/Scanner.php(245): OC\Files\Cache\Scanner->scan('', true, 3)
#11 /config/www/nextcloud/apps/files/lib/Command/Scan.php(145): OC\Files\Utils\Scanner->scan('/redacted', true, NULL)
#12 /config/www/nextcloud/apps/files/lib/Command/Scan.php(201): OCA\Files\Command\Scan->scanFiles('redacted', '/redacted', Object(OCA\OCCWeb\Controller\OccOutput), false, true, false)
#13 /config/www/nextcloud/3rdparty/symfony/console/Command/Command.php(255): OCA\Files\Command\Scan->execute(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Controller\OccOu
tput))
#14 /config/www/nextcloud/core/Command/Base.php(166): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Controller\OccOutput))
#15 /config/www/nextcloud/3rdparty/symfony/console/Application.php(946): OC\Core\Command\Base->run(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Controller\OccOutput))
#16 /config/www/nextcloud/3rdparty/symfony/console/Application.php(248): Symfony\Component\Console\Application->doRunCommand(Object(OCA\Files\Command\Scan), Object(Symfony\Component\Console\Input]
StringInput), Object(OCA\OCCWeb\Controller\OccOutput))
#17 /config/www/nextcloud/3rdparty/symfony/console/Application.php(148): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Control
ler\OccOutput))
#18 /config/www/nextcloud/apps/occweb/lib/Controller/OCCApplication.php(207): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Cont
roller\OccOutput))
#19 /config/www/nextcloud/apps/occweb/lib/Controller/OccController.php(61): OCA\OCCWeb\Controller\OCCApplication->run(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Control
ler\OccOutput))
#20 /config/www/nextcloud/apps/occweb/lib/Controller/OccController.php(81): OCA\OCCWeb\Controller\OccController->run(Object(Symfony\Component\Console\Input\StringInput))
#21 /config/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(166): OCA\OCCWeb\Controller\OccController->cmd('files:scan --al...')
#22 /config/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(99): OC\AppFramework\Http\Dispatcher->executeController(Object(OCA\OCCWeb\Controller\OccController), 'cmd')
#23 /config/www/nextcloud/lib/private/AppFramework/App.php(118): OC\AppFramework\Http\Dispatcher->dispatch(Object(OCA\OCCWeb\Controller\OccController), 'cmd')
#24 /config/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php(47): OC\AppFramework\App::main('OCA\\OCCWeb\\Cont...', 'cmd', Object(OC\AppFramework\DependencyInjection\DIContain
er), Array)
#25 [internal function: OC\AppFramework\Routing\RouteActionHandler->__invoke(Array)
#26 /config/www/nextcloud/lib/private/Route/Router.php(297): call_user_func(Object(OC\AppFramework\Routing\RouteActionHandler), Array)
#27 /config/www/nextcloud/lib/base.php(987): OC\Route\Router->match('/apps/occweb/cm...')
#28 /config/www/nextcloud/index.php(42): OC::handleRequest()
#29 {main}]
Starting scan for user 3 out of 4 (redacted)
Exception during scan: An exception occurred while executing 'INSERT INTO "oc_file_locks" ("key", "lock", "ttl") VALUES(?, ?, ?)' with params ["files\/27126a408e52d72c11a3086f2a24e692", -1, 1550700
101:
SQLSTATE[HY000]: General error: 11 database disk image is malformed]
#0 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractSQLiteDriver->convertException('An exception oc...', Object(Doctrine\DBAL\D
river\PDOException))
#1 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1015): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOSqlite\Driver), Objec
t(Doctrine\DBAL\Driver\PDOException), 'INSERT INTO "oc...', Array)
#2 /config/www/nextcloud/lib/private/DB/Connection.php(216): Doctrine\DBAL\Connection->executeUpdate('INSERT INTO "oc...', Array, Array)
#3 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(208): OC\DB\Connection->executeUpdate('INSERT INTO "oc...', Array, Array)
#4 /config/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(214): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /config/www/nextcloud/lib/private/Lock/DBLockingProvider.php(144): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /config/www/nextcloud/lib/private/Lock/DBLockingProvider.php(207): OC\Lock\DBLockingProvider->initLockField('files/27126a408...', -1)
#7 /config/www/nextcloud/lib/private/Files/Storage/Common.php(714): OC\Lock\DBLockingProvider->acquireLock('files/27126a408...', 2)
#8 /config/www/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php(593): OC\Files\Storage\Common->acquireLock('scanner::', 2, Object(OC\Lock\DBLockingProvider))
#9 /config/www/nextcloud/lib/private/Files/Cache/Scanner.php(331): OC\Files\Storage\Wrapper\Wrapper->acquireLock('scanner::', 2, Object(OC\Lock\DBLockingProvider))
#10 /config/www/nextcloud/lib/private/Files/Utils/Scanner.php(245): OC\Files\Cache\Scanner->scan('', true, 3)
#11 /config/www/nextcloud/apps/files/lib/Command/Scan.php(145): OC\Files\Utils\Scanner->scan('/redacted', true, NULL)
#12 /config/www/nextcloud/apps/files/lib/Command/Scan.php(201): OCA\Files\Command\Scan->scanFiles('redacted', '/redacted', Object(OCA\OCCWeb\Controller\OccOutput), false, true, false)
#13 /config/www/nextcloud/3rdparty/symfony/console/Command/Command.php(255): OCA\Files\Command\Scan->execute(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Controller\OccOu
tput))
#14 /config/www/nextcloud/core/Command/Base.php(166): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Controller\OccOutput))
#15 /config/www/nextcloud/3rdparty/symfony/console/Application.php(946): OC\Core\Command\Base->run(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Controller\OccOutput))
#16 /config/www/nextcloud/3rdparty/symfony/console/Application.php(248): Symfony\Component\Console\Application->doRunCommand(Object(OCA\Files\Command\Scan), Object(Symfony\Component\Console\Input]
StringInput), Object(OCA\OCCWeb\Controller\OccOutput))
#17 /config/www/nextcloud/3rdparty/symfony/console/Application.php(148): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Control
ler\OccOutput))
#18 /config/www/nextcloud/apps/occweb/lib/Controller/OCCApplication.php(207): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Cont
roller\OccOutput))
#19 /config/www/nextcloud/apps/occweb/lib/Controller/OccController.php(61): OCA\OCCWeb\Controller\OCCApplication->run(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Control
ler\OccOutput))
#20 /config/www/nextcloud/apps/occweb/lib/Controller/OccController.php(81): OCA\OCCWeb\Controller\OccController->run(Object(Symfony\Component\Console\Input\StringInput))
#21 /config/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(166): OCA\OCCWeb\Controller\OccController->cmd('files:scan --al...')
#22 /config/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(99): OC\AppFramework\Http\Dispatcher->executeController(Object(OCA\OCCWeb\Controller\OccController), 'cmd')
#23 /config/www/nextcloud/lib/private/AppFramework/App.php(118): OC\AppFramework\Http\Dispatcher->dispatch(Object(OCA\OCCWeb\Controller\OccController), 'cmd')
#24 /config/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php(47): OC\AppFramework\App::main('OCA\\OCCWeb\\Cont...', 'cmd', Object(OC\AppFramework\DependencyInjection\DIContain
er), Array)
#25 [internal function: OC\AppFramework\Routing\RouteActionHandler->__invoke(Array)
#26 /config/www/nextcloud/lib/private/Route/Router.php(297): call_user_func(Object(OC\AppFramework\Routing\RouteActionHandler), Array)
#27 /config/www/nextcloud/lib/base.php(987): OC\Route\Router->match('/apps/occweb/cm...')
#28 /config/www/nextcloud/index.php(42): OC::handleRequest()
#29 {main}]
Starting scan for user 4 out of 4 (redacted)
Exception during scan: An exception occurred while executing 'INSERT INTO "oc_file_locks" ("key", "lock", "ttl") VALUES(?, ?, ?)' with params ["files\/e62389f206edce8375613517ad81325b", -1, 1550700
101:
SQLSTATE[HY000]: General error: 11 database disk image is malformed]
#0 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractSQLiteDriver->convertException('An exception oc...', Object(Doctrine\DBAL\D
river\PDOException))
#1 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1015): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOSqlite\Driver), Objec
t(Doctrine\DBAL\Driver\PDOException), 'INSERT INTO "oc...', Array)
#2 /config/www/nextcloud/lib/private/DB/Connection.php(216): Doctrine\DBAL\Connection->executeUpdate('INSERT INTO "oc...', Array, Array)
#3 /config/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(208): OC\DB\Connection->executeUpdate('INSERT INTO "oc...', Array, Array)
#4 /config/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(214): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /config/www/nextcloud/lib/private/Lock/DBLockingProvider.php(144): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /config/www/nextcloud/lib/private/Lock/DBLockingProvider.php(207): OC\Lock\DBLockingProvider->initLockField('files/e62389f20...', -1)
#7 /config/www/nextcloud/lib/private/Files/Storage/Common.php(714): OC\Lock\DBLockingProvider->acquireLock('files/e62389f20...', 2)
#8 /config/www/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php(593): OC\Files\Storage\Common->acquireLock('scanner::', 2, Object(OC\Lock\DBLockingProvider))
#9 /config/www/nextcloud/lib/private/Files/Cache/Scanner.php(331): OC\Files\Storage\Wrapper\Wrapper->acquireLock('scanner::', 2, Object(OC\Lock\DBLockingProvider))
#10 /config/www/nextcloud/lib/private/Files/Utils/Scanner.php(245): OC\Files\Cache\Scanner->scan('', true, 3)
#11 /config/www/nextcloud/apps/files/lib/Command/Scan.php(145): OC\Files\Utils\Scanner->scan('/redacted', true, NULL)
#12 /config/www/nextcloud/apps/files/lib/Command/Scan.php(201): OCA\Files\Command\Scan->scanFiles('redacted', '/redacted', Object(OCA\OCCWeb\Controller\OccOutput), false, true, false)
#13 /config/www/nextcloud/3rdparty/symfony/console/Command/Command.php(255): OCA\Files\Command\Scan->execute(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Controller\OccOu
tput))
#14 /config/www/nextcloud/core/Command/Base.php(166): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Controller\OccOutput))
#15 /config/www/nextcloud/3rdparty/symfony/console/Application.php(946): OC\Core\Command\Base->run(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Controller\OccOutput))
#16 /config/www/nextcloud/3rdparty/symfony/console/Application.php(248): Symfony\Component\Console\Application->doRunCommand(Object(OCA\Files\Command\Scan), Object(Symfony\Component\Console\Input]
StringInput), Object(OCA\OCCWeb\Controller\OccOutput))
#17 /config/www/nextcloud/3rdparty/symfony/console/Application.php(148): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Control
ler\OccOutput))
#18 /config/www/nextcloud/apps/occweb/lib/Controller/OCCApplication.php(207): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Cont
roller\OccOutput))
#19 /config/www/nextcloud/apps/occweb/lib/Controller/OccController.php(61): OCA\OCCWeb\Controller\OCCApplication->run(Object(Symfony\Component\Console\Input\StringInput), Object(OCA\OCCWeb\Control
ler\OccOutput))
#20 /config/www/nextcloud/apps/occweb/lib/Controller/OccController.php(81): OCA\OCCWeb\Controller\OccController->run(Object(Symfony\Component\Console\Input\StringInput))
#21 /config/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(166): OCA\OCCWeb\Controller\OccController->cmd('files:scan --al...')
#22 /config/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(99): OC\AppFramework\Http\Dispatcher->executeController(Object(OCA\OCCWeb\Controller\OccController), 'cmd')
#23 /config/www/nextcloud/lib/private/AppFramework/App.php(118): OC\AppFramework\Http\Dispatcher->dispatch(Object(OCA\OCCWeb\Controller\OccController), 'cmd')
#24 /config/www/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php(47): OC\AppFramework\App::main('OCA\\OCCWeb\\Cont...', 'cmd', Object(OC\AppFramework\DependencyInjection\DIContain
er), Array)
#25 [internal function: OC\AppFramework\Routing\RouteActionHandler->__invoke(Array)
#26 /config/www/nextcloud/lib/private/Route/Router.php(297): call_user_func(Object(OC\AppFramework\Routing\RouteActionHandler), Array)
#27 /config/www/nextcloud/lib/base.php(987): OC\Route\Router->match('/apps/occweb/cm...')
#28 /config/www/nextcloud/index.php(42): OC::handleRequest()
#29 {main}]
+---------+-------+--------------+
| Folders | Files | Elapsed time |
+---------+-------+--------------+
| 0       | 0     | 00:00:00     |
+---------+-------+--------------+