diff options
| author | Robin Appelman <robin@icewind.nl> | 2024-07-31 17:17:54 +0200 |
|---|---|---|
| committer | Louis Chemineau <louis@chmn.me> | 2024-08-28 10:21:20 +0200 |
| commit | e538f4699d73e286469848f4a5378ac50f6378df (patch) | |
| tree | bba2d45c8b3430e94b19bc9d24d6a514112b2127 /apps | |
| parent | 80a25531f73c436660458fbe88acd07c9ed6434b (diff) | |
| download | nextcloud-server-e538f4699d73e286469848f4a5378ac50f6378df.tar.gz nextcloud-server-e538f4699d73e286469848f4a5378ac50f6378df.zip | |
fix: adjust systemtag orphan cleanup query to work with sharding
Signed-off-by: Robin Appelman <robin@icewind.nl>
Diffstat (limited to 'apps')
| -rw-r--r-- | apps/files/lib/BackgroundJob/DeleteOrphanedItems.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/apps/files/lib/BackgroundJob/DeleteOrphanedItems.php b/apps/files/lib/BackgroundJob/DeleteOrphanedItems.php index 0d6a632db1a..32fb569a3d4 100644 --- a/apps/files/lib/BackgroundJob/DeleteOrphanedItems.php +++ b/apps/files/lib/BackgroundJob/DeleteOrphanedItems.php @@ -59,8 +59,8 @@ class DeleteOrphanedItems extends TimedJob { $query->select('t1.' . $idCol) ->from($table, 't1') ->where($query->expr()->eq($typeCol, $query->expr()->literal('files'))) - ->andWhere($query->expr()->isNull('t2.fileid')) ->leftJoin('t1', 'filecache', 't2', $query->expr()->eq($query->expr()->castColumn('t1.' . $idCol, IQueryBuilder::PARAM_INT), 't2.fileid')) + ->andWhere($query->expr()->isNull('t2.fileid')) ->groupBy('t1.' . $idCol) ->setMaxResults(self::CHUNK_SIZE); |