mongodb update operation with aggregation pipeline results in error code 14

Question

i'm trying to update the value of a field with the value of another field of a document. mongodb docs say it's possible by using an aggregation pipeline as described here.

even the sample code from the docs results in an TypeMismatch code 14 error.

command:

db.members.update(
   { },
   [
      { $set: { status: "Modified", comments: [ "$misc1", "$misc2" ] } },
      { $unset: [ "misc1", "misc2" ] }
   ],
   { multi: true }
)

result:

WriteCommandError({
    "operationTime" : Timestamp(1561779602, 1),
    "ok" : 0,
    "errmsg" : "BSON field 'update.updates.u' is the wrong type 'array', expected type 'object'",
    "code" : 14,
    "codeName" : "TypeMismatch",
    "$clusterTime" : {
        "clusterTime" : Timestamp(1561779602, 1),
        "signature" : {
            "hash" : BinData(0,"AAAAAAAAAAAAAAAAAAAAAAAAAAA="),
            "keyId" : NumberLong(0)
        }
    }
})

is this an actual bug in mongodb or am i missing something?

Can you tell me your mongodb version?

Ravi Shankar Bharti
– Ravi Shankar Bharti

2019-06-29 05:24:18 +00:00
Commented Jun 29, 2019 at 5:24 — Ravi Shankar Bharti
– Ravi Shankar Bharti, Commented Jun 29, 2019 at 5:24
@RaviShankarBharti server is 4.0.6

Dĵ ΝιΓΞΗΛψΚ
– Dĵ ΝιΓΞΗΛψΚ

2019-06-29 05:28:31 +00:00
Commented Jun 29, 2019 at 5:28 — Dĵ ΝιΓΞΗΛψΚ
– Dĵ ΝιΓΞΗΛψΚ, Commented Jun 29, 2019 at 5:28

Ravi Shankar Bharti · Accepted Answer · 2019-06-29 05:31:08Z

16

I think what you are facing is a mongodb version issue.

According to the official documentation :

Update with Aggregation Pipeline

Starting in MongoDB 4.2, the db.collection.update() can use an aggregation pipeline for the update. The pipeline can consist of the following stages:

$addFields and its alias $set

$project and its alias $unset

$replaceRoot and its alias $replaceWith.

You can see that this support is available from mongodb version 4.2, And thats why it is throwing you that error.

answered Jun 29, 2019 at 5:31

Ravi Shankar Bharti

9,2786 gold badges31 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Dĵ ΝιΓΞΗΛψΚ Over a year ago

ah yes... i missed that bit of info. thanks for the answer!

SpacedMonkey Over a year ago

I have the same problem but I am using 4.2, what now? > version() 4.2.0

SpacedMonkey Over a year ago

Sorry. Turns out the version was coming from the shell, not the database which is version 4.0.8

Ravi Shankar Bharti Over a year ago

@SpacedMonkey so, were you able to update the version and resolve the issue? or do you still need help with something?

SpacedMonkey Over a year ago

@RaviShankarBharti I updated to the new version and it worked just as it should, thanks

|

Collectives™ on Stack Overflow

mongodb update operation with aggregation pipeline results in error code 14

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related