[openstack-dev] [Neutron][Requirement] SQLAlchemy raises None, causes TypeError

Nachi Ueno nachi at ntti3.com
Thu Jul 18 20:33:06 UTC 2013


Hi Eugene

Thanks for tips.
I'm trying to investigate this one
https://bugs.launchpad.net/neutron/+bug/1202797

Since we are using with context.session.. without flush for many place,
it is good to fix this lib side bug.

I have tested devstack with sqlalcemy 0.7.10
but it looks like keystone don't support it..
so it looks we need some workaround to upgrade sqlalchemy

Best
Nachi

2013/7/18 Eugene Nikanorov <enikanorov at mirantis.com>:
> Hi Nachi,
>
> Usually that exception is raised when something goes wrong during
> transaction commit (__exit__ of with block that we usually use)
> I do session.flush() manually to see specific exception in such cases.
> In case exception is potentially unavoidable, explicitly calling flush()
> seems to be a good workaround for this problem.
>
> Thanks,
> Eugene.
>
>
> On Thu, Jul 18, 2013 at 11:48 PM, Nachi Ueno <nachi at ntti3.com> wrote:
>>
>> Hi folks
>>
>> Sometimes, I got "SQLAlchemy raises None, causes TypeError"
>> This get debugging hard, because it hides real reasons.
>>
>> It looks like the problem of combining eventlet and sqlalchemy.
>>
>>
>> http://stackoverflow.com/questions/9525220/sqlalchemy-raises-none-causes-typeerror
>>
>> Latest version of sqlalchemy looks improved of this exception handling
>> code.
>>
>> The sqlalchemy version looks pinned to
>> sqlalchemy>=0.7.8,<=0.7.99.
>>
>> Because we needed SqlSoup (see [1]),
>> However sqlsoup is no longer used.
>>
>> so I would like to upgrade sqlalchemy, but
>> if the other project needs 0.7 version, please let me know.
>>
>>
>> [1]
>> commit cf54850d15b5ead0de2ffd536a2ecdbfed5f33ca
>> Author: Gary Kotton <gkotton at redhat.com>
>> Date:   Sat Oct 27 03:05:35 2012 +0000
>>
>>     pin sqlalchemy to 0.7
>>
>>     The sqlalchemy package 0.8.0b1 released on October 30, 2012
>>     removed SQLSoup
>>
>>
>> (http://docs.sqlalchemy.org/en/latest/changelog/migration_08.html#sqlsoup)
>>
>>     Ensure that the SqlSoup import is still supported. A number of
>> quantum agents
>>     make use of this code to access the database.
>>
>>
>> Best
>> Nachi
>>
>>     Fixes bug 1073555
>>
>>     Change-Id: I78b27716c6e3eb05d874314f0bc544a917fd5853
>>
>> _______________________________________________
>> OpenStack-dev mailing list
>> OpenStack-dev at lists.openstack.org
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
>
>
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>



More information about the OpenStack-dev mailing list