Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-4715

'prepareTransaction' is not supported for replica sets with arbiters

    • Type: Icon: Bug Bug
    • Resolution: Works as Designed
    • Priority: Icon: Major - P3 Major - P3
    • No version
    • Affects Version/s: 1.26.0
    • Component/s: Compass, CRUD
    • None
    • Environment:
      MongoDB 4.2.3 Community
      All Installed in Ubuntu 18 LTS
      2Shards, each shard have PSA nodes
      One mongos router
    • Not Needed
    • Hide

      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
      2)Query for sharded findAndModify must contain the shard key

       

      connection string in compass : &w=1&readConcernLevel=linearizable&readPreference=primary&appname=MongoDB%20Compass&retryWrites=true&directConnection=false&ssl=false
       

      Show
      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 2)Query for sharded findAndModify must contain the shard key   connection string in compass : &w=1&readConcernLevel=linearizable&readPreference=primary&appname=MongoDB%20Compass&retryWrites=true&directConnection=false&ssl=false  

      Problem Description

      1) We have 2 shards and each shard have PSA architecture in MongoDB 4.2.3 Community, while updating shard key from the compass, compass is throwing this error.

      My connection String parameters  &w=1&readConcernLevel=linearizable&readPreference=primary&appname=MongoDB%20Compass&retryWrites=true&directConnection=false&ssl=false

      2) While updating other field it is showing "

      Query for sharded findAndModify must contain the shard key
       " this error

      Steps to Reproduce

      Expected Results

      Actual Results

      Additional Notes

            Assignee:
            Unassigned Unassigned
            Reporter:
            kaushik.phpcoder@gmail.com Kaushik Das
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: