[SERVER-60840] Create an FSM workload test that perform DDL and multi-shard multi-stmt transactions Created: 20/Oct/21  Updated: 04/Dec/23

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

Type: Task Priority: Major - P3
Reporter: Jordi Serra Torrens Assignee: Backlog - Catalog and Routing
Resolution: Unresolved Votes: 0
Labels: oldshardingemea, shardingemea-qw
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Catalog and Routing
Sprint: Sharding EMEA 2021-11-29, Sharding EMEA 2021-12-13, Sharding EMEA 2021-12-27, Sharding EMEA 2022-01-10
Participants:
Story Points: 2

 Description   

Currently we have no FSM workloads that runs sharded DDL + multi-shard multi-statement transactions. This allowed bugs like SERVER-59965 to go unnoticed.

We should create an workload that tests that. We could either:
a) Write a specific workload to do this, similarly to random_moveChunk_broadcast_update_transaction.js
b) Perhaps we can use the concurrency_sharded_multi_stmt_txn suite and change random_DDL_CRUD_operations.js to put chunks in different shards and do CRUD that targets several shards.


Generated at Thu Feb 08 05:50:52 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.