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
|
