Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-8239

PDAC: objectId 3219370448785419 present in test database, but missing in PDAC Qserv

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:

      Description

      Yi Mei says:

      I found another problem: the database query

      select * from RunDeepForcedSource where objectId=3219370448785419;

      gave me 808 records but

      curl -o outForcedSource -d 'query=select+*+from+RunDeepForcedSource+where+objectId=3219370448785419;' http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync

      gave me nothing.

      (Note that the direct mysql query above was run against the test database gapon_sdss_stripe92_patch366_0)

        Attachments

          Issue Links

            Activity

            fritzm Fritz Mueller created issue -
            fritzm Fritz Mueller made changes -
            Field Original Value New Value
            Epic Link DM-6221 [ 24737 ]
            fritzm Fritz Mueller made changes -
            Watchers Fritz Mueller [ Fritz Mueller ] Fritz Mueller, Yi Mei [ Fritz Mueller, Yi Mei ]
            fritzm Fritz Mueller made changes -
            Description Yi Mei says:

            I found another problem: the database query, {code:sql}select * from RunDeepForcedSource where objectId=3219370448785419;{code} gave me 808 records but "curl -o outForcedSource -d 'query=select+*+from+RunDeepForcedSource+where+objectId=3219370448785419;' http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync" gave me nothing.
            fritzm Fritz Mueller made changes -
            Description Yi Mei says:

            I found another problem: the database query, {code:sql}select * from RunDeepForcedSource where objectId=3219370448785419;{code} gave me 808 records but "curl -o outForcedSource -d 'query=select+*+from+RunDeepForcedSource+where+objectId=3219370448785419;' http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync" gave me nothing.
            Yi Mei says:

            I found another problem: the database query{code:sql}select * from RunDeepForcedSource where objectId=3219370448785419;{code} gave me 808 records but {{curl -o outForcedSource -d 'query=select+*+from+RunDeepForcedSource+where+objectId=3219370448785419;' http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync}} gave me nothing.
            fritzm Fritz Mueller made changes -
            Description Yi Mei says:

            I found another problem: the database query{code:sql}select * from RunDeepForcedSource where objectId=3219370448785419;{code} gave me 808 records but {{curl -o outForcedSource -d 'query=select+*+from+RunDeepForcedSource+where+objectId=3219370448785419;' http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync}} gave me nothing.
            Yi Mei says:

            I found another problem: the database query{code:sql}select * from RunDeepForcedSource where objectId=3219370448785419;{code} gave me 808 records but {code}curl -o outForcedSource -d 'query=select+*+from+RunDeepForcedSource+where+objectId=3219370448785419;' http://lsst-qserv-dax01.ncsa.illinois.edu:5000/db/v0/tap/sync{code} gave me nothing.

            (Note that the direct mysql query above was run against the test database gapon_sdss_stripe92_patch366_0)
            fritzm Fritz Mueller made changes -
            Reporter Fritz Mueller [ fritzm ] Yi Mei [ ymei ]
            fritzm Fritz Mueller made changes -
            Story Points 2 0.1
            gapon Igor Gaponenko made changes -
            Resolution Done [ 10000 ]
            Status To Do [ 10001 ] Done [ 10002 ]
            fritzm Fritz Mueller made changes -
            Epic Link DM-6221 [ 24737 ] DM-8240 [ 27757 ]
            fritzm Fritz Mueller made changes -
            Comment [ Igor says: "I think I have an answer regarding objectId=3219370448785419. This belongs to the overlap area processed by IN2P3 (patch=366,0). And it was not included into the merged dataset because the whole patch of the dataset came from the NCSA part of the original S13 DC. You've hit a very narrow hole in the merged dataset right on the edge! Remember that we discussed this problem earlier with Yusra? I picked that patch by a pure accident when preparing that tiny monolithic catalog for SUIT in an anticipation of the PDAC deployment. I wouldn't draw any conclusions from this as this monolithic catalog is not meant to be used to Q&A PDAC! For that (later) purpose we're planning to have the full merged catalog on some dedicated hardware....when/if it will be available." ]
            fritzm Fritz Mueller made changes -
            Labels pdac
            fritzm Fritz Mueller made changes -
            Link This issue relates to DM-8241 [ DM-8241 ]

              People

              Assignee:
              gapon Igor Gaponenko
              Reporter:
              ymei Yi Mei [X] (Inactive)
              Watchers:
              Fritz Mueller, Igor Gaponenko, Yi Mei [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: