Project

General

Profile

Actions

Bug #2653

closed

mysql table lockup with database at mysql 5.5

Added by Anchi Cheng almost 11 years ago. Updated almost 7 years ago.

Status:
Closed
Priority:
Urgent
Assignee:
Category:
-
Target version:
Start date:
02/07/2014
Due date:
% Done:

0%

Estimated time:
Affected Version:
Appion/Leginon 3.0.0
Show in known bugs:
No
Workaround:

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.

Actions #1

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.

Actions #2

Updated by Anchi Cheng almost 11 years ago

r18097 merge this to 3.0

Actions #3

Updated by Anchi Cheng almost 7 years ago

  • Status changed from In Test to Closed
  • Target version set to myami-3.0
Actions

Also available in: Atom PDF