Print

Print


I tested it too on the branch with old stack! If you and/or
others see the problem too, let's try to fix it today.
Alternative would be to disable case05 for the 2015_02
release.

Jacek



On 02/27/2015 07:43 AM, Vaikunth Thukral wrote:
> Hmm, I tested on the old stack with local repos before pushing to review
> yesterday and it obviously worked, so I'm not sure what this error is
> either. I'll try to reproduce it and see if I can find something.
>
> -Vaikunth
>
> On Fri, Feb 27, 2015 at 2:13 AM, Jacek Becla <[log in to unmask]
> <mailto:[log in to unmask]>> wrote:
>
>     Anyone understands this?
>
>     To reproduce, run
>
>     bash <qserv dir>/admin/tools/qserv-__install.sh -i ~/<fresh stack
>     dir>/ -d
>
>     It didn't happen when I was running a test on my existing stack
>     earlier, with the latest qserv and qserv_testdata.
>
>
>     -----
>
>
>     2015-02-27 02:08:43,418 - lsst.qserv.tests.benchmark - INFO - Test
>     case #05: 11 queries launched on a total of 50
>     2015-02-27 02:08:43,419 - lsst.qserv.tests.qservDbLoader - INFO -
>     Drop and create MySQL database for Qserv: qservTest_case05_qserv
>     /usr/local/home/becla/__qservDev/Linux64/qserv___testdata/master-g7ac275767c/__python/lsst/qserv/tests/sql/__connection.py:59:
>     Warning: Can't drop database 'qservTest_case05_qserv'; database
>     doesn't exist
>        cursor.execute(query)
>     2015-02-27 02:08:43,420 - lsst.qserv.tests.qservDbLoader - INFO -
>     Drop CSS database for Qserv
>     2015-02-27 02:08:43,627 - lsst.qserv.tests.qservDbLoader - INFO -
>     Drop CSS database: qservTest_case05_qserv
>     2015-02-27 02:08:43,628 - lsst.qserv.tests.benchmark - INFO -
>     Loading data from
>     /usr/local/home/becla/__qservDev/Linux64/qserv___testdata/master-g7ac275767c/__datasets/case05/data
>     (qserv mode)
>     2015-02-27 02:08:43,628 - lsst.qserv.tests.qservDbLoader - INFO -
>     Partition data, create and load table Source
>     2015-02-27 02:09:58,289 - kazoo.client - WARNING - Connection
>     dropped: outstanding heartbeat ping not received
>     2015-02-27 02:09:58,289 - kazoo.client - WARNING - Transition to
>     CONNECTING
>     2015-02-27 02:09:59,563 - root - CRITICAL - Exception occured:
>     Traceback (most recent call last):
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/qserv/master-__g3c6e92cc48/bin/qserv-data-__loader.py",
>     line 312, in <module>
>          sys.exit(loader.run())
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/qserv/master-__g3c6e92cc48/bin/qserv-data-__loader.py",
>     line 248, in run
>          self.loader.load(self.args.__database, self.args.table,
>     self.args.schema, self.args.data)
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/qserv/master-__g3c6e92cc48/lib/python/lsst/__qserv/admin/dataLoader.py",
>     line 168, in load
>          return self._run(database, table, schema, data)
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/qserv/master-__g3c6e92cc48/lib/python/lsst/__qserv/admin/dataLoader.py",
>     line 216, in _run
>          self._updateCss(database, table)
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/qserv/master-__g3c6e92cc48/lib/python/lsst/__qserv/admin/dataLoader.py",
>     line 740, in _updateCss
>          self.css.createTable(database, table, options)
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/qserv/master-__g3c6e92cc48/lib/python/lsst/__qserv/admin/qservAdmin.py",
>     line 428, in createTable
>          self._createTable(options, dbName, tableName)
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/qserv/master-__g3c6e92cc48/lib/python/lsst/__qserv/admin/qservAdmin.py",
>     line 515, in _createTable
>          self._kvI.set(tbP, "READY")
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/qserv/master-__g3c6e92cc48/lib/python/lsst/__qserv/css/kvInterface.py",
>     line 415, in set
>          self._zk.set(k, v)
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/kazoo/2.0b1+__1/lib/python/kazoo-2.0b1-py2.__7.egg/kazoo/client.py",
>     line 1170, in set
>          return self.set_async(path, value, version).get()
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/kazoo/2.0b1+__1/lib/python/kazoo-2.0b1-py2.__7.egg/kazoo/handlers/__threading.py",
>     line 102, in get
>          raise self._exception
>     ConnectionLoss
>     2015-02-27 02:09:59,583 - lsst.qserv.admin.commons - CRITICAL -
>     Error code returned by command : qserv-data-loader.py -v
>     --config=/usr/local/home/__becla/qservDev/Linux64/qserv___testdata/master-g7ac275767c/__datasets/case05/data/common.__cfg
>     --user=root --password=changeme
>     --socket=/usr/local/home/__becla/qserv-run/2015_02/var/__lib/mysql/mysql.sock
>     --delete-tables
>     --config=/usr/local/home/__becla/qservDev/Linux64/qserv___testdata/master-g7ac275767c/__datasets/case05/data/Source.__cfg
>     --css-remove --skip-partition
>     --chunks-dir=/usr/local/home/__becla/qserv-run/2015_02/tmp/__qservTest_case05/chunks/Source
>     --config=/usr/local/home/__becla/qservDev/Linux64/qserv___testdata/master-g7ac275767c/__datasets/case05/data/Source.__cfg
>     qservTest_case05_qserv Source
>     /usr/local/home/becla/__qservDev/Linux64/qserv___testdata/master-g7ac275767c/__datasets/case05/data/Source.__sql
>     /usr/local/home/becla/qserv-__run/2015_02/tmp/qservTest___case05/chunks/Source/Source.__txt
>
>     ERROR
>
>     ==============================__==============================__==========
>     ERROR: test_case05
>     (lsst.qserv.tests.unittest.__testIntegration.__TestIntegration)
>     ------------------------------__------------------------------__----------
>     Traceback (most recent call last):
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/qserv___testdata/master-g7ac275767c/__python/lsst/qserv/tests/__unittest/testIntegration.py",
>     line 85, in test_case05
>          self._runTestCase(case_id)
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/qserv___testdata/master-g7ac275767c/__python/lsst/qserv/tests/__unittest/testIntegration.py",
>     line 63, in _runTestCase
>          bench.run(self.modeList, self.loadData)
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/qserv___testdata/master-g7ac275767c/__python/lsst/qserv/tests/__benchmark.py",
>     line 266, in run
>          self.loadData()
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/qserv___testdata/master-g7ac275767c/__python/lsst/qserv/tests/__benchmark.py",
>     line 205, in loadData
>          self.dataLoader[self._mode].__createLoadTable(table)
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/qserv___testdata/master-g7ac275767c/__python/lsst/qserv/tests/__qservDbLoader.py",
>     line 65, in createLoadTable
>          self._callLoader(table)
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/qserv___testdata/master-g7ac275767c/__python/lsst/qserv/tests/__qservDbLoader.py",
>     line 100, in _callLoader
>          stderr=sys.stderr)
>        File
>     "/usr/local/home/becla/__qservDev/Linux64/qserv/master-__g3c6e92cc48/lib/python/lsst/__qserv/admin/commons.py",
>     line 137, in run_command
>          sys.exit(1)
>     SystemExit: 1
>
>     ------------------------------__------------------------------__----------
>     Ran 5 tests in 249.629s
>
>     FAILED (errors=1)
>     Integration tests failed
>
>     ##############################__##############################__############
>     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
>     <https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1>
>
>

########################################################################
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