Couldn't creat Assignment- ERROR message:"..deadlock found when trying to get lock.."

Couldn't creat Assignment- ERROR message:"..deadlock found when trying to get lock.."

by Miki Alliel -
Number of replies: 4
Picture of Translators

Some teachers weren't able to create  an Assignment (without any special settings) by settings only title, instructions they get this message: "debug info deadlock found when trying to get lock. try restarting transaction delete from mdl_event where modulename = ? AND instance =? AND EVENTYPE..."

See image.error-adding-assignment

It happens sometimes with out any indications. Sometimes it works fine and sometimes we can't create assignments and getting this Error message.

Appreciate any help , please.

Thanks a lot

Average of ratings: -
In reply to Miki Alliel

Re: Couldn't creat Assignment- ERROR message:"..deadlock found when trying to get lock.."

by Emma Richardson -
Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Plugin developers
It looks like the database might be getting jammed up. Have you tried restarting server/s? Are you seeing other problems on the site? Operating system? Single server setup? Hosted/nonhosted? Moodle version?
In reply to Emma Richardson

Re: Couldn't creat Assignment- ERROR message:"..deadlock found when trying to get lock.."

by Miki Alliel -
Picture of Translators
Emma thanks,
Yes we tried to restart server and database but it still happenning.
no other problems for now.
any idea?
our Moodle is 3.7
In reply to Miki Alliel

Re: Couldn't creat Assignment- ERROR message:"..deadlock found when trying to get lock.."

by Emma Richardson -
Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Plugin developers
Try going into moodleDATA folder and deleting cache and localcache to see if it is a cached page causing issues...