id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
1368	Exposures waiting on fixed reference catalogue	Paul Price	eugene	"The following exposures are waiting on a fix to the reference catalogue (corruption at the pole).

mysql> select cam_id, exp_name, ra, decl from camProcessedExp join camRun using(cam_id) join chipRun using(chip_id) join rawExp using(exp_id) where camProcessedExp.fault != 0 and decl > 1.5;
+--------+-------------+----------+----------+
| cam_id | exp_name    | ra       | decl     |
+--------+-------------+----------+----------+
|  11803 | o4920g0028o | 1.334197 | 1.558217 | 
|  11810 | o4928g0092o |  0.66249 | 1.557952 | 
|  48386 | o5246g0063o | 1.571178 | 1.552927 | 
|  48401 | o5246g0080o | 1.570996 | 1.552928 | 
|  11816 | o4950g0019o | 4.448953 | 1.528762 | 
+--------+-------------+----------+----------+

I've set them to 'wait':

mysql> update camProcessedExp join camRun using(cam_id) join chipRun using(chip_id) join rawExp using(exp_id) set camRun.state = 'wait' where camProcessedExp.fault != 0 and decl > 1.5;
Query OK, 5 rows affected (0.19 sec)
Rows matched: 5  Changed: 5  Warnings: 0
"	defect	new	normal		DVO		normal