Bug #2653
closedmysql table lockup with database at mysql 5.5
0%
Description
Newer mysql appears to default not to autocommit but to wait for transaction to finish or when the connection is closed. sinedon connection is not closed until it is not accessed. We found this on a Leginon installation on Ubuntu 13 where mysql 5.5 is used. The symptom is that there is only one instance of a particular leginon step is allowed. Therefore, if one user has the Leginon setup wizard opened, no one else can start Leginon properly past setup wizard. If one client is opened, nothing else can have a client connection even if it is not on the same instrument since Leginon saves the client connection event in the database.
Updated by Anchi Cheng almost 11 years ago
- Status changed from New to In Test
- Priority changed from Normal to Urgent
Criag Y. found that setting autocommit to True in sinedon/sqldb.py mysqldb-python connection fixed this problem. The solution does not seem to affect our older mysql database in which autocommit is default, so I commit it here as r18095
This need to be merged to 3.0.
Updated by Anchi Cheng almost 7 years ago
- Status changed from In Test to Closed
- Target version set to myami-3.0