https://www.minds.com/groups/profile/365903183068794880/feed/review

added scoped labels

added 1 deleted label

changed title from to

changed the description

added scoped label and automatically removed label

@benhayward.ben this is a recurring issue with moderated group counters that has been ping ponged for nearly a year now. Let's get to the bottom of it in Sprint::10/23 - Quiet Quail .

added scoped labels

changed time estimate to 3h

assigned to @benhayward.ben

Sure thing, but isn't this a partial duplicate of minds#688 (moved)?

I believe it is, and is currently pending review for last week, closing this ticket

Where are we at here Ben?

A change was put forward, but there was an issue with it, so we need to approach this from another angle.

closed

reopened

added scoped label and automatically removed label

Very strange one. The statements used to count the posts and get the posts are pretty much identical, barring one uses * and one uses count(*).

Conversely, we can see on production in a faulty group, that there seems to be a discrepancy.

I wonder whether perhaps Factory::exportable() is silently dropping entities that are being included in the count?

I tested this theory out.

It seems not to be the case. No matter what is missing from the entity, it still sends it through the XHR.

added 2h of time spent at 2019-11-12

Maybe using DISTINCT would help. Hard to tell without knowing what data its finding.

Or another suggestion was CONSISTENCY ALL

added scoped label and automatically removed label

added scoped label and automatically removed label

added scoped label

assigned to @markeharding

added scoped label and automatically removed label

@markeharding @benhayward.ben is blocked due to data investigation issues. Assigning this to you to come up with a plan, as I don't have production Cassandra access.

unassigned @benhayward.ben