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]> 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 > > 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' > curl: (52) Empty reply from server > > > Tatiana > > On Aug 25, 2015, at 9:58 PM, "Becla, Jacek" <[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]> 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 >>> >>> Exception: OperationalError >>> Message: (OperationalError) (2003, "Can't connect to MySQL server on 'lsst-dbdev5.ncsa.illinois.edu' (111)") >>> >>> Thank you! >>> >>> Tatiana >>> >>> On Aug 24, 2015, at 11:32 AM, Serge Monkewitz <[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 (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 >>> >> >> >> 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 >> > > > Spam > Not spam > Forget previous vote > > 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 > ######################################################################## 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