MD and TXT files opens very slowly

SuziQ407 · December 29, 2022, 7:13pm

Greetings,

Nextcloud version (eg, 20.0.5): 24.0.8.2
Operating system and version (eg, Ubuntu 20.04): Ubuntu Server 20.04.5 LTS
Apache or nginx version (eg, Apache 2.4.25): Apache 2.4.41
PHP version (eg, 7.4): 8.0.24

The issue you are facing:

I have two NC installations on the same Ubuntu server, same Apache version, same PHP version, both with LetsEncrypt certificates and same NC config.php (only domain and directories are different of course).
Opening MD and TXT files on the first installation (NC-1) happens within one second. Wonderful!
However, opening such files on the second installation (NC-2) takes about 30 seconds.
If I copy MD/TXT files from NC-2 to NC-1 they also open within 1 second.

I am at a loss as to why this is so.
There are no entries in the NC log.

Does anyone have any idea what this could be due to?

Is this the first time you’ve seen this error? (Y/N): NO, facing that since months!

Steps to replicate it: → As described above.

The output of your Nextcloud log in Admin > Logging:

Fehler	text	OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '550430' for key 'PRIMARY'	
2022-12-29T17:41:27+0100
Fehler	index	OCP\Files\NotFoundException: File does not exist	
2022-12-20T22:54:54+0100
Fehler	PHP	Error: file_get_contents(/data/www/abge-cloud/data/appdata_oc4of1xpnsi0/css/icons/icons-list.template): Failed to open stream: No such file or directory at /var/www/abge-cloud/lib/private/Files/Storage/Local.php#294	
2022-12-20T22:54:54+0100
Fehler	text	OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '550430' for key 'PRIMARY'	
2022-12-20T20:29:38+0100
Fehler	text	OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '550430' for key 'PRIMARY'	
2022-12-20T20:29:32+0100
Fehler	PHP	Error: Undefined variable $folder at /var/www/abge-cloud/apps/notes/lib/Service/NoteUtil.php#154	
2022-12-12T14:02:37+0100
Fehler	PHP	Error: Undefined variable $folder at /var/www/abge-cloud/apps/notes/lib/Service/NoteUtil.php#154	
2022-12-12T14:02:01+0100
Warnung	no app in context	Login failed: ArnoSommer (Remote IP: 84.115.211.222)	
2022-12-12T00:34:14+0100
Fehler	text	OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '545101' for key 'PRIMARY'	
2022-12-10T22:08:27+0100
Fehler	text	OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '545113' for key 'PRIMARY'	
2022-12-10T22:07:41+0100
Fehler	no app in context	Sabre\DAV\Exception\BadRequest: Erwartete Dateigröße von 314756 bytes, aber 314754 bytes gelesen (vom Nextcloud-Client) und geschrieben (in den Nextcloud-Speicher). Dies kann entweder ein Netzwerkproblem auf der sendenden Seite oder ein Problem beim Schreiben in den Speicher auf der Serverseite sein.	
2022-12-10T20:41:11+0100
Fehler	PHP	Error: Undefined variable $folder at /var/www/abge-cloud/apps/notes/lib/Service/NoteUtil.php#154

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'instanceid' => 'oc4of1xpnsi0',
  'passwordsalt' => 'HySRMOe5YXXXXXXXXXXX3RQfqwQu7',
  'secret' => 'ulU7Bet95VkuVYYYYYYYYYYYY2xEDj1Jaww3BgmwMkk',
  'trusted_domains' => 
  array (
    0 => 'localhost',
    1 => 'cloud.DOMAIN.com',
  ),
  'datadirectory' => '/data/www/my-cloud/data',
  'auto_logout' => false,
  'dbtype' => 'mysql',
  'version' => '24.0.8.2',
  'overwrite.cli.url' => 'https://cloud.DOMAIN.com',
  'dbname' => 'my-cloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'oc_admin',
  'dbpassword' => 'JTN2NqKyZZZZZZZZZZZZZZT9Ormf',
  'defaultapp' => 'files',
  'default_language' => 'de',
  'filelocking.enabled' => true,
  'filesystem_check_changes' => 1,
  'installed' => true,
  'loglevel' => 2,
  'mail_smtpmode' => 'smtp',
  'mail_smtpsecure' => 'ssl',
  'mail_sendmailmode' => 'smtp',
  'mail_from_address' => 'Admin',
  'mail_domain' => 'DOMAIN.com',
  'mail_smtpauthtype' => 'LOGIN',
  'mail_smtpauth' => 1,
  'mail_smtphost' => 'smtp.DOMAIN.com',
  'mail_smtpport' => '465',
  'mail_smtpname' => 'admin',
  'mail_smtppassword' => '<PASSWORD>',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'maintenance' => false,
  'skeletondirectory' => '/data/www/my-cloud/data/skeleton',
  'theme' => '',
  'app_install_overwrite' => 
  array (
    0 => 'apporder',
    1 => 'group_everyone',
  ),

);

The output of your Apache/nginx/system log in /var/log/____:

91.141.44.207 - Suzi.Q [29/Dec/2022:19:47:59 +0100] "GET /ocs/v2.php/apps/user_status/api/v1/user_status?format=json HTTP/1.1" 200 5778 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:47:59 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications?format=json HTTP/1.1" 304 5056 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:47:59 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-AGs HTTP/1.1" 207 1191 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:48:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Bilder%20und%20-Videos HTTP/1.1" 207 1192 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:48:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Dokumente HTTP/1.1" 207 1181 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:48:01 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-intern HTTP/1.1" 207 1196 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:48:01 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Uploads HTTP/1.1" 207 1180 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - - [29/Dec/2022:19:48:07 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 5582 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:47:49 +0100] "GET /index.php/apps/logreader/poll?lastReqId=yoEu0Q5ZDfcbJFed47gz HTTP/1.1" 200 896 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:48:19 +0100] "-" 408 4746 "-" "-"
91.141.44.207 - - [29/Dec/2022:19:48:09 +0100] "GET /index.php/apps/logreader/poll?lastReqId=yoEu0Q5ZDfcbJFed47gz HTTP/1.1" 200 896 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:48:29 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-AGs HTTP/1.1" 207 5938 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:48:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Bilder%20und%20-Videos HTTP/1.1" 207 1192 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:48:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Dokumente HTTP/1.1" 207 1181 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:48:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-intern HTTP/1.1" 207 1196 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:48:31 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Uploads HTTP/1.1" 207 1180 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - - [29/Dec/2022:19:48:37 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 5582 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:48:29 +0100] "GET /index.php/apps/logreader/poll?lastReqId=yoEu0Q5ZDfcbJFed47gz HTTP/1.1" 200 896 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:48:59 +0100] "GET /ocs/v2.php/apps/user_status/api/v1/user_status?format=json HTTP/1.1" 200 5778 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:48:59 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications?format=json HTTP/1.1" 304 5056 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:48:59 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-AGs HTTP/1.1" 207 1191 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:49:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Bilder%20und%20-Videos HTTP/1.1" 207 1192 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:49:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Dokumente HTTP/1.1" 207 1181 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:49:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-intern HTTP/1.1" 207 1196 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:49:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Uploads HTTP/1.1" 207 1180 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - - [29/Dec/2022:19:49:07 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 5582 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:48:49 +0100] "GET /index.php/apps/logreader/poll?lastReqId=yoEu0Q5ZDfcbJFed47gz HTTP/1.1" 200 896 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:49:19 +0100] "-" 408 4746 "-" "-"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:49:29 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-AGs HTTP/1.1" 207 5938 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - - [29/Dec/2022:19:49:09 +0100] "GET /index.php/apps/logreader/poll?lastReqId=yoEu0Q5ZDfcbJFed47gz HTTP/1.1" 200 896 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:49:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Bilder%20und%20-Videos HTTP/1.1" 207 1192 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:49:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Dokumente HTTP/1.1" 207 1181 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:49:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-intern HTTP/1.1" 207 1196 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:49:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Uploads HTTP/1.1" 207 1180 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - - [29/Dec/2022:19:49:37 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 5582 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:49:30 +0100] "GET /index.php/apps/logreader/poll?lastReqId=yoEu0Q5ZDfcbJFed47gz HTTP/1.1" 200 896 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:49:59 +0100] "GET /ocs/v2.php/apps/user_status/api/v1/user_status?format=json HTTP/1.1" 200 5778 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:49:59 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications?format=json HTTP/1.1" 304 5056 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:49:59 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-AGs HTTP/1.1" 207 1191 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:50:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Bilder%20und%20-Videos HTTP/1.1" 207 1192 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:50:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Dokumente HTTP/1.1" 207 1181 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:50:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-intern HTTP/1.1" 207 1196 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:50:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Uploads HTTP/1.1" 207 1180 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - - [29/Dec/2022:19:50:07 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 5582 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:49:50 +0100] "GET /index.php/apps/logreader/poll?lastReqId=yoEu0Q5ZDfcbJFed47gz HTTP/1.1" 200 896 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:50:19 +0100] "-" 408 4746 "-" "-"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:50:29 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-AGs HTTP/1.1" 207 5938 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:50:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Bilder%20und%20-Videos HTTP/1.1" 207 1192 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:50:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Dokumente HTTP/1.1" 207 1181 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:50:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-intern HTTP/1.1" 207 1196 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:50:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Uploads HTTP/1.1" 207 1180 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - - [29/Dec/2022:19:50:10 +0100] "GET /index.php/apps/logreader/poll?lastReqId=yoEu0Q5ZDfcbJFed47gz HTTP/1.1" 200 896 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:50:37 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 5582 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:50:31 +0100] "GET /index.php/apps/logreader/poll?lastReqId=yoEu0Q5ZDfcbJFed47gz HTTP/1.1" 200 896 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:50:59 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications?format=json HTTP/1.1" 304 5056 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:50:59 +0100] "GET /ocs/v2.php/apps/user_status/api/v1/user_status?format=json HTTP/1.1" 200 5778 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:50:59 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-AGs HTTP/1.1" 207 5938 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:51:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Bilder%20und%20-Videos HTTP/1.1" 207 1192 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:51:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Dokumente HTTP/1.1" 207 1181 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:51:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-intern HTTP/1.1" 207 1196 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:51:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Uploads HTTP/1.1" 207 1180 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - - [29/Dec/2022:19:51:07 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 5582 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:50:51 +0100] "GET /index.php/apps/logreader/poll?lastReqId=yoEu0Q5ZDfcbJFed47gz HTTP/1.1" 200 896 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:51:19 +0100] "-" 408 4743 "-" "-"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:51:29 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-AGs HTTP/1.1" 207 5938 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:51:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Bilder%20und%20-Videos HTTP/1.1" 207 1192 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:51:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Dokumente HTTP/1.1" 207 1181 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:51:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-intern HTTP/1.1" 207 1196 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:51:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Uploads HTTP/1.1" 207 1180 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - - [29/Dec/2022:19:51:11 +0100] "GET /index.php/apps/logreader/poll?lastReqId=yoEu0Q5ZDfcbJFed47gz HTTP/1.1" 200 896 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:51:37 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 5582 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:51:31 +0100] "GET /index.php/apps/logreader/poll?lastReqId=yoEu0Q5ZDfcbJFed47gz HTTP/1.1" 200 896 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:51:59 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications?format=json HTTP/1.1" 304 5056 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:51:59 +0100] "GET /ocs/v2.php/apps/user_status/api/v1/user_status?format=json HTTP/1.1" 200 5779 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:51:59 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-AGs HTTP/1.1" 207 1191 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:52:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Bilder%20und%20-Videos HTTP/1.1" 207 1192 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:52:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Dokumente HTTP/1.1" 207 1181 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:52:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-intern HTTP/1.1" 207 1196 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:52:00 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Uploads HTTP/1.1" 207 1180 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - - [29/Dec/2022:19:52:06 +0100] "PUT /index.php/apps/user_status/heartbeat HTTP/1.1" 200 6269 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:52:07 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 309 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:51:51 +0100] "GET /index.php/apps/logreader/poll?lastReqId=yoEu0Q5ZDfcbJFed47gz HTTP/1.1" 200 896 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:52:20 +0100] "-" 408 4746 "-" "-"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:52:29 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-AGs HTTP/1.1" 207 5938 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:52:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Bilder%20und%20-Videos HTTP/1.1" 207 1192 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:52:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Dokumente HTTP/1.1" 207 1181 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:52:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-intern HTTP/1.1" 207 1196 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:52:30 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Uploads HTTP/1.1" 207 1180 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - - [29/Dec/2022:19:52:11 +0100] "GET /index.php/apps/logreader/poll?lastReqId=yoEu0Q5ZDfcbJFed47gz HTTP/1.1" 200 896 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:52:38 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 5582 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:52:31 +0100] "GET /index.php/apps/logreader/poll?lastReqId=yoEu0Q5ZDfcbJFed47gz HTTP/1.1" 200 896 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:52:59 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications?format=json HTTP/1.1" 304 5056 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:52:59 +0100] "GET /ocs/v2.php/apps/user_status/api/v1/user_status?format=json HTTP/1.1" 200 5779 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:52:59 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-AGs HTTP/1.1" 207 1191 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:53:01 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Bilder%20und%20-Videos HTTP/1.1" 207 1192 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:53:01 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Dokumente HTTP/1.1" 207 1181 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:53:01 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-intern HTTP/1.1" 207 1196 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - Suzi.Q [29/Dec/2022:19:53:01 +0100] "PROPFIND /remote.php/dav/files/Suzi.Q/MY-Uploads HTTP/1.1" 207 1180 "-" "Mozilla/5.0 (Linux) mirall/3.6.4 (build 12825) (Nextcloud, linuxmint-5.15.0-56-generic ClientArchitecture: x86_64 OsArchitecture: x86_64)"
91.141.44.207 - - [29/Dec/2022:19:53:08 +0100] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 5582 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:52:52 +0100] "GET /index.php/apps/logreader/poll?lastReqId=yoEu0Q5ZDfcbJFed47gz HTTP/1.1" 200 896 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0"
91.141.44.207 - - [29/Dec/2022:19:53:20 +0100] "-" 408 4746 "-" "-"

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.

root@www2:/var/www# cat /var/log/apache2/my-cloud-error.log
[Thu Dec 29 07:14:30.634336 2022] [php:error] [pid 2363804] [client 164.92.120.31:42774] script '/var/www/my-cloud/system_api.php' not found or unable to stat
root@www2:/var/www# cat /var/log/apache2/my-cloud-error.log.1
[Thu Dec 29 01:57:18.555423 2022] [php:error] [pid 2362145] [client 109.234.164.172:41130] script '/var/www/my-cloud/wp-login.php' not found or unable to stat, referer: http://cloud.akademie-bge.at/wp-login.php
root@www2:/var/www#

That’s all errors …

tflidd · January 1, 2023, 3:08pm

Instance ids also the same?

Just thinking if both use the same caches, that is probably not good so the caches should be aware these are separate instances.
Or the browser tools might give a hint what is taking 30s to load …

SuziQ407 · January 1, 2023, 3:36pm

No, of course not …
I just wanted to imply that the settings are otherwise completely identical, so two specially created installations.

But the browser tools are a good hint. Must look at how to do that. Thanks.

SuziQ407 · January 1, 2023, 4:32pm

Here is the result of the measurement with the Firefox Onboard tool.
I just opened the Nextcloud standard file “Example.md” (about 1 kB).
In the 5th line (vendors.js) the tool stops all the time, then the content of Example.md appears.

Unfortunately the screenshot (130 kB) cannot be uploaded here (upload error), therefore link to one of my cloud clients:

What I forgot to mention in my post:
Also the upload of ALL file types, even the file Example.md with 1 kB, takes about 30 seconds.
Nextcloud writes in the progress bar “a few seconds” (translated from German), but every file, no matter how small, takes about 30 seconds.

SuziQ407 · January 1, 2023, 4:38pm

I have also made the test with the NC-1. Here the upload of the Example.md took about 1 second!