Opened 16 years ago
#1368 new defect
Exposures waiting on fixed reference catalogue
| Reported by: | Paul Price | Owned by: | eugene |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | DVO | Version: | |
| Severity: | normal | Keywords: | |
| Cc: |
Description
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
