After a bit of staff discussion, I think the preferred solution here would be to obviate the need for a stored computed value by having the API return a count of Challenge participants at time of requesting Challenge data. We'd need to give careful consideration to performance especially on pages with lists of Challenges, but that's the way that will definitively solve this.

I know I was the person to log this issue, and I know there's already been staff discussion about it so feel free to completely ignore this disagreement if you wish 😄 but I'm wondering...
If you're concerned about performance (which certainly seems like a good concern), is it actually worth fixing this now? I don't see reports of the bug often so I don't think it's too disruptive. Once we're able to use database transactions, the current member count process could then be modified to use a transaction and so it would become reliable.

But it's just an idea. :) If any contributor wants to work on this, feel free to take it up since it's marked as help wanted!

It's a good point that it's not a high priority. If we were to tackle one of these stored-computed issues pre transactions, Guild/Party member counts would probably be more important as people run into that a lot more often!

EDIT: Based on that, I'm going to knock the priority tag down to minor, if that makes sense!

May be related to #12286 and potentially solved in a similar fashion. This ticket will remain on hold until we can upgrade to a version that allows transactions, which will allow us to make a complete fix.

With PR #12335 the Habitica codebase has been updated to support MongoDB 4.2 and transactions making it possible to fix this issue.

Transactions allow operations on multiple documents to be executed ensuring that either all of them are executed correctly or none, making it possible to fix this issue.

An example on using transactions can be found at https://mongoosejs.com/docs/transactions.html while more info at https://docs.mongodb.com/manual/core/transactions/. If you want to work on this issue and have any question please leave a comment!

Hello 👋 - I'd love to help out with this issue if it's still needed. Am I correct in surmising that this line has the two database update commands that should be included in the same transaction?

Line 350 in website/server/controllers/api-v3/challenges.js

const results = await Promise.all([challenge.syncTasksToUser(user), challenge.save()]);

@SYN-tactic If you're willing to tackle this, you have our full permission to do so! Thank you!

Awesome, thanks @CuriousMagpie - I'm on it!