simtest references unknown SQL db columns

[welling]

On odyssey.fas.harvard.edu I have been running simtest on SVN revision 24225 . I'm running:

pantasks: module simtest.pro
pantasks: simtest.setup.basic
pantasks: controller host add ...several appropriate hosts...
pantasks: simtest simtest heroint2 new

Things proceed for a while, then errors occur like:

failure for: warptool -tooverlap -dbname simtest -limit 32 -label proc
job exit status: 1
job host: localhost
job dtime: 13.042538

failure for: chiptool -pendingimfile -dbname simtest -limit 32 -label proc
job exit status: 1
job host: localhost
job dtime: 12.876265

failure for: faketool -pendingimfile -dbname simtest -limit 32 -label proc
job exit status: 1
job host: localhost
job dtime: 12.851278

Running these commands directly gives:

chiptool -pendingimfile -dbname simtest -limit 32 -label proc

p_psDBRunQuery (psDB.c:812) : Failed to execute SQL query. Error: Unknown column 'simtest.rawImfile.chip_id' in 'on clause'
pendingimfileMode (chiptool.c:374) : database error

-> p_psDBRunQuery (psDB.c:812): Database error generated by the server

Failed to execute SQL query. Error: Unknown column 'simtest.rawImfile.chip_id' in 'on clause'

-> pendingimfileMode (chiptool.c:374): unknown psLib error

database error

faketool -pendingimfile -dbname simtest -limit 32 -label proc
p_psDBRunQuery (psDB.c:812) : Failed to execute SQL query. Error: Unknown column 'simtest.camProcessedExp.chip_id' in 'on clause'
pendingimfileMode (faketool.c:471) : database error

-> p_psDBRunQuery (psDB.c:812): Database error generated by the server

Failed to execute SQL query. Error: Unknown column 'simtest.camProcessedExp.chip_id' in 'on clause'

-> pendingimfileMode (faketool.c:471): unknown psLib error

database error

Running with -trace psLib.db 10 gives:

faketool -pendingimfile -dbname simtest -limit 32 -label proc -trace psLib.db 10

calling mysql_autocommit(): 1
connected to database simtest
Executing SQL:

SELECT DISTINCT * FROM (

-- the subselect is so where criteria can be specified without knowing
-- which table the field came from
SELECT

fakeRun.*,
chipProcessedImfile.exp_id,
chipProcessedImfile.class_id,
chipProcessedImfile.uri,
chipProcessedImfile.bg,
chipProcessedImfile.bg_stdev,
chipProcessedImfile.bg_mean_stdev,
chipProcessedImfile.fringe_0,
chipProcessedImfile.fringe_1,
chipProcessedImfile.fringe_2,
chipProcessedImfile.ap_resid,
chipProcessedImfile.ap_resid_stdev,
chipProcessedImfile.n_stars,
chipProcessedImfile.n_extended,
chipProcessedImfile.n_cr,
chipProcessedImfile.path_base as chip_path_base,
camProcessedExp.path_base as cam_path_base,
rawExp.exp_name,
rawExp.exp_tag,
rawExp.camera,
rawExp.telescope,
rawExp.filelevel

FROM fakeRun
JOIN camRun USING(cam_id)
JOIN camProcessedExp USING(cam_id)
JOIN chipRun USING(chip_id)
JOIN chipProcessedImfile USING(chip_id)
JOIN rawExp

ON chipProcessedImfile.exp_id = rawExp.exp_id

LEFT JOIN fakeProcessedImfile

ON fakeRun.fake_id = fakeProcessedImfile.fake_id
AND chipProcessedImfile.class_id = fakeProcessedImfile.class_id

LEFT JOIN fakeMask

ON fakeRun.label = fakeMask.label

WHERE

((fakeRun.state = 'new'

AND fakeProcessedImfile.fake_id IS NULL
AND fakeProcessedImfile.class_id IS NULL

)
OR (fakeRun.state = 'update'

AND fakeProcessedImfile.data_state = 'cleaned')

)
AND fakeMask.label IS NULL

) as fakePendingImfile

WHERE (label = 'proc') LIMIT 32
p_psDBRunQuery (psDB.c:812) : Failed to execute SQL query. Error: Unknown column 'simtest.camProcessedExp.chip_id' in 'on clause'
pendingimfileMode (faketool.c:471) : database error

-> p_psDBRunQuery (psDB.c:812): Database error generated by the server

Failed to execute SQL query. Error: Unknown column 'simtest.camProcessedExp.chip_id' in 'on clause'

-> pendingimfileMode (faketool.c:471): unknown psLib error

database error

disconnected

[Paul Price]

This works for me. We never refer to camProcessedExp.chip_id (it doesn't exist).

Bill tells me that you're using MySQL v4, which we do not support (here's a reason why...). You will need to upgrade to MySQL v5.