Getting an internal server error, and mariadb seems to be down. Can’t figure out how to get it back online.
<–! Paste this in GitHub report -->
NextCloudPi diagnostics
NextCloudPi version v1.30.0
NextCloudPi image NextCloudPi_07-21-19
distribution Raspbian GNU/Linux 10 \n \l
automount yes
USB devices sda
datadir /media/myCloudDrive/ncdata
data in SD no
data filesystem btrfs
data disk usage 907G/932G
rootfs usage 4.2G/59G
swapfile /media/USBdrive/swap
dbdir /media/myCloudDrive/mysql
Nextcloud check error
HTTPD service up
PHP service up
MariaDB service down
Redis service up
Postfix service up
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 4:26
Nextcloud configuration
An unhandled exception has been thrown:
Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory in /var/www/nextcloud/lib/private/DB/Connection.php:67
Stack trace:
#0 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(889): OC\DB\Connection->connect()
#1 /var/www/nextcloud/lib/private/DB/Connection.php(194): Doctrine\DBAL\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)
#2 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(200): OC\DB\Connection->executeQuery('SELECT * FROM `...', Array, Array)
#3 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(216): Doctrine\DBAL\Query\QueryBuilder->execute()
#4 /var/www/nextcloud/lib/private/AppConfig.php(331): OC\DB\QueryBuilder\QueryBuilder->execute()
#5 /var/www/nextcloud/lib/private/AppConfig.php(109): OC\AppConfig->loadConfigValues()
#6 /var/www/nextcloud/lib/private/AppConfig.php(287): OC\AppConfig->getApps()
#7 /var/www/nextcloud/lib/private/legacy/OC_App.php(883): OC\AppConfig->getValues(false, 'installed_versi...')
#8 /var/www/nextcloud/lib/private/Server.php(663): OC_App::getAppVersions()
#9 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#10 /var/www/nextcloud/lib/private/ServerContainer.php(124): Pimple\Container->offsetGet('OC\\Memcache\\Fac...')
#11 /var/www/nextcloud/lib/private/Server.php(1701): OC\ServerContainer->query('OC\\Memcache\\Fac...')
#12 /var/www/nextcloud/lib/private/Server.php(854): OC\Server->getMemCacheFactory()
#13 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC\{closure}(Object(OC\Server))
#14 /var/www/nextcloud/lib/private/ServerContainer.php(124): Pimple\Container->offsetGet('OC\\App\\AppManag...')
#15 /var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php(163): OC\ServerContainer->query('OC\\App\\AppManag...')
#16 /var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(OC\Server))
#17 /var/www/nextcloud/lib/private/ServerContainer.php(124): Pimple\Container->offsetGet('OCP\\App\\IAppMan...')
#18 /var/www/nextcloud/lib/private/Server.php(1891): OC\ServerContainer->query('OCP\\App\\IAppMan...')
#19 /var/www/nextcloud/lib/private/legacy/OC_App.php(347): OC\Server->getAppManager()
#20 /var/www/nextcloud/lib/private/legacy/OC_App.php(114): OC_App::getEnabledApps()
#21 /var/www/nextcloud/lib/base.php(648): OC_App::loadApps(Array)
#22 /var/www/nextcloud/lib/base.php(1095): OC::init()
#23 /var/www/nextcloud/console.php(49): require_once('/var/www/nextcl...')
#24 /var/www/nextcloud/occ(11): require_once('/var/www/nextcl...')
#25 {main}
HTTPd logs
[Tue Sep 22 19:17:04.065938 2020] [authz_host:error] [pid 801:tid 2755339296] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /ncp-output.php failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:04.067181 2020] [authz_host:error] [pid 801:tid 2797343776] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:07.137389 2020] [authz_host:error] [pid 801:tid 2797343776] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:11.257243 2020] [authz_host:error] [pid 801:tid 2797343776] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /img/download.svg failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:11.257243 2020] [authz_host:error] [pid 801:tid 2788942880] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /img/delete.svg failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:11.383790 2020] [authz_host:error] [pid 801:tid 2788942880] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:16.481481 2020] [authz_host:error] [pid 801:tid 2797343776] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:16.598476 2020] [authz_host:error] [pid 801:tid 2797343776] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:16.598822 2020] [authz_host:error] [pid 801:tid 2797343776] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /index.php failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:16.702223 2020] [authz_host:error] [pid 801:tid 2797343776] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /index.php failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:18.149558 2020] [authz_host:error] [pid 801:tid 2788942880] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /js/ncp.js failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:18.149590 2020] [authz_host:error] [pid 801:tid 2797343776] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /js/minified.js failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:18.164732 2020] [authz_host:error] [pid 801:tid 2797343776] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /img/loading-small.gif failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:18.165491 2020] [authz_host:error] [pid 801:tid 2797343776] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /img/toggle.svg failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:18.172487 2020] [authz_host:error] [pid 801:tid 2797343776] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /img/defaults.svg failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:18.173162 2020] [authz_host:error] [pid 801:tid 2797343776] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /img/poweroff.svg failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:18.173838 2020] [authz_host:error] [pid 801:tid 2797343776] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /img/reboot.svg failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:18.242675 2020] [authz_host:error] [pid 801:tid 2797343776] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /ncp-output.php failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:18.300572 2020] [authz_host:error] [pid 801:tid 2788942880] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
[Tue Sep 22 19:17:18.358447 2020] [authz_host:error] [pid 801:tid 2788942880] [client 192.168.1.88:56020] AH01753: access check of 'localhost' to /ncp-launcher.php failed, reason: unable to get the remote host name
Database logs
2020-09-22 19:25:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-09-22 19:25:55 0 [Note] InnoDB: Number of pools: 1
2020-09-22 19:25:55 0 [Note] InnoDB: Using generic crc32 instructions
2020-09-22 19:25:55 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 1, chunk size = 128M
2020-09-22 19:25:55 0 [Note] InnoDB: Completed initialization of buffer pool
2020-09-22 19:25:55 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-09-22 19:25:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-09-22 19:25:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-09-22 19:25:55 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-09-22 19:25:55 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-09-22 19:25:55 0 [Note] InnoDB: Waiting for purge to start
2020-09-22 19:25:55 0 [Note] InnoDB: 10.3.23 started; log sequence number 15037575800; transaction id 17615830
2020-09-22 19:25:55 0 [Note] InnoDB: Loading buffer pool(s) from /media/myCloudDrive/mysql/ib_buffer_pool
2020-09-22 19:25:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-09-22 19:25:55 0 [Note] Recovering after a crash using tc.log
2020-09-22 19:25:55 0 [ERROR] Bad magic header in tc log
2020-09-22 19:25:55 0 [ERROR] Crash recovery failed. Either correct the problem (if it's, for example, out of memory error) and restart, or delete tc log and start mysqld with --tc-heuristic-recover={commit|rollback}
2020-09-22 19:25:55 0 [ERROR] Can't init tc log
2020-09-22 19:25:55 0 [ERROR] Aborting
Nextcloud logs
{"reqId":"X2qHvS5D5WoFYaCsNX8mEQAAAAA","level":3,"time":"2020-09-22T23:24:45+00:00","remoteAddr":"192.168.1.1","user":"--","app":"PHP","method":"PROPFIND","url":"/remote.php/dav/files/Jason/","message":"Error: Class 'OCA\\DAV\\Connector\\Sabre\\ExceptionLoggerPlugin' not found at /var/www/nextcloud/remote.php#61","userAgent":"Mozilla/5.0 (Windows) mirall/3.0.1stable-Win64 (build 20200828) (Nextcloud)","version":"19.0.2.2"}
{"reqId":"X2qHvi5D5WoFYaCsNX8mEgAAAAc","level":3,"time":"2020-09-22T23:24:46+00:00","remoteAddr":"192.168.1.1","user":"--","app":"remote","method":"GET","url":"/status.php","message":{"Exception":"Doctrine\\DBAL\\DBALException","Message":"Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory","Code":0,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":889,"function":"connect","class":"OC\\DB\\Connection","type":"->","args":[]},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":194,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT * FROM `oc_appconfig`",[],[],null]},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":200,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT * FROM `oc_appconfig`",[],[]]},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":216,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":331,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":109,"function":"loadConfigValues","class":"OC\\AppConfig","type":"->","args":[]},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":287,"function":"getApps","class":"OC\\AppConfig","type":"->","args":[]},{"file":"/var/www/nextcloud/lib/private/legacy/OC_App.php","line":883,"function":"getValues","class":"OC\\AppConfig","type":"->","args":[false,"installed_version"]},{"file":"/var/www/nextcloud/lib/private/Server.php","line":663,"function":"getAppVersions","class":"OC_App","type":"::","args":[]},{"file":"/var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php","line":118,"function":"OC\\{closure}","class":"OC\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/ServerContainer.php","line":124,"function":"offsetGet","class":"Pimple\\Container","type":"->","args":["OC\\Memcache\\Factory"]},{"file":"/var/www/nextcloud/lib/private/Server.php","line":1701,"function":"query","class":"OC\\ServerContainer","type":"->","args":["OC\\Memcache\\Factory"]},{"file":"/var/www/nextcloud/lib/private/Server.php","line":854,"function":"getMemCacheFactory","class":"OC\\Server","type":"->","args":[]},{"file":"/var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php","line":118,"function":"OC\\{closure}","class":"OC\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/ServerContainer.php","line":124,"function":"offsetGet","class":"Pimple\\Container","type":"->","args":["OC\\App\\AppManager"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":163,"function":"query","class":"OC\\ServerContainer","type":"->","args":["OC\\App\\AppManager"]},{"file":"/var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php","line":114,"function":"OC\\AppFramework\\Utility\\{closure}","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/ServerContainer.php","line":124,"function":"offsetGet","class":"Pimple\\Container","type":"->","args":["OCP\\App\\IAppManager"]},{"file":"/var/www/nextcloud/lib/private/Server.php","line":1891,"function":"query","class":"OC\\ServerContainer","type":"->","args":["OCP\\App\\IAppManager"]},{"file":"/var/www/nextcloud/lib/private/legacy/OC_App.php","line":347,"function":"getAppManager","class":"OC\\Server","type":"->","args":[]},{"file":"/var/www/nextcloud/lib/private/legacy/OC_App.php","line":114,"function":"getEnabledApps","class":"OC_App","type":"::","args":[]},{"file":"/var/www/nextcloud/lib/base.php","line":648,"function":"loadApps","class":"OC_App","type":"::","args":[["session"]]},{"file":"/var/www/nextcloud/lib/base.php","line":1095,"function":"init","class":"OC","type":"::","args":[]},{"file":"/var/www/nextcloud/status.php","line":37,"args":["/var/www/nextcloud/lib/base.php"],"function":"require_once"}],"File":"/var/www/nextcloud/lib/private/DB/Connection.php","Line":67,"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Macintosh) mirall/2.6.4stable (build 20200303) (Nextcloud)","version":"19.0.2.2"}
{"reqId":"X2qHwC5D5WoFYaCsNX8mEwAAAAY","level":3,"time":"2020-09-22T23:24:48+00:00","remoteAddr":"192.168.1.1","user":"--","app":"PHP","method":"GET","url":"/ocs/v2.php/core/navigation/apps?absolute=true&format=json","message":"Doctrine\\DBAL\\DBALException: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory at /var/www/nextcloud/lib/private/DB/Connection.php#67","userAgent":"Mozilla/5.0 (Macintosh) mirall/2.6.4stable (build 20200303) (Nextcloud)","version":"19.0.2.2"}
{"reqId":"X2qHxS5D5WoFYaCsNX8mFAAAAAs","level":3,"time":"2020-09-22T23:24:53+00:00","remoteAddr":"50.202.176.109","user":"--","app":"remote","method":"GET","url":"/status.php","message":{"Exception":"Doctrine\\DBAL\\DBALException","Message":"Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory","Code":0,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":889,"function":"connect","class":"OC\\DB\\Connection","type":"->","args":[]},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":194,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT * FROM `oc_appconfig`",[],[],null]},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":200,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT * FROM `oc_appconfig`",[],[]]},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":216,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":331,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":109,"function":"loadConfigValues","class":"OC\\AppConfig","type":"->","args":[]},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":287,"function":"getApps","class":"OC\\AppConfig","type":"->","args":[]},{"file":"/var/www/nextcloud/lib/private/legacy/OC_App.php","line":883,"function":"getValues","class":"OC\\AppConfig","type":"->","args":[false,"installed_version"]},{"file":"/var/www/nextcloud/lib/private/Server.php","line":663,"function":"getAppVersions","class":"OC_App","type":"::","args":[]},{"file":"/var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php","line":118,"function":"OC\\{closure}","class":"OC\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/ServerContainer.php","line":124,"function":"offsetGet","class":"Pimple\\Container","type":"->","args":["OC\\Memcache\\Factory"]},{"file":"/var/www/nextcloud/lib/private/Server.php","line":1701,"function":"query","class":"OC\\ServerContainer","type":"->","args":["OC\\Memcache\\Factory"]},{"file":"/var/www/nextcloud/lib/private/Server.php","line":854,"function":"getMemCacheFactory","class":"OC\\Server","type":"->","args":[]},{"file":"/var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php","line":118,"function":"OC\\{closure}","class":"OC\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/ServerContainer.php","line":124,"function":"offsetGet","class":"Pimple\\Container","type":"->","args":["OC\\App\\AppManager"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":163,"function":"query","class":"OC\\ServerContainer","type":"->","args":["OC\\App\\AppManager"]},{"file":"/var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php","line":114,"function":"OC\\AppFramework\\Utility\\{closure}","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/ServerContainer.php","line":124,"function":"offsetGet","class":"Pimple\\Container","type":"->","args":["OCP\\App\\IAppManager"]},{"file":"/var/www/nextcloud/lib/private/Server.php","line":1891,"function":"query","class":"OC\\ServerContainer","type":"->","args":["OCP\\App\\IAppManager"]},{"file":"/var/www/nextcloud/lib/private/legacy/OC_App.php","line":347,"function":"getAppManager","class":"OC\\Server","type":"->","args":[]},{"file":"/var/www/nextcloud/lib/private/legacy/OC_App.php","line":114,"function":"getEnabledApps","class":"OC_App","type":"::","args":[]},{"file":"/var/www/nextcloud/lib/base.php","line":648,"function":"loadApps","class":"OC_App","type":"::","args":[["session"]]},{"file":"/var/www/nextcloud/lib/base.php","line":1095,"function":"init","class":"OC","type":"::","args":[]},{"file":"/var/www/nextcloud/status.php","line":37,"args":["/var/www/nextcloud/lib/base.php"],"function":"require_once"}],"File":"/var/www/nextcloud/lib/private/DB/Connection.php","Line":67,"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows) mirall/3.0.1stable-Win64 (build 20200828) (Nextcloud)","version":"19.0.2.2"}
{"reqId":"X2qH2y5D5WoFYaCsNX8mFQAAAA4","level":3,"time":"2020-09-22T23:25:15+00:00","remoteAddr":"192.168.1.1","user":"--","app":"PHP","method":"PROPFIND","url":"/remote.php/dav/files/Jason/","message":"Error: Class 'OCA\\DAV\\Connector\\Sabre\\ExceptionLoggerPlugin' not found at /var/www/nextcloud/remote.php#61","userAgent":"Mozilla/5.0 (Windows) mirall/3.0.1stable-Win64 (build 20200828) (Nextcloud)","version":"19.0.2.2"}