id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
1256	simtest references unknown SQL db columns	welling	Paul Price	"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
"	defect	closed	highest		ippTools		blocker	invalid		welling@… gnarayan@…