CI Failure (`ConsistencyViolationException`) in `CompactionE2EIdempotencyTest.test_basic_compaction`

[vbotbuildovich]

https://buildkite.com/redpanda/redpanda/builds/45011

Module: rptest.tests.compaction_e2e_test
Class: CompactionE2EIdempotencyTest
Method: test_basic_compaction
Arguments: {
    "workload": "TX_UNIQUE_KEYS",
    "initial_cleanup_policy": "compact"
}

test_id:    CompactionE2EIdempotencyTest.test_basic_compaction
status:     FAIL
run time:   68.344 seconds

ConsistencyViolationException('183869\t43\t1\tviolation\tread aborted key19690=19690@25601\n')
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/dist-packages/ducktape/tests/runner_client.py", line 184, in _do_run
    data = self.run_test()
  File "/usr/local/lib/python3.10/dist-packages/ducktape/tests/runner_client.py", line 269, 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 "/root/tests/rptest/services/cluster.py", line 104, in wrapped
    r = f(self, *args, **kwargs)
  File "/root/tests/rptest/tests/compaction_e2e_test.py", line 155, in test_basic_compaction
    rw_verifier.remote_wait_consumer()
  File "/root/tests/rptest/services/compacted_verifier.py", line 219, in remote_wait_consumer
    wait_until(check_consumed,
  File "/usr/local/lib/python3.10/dist-packages/ducktape/utils/util.py", line 53, in wait_until
    raise e
  File "/usr/local/lib/python3.10/dist-packages/ducktape/utils/util.py", line 44, in wait_until
    if condition():
  File "/root/tests/rptest/services/compacted_verifier.py", line 208, in check_consumed
    info = self.remote_info()
  File "/root/tests/rptest/services/compacted_verifier.py", line 262, in remote_info
    return wait_until_result(wrapper, timeout_sec=5, backoff_sec=1)
  File "/root/tests/rptest/util.py", line 90, in wait_until_result
    wait_until(wrapped_condition, *args, **kwargs)
  File "/usr/local/lib/python3.10/dist-packages/ducktape/utils/util.py", line 53, in wait_until
    raise e
  File "/usr/local/lib/python3.10/dist-packages/ducktape/utils/util.py", line 44, in wait_until
    if condition():
  File "/root/tests/rptest/util.py", line 77, in wrapped_condition
    cond = condition()
  File "/root/tests/rptest/services/compacted_verifier.py", line 251, in wrapper
    return (True, self._remote_info())
  File "/root/tests/rptest/services/compacted_verifier.py", line 233, in _remote_info
    self.raise_on_violation(self._node)
rptest.services.compacted_verifier.ConsistencyViolationException: 183869	43	1	violation	read aborted key19690=19690@25601