AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Mysql deadlock12/19/2023 ![]() $this->db->where('interaction_id', $interact_value) $select_query = $this->db->query("SELECT COUNT(*) AS total FROM `scorm_interactions` WHERE `mod_id`='".$modid."' AND `course_id`='".$cid."' AND `user_id`='".$uid."' AND `interaction_id`='".$interact_value."'") UPDATE t_first - transaction 2 waits for transaction 1 to release the lock on t_first. UPDATE t_second - transaction 1 waits for transaction 2 to release the lock on t_second UPDATE t_second - transaction 2 locks t_second UPDATE t_first - transacion 1 locks t_first How do you deal with database transaction deadlocks in PHP code?
0 Comments
Read More
Leave a Reply. |