The following tasks are locking frequently. Centos 7, Maria

[heydoon]

The online users task seems to be getting locked a lot. There are some others that also get locked.

I'm running Centos 7 , MariaDB with data engine set to InnoDB.

My PHP memory limit is set to 256mb

[bfarber]

Do you have any errors in your System Logs? Are you using cron or activity-based tasks?

[heydoon]

No system or error logs. I forgot to mention I’m also using redis php.

Using cron based tasks I believe, they run on a schedule.

these are the tasks it seems to be happening to the most. clearsessions, onlineusers and userAgentStatistics.

I also noticed that view updates says it’s getting ran but doesn’t actually update. If I run it manually it updates fine.

edit: I’m not using cron but will switch to a cron job. I’ll let everyone know how it works out

 

[heydoon]

Update: Cron has been running for 30 minutes without issue.

Edit: It's been an hour now, and no more locks. Looks like that did it. Not sure what caused it though.

[bfarber]

We identified this as a bug which will be fixed in 4.3.3. In some cases, the Redis connection is getting closed before the task runs.