I think it’d be useful to document this kind of wisdom in one place. Maybe K-T has a suggestion where. Perhaps in DM-3452? > On Aug 28, 2015, at 12:03 PM, Serge Monkewitz <[log in to unmask]> wrote: > > Yes. Note you can ignore all the tables named run_XXX, since the corresponding XXX view is the same thing with the addition of column aliases. > > I think you should also ignore deepCoadd_det and deepCoadd_mergeDet - they don’t seem to contain much other than an ID and position, and the > RA/Dec columns (coord_ra, coord_dec) are always NULL. > > Cheers, > Serge > >> On Aug 28, 2015, at 11:50 AM, Tatiana Goldina <[log in to unmask] <mailto:[log in to unmask]>> wrote: >> >> Looks like the issue has resolved. I assume, I should be using smm_bremerton and sdss_dr9 as Serge said. >> >> On Aug 28, 2015, at 11:39 AM, Tatiana Goldina <[log in to unmask] <mailto:[log in to unmask]>> wrote: >> >>> Hi Jacek, >>> >>> Were the issues resolved? What is the database for end-to-end test? >>> >>> I tried http://localhost:8661/db/v0/query?sql=SHOW+DATABASES <http://localhost:8661/db/v0/query?sql=SHOW+DATABASES> >>> >>> and got an error again. >>> >>> Exception: OperationalError >>> Message: (OperationalError) (2006, 'MySQL server has gone away') >>> >>> Tried last-dev:8662, got an empty reply from server: >>> >>> curl 'http://localhost:8662/db/v0/query?sql=SHOW+DATABASES' <http://localhost:8662/db/v0/query?sql=SHOW+DATABASES'> >>> curl: (52) Empty reply from server >>> >>> >>> Tatiana >>> >>> On Aug 25, 2015, at 9:58 PM, "Becla, Jacek" <[log in to unmask] <mailto:[log in to unmask]>> wrote: >>> >>>> Tatiana >>>> >>>> We were affected by recent restart of lsst-dev (5 days ago), it took down all services I was running there. >>>> >>>> I noticed something you ran triggered a query that will likely confuse qserv. So hang on until I fix that (DM-3555). >>>> >>>> In the meantime, webserv on port 8661 connected to plain mysql on lsst10 should be working fine >>>> >>>> Jacek >>>> >>>> >>>> >>>> >>>>> On Aug 25, 2015, at 5:19 PM, Tatiana Goldina <[log in to unmask] <mailto:[log in to unmask]>> wrote: >>>>> >>>>> Hi All, >>>>> >>>>> As of now, is it possible to access the tables loaded as a part of end-to-end exercise via Data Access API? >>>>> >>>>> If yes, what is the service URL? I am getting an error from lsst-dev:8682, and I can not connect at all to last-dev:8681. >>>>> >>>>> http://localhost:8662/db/v0/query?sql=SHOW+DATABASES <http://localhost:8662/db/v0/query?sql=SHOW+DATABASES> >>>>> >>>>> Exception: OperationalError >>>>> Message: (OperationalError) (2003, "Can't connect to MySQL server on 'lsst-dbdev5.ncsa.illinois.edu <http://lsst-dbdev5.ncsa.illinois.edu/>' (111)") >>>>> >>>>> Thank you! >>>>> >>>>> Tatiana >>>>> >>>>> On Aug 24, 2015, at 11:32 AM, Serge Monkewitz <[log in to unmask] <mailto:[log in to unmask]>> wrote: >>>>> >>>>>> The data is not in qserv yet (should be there by tomorrow), but you can look at the tables on lsst-db.ncsa.illinois.edu <http://lsst-db.ncsa.illinois.edu/> (lsst10): >>>>>> >>>>>> database: >>>>>> smm_bremerton >>>>>> tables: >>>>>> deepCoadd_forced_src >>>>>> deepCoadd_meas >>>>>> deepCoadd_ref >>>>>> icMatch >>>>>> icSrc >>>>>> src >>>>>> srcMatch >>>>>> >>>>>> database: >>>>>> sdss_dr9 >>>>>> rables: >>>>>> fink_v5b >>>>>> >>>>>> I have not yet ingested descriptions/units for the columns. The last one is the reference catalog used for astrometry/photometry, and is what the icMatch and srcMatch catalogs join against. >>>>>> >>>>>> Cheers, >>>>>> Serge >>>>> >>>>> Use REPLY-ALL to reply to list >>>>> >>>>> To unsubscribe from the QSERV-L list, click the following link: >>>>> https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1 <https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1> >>>> >>>> Use REPLY-ALL to reply to list >>>> >>>> To unsubscribe from the QSERV-L list, click the following link: >>>> https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1 <https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1> >>> >>> >>> >>> >>> >>> Use REPLY-ALL to reply to list >>> >>> To unsubscribe from the QSERV-L list, click the following link: >>> https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1 <https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1> >> >> Use REPLY-ALL to reply to list >> >> To unsubscribe from the QSERV-L list, click the following link: >> https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1 <https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1> ######################################################################## Use REPLY-ALL to reply to list To unsubscribe from the QSERV-L list, click the following link: https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1