TYPO3 Core

Can confirm this.

Deleting and recreating the linkvalidator task fixes the issue (but does not solve the underlying problem).

Michael Sollmann wrote in #note-1:

Can confirm this.

Deleting and recreating the linkvalidator task fixes the issue (but does not solve the underlying problem).

Thanks for the confirmation and the temp solution. Setting the regarding task as deleted in the table "tx_scheduler_task" fixed the issue.

I have that error as well --> crashes the whole scheduler module with a 503

I've just had the issue with the last 12.4.19.

I guess the cause is that depth has been serialized as string (for an unknown reason) :

s:8:" * depth";s:3:"999" 

I think we can delete the task and recreate it. For us it was a very old task (created in 2021).

Had the same problem. Here is an updater class that hopefully helps someone:

namespace VENDOR\MySitePackage\Updates;

use TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\CMS\Core\Database\Query\QueryBuilder;
use TYPO3\CMS\Core\Utility\GeneralUtility;
use TYPO3\CMS\Install\Attribute\UpgradeWizard;
use TYPO3\CMS\Install\Updates\UpgradeWizardInterface;

#[UpgradeWizard('mySitePackage_SchedulerTaskUpgradeWizard')]
final class SchedulerTaskUpgradeWizard implements UpgradeWizardInterface
{
    /**
     * Returns the title of the upgrade wizard
     *
     * @return string
     */
    public function getTitle(): string
    {
        return 'mySitePackage_SchedulerTaskUpgradeWizard';
    }

    /**
     * Returns the description of the upgrade wizard
     *
     * @return string
     */
    public function getDescription(): string
    {
        return 'Updates LinkValidator serialized task objects.';
    }

    /**
     * Executes the update
     *
     * @return bool
     */
    public function executeUpdate(): bool
    {
        $rows = $this->getRecords();

        foreach ($rows as $row) {
            $uid = $row['uid'];
            $serializedTaskObject = $row['serialized_task_object'];
            $serializedTaskObject = preg_replace('/depth";s:[\d]+:"(\d+)"/', 'depth";i:$1', $serializedTaskObject);
            $serializedTaskObject = preg_replace('/page";s:[\d]+:"(\d+)"/', 'page";i:$1', $serializedTaskObject);
            $serializedTaskObject = preg_replace('/emailOnBrokenLinkOnly";i:(\d+)/', 'emailOnBrokenLinkOnly";b:$1', $serializedTaskObject);

            $queryBuilder = $this->getQueryBuilder();
            $queryBuilder->update('tx_scheduler_task')
                ->where(
                    $queryBuilder->expr()->eq('uid', $queryBuilder->createNamedParameter($uid))
                )
                ->set('serialized_task_object', $serializedTaskObject)
                ->executeStatement();
        }

        return false;
    }

    /**
     * Checks if the update is necessary
     *
     * @return bool
     */
    public function updateNecessary(): bool
    {
        $rows = $this->getRecords();
        return !empty($rows);
    }

    /**
     * Returns the pre-requisites for the upgrade wizard
     *
     * @return array
     */
    public function getPrerequisites(): array
    {
        return [];
    }

    protected function getRecords(): array
    {
        $queryBuilder = $this->getQueryBuilder();

        return $queryBuilder->select('uid', 'serialized_task_object')
            ->from('tx_scheduler_task')
            ->where(
                $queryBuilder->expr()->or(
                    $queryBuilder->expr()->like(
                        'serialized_task_object',
                        $queryBuilder->createNamedParameter('%depth";s:%')
                    ),
                    $queryBuilder->expr()->like(
                        'serialized_task_object',
                        $queryBuilder->createNamedParameter('%page";s:%')
                    ),
                    $queryBuilder->expr()->like(
                        'serialized_task_object',
                        $queryBuilder->createNamedParameter('%emailOnBrokenLinkOnly";i:%')
                    )
                )
            )
            ->executeQuery()
            ->fetchAllAssociative();
    }

    /**
     * Returns an instance of the QueryBuilder
     *
     * @return QueryBuilder
     */
    protected function getQueryBuilder(): QueryBuilder
    {
        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)
            ->getQueryBuilderForTable('tx_scheduler_task');

        $queryBuilder->getRestrictions()->removeAll();

        return $queryBuilder;
    }
}