various camtool problems

[eugene]

trying to use the -queue option, I get a number of problems:

I'm trying to select by chip ID:

camtool -queue -dbname gpcpr -chip_id 10

first, this forces me to supply values to all of the '-set' options. These should probably all default to the obvious choices (eg, inherit from chiptool).

I ran this command in the end:

camtool -queue -dbname gpcpr -chip_id 10 -set_workdir /data/ipp001.0/gpc1/20080211.proc -set_label test -set_reduction DEFAULT -set_expgroup NONE -set_dvodb GPCPR.2008.04 -set_tess_id GPCPR -set_end_stage warp -trace db 10

and got the following error stack:

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

SELECT

*

FROM

(SELECT DISTINCT

chipRun.*,
rawExp.camera,
rawExp.telescope,
rawExp.dateobs,
rawExp.exp_tag,
rawExp.exp_type,
rawExp.filelevel,
rawExp.filter,
rawExp.airmass,
rawExp.ra,
rawExp.decl,
rawExp.exp_time,
rawExp.sat_pixel_frac,
rawExp.bg,
rawExp.bg_stdev,
rawExp.bg_mean_stdev,
rawExp.alt,
rawExp.az,
rawExp.ccd_temp,
rawExp.posang,
rawExp.object,
rawExp.solang

FROM chipRun
JOIN rawExp

using(exp_id)

WHERE

chipRun.state = 'stop') as Foo

AND .chip_id = 10
p_psDBRunQuery (psDB.c:837) : Failed to execute SQL query. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND .chip_id = 10' at line 32
queueMode (camtool.c:193) : database error

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

Failed to execute SQL query. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND .chip_id = 10' at line 32

-> queueMode (camtool.c:193): unknown psLib error

database error

disconnected

[eugene]

also, camtool promotes runs to warp even on failure.

[eugene]

these have been addressed long ago.