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

Missing qservCssData db crash Qserv

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: To Do
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
      None
    • Team:
      Data Access and Database

      Description

      Missing qservCssData db crashes Qserv when issues a sql query through czar:

      The error message should be more clear and written to qserv-czar.log instead of console (console log should be thrown away in production).

      as of May 2019 the mysqlproxy behavior is as follows

      MariaDB [(none)]> use qservTest_case01_qserv;
      Database changed
      MariaDB [qservTest_case01_qserv]> select objectId from Object;
      ERROR 4005 (Proxy): Exception in call to czar method: Error from mysql: (-999) Error connecting to mysql with config:[host=, port=0, user=qsmaster, password=XXXXXX, db=qservCssData, socket=/home/npease/qserv-run/var/lib/mysql/mysql.sock, maxTableSize=0]
      MariaDB [qservTest_case01_qserv]> 
      

      Error reporting for empty or non-consistent qservCssData should also be improved.

      Running qserv-status.sh crashes.

        Attachments

          Issue Links

            Activity

            jammes Fabrice Jammes created issue -
            jammes Fabrice Jammes made changes -
            Field Original Value New Value
            Rank Ranked higher
            jbecla Jacek Becla made changes -
            Rank Ranked lower
            jbecla Jacek Becla made changes -
            Rank Ranked lower
            jbecla Jacek Becla made changes -
            Rank Ranked higher
            jbecla Jacek Becla made changes -
            Rank Ranked lower
            jbecla Jacek Becla made changes -
            Rank Ranked lower
            jbecla Jacek Becla made changes -
            Rank Ranked lower
            jbecla Jacek Becla made changes -
            Rank Ranked lower
            gcomoretto Gabriele Comoretto made changes -
            Remote Link This issue links to "Page (Confluence)" [ 20730 ]
            Hide
            fritzm Fritz Mueller added a comment -

            Andy SalnikovJohn GatesNate PeaseIgor Gaponenko: Could one of you please check to see if this is still the case or if this has subsequently been addressed collaterally, and comment here?

            Show
            fritzm Fritz Mueller added a comment - Andy Salnikov John Gates Nate Pease Igor Gaponenko : Could one of you please check to see if this is still the case or if this has subsequently been addressed collaterally, and comment here?
            npease Nate Pease made changes -
            Assignee Nate Pease [ npease ]
            Hide
            npease Nate Pease added a comment -

            Sure, I'll take a look.

            Show
            npease Nate Pease added a comment - Sure, I'll take a look.
            Hide
            npease Nate Pease added a comment -

            This issue still exists. I added some info to the description.

            Show
            npease Nate Pease added a comment - This issue still exists. I added some info to the description.
            npease Nate Pease made changes -
            Description Missing qservCssData db crashes Qserv when issues a sql query through czar:

            The error message should be more clear and written to qserv-czar.log instead of console (console log should be thrown away in production).

            {code}
            ==> /qserv/run/var/log/qserv-czar-console.log <==
            terminate called after throwing an instance of 'lsst::qserv::css::CssError'
              what(): Error from mysql: (-999) Error connecting to mysql with config:[host=, port=0, usr=qsmaster, pass=, dbName=qservCssData, socket=/qserv/run/var/lib/mysql/mysql.sock
            {code}

            Error reporting for empty or non-consistent qservCssData should also be improved.
            Missing qservCssData db crashes Qserv when issues a sql query through czar:

            The error message should be more clear and written to qserv-czar.log instead of console (console log should be thrown away in production).

            as of May 2019 the mysqlproxy behavior is as follows
            {code}
            MariaDB [(none)]> use qservTest_case01_qserv;
            Database changed
            MariaDB [qservTest_case01_qserv]> select objectId from Object;
            ERROR 4005 (Proxy): Exception in call to czar method: Error from mysql: (-999) Error connecting to mysql with config:[host=, port=0, user=qsmaster, password=XXXXXX, db=qservCssData, socket=/home/npease/qserv-run/var/lib/mysql/mysql.sock, maxTableSize=0]
            MariaDB [qservTest_case01_qserv]>
            {code}

            Error reporting for empty or non-consistent qservCssData should also be improved.

            Running {{qserv-status.sh}} crashes.

              People

              Assignee:
              npease Nate Pease
              Reporter:
              jammes Fabrice Jammes
              Watchers:
              Andy Salnikov, Fabrice Jammes, Fritz Mueller, Jacek Becla, John Gates, Nate Pease
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated: