Exception when loading timeline

[alexpdp7]

I guess some malformed post somewhere:

Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/django/core/handlers/exception.py", line 55, in inner
    response = get_response(request)
               ^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.13/site-packages/django/core/handlers/base.py", line 197, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/takahe/api/decorators.py", line 49, in inner
    return function(request, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/takahe/hatchway/view.py", line 312, in __call__
    response = self.view(request, **kwargs)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/takahe/api/views/timelines.py", line 46, in home
    schemas.Status.map_from_timeline_event(pager.results, request.identity),
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/takahe/api/schemas.py", line 235, in map_from_timeline_event
    cls.from_timeline_event(
    ^
  File "/takahe/api/schemas.py", line 217, in from_timeline_event
    **timeline_event.to_mastodon_status_json(

  File "/takahe/activities/models/timeline_event.py", line 291, in to_mastodon_status_json
    return self.subject_post_interaction.to_mastodon_status_json(

  File "/takahe/activities/models/post_interaction.py", line 558, in to_mastodon_status_json
    post_json = self.post.to_mastodon_json(

  File "/takahe/activities/models/post.py", line 1241, in to_mastodon_json
    "content": self.safe_content_remote(),
               ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/takahe/activities/models/post.py", line 500, in safe_content_remote
    return self.safe_content(local=False)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/takahe/activities/models/post.py", line 487, in safe_content
    return func(local=local)
           ^^^^^^^^^^^^^^^^^
  File "/takahe/activities/models/post.py", line 455, in _safe_content_note
    return ContentRenderer(local=local).render_post(self.content, self)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/takahe/core/html.py", line 343, in render_post
    uri_domain=(None if self.local else post.author.domain.uri_domain),
                                        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Exception Type: AttributeError at /api/v1/timelines/home
Exception Value: 'NoneType' object has no attribute 'uri_domain'
Raised during: hatchway.view.inner

[dcwatson]

At least on my instance, I've tracked this down to there being a few case-insensitive duplicates in Identity. Things like two of the same actor_uri with different casing, or duplicate username/domain combinations with different username casing. The easy solution would be to just update how we fetch identities to be case-insensitive (i.e. use iexact), but the hard part is figuring out the data migration. Could just delete the record without a domain, but that's not always the "current" user casing. A better solution would be to pick one, update all relations to point to it, then delete the other. But that is a big messy thing... need to think on this a bit.

Leaving this here for myself:

Identity.objects.values(actor=Lower("actor_uri")).annotate(num=Count("id")).filter(num__gt=1)