Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: SQL Deadlock on file renaming #46272

Open
6 of 8 tasks
solracsf opened this issue Jul 3, 2024 · 0 comments
Open
6 of 8 tasks

[Bug]: SQL Deadlock on file renaming #46272

solracsf opened this issue Jul 3, 2024 · 0 comments
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 28-feedback bug

Comments

@solracsf
Copy link
Member

solracsf commented Jul 3, 2024

⚠️ This issue respects the following points: ⚠️

Bug description

An exception occurred while executing a query: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction

Steps to reproduce

Try to rename a file on Desktop, and wait for the Nextcloud Desktop Client to upload it. Often results in Deadlock (not always).

Expected behavior

File is renamed.

Installation method

None

Nextcloud Server version

28

Operating system

None

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?

Encryption is Disabled

What user-backends are you using?

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

Configuration report

No response

List of activated Apps

No response

Nextcloud Signing status

No response

Nextcloud Logs

{
  "reqId": "FEO5bCkzSmzWg2mmky1m",
  "level": 3,
  "time": "2024-07-03T09:57:48+02:00",
  "remoteAddr": "8.22.29.25",
  "user": "user.name",
  "app": "webdav",
  "method": "MOVE",
  "url": "/remote.php/dav/files/user.name/POLE%20ADMIN/FONDATION/2025/Trame%20de%20note%20de%20frais%20FCS-2024.xlsx",
  "message": "An exception occurred while executing a query: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction",
  "userAgent": "Mozilla/5.0 (Windows) mirall/3.8.2stable-Win64 (build 20230516) (Nextcloud, windows-10.0.19045 ClientArchitecture: x86_64 OsArchitecture: x86_64)",
  "version": "28.0.7.4",
  "exception": {
    "Exception": "Doctrine\\DBAL\\Exception\\DeadlockException",
    "Message": "An exception occurred while executing a query: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction",
    "Code": 1213,
    "Trace": [
      {
        "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
        "line": 1814,
        "function": "convert",
        "class": "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
        "type": "->",
        "args": [
          [
            "Doctrine\\DBAL\\Driver\\PDO\\Exception"
          ],
          [
            "Doctrine\\DBAL\\Query"
          ]
        ]
      },
      {
        "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
        "line": 1749,
        "function": "handleDriverException",
        "class": "Doctrine\\DBAL\\Connection",
        "type": "->",
        "args": [
          [
            "Doctrine\\DBAL\\Driver\\PDO\\Exception"
          ],
          [
            "Doctrine\\DBAL\\Query"
          ]
        ]
      },
      {
        "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
        "line": 1163,
        "function": "convertExceptionDuringQuery",
        "class": "Doctrine\\DBAL\\Connection",
        "type": "->",
        "args": [
          [
            "Doctrine\\DBAL\\Driver\\PDO\\Exception"
          ],
          "UPDATE `oc_filecache` SET `size` = ? WHERE (`fileid` = ?) AND ((`size` <> ?) OR (`size` IS NULL))",
          [
            165473361,
            "*** sensitive parameters replaced ***",
            165473361
          ],
          [
            2,
            1,
            2
          ]
        ]
      },
      {
        "file": "/var/www/nextcloud/lib/private/DB/Connection.php",
        "line": 298,
        "function": "executeStatement",
        "class": "Doctrine\\DBAL\\Connection",
        "type": "->",
        "args": [
          "UPDATE `oc_filecache` SET `size` = ? WHERE (`fileid` = ?) AND ((`size` <> ?) OR (`size` IS NULL))",
          [
            165473361,
            "*** sensitive parameters replaced ***",
            165473361
          ],
          [
            2,
            1,
            2
          ]
        ]
      },
      {
        "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
        "line": 354,
        "function": "executeStatement",
        "class": "OC\\DB\\Connection",
        "type": "->",
        "args": [
          "UPDATE `oc_filecache` SET `size` = :dcValue3 WHERE (`fileid` = :dcValue1) AND ((`size` <> :dcValue2) OR (`size` IS NULL))",
          [
            "*** sensitive parameters replaced ***",
            165473361,
            165473361
          ],
          [
            1,
            2,
            2
          ]
        ]
      },
      {
        "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
        "line": 280,
        "function": "execute",
        "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/nextcloud/lib/private/Files/Cache/Cache.php",
        "line": 387,
        "function": "execute",
        "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/nextcloud/lib/private/Files/Cache/Cache.php",
        "line": 1035,
        "function": "update",
        "class": "OC\\Files\\Cache\\Cache",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/var/www/nextcloud/lib/private/Files/Cache/Cache.php",
        "line": 953,
        "function": "calculateFolderSizeInner",
        "class": "OC\\Files\\Cache\\Cache",
        "type": "->",
        "args": [
          "files/POLE ADMIN/FONDATION/2025",
          [
            "OC\\Files\\Cache\\CacheEntry"
          ]
        ]
      },
      {
        "file": "/var/www/nextcloud/lib/private/Files/Cache/HomeCache.php",
        "line": 43,
        "function": "calculateFolderSize",
        "class": "OC\\Files\\Cache\\Cache",
        "type": "->",
        "args": [
          "files/POLE ADMIN/FONDATION/2025",
          null
        ]
      },
      {
        "file": "/var/www/nextcloud/lib/private/Files/Cache/Cache.php",
        "line": 905,
        "function": "calculateFolderSize",
        "class": "OC\\Files\\Cache\\HomeCache",
        "type": "->",
        "args": [
          "files/POLE ADMIN/FONDATION/2025",
          null
        ]
      },
      {
        "file": "/var/www/nextcloud/lib/private/Files/Cache/Cache.php",
        "line": 917,
        "function": "correctFolderSize",
        "class": "OC\\Files\\Cache\\Cache",
        "type": "->",
        "args": [
          "files/POLE ADMIN/FONDATION/2025"
        ]
      },
      {
        "file": "/var/www/nextcloud/lib/private/Files/Cache/Updater.php",
        "line": 223,
        "function": "correctFolderSize",
        "class": "OC\\Files\\Cache\\Cache",
        "type": "->",
        "args": [
          "files/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2024.xlsx"
        ]
      },
      {
        "file": "/var/www/nextcloud/lib/private/Files/View.php",
        "line": 308,
        "function": "renameFromStorage",
        "class": "OC\\Files\\Cache\\Updater",
        "type": "->",
        "args": [
          [
            "OCA\\Files_Trashbin\\Storage",
            null,
            [
              "OC\\Files\\Cache\\Scanner"
            ],
            null,
            null,
            [
              "OC\\Files\\Cache\\Updater"
            ]
          ],
          "files/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2024.xlsx",
          "files/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2025.xlsx"
        ]
      },
      {
        "file": "/var/www/nextcloud/lib/private/Files/View.php",
        "line": 824,
        "function": "renameUpdate",
        "class": "OC\\Files\\View",
        "type": "->",
        "args": [
          [
            "OCA\\Files_Trashbin\\Storage",
            null,
            [
              "OC\\Files\\Cache\\Scanner"
            ],
            null,
            null,
            [
              "OC\\Files\\Cache\\Updater"
            ]
          ],
          [
            "OCA\\Files_Trashbin\\Storage",
            null,
            [
              "OC\\Files\\Cache\\Scanner"
            ],
            null,
            null,
            [
              "OC\\Files\\Cache\\Updater"
            ]
          ],
          "files/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2024.xlsx",
          "files/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2025.xlsx"
        ]
      },
      {
        "file": "/var/www/nextcloud/apps/dav/lib/Connector/Sabre/Node.php",
        "line": 159,
        "function": "rename",
        "class": "OC\\Files\\View",
        "type": "->",
        "args": [
          "/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2024.xlsx",
          "/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2025.xlsx"
        ]
      },
      {
        "file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php",
        "line": 153,
        "function": "setName",
        "class": "OCA\\DAV\\Connector\\Sabre\\Node",
        "type": "->",
        "args": [
          "Trame de note de frais FCS-2025.xlsx"
        ]
      },
      {
        "file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
        "line": 612,
        "function": "move",
        "class": "Sabre\\DAV\\Tree",
        "type": "->",
        "args": [
          "files/user.name/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2024.xlsx",
          "files/user.name/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2025.xlsx"
        ]
      },
      {
        "file": "/var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
        "line": 89,
        "function": "httpMove",
        "class": "Sabre\\DAV\\CorePlugin",
        "type": "->",
        "args": [
          [
            "Sabre\\HTTP\\Request"
          ],
          [
            "Sabre\\HTTP\\Response"
          ]
        ]
      },
      {
        "file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 472,
        "function": "emit",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": [
          "method:MOVE",
          [
            [
              "Sabre\\HTTP\\Request"
            ],
            [
              "Sabre\\HTTP\\Response"
            ]
          ]
        ]
      },
      {
        "file": "/var/www/nextcloud/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/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 321,
        "function": "start",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/nextcloud/apps/dav/lib/Server.php",
        "line": 371,
        "function": "exec",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/nextcloud/apps/dav/appinfo/v2/remote.php",
        "line": 35,
        "function": "exec",
        "class": "OCA\\DAV\\Server",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/nextcloud/remote.php",
        "line": 172,
        "args": [
          "/var/www/nextcloud/apps/dav/appinfo/v2/remote.php"
        ],
        "function": "require_once"
      }
    ],
    "File": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",
    "Line": 41,
    "Previous": {
      "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
      "Message": "SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction",
      "Code": 1213,
      "Trace": [
        {
          "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
          "line": 103,
          "function": "new",
          "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
          "type": "::",
          "args": [
            [
              "PDOException",
              [
                "40001",
                1213,
                "Deadlock found when trying to get lock; try restarting transaction"
              ]
            ]
          ]
        },
        {
          "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1153,
          "function": "execute",
          "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/nextcloud/lib/private/DB/Connection.php",
          "line": 298,
          "function": "executeStatement",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->",
          "args": [
            "UPDATE `oc_filecache` SET `size` = ? WHERE (`fileid` = ?) AND ((`size` <> ?) OR (`size` IS NULL))",
            [
              165473361,
              "*** sensitive parameters replaced ***",
              165473361
            ],
            [
              2,
              1,
              2
            ]
          ]
        },
        {
          "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
          "line": 354,
          "function": "executeStatement",
          "class": "OC\\DB\\Connection",
          "type": "->",
          "args": [
            "UPDATE `oc_filecache` SET `size` = :dcValue3 WHERE (`fileid` = :dcValue1) AND ((`size` <> :dcValue2) OR (`size` IS NULL))",
            [
              "*** sensitive parameters replaced ***",
              165473361,
              165473361
            ],
            [
              1,
              2,
              2
            ]
          ]
        },
        {
          "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
          "line": 280,
          "function": "execute",
          "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/nextcloud/lib/private/Files/Cache/Cache.php",
          "line": 387,
          "function": "execute",
          "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/nextcloud/lib/private/Files/Cache/Cache.php",
          "line": 1035,
          "function": "update",
          "class": "OC\\Files\\Cache\\Cache",
          "type": "->",
          "args": [
            "*** sensitive parameters replaced ***"
          ]
        },
        {
          "file": "/var/www/nextcloud/lib/private/Files/Cache/Cache.php",
          "line": 953,
          "function": "calculateFolderSizeInner",
          "class": "OC\\Files\\Cache\\Cache",
          "type": "->",
          "args": [
            "files/POLE ADMIN/FONDATION/2025",
            [
              "OC\\Files\\Cache\\CacheEntry"
            ]
          ]
        },
        {
          "file": "/var/www/nextcloud/lib/private/Files/Cache/HomeCache.php",
          "line": 43,
          "function": "calculateFolderSize",
          "class": "OC\\Files\\Cache\\Cache",
          "type": "->",
          "args": [
            "files/POLE ADMIN/FONDATION/2025",
            null
          ]
        },
        {
          "file": "/var/www/nextcloud/lib/private/Files/Cache/Cache.php",
          "line": 905,
          "function": "calculateFolderSize",
          "class": "OC\\Files\\Cache\\HomeCache",
          "type": "->",
          "args": [
            "files/POLE ADMIN/FONDATION/2025",
            null
          ]
        },
        {
          "file": "/var/www/nextcloud/lib/private/Files/Cache/Cache.php",
          "line": 917,
          "function": "correctFolderSize",
          "class": "OC\\Files\\Cache\\Cache",
          "type": "->",
          "args": [
            "files/POLE ADMIN/FONDATION/2025"
          ]
        },
        {
          "file": "/var/www/nextcloud/lib/private/Files/Cache/Updater.php",
          "line": 223,
          "function": "correctFolderSize",
          "class": "OC\\Files\\Cache\\Cache",
          "type": "->",
          "args": [
            "files/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2024.xlsx"
          ]
        },
        {
          "file": "/var/www/nextcloud/lib/private/Files/View.php",
          "line": 308,
          "function": "renameFromStorage",
          "class": "OC\\Files\\Cache\\Updater",
          "type": "->",
          "args": [
            [
              "OCA\\Files_Trashbin\\Storage",
              null,
              [
                "OC\\Files\\Cache\\Scanner"
              ],
              null,
              null,
              [
                "OC\\Files\\Cache\\Updater"
              ]
            ],
            "files/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2024.xlsx",
            "files/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2025.xlsx"
          ]
        },
        {
          "file": "/var/www/nextcloud/lib/private/Files/View.php",
          "line": 824,
          "function": "renameUpdate",
          "class": "OC\\Files\\View",
          "type": "->",
          "args": [
            [
              "OCA\\Files_Trashbin\\Storage",
              null,
              [
                "OC\\Files\\Cache\\Scanner"
              ],
              null,
              null,
              [
                "OC\\Files\\Cache\\Updater"
              ]
            ],
            [
              "OCA\\Files_Trashbin\\Storage",
              null,
              [
                "OC\\Files\\Cache\\Scanner"
              ],
              null,
              null,
              [
                "OC\\Files\\Cache\\Updater"
              ]
            ],
            "files/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2024.xlsx",
            "files/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2025.xlsx"
          ]
        },
        {
          "file": "/var/www/nextcloud/apps/dav/lib/Connector/Sabre/Node.php",
          "line": 159,
          "function": "rename",
          "class": "OC\\Files\\View",
          "type": "->",
          "args": [
            "/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2024.xlsx",
            "/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2025.xlsx"
          ]
        },
        {
          "file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php",
          "line": 153,
          "function": "setName",
          "class": "OCA\\DAV\\Connector\\Sabre\\Node",
          "type": "->",
          "args": [
            "Trame de note de frais FCS-2025.xlsx"
          ]
        },
        {
          "file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
          "line": 612,
          "function": "move",
          "class": "Sabre\\DAV\\Tree",
          "type": "->",
          "args": [
            "files/user.name/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2024.xlsx",
            "files/user.name/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2025.xlsx"
          ]
        },
        {
          "file": "/var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
          "line": 89,
          "function": "httpMove",
          "class": "Sabre\\DAV\\CorePlugin",
          "type": "->",
          "args": [
            [
              "Sabre\\HTTP\\Request"
            ],
            [
              "Sabre\\HTTP\\Response"
            ]
          ]
        },
        {
          "file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
          "line": 472,
          "function": "emit",
          "class": "Sabre\\DAV\\Server",
          "type": "->",
          "args": [
            "method:MOVE",
            [
              [
                "Sabre\\HTTP\\Request"
              ],
              [
                "Sabre\\HTTP\\Response"
              ]
            ]
          ]
        },
        {
          "file": "/var/www/nextcloud/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/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
          "line": 321,
          "function": "start",
          "class": "Sabre\\DAV\\Server",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/nextcloud/apps/dav/lib/Server.php",
          "line": 371,
          "function": "exec",
          "class": "Sabre\\DAV\\Server",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/nextcloud/apps/dav/appinfo/v2/remote.php",
          "line": 35,
          "function": "exec",
          "class": "OCA\\DAV\\Server",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/nextcloud/remote.php",
          "line": 172,
          "args": [
            "/var/www/nextcloud/apps/dav/appinfo/v2/remote.php"
          ],
          "function": "require_once"
        }
      ],
      "File": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
      "Line": 30,
      "Previous": {
        "Exception": "PDOException",
        "Message": "SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction",
        "Code": "40001",
        "Trace": [
          {
            "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
            "line": 101,
            "function": "execute",
            "class": "PDOStatement",
            "type": "->",
            "args": [
              null
            ]
          },
          {
            "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
            "line": 1153,
            "function": "execute",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/nextcloud/lib/private/DB/Connection.php",
            "line": 298,
            "function": "executeStatement",
            "class": "Doctrine\\DBAL\\Connection",
            "type": "->",
            "args": [
              "UPDATE `oc_filecache` SET `size` = ? WHERE (`fileid` = ?) AND ((`size` <> ?) OR (`size` IS NULL))",
              [
                165473361,
                "*** sensitive parameters replaced ***",
                165473361
              ],
              [
                2,
                1,
                2
              ]
            ]
          },
          {
            "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
            "line": 354,
            "function": "executeStatement",
            "class": "OC\\DB\\Connection",
            "type": "->",
            "args": [
              "UPDATE `oc_filecache` SET `size` = :dcValue3 WHERE (`fileid` = :dcValue1) AND ((`size` <> :dcValue2) OR (`size` IS NULL))",
              [
                "*** sensitive parameters replaced ***",
                165473361,
                165473361
              ],
              [
                1,
                2,
                2
              ]
            ]
          },
          {
            "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
            "line": 280,
            "function": "execute",
            "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/nextcloud/lib/private/Files/Cache/Cache.php",
            "line": 387,
            "function": "execute",
            "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/nextcloud/lib/private/Files/Cache/Cache.php",
            "line": 1035,
            "function": "update",
            "class": "OC\\Files\\Cache\\Cache",
            "type": "->",
            "args": [
              "*** sensitive parameters replaced ***"
            ]
          },
          {
            "file": "/var/www/nextcloud/lib/private/Files/Cache/Cache.php",
            "line": 953,
            "function": "calculateFolderSizeInner",
            "class": "OC\\Files\\Cache\\Cache",
            "type": "->",
            "args": [
              "files/POLE ADMIN/FONDATION/2025",
              [
                "OC\\Files\\Cache\\CacheEntry"
              ]
            ]
          },
          {
            "file": "/var/www/nextcloud/lib/private/Files/Cache/HomeCache.php",
            "line": 43,
            "function": "calculateFolderSize",
            "class": "OC\\Files\\Cache\\Cache",
            "type": "->",
            "args": [
              "files/POLE ADMIN/FONDATION/2025",
              null
            ]
          },
          {
            "file": "/var/www/nextcloud/lib/private/Files/Cache/Cache.php",
            "line": 905,
            "function": "calculateFolderSize",
            "class": "OC\\Files\\Cache\\HomeCache",
            "type": "->",
            "args": [
              "files/POLE ADMIN/FONDATION/2025",
              null
            ]
          },
          {
            "file": "/var/www/nextcloud/lib/private/Files/Cache/Cache.php",
            "line": 917,
            "function": "correctFolderSize",
            "class": "OC\\Files\\Cache\\Cache",
            "type": "->",
            "args": [
              "files/POLE ADMIN/FONDATION/2025"
            ]
          },
          {
            "file": "/var/www/nextcloud/lib/private/Files/Cache/Updater.php",
            "line": 223,
            "function": "correctFolderSize",
            "class": "OC\\Files\\Cache\\Cache",
            "type": "->",
            "args": [
              "files/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2024.xlsx"
            ]
          },
          {
            "file": "/var/www/nextcloud/lib/private/Files/View.php",
            "line": 308,
            "function": "renameFromStorage",
            "class": "OC\\Files\\Cache\\Updater",
            "type": "->",
            "args": [
              [
                "OCA\\Files_Trashbin\\Storage",
                null,
                [
                  "OC\\Files\\Cache\\Scanner"
                ],
                null,
                null,
                [
                  "OC\\Files\\Cache\\Updater"
                ]
              ],
              "files/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2024.xlsx",
              "files/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2025.xlsx"
            ]
          },
          {
            "file": "/var/www/nextcloud/lib/private/Files/View.php",
            "line": 824,
            "function": "renameUpdate",
            "class": "OC\\Files\\View",
            "type": "->",
            "args": [
              [
                "OCA\\Files_Trashbin\\Storage",
                null,
                [
                  "OC\\Files\\Cache\\Scanner"
                ],
                null,
                null,
                [
                  "OC\\Files\\Cache\\Updater"
                ]
              ],
              [
                "OCA\\Files_Trashbin\\Storage",
                null,
                [
                  "OC\\Files\\Cache\\Scanner"
                ],
                null,
                null,
                [
                  "OC\\Files\\Cache\\Updater"
                ]
              ],
              "files/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2024.xlsx",
              "files/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2025.xlsx"
            ]
          },
          {
            "file": "/var/www/nextcloud/apps/dav/lib/Connector/Sabre/Node.php",
            "line": 159,
            "function": "rename",
            "class": "OC\\Files\\View",
            "type": "->",
            "args": [
              "/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2024.xlsx",
              "/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2025.xlsx"
            ]
          },
          {
            "file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php",
            "line": 153,
            "function": "setName",
            "class": "OCA\\DAV\\Connector\\Sabre\\Node",
            "type": "->",
            "args": [
              "Trame de note de frais FCS-2025.xlsx"
            ]
          },
          {
            "file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
            "line": 612,
            "function": "move",
            "class": "Sabre\\DAV\\Tree",
            "type": "->",
            "args": [
              "files/user.name/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2024.xlsx",
              "files/user.name/POLE ADMIN/FONDATION/2025/Trame de note de frais FCS-2025.xlsx"
            ]
          },
          {
            "file": "/var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
            "line": 89,
            "function": "httpMove",
            "class": "Sabre\\DAV\\CorePlugin",
            "type": "->",
            "args": [
              [
                "Sabre\\HTTP\\Request"
              ],
              [
                "Sabre\\HTTP\\Response"
              ]
            ]
          },
          {
            "file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
            "line": 472,
            "function": "emit",
            "class": "Sabre\\DAV\\Server",
            "type": "->",
            "args": [
              "method:MOVE",
              [
                [
                  "Sabre\\HTTP\\Request"
                ],
                [
                  "Sabre\\HTTP\\Response"
                ]
              ]
            ]
          },
          {
            "file": "/var/www/nextcloud/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/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
            "line": 321,
            "function": "start",
            "class": "Sabre\\DAV\\Server",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/nextcloud/apps/dav/lib/Server.php",
            "line": 371,
            "function": "exec",
            "class": "Sabre\\DAV\\Server",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/nextcloud/apps/dav/appinfo/v2/remote.php",
            "line": 35,
            "function": "exec",
            "class": "OCA\\DAV\\Server",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/nextcloud/remote.php",
            "line": 172,
            "args": [
              "/var/www/nextcloud/apps/dav/appinfo/v2/remote.php"
            ],
            "function": "require_once"
          }
        ],
        "File": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
        "Line": 101
      }
    },
    "message": "An exception occurred while executing a query: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction",
    "exception": [],
    "CustomMessage": "An exception occurred while executing a query: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction"
  },
  "id": "6685080b4497d"
}

Additional info

No response

@solracsf solracsf added bug 0. Needs triage Pending check for reproducibility or if it fits our roadmap 28-feedback labels Jul 3, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 28-feedback bug
Projects
None yet
Development

No branches or pull requests

1 participant