DisableTransactions in MongoDB, debugging Cosmos DB for MongoDB

[elier]

Describe the bug

Not sure if the DisableTransactions option is being taken into consideration when passed, in the code it looks like hardcode to false, and never used:

remult/projects/core/remult-mongo.ts

Line 37 in fc2f5c6

disableTransactions = false

My code:

MongoDataProvider(client.db((process.env as any).MONGODB_DATABASE_NAME), client, { disableTransactions: true });

I wanted to disable transactions because I'm getting the following error:

Error=2, Details='Response status code does not indicate success: BadRequest (400); Substatus: 1101; ActivityId: 4a5f881b-e63d-4756-981e-23b60d6428e4; Reason: (Response status code does not indicate success: BadRequest (400); Substatus: 1101; ActivityId: 4a5f881b-e63d-4756-981e-23b60d6428e4; Reason: (Response status code does not indicate success: BadRequest (400); Substatus: 1101; ActivityId: 4a5f881b-e63d-4756-981e-23b60d6428e4; Reason: (Message: {"Errors":["Transaction is not active"]}

[noam-honig]

Thanks.
I've fixed it in version 0.22.1 (https://github.com/remult/remult/releases/tag/v0.22.1)

Can you check it and let me know that it's ok?

[elier]

Yes! { disableTransactions: true } works now!

I still got the following error from Cosmos DB if I set disableTransaction to false.

Reason: (Message: {"Errors":["Transaction is not active"]}

According to Cosmos DB for MongoDB documentation:
Multi-document transactions are supported within an unsharded collection in API version 4.0. Multi-document transactions are not supported across collections or in sharded collections in 4.0.
https://learn.microsoft.com/en-us/azure/cosmos-db/mongodb/use-multi-document-transactions

I'm using Cosmos DB 4.2 API, and unsharded collection. However, two simple reading operations from a static backendMethod cause Cosmos DB to trigger the error.

I guess, I won't be able to use transactions, cause any backendMethod just reading more than one collection will fail.

[noam-honig]

Are you still getting the error?

…

On Tue, Jul 25, 2023 at 14:26 Elier Delgado ***@***.***> wrote: Closed #215 <#215> as completed. — Reply to this email directly, view it on GitHub <#215 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AD65PUZ5MU7ODMKA5NXZN5LXR6UM3ANCNFSM6AAAAAA2WMHCJQ> . You are receiving this because you commented.Message ID: ***@***.***>

[elier]

No, if I set disableTransaction to true, all works fine.

[noam-honig]

Perfect - I thought you had another error - I'm happy that you don't. Cheers

…

On Tue, Jul 25, 2023 at 3:16 PM Elier Delgado ***@***.***> wrote: No, if I set disableTransaction to true, all works fine. — Reply to this email directly, view it on GitHub <#215 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AD65PU3Z7NIPW3BP7JT2B2LXR62KZANCNFSM6AAAAAA2WMHCJQ> . You are receiving this because you commented.Message ID: ***@***.***>