deadlocks in oc_calendarchanges when importing events #12947

flokli · 2018-12-09T22:55:33Z

Steps to reproduce

Set up nextcloud, enable calendar app. I used MySQL as database, without memcache and without redis
From the calendar view, import some events from ics via Settings & Import -> Import calendar

Expected behaviour

Nextcloud should be able to import events

Actual behaviour

A lot of events failed to import. Logs show some deadlocks occured.

Server configuration

Operating system: NixOS 18.09

Web server: nginx 1.14.1

Database: mariadb-10.2.17

PHP version: php 7.1.24

Nextcloud version: 14.0.4

Updated from an older Nextcloud/ownCloud or fresh install: updated from 14.0.3

Where did you install Nextcloud from: https://github.com/NixOS/nixpkgs/blob/ee1613aea656119a872c3e75334e8469c27fff44/pkgs/servers/nextcloud/default.nix

Signing status:

Signing status

Technical information
=====================
The following list covers which files have failed the integrity check. Please read
the previous linked documentation to learn more about the errors and how to fix
them.

Results
=======
- core
	- INVALID_HASH
		- lib/private/Mail/Mailer.php

Raw output
==========
Array
(
    [core] => Array
        (
            [INVALID_HASH] => Array
                (
                    [lib/private/Mail/Mailer.php] => Array
                        (
                            [expected] => 14863a04a8a9c5ce1ba56a415609a6ef0ecae27810ce7fa1d654f211d7f6c3eb882a022e7053db91e5c2bce2c6de2d4a19289383f7aeacab7686b7af34b1de32
                            [current] => 7ccb23725eabf13e31efe8fc040e4bf49d47563519c8f1a22e9d7a12a8de1f721cce88e3e1eea20f72b74e8a910e80564007192860d41b6645a01222d846aaf6
                        )

                )

        )

)

This is expected, we apply https://github.com/nextcloud/server/pull/11404.patch to fix sendmail, which is not backported to 14, but will be shipped in nextcloud 15.

List of activated apps:

App list

Enabled:
  - accessibility: 1.0.1
  - activity: 2.7.0
  - calendar: 1.6.4
  - cloud_federation_api: 0.0.1
  - comments: 1.4.0
  - contacts: 2.1.8
  - dav: 1.6.0
  - federatedfilesharing: 1.4.0
  - federation: 1.4.0
  - files: 1.9.0
  - files_pdfviewer: 1.3.2
  - files_sharing: 1.6.2
  - files_texteditor: 2.6.0
  - files_trashbin: 1.4.1
  - files_versions: 1.7.1
  - files_videoplayer: 1.3.0
  - firstrunwizard: 2.3.0
  - gallery: 18.1.0
  - logreader: 2.0.0
  - lookup_server_connector: 1.2.0
  - nextcloud_announcements: 1.3.0
  - notifications: 2.2.1
  - oauth2: 1.2.1
  - password_policy: 1.4.0
  - provisioning_api: 1.4.0
  - serverinfo: 1.4.0
  - sharebymail: 1.4.0
  - support: 1.0.0
  - survey_client: 1.2.0
  - systemtags: 1.4.0
  - theming: 1.5.0
  - twofactor_backupcodes: 1.3.1
  - updatenotification: 1.4.1
  - workflowengine: 1.4.0
Disabled:
  - admin_audit
  - encryption
  - files_external
  - user_external
  - user_ldap

Nextcloud configuration:

Config report

{
    "system": {
        "apps_paths": [
            {
                "path": "\/var\/lib\/nextcloud\/apps",
                "url": "\/apps",
                "writable": false
            },
            {
                "path": "\/var\/lib\/nextcloud\/store-apps",
                "url": "\/store-apps",
                "writable": true
            }
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "skeletondirectory": "",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "log_type": "syslog",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "14.0.4.2",
        "overwrite.cli.url": "http:\/\/localhost",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "loglevel": 2,
        "maintenance": false,
        "trusted_domains": [
            "***REMOVED SENSITIVE VALUE***"
        ]
    }
}

Are you using external storage, if yes which one: local/smb/sftp/... no

Are you using encryption: yes/no no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/... no

Client configuration

Browser: Google Chrome 70

Operating system: NixOS 18.09

Logs

Web server error log

Nextcloud log (data/nextcloud.log)

Nextcloud log

{
  "Exception": "Doctrine\\DBAL\\Exception\\DriverException",
  "Message": "An exception occurred while executing 'INSERT INTO `oc_calendarchanges` (`uri`, `synctoken`, `calendarid`, `operation`) SELECT ?, `synctoken`, ?, ? FROM `oc_calendars` WHERE `id` = ?' with params [\"Nextcloud-C2FREY26K7OGRSMWFEJ52.ics\", \"3\", 1, \"3\"]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction",
  "Code": 0,
  "Trace": [
    {
      "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php",
      "line": 128,
      "function": "convertException",
      "class": "Doctrine\\DBAL\\Driver\\AbstractMySQLDriver",
      "type": "->",
      "args": [
        "An exception occurred while executing 'INSERT INTO `oc_calendarchanges` (`uri`, `synctoken`, `calendarid`, `operation`) SELECT ?, `synctoken`, ?, ? FROM `oc_calendars` WHERE `id` = ?' with params [\"Nextcloud-C2FREY26K7OGRSMWFEJ52.ics\", \"3\", 1, \"3\"]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction",
        {
          "errorInfo": [
            "40001",
            1213,
            "Deadlock found when trying to get lock; try restarting transaction"
          ],
          "__class__": "Doctrine\\DBAL\\Driver\\PDOException"
        }
      ]
    },
    {
      "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php",
      "line": 177,
      "function": "driverExceptionDuringQuery",
      "class": "Doctrine\\DBAL\\DBALException",
      "type": "::",
      "args": [
        {
          "__class__": "Doctrine\\DBAL\\Driver\\PDOMySql\\Driver"
        },
        {
          "errorInfo": [
            "40001",
            1213,
            "Deadlock found when trying to get lock; try restarting transaction"
          ],
          "__class__": "Doctrine\\DBAL\\Driver\\PDOException"
        },
        "INSERT INTO `oc_calendarchanges` (`uri`, `synctoken`, `calendarid`, `operation`) SELECT ?, `synctoken`, ?, ? FROM `oc_calendars` WHERE `id` = ?",
        {
          "1": "Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
          "2": "3",
          "3": 1,
          "4": "3"
        }
      ]
    },
    {
      "file": "/nix/store/x9i6jp7d0lmydnxhv3csbklrx93y3pci-nextcloud-14.0.3/apps/dav/lib/CalDAV/CalDavBackend.php",
      "line": 2013,
      "function": "execute",
      "class": "Doctrine\\DBAL\\Statement",
      "type": "->",
      "args": [
        [
          "Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
          "3",
          1,
          "3"
        ]
      ]
    },
    {
      "file": "/nix/store/x9i6jp7d0lmydnxhv3csbklrx93y3pci-nextcloud-14.0.3/apps/dav/lib/CalDAV/CalDavBackend.php",
      "line": 1020,
      "function": "addChange",
      "class": "OCA\\DAV\\CalDAV\\CalDavBackend",
      "type": "->",
      "args": [
        "3",
        "Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
        1
      ]
    },
    {
      "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/dav/lib/CalDAV/Calendar.php",
      "line": 201,
      "function": "createCalendarObject",
      "class": "OCA\\DAV\\CalDAV\\CalDavBackend",
      "type": "->",
      "args": [
        "3",
        "Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
        "BEGIN:VCALENDAR\r\n[...]\r\nEND:VCALENDAR"
      ]
    },
    {
      "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/dav/lib/DAV/Server.php",
      "line": 1096,
      "function": "createFile",
      "class": "Sabre\\CalDAV\\Calendar",
      "type": "->",
      "args": [
        "Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
        "BEGIN:VCALENDAR\r\n[...]\r\nEND:VCALENDAR"
      ]
    },
    {
      "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
      "line": 529,
      "function": "createFile",
      "class": "Sabre\\DAV\\Server",
      "type": "->",
      "args": [
        "calendars/testuser/personal/Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
        "BEGIN:VCALENDAR\r\n[...]\r\nEND:VCALENDAR",
        null
      ]
    },
    {
      "function": "httpPut",
      "class": "Sabre\\DAV\\CorePlugin",
      "type": "->",
      "args": [
        {
          "absoluteUrl": "https://nextcloud/remote.php/dav/calendars/testuser/personal/Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
          "__class__": "Sabre\\HTTP\\Request"
        },
        {
          "__class__": "Sabre\\HTTP\\Response"
        }
      ]
    },
    {
      "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/event/lib/EventEmitterTrait.php",
      "line": 105,
      "function": "call_user_func_array",
      "args": [
        [
          {
            "__class__": "Sabre\\DAV\\CorePlugin"
          },
          "httpPut"
        ],
        [
          {
            "absoluteUrl": "https://nextcloud/remote.php/dav/calendars/testuser/personal/Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
            "__class__": "Sabre\\HTTP\\Request"
          },
          {
            "__class__": "Sabre\\HTTP\\Response"
          }
        ]
      ]
    },
    {
      "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/dav/lib/DAV/Server.php",
      "line": 479,
      "function": "emit",
      "class": "Sabre\\Event\\EventEmitter",
      "type": "->",
      "args": [
        "method:PUT",
        [
          {
            "absoluteUrl": "https://nextcloud/remote.php/dav/calendars/testuser/personal/Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
            "__class__": "Sabre\\HTTP\\Request"
          },
          {
            "__class__": "Sabre\\HTTP\\Response"
          }
        ]
      ]
    },
    {
      "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/dav/lib/DAV/Server.php",
      "line": 254,
      "function": "invokeMethod",
      "class": "Sabre\\DAV\\Server",
      "type": "->",
      "args": [
        {
          "absoluteUrl": "https://nextcloud/remote.php/dav/calendars/testuser/personal/Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
          "__class__": "Sabre\\HTTP\\Request"
        },
        {
          "__class__": "Sabre\\HTTP\\Response"
        }
      ]
    },
    {
      "file": "/nix/store/x9i6jp7d0lmydnxhv3csbklrx93y3pci-nextcloud-14.0.3/apps/dav/lib/Server.php",
      "line": 293,
      "function": "exec",
      "class": "Sabre\\DAV\\Server",
      "type": "->",
      "args": []
    },
    {
      "file": "/nix/store/x9i6jp7d0lmydnxhv3csbklrx93y3pci-nextcloud-14.0.3/apps/dav/appinfo/v2/remote.php",
      "line": 35,
      "function": "exec",
      "class": "OCA\\DAV\\Server",
      "type": "->",
      "args": []
    },
    {
      "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/remote.php",
      "line": 163,
      "args": [
        "/nix/store/x9i6jp7d0lmydnxhv3csbklrx93y3pci-nextcloud-14.0.3/apps/dav/appinfo/v2/remote.php"
      ],
      "function": "require_once"
    }
  ],
  "File": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php",
  "Line": 115,
  "Previous": {
    "Exception": "Doctrine\\DBAL\\Driver\\PDOException",
    "Message": "SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction",
    "Code": "40001",
    "Trace": [
      {
        "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php",
        "line": 168,
        "function": "execute",
        "class": "Doctrine\\DBAL\\Driver\\PDOStatement",
        "type": "->",
        "args": [
          [
            "Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
            "3",
            1,
            "3"
          ]
        ]
      },
      {
        "file": "/nix/store/x9i6jp7d0lmydnxhv3csbklrx93y3pci-nextcloud-14.0.3/apps/dav/lib/CalDAV/CalDavBackend.php",
        "line": 2013,
        "function": "execute",
        "class": "Doctrine\\DBAL\\Statement",
        "type": "->",
        "args": [
          [
            "Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
            "3",
            1,
            "3"
          ]
        ]
      },
      {
        "file": "/nix/store/x9i6jp7d0lmydnxhv3csbklrx93y3pci-nextcloud-14.0.3/apps/dav/lib/CalDAV/CalDavBackend.php",
        "line": 1020,
        "function": "addChange",
        "class": "OCA\\DAV\\CalDAV\\CalDavBackend",
        "type": "->",
        "args": [
          "3",
          "Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
          1
        ]
      },
      {
        "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/dav/lib/CalDAV/Calendar.php",
        "line": 201,
        "function": "createCalendarObject",
        "class": "OCA\\DAV\\CalDAV\\CalDavBackend",
        "type": "->",
        "args": [
          "3",
          "Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
          "BEGIN:VCALENDAR\r\n[...]\r\nEND:VCALENDAR"
        ]
      },
      {
        "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 1096,
        "function": "createFile",
        "class": "Sabre\\CalDAV\\Calendar",
        "type": "->",
        "args": [
          "Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
          "BEGIN:VCALENDAR\r\n[...]\r\nEND:VCALENDAR"
        ]
      },
      {
        "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
        "line": 529,
        "function": "createFile",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": [
          "calendars/testuser/personal/Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
          "BEGIN:VCALENDAR\r\n[...]\r\nEND:VCALENDAR",
          null
        ]
      },
      {
        "function": "httpPut",
        "class": "Sabre\\DAV\\CorePlugin",
        "type": "->",
        "args": [
          {
            "absoluteUrl": "https://nextcloud/remote.php/dav/calendars/testuser/personal/Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
            "__class__": "Sabre\\HTTP\\Request"
          },
          {
            "__class__": "Sabre\\HTTP\\Response"
          }
        ]
      },
      {
        "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/event/lib/EventEmitterTrait.php",
        "line": 105,
        "function": "call_user_func_array",
        "args": [
          [
            {
              "__class__": "Sabre\\DAV\\CorePlugin"
            },
            "httpPut"
          ],
          [
            {
              "absoluteUrl": "https://nextcloud/remote.php/dav/calendars/testuser/personal/Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
              "__class__": "Sabre\\HTTP\\Request"
            },
            {
              "__class__": "Sabre\\HTTP\\Response"
            }
          ]
        ]
      },
      {
        "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 479,
        "function": "emit",
        "class": "Sabre\\Event\\EventEmitter",
        "type": "->",
        "args": [
          "method:PUT",
          [
            {
              "absoluteUrl": "https://nextcloud/remote.php/dav/calendars/testuser/personal/Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
              "__class__": "Sabre\\HTTP\\Request"
            },
            {
              "__class__": "Sabre\\HTTP\\Response"
            }
          ]
        ]
      },
      {
        "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 254,
        "function": "invokeMethod",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": [
          {
            "absoluteUrl": "https://nextcloud/remote.php/dav/calendars/testuser/personal/Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
            "__class__": "Sabre\\HTTP\\Request"
          },
          {
            "__class__": "Sabre\\HTTP\\Response"
          }
        ]
      },
      {
        "file": "/nix/store/x9i6jp7d0lmydnxhv3csbklrx93y3pci-nextcloud-14.0.3/apps/dav/lib/Server.php",
        "line": 293,
        "function": "exec",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": []
      },
      {
        "file": "/nix/store/x9i6jp7d0lmydnxhv3csbklrx93y3pci-nextcloud-14.0.3/apps/dav/appinfo/v2/remote.php",
        "line": 35,
        "function": "exec",
        "class": "OCA\\DAV\\Server",
        "type": "->",
        "args": []
      },
      {
        "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/remote.php",
        "line": 163,
        "args": [
          "/nix/store/x9i6jp7d0lmydnxhv3csbklrx93y3pci-nextcloud-14.0.3/apps/dav/appinfo/v2/remote.php"
        ],
        "function": "require_once"
      }
    ],
    "File": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",
    "Line": 107,
    "Previous": {
      "Exception": "PDOException",
      "Message": "SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction",
      "Code": "40001",
      "Trace": [
        {
          "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",
          "line": 105,
          "function": "execute",
          "class": "PDOStatement",
          "type": "->",
          "args": [
            [
              "Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
              "3",
              1,
              "3"
            ]
          ]
        },
        {
          "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php",
          "line": 168,
          "function": "execute",
          "class": "Doctrine\\DBAL\\Driver\\PDOStatement",
          "type": "->",
          "args": [
            [
              "Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
              "3",
              1,
              "3"
            ]
          ]
        },
        {
          "file": "/nix/store/x9i6jp7d0lmydnxhv3csbklrx93y3pci-nextcloud-14.0.3/apps/dav/lib/CalDAV/CalDavBackend.php",
          "line": 2013,
          "function": "execute",
          "class": "Doctrine\\DBAL\\Statement",
          "type": "->",
          "args": [
            [
              "Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
              "3",
              1,
              "3"
            ]
          ]
        },
        {
          "file": "/nix/store/x9i6jp7d0lmydnxhv3csbklrx93y3pci-nextcloud-14.0.3/apps/dav/lib/CalDAV/CalDavBackend.php",
          "line": 1020,
          "function": "addChange",
          "class": "OCA\\DAV\\CalDAV\\CalDavBackend",
          "type": "->",
          "args": [
            "3",
            "Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
            1
          ]
        },
        {
          "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/dav/lib/CalDAV/Calendar.php",
          "line": 201,
          "function": "createCalendarObject",
          "class": "OCA\\DAV\\CalDAV\\CalDavBackend",
          "type": "->",
          "args": [
            "3",
            "Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
            "BEGIN:VCALENDAR\r\n[...]\r\nEND:VCALENDAR"
          ]
        },
        {
          "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/dav/lib/DAV/Server.php",
          "line": 1096,
          "function": "createFile",
          "class": "Sabre\\CalDAV\\Calendar",
          "type": "->",
          "args": [
            "Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
            "BEGIN:VCALENDAR\r\n[...]\r\nEND:VCALENDAR"
          ]
        },
        {
          "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
          "line": 529,
          "function": "createFile",
          "class": "Sabre\\DAV\\Server",
          "type": "->",
          "args": [
            "calendars/testuser/personal/Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
            "BEGIN:VCALENDAR\r\n[...]\r\nEND:VCALENDAR",
            null
          ]
        },
        {
          "function": "httpPut",
          "class": "Sabre\\DAV\\CorePlugin",
          "type": "->",
          "args": [
            {
              "absoluteUrl": "https://nextcloud/remote.php/dav/calendars/testuser/personal/Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
              "__class__": "Sabre\\HTTP\\Request"
            },
            {
              "__class__": "Sabre\\HTTP\\Response"
            }
          ]
        },
        {
          "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/event/lib/EventEmitterTrait.php",
          "line": 105,
          "function": "call_user_func_array",
          "args": [
            [
              {
                "__class__": "Sabre\\DAV\\CorePlugin"
              },
              "httpPut"
            ],
            [
              {
                "absoluteUrl": "https://nextcloud/remote.php/dav/calendars/testuser/personal/Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
                "__class__": "Sabre\\HTTP\\Request"
              },
              {
                "__class__": "Sabre\\HTTP\\Response"
              }
            ]
          ]
        },
        {
          "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/dav/lib/DAV/Server.php",
          "line": 479,
          "function": "emit",
          "class": "Sabre\\Event\\EventEmitter",
          "type": "->",
          "args": [
            "method:PUT",
            [
              {
                "absoluteUrl": "https://nextcloud/remote.php/dav/calendars/testuser/personal/Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
                "__class__": "Sabre\\HTTP\\Request"
              },
              {
                "__class__": "Sabre\\HTTP\\Response"
              }
            ]
          ]
        },
        {
          "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/sabre/dav/lib/DAV/Server.php",
          "line": 254,
          "function": "invokeMethod",
          "class": "Sabre\\DAV\\Server",
          "type": "->",
          "args": [
            {
              "absoluteUrl": "https://nextcloud/remote.php/dav/calendars/testuser/personal/Nextcloud-C2FREY26K7OGRSMWFEJ52.ics",
              "__class__": "Sabre\\HTTP\\Request"
            },
            {
              "__class__": "Sabre\\HTTP\\Response"
            }
          ]
        },
        {
          "file": "/nix/store/x9i6jp7d0lmydnxhv3csbklrx93y3pci-nextcloud-14.0.3/apps/dav/lib/Server.php",
          "line": 293,
          "function": "exec",
          "class": "Sabre\\DAV\\Server",
          "type": "->",
          "args": []
        },
        {
          "file": "/nix/store/x9i6jp7d0lmydnxhv3csbklrx93y3pci-nextcloud-14.0.3/apps/dav/appinfo/v2/remote.php",
          "line": 35,
          "function": "exec",
          "class": "OCA\\DAV\\Server",
          "type": "->",
          "args": []
        },
        {
          "file": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/remote.php",
          "line": 163,
          "args": [
            "/nix/store/x9i6jp7d0lmydnxhv3csbklrx93y3pci-nextcloud-14.0.3/apps/dav/appinfo/v2/remote.php"
          ],
          "function": "require_once"
        }
      ],
      "File": "/nix/store/h5csnfawxc73w0c0ls41fmj32cmjw2fi-nextcloud-14.0.4/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",
      "Line": 105
    }
  },
  "CustomMessage": "--"
}

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log
c) ...

I stripped the VCARD payload and json-formatted the log entry.

Might be related to #12413.

The text was updated successfully, but these errors were encountered:

flokli · 2018-12-15T13:37:57Z

cc @MorrisJobke

MorrisJobke · 2019-01-04T22:55:05Z

cc @georgehrke @tcitworld for the calendar import

georgehrke · 2019-01-04T23:18:51Z

There is this ticket in the calendar repo about limiting the number of import requests at a time: nextcloud/calendar#445 (already fixed in alpha of 2.0)

@MorrisJobke It would probably still be nice to properly catch this in the server, right?

MorrisJobke · 2019-01-05T08:47:36Z

How could we? Isn’t this due to a too big query from the calendar app?

flokli · 2019-01-05T08:53:20Z

In my case, this was a slow database - moving it to a faster underlying storage did work around the problem, but I'd consider nextcloud just failing randomly with some deadlocks a bug, not the slow storage...

georgehrke · 2019-01-05T12:16:16Z

How could we? Isn’t this due to a too big query from the calendar app?

Ok, so let's close this as a duplicate of nextcloud/calendar#445

flokli added 0. Needs triage Pending check for reproducibility or if it fits our roadmap bug labels Dec 9, 2018

georgehrke closed this as completed Jan 5, 2019

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

deadlocks in oc_calendarchanges when importing events #12947

deadlocks in oc_calendarchanges when importing events #12947

flokli commented Dec 9, 2018

flokli commented Dec 15, 2018

MorrisJobke commented Jan 4, 2019

georgehrke commented Jan 4, 2019

MorrisJobke commented Jan 5, 2019

flokli commented Jan 5, 2019 via email

georgehrke commented Jan 5, 2019

deadlocks in oc_calendarchanges when importing events #12947

deadlocks in oc_calendarchanges when importing events #12947

Comments

flokli commented Dec 9, 2018

Steps to reproduce

Expected behaviour

Actual behaviour

Server configuration

Client configuration

Logs

Web server error log

Nextcloud log (data/nextcloud.log)

Browser log

flokli commented Dec 15, 2018

MorrisJobke commented Jan 4, 2019

georgehrke commented Jan 4, 2019

MorrisJobke commented Jan 5, 2019

flokli commented Jan 5, 2019 via email

georgehrke commented Jan 5, 2019