Streams: for $merge to sharded collections not sharded on _id, need to include shard key in upsert requests

XMLWordPrintableJSON

    • Atlas Streams
    • Fully Compatible
    • ALL
    • Sprint 33, Sprint 34, Sprint 35, Sprint 36, Sprint 37
    • 30
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      Create a shard collection with key that isn't _id. $merge writes will send things to the DLQ with:
      {
      _id: ObjectId("651d8464f0b07ba2ac0ce8a3"),
      _stream_meta:

      { timestamp: ISODate("2023-10-04T15:27:32.278Z") }

      ,
      errInfo: {
      reason: 'Failed to process an input document in the current batch in MergeOperator with error: Failed to target upsert by query :: could not extract exact shard key: generic server error'
      }
      }

            Assignee:
            Sandeep Dhoot
            Reporter:
            Matthew Normyle
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: