[Python] Windows 10 Access Violation exit(5) application crashes when mysql-connector-python==9.1.0 is used and pyarrow installed

[ivanignatiev]

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

As I have seen some issues ( like #40100 ) related to Access Violation on Windows in pyarrow I have decided to open this issue here. Maybe for other not reproducible issues with the same crash reason it is related to conflicts with other dependencies.

We have a Python (3.12.5) Flask application which uses Flask==3.1.0 and Flask-SQLAlchemy==3.1.1.

As a connection driver, we had mysql-connector-python==9.1.0.

On Windows 10, when pyarrow is installed (I have tested all versions from pyarrow 15, and Python 3.12 and 3.13, PyPi) application crashes when SQLAlchemy tries to open connection to MySQL (in our case just localhost with standard 3306 port).

Here is faulthandler traces:

We have changed mysql-connector-python to mysqlclient and issue disappear.

Component(s)

Python

[kou]

#44855 may be related.