OpenStack Identity (keystone)

Deprecation warning from SQL Alchemy

Bug #1095409 reported by Adam Young on 2013-01-02

This bug report is a duplicate of: Bug #1031405: SADeprecationWarning: Pool.add_listener is deprecated. Use event.listen(). Edit Remove

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	OpenStack Identity (keystone)	Triaged	Medium	Unassigned

Running the unit tests for SQL upgrade shows the following meesage several times

SADeprecationWarning: The 'listeners' argument to Pool (and create_engine()) is deprecated. Use event.listen().

Pool.__init__(self, creator, **kw)

Revision history for this message

Adam Young (ayoung) wrote on 2013-01-02:

This is a SQL Alchemy issue. I'm running with python-sqlalchemy-0.7.9-1.fc17.x86_64

The file in question that needs to be updated is:

/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py

Keep this bug for tracking purposes

Joseph Heck (heckj) on 2013-01-05

Revision history for this message

Dolph Mathews (dolph) wrote on 2013-03-06:

I haven't seen this deprecation warning myself, but we pass 'listeners' to engine config here:

keystone/common/sql/core.py
244: engine_config['listeners'] = [MySQLPingListener()]

I also can't find anything in the sqlalchemy docs that suggests this option is deprecated?

Revision history for this message

Dolph Mathews (dolph) wrote on 2013-03-06:

I'm also running 0.7.9:

$ python -c "import sqlalchemy; print sqlalchemy.__version__"
0.7.9

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Bug watches keep track of this bug in other bug trackers.