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

runQueries.py fails on IN2P3 cluster

    Details

    • Type: Bug
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
      None
    • Story Points:
      4
    • Team:
      Data Access and Database

      Description

      Launching runQueries.py produces some errors:

      fjammes@ccosvms0070:~/src/qserv/admin/tools/docker/deployment/in2p3 (tickets/DM-5402 *=)$ ./run-test-queries.sh
      +--------------------+--------------------+
      | ra                 | decl               |
      +--------------------+--------------------+
      | 29.308806347275485 | -86.30884046118973 |
      +--------------------+--------------------+
       
      real    1m20.725s
      user    0m0.004s
      sys     0m0.012s
      Output directory: /afs/in2p3.fr/home/f/fjammes/runQueries_out
      Exception in thread Thread-12:
      Traceback (most recent call last):
        File "/usr/lib64/python2.7/threading.py", line 811, in __bootstrap_inner
          self.run()
        File "/usr/lib64/python2.7/threading.py", line 764, in run
          self.__target(*self.__args, **self.__kwargs)
        File "/afs/in2p3.fr/home/f/fjammes/src/qserv/admin/tools/docker/deployment/in2p3/runQueries.py", line 185, in runQueries
          db='LSST')
        File "/qserv/stack/Linux64/mysqlpython/1.2.3.lsst1/lib/python/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/MySQLdb/__init__.py", line 81, in Connect
          return Connection(*args, **kwargs)
        File "/qserv/stack/Linux64/mysqlpython/1.2.3.lsst1/lib/python/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/MySQLdb/connections.py", line 187, in __init__
          super(Connection, self).__init__(*args, **kwargs2)
      OperationalError: (2013, "Lost connection to MySQL server at 'reading authorization packet', system error: 0")
       
      Exception in thread Thread-23:
      Traceback (most recent call last):
        File "/usr/lib64/python2.7/threading.py", line 811, in __bootstrap_inner
          self.run()
        File "/usr/lib64/python2.7/threading.py", line 764, in run
          self.__target(*self.__args, **self.__kwargs)
        File "/afs/in2p3.fr/home/f/fjammes/src/qserv/admin/tools/docker/deployment/in2p3/runQueries.py", line 185, in runQueries
          db='LSST')
        File "/qserv/stack/Linux64/mysqlpython/1.2.3.lsst1/lib/python/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/MySQLdb/__init__.py", line 81, in Connect
          return Connection(*args, **kwargs)
        File "/qserv/stack/Linux64/mysqlpython/1.2.3.lsst1/lib/python/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/MySQLdb/connections.py", line 187, in __init__
          super(Connection, self).__init__(*args, **kwargs2)
      OperationalError: (1105, '(proxy) all backends are down')
       
      Exception in thread Thread-16:
      Traceback (most recent call last):
        File "/usr/lib64/python2.7/threading.py", line 811, in __bootstrap_inner
          self.run()
        File "/usr/lib64/python2.7/threading.py", line 764, in run
          self.__target(*self.__args, **self.__kwargs)
        File "/afs/in2p3.fr/home/f/fjammes/src/qserv/admin/tools/docker/deployment/in2p3/runQueries.py", line 185, in runQueries
          db='LSST')
        File "/qserv/stack/Linux64/mysqlpython/1.2.3.lsst1/lib/python/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/MySQLdb/__init__.py", line 81, in Connect
          return Connection(*args, **kwargs)
        File "/qserv/stack/Linux64/mysqlpython/1.2.3.lsst1/lib/python/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/MySQLdb/connections.py", line 187, in __init__
          super(Connection, self).__init__(*args, **kwargs2)
      OperationalError: (2013, "Lost connection to MySQL server at 'reading authorization packet', system error: 0")
       
      Exception in thread Thread-21:
      Traceback (most recent call last):
        File "/usr/lib64/python2.7/threading.py", line 811, in __bootstrap_inner
          self.run()
        File "/usr/lib64/python2.7/threading.py", line 764, in run
          self.__target(*self.__args, **self.__kwargs)
        File "/afs/in2p3.fr/home/f/fjammes/src/qserv/admin/tools/docker/deployment/in2p3/runQueries.py", line 185, in runQueries
          db='LSST')
        File "/qserv/stack/Linux64/mysqlpython/1.2.3.lsst1/lib/python/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/MySQLdb/__init__.py", line 81, in Connect
          return Connection(*args, **kwargs)
        File "/qserv/stack/Linux64/mysqlpython/1.2.3.lsst1/lib/python/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/MySQLdb/connections.py", line 187, in __init__
          super(Connection, self).__init__(*args, **kwargs2)
      OperationalError: (1105, '(proxy) all backends are down')
       
      Exception in thread Thread-17:
      Traceback (most recent call last):
        File "/usr/lib64/python2.7/threading.py", line 811, in __bootstrap_inner
          self.run()
        File "/usr/lib64/python2.7/threading.py", line 764, in run
          self.__target(*self.__args, **self.__kwargs)
        File "/afs/in2p3.fr/home/f/fjammes/src/qserv/admin/tools/docker/deployment/in2p3/runQueries.py", line 185, in runQueries
          db='LSST')
        File "/qserv/stack/Linux64/mysqlpython/1.2.3.lsst1/lib/python/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/MySQLdb/__init__.py", line 81, in Connect
          return Connection(*args, **kwargs)
        File "/qserv/stack/Linux64/mysqlpython/1.2.3.lsst1/lib/python/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/MySQLdb/connections.py", line 187, in __init__
          super(Connection, self).__init__(*args, **kwargs2)
      OperationalError: (2013, "Lost connection to MySQL server at 'reading authorization packet', system error: 0")
       
      Exception in thread Thread-19:
      Traceback (most recent call last):
        File "/usr/lib64/python2.7/threading.py", line 811, in __bootstrap_inner
          self.run()
        File "/usr/lib64/python2.7/threading.py", line 764, in run
          self.__target(*self.__args, **self.__kwargs)
        File "/afs/in2p3.fr/home/f/fjammes/src/qserv/admin/tools/docker/deployment/in2p3/runQueries.py", line 185, in runQueries
          db='LSST')
        File "/qserv/stack/Linux64/mysqlpython/1.2.3.lsst1/lib/python/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/MySQLdb/__init__.py", line 81, in Connect
          return Connection(*args, **kwargs)
        File "/qserv/stack/Linux64/mysqlpython/1.2.3.lsst1/lib/python/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/MySQLdb/connections.py", line 187, in __init__
          super(Connection, self).__init__(*args, **kwargs2)
      OperationalError: (2013, "Lost connection to MySQL server at 'reading authorization packet', system error: 0")
       
      Exception in thread Thread-18:
      Traceback (most recent call last):
        File "/usr/lib64/python2.7/threading.py", line 811, in __bootstrap_inner
          self.run()
        File "/usr/lib64/python2.7/threading.py", line 764, in run
          self.__target(*self.__args, **self.__kwargs)
        File "/afs/in2p3.fr/home/f/fjammes/src/qserv/admin/tools/docker/deployment/in2p3/runQueries.py", line 185, in runQueries
          db='LSST')
        File "/qserv/stack/Linux64/mysqlpython/1.2.3.lsst1/lib/python/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/MySQLdb/__init__.py", line 81, in Connect
          return Connection(*args, **kwargs)
        File "/qserv/stack/Linux64/mysqlpython/1.2.3.lsst1/lib/python/MySQL_python-1.2.3-py2.7-linux-x86_64.egg/MySQLdb/connections.py", line 187, in __init__
          super(Connection, self).__init__(*args, **kwargs2)
      OperationalError: (2013, "Lost connection to MySQL server at 'reading authorization packet', system error: 0")
      

        Attachments

          Issue Links

            Activity

            No work has yet been logged on this issue.

              People

              • Assignee:
                Unassigned
                Reporter:
                jammes Fabrice Jammes
                Watchers:
                Andy Salnikov, Fabrice Jammes, Fritz Mueller, Jacek Becla, John Gates, Tim Jenness, Vaikunth Thukral
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Summary Panel