Nightscout crash: "MongoDB connection failed! Double check the MONGODB_URI setting in Heroku"

[philipgo]

Describe the bug Every day or so my Nightscout crashes with the error message "MongoDB connection failed! Double check the MONGODB_URI setting in Heroku."

The problem appears to be with Nightscout (or AndroidAPS??), I do not need to restart the MongoDB instance and other Nightscout instances continue to work with the same MONGODB_URI without any issues. However I do need to manually restart the Nightscout instance.

Expected behavior Nightscout should not crash or if it does it should recover automatically.

Screenshots

Your setup information MongoDB self hosted on a private server, Nightscout Docker (latest dev, but same issue on master) hosted on a different private server. My uploader is AndroidAPS 2.8.1.1

Logs

nightscout_1  | DEDUPE: Devicestatus exact match
nightscout_1  | /opt/app/node_modules/mongodb/lib/utils.js:668
nightscout_1  |           throw error;
nightscout_1  |           ^
nightscout_1  |
nightscout_1  | TypeError: Cannot read property '0' of undefined
nightscout_1  |     at findResult (/opt/app/lib/server/websocket.js:414:32)
nightscout_1  |     at /opt/app/node_modules/mongodb/lib/utils.js:665:9
nightscout_1  |     at handleCallback (/opt/app/node_modules/mongodb/lib/utils.j                                                                                                                                                             s:102:55)
nightscout_1  |     at /opt/app/node_modules/mongodb/lib/cursor.js:834:20
nightscout_1  |     at /opt/app/node_modules/mongodb/lib/core/cursor.js:736:9
nightscout_1  |     at Object.callback (/opt/app/node_modules/mongodb/lib/core/c                                                                                                                                                             ursor.js:432:11)
nightscout_1  |     at Timeout._onTimeout (/opt/app/node_modules/mongodb/lib/cor                                                                                                                                                             e/sdam/topology.js:443:25)
nightscout_1  |     at listOnTimeout (internal/timers.js:554:17)
nightscout_1  |     at processTimers (internal/timers.js:497:7)
nightscout_1  | Executing startBoot
nightscout_1  | Executing checkNodeVersion
nightscout_1  | Node LTS version v14.15.3 is supported
nightscout_1  | Executing checkEnv
nightscout_1  | Executing augmentSettings
nightscout_1  | Parsing config URL from IMPORT_CONFIG failed
nightscout_1  | Executing checkSettings
nightscout_1  | Checking settings
nightscout_1  | Executing setupStorage
nightscout_1  | Setting up new connection to MongoDB
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 3 sec
nightscout_1  | ERROR CONNECTING TO MONGO Error: MongoDB connection failed! Doub                                                                                                                                                             le check the MONGODB_URI setting in Heroku.
nightscout_1  |     at connect_with_retry (/opt/app/lib/storage/mongo-storage.js                                                                                                                                                             :70:28)
nightscout_1  |     at processTicksAndRejections (internal/process/task_queues.j                                                                                                                                                             s:93:5)
nightscout_1  | Mongo Storage system ready
nightscout_1  | Executing setupAuthorization
nightscout_1  | Executing setupInternals
nightscout_1  | Executing ensureIndexes
nightscout_1  | Executing setupListeners
nightscout_1  | Executing setupBridge
nightscout_1  | Executing setupMMConnect
nightscout_1  | Executing finishBoot
nightscout_1  | Boot event processing completed
nightscout_1  | Security settings: INSECURE_USE_HTTP= true , SECURE_HSTS_HEADER=                                                                                                                                                              false
nightscout_1  | Listening on port 1337 b2d084333cfc
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 6 sec
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 9 sec
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 12 sec
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 15 sec
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 18 sec
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 21 sec
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 24 sec
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 27 sec
nightscout_1  | Successfully established a connected to MongoDB
nightscout_1  | Mongo user role seems ok: [ { role: 'readWrite', db: 'nightscout'                                                                                                                                                              } ]
nightscout_1  | Mongo Storage system ready

[sulkaharo]

Right - would it be possible for you to deploy this branch, so we'll see what the error is. Looks like you're hitting a previously unreported bug and sadly the current build doesn't log the error that's happening. https://github.com/nightscout/cgm-remote-monitor/pull/6777

[sulkaharo]

The branch is here: https://github.com/nightscout/cgm-remote-monitor/tree/websocket_dedupe_error

[philipgo]

I have deployed the websocket_dedupe_error branch and will wait for it to crash again and get back to you. Thank you for looking into this!

[philipgo]

Here are the logs of a crash running your websocket_dedupe_errorbranch: (The MongoDB logs show nothing exceptional)

nightscout_1  | devicestatus insertion error:  getaddrinfo EAI_AGAIN mongo.xyz.de
nightscout_1  | DEDUPE: Exact match
nightscout_1  | /opt/app/node_modules/mongodb/lib/utils.js:668
nightscout_1  |           throw error;
nightscout_1  |           ^
nightscout_1  |
nightscout_1  | TypeError: Cannot read property '0' of undefined
nightscout_1  |     at findResult (/opt/app/lib/server/websocket.js:326:32)
nightscout_1  |     at /opt/app/node_modules/mongodb/lib/utils.js:665:9
nightscout_1  |     at handleCallback (/opt/app/node_modules/mongodb/lib/utils.j                                                                                                                                                             s:102:55)
nightscout_1  |     at /opt/app/node_modules/mongodb/lib/cursor.js:834:20
nightscout_1  |     at /opt/app/node_modules/mongodb/lib/core/cursor.js:736:9
nightscout_1  |     at Object.callback (/opt/app/node_modules/mongodb/lib/core/c                                                                                                                                                             ursor.js:432:11)
nightscout_1  |     at Timeout._onTimeout (/opt/app/node_modules/mongodb/lib/cor                                                                                                                                                             e/sdam/topology.js:443:25)
nightscout_1  |     at listOnTimeout (internal/timers.js:554:17)
nightscout_1  |     at processTimers (internal/timers.js:497:7)
nightscout_1  | Executing startBoot
nightscout_1  | Executing checkNodeVersion
nightscout_1  | Node LTS version v14.15.3 is supported
nightscout_1  | Executing checkEnv
nightscout_1  | Executing augmentSettings
nightscout_1  | Parsing config URL from IMPORT_CONFIG failed
nightscout_1  | Executing checkSettings
nightscout_1  | Checking settings
nightscout_1  | Executing setupStorage
nightscout_1  | Setting up new connection to MongoDB
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 3 sec
nightscout_1  | ERROR CONNECTING TO MONGO Error: MongoDB connection failed! Doub                                                                                                                                                             le check the MONGODB_URI setting in Heroku.
nightscout_1  |     at connect_with_retry (/opt/app/lib/storage/mongo-storage.js                                                                                                                                                             :70:28)
nightscout_1  |     at processTicksAndRejections (internal/process/task_queues.j                                                                                                                                                             s:93:5)
nightscout_1  | Mongo Storage system ready
nightscout_1  | Executing setupAuthorization
nightscout_1  | Executing setupInternals
nightscout_1  | Executing ensureIndexes
nightscout_1  | Executing setupListeners
nightscout_1  | Executing setupBridge
nightscout_1  | Executing setupMMConnect
nightscout_1  | Executing finishBoot
nightscout_1  | Boot event processing completed
nightscout_1  | Security settings: INSECURE_USE_HTTP= true , SECURE_HSTS_HEADER=                                                                                                                                                              false
nightscout_1  | Listening on port 1337 dace99d2d2ce
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 6 sec
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 9 sec
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 12 sec
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 15 sec
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 18 sec
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 21 sec
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 24 sec
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 27 sec
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 30 sec
nightscout_1  | Error connecting to MongoDB: {"name":"MongoServerSelectionError"                                                                                                                                                             ,"reason":{"type":"Single","setName":null,"maxSetVersion":null,"maxElectionId":n                                                                                                                                                             ull,"servers":{},"stale":false,"compatible":true,"compatibilityError":null,"logi                                                                                                                                                             calSessionTimeoutMinutes":null,"heartbeatFrequencyMS":10000,"localThresholdMS":1                                                                                                                                                             5,"commonWireVersion":null}} - retrying in 33 sec
nightscout_1  | Successfully established a connected to MongoDB
nightscout_1  | Mongo user role seems ok: [ { role: 'readWrite', db: 'nightscout'                                                                                                                                                              } ]
nightscout_1  | Mongo Storage system ready

[ghost]

I have just deployed the latest and got the same error straight away.

[sulkaharo]

Dammit, @philipgo can you update to latest in the branch, there were two additional error spots like this, which now also capture the error. Btw how do you host the site? Based on the URL this is your own setup? Which Mongo version do you have? @lukebrogan Same to you - how are you hosting the site?

[ghost]

Hello! I am deploying to Heroku 20 stack. URL is https://cgm-luke.herokuapp.com/ Let me know if you need anything else. Many thanks.

[philipgo]

@sulkaharo Thank you, Sulka, already deployed. My MongoDB version is v4.2.11. MongoDB is self hosted on a private server, Nightscout Docker hosted on a different private server behind an nginx reverse proxy. My uploader is AndroidAPS 2.8.1.1. I have never found anything in the MongoDB logs which could point to the cause.

@lukebrogan Your error may not be the same as mine. If your site never works: are you sure your MongoDB_URI is correct? My site works fine for hours or sometimes days, then it crashes.

[ghost]

Yeah you are right - it was an error in the MongoDB_URI string, all working for me now 👍

[philipgo]

Here are the logs of another crash running the latest websocket_dedupe_error branch.

Some googling showed others are seeing similar errors in connection with useUnifiedTopology: true which was changed here recently.

nightscout_1  | WS: dbAdd client ID:  PbvoXQ5Gg6ZgtauSAABP  data:  {
nightscout_1  |   collection: 'treatments',
nightscout_1  |   data: {
nightscout_1  |     eventType: 'Temp Basal',
nightscout_1  |     duration: 60,
nightscout_1  |     absolute: 0,
nightscout_1  |     rate: 0,
nightscout_1  |     created_at: '2021-01-23T09:00:13Z',
nightscout_1  |     enteredBy: 'openaps://AndroidAPS',
nightscout_1  |     NSCLIENT_ID: '1611392413159'
nightscout_1  |   }
nightscout_1  | }
nightscout_1  | MongoServerSelectionError: getaddrinfo EAI_AGAIN mongo.xyz.de
nightscout_1  |     at Timeout._onTimeout (/opt/app/node_modules/mongodb/lib/core/sdam/topology.js:438:30)
nightscout_1  |     at listOnTimeout (internal/timers.js:554:17)
nightscout_1  |     at processTimers (internal/timers.js:497:7) {
nightscout_1  |   reason: TopologyDescription {
nightscout_1  |     type: 'Single',
nightscout_1  |     setName: null,
nightscout_1  |     maxSetVersion: null,
nightscout_1  |     maxElectionId: null,
nightscout_1  |     servers: Map(1) {
nightscout_1  |       'mongo.xyz.de:27017' => [ServerDescription]
nightscout_1  |     },
nightscout_1  |     stale: false,
nightscout_1  |     compatible: true,
nightscout_1  |     compatibilityError: null,
nightscout_1  |     logicalSessionTimeoutMinutes: null,
nightscout_1  |     heartbeatFrequencyMS: 10000,
nightscout_1  |     localThresholdMS: 15,
nightscout_1  |     commonWireVersion: 8
nightscout_1  |   }
nightscout_1  | }
nightscout_1  | devicestatus insertion error:  getaddrinfo EAI_AGAIN mongo.xyz.de
nightscout_1  | got data-received event, requesting reload
nightscout_1  | Problem loading entries
nightscout_1  | Problem loading activity data
nightscout_1  | Problem loading database stats
nightscout_1  | Load Complete:
nightscout_1  |     sgvs:576, profiles:1, food:2
nightscout_1  | data loaded: reloading sandbox data and updating plugins
nightscout_1  | OpenAPS hasn't reported a loop yet
nightscout_1  | MongoServerSelectionError: getaddrinfo EAI_AGAIN mongo.xyz.de
nightscout_1  |     at Timeout._onTimeout (/opt/app/node_modules/mongodb/lib/core/sdam/topology.js:438:30)
nightscout_1  |     at listOnTimeout (internal/timers.js:554:17)
nightscout_1  |     at processTimers (internal/timers.js:497:7) {
nightscout_1  |   reason: TopologyDescription {
nightscout_1  |     type: 'Single',
nightscout_1  |     setName: null,
nightscout_1  |     maxSetVersion: null,
nightscout_1  |     maxElectionId: null,
nightscout_1  |     servers: Map(1) {
nightscout_1  |       'mongo.xyz.de:27017' => [ServerDescription]
nightscout_1  |     },
nightscout_1  |     stale: false,
nightscout_1  |     compatible: true,
nightscout_1  |     compatibilityError: null,
nightscout_1  |     logicalSessionTimeoutMinutes: null,
nightscout_1  |     heartbeatFrequencyMS: 10000,
nightscout_1  |     localThresholdMS: 15,
nightscout_1  |     commonWireVersion: 8
nightscout_1  |   }
nightscout_1  | }
nightscout_1  | devicestatus insertion error:  getaddrinfo EAI_AGAIN mongo.xyz.de
nightscout_1  | MongoServerSelectionError: getaddrinfo EAI_AGAIN mongo.xyz.de
nightscout_1  |     at Timeout._onTimeout (/opt/app/node_modules/mongodb/lib/core/sdam/topology.js:438:30)
nightscout_1  |     at listOnTimeout (internal/timers.js:554:17)
nightscout_1  |     at processTimers (internal/timers.js:497:7) {
nightscout_1  |   reason: TopologyDescription {
nightscout_1  |     type: 'Single',
nightscout_1  |     setName: null,
nightscout_1  |     maxSetVersion: null,
nightscout_1  |     maxElectionId: null,
nightscout_1  |     servers: Map(1) {
nightscout_1  |       'mongo.xyz.de:27017' => [ServerDescription]
nightscout_1  |     },
nightscout_1  |     stale: false,
nightscout_1  |     compatible: true,
nightscout_1  |     compatibilityError: null,
nightscout_1  |     logicalSessionTimeoutMinutes: null,
nightscout_1  |     heartbeatFrequencyMS: 10000,
nightscout_1  |     localThresholdMS: 15,
nightscout_1  |     commonWireVersion: 8
nightscout_1  |   }
nightscout_1  | }
nightscout_1  | WS: dbAdd client ID:  PbvoXQ5Gg6ZgtauSAABP  data:  {
nightscout_1  |   collection: 'devicestatus',
nightscout_1  |   data: {
nightscout_1  |     device: 'openaps://samsung SM-G960F',
nightscout_1  |     pump: {
nightscout_1  |       clock: '2021-01-23T08:55:30Z',
nightscout_1  |       reservoir: 187,
nightscout_1  |       status: [Object],
nightscout_1  |       extended: [Object],
nightscout_1  |       battery: [Object]
nightscout_1  |     },
nightscout_1  |     openaps: { suggested: [Object], iob: [Object] },
nightscout_1  |     uploaderBattery: 88,
nightscout_1  |     created_at: '2021-01-23T08:59:58Z',
nightscout_1  |     configuration: {},
nightscout_1  |     NSCLIENT_ID: '1611392398671'
nightscout_1  |   }
nightscout_1  | }
nightscout_1  | WS: dbAdd client ID:  PbvoXQ5Gg6ZgtauSAABP  data:  {
nightscout_1  |   collection: 'treatments',
nightscout_1  |   data: {
nightscout_1  |     eventType: 'Temp Basal',
nightscout_1  |     duration: 60,
nightscout_1  |     absolute: 0,
nightscout_1  |     rate: 0,
nightscout_1  |     created_at: '2021-01-23T09:00:13Z',
nightscout_1  |     enteredBy: 'openaps://AndroidAPS',
nightscout_1  |     NSCLIENT_ID: '1611392413159'
nightscout_1  |   }
nightscout_1  | }
nightscout_1  | tick 2021-01-23T08:58:41.228Z
nightscout_1  | Problem loading entries
nightscout_1  | Problem loading activity data
nightscout_1  | Problem loading database stats
nightscout_1  | Load Complete:
nightscout_1  |     sgvs:576, profiles:1, food:2
nightscout_1  | data loaded: reloading sandbox data and updating plugins
nightscout_1  | OpenAPS hasn't reported a loop yet
nightscout_1  | WS: dbAdd client ID:  PbvoXQ5Gg6ZgtauSAABP  data:  {
nightscout_1  |   collection: 'devicestatus',
nightscout_1  |   data: {
nightscout_1  |     device: 'openaps://samsung SM-G960F',
nightscout_1  |     pump: {
nightscout_1  |       clock: '2021-01-23T08:55:30Z',
nightscout_1  |       reservoir: 187,
nightscout_1  |       status: [Object],
nightscout_1  |       extended: [Object],
nightscout_1  |       battery: [Object]
nightscout_1  |     },
nightscout_1  |     openaps: { suggested: [Object], iob: [Object] },
nightscout_1  |     uploaderBattery: 88,
nightscout_1  |     created_at: '2021-01-23T08:59:58Z',
nightscout_1  |     configuration: {},
nightscout_1  |     NSCLIENT_ID: '1611392398671'
nightscout_1  |   }
nightscout_1  | }
nightscout_1  | WS: dbAdd client ID:  PbvoXQ5Gg6ZgtauSAABP  data:  {
nightscout_1  |   collection: 'treatments',
nightscout_1  |   data: {
nightscout_1  |     eventType: 'Temp Basal',
nightscout_1  |     duration: 60,
nightscout_1  |     absolute: 0,
nightscout_1  |     rate: 0,
nightscout_1  |     created_at: '2021-01-23T09:00:13Z',
nightscout_1  |     enteredBy: 'openaps://AndroidAPS',
nightscout_1  |     NSCLIENT_ID: '1611392413159'
nightscout_1  |   }
nightscout_1  | }
nightscout_1  | MongoServerSelectionError: getaddrinfo EAI_AGAIN mongo.xyz.de
nightscout_1  |     at Timeout._onTimeout (/opt/app/node_modules/mongodb/lib/core/sdam/topology.js:438:30)
nightscout_1  |     at listOnTimeout (internal/timers.js:554:17)
nightscout_1  |     at processTimers (internal/timers.js:497:7) {
nightscout_1  |   reason: TopologyDescription {
nightscout_1  |     type: 'Single',
nightscout_1  |     setName: null,
nightscout_1  |     maxSetVersion: null,
nightscout_1  |     maxElectionId: null,
nightscout_1  |     servers: Map(1) {
nightscout_1  |       'mongo.xyz.de:27017' => [ServerDescription]
nightscout_1  |     },
nightscout_1  |     stale: false,
nightscout_1  |     compatible: true,
nightscout_1  |     compatibilityError: null,
nightscout_1  |     logicalSessionTimeoutMinutes: null,
nightscout_1  |     heartbeatFrequencyMS: 10000,
nightscout_1  |     localThresholdMS: 15,
nightscout_1  |     commonWireVersion: 8
nightscout_1  |   }
nightscout_1  | }
nightscout_1  | devicestatus insertion error:  getaddrinfo EAI_AGAIN mongo.xyz.de
nightscout_1  | MongoServerSelectionError: getaddrinfo EAI_AGAIN mongo.xyz.de
nightscout_1  |     at Timeout._onTimeout (/opt/app/node_modules/mongodb/lib/core/sdam/topology.js:438:30)
nightscout_1  |     at listOnTimeout (internal/timers.js:554:17)
nightscout_1  |     at processTimers (internal/timers.js:497:7) {
nightscout_1  |   reason: TopologyDescription {
nightscout_1  |     type: 'Single',
nightscout_1  |     setName: null,
nightscout_1  |     maxSetVersion: null,
nightscout_1  |     maxElectionId: null,
nightscout_1  |     servers: Map(1) {
nightscout_1  |       'mongo.xyz.de:27017' => [ServerDescription]
nightscout_1  |     },
nightscout_1  |     stale: false,
nightscout_1  |     compatible: true,
nightscout_1  |     compatibilityError: null,
nightscout_1  |     logicalSessionTimeoutMinutes: null,
nightscout_1  |     heartbeatFrequencyMS: 10000,
nightscout_1  |     localThresholdMS: 15,
nightscout_1  |     commonWireVersion: 8
nightscout_1  |   }
nightscout_1  | }
nightscout_1  | WS: dbAdd client ID:  PbvoXQ5Gg6ZgtauSAABP  data:  {
nightscout_1  |   collection: 'devicestatus',
nightscout_1  |   data: {
nightscout_1  |     device: 'openaps://samsung SM-G960F',
nightscout_1  |     pump: {
nightscout_1  |       clock: '2021-01-23T08:55:30Z',
nightscout_1  |       reservoir: 187,
nightscout_1  |       status: [Object],
nightscout_1  |       extended: [Object],
nightscout_1  |       battery: [Object]
nightscout_1  |     },
nightscout_1  |     openaps: { suggested: [Object], iob: [Object] },
nightscout_1  |     uploaderBattery: 88,
nightscout_1  |     created_at: '2021-01-23T08:59:58Z',
nightscout_1  |     configuration: {},
nightscout_1  |     NSCLIENT_ID: '1611392398671'
nightscout_1  |   }
nightscout_1  | }
nightscout_1  | WS: dbAdd client ID:  PbvoXQ5Gg6ZgtauSAABP  data:  {
nightscout_1  |   collection: 'treatments',
nightscout_1  |   data: {
nightscout_1  |     eventType: 'Temp Basal',
nightscout_1  |     duration: 60,
nightscout_1  |     absolute: 0,
nightscout_1  |     rate: 0,
nightscout_1  |     created_at: '2021-01-23T09:00:13Z',
nightscout_1  |     enteredBy: 'openaps://AndroidAPS',
nightscout_1  |     NSCLIENT_ID: '1611392413159'
nightscout_1  |   }
nightscout_1  | }
nightscout_1  | Problem loading entries
nightscout_1  | Problem loading activity data
nightscout_1  | Problem loading database stats
nightscout_1  | Load Complete:
nightscout_1  |     sgvs:576, profiles:1, food:2
nightscout_1  | data loaded: reloading sandbox data and updating plugins
nightscout_1  | OpenAPS hasn't reported a loop yet
nightscout_1  | MongoServerSelectionError: getaddrinfo EAI_AGAIN mongo.xyz.de
nightscout_1  |     at Timeout._onTimeout (/opt/app/node_modules/mongodb/lib/core/sdam/topology.js:438:30)
nightscout_1  |     at listOnTimeout (internal/timers.js:554:17)
nightscout_1  |     at processTimers (internal/timers.js:497:7) {
nightscout_1  |   reason: TopologyDescription {
nightscout_1  |     type: 'Single',
nightscout_1  |     setName: null,
nightscout_1  |     maxSetVersion: null,
nightscout_1  |     maxElectionId: null,
nightscout_1  |     servers: Map(1) {
nightscout_1  |       'mongo.xyz.de:27017' => [ServerDescription]
nightscout_1  |     },
nightscout_1  |     stale: false,
nightscout_1  |     compatible: true,
nightscout_1  |     compatibilityError: null,
nightscout_1  |     logicalSessionTimeoutMinutes: null,
nightscout_1  |     heartbeatFrequencyMS: 10000,
nightscout_1  |     localThresholdMS: 15,
nightscout_1  |     commonWireVersion: 8
nightscout_1  |   }
nightscout_1  | }
nightscout_1  | devicestatus insertion error:  getaddrinfo EAI_AGAIN mongo.xyz.de
nightscout_1  | MongoServerSelectionError: getaddrinfo EAI_AGAIN mongo.xyz.de
nightscout_1  |     at Timeout._onTimeout (/opt/app/node_modules/mongodb/lib/core/sdam/topology.js:438:30)
nightscout_1  |     at listOnTimeout (internal/timers.js:554:17)
nightscout_1  |     at processTimers (internal/timers.js:497:7) {
nightscout_1  |   reason: TopologyDescription {
nightscout_1  |     type: 'Single',
nightscout_1  |     setName: null,
nightscout_1  |     maxSetVersion: null,
nightscout_1  |     maxElectionId: null,
nightscout_1  |     servers: Map(1) {
nightscout_1  |       'mongo.xyz.de:27017' => [ServerDescription]
nightscout_1  |     },
nightscout_1  |     stale: false,
nightscout_1  |     compatible: true,
nightscout_1  |     compatibilityError: null,
nightscout_1  |     logicalSessionTimeoutMinutes: null,
nightscout_1  |     heartbeatFrequencyMS: 10000,
nightscout_1  |     localThresholdMS: 15,
nightscout_1  |     commonWireVersion: 8
nightscout_1  |   }
nightscout_1  | }

[sulkaharo]

@philipgo Given the logged error is simply that the connection has failed, I'm assuming this has to be something in your Mongo setup, as this hasn't been reported by others. Not the Mongo Driver in Nightscout has been configured to auto-reconnect and this seems to be also fail in this case. FWIW I have a similar setup in Digital Ocean and have never had the Mongo connection fail in this manner. Wonder if there's a Mongo forum somewhere that could help you?

[philipgo]

I am still experimenting with different setups.

• a Nightscout version without https://github.com/nightscout/cgm-remote-monitor/pull/6589 worked fine
• a current dev Nightscout version removing both timeouts at https://github.com/nightscout/cgm-remote-monitor/blob/c91ec78af480f9bb90af89d55dc04de3026902cd/lib/storage/mongo-storage.js#L29 worked fine as well

My MongoDB instance is super fast, so I would have no idea where timeouts might come from. However, is there a reason setting them to much shorter values than their defaults? Just removing the two lines will let them default to socketTimeoutMS = 360000 and connectTimeoutMS=10000.

One note: One of your changes in https://github.com/nightscout/cgm-remote-monitor/pull/6777/files causes the MONGODB_URI string to be displayed in full in the html error message on the web, including user name and password.

[sulkaharo]

Right, increasing the timeouts makes sense. Note the connection time can be different from the query performance and if what you're seeing is caused by a connection or socket timing out, that indicates there's something odd either in the networking between the servers or the Mongo server is misbehaving and sleeping, or some other issue that slows down the handshake.

[inventor96]

I was having a very similar issue on my local machine doing development work. The error message said the type was ReplicaSetNoPrimary. I had it pointing to my live database on MongoDB Cloud. While troubleshooting, I determined that the DNS record for my MongoDB instance didn't exist (I checked locally and by using some DNS lookup services online). This missing DNS record issue has come and gone periodically.

I chatted MongoDB support, and the support rep gave me another connection string to work with instead of the one I was using on my live Nightscout instance on Heroku, which specifically set the name of each shard (rather than referencing the cluster as a whole) and changed a couple options.

Original connection string:

mongodb+srv://username:password@cluster-bp7z8gq4.ngvbd.mongodb.net/heroku_bp7z8gq4?retryWrites=true&w=majority

New connection string:

mongodb://username:password@cluster-bp7z8gq4-shard-00-00.ngvbd.mongodb.net:27017,cluster-bp7z8gq4-shard-00-01.ngvbd.mongodb.net:27017,cluster-bp7z8gq4-shard-00-02.ngvbd.mongodb.net:27017/heroku_bp7z8gq4?ssl=true&replicaSet=atlas-llw8hn-shard-0&authSource=admin&retryWrites=true&w=majority

Using this new connection string, I have been able to connect to my database on MongoDB Cloud from my local machine.

[peligrims]

I installed linux ubuntu 20.04.2 and nightscout After starting i have logo on black screen "loading the client" .what am i doing wrong?

[bewest]

On ubuntu, make sure to unset the LANGUAGE environment variable, or set it to one of the values Nightscout supports. Recent versions of Ubuntu set this in my case to en_US:en when Nightscout needs en. Hope this helps.

[marcirene]

Hello,I ve made 7 attempts to add my Mongo connection string into my Heroku application code (need it for my diabetes application). Keep getting the message: 'Unable to connect to Mongo, MongoDB connection failed! Double check the MONGODB_URI setting in Heroku'.

I can think of 2 things going wrong (see attachment)

1. Do i have to make a copy of the string by 'including full driver code example' (red arrow)...or not necessary? (have used the short one till know)

2. Also don't know which combination of username & pasword to ad. Is this the combination for the account from Mongo?....or the account from Heroku (where I try to deploy my app?) (green stripe!)

Thanks for your help!

Dear regards Marc

[psonnera]

@marcirene you need to replace password (remove bracket!) with the one you decided in step 3e https://nightscout.github.io/nightscout/new_user/#step-3-create-an-atlas-account Please don't select anything that's not specified in the documentation. If you need to change your Atlas password look at this https://nightscout.github.io/troubleshoot/connection_string/#change-your-atlas-database-password

[marcirene]

@marcirene you need to replace password (remove bracket!) with the one you decided in step 3e https://nightscout.github.io/nightscout/new_user/#step-3-create-an-atlas-account Please don't select anything that's not specified in the documentation. If you need to change your Atlas password look at this https://nightscout.github.io/troubleshoot/connection_string/#change-your-atlas-database-password

Thanks for your help psonnera! Don't get it yet ;) (see attachment 2). My nightscout username is my gmail adres. However Nightscout calls me 'Flieren123' as the username. Do you think this creates the problem?

[marcirene]

...forgot something....do i use the 'big connection string' (see bleu 'check mark') or the small one (whiteout using the check mark?)

[psonnera]

Please follow the documentation. Your Atlas login is different from your database username and password. Make sure to create a database user and a password you write down and use those for the connection string. Flieren123 is your database user. Do not include full code example to obtain the connection string.

[Maceysmom]

@marcirene you need to replace password (remove bracket!) with the one you decided in step 3e https://nightscout.github.io/nightscout/new_user/#step-3-create-an-atlas-account Please don't select anything that's not specified in the documentation. If you need to change your Atlas password look at this https://nightscout.github.io/troubleshoot/connection_string/#change-your-atlas-database-password

Thank you so much for the simple "remove bracket" instruction! I've been losing my mind for 2 hours trying to figure out what I could possibly be doing wrong! Working now! Thank you SO much!!!!!

[robster7674]

Just had this today on Northflank, with MongoDB as add-on, also in Northflank. The logs weren't very helpful, so what I first did was re-copy MONGO_SRV contents to MONGODB_URI. After the container with the updated config started, NightScout worked again.

[szantos]

Same occured here 4-6 times during the last 3 weeks. A "rollout restart" seems to solve it for some days, but missing data (during downtime) won't get backfilled.

Host: Northflank DB: mongoDB (Atlas) NS dev 15 d602de1 AAPS dev with NSClient v3 + websockets

I had aa4faa6 running without any problems in April-July (maybe August), then something happened, I've started to experience this failure. A newer NS build did not solved it.

[robster7674]

Just had this again some hours ago, running https://github.com/nightscout/cgm-remote-monitor/commit/da3b2eedd8a12e36daad9e7a5bf8c318c61b6f23 on Northflank.