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