On Sep 4, 2013, at 2:45 PM, Douglas Smith wrote:

> But I can't seem to join with the Object table yet, we knew this
> I guess already:
>
> mysql> SELECT s.ra, s.decl FROM Source s, Object o  WHERE  
> s.objectId=o.objectId and o.objectId = 154062577146538502;
> Empty set (2 min 17.98 sec)

Not sure what's going on here, but I'll take a look after some more  
debugging.

Some other notes:
  - I added LSST__Source (a copy of LSST__Object) to qservMeta. I  
probably could have soft-linked it to LSST__Object.*, but for now I  
just made a copy off the objectId index table.
  - The fact that the qserv master doesn't recognize Source.objectId  
as special and look up a chunk for it in the objectId index table  
seems like a bug.

> But when I try a near-neighbor count in that small section I get:
>
> mysql> SELECT COUNT(*) FROM Object o1, Object o2
>     -> WHERE qserv_areaspec_box(1,2,3,4)
>     -> AND qserv_angSep(o1.ra_PS, o1.decl_PS,o2.ra_PS, o2.decl_PS)  
> < 0.1;
> ERROR 4120 (Proxy): Error during execution: 'read failed for chunk 
> (s): 14880 14641 14640 14881'
>
> So, not sure what is happening there?

The problem here is almost certainly that you are calling qserv_angSep 
() when you should be calling scisql_angSep(). The former doesn't  
exist, and because there isn't much in the way of logic that passes  
error message back from workers to the master, you get the somewhat  
opaque error message above.

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