delete cronjob schedule logs directly by sql to avoid memory issues, fixes #5386

Closes #5386

Merge request studip/studip!4273

1 files changed, 7 insertions, 1 deletions

diff --git a/lib/models/CronjobSchedule.class.php b/lib/models/CronjobSchedule.class.php
index e3e81e9..05baa34 100644
--- a/lib/models/CronjobSchedule.class.php
+++ b/lib/models/CronjobSchedule.class.php
@@ -67,7 +67,13 @@ class CronjobSchedule extends SimpleORMap
         ];
         $config['has_many']['logs'] = [
             'class_name' => CronjobLog::class,
-            'on_delete'  => 'delete',
+            'on_delete'  => function (CronjobSchedule $schedule) {
+                // Direct db query to avoid memory issues
+                return DBManager::get()->execute(
+                    'DELETE FROM cronjobs_logs WHERE schedule_id = ?',
+                    [$schedule->id]
+                );
+            },
             'on_store'   => 'store',
         ];