Cleanup of batches is never performed, add batch cleanup after execution of batch

This issue is being reviewed by the kind folks in Slack, #needs-review-queue-initiative. We are working to keep the size of Needs Review queue [2700+ issues] to around 400 (1 month or less), following Review a patch or merge request → as a guide.

This could use test coverage

Rerolled patch from #36 against 9.5.4. No other changes.

Patch rerolled for the 10.2.x branch

Here's another consequence of this bug. We discovered that we have 16000+ old batch jobs left in the queue table. _drush_batch_worker() invokes Drupal\Core\Queue\DataBaseQueue::claimItem(), which generates a query similar to this:

SELECT * FROM queue q WHERE name='drupal_batch:123301:0' ORDER BY item_id ASC LIMIT 0, 1;

This query now takes about 6 seconds to execute!

Now, during an upgrade, drush commands such as `locale:check` and `locale:upgrade` takes forever to execute because of this (they repeatedly add new batch jobs). Even enabling a new module will have this effect, since it will invoke the locale module to look for translations.

Rebased against head and moved changes to OOPS hooks.

MR and patch seem very different, was some stuff missed?

@smustgrave issue is rescoped check #40, patch rerolls are not correct. MR 3248 is relevant.

Then the needs tests tag still seems relevant hear so moving back to NW thanks