CI Failure (Failed to query spillover manifest) in `ShadowIndexingWhileBusyTest.test_create_or_delete_topics_while_busy`

[dotnwat]

https://buildkite.com/redpanda/vtools/builds/8251#0188f951-972a-47b3-bf60-58ee85fab736

Module: rptest.tests.e2e_shadow_indexing_test
Class:  ShadowIndexingWhileBusyTest
Method: test_create_or_delete_topics_while_busy
Arguments:
{
  "cloud_storage_type": 1,
  "short_retention": true
}

====================================================================================================
test_id:    rptest.tests.e2e_shadow_indexing_test.ShadowIndexingWhileBusyTest.test_create_or_delete_topics_while_busy.short_retention=True.cloud_storage_type=CloudStorageType.S3
status:     FAIL
run time:   9 minutes 23.736 seconds


    <BadLogLines nodes=ip-172-31-0-163(1),ip-172-31-5-73(1) example="ERROR 2023-06-26 21:58:10,130 [shard 3] cloud_storage - [fiber7559 kafka/topic-ucqtreeztm/49] - remote_partition.cc:464 - Failed to query spillover manifests: cloud_storage::error_outcome:10, query: {2943}">
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/dist-packages/ducktape/tests/runner_client.py", line 135, in run
    data = self.run_test()
  File "/usr/local/lib/python3.10/dist-packages/ducktape/tests/runner_client.py", line 227, in run_test
    return self.test_context.function(self.test)
  File "/usr/local/lib/python3.10/dist-packages/ducktape/mark/_mark.py", line 481, in wrapper
    return functools.partial(f, *args, **kwargs)(*w_args, **w_kwargs)
  File "/home/ubuntu/redpanda/tests/rptest/services/cluster.py", line 139, in wrapped
    redpanda.raise_on_bad_logs(
  File "/home/ubuntu/redpanda/tests/rptest/services/redpanda.py", line 2690, in raise_on_bad_logs
    raise BadLogLines(bad_lines)
rptest.services.utils.BadLogLines: <BadLogLines nodes=ip-172-31-0-163(1),ip-172-31-5-73(1) example="ERROR 2023-06-26 21:58:10,130 [shard 3] cloud_storage - [fiber7559 kafka/topic-ucqtreeztm/49] - remote_partition.cc:464 - Failed to query spillover manifests: cloud_storage::error_outcome:10, query: {2943}">

JIRA Link: CORE-1353