https://github.com/nextcloud/nextcloudpi/issues/1479
facing Internal Server Error
Logs follow. Thanks for any advice.
NextCloudPi diagnostics
NextCloudPi version v1.47.2
NextCloudPi image NextCloudPi_docker_03-07-22
OS Debian GNU/Linux 11. 5.10.102-meson64 (aarch64)
automount no
USB devices none
datadir /data/nextcloud/data
data in SD yes
data filesystem ext2/ext3
data disk usage 83G/117G
rootfs usage 83G/117G
swapfile /dev/zram0
dbdir /data/database
Nextcloud check error
HTTPD service up
PHP service up
MariaDB service down
Redis service down
HPB service down
Postfix service down
internet check ok
port check 80 closed
port check 443 closed
IP ***REMOVED SENSITIVE VALUE***
gateway ***REMOVED SENSITIVE VALUE***
interface eth0
certificates ***REMOVED SENSITIVE VALUE***
NAT loopback no
uptime 2days
Nextcloud configuration
An unhandled exception has been thrown:
Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory in /data-ro/nextcloud/lib/private/DB/Connection.php:87
Stack trace:
#0 /data-ro/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\DB\Connection->connect()
#1 /data-ro/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\DBAL\Connection->getWrappedConnection()
#2 /data-ro/nextcloud/lib/private/DB/Connection.php(237): Doctrine\DBAL\Connection->executeQuery()
#3 /data-ro/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\DB\Connection->executeQuery()
#4 /data-ro/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\DBAL\Query\QueryBuilder->execute()
#5 /data-ro/nextcloud/lib/private/AppConfig.php(344): OC\DB\QueryBuilder\QueryBuilder->execute()
#6 /data-ro/nextcloud/lib/private/AppConfig.php(109): OC\AppConfig->loadConfigValues()
#7 /data-ro/nextcloud/lib/private/AppConfig.php(300): OC\AppConfig->getApps()
#8 /data-ro/nextcloud/lib/private/legacy/OC_App.php(972): OC\AppConfig->getValues()
#9 /data-ro/nextcloud/lib/private/Server.php(692): OC_App::getAppVersions()
#10 /data-ro/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(160): OC\Server->OC\{closure}()
#11 /data-ro/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#12 /data-ro/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(127): Pimple\Container->offsetGet()
#13 /data-ro/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query()
#14 /data-ro/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(56): OC\ServerContainer->query()
#15 /data-ro/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(182): OC\AppFramework\Utility\SimpleContainer->get()
#16 /data-ro/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(160): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#17 /data-ro/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#18 /data-ro/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(127): Pimple\Container->offsetGet()
#19 /data-ro/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query()
#20 /data-ro/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(56): OC\ServerContainer->query()
#21 /data-ro/nextcloud/lib/private/Server.php(1079): OC\AppFramework\Utility\SimpleContainer->get()
#22 /data-ro/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(160): OC\Server->OC\{closure}()
#23 /data-ro/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#24 /data-ro/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(127): Pimple\Container->offsetGet()
#25 /data-ro/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query()
#26 /data-ro/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(56): OC\ServerContainer->query()
#27 /data-ro/nextcloud/lib/private/Server.php(2040): OC\AppFramework\Utility\SimpleContainer->get()
#28 /data-ro/nextcloud/lib/private/Files/View.php(118): OC\Server->getLockingProvider()
#29 /data-ro/nextcloud/lib/private/Server.php(439): OC\Files\View->__construct()
#30 /data-ro/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(160): OC\Server->OC\{closure}()
#31 /data-ro/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}()
#32 /data-ro/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(127): Pimple\Container->offsetGet()
#33 /data-ro/nextcloud/lib/private/ServerContainer.php(136): OC\AppFramework\Utility\SimpleContainer->query()
#34 /data-ro/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(56): OC\ServerContainer->query()
#35 /data-ro/nextcloud/lib/private/Server.php(1403): OC\AppFramework\Utility\SimpleContainer->get()
#36 /data-ro/nextcloud/lib/base.php(594): OC\Server->boot()
#37 /data-ro/nextcloud/lib/base.php(1087): OC::init()
#38 /data-ro/nextcloud/console.php(48): require_once('/data-ro/nextcl...')
#39 /data-ro/nextcloud/occ(11): require_once('/data-ro/nextcl...')
#40 {main}
HTTPd logs
[Sun May 15 21:46:50.786049 2022] [authz_host:error] [pid 891:tid 281473633104272] [client 192.168.0.10:50886] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Sun May 15 21:48:11.038668 2022] [mpm_event:notice] [pid 123:tid 281473847869456] AH00493: SIGUSR1 received. Doing graceful restart
[Sun May 15 21:48:11.074199 2022] [ssl:warn] [pid 123:tid 281473847869456] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sun May 15 21:48:11.080341 2022] [mpm_event:notice] [pid 123:tid 281473847869456] AH00489: Apache/2.4.52 (Debian) OpenSSL/1.1.1k configured -- resuming normal operations
[Sun May 15 21:48:11.080430 2022] [core:notice] [pid 123:tid 281473847869456] AH00094: Command line: '/usr/sbin/apache2'
[Sun May 15 21:56:00.405290 2022] [authz_host:error] [pid 1653:tid 281473742209424] [client 192.168.0.10:50992] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Sun May 15 21:56:03.180724 2022] [authz_host:error] [pid 1653:tid 281473742209424] [client 192.168.0.10:50992] AH01753: access check of 'localhost' to /favicon.ico failed, reason: unable to get the remote host name, referer: https://192.168.0.107:4443/
[Sun May 15 23:08:40.353994 2022] [authz_host:error] [pid 1653:tid 281473742209424] [client 192.168.0.10:51264] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Sun May 15 23:25:33.839558 2022] [mpm_event:notice] [pid 123:tid 281473847869456] AH00493: SIGUSR1 received. Doing graceful restart
apache2: Syntax error on line 146 of /etc/apache2/apache2.conf: Syntax error on line 1 of /etc/apache2/mods-enabled/http2.load: Cannot load /usr/lib/apache2/modules/mod_http2.so into server: /usr/lib/apache2/modules/mod_http2.so: undefined symbol: ap_thread_create
[Sun May 15 16:36:11.325532 2022] [ssl:warn] [pid 121:tid 281473346441232] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sun May 15 16:36:11.360187 2022] [ssl:warn] [pid 122:tid 281473346441232] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sun May 15 16:36:11.364542 2022] [core:warn] [pid 122:tid 281473346441232] AH00098: pid file /var/run/apache2/apache2.pid overwritten -- Unclean shutdown of previous Apache run?
[Sun May 15 16:36:11.369769 2022] [mpm_event:notice] [pid 122:tid 281473346441232] AH00489: Apache/2.4.53 (Debian) OpenSSL/1.1.1n configured -- resuming normal operations
[Sun May 15 16:36:11.369941 2022] [core:notice] [pid 122:tid 281473346441232] AH00094: Command line: '/usr/sbin/apache2'
[Sun May 15 17:09:48.431954 2022] [ssl:warn] [pid 122:tid 281473265266704] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sun May 15 17:09:48.467087 2022] [ssl:warn] [pid 123:tid 281473265266704] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sun May 15 17:09:48.471727 2022] [core:warn] [pid 123:tid 281473265266704] AH00098: pid file /var/run/apache2/apache2.pid overwritten -- Unclean shutdown of previous Apache run?
[Sun May 15 17:09:48.477557 2022] [mpm_event:notice] [pid 123:tid 281473265266704] AH00489: Apache/2.4.53 (Debian) OpenSSL/1.1.1n configured -- resuming normal operations
[Sun May 15 17:09:48.477731 2022] [core:notice] [pid 123:tid 281473265266704] AH00094: Command line: '/usr/sbin/apache2'
Database logs
tail: cannot open '/var/log/mysql/*.log' for reading: No such file or directory
Nextcloud logs
{"reqId":"YoFmomkz0Y6NFhx@3DkNFAAAAEw","level":0,"time":"2022-05-15T20:46:27+00:00","remoteAddr":"76.210.138.30","user":"James","app":"workflowengine","method":"PROPFIND","url":"/remote.php/dav/files/James/","message":"Flow activation: rules were requested for operation Block access to a file","userAgent":"Mozilla/5.0 (Linux) mirall/3.5.0-20220505.175928.ccb79dc69-1.0~focal1 (Nextcloud, ubuntu-5.4.0-110-lowlatency ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"23.0.2.1"}
{"reqId":"YoFmomkz0Y6NFhx@3DkNFAAAAEw","level":0,"time":"2022-05-15T20:46:27+00:00","remoteAddr":"76.210.138.30","user":"James","app":"workflowengine","method":"PROPFIND","url":"/remote.php/dav/files/James/","message":"No flow configurations is going to run Block access to a file","userAgent":"Mozilla/5.0 (Linux) mirall/3.5.0-20220505.175928.ccb79dc69-1.0~focal1 (Nextcloud, ubuntu-5.4.0-110-lowlatency ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"auto_groups","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"webapppassword","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"extract","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"geoblocker","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"maps","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"metadata","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"piwik","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"qownnotesapi","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"socialsharing_email","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"socialsharing_facebook","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"socialsharing_twitter","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"suspicious_login","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"twofactor_gateway","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"uploaddetails","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"--","message":"new parser added : FeedIo\\Standard\\Json","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"--","message":"new parser added : FeedIo\\Standard\\Atom","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"--","message":"new parser added : FeedIo\\Standard\\Rss","userAgent":"--","version":"23.0.2.1"}
{"reqId":"7bwXwZy2wBjfIEZzxuZQ","level":0,"time":"2022-05-15T20:46:42+00:00","remoteAddr":"","user":"--","app":"news","method":"","url":"--","message":"new parser added : FeedIo\\Standard\\Rdf","userAgent":"--","version":"23.0.2.1"}
This image pull is moving NextcloudPi from Debian 10 to Debian 11. Seems that might be part of the issue.
# systemctl status apache2
apache2.service - The Apache HTTP Server
Loaded: loaded (/lib/systemd/system/apache2.service, enabled)
Active: inactive (dead)
# systemctl status mariadb
mariadb.service - MariaDB 10.5.15 database server
Loaded: loaded (/lib/systemd/system/mariadb.service, enabled)
Active: inactive (dead)
root@321d749b679d:/# systemctl status mysqld
mysqld.service - MariaDB 10.5.15 database server
Loaded: loaded (/lib/systemd/system/mysqld.service, disabled)
Active: inactive (dead)
# systemctl start mariadb
ERROR:systemctl:the ExecStartPre control process exited with error code
Trying the suggestion from this topic.
# /usr/sbin/mysqld --tc-heuristic-recover=commit
2022-05-16 1:20:22 0 [Note] /usr/sbin/mysqld (mysqld 10.5.12-MariaDB-0+deb11u1) starting as process 937 ...
2022-05-16 1:20:22 0 [ERROR] mysqld: File '/data/database/aria_log_control' not found (Errcode: 13 "Permission denied")
2022-05-16 1:20:22 0 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/data/database/aria_log_control'
2022-05-16 1:20:22 0 [ERROR] Plugin 'Aria' init function returned error.
2022-05-16 1:20:22 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2022-05-16 1:20:22 0 [Warning] The parameter innodb_file_format is deprecated and has no effect. It may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/
2022-05-16 1:20:22 0 [Warning] The parameter innodb_buffer_pool_instances is deprecated and has no effect.
2022-05-16 1:20:22 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-05-16 1:20:22 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2022-05-16 1:20:22 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-05-16 1:20:22 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-05-16 1:20:22 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-05-16 1:20:22 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
2022-05-16 1:20:22 0 [ERROR] Failed to initialize plugins.
2022-05-16 1:20:22 0 [ERROR] Aborting
Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory in /data/nextcloud/lib/private/DB/Connection.php:87
# cat /var/log/apache2/nc-error.log
[Mon May 16 01:25:26.138859 2022] [proxy_fcgi:error] [pid 132:tid 281472158134672] [client 76.210.138.30:50881] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory in /data-ro/nextcloud/lib/private/DB/Connection.php:87\nStack trace:\n#0 /data-ro/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\DB\Connection->connect()\n#1 /data-ro/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\DBAL\Connection->getWrappedConnection()\n#2 /data-ro/nextcloud/lib/private/DB/Connection.php(237): Doctrine\DBAL\Connection->executeQuery()\n#3 /data-ro/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\DB\Connection->executeQuery()\n#4 /data-ro/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\DBAL\Query\QueryBuilder->execute()\n#5 /data-ro/nextcloud/lib/private/AppConfig.php(344): OC\DB\QueryBuilder\QueryBuilder->execute()\n#6 /data-ro/nextcloud/lib/private/AppConfig.php(109): OC\AppConfig->loadConfigValues()\n#7 /data-ro/nextcloud/lib/pr…’
[Mon May 16 01:50:40.121831 2022] [proxy_fcgi:error] [pid 138:tid 281473239937424] [client 76.210.138.30:64933] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory in /data-ro/nextcloud/lib/private/DB/Connection.php:87\nStack trace:\n#0 /data-ro/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\DB\Connection->connect()\n#1 /data-ro/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\DBAL\Connection->getWrappedConnection()\n#2 /data-ro/nextcloud/lib/private/DB/Connection.php(237): Doctrine\DBAL\Connection->executeQuery()\n#3 /data-ro/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\DB\Connection->executeQuery()\n#4 /data-ro/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\DBAL\Query\QueryBuilder->execute()\n#5 /data-ro/nextcloud/lib/private/AppConfig.php(344): OC\DB\QueryBuilder\QueryBuilder->execute()\n#6 /data-ro/nextcloud/lib/private/AppConfig.php(109): OC\AppConfig->loadConfigValues()\n#7 /data-ro/nextcloud/lib/pr…’