Forwarding some problems Tatiana run into... Begin forwarded message: > *From: *Tatiana Goldina <[log in to unmask] > <mailto:[log in to unmask]>> > *Subject: **issues when working with scisql_s2PtInCircle* > *Date: *January 15, 2015 11:16:52 AM PST > *To: *Serge Monkewitz <[log in to unmask] <mailto:[log in to unmask]>> > *Cc: *John Rector <[log in to unmask] <mailto:[log in to unmask]>> > > Hi Serge, > > 1. This time I tried executing > > select * from Science_Ccd_Exposure where scisql_s2PtInCircle(ra, > decl, 0.5, 1.1, 0.138)=1; > > followed by > > select * from DeepSource where scisql_s2PtInCircle(ra, decl, 0.5, > 1.1, 0.138) = 1; > > [2015-01-15 10:29:21] [Proxy][4005] Cannot connect to Qserv master; > Exception in RPC call: > ...tack/Linux64/lua/5.1.4/share/lua/5.1/xmlrpc/http.lua:41: connection > refused > > > qserv-status revealed that czar is dead, > > the last lines in var/log/qserv-czar.log: > > 0115 10:29:01.668 [0x7fa7e6ab9700] INFO root > (build/qdisp/Executive.cc:193) - Query exec finish. 1 dispatched. > 0115 10:29:01.668 [0x7fa7e6ab9700] DEBUG root > (build/qdisp/MessageStore.cc:49) - Msg: 1234567890 2000 Complete > (success) 0 1421346541 > python: build/rproc/ProtoRowBuffer.cc:69: int > lsst::qserv::rproc::escapeString(Iter, CIter, CIter) [with Iter = > __gnu_cxx::__normal_iterator<char*, std::vector<char, > std::allocator<char> > >, CIter = __gnu_cxx::__normal_iterator<const > char*, std::basic_string<char, std::char_traits<char>, > std::allocator<char> > >]: Assertion `sr > cBegin != srcEnd' failed. > > > in zookeeper.log: > > 2015-01-15 10:29:01,100 [myid:] - DEBUG > [SyncThread:0:FinalRequestProcessor@160] - sessionid:0x14ae0fa99e90000 > type:ping cxid:0xfffffffffffffffe zxid:0xfffffffffffffffe > txntype:unknown reqpath:n/a > 2015-01-15 10:29:01,679 [myid:] - WARN > [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:12181:NIOServerCnxn@357] - > caught end of stream exception > EndOfStreamException: Unable to read additional data from client > sessionid 0x14ae0fa99e90000, likely client has closed socket > at org.apache.zookeeper.server.NIOServerCnxn.doIO(NIOServerCnxn.java:228) > at > org.apache.zookeeper.server.NIOServerCnxnFactory.run(NIOServerCnxnFactory.java:208) > at java.lang.Thread.run(Thread.java:745) > 2015-01-15 10:29:01,682 [myid:] - INFO > [NIOServerCxn.Factory:0.0.0.0/0.0.0.0:12181:NIOServerCnxn@1007] - > Closed socket connection for client /127.0.0.1:49482 which had > sessionid 0x14ae0fa99e90000 > 2015-01-15 10:29:12,000 [myid:] - INFO > [SessionTracker:ZooKeeperServer@347] - Expiring session > 0x14ae0fa99e90000, timeout of 10000ms exceeded > 2015-01-15 10:29:12,001 [myid:] - INFO [ProcessThread(sid:0 > cport:-1)::PrepRequestProcessor@494] - Processed session termination > for sessionid: 0x14ae0fa99e90000 > 2015-01-15 10:29:12,002 [myid:] - DEBUG > [SyncThread:0:FinalRequestProcessor@88] - Processing request:: > sessionid:0x14ae0fa99e90000 type:closeSession cxid:0x0 zxid:0x63 > txntype:-11 reqpath:n/a > > I have restarted qserv, and both queries seems to work fine. Do you > know what might have happened? > > > > 2. Then I tried the same cone search on DeepForcedSource, and got the > following error passed to the client: > > select * from DeepForcedSource where scisql_s2PtInCircle(ra, decl, > 0.5, 1.1, 0.138) = 1 > > [2015-01-15 11:02:29] [Proxy][4120] Error during execution: > -1 Ref=1 Resource(/chk/LSST/6970): 20150115-11:01:05, Complete > (success), 0, > Ref=2 Resource(/chk/LSST/7138): 20150115-11:02:19, Complete (success), 0, > Ref=3 Resource(/chk/LSST/7140): 20150115-11:02:18, Error merging > result, 0, > Ref=4 Resource(/chk/LSST/730 (-1) > > Is it the same query analysis bug you were talking about before or > something else? (qserv-status says that all services are alive) > I tried the same query again and got the same error. > > Thank you! > > 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