Bug: ValueError in clean_duplicate_history command

[niksite]

Description:

The clean_duplicate_history management command raises a ValueError when used with Django 5.1 and a PostgreSQL DB backend. This error occurs if QuerySet.iterator() is called after prefetch_related() without specifying a chunk_size.

Error:

ValueError: chunk_size must be provided when using QuerySet.iterator() after prefetch_related().

Location:

The error originates in the _process method within simple_history/management/commands/clean_duplicate_history.py.

Proposed Fix:

Specify a chunk_size when calling .iterator() on QuerySets that use prefetch_related().

[MathieuB1]

As of Django 5.0 they mentioned this part:

• The usage of QuerySet.iterator() on a queryset that prefetches related
  objects without providing the chunk_size argument is no longer allowed.

The fix is to add a default chunk size to line 95 in simple_history/management/commands/clean_duplicate_history.py

            for o in model_query.iterator(chunk_size=200):
                self._process_instance(o, model, stop_date=stop_date, dry_run=dry_run)