[SERVER-39985] Improve transaction lock failure error message Created: 06/Mar/19  Updated: 29/Oct/23  Resolved: 26/Jun/19

Status: Closed
Project: Core Server
Component/s: Diagnostics
Affects Version/s: None
Fix Version/s: 4.3.1

Type: Improvement Priority: Major - P3
Reporter: Bruce Lucas (Inactive) Assignee: Gregory Wlodarek
Resolution: Fixed Votes: 2
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-39902 lockInfo should use UUIDCatalog to ma... Closed
Related
related to SERVER-39984 Log all failed transaction statements Closed
related to SERVER-40915 Show view namespaces in the LockManag... Closed
Backwards Compatibility: Fully Compatible
Sprint: Execution Team 2019-07-01
Participants:
Case:

 Description   

The error message when a transaction statement is unable to acquire a lock within the timeout is cryptic, making it difficult to identify the conflicting operation:

Unable to acquire lock '{7817449386782089629: Database, 899920359141007773}'

Would it be possible to include more information that could help pinpoint the cause of the conflict, for example

  • conflicting database or collection name
  • connection number of client holding the lock
  • operation id holding the lock
  • name of operation holding the lock


 Comments   
Comment by Githook User [ 26/Jun/19 ]

Author:

{'name': 'Gregory Wlodarek', 'username': 'GWlodarek', 'email': 'gregory.wlodarek@mongodb.com'}

Message: SERVER-39985 Improve transaction lock failure error message
Branch: master
https://github.com/mongodb/mongo/commit/b7bb12280b83b0b5e7e9386354a10156ce2f2cd3

Comment by Gregory Wlodarek [ 21/Jun/19 ]

SERVER-39902 added conflicting database or collection names to the output. Previously it was only available in debug builds. Right now we're also working on adding view names to the output in SERVER-40915.

I'll look at the remaining requests in this ticket.

Generated at Thu Feb 08 04:53:42 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.