CI Failure (Unexpected tx_error error: {tx_errc::stale}) in TxAdminTest.test_mark_transaction_expired

[vbotbuildovich]

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

Module: rptest.transactions.tx_admin_api_test
Class: TxAdminTest
Method: test_mark_transaction_expired

test_id:    TxAdminTest.test_mark_transaction_expired
status:     FAIL
run time:   18.449 seconds

<BadLogLines nodes=docker-rp-12(1) example="ERROR 2024-06-10 21:21:21,149 [shard 1:admi] admin_api_server - server.cc:653 - [_anonymous] exception intercepted - url: [http://docker-rp-12:9644/v1/partitions/kafka/topic-sjpfmmmvwn/1/mark_transaction_expired] http_return_status[500] reason - seastar::httpd::server_error_exception (Unexpected tx_error error: {tx_errc::stale})">
Traceback (most recent call last):
  File "/opt/.ducktape-venv/lib/python3.10/site-packages/ducktape/tests/runner_client.py", line 184, in _do_run
    data = self.run_test()
  File "/opt/.ducktape-venv/lib/python3.10/site-packages/ducktape/tests/runner_client.py", line 276, in run_test
    return self.test_context.function(self.test)
  File "/root/tests/rptest/services/cluster.py", line 190, in wrapped
    redpanda.raise_on_bad_logs(
  File "/root/tests/rptest/services/redpanda.py", line 1565, in raise_on_bad_logs
    lsearcher.search_logs(_searchable_nodes)
  File "/root/tests/rptest/services/utils.py", line 197, in search_logs
    raise BadLogLines(bad_loglines)
rptest.services.utils.BadLogLines: <BadLogLines nodes=docker-rp-12(1) example="ERROR 2024-06-10 21:21:21,149 [shard 1:admi] admin_api_server - server.cc:653 - [_anonymous] exception intercepted - url: [http://docker-rp-12:9644/v1/partitions/kafka/topic-sjpfmmmvwn/1/mark_transaction_expired] http_return_status[500] reason - seastar::httpd::server_error_exception (Unexpected tx_error error: {tx_errc::stale})">

JIRA Link: CORE-3706

[vbotbuildovich]

*https://buildkite.com/redpanda/redpanda/builds/50079

[vbotbuildovich]

*https://buildkite.com/redpanda/redpanda/builds/50145

[vbotbuildovich]

*https://buildkite.com/redpanda/redpanda/builds/50389
*https://buildkite.com/redpanda/redpanda/builds/50458