Nextcloud version: 23.0.4
Operating system and version: Deebian 11 (Bullseye)
Nginx version: nginx/1.21.6
PHP version: PHP 7.4.29
MySQL version: MariaDB 10.7.3
The issue you are facing:
Nextcloud stops working after some period, usually after 12-20 hours and i’m forced to reboot the vm in order to make it work again. When this issue occurs i am not able to login to MySQL or restart the service. I’ve reinstalled MariaDB by purging the config files and re-creating the database (mysqlcheck shows no errors).
Is this the first time you’ve seen this error? (Y/N): No
The output of your Nextcloud log in Admin > Logging:
[webdav] Fatal: The REQUEST_URI (/remote.php/dav/files/user//) did not end with the contents of PATH_INFO (/dav/files/user/). This server might be misconfigured.
PROPFIND /remote.php/dav/files/user//
from 192.168.1.91 by user at 2022-05-18T14:38:51+00:00
[cron] Error: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
at 2022-05-18T14:38:51+00:00
The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'instanceid' => 'x',
'passwordsalt' => 'x',
'secret' => 'x',
'trusted_domains' =>
array (
0 => 'x.com',
1 => '192.168.1.8',
2 => 'www',
3 => 'www.local',
),
'datadirectory' => '/var/www/_data/nextcloud/',
'dbtype' => 'mysql',
'version' => '23.0.4.1',
'overwrite.cli.url' => 'https://x.com',
'dbname' => 'nextcloud',
'dbhost' => 'localhost',
'loglevel' => 2,
'logfile' => '/var/log/nextcloud/nextcloud.log',
'log_rotate_size' => 5242880,
'dbport' => '3306',
'dbtableprefix' => 'oc_',
'dbuser' => 'nextcloud',
'dbpassword' => 'x',
'installed' => true,
'mail_from_address' => 'x',
'mail_smtpmode' => 'smtp',
'mail_domain' => 'x',
'mail_smtpsecure' => 'tls',
'mail_smtphost' => 'x',
'mail_smtpport' => '587',
'mail_smtpauth' => 1,
'mail_smtpname' => 'x',
'mail_smtppassword' => 'x',
'preview_libreoffice_path' => '/usr/bin/libreoffice',
'htaccess.RewriteBase' => '/',
'remember_login_cookie_lifetime' => 7776000,
'session_lifetime' => 19440000,
'simpleSignUpLink.shown' => false,
'auth.bruteforce.protection.enabled' => true,
'lost_password_link' => '#',
'default_phone_region' => 'US',
'enable_previews' => true,
'enabledPreviewProviders' =>
array (
0 => 'OC\\Preview\\Image',
1 => 'OC\\Preview\\MP3',
2 => 'OC\\Preview\\TXT',
3 => 'OC\\Preview\\PDF',
4 => 'OC\\Preview\\Movie',
5 => 'OC\\Preview\\Photoshop',
6 => 'OC\\Preview\\TIFF',
7 => 'OC\\Preview\\SVG',
8 => 'OC\\Preview\\OpenDocument',
),
'filelocking.enabled' => 'true',
'memcache.local' => '\\OC\\Memcache\\APCu',
'memcache.locking' => '\\OC\\Memcache\\Redis',
'redis' =>
array (
'host' => '/var/run/redis/redis-server.sock',
'port' => 0,
),
'maintenance' => false,
'theme' => '',
'mysql.utf8mb4' => true,
'updater.release.channel' => 'stable',
'mail_sendmailmode' => 'smtp',
'app_install_overwrite' =>
array (
0 => 'dicomviewer',
1 => 'bruteforcesettings',
2 => 'previewgenerator',
3 => 'metadata',
4 => 'camerarawpreviews',
),
);
nginx logs:
error.log
2022/05/18 16:05:08 [error] 70754#70754: *45003 upstream timed out (110: Connection timed out) while reading response header from upstream, client: 192.168.1.1, server: mydomain.com, request: "GET /apps/dashboard/ HTTP/2.0", upstream: "fastcgi://127.0.0.1:9000", host: "mydomain.com"
access.log
192.168.1.1 - - [18/May/2022:16:05:08 +0200] "GET /apps/dashboard/ HTTP/2.0" 504 569 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36"
192.168.1.1 - - [18/May/2022:16:06:08 +0200] "GET /favicon.ico HTTP/2.0" 504 569 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36"
nextcloud.log
php7.4-fpm.log
[16-May-2022 23:56:01] WARNING: [pool www] server reached pm.max_children setting (5), consider raising it
[16-May-2022 23:56:14] WARNING: [pool www] server reached pm.max_children setting (5), consider raising it
[17-May-2022 18:36:06] WARNING: [pool www] server reached pm.max_children setting (5), consider raising it
[18-May-2022 11:41:18] WARNING: [pool www] server reached pm.max_children setting (5), consider raising it
