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

"SELECT y_flagNegative from Object where y_flagNegative != (1)" crash Qserv master

    XMLWordPrintable

    Details

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

      Description

      Next query crash Qserv master:

      -bash-4.2$ time mysql --host ccqserv125 --port 4040 --user qsmaster LSST -e "SELECT y_flagNegative from Object where y_flagNegative != (1)";
      		 
      ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query

      One may suppose it's because too large results.

        Attachments

          Issue Links

          mentioned in

          Page Loading...

            Activity

            Ascending order - Click to sort in descending order
            No builds found.
            jammes Fabrice Jammes created issue -
            jbecla Jacek Becla made changes -
            Field Original Value New Value
            Epic Link DM-2881 [ 17862 ]
            tjenness Tim Jenness made changes -
            Team Data Access and Database [ 10204 ]
            fritzm Fritz Mueller made changes -
            Rank Ranked higher
            fritzm Fritz Mueller made changes -
            Rank Ranked lower
            gcomoretto Gabriele Comoretto [X] (Inactive) made changes -
            Remote Link This issue links to "Page (Confluence)" [ 23830 ]
            fritzm Fritz Mueller made changes -
            Status To Do [ 10001 ] In Progress [ 3 ]
            fritzm Fritz Mueller made changes -
            Resolution Done [ 10000 ]
            Status In Progress [ 3 ] Done [ 10002 ]
            Hide
            Permalink
            fritzm Fritz Mueller added a comment -

            Appears to have been addressed in interim; no longer crashes and works per expectation.

            Show
            fritzm Fritz Mueller added a comment - Appears to have been addressed in interim; no longer crashes and works per expectation.
            fritzm Fritz Mueller made changes -
            Urgent? off
            Watchers Fabrice Jammes, Jacek Becla, John Gates [ Fabrice Jammes, Jacek Becla, John Gates ] John Gates [ John Gates ]
            fritzm Fritz Mueller made changes -
            Resolution Done [ 10000 ]
            Status Done [ 10002 ] To Do [ 10001 ]
            fritzm Fritz Mueller made changes -
            Resolution Done [ 10000 ]
            Status To Do [ 10001 ] Invalid [ 11005 ]

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              jammes Fabrice Jammes
              Watchers:
              Fritz Mueller, John Gates
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Jenkins

                  No builds found.