documentserver_community icon indicating copy to clipboard operation
documentserver_community copied to clipboard

Nextcloud 18 OnlyOffice is loading forever

Open gcommit opened this issue 5 years ago • 23 comments

Hi,

i am running a Nextcloud 18 (upgraded from 17.0.0 to 18.0.0) and tried to install "onlyoffice" and "community document server" to work with it. The installation just went fine and the serviceadress is filled in automatically, which is nice. But when i want to open a file it's loading into "onlyoffice" but is showing the loading screen forever.

I had a look at the network interface in my browser and saw this:

POST https://MY-URL-DE/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/2281804892/c/670/ws2b4xun/xhr_send?t=1579701898108 500 (Internal Server Error)

Steps to reproduce

  1. Start Nextcloud 17.0.0 with S3 as primary storage
  2. Upgrade to 18.0.0
  3. Try to install and use Onlyoffice

Is there something i am missing or is this a real bug?

gcommit avatar Jan 22 '20 14:01 gcommit

Is there something interesting in your logs?

kesselb avatar Jan 22 '20 14:01 kesselb

Not really no, i just see the starting calls

gcommit avatar Jan 22 '20 14:01 gcommit

Can you try again with 0.1.3

icewind1991 avatar Jan 24 '20 14:01 icewind1991

I will. I‘ll let you know when i have tested it.

gcommit avatar Jan 25 '20 16:01 gcommit

Running new installed NC18 and get this after click on install: Es ist ein Fehler bei der Anfrage aufgetreten. Es kann nicht fortgefahren werden.

KoljaL avatar Jan 27 '20 10:01 KoljaL

What I get from clicking the document to open till I stop it manually by selecting something else in Nextcloud (in this, select the settings to see the logs..)

{"reqId":"qGSikmFOmXuiyZzOQmUi","level":0,"time":"2020-01-30T10:29:30+01:00","remoteAddr":"111.222.333.444","user":"######","app":"onlyoffice","method":"GET","url":"/index.php/apps/onlyoffice/ajax/config/6?filePath=%2FDocuments%2FAbout.odt&inframe=2","message":"Config is generated for: 6 with key 1922872674","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}
{"reqId":"zeHZfi9nNVOCGgbjdVqS","level":1,"time":"2020-01-30T10:29:32+01:00","remoteAddr":"111.222.333.444","user":"######","app":"no app in context","method":"POST","url":"/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/1922872674/c/198/dq44hdvv/xhr_send?t=1580376572764","message":"Deprecated event type for \\OCP\\Files::preWrite: Symfony\\Component\\EventDispatcher\\GenericEvent","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}
{"reqId":"zeHZfi9nNVOCGgbjdVqS","level":1,"time":"2020-01-30T10:29:32+01:00","remoteAddr":"111.222.333.444","user":"######","app":"no app in context","method":"POST","url":"/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/1922872674/c/198/dq44hdvv/xhr_send?t=1580376572764","message":"Deprecated event type for \\OCP\\Files::preCreate: Symfony\\Component\\EventDispatcher\\GenericEvent","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}
{"reqId":"zeHZfi9nNVOCGgbjdVqS","level":1,"time":"2020-01-30T10:29:33+01:00","remoteAddr":"111.222.333.444","user":"######","app":"no app in context","method":"POST","url":"/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/1922872674/c/198/dq44hdvv/xhr_send?t=1580376572764","message":"Deprecated event type for \\OCP\\Files::postWrite: Symfony\\Component\\EventDispatcher\\GenericEvent","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}
{"reqId":"zeHZfi9nNVOCGgbjdVqS","level":1,"time":"2020-01-30T10:29:33+01:00","remoteAddr":"111.222.333.444","user":"######","app":"no app in context","method":"POST","url":"/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/1922872674/c/198/dq44hdvv/xhr_send?t=1580376572764","message":"Deprecated event type for \\OCP\\Files::postCreate: Symfony\\Component\\EventDispatcher\\GenericEvent","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}
{"reqId":"zeHZfi9nNVOCGgbjdVqS","level":1,"time":"2020-01-30T10:29:33+01:00","remoteAddr":"111.222.333.444","user":"######","app":"no app in context","method":"POST","url":"/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/1922872674/c/198/dq44hdvv/xhr_send?t=1580376572764","message":"Deprecated event type for \\OCP\\Files::preWrite: Symfony\\Component\\EventDispatcher\\GenericEvent","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}
{"reqId":"zeHZfi9nNVOCGgbjdVqS","level":1,"time":"2020-01-30T10:29:33+01:00","remoteAddr":"111.222.333.444","user":"######","app":"no app in context","method":"POST","url":"/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/1922872674/c/198/dq44hdvv/xhr_send?t=1580376572764","message":"Deprecated event type for \\OCP\\Files::preCreate: Symfony\\Component\\EventDispatcher\\GenericEvent","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}
{"reqId":"zeHZfi9nNVOCGgbjdVqS","level":1,"time":"2020-01-30T10:29:33+01:00","remoteAddr":"111.222.333.444","user":"######","app":"no app in context","method":"POST","url":"/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/1922872674/c/198/dq44hdvv/xhr_send?t=1580376572764","message":"Deprecated event type for \\OCP\\Files::postWrite: Symfony\\Component\\EventDispatcher\\GenericEvent","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}
{"reqId":"zeHZfi9nNVOCGgbjdVqS","level":1,"time":"2020-01-30T10:29:33+01:00","remoteAddr":"111.222.333.444","user":"######","app":"no app in context","method":"POST","url":"/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/1922872674/c/198/dq44hdvv/xhr_send?t=1580376572764","message":"Deprecated event type for \\OCP\\Files::postCreate: Symfony\\Component\\EventDispatcher\\GenericEvent","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}
{"reqId":"zeHZfi9nNVOCGgbjdVqS","level":1,"time":"2020-01-30T10:29:33+01:00","remoteAddr":"111.222.333.444","user":"######","app":"no app in context","method":"POST","url":"/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/1922872674/c/198/dq44hdvv/xhr_send?t=1580376572764","message":"Deprecated event type for \\OCP\\Files::preWrite: Symfony\\Component\\EventDispatcher\\GenericEvent","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}
{"reqId":"zeHZfi9nNVOCGgbjdVqS","level":1,"time":"2020-01-30T10:29:33+01:00","remoteAddr":"111.222.333.444","user":"######","app":"no app in context","method":"POST","url":"/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/1922872674/c/198/dq44hdvv/xhr_send?t=1580376572764","message":"Deprecated event type for \\OCP\\Files::postWrite: Symfony\\Component\\EventDispatcher\\GenericEvent","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}
{"reqId":"zeHZfi9nNVOCGgbjdVqS","level":1,"time":"2020-01-30T10:29:33+01:00","remoteAddr":"111.222.333.444","user":"######","app":"no app in context","method":"POST","url":"/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/1922872674/c/198/dq44hdvv/xhr_send?t=1580376572764","message":"Deprecated event type for \\OCP\\Files::preWrite: Symfony\\Component\\EventDispatcher\\GenericEvent","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}
{"reqId":"zeHZfi9nNVOCGgbjdVqS","level":1,"time":"2020-01-30T10:29:33+01:00","remoteAddr":"111.222.333.444","user":"######","app":"no app in context","method":"POST","url":"/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/1922872674/c/198/dq44hdvv/xhr_send?t=1580376572764","message":"Deprecated event type for \\OCP\\Files::preCreate: Symfony\\Component\\EventDispatcher\\GenericEvent","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}
{"reqId":"zeHZfi9nNVOCGgbjdVqS","level":1,"time":"2020-01-30T10:29:33+01:00","remoteAddr":"111.222.333.444","user":"######","app":"no app in context","method":"POST","url":"/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/1922872674/c/198/dq44hdvv/xhr_send?t=1580376572764","message":"Deprecated event type for \\OCP\\Files::postWrite: Symfony\\Component\\EventDispatcher\\GenericEvent","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}
{"reqId":"zeHZfi9nNVOCGgbjdVqS","level":1,"time":"2020-01-30T10:29:33+01:00","remoteAddr":"111.222.333.444","user":"######","app":"no app in context","method":"POST","url":"/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/1922872674/c/198/dq44hdvv/xhr_send?t=1580376572764","message":"Deprecated event type for \\OCP\\Files::postCreate: Symfony\\Component\\EventDispatcher\\GenericEvent","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}
{"reqId":"zeHZfi9nNVOCGgbjdVqS","level":1,"time":"2020-01-30T10:29:33+01:00","remoteAddr":"111.222.333.444","user":"######","app":"no app in context","method":"POST","url":"/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/1922872674/c/198/dq44hdvv/xhr_send?t=1580376572764","message":"Deprecated event type for \\OCP\\Files::preWrite: Symfony\\Component\\EventDispatcher\\GenericEvent","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}
{"reqId":"zeHZfi9nNVOCGgbjdVqS","level":1,"time":"2020-01-30T10:29:33+01:00","remoteAddr":"111.222.333.444","user":"######","app":"no app in context","method":"POST","url":"/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/1922872674/c/198/dq44hdvv/xhr_send?t=1580376572764","message":"Deprecated event type for \\OCP\\Files::postWrite: Symfony\\Component\\EventDispatcher\\GenericEvent","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0","version":"18.0.0.10"}

I must have missed something....

nextcloud 18.0.0 php 7.3 debian linux 9 Linux 4.9.0-11-amd64 on x86_64

pieter-groeneweg avatar Jan 30 '20 10:01 pieter-groeneweg

"Nextcloud 18 OnlyOffice is loading forever" -> I had the same problem, and for me it seems that is has something to do with php Caching (recommended for using with Nextcloud) ... when I deactivated the Caching everything works fine

lenni-web avatar Jan 31 '20 10:01 lenni-web

I can confirm. Disabling the caching in config.php made the document open. Using APCU 'memcache.local' => '\OC\Memcache\APCu',

Though it takes some while to open. So I wouldn't say 'every thing works fine'.

re-enabling the memcache reverts to a non loading document...

pieter-groeneweg avatar Feb 06 '20 08:02 pieter-groeneweg

For me the endless loading is accompanied with requests to

https://my.domain/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/4222984543/c/info?t=1581107586475

returning 404. It just keeps doing that until it stops trying and says "the document can be viewed"... But that's not possible either

EDIT: AH, turns out for me it's related to Nextcloud hating me when it comes to the rewrites. I don't use Apache and I couldn't get rewrites to remove index.php to work at all... Now for some reason it removes index.php from this url, while

https://my.domain/index.php/apps/documentserver_community/3rdparty/onlyoffice/documentserver/doc/4222984543/c/info?t=1581107586475

works fine. But now I cant get it to use that anymore, though.

Could this be a problem of this plugin still? I don't know how the URL generation works in Nextcloud.

EDIT2: Actually not, I know this worked before... ugh the behaviour on when which URLs are created is such a big question mark to me

sinni800 avatar Feb 07 '20 20:02 sinni800

I can confirm. Disabling the caching in config.php made the document open. Using APCU 'memcache.local' => '\OC\Memcache\APCu',

Though it takes some while to open. So I wouldn't say 'every thing works fine'.

re-enabling the memcache reverts to a non loading document...

I can also confirm the same! Is there any other way you could resolve the problem?

manojknaikade avatar Feb 14 '20 10:02 manojknaikade

I was able to solve the problem by adding Redis for distributed cache

config.php looks like this now

 'memcache.local' => '\\OC\Memcache\APCu',
'memcache.distributed' => '\\OC\Memcache\Redis',
'memcache.locking' => '\\OC\Memcache\Redis',
'redis' => [
     'host' => '127.0.0.1 ::1',
     'port' => 6379,
],

manojknaikade avatar Feb 15 '20 18:02 manojknaikade

Just FYI, when using memcache.local with array cache ('memcache.local' => '\OC\Memcache\ArrayCache'), the document will also keep loading forever.

geiger-engineering avatar Mar 17 '20 09:03 geiger-engineering

I can confirm, installing, and enabling "redis" works. use these instructions. https://guides.wp-bullet.com/how-to-configure-redis-to-use-unix-socket-speed-boost/

pieter-groeneweg avatar Mar 27 '20 19:03 pieter-groeneweg

me too... my hoster seems not to provide redis it only works for me when i disable local memcache... somebody any news/workarround?

sturze avatar Apr 16 '20 09:04 sturze

Up!

Any news?

PlanetDyna avatar May 12 '20 15:05 PlanetDyna

Can confirm this. OnlyOffice is loading forever if you have the line 'memcache.local' => '\OC\Memcache\ArrayCache', in your config.php

Removing this fixes the problem of OnlyOffice not loading but is not recommended.

Any other fix in sight rather than not using ArrayCache?

Zaxooy avatar May 13 '20 23:05 Zaxooy

Actually what is causing these issues, If it's simply the memcache, wouldn't that simply already be tested by nextcloud before pushing out Nextcloud 18(Hub) ? As memcache configuration are also stated in Nextcloud's Handbook for installing and configuring, so why it's not optimized for their default configuration?

Hope it get fixes soon.

shenhong96 avatar May 20 '20 00:05 shenhong96

Hi Just wanted to post a solution that worked for me on this. i am running nextcloud via apache2 reverse proxy. i had trouble with the onlyoffice loading page timing out and going nowhere . i tried the memcache fix above but had no success. what fixed the issue for me was to add the following in my virtualhost config.

ProxyPreserveHost On

hopefully someone finds my fix useful

neiion avatar Jun 28 '20 16:06 neiion

Is there already a solution to the problem? Deactivating memcache permanently is probably not the best solution.

djurczik avatar Jul 02 '20 14:07 djurczik

Any Updates? I am still facing this issue and don't want to disable memcache as a workaround.

Emporea avatar Aug 13 '20 20:08 Emporea

I have the exact same problem. I have redis enabled and the problem can be fixed by disabling redis and enable 'memcache.local' => '\OC\Memcache\APCu',

Guess there is a general caching issue.

sebastiansterk avatar Aug 24 '20 10:08 sebastiansterk

Yeah but this only seems to be a workaround and maybe slows down my setup?

Emporea avatar Aug 24 '20 12:08 Emporea

Hi. Posting my solution on similar case. I am running nextcloud 19 on a Centos 8 VM with Apache behind an nginx proxy for ssl upstream. I was having the same issue of endless loading when opening a file with onlyoffice. Changing SELINUX settings to permissive in the NC VM and rebooting it solved the issue for me.

mayiagator avatar Oct 16 '20 03:10 mayiagator

Latest version work for Nextcloud 29

chadek avatar Jul 12 '24 11:07 chadek