[SERVER-77890] Investigate failure to create Database with 'operation was interrupted' error Created: 07/Jun/23  Updated: 07/Jul/23  Resolved: 07/Jul/23

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

Type: Bug Priority: Major - P3
Reporter: Adi Zaimi Assignee: Adi Zaimi
Resolution: Won't Fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Sharding NYC
Operating System: ALL
Participants:

 Description   

As part of the sharded test suite being added for the FCV upgrade/downgrade project, there is a failure to create a database with 'operation was interrupted' error. Looking at the log, it seems we attempt to abort an internal txn when the fcv downgrade command is received, but we can't find the txn in question:
"Unable to abort internal transaction","attr":
{
reason: "NoSuchTransaction: Transaction with

{ txnNumber: 0 }

has been aborted."...
This happened in several cases:
https://parsley.mongodb.com/resmoke/adaafb25f3c051dbeadc18fc1cf6e2c3/test/1764e1cc8fb4fb64fa1c0967d7e4f127?bookmarks=0,71,104,111,133,136,841&shareLine=111

also: https://parsley.mongodb.com/resmoke/c714af65f0168ccef874ff70d13425a3/test/1764e1c69f9e9aa04d5f30dee4d2e15e?bookmarks=0,57&shareLine=0



 Comments   
Comment by Adi Zaimi [ 07/Jul/23 ]

We found a workaround in the project to catch this failure in a test script and retry the operation. This works well in that we dont have failures anymore in those tests. Since this is an expected behavior, as Sergi and Paolo suggest, there is nothing more to do for this ticket.

Comment by Adi Zaimi [ 07/Jul/23 ]

We found a workaround in the project to catch this failure in a test script and retry the operation. This works well in that we dont have failures anymore in those tests. Since this is an expected behavior, as Sergi and Paolo suggest, there is nothing more to do for this ticket.

Comment by Paolo Polato [ 15/Jun/23 ]

Since SERVER-71755, the creation of a database on a sharded cluster implies the execution of a transaction in the config server to persist catalog and historical metadata.

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