{"reqId":"bH21nMDzr064SsMYfKlM","level":0,"time":"2025-07-13T16:24:43+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type`, `lazy` FROM `*PREFIX*appconfig`","userAgent":"--","version":"31.0.2.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type`, `lazy` FROM `*PREFIX*appconfig`","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":1233,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":1193,"function":"loadConfig","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":965,"function":"loadConfigAll","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud/lib/private/Repair/AddAppConfigLazyMigration.php","line":39,"function":"updateLazy","class":"OC\\AppConfig","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Repair.php","line":104,"function":"run","class":"OC\\Repair\\AddAppConfigLazyMigration","type":"->"},{"file":"/var/www/nextcloud/lib/private/Updater.php","line":265,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud/lib/private/Updater.php","line":100,"function":"doUpgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/nextcloud/core/Command/Upgrade.php","line":192,"function":"upgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/console/Command/Command.php","line":326,"function":"execute","class":"OC\\Core\\Command\\Upgrade","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/console/Application.php","line":1078,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/console/Application.php","line":324,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/console/Application.php","line":175,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud/lib/private/Console/Application.php","line":187,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud/occ","line":33,"args":["/var/www/nextcloud/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud/lib/private/DB/Connection.php","Line":406,"message":"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type`, `lazy` FROM `*PREFIX*appconfig`","tables":["oc_preferences","oc_migrations","oc_jobs","oc_appconfig","oc_storages","oc_filecache","oc_notes_meta","oc_oauth2_access_tokens","oc_oauth2_clients"],"reads":["oc_appconfig"],"exception":{},"CustomMessage":"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type`, `lazy` FROM `*PREFIX*appconfig`"}}
{"reqId":"bH21nMDzr064SsMYfKlM","level":1,"time":"2025-07-13T16:24:43+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"core/BackgroundJobs/AppConfigLazyMigration: 0 config values updated","userAgent":"--","version":"31.0.2.1","data":[]}
{"reqId":"bH21nMDzr064SsMYfKlM","level":1,"time":"2025-07-13T16:24:43+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: Cache logo dimension to fix size in emails on Outlook","userAgent":"--","version":"31.0.2.1","data":{"app":"updater"}}
{"reqId":"bH21nMDzr064SsMYfKlM","level":1,"time":"2025-07-13T16:24:43+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"OC\\Repair\\Events\\RepairInfoEvent: Repair info: Logo dimensions are already known","userAgent":"--","version":"31.0.2.1","data":{"app":"updater"}}
{"reqId":"bH21nMDzr064SsMYfKlM","level":1,"time":"2025-07-13T16:24:43+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: Remove legacy \".ocdata\" file","userAgent":"--","version":"31.0.2.1","data":{"app":"updater"}}
{"reqId":"bH21nMDzr064SsMYfKlM","level":1,"time":"2025-07-13T16:24:43+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: Add cleanup-deleted-users background job","userAgent":"--","version":"31.0.2.1","data":{"app":"updater"}}
{"reqId":"bH21nMDzr064SsMYfKlM","level":0,"time":"2025-07-13T16:24:43+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"31.0.2.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/JobList.php","line":128,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/JobList.php","line":48,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud/lib/private/Repair/AddCleanupDeletedUsersBackgroundJob.php","line":28,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud/lib/private/Repair.php","line":104,"function":"run","class":"OC\\Repair\\AddCleanupDeletedUsersBackgroundJob","type":"->"},{"file":"/var/www/nextcloud/lib/private/Updater.php","line":265,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud/lib/private/Updater.php","line":100,"function":"doUpgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/nextcloud/core/Command/Upgrade.php","line":192,"function":"upgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/console/Command/Command.php","line":326,"function":"execute","class":"OC\\Core\\Command\\Upgrade","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/console/Application.php","line":1078,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/console/Application.php","line":324,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/console/Application.php","line":175,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud/lib/private/Console/Application.php","line":187,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud/occ","line":33,"args":["/var/www/nextcloud/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud/lib/private/DB/Connection.php","Line":406,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_preferences","oc_migrations","oc_jobs","oc_appconfig","oc_storages","oc_filecache","oc_notes_meta","oc_oauth2_access_tokens","oc_oauth2_clients"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"bH21nMDzr064SsMYfKlM","level":1,"time":"2025-07-13T16:24:43+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: Validate account properties and store phone numbers in a known format for search","userAgent":"--","version":"31.0.2.1","data":{"app":"updater"}}
{"reqId":"bH21nMDzr064SsMYfKlM","level":0,"time":"2025-07-13T16:24:43+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"31.0.2.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/JobList.php","line":128,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/JobList.php","line":48,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud/lib/private/Repair/NC29/SanitizeAccountProperties.php","line":27,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud/lib/private/Repair.php","line":104,"function":"run","class":"OC\\Repair\\NC29\\SanitizeAccountProperties","type":"->"},{"file":"/var/www/nextcloud/lib/private/Updater.php","line":265,"function":"run","class":"OC\\Repair","type":"->"},{"file":"/var/www/nextcloud/lib/private/Updater.php","line":100,"function":"doUpgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/nextcloud/core/Command/Upgrade.php","line":192,"function":"upgrade","class":"OC\\Updater","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/console/Command/Command.php","line":326,"function":"execute","class":"OC\\Core\\Command\\Upgrade","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/console/Application.php","line":1078,"function":"run","class":"Symfony\\Component\\Console\\Command\\Command","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/console/Application.php","line":324,"function":"doRunCommand","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/console/Application.php","line":175,"function":"doRun","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud/lib/private/Console/Application.php","line":187,"function":"run","class":"Symfony\\Component\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud/console.php","line":87,"function":"run","class":"OC\\Console\\Application","type":"->"},{"file":"/var/www/nextcloud/occ","line":33,"args":["/var/www/nextcloud/console.php"],"function":"require_once"}],"File":"/var/www/nextcloud/lib/private/DB/Connection.php","Line":406,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":["oc_preferences","oc_migrations","oc_jobs","oc_appconfig","oc_storages","oc_filecache","oc_notes_meta","oc_oauth2_access_tokens","oc_oauth2_clients"],"reads":["oc_jobs"],"exception":{},"CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"bH21nMDzr064SsMYfKlM","level":1,"time":"2025-07-13T16:24:43+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"OC\\Repair\\Events\\RepairInfoEvent: Repair info: Queued background to validate account properties.","userAgent":"--","version":"31.0.2.1","data":{"app":"updater"}}
{"reqId":"bH21nMDzr064SsMYfKlM","level":0,"time":"2025-07-13T16:24:43+00:00","remoteAddr":"","user":"--","app":"serverDI","method":"","url":"--","message":"The requested alias \"IntegrityCodeChecker\" is deprecated. Please request \"OC\\IntegrityCheck\\Checker\" directly. This alias will be removed in a future Nextcloud version.","userAgent":"--","version":"31.0.2.1","data":{"app":"serverDI"}}
{"reqId":"bH21nMDzr064SsMYfKlM","level":1,"time":"2025-07-13T16:24:43+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::startCheckCodeIntegrity: Starting code integrity check...","userAgent":"--","version":"31.0.2.1","data":{"app":"updater"}}
{"reqId":"bH21nMDzr064SsMYfKlM","level":1,"time":"2025-07-13T16:24:46+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::finishedCheckCodeIntegrity: Finished code integrity check","userAgent":"--","version":"31.0.2.1","data":{"app":"updater"}}
{"reqId":"bH21nMDzr064SsMYfKlM","level":1,"time":"2025-07-13T16:24:46+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::updateEnd: Update successful","userAgent":"--","version":"31.0.7.1","data":{"app":"updater"}}
{"reqId":"bH21nMDzr064SsMYfKlM","level":1,"time":"2025-07-13T16:24:46+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::maintenanceDisabled: Turned off maintenance mode","userAgent":"--","version":"31.0.7.1","data":{"app":"updater"}}
{"reqId":"bH21nMDzr064SsMYfKlM","level":1,"time":"2025-07-13T16:24:46+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::resetLogLevel: Reset log level to Warning(2)","userAgent":"--","version":"31.0.7.1","data":{"app":"updater"}}
{"reqId":"1aFOPM6YpTut3lSlzqtP","level":2,"time":"2025-07-13T16:25:26+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Temporary directory /media/data/ncdata/data/tmp is not present or writable","userAgent":"--","version":"31.0.7.1","data":[]}
{"reqId":"1aFOPM6YpTut3lSlzqtP","level":2,"time":"2025-07-13T16:25:26+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Temporary directory /media/data/ncdata/data/tmp is not present or writable","userAgent":"--","version":"31.0.7.1","data":[]}
{"reqId":"nqRVoMuqJkfuRCKr3MaW","level":2,"time":"2025-07-13T16:25:26+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Temporary directory /media/data/ncdata/data/tmp is not present or writable","userAgent":"--","version":"31.0.7.1","data":[]}
{"reqId":"nqRVoMuqJkfuRCKr3MaW","level":2,"time":"2025-07-13T16:25:26+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","message":"Temporary directory /media/data/ncdata/data/tmp is not present or writable","userAgent":"--","version":"31.0.7.1","data":[]}
System information
NextcloudPi diagnostics
Nextcloud configuration
HTTPd logs
Database logs
Nextcloud logs
Running nc-datadir gives the following output
It makes no difference if the new DATADIR location is btrfs or ext4 formatted. Checking to original DATADIR shows that none of the mentioned errors are real:
Initial DATADIR:
These messages are wrong or misleading
Temporary directory /opt/ncdata/data/tmp is not present or writableEnsure there is a file called ".ncdata" in the root of the data directory.Cannot create "data" directory.