I am fighting with Nextcloud Office - maybe it is only big misunderstanding.
I have Nextcloud installed on my webserver which is almost dedicated for it
Gentoo Linux, apache-2.4.54, mysql-8.0.27
CPU i3-12100 @ 3.3GHz
32GiB RAM
NVME SSDs
PHP 8.0.24 with memory limit: 512 MB (should be more?)
Nextcloud version: Nextcloud Hub 3 25.0.2
latest Firefox as client webbrowser
Everything is reasonable fast except Nextcloud Office. Whenever i am tryin open any ODS or ODT document it takes minutes.
I do not want use Docker and i cannot dedicate another server only for Collabora Office.
I would like have possibility open ODT/ODS only for occasional use in webbrowser. Nothing more.
Question is - how can i diagnose where could be problem? Htop doesn’t show any significant CPU load (less than 2% on some cores), network traffic is very minimal, almost nothing is read or written on SSD. Even browser on client PC doesn’t generate significant CPU load.
It seems to me - Nexcloud Office is waiting for something. But i have no idea why and for what.
In processes i can see this:
1338 ? S 0:00 bash -c ( /home/eventarenanextcloud/www/apps/richdocumentscode/collabora/Collabora_Online.AppImage --pidfile=/tmp/coolwsd.pid || /home/eventarenanextcloud/www/apps/richdocumentscode/collabora/Collabora_Online.AppImage --appimage-extract-and-run --pidfile=/tmp/coolwsd.pid) >/dev/null & disown
1339 ? S 0:00 \_ /bin/bash /tmp/.mount_CollabrYmtzq/AppRun --pidfile=/tmp/coolwsd.pid
1350 ? Sl 162:05 \_ coolwsd --config-file=/tmp/.mount_CollabrYmtzq/etc/coolwsd/coolwsd.xml --disable-cool-user-checking --port=9983 --lo-template-path=/tmp/.mount_CollabrYmtzq/opt/collaboraoffice --o:sys_template_path=/tmp/.mount_CollabrYmtzq/ --o:security.capabilities=false --o:security.seccomp=false --o:child_root_path=/tmp/coolwsd.mEaMN1nbWc/jails --o:file_server_root_path=/tmp/.mount_CollabrYmtzq/usr/share/coolwsd --o:ssl.enable=false --o:net.proxy_prefix=true --o:memproportion=50 --o:logging.file[@enable]=true --o:logging.file.property[0][@name]=path --o:logging.file.property[0]=/tmp/coolwsd.mEaMN1nbWc/coolwsd.log --o:welcome.enable=true --o:mount_jail_tree=false --o:user_interface.mode=default --o:allowed_languages=de_DE el en_GB en_US es_ES fr_FR hu it nl pt_BR pt_PT ru --pidfile=/tmp/coolwsd.pid
1352 ? S 0:20 \_ /tmp/.mount_CollabrYmtzq/usr/bin/coolforkit --systemplate=/tmp/.mount_CollabrYmtzq/ --lotemplate=/tmp/.mount_CollabrYmtzq/opt/collaboraoffice --childroot=/tmp/coolwsd.mEaMN1nbWc/jails/ --clientport=9983 --masterport=coolwsd-ajajT62p --rlimits=limit_virt_mem_mb:0;limit_stack_mem_kb:8000;limit_file_size_mb:0;limit_num_open_files:0 --version --nocaps --noseccomp --ui=default --disable-cool-user-checking
26798 ? Sl 0:00 \_ /tmp/.mount_CollabrYmtzq/usr/bin/coolforkit --systemplate=/tmp/.mount_CollabrYmtzq/ --lotemplate=/tmp/.mount_CollabrYmtzq/opt/collaboraoffice --childroot=/tmp/coolwsd.mEaMN1nbWc/jails/ --clientport=9983 --masterport=coolwsd-ajajT62p --rlimits=limit_virt_mem_mb:0;limit_stack_mem_kb:8000;limit_file_size_mb:0;limit_num_open_files:0 --version --nocaps --noseccomp --ui=default --disable-cool-user-checking
28269 ? Sl 0:01 \_ /tmp/.mount_CollabrYmtzq/usr/bin/coolforkit --systemplate=/tmp/.mount_CollabrYmtzq/ --lotemplate=/tmp/.mount_CollabrYmtzq/opt/collaboraoffice --childroot=/tmp/coolwsd.mEaMN1nbWc/jails/ --clientport=9983 --masterport=coolwsd-ajajT62p --rlimits=limit_virt_mem_mb:0;limit_stack_mem_kb:8000;limit_file_size_mb:0;limit_num_open_files:0 --version --nocaps --noseccomp --ui=default --disable-cool-user-checking
28851 ? S 0:00 \_ /tmp/.mount_CollabrYmtzq/usr/bin/coolforkit --systemplate=/tmp/.mount_CollabrYmtzq/ --lotemplate=/tmp/.mount_CollabrYmtzq/opt/collaboraoffice --childroot=/tmp/coolwsd.mEaMN1nbWc/jails/ --clientport=9983 --masterport=coolwsd-ajajT62p --rlimits=limit_virt_mem_mb:0;limit_stack_mem_kb:8000;limit_file_size_mb:0;limit_num_open_files:0 --version --nocaps --noseccomp --ui=default --disable-cool-user-checking
1344 ? Ssl 0:05 /home/eventarenanextcloud/www/apps/richdocumentscode/collabora/Collabora_Online.AppImage --pidfile=/tmp/coolwsd.pid
Several times Nextcloud frozen so only option was restart of Apache.
I even found folder /tmp/coolwsd.mEaMN1nbWc where is subfolder jails and 6.5GiB big coolwsd.log
At the end of it are many messages like this:
wsd-01350-28377 2023-01-16 17:30:29.934910 +0100 [ docbroker_02a ] WRN ToClient-344226: Tracker tileID 0:34560:15360:3840:3840:0 was dropped because of time out (9823ms). Tileprocessed mess
age did not arrive in time.| wsd/ClientSession.cpp:2037
All ODT/ODS documents, which i am experimenting with, are small and very simple. For example one page of text without any pictures or anything else. After restart of Apache document can be opened, it is still slow, mostly it tooks several seconds. But often i cannot open same document second time after it was closed. I am not sure, but maybe it is worse when i am trying open more documents in more browser tabs.
