On 11/26/21 4:35 AM, M4tze wrote:
Dear list members,
if there is any Hyperkitty expert here, I have issues in Hyperkitty (just updated Maxkings Docker images) when rebuilding the Index.
Unfortunately, there are more than 25,000 mails and I do not know which one is/might be broken. Does the error mean that the rebuilding process is incomplete or does it simply skip the erroneous message?
It means the process is incomplete.
Traceback (most recent call last): ... return self._result.fetch_row(size, self._fetch_type) UnicodeDecodeError: 'utf-8' codec can't decode byte 0xed in position 3209: invalid continuation byte
I'm not sure what's going on here. I suspect the issue is withe the
content
of some message in the hyperkitty_email table in the database.
You could try a database query like
SELECT * FROM hyperkitty_email WHERE LEN(content) >= 3209;
If you're lucky, that may just return a few messages and enable you to find the problem one.
Otherwise, you could try first running mailman-web clear_index
and
then run mailman-web update_index
with --start and --end options to
specify a date range and zero in on the offending message.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan