[Sqlalchemy-tickets] Issue #3258: gevent + sqlalchemy connection bug back in later version (zzzeek/sqlalchemy)

[Lx Y. <iss...@bi...>]

New issue 3258: gevent + sqlalchemy connection bug back in later version
https://bitbucket.org/zzzeek/sqlalchemy/issue/3258/gevent-sqlalchemy-connection-bug-back-in

Lx Yu:

the same error reported in https://bitbucket.org/zzzeek/sqlalchemy/issue/3043/error-file-descriptor-was-closed-in back again.

Currently the most stable version is 0.9.3, which only produce small amount of AttributeError, and versions after produces different exceptions, especially more excs since 0.9.5

I tested python-mysql-connector + gevent + sqlalchemy too and the problem is the same, so I assume the bug is in the sqlalchemy side.

The test was done with your benchmark script, both test script and produced log pasted here:

https://gist.github.com/lxyu/7cbd6cbe83b47e581c8d

The bug is very serious since it may cause strange bug in mysql transaction, we have captured situation where only part of the transaction succeed in our prod servers.