summaryrefslogtreecommitdiff
path: root/jstests/sharding/transactions_snapshot_errors_subsequent_statements.js
blob: f346a8eea48ba0552cb74a3aaaad1831dc681e57 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
// Tests mongos behavior on snapshot errors encountered during subsequent statements in a
// multi-statement transaction. In particular, verifies that snapshot errors beyond the first
// command in a transaction are fatal to the entire transaction.
//
// Runs against an unsharded collection, a sharded collection with all chunks on one shard, and a
// sharded collection with one chunk on both shards.
//
// @tags: [requires_sharding, uses_transactions]
(function() {
    "use strict";

    load("jstests/sharding/libs/sharded_transactions_helpers.js");

    const dbName = "test";
    const collName = "foo";
    const ns = dbName + '.' + collName;

    const kCommandTestCases = [
        {name: "aggregate", command: {aggregate: collName, pipeline: [], cursor: {}}},
        {name: "distinct", command: {distinct: collName, query: {}, key: "_id"}},
        {name: "find", command: {find: collName}},
        {
          // findAndModify can only target one shard, even in the two shard case.
          name: "findAndModify",
          command: {findAndModify: collName, query: {_id: 1}, update: {$set: {x: 1}}}
        },
        {name: "insert", command: {insert: collName, documents: [{_id: 1}, {_id: 11}]}},
        {
          name: "update",
          command: {
              update: collName,
              updates: [{q: {_id: 1}, u: {$set: {_id: 2}}}, {q: {_id: 11}, u: {$set: {_id: 12}}}]
          }
        },
        {
          name: "delete",
          command:
              {delete: collName, deletes: [{q: {_id: 2}, limit: 1}, {q: {_id: 12}, limit: 1}]}
        },
        // We cannot test killCursors because mongos discards the response from any killCursors
        // requests that may be sent to shards.
    ];

    function runTest(st, collName, errorCode) {
        const session = st.s.startSession();
        const sessionDB = session.getDatabase(dbName);

        for (let commandTestCase of kCommandTestCases) {
            const commandName = commandTestCase.name;
            const commandBody = commandTestCase.command;

            // Successfully start a transaction on one shard.
            session.startTransaction({readConcern: {level: "snapshot"}});
            assert.commandWorked(sessionDB.runCommand({find: collName, filter: {_id: 15}}));

            // Verify the command must fail on a snapshot error from a subsequent statement.
            setFailCommandOnShards(st, {times: 1}, [commandName], errorCode, 1);
            const res = assert.commandFailedWithCode(sessionDB.runCommand(commandBody),
                                                     ErrorCodes.NoSuchTransaction);
            assert.eq(res.errorLabels, ["TransientTransactionError"]);

            session.abortTransaction();
        }
    }

    const st = new ShardingTest({shards: 2, mongos: 1, config: 1});

    jsTestLog("Unsharded transaction");

    assert.writeOK(st.s.getDB(dbName)[collName].insert({_id: 5}, {writeConcern: {w: "majority"}}));
    st.ensurePrimaryShard(dbName, st.shard0.shardName);

    // Single shard case simulates the storage engine discarding an in-use snapshot.
    for (let errorCode of kSnapshotErrors) {
        runTest(st, collName, errorCode);
    }

    assert.commandWorked(st.s.adminCommand({enableSharding: dbName}));
    st.ensurePrimaryShard(dbName, st.shard0.shardName);
    assert.commandWorked(st.s.adminCommand({shardCollection: ns, key: {_id: 1}}));

    // Set up 2 chunks, [minKey, 10), [10, maxKey), each with one document (includes the document
    // already inserted).
    assert.commandWorked(st.s.adminCommand({split: ns, middle: {_id: 10}}));
    assert.writeOK(st.s.getDB(dbName)[collName].insert({_id: 15}, {writeConcern: {w: "majority"}}));

    jsTestLog("One shard transaction");

    assert.eq(2, st.s.getDB('config').chunks.count({ns: ns, shard: st.shard0.shardName}));
    assert.eq(0, st.s.getDB('config').chunks.count({ns: ns, shard: st.shard1.shardName}));

    for (let errorCode of kSnapshotErrors) {
        runTest(st, collName, errorCode);
    }

    jsTestLog("Two shard transaction");

    assert.commandWorked(
        st.s.adminCommand({moveChunk: ns, find: {_id: 15}, to: st.shard1.shardName}));
    assert.eq(1, st.s.getDB('config').chunks.count({ns: ns, shard: st.shard0.shardName}));
    assert.eq(1, st.s.getDB('config').chunks.count({ns: ns, shard: st.shard1.shardName}));

    // Multi shard case simulates adding a new participant that can no longer support the already
    // chosen read timestamp.
    for (let errorCode of kSnapshotErrors) {
        runTest(st, collName, errorCode);
    }

    st.stop();
})();