Changes between Version 20 and Version 21 of PS1_IPP_Czarlog_20190204
- Timestamp:
- Feb 8, 2019, 12:15:52 PM (7 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
PS1_IPP_Czarlog_20190204
v20 v21 266 266 267 267 From these, the following are done, indicated by the state="full": 268 269 {{{ 268 270 +-------------+--------+---------------------+----------------------------+-------+---------+ 269 271 | exp_name | exp_id | label | data_group | state | chip_id | … … 276 278 | o5476g0289o | 235984 | PSNSC.wfix.20180525 | PSNSC.wfix.20180525.x.date | full | 2128163 | 277 279 +-------------+--------+---------------------+----------------------------+-------+---------+ 280 }}} 281 278 282 279 283 Therefore, set their old chips, the ones stuck in update, to clean: 280 284 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"; 285 286 {{{ 281 287 +-------------+--------+--------------+------------------+--------+---------+ 282 288 | exp_name | exp_id | label | data_group | state | chip_id | … … 289 295 | o5476g0289o | 235984 | ps_ud_MOPS.2 | ecliptic.rp.1hr | update | 489341 | 290 296 +-------------+--------+--------------+------------------+--------+---------+ 297 }}} 298 291 299 use: 292 300 {{{
