| | 260 | |
| | 261 | '''Morning clean up''' |
| | 262 | JRF: I didn't finish clearing up last night as it got late and the telescope opened. So continuing on: |
| | 263 | |
| | 264 | I'll query the state of the exposures still listed as problems in the chiptool table: |
| | 265 | SELECT exp_name, exp_id, label, data_group, chipRun.state FROM rawExp LEFT JOIN chipRun USING (exp_id) WHERE exp_name IN ("o5563g0048o", "o5563g0068o", "o6081g0423o", "o6089g0580o", "o6215g0082o", "o6215g0062o", "o6783g0595o", "o6036g0249o", "o5368g0203o", "o5561g0743o", "o5522g0420o", "o6072g0424o", "o6215g0072o", "o5918g0460o", "o5218g0041o", "o5218g0057o", "o5362g0570o", "o5362g0583o", "o5476g0223o", "o5476g0289o", "o5855g0127o", "o5328g0034o", "o5328g0050o") |
| | 266 | |
| | 267 | From these, the following are done, indicated by the state="full": |
| | 268 | +-------------+--------+---------------------+----------------------------+-------+---------+ |
| | 269 | | exp_name | exp_id | label | data_group | state | chip_id | |
| | 270 | +-------------+--------+---------------------+----------------------------+-------+---------+ |
| | 271 | | o5218g0041o | 125344 | PSNSC.wfix.20180525 | PSNSC.wfix.20180525.x.date | full | 2128159 | |
| | 272 | | o5218g0057o | 125358 | PSNSC.wfix.20180525 | PSNSC.wfix.20180525.x.date | full | 2128160 | |
| | 273 | | o5362g0570o | 181829 | PSNSC.wfix.20180525 | PSNSC.wfix.20180525.x.date | full | 2128161 | |
| | 274 | | o5362g0583o | 181842 | PSNSC.wfix.20180525 | PSNSC.wfix.20180525.x.date | full | 2128162 | |
| | 275 | | o5476g0223o | 235917 | PSNSC.wfix.20180525 | PSNSC.wfix.20180525.x.date | full | 2128164 | |
| | 276 | | o5476g0289o | 235984 | PSNSC.wfix.20180525 | PSNSC.wfix.20180525.x.date | full | 2128163 | |
| | 277 | +-------------+--------+---------------------+----------------------------+-------+---------+ |
| | 278 | |
| | 279 | Therefore, set their old chips, the ones stuck in update, to clean: |
| | 280 | SELECT exp_name, exp_id, label, data_group, chipRun.state, chipRun.chip_id FROM rawExp LEFT JOIN chipRun USING (exp_id) WHERE exp_name IN ("o5218g0041o", "o5218g0057o", "o5362g0570o", "o5362g0583o", "o5476g0223o", "o5476g0289o") AND chipRun.state="update"; |
| | 281 | +-------------+--------+--------------+------------------+--------+---------+ |
| | 282 | | exp_name | exp_id | label | data_group | state | chip_id | |
| | 283 | +-------------+--------+--------------+------------------+--------+---------+ |
| | 284 | | o5218g0041o | 125344 | ps_ud_MOPS.2 | ecliptic.rp.23hr | update | 486920 | |
| | 285 | | o5218g0057o | 125358 | ps_ud_MOPS.2 | ecliptic.rp.23hr | update | 486927 | |
| | 286 | | o5362g0570o | 181829 | ps_ud_MOPS.2 | ecliptic.rp.1hr | update | 489051 | |
| | 287 | | o5362g0583o | 181842 | ps_ud_MOPS.2 | ecliptic.rp.1hr | update | 489062 | |
| | 288 | | o5476g0223o | 235917 | ps_ud_MOPS.2 | ecliptic.rp.1hr | update | 489311 | |
| | 289 | | o5476g0289o | 235984 | ps_ud_MOPS.2 | ecliptic.rp.1hr | update | 489341 | |
| | 290 | +-------------+--------+--------------+------------------+--------+---------+ |
| | 291 | use: |
| | 292 | {{{ |
| | 293 | chiptool -dbname gpc1 -updaterun -set_state goto_cleaned -set_label goto_cleaned -chip_id XXXXXX |
| | 294 | }}} |
| | 295 | |
| | 296 | |
| | 297 | Query the remaining with: |
| | 298 | SELECT exp_name, exp_id, label, data_group, chipRun.state, chipRun.chip_id FROM rawExp LEFT JOIN chipRun USING (exp_id) WHERE exp_name="XXXXXXX"; |
| | 299 | |
| | 300 | All of these are stuck in the update step with the MOPS.2 label. I guess I never send this to be reprocessed. So I will do that using the wfix label, then I'll send the old to cleaned |
| | 301 | |
| | 302 | * HOWEVER... reading the wiki the LAP.PV3 may need to be processed without SWEETSPOT reduction, and instead use default...MEH will explain all later. |
| | 303 | |
| | 304 | |