If xrootd is dead, then it's probably misconfigured somehow. I'll need to see the xrootd log and a list of db/tables to start. My current wild guess is that the worker couldn't find any dbs to publish. -Daniel (typed on a small touch screen) On Nov 11, 2014 6:00 PM, Tatiana Goldina <[log in to unmask]> wrote: > > Yes, we figured that whenever select statements (like "select count …") hang, the qserv status shows that "xrootd is dead" and qserv has to be restarted. > > We also confirmed that we can not connect to Qserv's mysql proxy using JDBC. The error we get is > > SQLException: Qserv error: 'ParseException:ANTLR parse error:unexpected token: /:' > > I am including John Rector, who did set up the QSERV for us. He has more details. > > Tatiana > > > On Nov 11, 2014, at 3:59 PM, Jacek Becla <[log in to unmask]> wrote: > > > Tatiana > > > > When you are talking to Qserv, the front end that you are talking to > > is mysql proxy (which looks exactly like standard mysql on the surface). > > Under the hood, we are intercepting each query and do all sorts of > > somewhat uncommon things. The bottom line is that > > "select columns from %table%' from mysql" will not give you what > > is expected, because were is currently not handled > > by qserv/mysqlProxy. > > > > > > Regarding the issue with DeepCoadd, I vaguely recall DeepCoadd > > is a view, and there were some issues with views in the past. > > Looking at the log files from qserv czar and xrootd would help > > understand this problem, do you know where to look? > > > > Jacek > > > > > > > > On 11/11/2014 12:27 PM, Tatiana Goldina wrote: > >> Thank you for a quick reply. > >> > >> I am issuing "select columns from %table%' from mysql command line > >> client. For now this is the only client that I know which can connect > >> to QSERVE mysql proxy. It could be that MySQL Query Browser and > >> IntelliJ (via JDBC driver) fail to connect because in addition to > >> connecting they try to get extra information about the the schema. I'll > >> test it tonight. > >> > >> The other issue is that I can not make any of the select statements > >> work. It appears to hang for a long while, then produces an error. For > >> example, how do I get a row count for a table? > >> > >> mysql> select count(deepCoaddId) from DeepCoadd; > >> ERROR 4120 (Proxy): Error executing query using qserv. > >> > >> Tatiana > >> > >> On Nov 11, 2014, at 10:14 AM, Serge Monkewitz <[log in to unmask] > >> <mailto:[log in to unmask]>> wrote: > >> > >>> Hi Tatiana, > >>> > >>> I’m moving this discussions to the qserv mailing list. There’s a > >>> page on the SQL constructs that qserv supports here: > >>> https://dev.lsstcorp.org/trac/wiki/db/ScalableArchSQL. > >>> > >>> In general, it’s SQL 92 minus sub-queries, and with some spatial > >>> support. That means that MySQL specific syntax usually isn’t > >>> supported. Unfortunately, I’m not aware of a page that lists out the > >>> exact MySQLisms that we do support, but I believe it’s limited to: > >>> > >>> SHOW TABLES > >>> SHOW DATABSES > >>> DESCRIBE > >>> > >>> Are you saying that the JDBC driver itself is issuing SHOW COLUMNS, or > >>> is that initiated on your end? > >>> > >>> Cheers, > >>> Serge > >>> > >>> Begin forwarded message: > >>> > >>>> *From: *Tatiana Goldina <[log in to unmask] > >>>> <mailto:[log in to unmask]>> > >>>> *Subject: **connecting to qserv database* > >>>> *Date: *November 11, 2014 at 9:07:02 AM PST > >>>> *To: *Serge Monkewitz <[log in to unmask] > >>>> <mailto:[log in to unmask]>> > >>>> > >>>> Hi Serge, > >>>> > >>>> John Rector has set a QSERV for us here at IPAC, and we are trying > >>>> to figure out how to access it. > >>>> > >>>> It seems that I can not access it with a MySql GUI client or JDBC > >>>> (jdbc:mysql://lsst-db1.ipac.caltech.edu > >>>> <http://lsst-db1.ipac.caltech.edu/>:4040/LSST) > >>>> > >>>> I am able to access it with command line mysql client. I can get the > >>>> tables with "show tables;" but > >>>> > >>>> mysql> show columns from DeepSource from LSST; > >>>> ERROR 4110 (Proxy): Qserv error: 'ParseException:ANTLR parse > >>>> error:unexpected token: show:' > >>>> > >>>> (The same error that we get when trying to connect with JDBC.) > >>>> > >>>> On the other hand "describe DeepSource;" works. > >>>> > >>>> How do I find out which commands are supported? > >>>> > >>>> Tatiana > >>> > >> > >> > >> ------------------------------------------------------------------------ > >> > >> 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 > >> > > > > > > > > -- > > BEGIN-ANTISPAM-VOTING-LINKS > > ------------------------------------------------------ > > > > Teach CanIt if this mail (ID 04NenXkSl) is spam: > > Spam: https://canit.ipac.caltech.edu/canit/b.php?i=04NenXkSl&m=ad12a6f5bb2b&c=s > > Not spam: https://canit.ipac.caltech.edu/canit/b.php?i=04NenXkSl&m=ad12a6f5bb2b&c=n > > Forget vote: https://canit.ipac.caltech.edu/canit/b.php?i=04NenXkSl&m=ad12a6f5bb2b&c=f > > ------------------------------------------------------ > > END-ANTISPAM-VOTING-LINKS > > > > ######################################################################## > 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