Moving from Sp6 to Docker Sp7 Any query fails

Thank you so much for your assistance.

I did update specify7 and specify7-worker services to v7.9.0 as suggested, but the issue persists. Specify 7 Crash Report - Query - 2023-11-29T22 19 43.440Z.txt (1.2 MB)

Interestingly when I tried to open the DataObjFormatters app resource(s), it also crashed with the following StackTrace:

Traceback (most recent call last):
  File "/opt/specify7/ve/lib/python3.8/site-packages/django/core/handlers/base.py", line 181, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/opt/specify7/specifyweb/specify/views.py", line 40, in wrapped
    return view(request, *args, **kwargs)
  File "/opt/specify7/ve/lib/python3.8/site-packages/django/views/decorators/cache.py", line 31, in _cache_controlled
    response = viewfunc(request, *args, **kw)
  File "/opt/specify7/specifyweb/specify/views.py", line 73, in view
    return dispatch_func(request, *args, **kwargs)
  File "/opt/specify7/specifyweb/specify/api.py", line 202, in collection_dispatch
    resp = HttpResponse(toJson(data), content_type='application/json')
  File "/opt/specify7/specifyweb/specify/api.py", line 61, in toJson
    return json.dumps(obj, cls=JsonEncoder)
  File "/usr/lib/python3.8/json/__init__.py", line 234, in dumps
    return cls(
  File "/usr/lib/python3.8/json/encoder.py", line 199, in encode
    chunks = self.iterencode(o, _one_shot=True)
  File "/usr/lib/python3.8/json/encoder.py", line 257, in iterencode
    return _iterencode(o, 0)
  File "/opt/specify7/specifyweb/specify/api.py", line 57, in default
    return obj.decode()
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe9 in position 5027: invalid continuation byte

Specify 7 Crash Report - DataObjFormatters - 2023-11-29T22 21 48.742Z.txt (531.9 KB)

Error message reminded my of similar issue on the forum, with special characters encoding issue.

And a quick search on SO confirm that the root of the problem might be accentuated letters (é, è, à, etc., sorry for our French !) in the database ? It feels that we have a lead.