Project

General

Profile

Actions
Copy link

Bug #6494

closed

dddriftstatsgraph.php shows different results on reload

Added by Sargis Dallakyan almost 6 years ago. Updated almost 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
01/02/2019
Due date:
% Done:

0%

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

Description

This happens for sessions with large number of images. For instance http://emgweb.nysbc.org/betamyamiweb/dddriftstatsgraph.php?expId=8228&preset=enn

Related issues 1 (0 open — 1 closed)

Related to Leginon - Bug #1220: loi.php generates a lot of query connection and seem to cause a traffic jamClosedAnchi Cheng03/04/2011

Actions
Actions
Copy link
 #1

Updated by Sargis Dallakyan almost 6 years ago

  • Related to Bug #1220: loi.php generates a lot of query connection and seem to cause a traffic jam added
Actions
Copy link
 #2

Updated by Sargis Dallakyan almost 6 years ago

  • Status changed from New to Closed

Fixed this by reusing existing connection in SQLQuery. It was opening too many mysql connection without closing them. It logged me out a couple of times from the viewer while debugging this and hopefully this will also fix that issue. It now also tries to make another connection and logs the errors. I've added gc_collect_cycles() in between so that servers will have time to close existing connection before trying a new connection.

Actions
Copy link

Also available in: Atom PDF