Query Node: sporadic incorrect membership creation dates for small subset of users

[mochet]

Problem

Some of the members have an incorrect membership creation date: The date for all FMs should be on, or about 2022-12-09T20:39:30.001Z

Cause

• This bug seems to be triggered by someone being elected for the council, and it updates memberships.createdAt which is basically an immutable value.
• This bug also seems to be the reason that browsing members in Pioneer sometimes has weird results pop up when searching for memberships or browsing through memberships in Pioneer.

Query used:

  memberships(limit: 10000, orderBy: createdAt_DESC) {
    id
    handle
    entry {
      ... on MembershipEntryPaid {
        __typename
        membershipBoughtEvent {
          inBlock
        }
      }
      ... on MembershipEntryInvited {
        __typename
        memberInvitedEvent {
          inBlock
        }
      }
      ... on MembershipEntryGifted {
        __typename
        membershipGiftedEvent {
          inBlock
        }
      }
      ... on MembershipEntryMemberCreated {
        __typename
        memberCreatedEvent {
          inBlock
        }
      }
    }
    totalChannelsCreated
    createdAt
  }
}

[thesan]

The date in the associated MemberCreatedEvent is correct though:

So I'm assuming some mapping code mutates Membership.createdAt later on.