Project

General

Profile

Actions

Bug #5456

closed

apStack particle insertion failure if not all columns have value

Added by Anchi Cheng over 6 years ago. Updated about 5 years ago.

Status:
Closed
Priority:
Normal
Category:
-
Target version:
Start date:
01/23/2018
Due date:
% Done:

0%

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

Description

Produced this query which can not be inserted.

INSERT INTO `ApStackParticleData` (`particleNumber`,`REF|ApStackData|stack`,`REF|ApStackRunData|stackRun`,`edgemean`,`min`,`max`,`skew`,`centerstdev`,`REF|ApParticleData|particle`,`stdev`,`edgestdev`,`kurtosis`,`centermean`,`mean`) VALUES ('1','10','6','None','None','None','None','None','47','467.88497925','None','None','None','2903.36547852')

Actions #1

Updated by Anchi Cheng over 6 years ago

  • Status changed from Assigned to In Test
  • Assignee changed from Anchi Cheng to Gabriel Lander

Gabe,

Maybe you have run into this problem before ?

Actions #2

Updated by Gabriel Lander over 6 years ago

I've never come across an error like this - did I add this line? Why are we doing an direct sql insert as opposed to using sinedon?

Actions #3

Updated by Anchi Cheng over 6 years ago

You added the direct sql stuff originally. Issue #3355. However, I think I encounter this because I was creating substack from quickstack which Neil Wrote. These ApStackParticleData that it needs to copy do not have all the column values to make it quick.

I will test it one more time later and close the issue.

Actions #4

Updated by Anchi Cheng about 5 years ago

  • Status changed from In Test to Closed

assume ok

Actions

Also available in: Atom PDF