Failure when writing to Cosmos MongoDB Service

[dgomezc]

Describe the bug
When writing to a Cosmos MongoDB service from a generated app we get the following error:
"Retryable writes are not supported. Please disable retryable writes by specifying "retrywrites=false" in the connection string or an equivalent driver specific config."

To Reproduce
Steps to reproduce the behavior:

1. Launch Web Templates Studio
2. Select any frontend and backend framework
3. Add a List page and a Cosmos DB Service with MongoDB
4. Click create
5. Accept connection string replacement dialog
6. Start the app
7. Try to add something to the list
8. See error

[dgomezc]

To solve this, add the property retryWrites = false in your backend framework:

• Node/Express:
  • Open backend/mongo/mongoConnect.js file.
  • In connect function, add useUnifiedTopology: true and retryWrites: false below useNewUrlParser: true.

function connect() {
  mongoose
    .connect(`${process.env.COSMOSDB_CONNSTR}?ssl=true&replicaSet=globaldb`, {
      auth: {
        user: process.env.COSMOSDB_USER,
        password: process.env.COSMOSDB_PASSWORD
      },
      useNewUrlParser: true,
      useUnifiedTopology: true,
      retryWrites: false
    })
    .then(() => console.log("Connection to CosmosDB successful"))
    .catch(err => console.error(err));
}

• Flask:
  • Open backend/src/mongo/client.py file.
  • Add retryWrites=false to connection string in MongoClient().

client = MongoClient(connection_str + '?ssl=true&replicaSet=globaldb&retryWrites=false')

• ASP.NET
  • Open backend/startup.cs file.
  • In InitializeCosmosClientInstance() method add settings.RetryWrites = false; before return new MongoClient(settings);.

private IMongoClient InitializeCosmosClientInstance()
{
   var connectionString = Configuration["COSMOSDB_CONNSTR"];
   var userName = Configuration["COSMOSDB_USER"];
   var dbName = Configuration["COSMOSDB_DB_NAME"];
   var password = Configuration["COSMOSDB_PASSWORD"];
   
   var settings = MongoClientSettings.FromConnectionString(connectionString);
   
   var identity = new MongoInternalIdentity(dbName, userName);
   var evidence = new PasswordEvidence(password);
   settings.Credential = new MongoCredential("SCRAM-SHA-1", identity, evidence);
   
   settings.UseTls = true;
   settings.SslSettings = new SslSettings() { EnabledSslProtocols = SslProtocols.Tls12 };
   settings.RetryWrites = false;
   
   return new MongoClient(settings);
}

• Moleculer
  • Open backend/mixins/db.mixin.js file.
  • In MongoAdapter constructor, add retryWrites: false below useUnifiedTopology: true.

adapter: new MongoAdapter(
  `${process.env.COSMOSDB_CONNSTR}?ssl=true&replicaSet=globaldb`,
  {
    auth: {
      user: process.env.COSMOSDB_USER,
      password: process.env.COSMOSDB_PASSWORD
    },
    useNewUrlParser: true,
    useUnifiedTopology: true,
retryWrites: false
  }
),

[prupipho]

Fixed and tested in version: 0.5.2104801