Hello,
since updating my self hosted nextcloud on a Proxmox LXC i have the problem, that the nextcloud interface is very slow. So if i am logging in (via Firefox oder MS Edge) the site needs about 10 seconds to load. When I am then trying to go into the Settings the site needs about 30 seconds to load. The mysterious thing ist that if i am going to Data i am able to switch the folders and files as fast as bevore updating nextcloud.
While loading the Settings page the CPU load is about 2%. In the Security and setup warnings i have got a green hook. In addition i may have to note, that i have got some errors in the log. But i think they are caused by shutting off my container in the night for doing some backups.
I hope you can help!
regards
Bastian
[/details]
Nextcloud version _(eg, 20.0.5)_: `23.0.0`
Operating system and version _(eg, Ubuntu 20.04)_: `Ubuntu 20.04.3 `
Apache or nginx version _(eg, Apache 2.4.25)_: `Apache 2.4.41`
PHP version _(eg, 7.4)_: `7.4.3`
memory_limit at php.ini: 5096 MB
The issue you are facing:
Is this the first time you've seen this error? _(Y/N)_:Y
Steps to replicate it:
1. Go to the dashboard
2. Got to settings -> setting page need to load for 30 seconds
The output of your Nextcloud log in **Admin > Logging**:
{"reqId":"PJlk17DVvAExsaoxxUEc","level":3,"time":"2021-10-22T16:27:02+02:00","remoteAddr":"192.168.178.33","user":"bastian","app":"PHP","method":"GET","url":"/index.php/apps/logreader/poll?lastReqId=QShFEfEmBjhhfCXTZofO","message":"Trying to access array offset on value of type null at /var/www/nextcloud/apps/logreader/lib/Controller/LogController.php#95","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0","version":"22.2.0.2","exception":{"Exception":"Error","Message":"Trying to access array offse>
{"reqId":"w0Yq8w2fmDmK4Ftm4eqB","level":2,"time":"2021-10-22T16:30:50+02:00","remoteAddr":"192.168.178.33","user":"--","app":"no app in context","method":"POST","url":"/index.php/login","message":"Login failed: bastian (Remote IP: 192.168.178.33)","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0","version":"22.2.0.2"}
{"reqId":"IxIkDe2mJMSbXIbvBQEu","level":2,"time":"2021-10-22T16:30:54+02:00","remoteAddr":"192.168.178.33","user":"--","app":"no app in context","method":"POST","url":"/index.php/login","message":"Login failed: bastian (Remote IP: 192.168.178.33)","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0","version":"22.2.0.2"}
{"reqId":"MokGkIpbmmqk2EizZub7","level":2,"time":"2021-10-22T16:30:58+02:00","remoteAddr":"192.168.178.33","user":"--","app":"no app in context","method":"POST","url":"/index.php/login","message":"Login failed: bastian (Remote IP: 192.168.178.33)","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0","version":"22.2.0.2"}
{"reqId":"Bx49gsCoAHDfMNEeNqO7","level":2,"time":"2021-10-22T16:37:08+02:00","remoteAddr":"192.168.178.33","user":"--","app":"no app in context","method":"POST","url":"/index.php/login","message":"Login failed: bastian (Remote IP: 192.168.178.33)","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0","version":"22.2.0.2"}
{"reqId":"35g9U33nir3XbMfUFAXA","level":3,"time":"2021-10-22T20:03:39+02:00","remoteAddr":"192.168.178.40","user":"bastian","app":"index","method":"GET","url":"/index.php/core/preview.png?file=Photos/2021/10/21-10-01%2013-55-48%206125.jpg&x=1024&y=1024&a=1&mode=cover","message":"Could not create folder","userAgent":"Mozilla/5.0 (iOS) Nextcloud-iOS/4.0.6","version":"22.2.0.2","exception":{"Exception":"OCP\\Files\\NotPermittedException","Message":"Could not create folder","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/private/Files/AppDa>
{"reqId":"XhN5Ld4mnaudnFDbxlqG","level":3,"time":"2021-10-22T20:03:39+02:00","remoteAddr":"192.168.178.40","user":"bastian","app":"index","method":"GET","url":"/index.php/core/preview.png?file=Photos/2021/10/21-10-01%2012-21-40%206119.jpg&x=1024&y=1024&a=1&mode=cover","message":"Could not create folder","userAgent":"Mozilla/5.0 (iOS) Nextcloud-iOS/4.0.6","version":"22.2.0.2","exception":{"Exception":"OCP\\Files\\NotPermittedException","Message":"Could not create folder","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/private/Files/AppDa>
{"reqId":"HococKKBEA2Zpb5kBKFj","level":3,"time":"2021-10-22T20:03:39+02:00","remoteAddr":"192.168.178.40","user":"bastian","app":"index","method":"GET","url":"/index.php/core/preview.png?file=Photos/2021/09/21-09-30%2010-48-21%206062.jpg&x=1024&y=1024&a=1&mode=cover","message":"Could not create folder","userAgent":"Mozilla/5.0 (iOS) Nextcloud-iOS/4.0.6","version":"22.2.0.2","exception":{"Exception":"OCP\\Files\\NotPermittedException","Message":"Could not create folder","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/private/Files/AppDa>
{"reqId":"LRHWHEtO6bpmLUJcwnVP","level":3,"time":"2021-10-22T20:03:49+02:00","remoteAddr":"192.168.178.40","user":"bastian","app":"no app in context","method":"PUT","url":"/remote.php/webdav/Photos/2021/10/21-10-21%2012-28-03%206213.jpg","message":"Expected filesize of 3636865 bytes but read (from Nextcloud client) and wrote (to Nextcloud storage) 835584 bytes. Could either be a network problem on the sending side or a problem writing to the storage on the server side.","userAgent":"Mozilla/5.0 (iOS) Nextcloud-iOS/4.0.6","version":"22.2.0>
{"reqId":"pEdHqzOpijzWGX0XW5LW","level":3,"time":"2021-10-22T20:03:49+02:00","remoteAddr":"192.168.178.40","user":"bastian","app":"no app in context","method":"PUT","url":"/remote.php/webdav/Photos/2021/10/21-10-20%2019-58-36%206212.jpg","message":"Expected filesize of 7795526 bytes but read (from Nextcloud client) and wrote (to Nextcloud storage) 1130496 bytes. Could either be a network problem on the sending side or a problem writing to the storage on the server side.","userAgent":"Mozilla/5.0 (iOS) Nextcloud-iOS/4.0.6","version":"22.2.>
{"reqId":"rOekeSbLmyRArDsFKNCH","level":3,"time":"2021-10-22T20:03:49+02:00","remoteAddr":"192.168.178.40","user":"bastian","app":"no app in context","method":"PUT","url":"/remote.php/webdav/Photos/2021/10/21-10-21%2012-43-47%206214.jpg","message":"Expected filesize of 7676129 bytes but read (from Nextcloud client) and wrote (to Nextcloud storage) 1064960 bytes. Could either be a network problem on the sending side or a problem writing to the storage on the server side.","userAgent":"Mozilla/5.0 (iOS) Nextcloud-iOS/4.0.6","version":"22.2.>
{"reqId":"vExQTPdjxdQxJDXfvJa7","level":3,"time":"2021-10-22T20:03:49+02:00","remoteAddr":"192.168.178.40","user":"bastian","app":"no app in context","method":"PUT","url":"/remote.php/webdav/Photos/2021/10/21-10-21%2012-44-01%206215.jpg","message":"Expected filesize of 5350853 bytes but read (from Nextcloud client) and wrote (to Nextcloud storage) 1048576 bytes. Could either be a network problem on the sending side or a problem writing to the storage on the server side.","userAgent":"Mozilla/5.0 (iOS) Nextcloud-iOS/4.0.6","version":"22.2.>
{"reqId":"n1Gt7eNeGNzGC6TUFTlj","level":3,"time":"2021-10-23T00:00:04+02:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","userAgent":"--","version":"22.2.0.2","exception":{"Exception":"Doctrine\\DBAL\\Exception\\ConnectionLost","Message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":2006,"Trace":[{"file":"/var/www/nextcloud/3>
{"reqId":"Htqr95nkkWMeErUAqUfB","level":3,"time":"2021-10-24T00:00:03+02:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","userAgent":"--","version":"22.2.0.2","exception":{"Exception":"Doctrine\\DBAL\\Exception\\ConnectionLost","Message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":2006,"Trace":[{"file":"/var/www/nextcloud/3>
{"reqId":"HKXq2ppQCOnB5QJMocbZ","level":3,"time":"2021-10-25T00:00:03+02:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","userAgent":"--","version":"22.2.0.2","exception":{"Exception":"Doctrine\\DBAL\\Exception\\ConnectionLost","Message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":2006,"Trace":[{"file":"/var/www/nextcloud/3>
{"reqId":"nW71VLl83BSegnrXdrtj","level":3,"time":"2021-10-26T00:00:04+02:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","userAgent":"--","version":"22.2.0.2","exception":{"Exception":"Doctrine\\DBAL\\Exception\\ConnectionLost","Message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":2006,"Trace":[{"file":"/var/www/nextcloud/3>
{"reqId":"zP3GoS9OFjwgT9a8nQIr","level":3,"time":"2021-10-27T00:00:03+02:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"An exception occurred while executing a query: SQLSTATE[08S01]: Communication link failure: 1053 Server shutdown in progress","userAgent":"--","version":"22.2.0.2","exception":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing a query: SQLSTATE[08S01]: Communication link failure: 1053 Server shutdown in progress","Code":1053,"Trace":[>
{"reqId":"0pfi4WxKLl2Q4sQP4xZ6","level":3,"time":"2021-10-28T00:00:03+02:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","userAgent":"--","version":"22.2.0.2","exception":{"Exception":"Doctrine\\DBAL\\Exception\\ConnectionLost","Message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":2006,"Trace":[{"file":"/var/www/nextcloud/3>
{"reqId":"MnoOpzCluxQWNnTeSRSO","level":3,"time":"2021-10-29T00:00:04+02:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":"Error while running background job (class: OCA\\Files\\BackgroundJob\\DeleteOrphanedItems, arguments: )","userAgent":"--","version":"22.2.0.2","exception":{"Exception":"Doctrine\\DBAL\\Exception\\ConnectionLost","Message":"An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","Code":2006,"Trace":[{"file":"/var/www/nextcloud/3rdparty>
{"reqId":"MnoOpzCluxQWNnTeSRSO","level":3,"time":"2021-10-29T00:00:04+02:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory","userAgent":"--","version":"22.2.0.2","exception":{"Exception":"Doctrine\\DBAL\\Exception","Message":"Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory","Code":2002,"Trace":[{"file":"/var/www/nextclo>
The output of your config.php file in `/path/to/nextcloud` (make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'instanceid' => 'xxxxxxxxxxxxxxxxx',
'passwordsalt' => 'xxxxxxxxxxxxxxxxx',
'secret' => 'xxxxxxxxxxxxxxxxx',
'trusted_domains' =>
array (
0 => 'xxxxxxxxxxxxxxxxx',
1 => 'xxxxxxxxxxxxxxxxx.de',
),
'datadirectory' => '/home/data/',
'dbtype' => 'mysql',
'version' => '23.0.0.10',
'overwrite.cli.url' => 'http://xxxxxxxxxxxxxxxxx/nextcloud',
'dbname' => 'nextcloud',
'dbhost' => 'localhost',
'dbport' => '',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => 'bastian',
'dbpassword' => 'xxxxxxxxxxxxxxxxx',
'installed' => true,
'maintenance' => false,
'default_phone_region' => 'DE',
'theme' => '',
'loglevel' => 2,
'memcache.local' => '\\OC\\Memcache\\APCu',
'filelocking.enabled' => 'true',
'memcache.locking' => '\\OC\\Memcache\\Redis',
'redis' =>
array (
'host' => '127.0.0.1',
'port' => xxxxxxxxxxxxxxxxx,
'password' => 'xxxxxxxxxxxxxxxxx',
'timeout' => 0.0,
),
'updater.release.channel' => 'stable',
'log_type' => 'file',
'logtimezone' => 'Europe/Berlin',
'logfile' => '/var/log/nextcloud.log',
'syslog_tag' => 'Nextcloud',
'mail_smtpmode' => 'smtp',
'mail_smtpsecure' => 'ssl',
'mail_sendmailmode' => 'smtp',
'mail_from_address' => 'mail',
'mail_domain' => 'xxxxxxxxxxxxxxxxx.de',
'mail_smtpauthtype' => 'LOGIN',
'mail_smtphost' => 'xxxxxxxxxxxxxxxxx.de',
'mail_smtpport' => 'xxxxxxxxxxxxxxxxx',
'mail_smtpauth' => 1,
'mail_smtpname' => 'xxxxxxxxxxxxxxxxx.de',
'mail_smtppassword' => 'xxxxxxxxxxxxxxxxx',
);
The output of your Apache/nginx/system log in `/var/log/____`:
[Tue Jan 04 00:00:02.161066 2022] [mpm_prefork:notice] [pid 288] AH00163: Apache/2.4.41 (Ubuntu) OpenSSL/1.1.1f configured -- resuming normal operations
[Tue Jan 04 00:00:02.161095 2022] [core:notice] [pid 288] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jan 04 07:45:30.329617 2022] [mpm_prefork:notice] [pid 288] AH00171: Graceful restart requested, doing restart
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1. Set the 'ServerName' directive globally to suppress this message
[Tue Jan 04 07:45:30.372172 2022] [mpm_prefork:notice] [pid 288] AH00163: Apache/2.4.41 (Ubuntu) OpenSSL/1.1.1f configured -- resuming normal operations
[Tue Jan 04 07:45:30.372190 2022] [core:notice] [pid 288] AH00094: Command line: '/usr/sbin/apache2'
[Tue Jan 04 07:45:34.823985 2022] [mpm_prefork:notice] [pid 288] AH00171: Graceful restart requested, doing restart
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1. Set the 'ServerName' directive globally to suppress this message
[Tue Jan 04 07:45:34.862579 2022] [mpm_prefork:notice] [pid 288] AH00163: Apache/2.4.41 (Ubuntu) OpenSSL/1.1.1f configured -- resuming normal operations
[Tue Jan 04 07:45:34.862598 2022] [core:notice] [pid 288] AH00094: Command line: '/usr/sbin/apache2'