CI Failure (key symptom) in TxUpgradeTest.upgrade_does_not_change_tx_coordinator_assignment_test

[vbotbuildovich]

https://buildkite.com/redpanda/redpanda/builds/48458
https://buildkite.com/redpanda/redpanda/builds/48467
https://buildkite.com/redpanda/redpanda/builds/48475
https://buildkite.com/redpanda/vtools/builds/13348
https://buildkite.com/redpanda/redpanda/builds/48482
https://buildkite.com/redpanda/vtools/builds/13346

Module: rptest.tests.transactions_test
Class: TxUpgradeTest
Method: upgrade_does_not_change_tx_coordinator_assignment_test

test_id:    TxUpgradeTest.upgrade_does_not_change_tx_coordinator_assignment_test
status:     FAIL
run time:   152.840 seconds

KafkaException(KafkaError{FATAL,code=INVALID_TXN_STATE,val=48,str="Failed to add partitions to transaction: Broker: Producer attempted a transactional operation in an invalid state"})
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 103, in wrapped
    r = f(self, *args, **kwargs)
  File "/root/tests/rptest/tests/transactions_test.py", line 1346, in upgrade_does_not_change_tx_coordinator_assignment_test
    self._populate_tx_coordinator(topic.name)
  File "/root/tests/rptest/tests/transactions_test.py", line 1310, in _populate_tx_coordinator
    producer.commit_transaction()
cimpl.KafkaException: KafkaError{FATAL,code=INVALID_TXN_STATE,val=48,str="Failed to add partitions to transaction: Broker: Producer attempted a transactional operation in an invalid state"}

JIRA Link: CORE-2733

[vbotbuildovich]

*https://buildkite.com/redpanda/vtools/builds/13383
*https://buildkite.com/redpanda/vtools/builds/13384

[vbotbuildovich]

*https://buildkite.com/redpanda/redpanda/builds/48602
*https://buildkite.com/redpanda/redpanda/builds/48605
*https://buildkite.com/redpanda/vtools/builds/13406

[piyushredpanda]

Presumed to be fixed by #18187

[vbotbuildovich]

*https://buildkite.com/redpanda/vtools/builds/14734
*https://buildkite.com/redpanda/redpanda/builds/50321
*https://buildkite.com/redpanda/redpanda/builds/50323
*https://buildkite.com/redpanda/vtools/builds/14763
*https://buildkite.com/redpanda/vtools/builds/14768
*https://buildkite.com/redpanda/vtools/builds/14777
*https://buildkite.com/redpanda/redpanda/builds/50380
*https://buildkite.com/redpanda/redpanda/builds/50396
*https://buildkite.com/redpanda/vtools/builds/14864
*https://buildkite.com/redpanda/vtools/builds/14865