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