How to reset the sentinel sequence ID to skip processing a large backlog?

Thanks @diana and @jkuester !

So to pull it all together:

  1. Confirm in watchdog you have a sentinel backlog. This is likely in the thousands or millions. While it may decreasing you’ll note that it will take weeks or months to reach zero. While this backlog is being processed, no new sentinel transitions will be processed:

  2. get the current sequence ID for medic db via curl -qs https://medic:password@192-168-68-26.local-ip.medicmobile.org:10443/medic/ | jq ".update_seq" - will show a like ~400 char string starting with a number::

    307933-g1AAAAO1eJyV0j1OwzAUB3CLIiEQUsXAJRiQP2I7ZoErQGsxMMV2oigqMDFzil4BUk-sTJyCKzAwMtOGZ8cLUlXJ9vCGJ__k97cXCKHjduLQiX18sq0zV4TKcwybLKC197CPXr3_hjLA6tqJQcgd3kProOSmFLzYdnQ3eKP1J5QXcBN4FEHJqeSK5oPrYfiAcg3uCNa3EaywZI0j-WDvvYfyC2664XsEi6bCWDX54Ezr5RilT-BFBJlzkjKWCZrnYdiMQS5Hzr5FjsqS1kzmcp33q2CuE_YVMSMaxbjNxbTW8yD2Cesj5pzijIpc7BI-XRBn6V3vIiZsbQqRndoZpB_ETXqC6TgmpRVx2WOewq2CuPqXmSC8pCXPxCoUuHmSfqJkCVaF2Tpj9wfVKv_m
    
  3. In Fauxton, go to the transitions-seq document via the URL https://192-168-68-26.local-ip.medicmobile.org:10443/_utils/#database/medic-sentinel/_local/transitions-seq . You can note before you edit that the leading integer is lower than step 2 above. For me it was "value": "292713-g1AAAAO1e...

  4. Stop the sentinel container. This is critical as the timing may be such that if you don’t stop it, the sentinel process will overwrite the attempt reset the sequence ID and the backlog will not be cleared.

  5. Carefully edit value to paste in the string you got on step 2 and click “Save Changes”

  6. Restart the Sentinel container

  7. Watchdog should now show a curt drop off and zero backlog: