I just tried running integration tests using the latest qserv
and qserv_testdata (I run qserv-test-integration.py), and I got:
[...]
INFO:lsst.qserv.tests.benchmark:Launch 0003_SourcesForGivenExposure.sql
against qserv
INFO:lsst.qserv.admin.commons:Run shell command: mysql --host=127.0.0.1
--port=4040 --user=qsmaster --batch qservTest_case04_qserv -e SELECT
sce.filterName, sce.field, sce.camcol, sce.run, s.deepForcedSourceId,
s.ra, s.decl, s.x, s.y, s.psfFlux, s.psfFluxSigma, s.apFlux,
s.apFluxSigma, s.modelFlux, s.modelFluxSigma, s.instFlux,
s.instFluxSigma, s.shapeIxx, s.shapeIyy, s.shapeIxy, s.flagPixInterpCen,
s.flagNegative, s.flagPixEdge, s.flagBadCentroid, s.flagPixSaturCen,
s.extendedness FROM DeepForcedSource AS s, Science_Ccd_Exposure AS sce
WHERE (s.scienceCcdExposureId = sce.scienceCcdExposureId) AND
(sce.filterName = 'g') AND (sce.field = 535) AND (sce.camcol = 1) AND
(sce.run = 94);
INFO:lsst.qserv.admin.commons:stdout file :
/usr/local/home/becla/qservDev/qserv-run/tmp/qservTest_case04/outputs/qserv/0003_SourcesForGivenExposure.txt
INFO:lsst.qserv.admin.commons: stderr :
--
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
--
CRITICAL:lsst.qserv.admin.commons:Error code returned by command : mysql
--host=127.0.0.1 --port=4040 --user=qsmaster --batch
qservTest_case04_qserv -e SELECT sce.filterName, sce.field, sce.camcol,
sce.run, s.deepForcedSourceId, s.ra, s.decl, s.x, s.y, s.psfFlux,
s.psfFluxSigma, s.apFlux, s.apFluxSigma, s.modelFlux, s.modelFluxSigma,
s.instFlux, s.instFluxSigma, s.shapeIxx, s.shapeIyy, s.shapeIxy,
s.flagPixInterpCen, s.flagNegative, s.flagPixEdge, s.flagBadCentroid,
s.flagPixSaturCen, s.extendedness FROM DeepForcedSource AS s,
Science_Ccd_Exposure AS sce WHERE (s.scienceCcdExposureId =
sce.scienceCcdExposureId) AND (sce.filterName = 'g') AND (sce.field =
535) AND (sce.camcol = 1) AND (sce.run = 94);
ERROR
======================================================================
ERROR: test_case01
(lsst.qserv.tests.unittest.testIntegration.TestIntegration)
----------------------------------------------------------------------
Traceback (most recent call last):
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/unittest/testIntegration.py",
line 69, in test_case01
self._runTestCase(case_id)
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/unittest/testIntegration.py",
line 63, in _runTestCase
bench.run(self.modeList, self.loadData)
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/benchmark.py",
line 258, in run
self.loadData()
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/benchmark.py",
line 202, in loadData
self.dataLoader[self._mode].createLoadTable(table)
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/qservDbLoader.py",
line 64, in createLoadTable
open(self._emptyChunksFile, 'a').close()
IOError: [Errno 2] No such file or directory:
'/usr/local/home/becla/qservDev/qserv-run/var/lib/qserv/empty_qservTest_case01_qserv.txt'
======================================================================
ERROR: test_case02
(lsst.qserv.tests.unittest.testIntegration.TestIntegration)
----------------------------------------------------------------------
Traceback (most recent call last):
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/unittest/testIntegration.py",
line 73, in test_case02
self._runTestCase(case_id)
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/unittest/testIntegration.py",
line 63, in _runTestCase
bench.run(self.modeList, self.loadData)
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/benchmark.py",
line 258, in run
self.loadData()
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/benchmark.py",
line 202, in loadData
self.dataLoader[self._mode].createLoadTable(table)
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/qservDbLoader.py",
line 64, in createLoadTable
open(self._emptyChunksFile, 'a').close()
IOError: [Errno 2] No such file or directory:
'/usr/local/home/becla/qservDev/qserv-run/var/lib/qserv/empty_qservTest_case02_qserv.txt'
======================================================================
ERROR: test_case03
(lsst.qserv.tests.unittest.testIntegration.TestIntegration)
----------------------------------------------------------------------
Traceback (most recent call last):
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/unittest/testIntegration.py",
line 77, in test_case03
self._runTestCase(case_id)
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/unittest/testIntegration.py",
line 63, in _runTestCase
bench.run(self.modeList, self.loadData)
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/benchmark.py",
line 258, in run
self.loadData()
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/benchmark.py",
line 202, in loadData
self.dataLoader[self._mode].createLoadTable(table)
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/qservDbLoader.py",
line 64, in createLoadTable
open(self._emptyChunksFile, 'a').close()
IOError: [Errno 2] No such file or directory:
'/usr/local/home/becla/qservDev/qserv-run/var/lib/qserv/empty_qservTest_case03_qserv.txt'
======================================================================
ERROR: test_case04
(lsst.qserv.tests.unittest.testIntegration.TestIntegration)
----------------------------------------------------------------------
Traceback (most recent call last):
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/unittest/testIntegration.py",
line 81, in test_case04
self._runTestCase(case_id)
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/unittest/testIntegration.py",
line 63, in _runTestCase
bench.run(self.modeList, self.loadData)
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/benchmark.py",
line 261, in run
self.runQueries(stop_at_query)
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/benchmark.py",
line 146, in runQueries
column_names)
File
"/usr/local/home/becla/qservDev/repo/qserv_testdata/python/lsst/qserv/tests/sql/cmd.py",
line 75, in execute
commons.run_command(commandLine, stdout=stdout)
File
"/usr/local/home/becla/qservDev/repo/qserv-master/lib/python/lsst/qserv/admin/commons.py",
line 137, in run_command
sys.exit(1)
SystemExit: 1
----------------------------------------------------------------------
Ran 4 tests in 39.201s
FAILED (errors=4)
this is on lsst-dbdev5.
eups list qserv_testdata
2.1.0 current qserv 2014_11 b513
LOCAL:/usr/local/home/becla/qservDev/repo/qserv_testdata setup
eups list qserv
2014_11.1 current qserv 2014_11 b513
LOCAL:/usr/local/home/becla/qservDev/repo/qserv-master setup
u.jbecla.DM-1213-g2165686426
Does it ring any bell?
Jacek
########################################################################
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
