Collabora's "Nextcloud Office" freezes Nextcloud?

[Supaiku]

Original text:

*Nextcloud slower/times out more than other apps?

I've got a Cloudron install on a home server and most apps work pretty well (both remote and on my network) but nextcloud for some reason times out more than the others - and then works sometimes.

Any tips on troubleshooting or figuring this one out?

The computer speed is fine (FX8150 with 32GB memory).

I have AT&T Fiber, so there could be some sort of networking thing, but the other apps all seem to work fine.

Accessing it directly from the computer it's on (via the domain name) is even slow.

I am also trying hardcoding the server's local IP (168.192.1.xxx) into my hosts file on the other computer and it's still not really speeding things up or making them more reliable (yet? - still making sure programs are honorings the hosts file and all...)*

Update:

I was able to fix this by disabling "Nextcloud Office", which is the Collabora solution available - but this means we can't use Collabora!
Is there a bug in there right now?

It seems that it can't connect and that cuases an exception:

[beginning of error log line clipped] Failed to fetch the Collabora capabilities endpoint: cURL error 28: Connection timed out after 45001 milliseconds (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://example./com/richdocumentscode/proxy.php?req=/hosting/capabilities","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0","version":"25.0.2.3","exception":{"Exception":"GuzzleHttp\\\\Exception\\\\ConnectException","Message":"cURL error 28: Connection timed out after 45001 milliseconds (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://example.com/richdocumentscode/proxy.php?req=/hosting/capabilities","Code":0,"Trace":[{"file":"/app/code/3rdparty/guzzlehttp/guzzle/src/Handler/CurlFactory.php","line":158,"function":"createRejection","class":"GuzzleHttp\\\\Handler\\\\CurlFactory","type":"::"},{"file":"/app/code/3rdparty/guzzlehttp/guzzle/src/Handler/CurlFactory.php","line":110,"function":"finishError","class":"GuzzleHttp\\\\Handler\\\\CurlFactory","type":"::"},{"file":"/app/code/3rdparty/guzzlehttp/guzzle/src/Handler/CurlHandler.php","line":47,"function":"finish","class":"GuzzleHttp\\\\Handler\\\\CurlFactory","type":"::"},{"file":"/app/code/lib/private/Http/Client/DnsPinMiddleware.php","line":113,"function":"__invoke","class":"GuzzleHttp\\\\Handler\\\\CurlHandler","type":"->"},{"file":"/app/code/3rdparty/guzzlehttp/guzzle/src/PrepareBodyMiddleware.php","line":35,"function":"OC\\\\Http\\\\Client\\\\{closure}","class":"OC\\\\Http\\\\Client\\\\DnsPinMiddleware","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/app/code/3rdparty/guzzlehttp/guzzle/src/Middleware.php","line":31,"function":"__invoke","class":"GuzzleHttp\\\\PrepareBodyMiddleware","type":"->"},{"file":"/app/code/3rdparty/guzzlehttp/guzzle/src/RedirectMiddleware.php","line":71,"function":"GuzzleHttp\\\\{closure}","class":"GuzzleHttp\\\\Middleware","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/app/code/3rdparty/guzzlehttp/guzzle/src/Middleware.php","line":63,"function":"__invoke","class":"GuzzleHttp\\\\RedirectMiddleware","type":"->"},{"file":"/app/code/3rdparty/guzzlehttp/guzzle/src/HandlerStack.php","line":75,"function":"GuzzleHttp\\\\{closure}","class":"GuzzleHttp\\\\Middleware","type":"::","args":["*** sensitive parameters replaced ***"]},{"file":"/app/code/3rdparty/guzzlehttp/guzzle/src/Client.php","line":331,"function":"__invoke","class":"GuzzleHttp\\\\HandlerStack","type":"->"},{"file":"/app/code/3rdparty/guzzlehttp/guzzle/src/Client.php","line":168,"function":"transfer","class":"GuzzleHttp\\\\Client","type":"->"},{"file":"/app/code/3rdparty/guzzlehttp/guzzle/src/Client.php","line":187,"function":"requestAsync","class":"GuzzleHttp\\\\Client","type":"->"},{"file":"/app/code/lib/private/Http/Client/Client.php","line":218,"function":"request","class":"GuzzleHttp\\\\Client","type":"->"},{"file":"/app/data/apps/richdocuments/lib/Service/CapabilitiesService.php","line":132,"function":"get","class":"OC\\\\Http\\\\Client\\\\Client","type":"->"},{"file":"/app/data/apps/richdocuments/lib/Service/CapabilitiesService.php","line":74,"function":"refetch","class":"OCA\\\\Richdocuments\\\\Service\\\\CapabilitiesService","type":"->"},{"file":"/app/data/apps/richdocuments/lib/AppInfo/Application.php","line":80,"function":"getCapabilities","class":"OCA\\\\Richdocuments\\\\Service\\\\CapabilitiesService","type":"->"},{"file":"/app/code/lib/private/AppFramework/Bootstrap/FunctionInjector.php","line":67,"function":"OCA\\\\Richdocuments\\\\AppInfo\\\\{closure}","class":"OCA\\\\Richdocuments\\\\AppInfo\\\\Application","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/app/code/lib/private/AppFramework/Bootstrap/BootContext.php","line":51,"function":"injectFn","class":"OC\\\\AppFramework\\\\Bootstrap\\\\FunctionInjector","type":"->"},{"file":"/app/data/apps/richdocuments/lib/AppInfo/Application.php","line":135,"function":"injectFn","class":"OC\\\\AppFramework\\\\Bootstrap\\\\BootContext","type":"->"},{"file":"/app/code/lib/private/AppFramework/Bootstrap/Coordinator.php","line":190,"function":"boot","class":"OCA\\\\Richdocuments\\\\AppInfo\\\\Application","type":"->"},{"file":"/app/code/lib/private/legacy/OC_App.php","line":208,"function":"bootApp","class":"OC\\\\AppFramework\\\\Bootstrap\\\\Coordinator","type":"->"},{"file":"/app/code/lib/private/legacy/OC_App.php","line":141,"function":"loadApp","class":"OC_App","type":"::"},{"file":"/app/code/lib/base.php","line":1027,"function":"loadApps","class":"OC_App","type":"::"},{"file":"/app/code/index.php","line":36,"function":"handleRequest","class":"OC","type":"::"}],"File":"/app/code/3rdparty/guzzlehttp/guzzle/src/Handler/CurlFactory.php","Line":210,"message":"Failed to fetch the Collabora capabilities endpoint: cURL error 28: Connection timed out after 45001 milliseconds (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://example.com/richdocumentscode/proxy.php?req=/hosting/capabilities","exception":{},"CustomMessage":"Failed to fetch the Collabora capabilities endpoint: cURL error 28: Connection timed out after 45001 milliseconds (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://example.com/richdocumentscode/proxy.php?req=/hosting/capabilities"}}

Jan 06 21:21:59 [Sat Jan 07 02:21:59.472666 2023] [php:notice] [pid 253] [client 172.18.0.1:56212] {"reqId":"0AzbYdfJw7xW7jx0rCYd","level":3,"time":"2023-01-07T02:21:59+00:00","remoteAddr":"2600:1700:4f06:6010:9cb0:ff38:69cb:41fd","user":"admin","app":"richdocuments","method":"PUT","url":"/ocs/v2.php/apps/user_status/api/v1/heartbeat?format=json","message":"Failed to fetch the Collabora capabilities endpoint: cURL error 28: Connection timed out after 45000 milliseconds (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://example.com/richdocumentscode/proxy.php?req=/hosting/capabilities","userAgent":"Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:108.0) Gecko/20100101 Firefox/108.0","vers[end of error log line clipped]

[Supaiku]

EDIT:
Note: My home server has some NAT Loopback/hairpin issues.

To get OnlyOffice working I had to host it on a seperate Cloudron instance on DO so it would access externally. I've got a new router in the mail.

I suppose this could be causing this issue?

[girish]

@Supaiku Most likely, per your original logs, it times out after 45 seconds because of network issues. Which is probably the "freeze" you were noticing.

[marcusquinn]

I've found Nextcloud Office to be super-fast and reliable with Cloudron, and given it's consistent installation across all instances, this does sound like something outside of Cloudron.

Also see this post, may or may not be relevant:

• https://forum.cloudron.io/topic/7769/speed-tip-for-nextcloud-the-temporary-files-lock-add-on-causes-significant-slowness?

[jdaviescoates]

@marcusquinn said in Collabora's "Nextcloud Office" freezes Nextcloud?:

I've found Nextcloud Office to be super-fast and reliable with Cloudron

Interesting.

Better than connecting to a separate Cloudron Collabora app? I would've presumed that was better, but perhaps not these days.

Personally I'm still connecting to a separate Cloudron OnlyOffice app as in the past Collabora was a lot slower.

[marcusquinn]

@jdaviescoates I didn't notice and significant difference between Nextcloud Office and the separate Collabora Online (CODE) app, just that using the build-in app is a little simpler for system admin, and I suppose has more eyes on maintaining.