After update from 11 to 12 (and now stll from 13.0.5 to 13.0.6) : Calendar loading infinitly (and php-fpm 100% CPU usage)

[werki]

Hi,
I have a similar problem with my calendar.

FF does not get an answer:
REPORT XHR https:///remote.php/dav/calendars//default%20calendar/

and the cpu is busy…

The table “oc_dav_shares” is correct.
I’ve been using calendar-app since owncloud.
Nextcloud version 11.0.3 works fine…

[MikeLupe]

Hi @werki - I’m right now on a trip to check @steffen s hint, and since his posting I had to reconfigure my nextcloud DB, killed my nextcloud VM, because I updated my cluster (another challenge), had some other infrastructure problems and was only able to restore the VM 5 mins ago… man, man

So i’ll now be able to try to add the ‘publicuri’ field to ‘oc_dav_shares’ and let you know.

edit: I will not try to add the column, as I just saw you do have that field and it still doesn’t work.

[werki]

It’s strange…
I have two calendars, one is working and the other does not work.
I can add new calendar without any problems.

[MikeLupe]

Yeah, my second “birthday” calendar works as well… but not the first, main one.

really strange

[werki]

I found this debug message:

{“reqId”:“ICgV9TItYUixHmTXZx44”,“level”:0,“time”:“2017-05-24T21:47:36+00:00”,“remoteAddr”:“12.34.56.78”,“user”:"–",“app”:“webdav”,“method”:“REPORT”,“url”:"/remote.php/dav/calendars/user/default%20calendar/",“message”:“Exception: {“Message”:“HTTP\/1.1 401 No public access to this resource., No ‘Authorization: Bearer’ header found. Either the client didn’t send one, or the server is mis-configured, No ‘Authorization: Basic’ header found. Either the client didn’t send one, or the server is misconfigured”,“Exception”:“Sabre\\DAV\\Exception\\NotAuthenticated”,“Code”:0,“Trace”:”#0 [internal function]: Sabre\\DAV\\Auth\\Plugin->beforeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#1 \/srv\/http\/nextcloud\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php(105): call_user_func_array(Array, Array)\n#2 \/srv\/http\/nextcloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(466): Sabre\\Event\\EventEmitter->emit(‘beforeMethod’, Array)\n#3 \/srv\/http\/nextcloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php(254): Sabre\\DAV\\Server->invokeMethod(Object(Sabre\\HTTP\\Request), Object(Sabre\\HTTP\\Response))\n#4 \/srv\/http\/nextcloud\/apps\/dav\/lib\/Server.php(253): Sabre\\DAV\\Server->exec()\n#5 \/srv\/http\/nextcloud\/apps\/dav\/appinfo\/v2\/remote.php(33): OCA\\DAV\\Server->exec()\n#6 \/srv\/http\/nextcloud\/remote.php(162): require_once(’\/srv\/http\/nextc…’)\n#7 {main}",“File”:"\/srv\/http\/nextcloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Auth\/Plugin.php",“Line”:168,“User”:false}",“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:53.0) Gecko/20100101 Firefox/53.0”,“version”:“12.0.0.29”}

[MikeLupe]

So maybe these issues are indeed linked:

NC12 Authentication issue with Cardav, Caldav and Sogo connector

Hi guys, I updated just now from NC 11.0.3 to NC 12. It worked without any issues. First I noticed that my Thunderbird Lightning was not able to connect no more, but I could not see any errors. The same with the SoGo connector. After that I checked on my two Android the cardav-sync as well as the caldav-sync. Both are refusing to work. Still no error, even the Nextcloud log stays empty. Then I removed on my Android test-wise the caldav account to start over. The problem I am facing is that …

[MikeLupe]

After a new attempt to upgrade 11.0.3 to 12.0.final, calendar loading still doesn’t complete and php-fpm CPU usage still goes to 100% (per calendar loading attempt).

FF Console additionally shows:
Error in parsing value for ‘top’. Declaration dropped. calendar
Error in parsing value for ‘left’. Declaration dropped. calendar

And:
“
JQMIGRATE: Migrate is installed, version 1.4.0 core.js:7:542
"Deprecation warning: use moment.updateLocale(localeName, config) to change an existing locale. moment.defineLocale(localeName, config) should only be used for creating a new locale See http://momentjs.com/guides/#/warnings/define-locale/ for more info.” core.js:1563:2834
/remote.php/dav/calendars/ncuser01/defaultalendar/
"

“/defaultalendar/” ?? for “Default Calendar”?? Is there something missing? Or is there something about a NC message, just after upgrade, for MySQL like “convert to UTF8…”?

Do you have an idea, @oparoz? thanks

[b03rg3]

The same here. After Upgrade, calendar is not working anymore. Some of the calendars working, others (shared or not) infinite spin and 100% CPU Load.
This is a serious issue for me, because nextcloud-installation is prodactiv.
Is ist possible do downgrade the installation without any loss?

[MikeLupe]

I’m not sure, if downgrading is possible without a lot of hassle…

I’m lucky to be able to create VM snapshots, before I upgrade. Additionally I’ve got nightly DB and data backup scripts. Without those I think I’d be lost.

[b03rg3]

OK, playing arround my nextcloud, this happend:

1. Backedup all my data
2. export the calendars as ics-files
3. delete all broken calendars in nc
4. create all calendars
5. try to import ics-files
6. Can’t because of non-campatible content warning in nc-importer
7. try to import from calendar-app (macos)
8. broken sync, 100% CPU
9. f*ck

[MikeLupe]

My new attempt to upgrade 11.0.3 to 12.0.x still gives the same calendar loading issues. No entries in Webui Logviewer.

Webconsole shows:

JQMIGRATE: Migrate is installed, version 1.4.0  core.js:7:542
"Deprecation warning: use moment.updateLocale(localeName, config) to change an existing locale. moment.defineLocale(localeName, config) should only be used for creating a new locale See http://momentjs.com/guides/#/warnings/define-locale/ for more info."  core.js:1563:2834
/remote.php/dav/calendars/ncuser01/defaultalendar/

Config.php is configured with respect to my reverse proxy.

Has really no one an idea what this could be?

[MikeLupe]

Please - could anyone investigate on this still existing calendar problem?

New attempt (after Debian php updates) to upgrade 11.0.3 to 12.0.x still results in the same not loading calendar.

JS Console:
“Error: Updating calendar failed app.min.js:3:23575
/remote.php/dav/calendars/ncuser01/defaultalendar/ app.min.js:2:16313”

How is “Default calendar” from Webui becoming “/defaultalendar/” in the URL??

[MikeLupe]

Are there any news about this issue? Thanks

[Hollerauer]

I opened a issue on github. Maybe this helps.

Issue: NC12.0.0 + PHP-fpm + Calender-App = 100% CPU usage

[MikeLupe]

Thanks @Hollerauer. I’m curious if the Debian constellation might be the little troublemaker.

[Hollerauer]

Original issue was closed because I posted it in the wrong repository. Sry

New Issue:

Issue: NC12.0.0 + PHP-fpm + Calender-App = 100% CPU usage

[MikeLupe]

Thank you @Hollerauer

[MikeLupe]

Something’s in the bushes…

Issue: NC12.0.0 + PHP-fpm + Calender-App = 100% CPU usage

[MikeLupe]

After updating 11.0.3 to 12.0.1RC4 the problem still exists. On https://github.com/fruux/sabre-vobject/pull/383 apearently the issue has been resolved, but I guess it’ll take some time to get this update, won’t it?

[Hollerauer]

Here is the solution for this issue posted on github

Issue: NC12.0.0 + PHP-fpm + Calender-App = 100% CPU usage