Files operation (upload, copy, move, delete) extremly slow - also notes app

conzelmannth · August 18, 2023, 4:26pm

file operation like upload extremly slow

Sorry to hear you’re facing problems

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can

Nextcloud version (eg, 20.0.5): 26.0.5
Operating system and version (eg, Ubuntu 20.04): Linux myserver 4.4.302+ #64570 SMP Tue Jun 13 21:40:17 CST 2023 x86_64 GNU/Linux synology_apollolake_718+
Apache or nginx version (eg, Apache 2.4.25): 2.4
PHP version (eg, 7.4): 8.2.5

The issue you are facing:

Uploading even small files, renaming or deleting them takes extrem long time. The progress bar in the Web UI moves in a fraction of a second to 99%, then waits for 20+ seconds and nothing happens except displaying “ein paar sekunden” (few seconds). Finally the upload finishs successfully. Similar behavour using nextcloud notes app. When I create a new note in the web-ui it takes also unusally long until the empty note is created and I can start to write some text in it.

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

see above description

The output of your Nextcloud log in Admin > Logging:

no specific error - sometimes following warning:
[notes] Warnung: Database failed inserting Meta objects for 252 times.

GET /index.php/apps/notes/notes?pruneBefore=1692127271
from 192.xx.xx.xx1 by username at 2023-08-15T20:44:56+00:00

or this error:
[notes] Fehler: OCP\Lock\LockedException: "Notes/Neue Notiz (3).md" is locked at <<closure>>

 0. /volume1/web/nextcloud/lib/private/Files/View.php line 2085
    OC\Files\View->lockPath("/admin/files/Notes/Neue Notiz (3).md", 1, false)
 1. /volume1/web/nextcloud/lib/private/Files/View.php line 1162
    OC\Files\View->lockFile("/admin/files/Notes/Neue Notiz (3).md", 1)
 2. /volume1/web/nextcloud/lib/private/Files/View.php line 602
    OC\Files\View->basicOperation("file_get_contents", "/admin/files/Notes/Neue Notiz (3).md", ["read"])
 3. /volume1/web/nextcloud/lib/private/Files/Node/File.php line 56
    OC\Files\View->file_get_contents("/admin/files/Notes/Neue Notiz (3).md")
 4. /volume1/web/nextcloud/apps/notes/lib/Service/Note.php line 41
    OC\Files\Node\File->getContent()
 5. /volume1/web/nextcloud/apps/notes/lib/Service/MetaService.php line 188
    OCA\Notes\Service\Note->getContent()
 6. /volume1/web/nextcloud/apps/notes/lib/Service/Util.php line 26
    OCA\Notes\Service\MetaService->OCA\Notes\Service\{closure}("*** sensitive parameters replaced ***")
 7. /volume1/web/nextcloud/apps/notes/lib/Service/MetaService.php line 187
    OCA\Notes\Service\Util::retryIfLocked("*** sensitive parameters replaced ***", 3)
 8. /volume1/web/nextcloud/apps/notes/lib/Service/MetaService.php line 170
    OCA\Notes\Service\MetaService->generateContentEtag("*** sensitive parameters replaced ***")
 9. /volume1/web/nextcloud/apps/notes/lib/Service/MetaService.php line 139
    OCA\Notes\Service\MetaService->updateIfNeeded("*** sensitive parameters replaced ***")
10. /volume1/web/nextcloud/apps/notes/lib/Service/MetaService.php line 83
    OCA\Notes\Service\MetaService->createMeta("*** sensitive parameters replaced ***")
11. /volume1/web/nextcloud/apps/notes/lib/Controller/Helper.php line 78
    OCA\Notes\Service\MetaService->getAll("*** sensitive parameters replaced ***", ["*** sensitive  ... "])
12. /volume1/web/nextcloud/apps/notes/lib/Controller/NotesController.php line 74
    OCA\Notes\Controller\Helper->getNotesAndCategories(1692371738, ["etag","content"])
13. /volume1/web/nextcloud/apps/notes/lib/Service/Util.php line 26
    OCA\Notes\Controller\NotesController->OCA\Notes\Controller\{closure}("*** sensitive parameters replaced ***")
14. /volume1/web/nextcloud/apps/notes/lib/Controller/Helper.php line 140
    OCA\Notes\Service\Util::retryIfLocked("*** sensitive parameters replaced ***")
15. /volume1/web/nextcloud/apps/notes/lib/Controller/NotesController.php line 60
    OCA\Notes\Controller\Helper->handleErrorResponse("*** sensitive parameters replaced ***")
16. /volume1/web/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Notes\Controller\NotesController->index(1692371738)
17. /volume1/web/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController(["OCA\\Notes\\Co ... "], "index")
18. /volume1/web/nextcloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch(["OCA\\Notes\\Co ... "], "index")
19. /volume1/web/nextcloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main("OCA\\Notes\\Controller\\NotesController", "index", ["OC\\AppFramewo ... "], ["notes.notes.index"])
20. /volume1/web/nextcloud/lib/base.php line 1065
    OC\Route\Router->match("/apps/notes/notes")
21. /volume1/web/nextcloud/index.php line 36
    OC::handleRequest()

Caused by:

OCP\Lock\LockedException: "files/cf7da8496c353228684dbb69a48c4063"("home::admin::files/Notes/Neue Notiz (3).md") is locked at <<closure>>

 0. /volume1/web/nextcloud/lib/private/Files/Storage/Common.php line 765
    OC\Lock\DBLockingProvider->acquireLock("files/cf7da8496c353228684dbb69a48c4063", 1, "home::admin::fi ... d")
 1. /volume1/web/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php line 607
    OC\Files\Storage\Common->acquireLock("files/Notes/Neue Notiz (3).md", 1, ["OC\\Lock\\DBLockingProvider"])
 2. /volume1/web/nextcloud/lib/private/Files/Storage/Wrapper/Wrapper.php line 607
    OC\Files\Storage\Wrapper\Wrapper->acquireLock("files/Notes/Neue Notiz (3).md", 1, ["OC\\Lock\\DBLockingProvider"])
 3. /volume1/web/nextcloud/lib/private/Files/View.php line 1967
    OC\Files\Storage\Wrapper\Wrapper->acquireLock("files/Notes/Neue Notiz (3).md", 1, ["OC\\Lock\\DBLockingProvider"])
 4. /volume1/web/nextcloud/lib/private/Files/View.php line 2085
    OC\Files\View->lockPath("/admin/files/Notes/Neue Notiz (3).md", 1, false)
 5. /volume1/web/nextcloud/lib/private/Files/View.php line 1162
    OC\Files\View->lockFile("/admin/files/Notes/Neue Notiz (3).md", 1)
 6. /volume1/web/nextcloud/lib/private/Files/View.php line 602
    OC\Files\View->basicOperation("file_get_contents", "/admin/files/Notes/Neue Notiz (3).md", ["read"])
 7. /volume1/web/nextcloud/lib/private/Files/Node/File.php line 56
    OC\Files\View->file_get_contents("/admin/files/Notes/Neue Notiz (3).md")
 8. /volume1/web/nextcloud/apps/notes/lib/Service/Note.php line 41
    OC\Files\Node\File->getContent()
 9. /volume1/web/nextcloud/apps/notes/lib/Service/MetaService.php line 188
    OCA\Notes\Service\Note->getContent()
10. /volume1/web/nextcloud/apps/notes/lib/Service/Util.php line 26
    OCA\Notes\Service\MetaService->OCA\Notes\Service\{closure}("*** sensitive parameters replaced ***")
11. /volume1/web/nextcloud/apps/notes/lib/Service/MetaService.php line 187
    OCA\Notes\Service\Util::retryIfLocked("*** sensitive parameters replaced ***", 3)
12. /volume1/web/nextcloud/apps/notes/lib/Service/MetaService.php line 170
    OCA\Notes\Service\MetaService->generateContentEtag("*** sensitive parameters replaced ***")
13. /volume1/web/nextcloud/apps/notes/lib/Service/MetaService.php line 139
    OCA\Notes\Service\MetaService->updateIfNeeded("*** sensitive parameters replaced ***")
14. /volume1/web/nextcloud/apps/notes/lib/Service/MetaService.php line 83
    OCA\Notes\Service\MetaService->createMeta("*** sensitive parameters replaced ***")
15. /volume1/web/nextcloud/apps/notes/lib/Controller/Helper.php line 78
    OCA\Notes\Service\MetaService->getAll("*** sensitive parameters replaced ***", ["*** sensitive  ... "])
16. /volume1/web/nextcloud/apps/notes/lib/Controller/NotesController.php line 74
    OCA\Notes\Controller\Helper->getNotesAndCategories(1692371738, ["etag","content"])
17. /volume1/web/nextcloud/apps/notes/lib/Service/Util.php line 26
    OCA\Notes\Controller\NotesController->OCA\Notes\Controller\{closure}("*** sensitive parameters replaced ***")
18. /volume1/web/nextcloud/apps/notes/lib/Controller/Helper.php line 140
    OCA\Notes\Service\Util::retryIfLocked("*** sensitive parameters replaced ***")
19. /volume1/web/nextcloud/apps/notes/lib/Controller/NotesController.php line 60
    OCA\Notes\Controller\Helper->handleErrorResponse("*** sensitive parameters replaced ***")
20. /volume1/web/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 230
    OCA\Notes\Controller\NotesController->index(1692371738)
21. /volume1/web/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 137
    OC\AppFramework\Http\Dispatcher->executeController(["OCA\\Notes\\Co ... "], "index")
22. /volume1/web/nextcloud/lib/private/AppFramework/App.php line 183
    OC\AppFramework\Http\Dispatcher->dispatch(["OCA\\Notes\\Co ... "], "index")
23. /volume1/web/nextcloud/lib/private/Route/Router.php line 315
    OC\AppFramework\App::main("OCA\\Notes\\Controller\\NotesController", "index", ["OC\\AppFramewo ... "], ["notes.notes.index"])
24. /volume1/web/nextcloud/lib/base.php line 1065
    OC\Route\Router->match("/apps/notes/notes")
25. /volume1/web/nextcloud/index.php line 36
    OC::handleRequest()

GET /index.php/apps/notes/notes?pruneBefore=1692371738
from xx.xx.xx.xx by username at 2023-08-18T15:16:10+00:00

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

<?php
$CONFIG = array (
  'instanceid' => 'xxx',
  'passwordsalt' => 'xxx',
  'secret' => 'xxx',
  'trusted_domains' =>
  array (
    0 => 'mydomain.tld',
  ),
  'datadirectory' => '/volume1/nextcloud_data',
  'dbtype' => 'mysql',
  'version' => '26.0.5.1',
  'overwrite.cli.url' => 'https://mydomain.tld',
  'dbname' => 'db_nc',
  'dbhost' => 'localhost:3307',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nc_admin2',
  'dbpassword' => 'xxx',
  'installed' => true,
  'ldapProviderFactory' => 'OCA\\User_LDAP\\LDAPProviderFactory',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' =>
  array (
    'host' => '127.0.0.1',
    'port' => '6379',
    'timeout' => '0',
    'password' => '',
    'dbindex' => '0',
  ),
  'mail_smtpmode' => 'smtp',
  'mail_smtpsecure' => 'ssl',
  'mail_sendmailmode' => 'smtp',
  'mail_from_address' => 'myadress',
  'mail_smtphost' => 'securesmtp.t-online.de',
  'mail_smtpport' => '465',
  'mail_domain' => 't-online.de',
  'default_phone_region' => 'DE',
  'maintenance' => false,
  'tempdirectory' => '/volume1/nextcloud_data/tmp',
  'loglevel' => 2,
  'logfile' => '/var/log/nextcloud.log',
  'data-fingerprint' => 'xxxx',
  'mail_smtpauth' => 1,
  'mail_smtpname' => 'myname',
  'mail_smtppassword' => 'xxxx',
  'allow_local_remote_servers' => true,
  'app.mail.imap.timeout' => 60,
  'app.mail.smtp.timeout' => 20,
  'app.mail.sieve.timeout' => 2,
  'theme' => '',
);

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

apache log while upload of file deny-ip-list.txt with size of < 10kb:

2023-08-18T18:30:49+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:30:47 +0200] "POST /index.php/apps/text/session/sync HTTP/1.1" 200 1788 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:30:50+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:30:48 +0200] "POST /index.php/apps/text/session/push HTTP/1.1" 200 22 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:30:55+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:30:54 +0200] "POST /index.php/apps/text/session/sync HTTP/1.1" 200 1788 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:00+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:00 +0200] "POST /index.php/apps/text/session/sync HTTP/1.1" 200 1788 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:04+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:03 +0200] "POST /index.php/apps/text/session/push HTTP/1.1" 200 22 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:05+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:05 +0200] "POST /index.php/apps/text/session/sync HTTP/1.1" 200 1788 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:08+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:08 +0200] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 - "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:10+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:08 +0200] "PROPFIND /remote.php/dav/files/thomasco HTTP/1.1" 207 618 "-" "Microsoft-WebDAV-MiniRedir/10.0.19045"
2023-08-18T18:31:10+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:10 +0200] "PROPFIND /remote.php/dav/files/thomasco HTTP/1.1" 207 618 "-" "Microsoft-WebDAV-MiniRedir/10.0.19045"
2023-08-18T18:31:11+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:11 +0200] "POST /index.php/apps/text/session/sync HTTP/1.1" 200 1788 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:16+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:16 +0200] "POST /index.php/apps/text/session/sync HTTP/1.1" 200 1788 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:18+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:17 +0200] "PROPFIND /remote.php/dav/files/thomasco/ HTTP/1.1" 207 252 "-" "Mozilla/5.0 (Windows) mirall/3.4.2stable-Win64 (build 20220127) (Nextcloud, windows-10.0.19045 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
2023-08-18T18:31:21+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:21 +0200] "POST /index.php/apps/text/session/sync HTTP/1.1" 200 1788 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:21+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:18 +0200] "POST /index.php/apps/text/session/push HTTP/1.1" 200 22 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:26+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:26 +0200] "POST /index.php/apps/text/session/sync HTTP/1.1" 200 1788 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:31+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:31 +0200] "POST /index.php/apps/text/session/sync HTTP/1.1" 200 1788 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:35+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:35 +0200] "GET /index.php/apps/files/api/v1/stats HTTP/1.1" 200 152 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:35+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:34 +0200] "POST /index.php/apps/text/session/push HTTP/1.1" 200 22 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:37+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:36 +0200] "POST /index.php/apps/text/session/sync HTTP/1.1" 200 1788 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:38+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:38 +0200] "GET /ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 304 - "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:42+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:42 +0200] "POST /index.php/apps/text/session/sync HTTP/1.1" 200 1788 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:48+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:47 +0200] "PROPFIND /remote.php/dav/files/thomasco/ HTTP/1.1" 207 252 "-" "Mozilla/5.0 (Windows) mirall/3.4.2stable-Win64 (build 20220127) (Nextcloud, windows-10.0.19045 ClientArchitecture: x86_64 OsArchitecture: x86_64)"
2023-08-18T18:31:49+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:21 +0200] "PUT /remote.php/webdav/deny-ip-list.txt HTTP/1.1" 201 - "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:49+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:49 +0200] "GET /index.php/apps/files/ajax/getstoragestats HTTP/1.1" 303 - "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:50+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:49 +0200] "GET /index.php/apps/files/?fileNotFound=1 HTTP/1.1" 200 16520 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:50+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:49 +0200] "POST /index.php/apps/text/session/push HTTP/1.1" 200 22 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:50+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:47 +0200] "POST /index.php/apps/text/session/sync HTTP/1.1" 200 1788 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"
2023-08-18T18:31:50+02:00 myserver 99.99.99.99  - - [18/Aug/2023:18:31:49 +0200] "PROPFIND /remote.php/dav/files/admin/deny-ip-list.txt HTTP/1.1" 207 584 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0"

PASTE HERE


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.

PASTE HERE

ernolf · August 18, 2023, 8:45pm

Did you try to enable Transactional File locking?

I could not find

'filelocking.enabled' => true,

in your config/config.php

Hope that helps,
much luck!

conzelmannth · August 19, 2023, 6:49am

Thanks for this hint. File locking was not enabled.
I enabled it now and restartet the whole server. Unfortunately no difference in the behaviour.
Upload of a simple txt-file, size 1kb takes ~20seconds. No error in the admin-log-section.

The relevant section of config.php looks now as follows:
…
‘filelocking.enabled’ => true,
‘memcache.local’ => ‘\OC\Memcache\APCu’,
‘memcache.locking’ => ‘\OC\Memcache\Redis’,
‘redis’ =>
array (
‘host’ => ‘127.0.0.1’,
‘port’ => ‘6379’,
‘timeout’ => ‘0’,
‘password’ => ‘’,
‘dbindex’ => ‘0’,
),
…

By the way, I just found in the nextcloud manual the hint to let redis listen to a unix socket instead to a port:
https://docs.nextcloud.com/server/latest/admin_manual/configuration_files/files_locking_transactional.html

Redis and Nextcloud run on the same system, so I can try this as well.

ernolf · August 19, 2023, 8:06am

Since you are runing your Nextcloud on

Is your Nextcloud somehow dockerized or snap or any other (Synology)-appliance or is it installed on barre metal linux?

Another common source of sluggishness is the cron mode. If that is set to Ajax, it performs a cronjob on every click.

(assuming you are familiar with the use of occ and jq is installed on your system), what is the echo of:

 occ config:list core | jq '.apps.core.backgroundjobs_mode'

if it is “null”, then you should setup cron

But you can see if cron is configured in the “Basic settings”-tab of your Admin section as well.

Aditionally you could dive deeper to gain insights with the techniques I described here in an other case:

Hope this helps,
much luck!

conzelmannth · August 19, 2023, 8:19am

The nextcloud is installed on bare linux on the synology DS, no docker-installation.

I run a cron job every 5 minutes, Also no issues. In the admin-panel of nextcloud usually always “green” and nextcloud confirms, that the last cron-job run few minutes ago.

output of the occ:
admin@srvconzel1:~$ sudo -u root ./nc_tools/occ ‘config:list core’ | jq ‘.apps.core.backgroundjobs_mode’
“cron”

Thanks for refering to the document of slow performance loading pdfs:

I would exclude the browser. It’s same behavour on different systems no matter which browser (edge, firefox, safari).
But I’ll review the other topics from that document.

One additional information: I face this issue since I did a complete new installation of my synology for some reason 4 weeks ago. Before it was running perfectly with no performance issues. After the basis synology system was running again, I did a new installtion of NC, then restored my data from a backup.

ernolf · August 19, 2023, 8:33am

Did you run

occ maintenance:data-fingerprint

after restore?

ernolf

conzelmannth · August 19, 2023, 9:41am

I did. Perhaps I do it once more?

conzelmannth · August 19, 2023, 10:53am

Did once more the occ maintanance:data-fingerprint. But no difference in the behaviour.
Then I activated the Firefox developer tool with F12 and did an upload.
The result is here:

However, my knowledge to interpret the result is not enough. In the console are several warnings regarding jQuery. Any idea?

conzelmannth · September 5, 2023, 8:19pm

I found the reason for the issue and the solution. On a second plain test-installation of nextcloud, the behaviour was exactly the same. So I suspected the database and found following hint:

https://help.nextcloud.com/t/neue-synology-nc-instanz-uploadperformance-kleiner-dateien-unfassbar-schlecht/113580/9

With following setting for MariaDB in my.cnf the issue was solved:

[server]
skip-name-resolve
innodb_buffer_pool_size = 256M
innodb_buffer_pool_instances = 1
innodb_flush_log_at_trx_commit = 2
innodb_flush_log_at_timeout = 5
innodb_log_buffer_size = 32M
innodb_max_dirty_pages_pct = 75
query_cache_type = 1
query_cache_limit = 2M
query_cache_min_res_unit = 2k
query_cache_size = 16M #was 64M, tuning primer said mybe less
tmp_table_size= 64M
max_heap_table_size= 64M
slow-query-log = 1
slow-query-log-file = /var/log/mysql/slow.log
long_query_time = 1
max_connections = 250
join_buffer_size = 1M
key_buffer = 64M

[client]
default-character-set = utf8mb4

[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
transaction_isolation = READ-COMMITTED
binlog_format = ROW
innodb_large_prefix=on
innodb_file_format=barracuda
innodb_file_per_table=1
default_authentication_plugin=mysql_native_password
max_binlog_size = 134217728
expire_logs_days = 3