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

Also available in: Atom PDF