Hide Forgot
Description of problem: See The upstream bug report: http://sourceforge.net/p/mysql-python/bugs/324/ Version-Release number of selected component (if applicable): MySQL-python-1.2.3-11.el7.x86_64 How reproducible: always Steps to Reproduce: 1. Set the mysql root password to 'root' 2. execute the http://sourceforge.net/p/mysql-python/bugs/_discuss/thread/67522657/7461/attachment/mysqldb-example.py $ python mysqldb-example.py foo Actual results: no operational error raised ! Traceback (most recent call last): File "test.py", line 58, in <module> bad() File "test.py", line 48, in bad run_test("SELECT * FROM a WHERE a.id in (1, 2) FOR UPDATE") File "test.py", line 42, in run_test "cursor returned from SELECT with no description!" AssertionError: cursor returned from SELECT with no description! Expected results: Traceback (most recent call last): File "test.py", line 58, in <module> bad() File "test.py", line 48, in bad run_test("SELECT * FROM a WHERE a.id in (1, 2) FOR UPDATE") File "test.py", line 39, in run_test curs1.execute(stmt) File "/root/.local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute self.errorhandler(self, exc, value) File "/root/.local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue _mysql_exceptions.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') Additional info: This issue affects Openstack, Workaround: pip install -U MySQL-python==1.2.5 The upstream bug references to this patch: http://sourceforge.net/p/mysql-python/svn/655/tree//branches/MySQLdb-1.2/MySQLdb/_mysql.c?diff=5059d1f5bfc09e26e1a66617:654
I believe this bug is already fixed, since MySQL-python-1.2.5-1.el7 is available. Can you confirm, Attila, please?
The test works as expected, I got the 'Lock wait timeout exceeded; try restarting transaction' .