Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-62685

WiredTigerIdIndex has write conflict when prepared transaction is aborted and immediately retried

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 5.3.0-rc1
    • Affects Version/s: 5.3 Required
    • Component/s: None
    • None
    • Fully Compatible
    • ALL
    • Hide

      The error is reproducible. Diff:

      diff --git a/jstests/core/txns/commit_prepared_transaction_errors.js b/jstests/core/txns/commit_prepared_transaction_errors.js
      index 64b27f3c16c..9fee9fd7870 100644
      --- a/jstests/core/txns/commit_prepared_transaction_errors.js
      +++ b/jstests/core/txns/commit_prepared_transaction_errors.js
      @@ -23,6 +23,10 @@ const doc = {
           _id: 1
       };
       
      +const ITERS=1000;
      +for (var i=0; i<ITERS; i++) {
      +jsTestLog("ITERATION " + i);
      +
       jsTestLog("Test committing a prepared transaction with no 'commitTimestamp'.");
       session.startTransaction();
       assert.commandWorked(sessionColl.insert(doc));
      @@ -69,4 +73,6 @@ jsTestLog("Test committing an unprepared transaction with an invalid 'commitTime
       session.startTransaction();
       assert.commandWorked(sessionColl.insert(doc));
       assert.commandFailedWithCode(PrepareHelpers.commitTransaction(session, 5), ErrorCodes.TypeMismatch);
      +
      +}
       }());
      
      Show
      The error is reproducible. Diff: diff --git a/jstests/core/txns/commit_prepared_transaction_errors.js b/jstests/core/txns/commit_prepared_transaction_errors.js index 64b27f3c16c..9fee9fd7870 100644 --- a/jstests/core/txns/commit_prepared_transaction_errors.js +++ b/jstests/core/txns/commit_prepared_transaction_errors.js @@ -23,6 +23,10 @@ const doc = { _id: 1 }; + const ITERS=1000; + for ( var i=0; i<ITERS; i++) { +jsTestLog( "ITERATION " + i); + jsTestLog( "Test committing a prepared transaction with no 'commitTimestamp' ." ); session.startTransaction(); assert .commandWorked(sessionColl.insert(doc)); @@ -69,4 +73,6 @@ jsTestLog("Test committing an unprepared transaction with an invalid 'commitTime session.startTransaction(); assert .commandWorked(sessionColl.insert(doc)); assert .commandFailedWithCode(PrepareHelpers.commitTransaction(session, 5), ErrorCodes.TypeMismatch); + +} }());
    • 19

      The commit_prepared_transaction_errors.js test is reproducing the situation when a prepared transaction fails because it has no commitTimestamp and then is aborted with `abortTransaction_forTesting()`. The next transaction started for the same data entry fails in WiredTigerIdIndex::_insert with:

      "WiredTigerIdIndex::_insert: index: _id_; uri: table:index-161--1657325371758770379 :: caused by :: WriteConflict
      

      I verified that the conflict happens in the C-level code `__wt_cursor int __F(insert)(WT_CURSOR *cursor)`. I verified that the `WiredTigerItem keyItem` passed to both transactions is identical, so almost certainly it means the previous index key was not removed from WT table when the transaction abort already returned.

        1. bad.json
          37 kB
          Gregory Wlodarek
        2. debug.diff
          12 kB
          Gregory Wlodarek
        3. ok.json
          33 kB
          Gregory Wlodarek
        4. test.js
          2 kB
          Gregory Wlodarek

            Assignee:
            andrew.morton@mongodb.com Andrew Morton
            Reporter:
            andrew.shuvalov@mongodb.com Andrew Shuvalov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            13 Start watching this issue

              Created:
              Updated:
              Resolved: