Make CI happy again

[milesgranger]

xref: https://github.com/dask-contrib/dask-expr/issues/945

Tried to split each 'fix' into it's own commit, I think some may need their own follow-up issue.

[github-actions[bot]]

Unit Test Results

See test report for an extended history of previous test failures. This is useful for diagnosing flaky tests.

    27 files  ±    0      27 suites  ±0   10h 26m 24s :stopwatch: + 1h 48m 13s  4 048 tests  -     2   3 932 :white_check_mark: +  109    110 :zzz:  -   3   6 :x:  - 108  50 828 runs  +5 654  48 459 :white_check_mark: +6 274  2 336 :zzz: +180  33 :x:  - 800 

For more details on these failures, see this check.

Results for commit 1ccfad65. ± Comparison against base commit f595c9eb.

This pull request removes 2 tests.

distributed.cli.tests.test_dask_worker.test_listen_address_ipv6[tcp:..[ ‑ 1]:---nanny]
distributed.cli.tests.test_dask_worker.test_listen_address_ipv6[tcp:..[ ‑ 1]:---no-nanny]

:recycle: This comment has been updated with latest results.

[crusaderky]

I'm aiming to merge this PR with these tests still failing, as they are more involved:

• test_dataframe_set_index_sync (#8561)
• test_default_task_duration_splits (https://github.com/dask/distributed/pull/8563)
• test_blocklist_shuffle_split (https://github.com/dask/distributed/pull/8563)