Re: [sqlalchemy] NoSuchColumnError happens when multiple processes concurrently access to a row with locking

2016-04-19 Thread Shingo Toda
+9, Mike Bayer wrote: > > > > On 04/18/2016 08:54 PM, Shingo Toda wrote: > > Hi all > > > > I am now seeing the SQLAlchemy raise 'NoSuchColumnError' occasionally > > when concurrent accesses happen with 'select for update'. &

[sqlalchemy] NoSuchColumnError happens when multiple processes concurrently access to a row with locking

2016-04-18 Thread Shingo Toda
Hi all I am now seeing the SQLAlchemy raise 'NoSuchColumnError' occasionally when concurrent accesses happen with 'select for update'. My application uses * SQLAlchemy 0.8.4 * MySQL-python 1.2.3 * CentOS6.7 * python 2.6 * MariaDB 10.0.20 (three-node Galera Cluster with haprox