Scheduled Jobs - Clean-up job Failed

[Enju]

Hello,
Job: Clean-up always has status: Failed.
The biggest problem is that after Cron tries to execute Job: "Clean-up", the job "process Pending Flows" stops as well.
Do you have any suggestions how to fix it?

[Maximus]

Hi,
How this issue described in the EspoCRM log?
Do you have only the problem with the "Clean-up" job?

[Enju]

I tried to start Job today at 7.30.

The log file in DEBUG mode looks like attached: I do not see any error in it regarding this task.

[item]

Hello,

application/Espo/Jobs/Cleanup.php. do this

$this->cleanupJobs();
$this->cleanupScheduledJobLog();
$this->cleanupAttachments();
$this->cleanupEmails();
$this->cleanupNotifications();
$this->cleanupActionHistory();
$this->cleanupAuthToken();
$this->cleanupAuthLog();
$this->cleanupUpgradeBackups();
$this->cleanupUniqueIds();
$this->cleanupDeletedRecords();

comment one and execute : php command.php run-job Cleanup
if good, repeat with other , comment one and execute .. so you can find where is failled.

[Enju]

Thanks for the suggestions item and thanks to you I solved the problem. I encountered a problem doing: cleanupNotifications:

PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 16384 bytes)

I deleted the records directly from the database and since then the CleanUp Job has been executed.

[Wzhik]

The cleanup command doesn't work for me either.
When performing cleaning, such an error:

Error: Job 'Cleanup' failed to execute. SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

I can't change mysql settings - the application works on a regular hosting

It was possible to find out that the problem is in the task

$this->cleanup Attachments();

More than 12,000 files have accumulated in the /data/upload folder

Is there a way to make the task of cleaning attachments work?

[item]

Hi,
maybe, test at your risk:

go to admin/attachments : set primary filter : Orphan
delete all find

https://demo.eu.espocrm.com/?l=en_GB#Admin/attachments

or modify this some data and try :

https://github.com/espocrm/espocrm/blob/66b06b8baaa0ee89021d5a9694e241c5ff8284a1/application/Espo/Classes/Jobs/Cleanup.php#L303

run cleanUp job manually
remove manually deleted record ( sql delete from ..where deleted=1 )