Started trying my usual weekly run of a long (> hour if I don’t break it down into segments) automated series of multi db procedures. It stopped roughly half way through with an unexpected quit of PanX. There have been several seemingly identical such today as I’ve been tracing the problem. Running under terminal with enough zlog statements added eventually pointed to this statement:
FormulaFill NOTE+ str(aggregate({«Chart Number»}, "count", {««ChargeRef»»=«Charge Reference» and «Who Paid»="1" and "IP" contains TransType}, "WS Payment XRef", true()))
A zlog statement the line before in the procedure (".NoteToDos") in db “LinkedCharges&Pays” showed in Terminal, the zlog the line after didn’t show. Instead the next output in Terminal was:
/Users/johnbovenmyer/Applications/Run Panorama X Using Terminal: line 2: 7224 Segmentation fault: 11 /Applications/PanoramaX.app/Contents/MacOS/PanoramaX
logout
Saving session...
...copying shared history...
...saving history...truncating history files...
...completed.
I don’t think that procedure had changed in a couple years. I’d never needed to add zlog statements to it before, unlike several other procedures in this run. I’m running an intel laptop under Catalina. The one obvious change is B26. An identical FormulaFill statement did run about 20 code lines earlier, albeit filling a different selection. I half recall a problem with unexpected quits a couple years back, I think also involving FormulaFills including aggregating a different db which also reported segmentation faults. It had me sticking with an earlier beta version for awhile, which didn’t cause it. I think I resolved that by recoding it to employ summarytable(, which might be a work around for this. So I don’t know if the earlier problem resolved with subsequent betas or not. But I’d never had problems here before. My net move is to track down that old fix to see whether I can apply it here. But I though it worth reporting and maybe PanX’s automatic crash reporting will show something useful at Jim’s end. The files and code are too big to ask Jim to review, even if they weren’t medically confidential.
As an aside, my investigations were slowed because my instrumentation settings often didn’t stay turned on. Mostly regarding db “LinkedCharges&Pays”. I wonder whether my unusual naming pick several years back, including “&”, could have anything to do with that. I’ve periodically noticed that behavior for months.