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
|