[Bug]: Failure on subscribing to a public Google calendar

[escoand]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

When using the calendar app to add a public Google calendar i get errors. Furthermore only a small selection of the events are shown.

An other Google calender is working without problems.

Steps to reproduce

Happening with every try with my specific calendar.

Expected behavior

This calendar is working like the others.

Nextcloud Server version

30

Operating system

Other

PHP engine version

PHP 8.2

Web server

Apache (supported)

Database engine version

MariaDB

Is this bug present after an update or on a fresh install?

None

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other

Configuration report

{
    "system": {
        "memcache.local": "\\OC\\Memcache\\APCu",
        "apps_paths": [
            {
                "path": "\/var\/www\/html\/apps",
                "url": "\/apps",
                "writable": false
            },
            {
                "path": "\/var\/www\/html\/custom_apps",
                "url": "\/custom_apps",
                "writable": true
            }
        ],
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "password": "***REMOVED SENSITIVE VALUE***",
            "port": 6379
        },
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "***REMOVED SENSITIVE VALUE***",
            "***REMOVED SENSITIVE VALUE***",
            "***REMOVED SENSITIVE VALUE***"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "30.0.0.14",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "skeletondirectory": "",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauth": 1,
        "mail_smtpsecure": "ssl",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "default_language": "de",
        "default_locale": "de_DE",
        "overwrite.cli.url": "***REMOVED SENSITIVE VALUE***",
        "default_phone_region": "DE",
        "defaultapp": "calendar",
        "loglevel": 0,
        "maintenance": false,
        "theme": "",
        "htaccess.RewriteBase": "\/",
        "maintenance_window_start": "3",
        "overwriteprotocol": "https",
        "app_install_overwrite": [
            "polls",
            "forms"
        ]
    }
}

List of activated Apps

Enabled:
  - bruteforcesettings: 3.0.0
  - calendar: 5.0.0
  - calendar_resource_management: 0.8.0
  - cloud_federation_api: 1.13.0
  - contacts: 6.1.0
  - contactsinteraction: 1.11.0
  - dav: 1.31.1
  - federatedfilesharing: 1.20.0
  - files: 2.2.0
  - files_downloadlimit: 3.0.0
  - files_external: 1.22.0
  - files_pdfviewer: 3.0.0
  - files_reminders: 1.3.0
  - files_sharing: 1.22.0
  - files_trashbin: 1.20.1
  - files_versions: 1.23.0
  - forms: 4.2.4
  - group_everyone: 0.1.16
  - impersonate: 1.17.0
  - logreader: 3.0.0
  - lookup_server_connector: 1.18.0
  - nextcloud_announcements: 2.0.0
  - notifications: 3.0.0
  - oauth2: 1.18.1
  - oidc: 0.9.4
  - password_policy: 2.0.0
  - polls: 7.2.3
  - previewgenerator: 5.6.0
  - privacy: 2.0.0
  - provisioning_api: 1.20.0
  - serverinfo: 2.0.0
  - settings: 1.13.0
  - sharebymail: 1.20.0
  - text: 4.1.0
  - theming: 2.5.0
  - twofactor_backupcodes: 1.19.0
  - updatenotification: 1.20.0
  - viewer: 3.0.0
  - webapppassword: 24.9.0
  - workflowengine: 2.12.0
Disabled:
  - activity: 3.0.0 (installed 2.18.0)
  - admin_audit: 1.20.0
  - calendar.bak: 5.0.0
  - circles: 30.0.0-dev (installed 26.0.0)
  - comments: 1.20.1 (installed 1.16.0)
  - dashboard: 7.10.0 (installed 7.6.0)
  - encryption: 2.18.0
  - federation: 1.20.0 (installed 1.17.0)
  - firstrunwizard: 3.0.0 (installed 2.15.0)
  - phonetrack: 0.8.1 (installed 0.8.1)
  - photos: 3.0.2 (installed 2.2.0)
  - recommendations: 3.0.0 (installed 1.5.0)
  - related_resources: 1.5.0 (installed 1.1.0-alpha1)
  - support: 2.0.0 (installed 1.9.0)
  - survey_client: 2.0.0 (installed 1.14.0)
  - suspicious_login: 8.0.0 (installed 8.0.0)
  - systemtags: 1.20.0 (installed 1.16.0)
  - twofactor_nextcloud_notification: 4.0.0
  - twofactor_totp: 12.0.0-dev
  - user_ldap: 1.21.0
  - user_status: 1.10.0 (installed 1.6.0)
  - weather_status: 1.10.0 (installed 1.6.0)
  - webhook_listeners: 1.1.0-dev (installed 1.1.0-dev)

Nextcloud Signing status

No response

Nextcloud Logs

{
  "reqId": "kbmyKr2K2FEYkV3xFQex",
  "level": 0,
  "time": "2024-09-20T05:02:28+00:00",
  "remoteAddr": "10.89.0.133",
  "user": "...",
  "app": "no app in context",
  "method": "MKCOL",
  "url": "/remote.php/dav/calendars/.../...",
  "message": "dirty table reads: SELECT `displayname`, `refreshrate`, `calendarorder`, `calendarcolor`, `striptodos`, `stripalarms`, `stripattachments`, `id`, `uri`, `source`, `principaluri`, `lastmodified`, `synctoken` FROM `*PREFIX*calendarsubscriptions` WHERE `principaluri` = :dcValue1 ORDER BY `calendarorder` asc",
  "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0",
  "version": "30.0.0.14",
  "exception": {
    "Exception": "Exception",
    "Message": "dirty table reads: SELECT `displayname`, `refreshrate`, `calendarorder`, `calendarcolor`, `striptodos`, `stripalarms`, `stripattachments`, `id`, `uri`, `source`, `principaluri`, `lastmodified`, `synctoken` FROM `*PREFIX*calendarsubscriptions` WHERE `principaluri` = :dcValue1 ORDER BY `calendarorder` asc",
    "Code": 0,
    "Trace": [
      {
        "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
        "line": 50,
        "function": "executeQuery",
        "class": "OC\\DB\\Connection",
        "type": "->",
        "args": [
          "SELECT `displayname`, `refreshrate`, `calendarorder`, `calendarcolor`, `striptodos`, `stripalarms`, `stripattachments`, `id`, `uri`, `source`, `principaluri`, `lastmodified`, `synctoken` FROM `*PREFIX*calendarsubscriptions` WHERE `principaluri` = :dcValue1 ORDER BY `calendarorder` asc",
          ["*** sensitive parameters replaced ***"],
          [2]
        ]
      },
      {
        "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
        "line": 272,
        "function": "executeQuery",
        "class": "OC\\DB\\ConnectionAdapter",
        "type": "->",
        "args": [
          "SELECT `displayname`, `refreshrate`, `calendarorder`, `calendarcolor`, `striptodos`, `stripalarms`, `stripattachments`, `id`, `uri`, `source`, `principaluri`, `lastmodified`, `synctoken` FROM `*PREFIX*calendarsubscriptions` WHERE `principaluri` = :dcValue1 ORDER BY `calendarorder` asc",
          ["*** sensitive parameters replaced ***"],
          [2]
        ]
      },
      {
        "file": "/var/www/html/apps/dav/lib/CalDAV/CalDavBackend.php",
        "line": 2551,
        "function": "executeQuery",
        "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php",
        "line": 162,
        "function": "getSubscriptionsForUser",
        "class": "OCA\\DAV\\CalDAV\\CalDavBackend",
        "type": "->",
        "args": ["*** sensitive parameters replaced ***"]
      },
      {
        "file": "/var/www/html/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php",
        "line": 40,
        "function": "getSubscription",
        "class": "OCA\\DAV\\CalDAV\\WebcalCaching\\RefreshWebcalService",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***",
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/var/www/html/apps/dav/lib/Listener/SubscriptionListener.php",
        "line": 45,
        "function": "refreshSubscription",
        "class": "OCA\\DAV\\CalDAV\\WebcalCaching\\RefreshWebcalService",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***",
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/var/www/html/lib/private/EventDispatcher/ServiceEventListener.php",
        "line": 68,
        "function": "handle",
        "class": "OCA\\DAV\\Listener\\SubscriptionListener",
        "type": "->",
        "args": [["OCA\\DAV\\Events\\SubscriptionCreatedEvent"]]
      },
      {
        "file": "/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
        "line": 230,
        "function": "__invoke",
        "class": "OC\\EventDispatcher\\ServiceEventListener",
        "type": "->",
        "args": [
          ["OCA\\DAV\\Events\\SubscriptionCreatedEvent"],
          "OCA\\DAV\\Events\\SubscriptionCreatedEvent",
          ["Symfony\\Component\\EventDispatcher\\EventDispatcher"]
        ]
      },
      {
        "file": "/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
        "line": 59,
        "function": "callListeners",
        "class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
        "type": "->",
        "args": [
          [["Closure"]],
          "OCA\\DAV\\Events\\SubscriptionCreatedEvent",
          ["OCA\\DAV\\Events\\SubscriptionCreatedEvent"]
        ]
      },
      {
        "file": "/var/www/html/lib/private/EventDispatcher/EventDispatcher.php",
        "line": 67,
        "function": "dispatch",
        "class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
        "type": "->",
        "args": [
          ["OCA\\DAV\\Events\\SubscriptionCreatedEvent"],
          "OCA\\DAV\\Events\\SubscriptionCreatedEvent"
        ]
      },
      {
        "file": "/var/www/html/lib/private/EventDispatcher/EventDispatcher.php",
        "line": 79,
        "function": "dispatch",
        "class": "OC\\EventDispatcher\\EventDispatcher",
        "type": "->",
        "args": [
          "OCA\\DAV\\Events\\SubscriptionCreatedEvent",
          ["OCA\\DAV\\Events\\SubscriptionCreatedEvent"]
        ]
      },
      {
        "file": "/var/www/html/apps/dav/lib/CalDAV/CalDavBackend.php",
        "line": 2622,
        "function": "dispatchTyped",
        "class": "OC\\EventDispatcher\\EventDispatcher",
        "type": "->",
        "args": [["OCA\\DAV\\Events\\SubscriptionCreatedEvent"]]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php",
        "line": 249,
        "function": "createSubscription",
        "class": "OCA\\DAV\\CalDAV\\CalDavBackend",
        "type": "->",
        "args": ["*** sensitive parameters replaced ***"]
      },
      {
        "file": "/var/www/html/apps/dav/lib/CalDAV/CalendarHome.php",
        "line": 77,
        "function": "createExtendedCollection",
        "class": "Sabre\\CalDAV\\CalendarHome",
        "type": "->",
        "args": ["*** sensitive parameters replaced ***"]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 1199,
        "function": "createExtendedCollection",
        "class": "OCA\\DAV\\CalDAV\\CalendarHome",
        "type": "->",
        "args": ["*** sensitive parameters replaced ***"]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
        "line": 560,
        "function": "createCollection",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": ["*** sensitive parameters replaced ***"]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
        "line": 89,
        "function": "httpMkcol",
        "class": "Sabre\\DAV\\CorePlugin",
        "type": "->",
        "args": [["Sabre\\HTTP\\Request"], ["Sabre\\HTTP\\Response"]]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 472,
        "function": "emit",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": [
          "method:MKCOL",
          [["Sabre\\HTTP\\Request"], ["Sabre\\HTTP\\Response"]]
        ]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 253,
        "function": "invokeMethod",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": [["Sabre\\HTTP\\Request"], ["Sabre\\HTTP\\Response"]]
      },
      {
        "file": "/var/www/html/apps/dav/lib/Server.php",
        "line": 370,
        "function": "start",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/apps/dav/appinfo/v2/remote.php",
        "line": 19,
        "function": "exec",
        "class": "OCA\\DAV\\Server",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/remote.php",
        "line": 146,
        "args": ["/var/www/html/apps/dav/appinfo/v2/remote.php"],
        "function": "require_once"
      }
    ],
    "File": "/var/www/html/lib/private/DB/Connection.php",
    "Line": 402,
    "message": "dirty table reads: SELECT `displayname`, `refreshrate`, `calendarorder`, `calendarcolor`, `striptodos`, `stripalarms`, `stripattachments`, `id`, `uri`, `source`, `principaluri`, `lastmodified`, `synctoken` FROM `*PREFIX*calendarsubscriptions` WHERE `principaluri` = :dcValue1 ORDER BY `calendarorder` asc",
    "tables": ["oc_calendarsubscriptions"],
    "reads": ["oc_calendarsubscriptions"],
    "exception": [],
    "CustomMessage": "dirty table reads: SELECT `displayname`, `refreshrate`, `calendarorder`, `calendarcolor`, `striptodos`, `stripalarms`, `stripattachments`, `id`, `uri`, `source`, `principaluri`, `lastmodified`, `synctoken` FROM `*PREFIX*calendarsubscriptions` WHERE `principaluri` = :dcValue1 ORDER BY `calendarorder` asc"
  },
  "id": "66ed01eb73efe"
}

Additional info

[joshtrichards]

Was is the XML response under your browser inspector under the Network tab for the transaction that is returning a 403?

[escoand]

Yes,

<?xml version="1.0" encoding="utf-8"?>
<d:error xmlns:d="DAV:" xmlns:s="http://sabredav.org/ns">
	<s:exception>Interner Serverfehler</s:exception>
	<s:message>
		Der Server konnte die Anfrage nicht fertig stellen.		Sollte dies erneut auftreten, sende bitte die nachfolgenden technischen Einzelheiten an deinen Server-Administrator.		Weitere Details können im Server-Protokoll gefunden werden.			</s:message>

	<s:technical-details>
		<s:remote-address>10.89.0.133</s:remote-address>
		<s:request-id>vaFRfVFMcxv0qTSSzEmt</s:request-id>

		</s:technical-details>
</d:error>

[escoand]

I tried another Nextcloud instance with the same result. Does this google calendar maybe has some special entries crashing the import?

[escoand]

Found the reason and created a pull request. #48349

[joshtrichards]

Re-opening to track dev progress. We'll let a successful merge auto-close the Issue via the linked PR. :)