Encountering an internal server error. The above mentioned log “An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away” has been copied from /var/log/apache2/error.log. After a lot off fiddeling around and upgrading php8.1 → 8.2 to solve the issue, several restarts, etc. the logfile is empty.
No chance to upgrade NCP or NC to a newer version, because “Nextcloud is down”.
Furhter description below.
Thank you very much in advance.
Nextcloud version (eg, 20.0.5): 27.1.3.2
Operating system and version (eg, Ubuntu 20.04): Debian 11 (NextcloudPi)
Apache or nginx version (eg, Apache 2.4.25): Apache 2.4.56
PHP version (eg, 7.4): 8.2
The issue you are facing:
Is this the first time you’ve seen this error? (Y/N): Yes
Steps to replicate it:
- Try to connect via e.g. via browser
- See Internal Server Error
The output of your Nextcloud log in Admin > Logging:
> {"reqId":"343ESy9XxOm0ZeRz2oBj","level":1,"time":"2023-10-29T12:08:43+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::incompatibleAppDisabled: Disabled incompatible app: polls","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":1,"time":"2023-10-29T12:08:43+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::incompatibleAppDisabled: Disabled incompatible app: richdocuments","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":1,"time":"2023-10-29T12:08:43+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::incompatibleAppDisabled: Disabled incompatible app: tasks","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:43+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::checkAppStoreAppBefore: Checking for update of app \"activity\" in appstore","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::checkAppStoreApp: Checked for update of app \"activity\" in appstore","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::checkAppStoreAppBefore: Checking for update of app \"bruteforcesettings\" in appstore","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::checkAppStoreApp: Checked for update of app \"bruteforcesettings\" in appstore","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::checkAppStoreAppBefore: Checking for update of app \"cloud_federation_api\" in appstore","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::checkAppStoreApp: Checked for update of app \"cloud_federation_api\" in appstore","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::checkAppStoreAppBefore: Checking for update of app \"comments\" in appstore","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::checkAppStoreApp: Checked for update of app \"comments\" in appstore","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::checkAppStoreAppBefore: Checking for update of app \"contactsinteraction\" in appstore","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::checkAppStoreApp: Checked for update of app \"contactsinteraction\" in appstore","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::checkAppStoreAppBefore: Checking for update of app \"dashboard\" in appstore","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::checkAppStoreApp: Checked for update of app \"dashboard\" in appstore","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::checkAppStoreAppBefore: Checking for update of app \"dav\" in appstore","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::checkAppStoreApp: Checked for update of app \"dav\" in appstore","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::checkAppStoreAppBefore: Checking for update of app \"federatedfilesharing\" in appstore","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::checkAppStoreApp: Checked for update of app \"federatedfilesharing\" in appstore","userAgent":"--","version":"27.0.1.2","data":{"app":"updater"}}
{"reqId":"343ESy9XxOm0ZeRz2oBj","level":0,"time":"2023-10-29T12:08:44+00:00","remoteAddr":"","user":"--","app":"updater","method":"","url":"--","message":"\\OC\\Updater::chnextcloud.log
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
> <?php
$CONFIG = array (
'passwordsalt' => 'xxx',
'secret' => 'xxx',
'trusted_domains' =>
array (
0 => 'localhost',
11 => '2003:c1:af20:1800:4a85:3db4:6137:fbe5',
1 => '192.168.178.50',
5 => 'nextcloudpi.local',
7 => 'nextcloudpi',
8 => 'nextcloudpi.lan',
20 => 'xxx',
22 => 'xxx',
23 => 'xxx',
'' => 'nextcloudpi',
3 => 'nextcloudpi',
14 => 'nextcloudpi',
21 => 'xxx',
),
'datadirectory' => '/media/myCloudDrive/ncdata',
'dbtype' => 'mysql',
'version' => '27.1.3.2',
'overwrite.cli.url' => 'https://nextcloudpi/',
'dbname' => 'nextcloud',
'dbhost' => 'localhost',
'dbport' => '',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => 'ncadmin',
'dbpassword' => 'xxx',
'installed' => true,
'instanceid' => 'ocrwufnn7knt',
'memcache.local' => '\\OC\\Memcache\\Redis',
'memcache.locking' => '\\OC\\Memcache\\Redis',
'redis' =>
array (
'host' => '/var/run/redis/redis.sock',
'port' => 0,
'timeout' => 0.0,
'password' => '9eVVdr/J/8uhI4xO0b6+lyQcjwcmieahDFnjOIeU+dg=',
),
'tempdirectory' => '/media/myCloudDrive/ncdata/tmp',
'mail_smtpmode' => 'smtp',
'mail_smtpauthtype' => 'LOGIN',
'mail_from_address' => 'xxx',
'mail_domain' => 'xxx',
'preview_max_x' => '2048',
'preview_max_y' => '2048',
'jpeg_quality' => '60',
'overwriteprotocol' => 'https',
'maintenance' => false,
'logfile' => '/media/myCloudDrive/ncdata/nextcloud.log',
'loglevel' => '2',
'log_type' => 'file',
'mail_sendmailmode' => 'smtp',
'mail_smtpsecure' => 'ssl',
'mail_smtpauth' => 1,
'mail_smtphost' => 'xxx',
'mail_smtpport' => '465',
'mail_smtpname' => 'xxx',
'mail_smtppassword' => 'xxx',
'app_install_overwrite' =>
array (
0 => 'admin_notifications',
1 => 'social',
2 => 'nextcloudpi',
),
'theme' => '',
'skeletondirectory' => '',
'default_phone_region' => 'DE',
'trusted_proxies' =>
array (
11 => '127.0.0.1',
12 => '::1',
13 => 'nextcloudpi',
14 => '192.168.178.50',
),
'htaccess.RewriteBase' => '/',
);
The output of your Apache/nginx/system log in /var/log/apache2/nc-error.log
:
> [Thu Nov 30 20:57:10.533644 2023] [proxy_fcgi:error] [pid 2364] [client 79.245.22.130:52398] AH01071: Got error 'Access to the script 'redirect:/index.php/v2/notifications' has been denied (see security.limit_extensions)'
[Thu Nov 30 20:57:10.555099 2023] [proxy_fcgi:error] [pid 2364] [client 79.245.22.130:52398] AH01071: Got error 'Access to the script 'redirect:/index.php/v2/notifications' has been denied (see security.limit_extensions)'
[Thu Nov 30 20:57:10.582047 2023] [proxy_fcgi:error] [pid 2364] [client 79.245.22.130:52398] AH01071: Got error 'Access to the script 'redirect:/index.php/v2/notifications' has been denied (see security.limit_extensions)'
[Thu Nov 30 20:57:10.609676 2023] [proxy_fcgi:error] [pid 2364] [client 79.245.22.130:52398] AH01071: Got error 'Access to the script 'redirect:/index.php/v2/notifications' has been denied (see security.limit_extensions)'
[Thu Nov 30 20:57:10.634787 2023] [proxy_fcgi:error] [pid 2364] [client 79.245.22.130:52398] AH01071: Got error 'Access to the script 'redirect:/index.php/v2/notifications' has been denied (see security.limit_extensions)'
[Thu Nov 30 20:57:10.658789 2023] [proxy_fcgi:error] [pid 2364] [client 79.245.22.130:52398] AH01071: Got error 'Access to the script 'redirect:/index.php/v2/notifications' has been denied (see security.limit_extensions)'
[Thu Nov 30 20:57:10.680087 2023] [proxy_fcgi:error] [pid 2364] [client 79.245.22.130:52398] AH01071: Got error 'Access to the script 'redirect:/index.php/v2/notifications' has been denied (see security.limit_extensions)'
[Thu Nov 30 20:57:10.709305 2023] [proxy_fcgi:error] [pid 2364] [client 79.245.22.130:52398] AH01071: Got error 'Access to the script 'redirect:/index.php/v2/notifications' has been denied (see security.limit_extensions)'
[Thu Nov 30 20:57:10.728129 2023] [proxy_fcgi:error] [pid 2364] [client 79.245.22.130:52398] AH01071: Got error 'Access to the script 'redirect:/index.php/v2/notifications' has been denied (see security.limit_extensions)'
[Thu Nov 30 20:57:10.750875 2023] [proxy_fcgi:error] [pid 2364] [client 79.245.22.130:52398] AH01071: Got error 'Access to the script 'redirect:/index.php/v2/notifications' has been denied (see security.limit_extensions)'
[Thu Nov 30 21:10:06.492669 2023] [proxy_fcgi:error] [pid 2364] [client 79.245.22.130:52398] AH01071: Got error 'Access to the script 'redirect:/index.php/v2/notifications' has been denied (see security.limit_extensions)'
The output of ncp.log file in /var/log/ncp.log
:
> +++ [[ aarch64[ nc-limits ] (Thu 30 Nov 2023 09:10:25 PM CET)
+ configure
++ get_total_mem
+++ free -b
+++ sed -n 2p
+++ awk '{ print $2 }'
++ local total_mem=3968856064
++ local MAX_32BIT=4096000000
++ [[ aarch64 == \a\r\m\v\7 ]]
++ echo 3968856064
+ local TOTAL_MEM=3968856064
+ file /bin/bash
+ grep 64-bit
+ local AUTOMEM=2976642048
+ local require_fpm_restart=false
+ local CONF=/etc/php/8.1/fpm/conf.d/90-ncp.ini
++ cat /etc/php/8.1/fpm/conf.d/90-ncp.ini
+ local 'CONF_VALUE=; disable .user.ini files for performance and workaround NC update bugs
user_ini.filename =
; from Nextcloud .user.ini
upload_max_filesize=10G
post_max_size=10G
memory_limit=2976642048
mbstring.func_overload=0
always_populate_raw_post_data=-1
default_charset='\''UTF-8'\''
output_buffering=0
; slow transfers will be killed after this time
max_execution_time=3600
max_input_time=3600'
++ tmpl_php_max_memory
+++ get_total_mem
++++ free -b
++++ sed -n 2p
++++ awk '{ print $2 }'
+++ local total_mem=3968856064
+++ local MAX_32BIT=4096000000
+++ [[ aarch64 == \a\r\m\v\7 ]]
+++ echo 3968856064
++ local TOTAL_MEM=3968856064
+++ find_app_param nc-limits MEMORYLIMIT
+++ local script=nc-limits
+++ local param_id=MEMORYLIMIT
++++ basename nc-limits .sh
+++ local ncp_app=nc-limits
+++ local cfg_file=/usr/local/etc/ncp-config.d/nc-limits.cfg
++++ find_app_param_num nc-limits MEMORYLIMIT
++++ local script=nc-limits
++++ local param_id=MEMORYLIMIT
+++++ basename nc-limits .sh
++++ local ncp_app=nc-limits
++++ local cfg_file=/usr/local/etc/ncp-config.d/nc-limits.cfg
++++ [[ -f /usr/local/etc/ncp-config.d/nc-limits.cfg ]]
+++++ cat /usr/local/etc/ncp-config.d/nc-limits.cfg
++++ local 'cfg={
"id": "nc-limits",
"name": "Nc-limits",
"title": "nc-limits",
"description": "Configure system limits for NextcloudPi",
"info": "Examples: 200M or 2G. Write 0 for autoconfig",
"infotitle": "",
"params": [
{
"id": "MAXFILESIZE",
"name": "Maximum file size",
"value": "10G",
"default": "10G",
"suggest": "10G"
},
{
"id": "MEMORYLIMIT",
"name": "Memory limit",
"value": "0",
"default": "0",
"suggest": "0"
},
{
"id": "PHPTHREADS",
"name": "PHP threads",
"value": "0",
"default": "0",
"suggest": "0"
Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.
No logs available