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

We are seeing sporadic CI failures on Python builds due to pytest_cython:

  File "/opt/conda/envs/arrow/lib/python3.8/site-packages/pytest_cython/plugin.py", line 77, in <module>
    def _without_suffixes(path: str | pathlib.Path) -> pathlib.Path:
TypeError: unsupported operand type(s) for |: 'type' and 'type'

https://github.com/apache/arrow/actions/runs/8526575827/job/23356153535?pr=40949#step:6:5476

Upstream issue has been merged pytest-cython/pytest-cython#67 but not yet released so we should add an upper pin for pytest-cython to have green CI.

Component(s)

Continuous Integration