There are loads of threads on this issue, none of which have solutions that work for me. I am using NestJS, TypeORM, and Cosmos DB Mongo API.
I am running the NestJS service on my machine, hitting the Database in Azure. I can read from collections fine, but any time I try to write, I get the following error:
MongoError: Retryable writes are not supported. Please disable retryable writes by specifying "retrywrites=false" in the connection string or an equivalent driver specific config.
A stripped down version of the logic that is saving to the DB. The object I am saving works fine when doing db.collection.save() in Mongo Shell in Azure. But the exact same save() fails here
@Injectable()
export class PatientService {
constructor(
@InjectRepository(PatientsByUser)
private readonly patientsByUserRepo: MongoRepository<PatientsByUser>
) {}
async addPatientToFavoritesList() {
this.patientsByUserRepo.save({
email: "test",
patientList: [{
accountNumber: 1,
firstName: "test",
lastName: "test",
dob: "test"
}]
})
}
}
Here is the module that configures TypeORM:
import {HttpModule, Module} from '@nestjs/common';
import {ConfigModule} from "@nestjs/config";
import {TypeOrmModule} from "@nestjs/typeorm";
import {PatientService} from "./patient.service";
import {PatientController} from "./patient.controller";
import {PatientsByUser} from "./patient.entity";
@Module({
imports: [
HttpModule,
ConfigModule.forRoot(),
TypeOrmModule.forRoot({
type: 'mongodb',
url: process.env.MONGODB_CONNECTION_STRING,
database: process.env.MONGODB_DATABASE,
entities: [
__dirname + '/**/*.entity{.ts,.js}',
],
ssl: true,
useUnifiedTopology: true,
useNewUrlParser: true,
}),
TypeOrmModule.forFeature([PatientsByUser])
],
providers: [PatientService],
controllers: [PatientController],
exports: [PatientService]
})
export class PatientModule {}
My connection string does contain retrywrites=false. I also tried retryWrites=false, and tried both at the end of the connection string. Neither worked.
MONGODB_CONNECTION_STRING=mongodb://portal-db-dev:<private>==@portal-db-dev.mongo.cosmos.azure.com:10255/?ssl=true&replicaSet=globaldb&retrywrites=false&maxIdleTimeMS=120000&appName=@portal-db-dev@
Our Cosmos DB is version 4. I am aware that rolling back to 3.2 would fix this, but that would be suboptimal, and completely absurd on Microsoft's part if thats the only way out of this.
package.json
{
"name": "portal-be",
"version": "0.0.1",
"description": "",
"author": "",
"private": true,
"license": "UNLICENSED",
"scripts": {
"prebuild": "rimraf dist",
"build": "nest build && mkdir dist/src/assets && cp -r src/assets/* dist/src/assets",
"format": "prettier --write \"src/**/*.ts\" \"test/**/*.ts\"",
"start": "nest start",
"start:dev": "nest start --watch",
"start:debug": "nest start --debug --watch",
"start:prod": "node dist/main",
"lint": "eslint \"{src,apps,libs,test}/**/*.ts\" --fix",
"test": "jest",
"test:watch": "jest --watch",
"test:cov": "jest --coverage",
"test:debug": "node --inspect-brk -r tsconfig-paths/register -r ts-node/register node_modules/.bin/jest --runInBand",
"test:e2e": "jest --config ./test/jest-e2e.json"
},
"dependencies": {
"@nestjs/common": "^7.6.13",
"@nestjs/config": "^0.6.3",
"@nestjs/core": "^7.6.13",
"@nestjs/passport": "^7.1.5",
"@nestjs/platform-express": "^7.6.13",
"@nestjs/swagger": "^4.7.15",
"@nestjs/typeorm": "^7.1.5",
"@types/mongodb": "^3",
"@types/passport-azure-ad": "^4.0.8",
"class-transformer": "^0.4.0",
"class-validator": "^0.13.1",
"dotenv": "^8.2.0",
"jwt-decode": "^3.1.2",
"moment": "^2.29.1",
"mongodb": "^3.6.9",
"passport": "^0.4.1",
"passport-azure-ad": "^4.3.0",
"reflect-metadata": "^0.1.13",
"rimraf": "^3.0.2",
"rxjs": "^6.6.7",
"soap": "^0.39.0",
"typeorm": "^0.2.32"
},
"devDependencies": {
"@nestjs/cli": "^7.5.6",
"@nestjs/schematics": "^7.2.7",
"@nestjs/testing": "^7.6.13",
"@types/express": "^4.17.11",
"@types/jest": "^26.0.20",
"@types/mongodb": "^3",
"@types/node": "^14.14.31",
"@types/supertest": "^2.0.10",
"@typescript-eslint/eslint-plugin": "^4.15.2",
"@typescript-eslint/parser": "^4.15.2",
"eslint": "^7.20.0",
"eslint-config-prettier": "^8.1.0",
"eslint-plugin-prettier": "^3.3.1",
"jest": "^26.6.3",
"prettier": "^2.2.1",
"supertest": "^6.1.3",
"ts-jest": "^26.5.2",
"ts-loader": "^8.0.17",
"ts-node": "^9.1.1",
"tsconfig-paths": "^3.9.0",
"typescript": "^4.1.5"
},
"jest": {
"moduleFileExtensions": [
"js",
"json",
"ts"
],
"rootDir": "src",
"testRegex": ".*\\.spec\\.ts$",
"transform": {
"^.+\\.(t|j)s$": "ts-jest"
},
"collectCoverageFrom": [
"**/*.(t|j)s"
],
"coverageDirectory": "../coverage",
"testEnvironment": "node"
}
}
