Homec4science

dbquery: MySQL 5.5.3+ autocommit fix

Authored by Samuele Kaplun <samuele.kaplun@cern.ch> on Sep 5 2012, 11:18.

Description

dbquery: MySQL 5.5.3+ autocommit fix

  • Since MySQL 5.5.3 DDL statements are transactional, thus they were possibly causing locks with other operations even though these were performed over MyISAM tables. This appears to be due to MySQLdb Python module that since version 1.2.0 disables autocommit by default. To avoid these deadlocks, it is enough to re-enable autocommit.

Details

Committed
Tibor Simko <tibor.simko@cern.ch>Sep 7 2012, 15:08
Parents
R3600:3d0af5673fac: Merge branch 'maint-1.0'
Branches
Unknown
Tags
Unknown

Event Timeline

Tibor Simko <tibor.simko@cern.ch> committed R3600:7f63d3c31ce9: dbquery: MySQL 5.5.3+ autocommit fix (authored by Samuele Kaplun <samuele.kaplun@cern.ch>).Sep 7 2012, 15:08