Bug#1101527: pandas fails its autopkgtests

[Nilesh Patra]

Source: pandas
Version: 2.2.3+dfsg-8
Severity: serious

Pandas is failings its autopkgtests in unstable and currently blocking matplotlib migration.
On closer inspection, these do not look related to matplotlib and are likely failing due to
other reasons.

Part of failing log:

1936s _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
1936s 
1936s mysql_pymysql_engine = Engine(mysql+pymysql://root@localhost:3306/pandas)
1936s 
1936s     @pytest.fixture
1936s     def mysql_pymysql_conn(mysql_pymysql_engine):
1936s >       with mysql_pymysql_engine.connect() as conn:
1936s 
1936s /usr/lib/python3/dist-packages/pandas/tests/io/test_sql.py:634: 
1936s _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
1936s 
1936s self = Engine(mysql+pymysql://root@localhost:3306/pandas)
1936s 
1936s     def connect(self) -> Connection:
1936s         """Return a new :class:`_engine.Connection` object.
1936s     
1936s         The :class:`_engine.Connection` acts as a Python context manager, so
1936s         the typical use of this method looks like::
1936s     
1936s             with engine.connect() as connection:
1936s                 connection.execute(text("insert into table values ('foo')"))
1936s                 connection.commit()
1936s     
1936s         Where above, after the block is completed, the connection is "closed"
1936s         and its underlying DBAPI resources are returned to the connection pool.
1936s         This also has the effect of rolling back any transaction that
1936s         was explicitly begun or was begun via autobegin, and will
1936s         emit the :meth:`_events.ConnectionEvents.rollback` event if one was
1936s         started and is still in progress.
1936s     
1936s         .. seealso::
1936s     
1936s             :meth:`_engine.Engine.begin`
1936s     
1936s         """
1936s     
1936s >       return self._connection_cls(self)
1936s 
1936s /usr/lib/python3/dist-packages/sqlalchemy/engine/base.py:3278: 
1936s _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
1936s 
1936s self = <sqlalchemy.engine.base.Connection object at 0x7fd90f73c1a0>
1936s engine = Engine(mysql+pymysql://root@localhost:3306/pandas), connection = None
1936s _has_events = None, _allow_revalidate = True, _allow_autobegin = True
1936s 
1936s     def __init__(
1936s         self,
1936s         engine: Engine,
1936s         connection: Optional[PoolProxiedConnection] = None,
1936s         _has_events: Optional[bool] = None,
1936s         _allow_revalidate: bool = True,
1936s         _allow_autobegin: bool = True,
1936s     ):
1936s         """Construct a new Connection."""
1936s         self.engine = engine
1936s         self.dialect = dialect = engine.dialect
1936s     
1936s         if connection is None:
1936s             try:
1936s                 self._dbapi_connection = engine.raw_connection()
1936s             except dialect.loaded_dbapi.Error as err:
1936s >               Connection._handle_dbapi_exception_noconnection(
1936s                     err, dialect, engine
1936s                 )
1936s 
1936s /usr/lib/python3/dist-packages/sqlalchemy/engine/base.py:148: 
1936s _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
1936s 


Full log at:

https://ci.debian.net/packages/p/pandas/testing/amd64/59330055/
https://ci.debian.net/data/autopkgtest/testing/amd64/p/pandas/59330055/log.gz