Project

General

Profile

Actions
Copy link

Bug #8481

closed

ctfgraph query fails on mysql 5.7 and above server

Added by Anchi Cheng almost 5 years ago. Updated almost 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
Leginon - Appion/Leginon 3.5
Start date:
01/16/2020
Due date:
% Done:

0%

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

Description

mysql 5.7 and above enforce only_full_group_by. ctfgraph query that uses extensively group by image in ApCtfData where it is not primary key can not work with it.

Actions
Copy link
 #1

Updated by Anchi Cheng almost 5 years ago

  • Description updated (diff)
  • Status changed from New to Closed

If we want the accurate result of ctfdata with best resolution_appion on the whole session, the only way is to do it one-by-one because we can not sort that column within group by and yet get the best row.

Accept the current fuzzy result now and changed server settings to not force ONLY_FULL_GROUP_BY solved the problem.

Actions
Copy link

Also available in: Atom PDF