nextcloud/lib/public/DB/QueryBuilder
Carl Schwan f3778bc9c7
fix(propagator): Improve lock behavior of propagator
Fix possible dead locks when running the propagator caused by two
requests updating the same amount rows in transactions.

- Lock rows always in the same deterministic order by sorting the
  path_hash first

- On all database outside of sqlite, also do first a SELECT FOR UPDATE
  to lock all the rows used in batch UPDATE calls, afterward to decrease
  the risk of two requests trying to lock the same rows

Signed-off-by: Carl Schwan <carlschwan@kde.org>
2026-02-09 12:10:56 +01:00
..
Sharded feat: implement distributing partitioned queries over multiple shards 2024-08-28 10:21:19 +02:00
ConflictResolutionMode.php fix(propagator): Improve lock behavior of propagator 2026-02-09 12:10:56 +01:00
ICompositeExpression.php chore: Add SPDX header 2024-05-24 13:11:22 +02:00
IExpressionBuilder.php style: update codestyle for coding-standard 1.2.3 2024-08-25 19:34:58 +02:00
IFunctionBuilder.php refactor: Prefer using IFunctionBuilder than createFunction 2026-01-23 16:58:38 +01:00
ILiteral.php chore: Add SPDX header 2024-05-24 13:11:22 +02:00
IParameter.php chore: Add SPDX header 2024-05-24 13:11:22 +02:00
IQueryBuilder.php fix(propagator): Improve lock behavior of propagator 2026-02-09 12:10:56 +01:00
IQueryFunction.php chore: Add SPDX header 2024-05-24 13:11:22 +02:00