Page 1 of 1

Cron job hanging

Posted: 20 Jan 2017 09:01
by Sillen42
Hi.

Every morning a cron job is started at 05:01.
It's a standard job that is part of EFA and not any modification is done to it.
At that time and every hour after that there is CROND process running.

Every morning I kill a database connection for a command (se below) and after that all is well.
"DELETE i.*, m.* FROM mtalog AS m LEFT OUTER JOIN mtalog_ids AS i ON i.smtp_id = m.msg_id WHERE m.timestamp < (NOW() - INTERVAL 1 DAY)"

I have reinstalled EFA and the problem is back again.

Anybody that has experienced anything like this or why it happens?

/Lennart.

Re: Cron job hanging

Posted: 20 Jan 2017 18:13
by shawniverson
If anyone else is having issues, please chime in. I wonder if this is similar to the database lock issue another user was experiencing.