 |
 |
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]> 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