Skip to content

Odroid HC4: 2nd SATA port suddenly not working after 1.57.0 update (system crash when plugging the 2nd backup drive) #2109

@zedocrob

Description

@zedocrob

System information

NextcloudPi diagnostics

NextcloudPi version  v1.57.0
NextcloudPi image    
OS                   Armbian-unofficial 24.8.2 bookworm. 6.6.47-current-meson64 (aarch64)
automount            yes
USB devices          none
datadir              /media/DATAcloud/ncdata/data
data in SD           no
data filesystem      btrfs
data disk usage      1.3T/3.7T
rootfs usage         7.1G/29G
swapfile             /var/swap
dbdir                /var/lib/mysql
Nextcloud check      ok
Nextcloud version    33.0.2.2
HTTPD service        up
PHP service          up
MariaDB service      up
Redis service        up
HPB service          up
Postfix service      up
Internet check       ok
Public IPv4          ***REMOVED SENSITIVE VALUE***
Public IPv6          ***REMOVED SENSITIVE VALUE***
Port 80              open
Port 443             open
IP                   ***REMOVED SENSITIVE VALUE***
Gateway              ***REMOVED SENSITIVE VALUE***
Interface            end0
Certificates         ***REMOVED SENSITIVE VALUE***
NAT loopback         no
Uptime               11min

Nextcloud configuration

{
    "system": {
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": {
            "0": "localhost",
            "7": "nextcloudpi",
            "5": "nextcloudpi.local",
            "8": "nextcloudpi.lan",
            "3": "robserver.duckdns.org",
            "11": "78.203.120.240",
            "1": "192.168.0.9",
            "14": "nextcloudpi",
            "20": "78.203.120.240",
            "21": "robserver.duckdns.org",
            "22": "192.168.0.254",
            "12": "[2a01:e34:ecb7:8f00:3cb1:226f:75c6:5dd0]"
        },
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "33.0.2.2",
        "overwrite.cli.url": "https:\/\/robserver.duckdns.org\/",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "default_phone_region": "FR",
        "maintenance_window_start": 1,
        "memcache.local": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "timeout": 0,
            "password": "***REMOVED SENSITIVE VALUE***"
        },
        "tempdirectory": "\/media\/DATAcloud\/ncdata\/data\/tmp",
        "mail_smtpmode": "smtp",
        "mail_smtpauthtype": "LOGIN",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "preview_max_x": "2048",
        "preview_max_y": "2048",
        "jpeg_quality": "60",
        "overwriteprotocol": "https",
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "loglevel": "2",
        "log_type": "file",
        "htaccess.RewriteBase": "\/",
        "maintenance": false,
        "mail_sendmailmode": "smtp",
        "mail_smtpsecure": "tls",
        "mail_smtpauth": 1,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "587",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "logfile": "\/media\/DATAcloud\/ncdata\/data\/nextcloud.log",
        "data-fingerprint": "b8ac664eba7d4d2482f918f253189aa1",
        "theme": "",
        "app_install_overwrite": [],
        "twofactor_enforced": "false",
        "twofactor_enforced_groups": [],
        "twofactor_enforced_excluded_groups": [],
        "serverid": 936
    }
}

HTTPd logs

[Sat Apr 11 17:23:20.397686 2026] [authz_host:error] [pid 2454:tid 2466] [remote 192.168.0.54:49533] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Sat Apr 11 17:23:20.597109 2026] [authz_host:error] [pid 2454:tid 2466] [remote 192.168.0.54:49533] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Sat Apr 11 17:23:43.397552 2026] [authz_host:error] [pid 2453:tid 2499] [remote 192.168.0.54:65517] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Sat Apr 11 17:23:43.593228 2026] [authz_host:error] [pid 2453:tid 2499] [remote 192.168.0.54:65517] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Sat Apr 11 17:23:43.594399 2026] [authz_host:error] [pid 2453:tid 2499] [remote 192.168.0.54:65517] AH01753: access check of 'localhost' to /index.php failed, reason: unable to get the remote host name
[Sat Apr 11 17:23:43.790049 2026] [authz_host:error] [pid 2453:tid 2499] [remote 192.168.0.54:65517] AH01753: access check of 'localhost' to /index.php failed, reason: unable to get the remote host name
[Sat Apr 11 17:25:17.647733 2026] [authz_host:error] [pid 2454:tid 2479] [remote 192.168.0.54:49533] AH01753: access check of 'localhost' to /img/info.svg failed, reason: unable to get the remote host name, referer: https://192.168.0.9:4443/css/ncp.css
[Sat Apr 11 17:25:17.848852 2026] [authz_host:error] [pid 2454:tid 2479] [remote 192.168.0.54:49533] AH01753: access check of 'localhost' to /img/info.svg failed, reason: unable to get the remote host name, referer: https://192.168.0.9:4443/css/ncp.css
[Sat Apr 11 17:25:34.147707 2026] [authz_host:error] [pid 2454:tid 2477] [remote 192.168.0.54:49533] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Sat Apr 11 17:25:34.349549 2026] [authz_host:error] [pid 2454:tid 2477] [remote 192.168.0.54:49533] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Sat Apr 11 17:25:40.018802 2026] [authz_host:error] [pid 2454:tid 2476] [remote 192.168.0.54:49533] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Sat Apr 11 17:25:40.220395 2026] [authz_host:error] [pid 2454:tid 2476] [remote 192.168.0.54:49533] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Sat Apr 11 17:25:45.647789 2026] [authz_host:error] [pid 2454:tid 2471] [remote 192.168.0.54:49533] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Sat Apr 11 17:25:45.848700 2026] [authz_host:error] [pid 2454:tid 2471] [remote 192.168.0.54:49533] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Sat Apr 11 17:25:53.397587 2026] [authz_host:error] [pid 2454:tid 2473] [remote 192.168.0.54:49533] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Sat Apr 11 17:25:53.598234 2026] [authz_host:error] [pid 2454:tid 2473] [remote 192.168.0.54:49533] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Sat Apr 11 17:27:01.647447 2026] [authz_host:error] [pid 2454:tid 2478] [remote 192.168.0.54:49533] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Sat Apr 11 17:27:01.647753 2026] [authz_host:error] [pid 2454:tid 2481] [remote 192.168.0.54:49533] AH01753: access check of 'localhost' to /img/green-circle.svg failed, reason: unable to get the remote host name, referer: https://192.168.0.9:4443/css/ncp.css
[Sat Apr 11 17:27:01.846432 2026] [authz_host:error] [pid 2454:tid 2481] [remote 192.168.0.54:49533] AH01753: access check of 'localhost' to /img/green-circle.svg failed, reason: unable to get the remote host name, referer: https://192.168.0.9:4443/css/ncp.css
[Sat Apr 11 17:27:01.859819 2026] [authz_host:error] [pid 2454:tid 2478] [remote 192.168.0.54:49533] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name

Database logs

tail: cannot open '/var/log/mysql/*.log' for reading: No such file or directory

Nextcloud logs

{"reqId":"q7IvfdYdJZ9TrbsECL5z","level":0,"time":"2026-04-06T07:08:22+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","scriptName":"nextcloud/occ","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"32.0.8.2","occ_command":["nextcloud/occ","upgrade"],"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":268,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/JobList.php","line":131,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/JobList.php","line":57,"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":107,"function":"run","class":"OC\\Repair\\NC29\\SanitizeAccountProperties","type":"->"},{"file":"/var/www/nextcloud/lib/private/Updater.php","line":263,"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":193,"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":1083,"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":92,"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":407,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":"[\"oc_migrations\",\"oc_share\",\"oc_jobs\",\"oc_appconfig\",\"oc_preferences\",\"oc_calendars\",\"oc_activity\",\"oc_text_steps\",\"oc_text_sessions\",\"oc_text_documents\",\"oc_filecache\",\"oc_oauth2_access_tokens\",\"oc_oauth2_clients\",\"oc_filecache_extended\",\"oc_files_metadata\",\"oc_files_metadata_index\"]","reads":"[\"oc_jobs\"]","exception":"{\"class\":\"Exception\",\"message\":\"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1\",\"code\":0,\"file\":\"/var/www/nextcloud/lib/private/DB/Connection.php:407\",\"trace\":\"#0 /var/www/nextcloud/lib/private/DB/ConnectionAdapter.php(50): OC\\DB\\Connection->executeQuery()\\n#1 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(268): OC\\DB\\ConnectionAdapter->executeQuery()\\n#2 /var/www/nextcloud/lib/private/BackgroundJob/JobList.php(131): OC\\DB\\QueryBuilder\\QueryBuilder->executeQuery()\\n#3 /var/www/nextcloud/lib/private/BackgroundJob/JobList.php(57): OC\\BackgroundJob\\JobList->has()\\n#4 /var/www/nextcloud/lib/private/Repair/NC29/SanitizeAccountProperties.php(27): OC\\BackgroundJob\\JobList->add()\\n#5 /var/www/nextcloud/lib/private/Repair.php(107): OC\\Repair\\NC29\\SanitizeAccountProperties->run()\\n#6 /var/www/nextcloud/lib/private/Updater.php(263): OC\\Repair->run()\\n#7 /var/www/nextcloud/lib/private/Updater.php(100): OC\\Updater->doUpgrade()\\n#8 /var/www/nextcloud/core/Command/Upgrade.php(193): OC\\Updater->upgrade()\\n#9 /var/www/nextcloud/3rdparty/symfony/console/Command/Command.php(326): OC\\Core\\Command\\Upgrade->execute()\\n#10 /var/www/nextcloud/3rdparty/symfony/console/Application.php(1083): Symfony\\Component\\Console\\Command\\Command->run()\\n#11 /var/www/nextcloud/3rdparty/symfony/console/Application.php(324): Symfony\\Component\\Console\\Application->doRunCommand()\\n#12 /var/www/nextcloud/3rdparty/symfony/console/Application.php(175): Symfony\\Component\\Console\\Application->doRun()\\n#13 /var/www/nextcloud/lib/private/Console/Application.php(187): Symfony\\Component\\Console\\Application->run()\\n#14 /var/www/nextcloud/console.php(92): OC\\Console\\Application->run()\\n#15 /var/www/nextcloud/occ(33): require_once('...')\\n#16 {main}\"}","CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"q7IvfdYdJZ9TrbsECL5z","level":1,"time":"2026-04-06T07:08:22+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","scriptName":"nextcloud/occ","message":"OC\\Repair\\Events\\RepairInfoEvent: Repair info: Queued background to validate account properties.","userAgent":"--","version":"32.0.8.2","occ_command":["nextcloud/occ","upgrade"],"data":{"app":"updater"}}
{"reqId":"q7IvfdYdJZ9TrbsECL5z","level":1,"time":"2026-04-06T07:08:22+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","scriptName":"nextcloud/occ","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: Queue a job to move the preview","userAgent":"--","version":"32.0.8.2","occ_command":["nextcloud/occ","upgrade"],"data":{"app":"updater"}}
{"reqId":"q7IvfdYdJZ9TrbsECL5z","level":0,"time":"2026-04-06T07:08:22+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","scriptName":"nextcloud/occ","message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","userAgent":"--","version":"32.0.8.2","occ_command":["nextcloud/occ","upgrade"],"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":268,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/JobList.php","line":131,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/BackgroundJob/JobList.php","line":57,"function":"has","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud/lib/private/Repair/AddMovePreviewJob.php","line":25,"function":"add","class":"OC\\BackgroundJob\\JobList","type":"->"},{"file":"/var/www/nextcloud/lib/private/Repair.php","line":107,"function":"run","class":"OC\\Repair\\AddMovePreviewJob","type":"->"},{"file":"/var/www/nextcloud/lib/private/Updater.php","line":263,"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":193,"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":1083,"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":92,"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":407,"message":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1","tables":"[\"oc_migrations\",\"oc_share\",\"oc_jobs\",\"oc_appconfig\",\"oc_preferences\",\"oc_calendars\",\"oc_activity\",\"oc_text_steps\",\"oc_text_sessions\",\"oc_text_documents\",\"oc_filecache\",\"oc_oauth2_access_tokens\",\"oc_oauth2_clients\",\"oc_filecache_extended\",\"oc_files_metadata\",\"oc_files_metadata_index\"]","reads":"[\"oc_jobs\"]","exception":"{\"class\":\"Exception\",\"message\":\"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1\",\"code\":0,\"file\":\"/var/www/nextcloud/lib/private/DB/Connection.php:407\",\"trace\":\"#0 /var/www/nextcloud/lib/private/DB/ConnectionAdapter.php(50): OC\\DB\\Connection->executeQuery()\\n#1 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(268): OC\\DB\\ConnectionAdapter->executeQuery()\\n#2 /var/www/nextcloud/lib/private/BackgroundJob/JobList.php(131): OC\\DB\\QueryBuilder\\QueryBuilder->executeQuery()\\n#3 /var/www/nextcloud/lib/private/BackgroundJob/JobList.php(57): OC\\BackgroundJob\\JobList->has()\\n#4 /var/www/nextcloud/lib/private/Repair/AddMovePreviewJob.php(25): OC\\BackgroundJob\\JobList->add()\\n#5 /var/www/nextcloud/lib/private/Repair.php(107): OC\\Repair\\AddMovePreviewJob->run()\\n#6 /var/www/nextcloud/lib/private/Updater.php(263): OC\\Repair->run()\\n#7 /var/www/nextcloud/lib/private/Updater.php(100): OC\\Updater->doUpgrade()\\n#8 /var/www/nextcloud/core/Command/Upgrade.php(193): OC\\Updater->upgrade()\\n#9 /var/www/nextcloud/3rdparty/symfony/console/Command/Command.php(326): OC\\Core\\Command\\Upgrade->execute()\\n#10 /var/www/nextcloud/3rdparty/symfony/console/Application.php(1083): Symfony\\Component\\Console\\Command\\Command->run()\\n#11 /var/www/nextcloud/3rdparty/symfony/console/Application.php(324): Symfony\\Component\\Console\\Application->doRunCommand()\\n#12 /var/www/nextcloud/3rdparty/symfony/console/Application.php(175): Symfony\\Component\\Console\\Application->doRun()\\n#13 /var/www/nextcloud/lib/private/Console/Application.php(187): Symfony\\Component\\Console\\Application->run()\\n#14 /var/www/nextcloud/console.php(92): OC\\Console\\Application->run()\\n#15 /var/www/nextcloud/occ(33): require_once('...')\\n#16 {main}\"}","CustomMessage":"dirty table reads: SELECT `id` FROM `*PREFIX*jobs` WHERE (`class` = :dcValue1) AND (`argument_hash` = :dcValue2) LIMIT 1"}}
{"reqId":"q7IvfdYdJZ9TrbsECL5z","level":1,"time":"2026-04-06T07:08:22+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","scriptName":"nextcloud/occ","message":"OC\\Repair\\Events\\RepairStepEvent: Repair step: Migrate config keys","userAgent":"--","version":"32.0.8.2","occ_command":["nextcloud/occ","upgrade"],"data":{"app":"updater"}}
{"reqId":"q7IvfdYdJZ9TrbsECL5z","level":0,"time":"2026-04-06T07:08:22+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","scriptName":"nextcloud/occ","message":"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type`, `lazy` FROM `*PREFIX*appconfig` WHERE `lazy` = :dcValue1","userAgent":"--","version":"32.0.8.2","occ_command":["nextcloud/occ","upgrade"],"exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type`, `lazy` FROM `*PREFIX*appconfig` WHERE `lazy` = :dcValue1","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":268,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":1361,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":1037,"function":"loadConfig","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud/lib/private/Config/ConfigManager.php","line":104,"function":"updateLazy","class":"OC\\AppConfig","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Config/ConfigManager.php","line":91,"function":"updateLexiconAppConfigEntries","class":"OC\\Config\\ConfigManager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Repair/ConfigKeyMigration.php","line":28,"function":"updateLexiconEntries","class":"OC\\Config\\ConfigManager","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/Repair.php","line":107,"function":"run","class":"OC\\Repair\\ConfigKeyMigration","type":"->"},{"file":"/var/www/nextcloud/lib/private/Updater.php","line":263,"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":193,"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":1083,"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":92,"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":407,"message":"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type`, `lazy` FROM `*PREFIX*appconfig` WHERE `lazy` = :dcValue1","tables":"[\"oc_migrations\",\"oc_share\",\"oc_jobs\",\"oc_appconfig\",\"oc_preferences\",\"oc_calendars\",\"oc_activity\",\"oc_text_steps\",\"oc_text_sessions\",\"oc_text_documents\",\"oc_filecache\",\"oc_oauth2_access_tokens\",\"oc_oauth2_clients\",\"oc_filecache_extended\",\"oc_files_metadata\",\"oc_files_metadata_index\"]","reads":"[\"oc_appconfig\"]","exception":"{\"class\":\"Exception\",\"message\":\"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type`, `lazy` FROM `*PREFIX*appconfig` WHERE `lazy` = :dcValue1\",\"code\":0,\"file\":\"/var/www/nextcloud/lib/private/DB/Connection.php:407\",\"trace\":\"#0 /var/www/nextcloud/lib/private/DB/ConnectionAdapter.php(50): OC\\DB\\Connection->executeQuery()\\n#1 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(268): OC\\DB\\ConnectionAdapter->executeQuery()\\n#2 /var/www/nextcloud/lib/private/AppConfig.php(1361): OC\\DB\\QueryBuilder\\QueryBuilder->executeQuery()\\n#3 /var/www/nextcloud/lib/private/AppConfig.php(1037): OC\\AppConfig->loadConfig()\\n#4 /var/www/nextcloud/lib/private/Config/ConfigManager.php(104): OC\\AppConfig->updateLazy()\\n#5 /var/www/nextcloud/lib/private/Config/ConfigManager.php(91): OC\\Config\\ConfigManager->updateLexiconAppConfigEntries()\\n#6 /var/www/nextcloud/lib/private/Repair/ConfigKeyMigration.php(28): OC\\Config\\ConfigManager->updateLexiconEntries()\\n#7 /var/www/nextcloud/lib/private/Repair.php(107): OC\\Repair\\ConfigKeyMigration->run()\\n#8 /var/www/nextcloud/lib/private/Updater.php(263): OC\\Repair->run()\\n#9 /var/www/nextcloud/lib/private/Updater.php(100): OC\\Updater->doUpgrade()\\n#10 /var/www/nextcloud/core/Command/Upgrade.php(193): OC\\Updater->upgrade()\\n#11 /var/www/nextcloud/3rdparty/symfony/console/Command/Command.php(326): OC\\Core\\Command\\Upgrade->execute()\\n#12 /var/www/nextcloud/3rdparty/symfony/console/Application.php(1083): Symfony\\Component\\Console\\Command\\Command->run()\\n#13 /var/www/nextcloud/3rdparty/symfony/console/Application.php(324): Symfony\\Component\\Console\\Application->doRunCommand()\\n#14 /var/www/nextcloud/3rdparty/symfony/console/Application.php(175): Symfony\\Component\\Console\\Application->doRun()\\n#15 /var/www/nextcloud/lib/private/Console/Application.php(187): Symfony\\Component\\Console\\Application->run()\\n#16 /var/www/nextcloud/console.php(92): OC\\Console\\Application->run()\\n#17 /var/www/nextcloud/occ(33): require_once('...')\\n#18 {main}\"}","CustomMessage":"dirty table reads: SELECT `appid`, `configkey`, `configvalue`, `type`, `lazy` FROM `*PREFIX*appconfig` WHERE `lazy` = :dcValue1"}}
{"reqId":"q7IvfdYdJZ9TrbsECL5z","level":0,"time":"2026-04-06T07:08:22+00:00","remoteAddr":"","user":"--","app":"serverDI","method":"","url":"--","scriptName":"nextcloud/occ","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":"32.0.8.2","occ_command":["nextcloud/occ","upgrade"],"data":{"app":"serverDI"}}
{"reqId":"q7IvfdYdJZ9TrbsECL5z","level":1,"time":"2026-04-06T07:08:22+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","scriptName":"nextcloud/occ","message":"\\OC\\Updater::startCheckCodeIntegrity: Starting code integrity check...","userAgent":"--","version":"32.0.8.2","occ_command":["nextcloud/occ","upgrade"],"data":{"app":"updater"}}
{"reqId":"q7IvfdYdJZ9TrbsECL5z","level":1,"time":"2026-04-06T07:09:18+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","scriptName":"nextcloud/occ","message":"\\OC\\Updater::finishedCheckCodeIntegrity: Finished code integrity check","userAgent":"--","version":"32.0.8.2","occ_command":["nextcloud/occ","upgrade"],"data":{"app":"updater"}}
{"reqId":"q7IvfdYdJZ9TrbsECL5z","level":1,"time":"2026-04-06T07:09:18+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","scriptName":"nextcloud/occ","message":"\\OC\\Updater::updateEnd: Update successful","userAgent":"--","version":"33.0.2.2","occ_command":["nextcloud/occ","upgrade"],"data":{"app":"updater"}}
{"reqId":"q7IvfdYdJZ9TrbsECL5z","level":1,"time":"2026-04-06T07:09:18+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","scriptName":"nextcloud/occ","message":"\\OC\\Updater::maintenanceDisabled: Turned off maintenance mode","userAgent":"--","version":"33.0.2.2","occ_command":["nextcloud/occ","upgrade"],"data":{"app":"updater"}}
{"reqId":"q7IvfdYdJZ9TrbsECL5z","level":1,"time":"2026-04-06T07:09:18+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","scriptName":"nextcloud/occ","message":"\\OC\\Updater::resetLogLevel: Reset log level to Warning(2)","userAgent":"--","version":"33.0.2.2","occ_command":["nextcloud/occ","upgrade"],"data":{"app":"updater"}}
{"reqId":"79Q7BiBtPHTl1Wu4tF4O","level":2,"time":"2026-04-06T07:15:02+00:00","remoteAddr":"","user":"--","app":"no app in context","method":"","url":"--","scriptName":"/var/www/nextcloud/cron.php","message":"Skipping updater backup clean-up - could not find updater backup folder /media/DATAcloud/ncdata/data/updater-ocuzkzdyazo6/backups","userAgent":"--","version":"33.0.2.2","occ_command":["/var/www/nextcloud/cron.php"],"data":[]}
{"reqId":"ERaDLpSytwwmYEDHLh8h","level":2,"time":"2026-04-06T07:58:25+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","scriptName":"/var/www/nextcloud/occ","message":"exif_imagetype(): PNG file corrupted by ASCII conversion at /var/www/nextcloud/lib/private/Image.php#607","userAgent":"--","version":"32.0.8.2","occ_command":["/var/www/nextcloud/occ","preview:generate-all"],"data":{"app":"PHP"}}
{"reqId":"adQhZMue9S_xqYGLy8lsqAAATCE","level":2,"time":"2026-04-06T21:11:00+00:00","remoteAddr":"192.168.0.254","user":"rob","app":"PHP","method":"GET","url":"/ocs/v2.php/apps/dashboard/api/v1/widgets","scriptName":"/ocs/v2.php","message":"Undefined array key \"node\" at /var/www/nextcloud/apps/notes/lib/Service/NoteUtil.php#201","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36","version":"33.0.2.2","data":{"app":"PHP"}}
{"reqId":"adQiZzBYfoKzbLusIQcYnQAAFgg","level":2,"time":"2026-04-06T21:15:20+00:00","remoteAddr":"192.168.0.254","user":"rob","app":"PHP","method":"GET","url":"/ocs/v2.php/apps/dashboard/api/v1/widgets","scriptName":"/ocs/v2.php","message":"Undefined array key \"node\" at /var/www/nextcloud/apps/notes/lib/Service/NoteUtil.php#201","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36","version":"33.0.2.2","data":{"app":"PHP"}}
{"reqId":"adVPYBaG8bZ8P1KVLIuiDQAATRI","level":2,"time":"2026-04-07T18:39:29+00:00","remoteAddr":"192.168.0.254","user":"rob","app":"PHP","method":"GET","url":"/ocs/v2.php/apps/dashboard/api/v1/widgets","scriptName":"/ocs/v2.php","message":"Undefined array key \"node\" at /var/www/nextcloud/apps/notes/lib/Service/NoteUtil.php#201","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36","version":"33.0.2.2","data":{"app":"PHP"}}
{"reqId":"adWYMTltFEgvCtPq7awaNgAADBY","level":2,"time":"2026-04-07T23:50:09+00:00","remoteAddr":"192.168.0.254","user":"rob","app":"PHP","method":"GET","url":"/ocs/v2.php/apps/dashboard/api/v1/widgets","scriptName":"/ocs/v2.php","message":"Undefined array key \"node\" at /var/www/nextcloud/apps/notes/lib/Service/NoteUtil.php#201","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36","version":"33.0.2.2","data":{"app":"PHP"}}
{"reqId":"adZeRuJLliwpAm1h4iFRzgAATQc","level":2,"time":"2026-04-08T13:55:18+00:00","remoteAddr":"192.168.0.254","user":"rob","app":"PHP","method":"GET","url":"/ocs/v2.php/apps/dashboard/api/v1/widgets","scriptName":"/ocs/v2.php","message":"Undefined array key \"node\" at /var/www/nextcloud/apps/notes/lib/Service/NoteUtil.php#201","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36","version":"33.0.2.2","data":{"app":"PHP"}}
{"reqId":"adp3f0R30YZ6xCTfT82TpgAASA8","level":2,"time":"2026-04-11T16:32:00+00:00","remoteAddr":"192.168.0.254","user":"rob","app":"PHP","method":"GET","url":"/ocs/v2.php/apps/dashboard/api/v1/widgets","scriptName":"/ocs/v2.php","message":"Undefined array key \"node\" at /var/www/nextcloud/apps/notes/lib/Service/NoteUtil.php#201","userAgent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:140.0) Gecko/20100101 Firefox/140.0","version":"33.0.2.2","data":{"app":"PHP"}}

Hi,
since ncp 1.57.0 i have a problem connecting my backup SATA drive (named "WDbackup" and used for ncp-backup-sync) on the first SATA port (the closest to the power cord and plugged directly in the "toaster").
The drives are working fine when plugged in the other SATA port.

So for now i only have the main drive on the working port (named DATAcloud and used for Nextcloud ncdata)
The 2 SATA ports looks there anyway:

root@nextcloudpi:/# dmesg | grep -i sata
[    2.165217] ata1: SATA max UDMA/133 abar m512@0xfc700000 port 0xfc700100 irq 26
[    2.165231] ata2: SATA max UDMA/133 abar m512@0xfc700000 port 0xfc700180 irq 26
[    7.378030] ata1: SATA link up 6.0 Gbps (SStatus 133 SControl 300)
[    7.696555] ata2: SATA link down (SStatus 0 SControl 300)
root@nextcloudpi:/# lsblk
NAME        MAJ:MIN RM   SIZE RO TYPE MOUNTPOINTS
sda           8:0    0   3.6T  0 disk 
└─sda1        8:1    0   3.6T  0 part /media/DATAcloud
mtdblock0    31:0    0    16M  0 disk 
mmcblk0     179:0    0  29.8G  0 disk 
└─mmcblk0p1 179:1    0  29.5G  0 part /var/log.hdd
                                      /
zram0       251:0    0   1.8G  0 disk [SWAP]
zram1       251:1    0    50M  0 disk /var/log
zram2       251:2    0 945.3M  0 disk [SWAP]

Symptoms:
When i plug the "WDbackup" drive to the second SATA port alongside the main drive, system is not booting (fix red light and no blue light flashing) same if i plug the other drive in it.
and system is NOT rebooting after unpluging it (blue light flashing back but no SSH or WebUI Panel connection)... I had to connect the SDcard to computer and start with a clean fstab to make it boot back.

fstab with 'WDbackup" drive removed (if WDbackup is listed in it and unplugged system is not booting):

UUID=c3af9377-d36b-4ba0-bb6e-somenumbers / ext4 defaults,noatime,commit=120,errors=remount-ro 0 1
tmpfs /tmp tmpfs defaults,nosuid 0 0

#DATAcloud (dev/sda1)
UUID=afda45a6-a6fa-483f-9bbe-somenumbers /media/DATAcloud btrfs defaults 0 0
# a swapfile is not a swap partition, no line here
#   use  dphys-swapfile swap[on|off]  for that

current kernel:

root@nextcloudpi:/# uname -r
6.6.47-current-meson64
apt policy linux-image-current-meson64
linux-image-current-meson64:
  Installed: 24.8.2
  Candidate: 26.2.1
  Version table:
     26.2.1 500
        500 http://apt.armbian.com bookworm/main arm64 Packages
     25.11.2 500
        500 http://apt.armbian.com bookworm/main arm64 Packages
     25.8.2 500
        500 http://apt.armbian.com bookworm/main arm64 Packages
     25.8.1 500
        500 http://apt.armbian.com bookworm/main arm64 Packages
     25.5.1 500
        500 http://apt.armbian.com bookworm/main arm64 Packages
     25.2.3 500
        500 http://apt.armbian.com bookworm/main arm64 Packages
     25.2.2 500
        500 http://apt.armbian.com bookworm/main arm64 Packages
     24.11.1 500
        500 http://apt.armbian.com bookworm/main arm64 Packages
 *** 24.8.2 500
        500 http://apt.armbian.com bookworm/main arm64 Packages
        100 /var/lib/dpkg/status
     24.8.1 500
        500 http://apt.armbian.com bookworm/main arm64 Packages
     24.5.1 500
        500 http://apt.armbian.com bookworm/main arm64 Packages
     24.2.1 500
        500 http://apt.armbian.com bookworm/main arm64 Packages

I also tried a clean ncp install 1.57.0 on another SDcard and same SATA problem.

Question:
As the problem suddenly arrived a few hours during the night after auto-update to ncp 1.57.0 (system suddenly crashed and SATA port problem appear) Could it be related to a kernel version problem like reported before on DietPi on some kernel version with SATA driver not working well?
ref: MichaIng/DietPi#8075
regards,

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions