Project

General

Profile

Actions
Copy link

Bug #25615

closed

Scheduler floods sys_log in endless loop if a task is running and multiple executions isn't allowed

Added by Christian Kuhn about 15 years ago. Updated almost 11 years ago.

Status:
Closed
Priority:
Must have
Assignee:
Francois Suter
Category:
scheduler
Target version:
-
Start date:
2009-09-26
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

How to reproduce:
- Create a sleep test task with 300 seconds
- Call the scheduler cli to start the 5 minute task
- Call a second cli while the first cli is still running. This cli will only end after the first cli terminated, hammering sys_log table as fast as it can with messages like "[scheduler]: Task is already running and multiple executions are not allowed, skipping! Class: tx_scheduler_SleepTask, UID: 3"

This is because the fetchTask() in the cli class fetches the running task again and again so that hasTask will never be false:
The following queries will be executed in an endless loop until the first cli terminates:

157 Query       SELECT serialized_task_object
            FROM tx_scheduler_task
            WHERE
                disable = 0 AND nextexecution != 0 AND nextexecution <= 1253990423
            LIMIT 1
157 Query       SELECT serialized_executions
            FROM tx_scheduler_task
            WHERE
                uid = 3
            LIMIT 1
157 Query       INSERT INTO sys_log
                (
                    userid,
                    type,
                    action,
                    error,
                    details_nr,
                    details,
                    log_data,
                    tablename,
                    recuid,
                    IP,
                    tstamp,
                    event_pid,
                    NEWid,
                    workspace
                ) VALUES (
                    '20',
                    '4',
                    '0',
                    '0',
                    '0',
                    '[scheduler]: Task is already running and multiple executions are not allowed, skipping! Class: tx_scheduler_SleepTask, UID: 3',
                    'a:0:{}',
                    '',
                    '0',
                    '',
                    '1253990423',
                    '-1',
                    '',
                    '0'
                )

(issue imported from #M12068)

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Bug #90614: TYPO3 scheduler floods sys_log with "Task is already running and multiple executions are not allowed, skipping!"Rejected2020-03-02

Actions
Actions
Copy link

Also available in: Atom PDF