升级到2.2.5 的问题

[79102576]

Describe the bug

使用2.2.5出现2026错误,回退到2.2.4成功运行

Environment

sqlalchemy和sqlmodel

How did you install libmysqlclient libraries?

No response

What version of mysqlclient do you use?

2.2.5

Docker command to start MySQL server

No response

Minimum but complete code to reproduce

# Write Python code here.
    database_mysql_url = f"mysql+mysqldb://{user}:{password}@{host}:{port}"
    database_engine = create_engine(database_mysql_url)
    create_database_sql = "CREATE DATABASE IF NOT EXISTS YUWEN;"
    Session = sessionmaker(bind=database_engine)
    with Session() as session:
        session.execute(text(create_database_sql))
        session.commit()
...

Schema and initial data required to reproduce.

-- Write SQL here.
-- e.g. CREATE TABLE ...

Commands, and any other step required to reproduce your issue.

Traceback (most recent call last):
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\engine\base.py", line 146, in init
self._dbapi_connection = engine.raw_connection()
^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\engine\base.py", line 3302, in raw_connection
return self.pool.connect()
^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\base.py", line 449, in connect
return _ConnectionFairy._checkout(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\base.py", line 1263, in _checkout
fairy = _ConnectionRecord.checkout(pool)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\base.py", line 712, in checkout
rec = pool._do_get()
^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\impl.py", line 179, in _do_get
with util.safe_reraise():
^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in exit
raise exc_value.with_traceback(exc_tb)
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\impl.py", line 177, in _do_get
return self._create_connection()
^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\base.py", line 390, in _create_connection
return _ConnectionRecord(self)
^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\base.py", line 674, in init
self.__connect()
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\base.py", line 900, in __connect
with util.safe_reraise():
^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in exit
raise exc_value.with_traceback(exc_tb)
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\base.py", line 896, in __connect
self.dbapi_connection = connection = pool.invoke_creator(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\engine\create.py", line 643, in connect
return dialect.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\engine\default.py", line 621, in connect
return self.loaded_dbapi.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\MySQLdb_init.py", line 121, in Connect
return Connection(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\MySQLdb\connections.py", line 195, in init
super().init(*args, **kwargs2)
MySQLdb.OperationalError: (2026, 'TLS/SSL error: Server certificate validation failed. A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider. Error 0x800B0109(CERT_E_UNTRUSTEDROOT)')

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "e:\project\yuwen\migration\yuwen_server\data\models.py", line 353, in
create_db_and_tables()
File "e:\project\yuwen\migration\yuwen_server\data\models.py", line 347, in create_db_and_tables
wf_Base.metadata.drop_all(engine)
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\sql\schema.py", line 5896, in drop_all
bind._run_ddl_visitor(
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\engine\base.py", line 3252, in _run_ddl_visitor
with self.begin() as conn:
^^^^^^^^^^^^
File "E:\environment\Python\Lib\contextlib.py", line 137, in enter
return next(self.gen)
^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\engine\base.py", line 3242, in begin
with self.connect() as conn:
^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\engine\base.py", line 3278, in connect
return self._connection_cls(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\engine\base.py", line 148, in init
Connection._handle_dbapi_exception_noconnection(
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\engine\base.py", line 2442, in _handle_dbapi_exception_noconnection
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\engine\base.py", line 146, in init
self._dbapi_connection = engine.raw_connection()
^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\engine\base.py", line 3302, in raw_connection
return self.pool.connect()
^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\base.py", line 449, in connect
return _ConnectionFairy._checkout(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\base.py", line 1263, in _checkout
fairy = _ConnectionRecord.checkout(pool)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\base.py", line 712, in checkout
rec = pool._do_get()
^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\impl.py", line 179, in _do_get
with util.safe_reraise():
^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in exit
raise exc_value.with_traceback(exc_tb)
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\impl.py", line 177, in _do_get
return self._create_connection()
^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\base.py", line 390, in _create_connection
return _ConnectionRecord(self)
^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\base.py", line 674, in init
self.__connect()
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\base.py", line 900, in __connect
with util.safe_reraise():
^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in exit
raise exc_value.with_traceback(exc_tb)
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\pool\base.py", line 896, in __connect
self.dbapi_connection = connection = pool.invoke_creator(self)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\engine\create.py", line 643, in connect
return dialect.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\sqlalchemy\engine\default.py", line 621, in connect
return self.loaded_dbapi.connect(*cargs, **cparams)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\MySQLdb_init.py", line 121, in Connect
return Connection(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "E:\project\yuwen\migration\yuwen_server\lib\Lib\site-packages\MySQLdb\connections.py", line 195, in init
super().init(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (2026, 'TLS/SSL error: Server certificate validation failed. A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider. Error 0x800B0109(CERT_E_UNTRUSTEDROOT)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)

[methane]

duplicate of #729