[COMPASS-4715] 'prepareTransaction' is not supported for replica sets with arbiters Created: 16/Mar/21 Updated: 27/Oct/23 Resolved: 08/Feb/23 |
|
| Status: | Closed |
| Project: | Compass |
| Component/s: | Compass, CRUD |
| Affects Version/s: | 1.26.0 |
| Fix Version/s: | No version |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Kaushik Das | Assignee: | Unassigned |
| Resolution: | Works as Designed | Votes: | 1 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
MongoDB 4.2.3 Community |
||
| Attachments: |
|
||||||||||||
| Issue Links: |
|
||||||||||||
| Documentation Changes: | Not Needed | ||||||||||||
| UserVoice Links: | Error 1) Update operation was converted into a distributed transaction because the document being updated would move shards and that transaction failed. :: caused by :: from shard shard one :: caused by :: 'prepareTransaction' is not supported for replica sets with arbiters
connection string in compass : &w=1&readConcernLevel=linearizable&readPreference=primary&appname=MongoDB%20Compass&retryWrites=true&directConnection=false&ssl=false |
||||||||||||
| Description |
| Comments |
| Comment by Maurizio Casimirri [ 08/Feb/23 ] |
|
kaushik.phpcoder@gmail.com transactions have a known limitation with shards and PSAs. Transactions whose write operations span multiple shards will error and abort if any transaction operation reads from or writes to a shard that contains an arbiter: https://www.mongodb.com/docs/manual/core/transactions-sharded-clusters/#multiple-shards I'm going to close this as "Work as designed" as it is not a Compass issue. Feel free to open a SERVER ticket in the future if you have similar issues. |
| Comment by Anna Henningsen [ 02/Dec/22 ] |
|
Confirmed that:
Practically speaking though, it seems like there is nothing that Compass could do about the first issue here. |
| Comment by Jessica Sigafoos [ 04/May/22 ] |
|
Hi kaushik.phpcoder@gmail.com, following up on this. Are you still seeing this issue with the latest version of Compass? We believe the second issue was resolved by |
| Comment by Jessica Sigafoos [ 07/Apr/22 ] |
|
Hi kaushik.phpcoder@gmail.com, are you still seeing this issue with the latest version of Compass? Thanks! |
| Comment by Jessica Sigafoos [ 23/Mar/22 ] |
|
kaushik.phpcoder@gmail.com are you still seeing this issue with the latest version of Compass? Thanks! |
| Comment by Kaushik Das [ 30/Mar/21 ] |
|
for 1st case Same error is coming while doing the update on shell. |
| Comment by Massimiliano Marcon [ 24/Mar/21 ] |
|
kaushik.phpcoder@gmail.com |