This is another version of https://acreconsulting.canny.io/hifis-4/p/housing-status-duplicated-statuses but it's distinct enough that I'm giving it its own ticket.
  • I have a total of 36 clients. I found the issue for 7 clients including Anonymous, Anonymous, that's around 20% of clients affected.
  • I tested the demo site and the issue is present for over 1200 clients. Here are some examples of affected clients: all clients between 2,881 and 2,895 inclusive; 2,723; 800; 259.... there's lots.
  • It's always duplicated Unknown status. Every time. I haven't found a duplicated status that wasn't Unknown.
  • It's always the same client becoming unknown a bunch of times at the exact same timestamp.
  • The timestamp is the same timestamp as the client created date.
  • There are always 77 copies of the duplicated unknown status. The number 77 probably has to do with something in my database. I tested on demo.hifis.ca and the number was 615. I don't know what I have 77 of and demo.hifis.ca has 615 of, but there's probably something.