atlas mongodb serverless and aws lambda connection issue

Question

I have got a serverless db on atlas (https://www.mongodb.com/serverless). I used the connection string recommended by ATLAS:

mongodb+srv://<username>:<password>@xyz.esxbh.mongodb.net/myFirstDatabase?retryWrites=true&w=majority

however as soon as i try to create a record, i get the following error:

{"errorType":"Runtime.UnhandledPromiseRejection","errorMessage":"MongoParseError: Text record must only set `authSource` or `replicaSet`","reason":{"errorType":"MongoParseError","errorMessage":"Text record must only set `authSource` or `replicaSet`","name":"MongoParseError","stack":["MongoParseError: Text record must only set `authSource` or `replicaSet`","

I don't think that the connection string is correct, on the other hand the dns entry for the server does reply with 2 servers.

I tried dropping the '+srv' part, however in that case the save function from mongoose just hangs forever timing out the lambda function.

I could not find any similar problem on google.

The TXT entry record from the dns server shows:

"TXT    "authSource=admin&loadBalanced=true"

How have you configured the serverless database to work?

The code that generates the error depends on mongoose and is as follows:

        try {
          const customer = new Customer(cust);
          console.log('new cusotmer created');
          const returnedCustomer = await customer.save();
          console.log(returnedCustomer);
          return serverResponse(200, returnedCustomer);
        } catch(err){
          console.log(err);
          return errorHandler(500, err)
        }

It seems that the connection to the database is fine:

try {
    await dbTools.connectMongoose();
    console.log('*** connected ***');

} catch(err){
    console.log('error when connecting');
    return errorHandler(500, err);
}

Now, looking at the source code, nothing really too complicated:

if (Object.keys(record).some(key => key !== 'authSource' && key !== 'replicaSet')) {
  return callback(
    new MongoParseError('Text record must only set `authSource` or `replicaSet`')
  );
}

I am now really struggling to understand what's wrong as authSource seems to be present in the TXT record.

The actual connection string looks fine, what line of the code generates this error? — Tom Slabbaert
– Tom Slabbaert, Commented Aug 1, 2021 at 9:54
Hey thanks for both answers. I cannot remove loadBalanced=true as this is a service provided by atlas. re- the code that generates the error, it's a simple mongoose save() function: try { const customer = new Customer(cust); console.log('new cusotmer created'); const returnedCustomer = await customer.save(); console.log(returnedCustomer); return serverResponse(200, returnedCustomer); } catch(err){ console.log(err); return errorHandler(500, err) } — LordVee
– LordVee, Commented Aug 3, 2021 at 6:58
@ArbazSiddiqui I think your solution is right, problem is I don't control the server's dns — LordVee
– LordVee, Commented Aug 3, 2021 at 20:22

Zia Ullah · Accepted Answer · 2021-09-10 09:47:45Z

11

Upgrading mongoose to the latest version worked for me in Nodejs.

Remove "mongoose" from package.json.
Reinstall "npm i mongoose"
"mongoose version 6.0.5" should work.

Worked on 10-Sep-2021

answered Sep 10, 2021 at 9:47

Zia Ullah

3323 silver badges12 bronze badges

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

2 Comments

BaiMaoli Over a year ago

Yeah, It is working well. Thanks for your answer, I was also having same issue and you saved me in that.

Zia Ullah Over a year ago

Glad to learn that I helped you :)

asgs · Accepted Answer · 2023-05-07 19:46:02Z

1

For anyone still experiencing this in 2022, here is an answer from a MongoDB employee (at the bottom). It's a native Node.js driver issue (nothing to do with AWS lambda specifically), which will waterfall to all ODM implementations that implement the native driver.

https://www.mongodb.com/community/forums/t/atlas-serverless-and-dns-txt-record/117967/9

According to Zia Ullah's answer to this same question, this is fixed by Mongoose 6.0.5.

edited May 7, 2023 at 19:46

asgs

4,0026 gold badges42 silver badges57 bronze badges

answered Aug 12, 2022 at 12:19

Michael Jay

5936 silver badges19 bronze badges

Comments

davidaharlow · Accepted Answer · 2023-06-21 15:32:09Z

0

If you are getting this error while using mongoimport or another item of mongodb-database-tools, then upgrade your tools to version 100.5.x or later

for mac: brew upgrade mongodb-database-tools

https://www.mongodb.com/docs/atlas/reference/serverless-instance-limitations/

https://www.mongodb.com/docs/database-tools/installation/installation-macos/

answered Jun 21, 2023 at 15:32

davidaharlow

1191 silver badge4 bronze badges

Collectives™ on Stack Overflow

atlas mongodb serverless and aws lambda connection issue

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related