[lsst-dm-stack-users] Can't access https://lsst-web.ncsa.illinois.edu/mydb/

[Michael Wood-Vasey]

Dear DM:

I can't access the PHPAdmin interface:

https://lsst-web.ncsa.illinois.edu/mydb/

this morning.  I could last night, when I was having no trouble beating up the database server with various mildly inefficient queries.  I could access the Moya' interface

https://moya.lsst.majuric.org/db/

and then I submitted a query, but now it's unresponsive.

For interest, I attach my query below.  I'm just still roughing out various ideas here, this isn't meant to be the most beautiful query.

Thanks,
Michael

SELECT afp.ra, afp.decl, afp.deepSourceID,
afp.q1Mag_g - afp.q3Mag_g as gdiff,
afp.q1Mag_r - afp.q3Mag_r as rdiff,
manualstd_r.fluxstd  as r_stdev,
ro.uMag, ro.gMag, ro.rMag, ro.iMag, ro.zMag,
ro.gMag-ro.rMag as g_r,
ro.rMag-ro.iMag as r_i
FROM 
(SELECT * FROM AvgForcedPhot
WHERE ra BETWEEN 0 AND 0.1 AND decl BETWEEN 0 AND 0.5) as afp
LEFT JOIN RefDeepSrcMatch
ON afp.deepSourceID=RefDeepSrcMatch.deepSourceID
LEFT JOIN RefObject AS ro
ON RefDeepSrcMatch.refObjectId=ro.refObjectId
LEFT JOIN
(SELECT STDDEV(psfFlux) as fluxstd FROM DeepForcedSource
WHERE ra BETWEEN 0 AND 0.1 AND decl BETWEEN 0 AND 0.5
AND filterId=3
GROUP BY deepForcedSourceID
) as manualstd_r
ON afp.refObjectId=manualstd_r.refObjectId