History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: QB-3692
Type: Bug Bug
Status: Closed Closed
Resolution: Incomplete
Priority: Major Major
Assignee: Robin Shen
Reporter: Cheolhee Jeon
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
QuickBuild

quickbuild's run build give us "Deadlock found when trying to get lock" error frequently.

Created: 29/Mar/21 07:28 AM   Updated: 08/Jan/22 10:15 AM
Component/s: None
Affects Version/s: 10.0.15
Fix Version/s: None

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown
Environment: ubuntu 16.04 LTS ( Linux (3.10.0-1127.el7.x86_64 ) / mysql 5.7.30


 Description  « Hide
Hello,
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. :)

Thanks,
Nick.

 All   Comments   Work Log   Change History      Sort Order:
No work has yet been logged on this issue.