We've got "Deadlock" Errors on our Quickbuild server, when users are trying to run their build.
I've looked forward our server's console.log file, and it saids "Deadlock found when trying to get lock".
Here's the logs that I've found, below.
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s)
MySQL thread id 30, OS thread handle 139904000202496, query id 42624890 10.166.111.60 quick_admin updating
/* update com.pmease.quickbuild.model.Configuration */ update QB_CONFIGURATION set QB_STATUS_DATE='2021-03-23 11:13:53.773' where QB_ID=35
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 86 page no 68 n bits 80 index PRIMARY of table `QUICKBUILD`.`QB_CONFIGURATION` trx id 4568257 lock_mode X locks rec but not gap waiting
Record lock, heap no 7 PHYSICAL RECORD: n_fields 53; compact format; info bits 0
So, the question is, Is there any solution exist that we can resolve this problem?
I know this problem belongs to DB side, but on the other hand, this deadlock issue comes from the table that quickbuild uses.
So, I'm wondering if there's any solution that you have in mind.
Please let me know with joyful answer. :)