[C++][CI] Sporadic errors in `arrow-acero-asof-join-node-test`

[pitrou]

Describe the bug, including details regarding any error messages, version, and platform.

Various errors seem to occur intermittently on CI.

One example:

[ RUN      ] AsofJoinTest.BackpressureWithBatchesGen
/arrow/cpp/src/arrow/acero/asof_join_node_test.cc:1516: Failure
Value of: has_bp_been_applied()
  Actual: false
Expected: true
[  FAILED  ] AsofJoinTest.BackpressureWithBatchesGen (10693 ms)

from https://github.com/apache/arrow/actions/runs/5391899018/jobs/9789453616?pr=36215#step:6:3333

Another example:
logs
from https://github.com/apache/arrow/actions/runs/5376323460/jobs/9753323965#step:10:338

Component(s)

C++, Continuous Integration

[pitrou]

@rtpsw @icexelloss

[icexelloss]

Thanks @pitrou - I noticed this the other day as well: #36248

We can probably disable this test until we figure out how to make this more robust

[icexelloss]

@rtpsw Can you please take a look

[kou]

@rtpsw Could you add "take" only comment here to assign you to this issue?

[rtpsw]

take