Qc1 Tweaks

UPDATE checks SET active='* * * * 3001';
UPDATE checks SET active='* * * * *' WHERE checkname='precipcollected_flag';
kvalobs=# select * from checks
 where checkname like '%recip%flag';
stationid|qcx|medium_qcx|language|checkname|checksignature|active|fromtime
0|QC1-7-110|QC1-7|1|precipcollected_flag|obs;RR_24&&&302;;0,-46080|refobs;KLSTART,KLOBS;;|* * * * *|1500-01-01 00:00:00
(1 rad)

Try this first then see if need to update the -46080 (is this already 32 days or 12 hours?)

Strange thinsg now happening:

kvalobs=# select * from data where paramid=110 and obstime>'2010-02-01' and obstime<'2010-02-17' and typeid=302 and stationid=91400 order by obstime;
 stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      | cfailed 
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+---------
     91400 | 2010-02-01 06:00:00 |   -32767 |     110 | 2010-02-03 20:29:19 |    302 | 0      |     0 |    -32767 | 0000003000000000 | 9899900000000000 | 
     91400 | 2010-02-02 06:00:00 |   -32767 |     110 | 2010-02-03 14:14:12 |    302 | 0      |     0 |    -32767 | 0000003000000000 | 9899900000000000 | 
     91400 | 2010-02-03 06:00:00 |   -32767 |     110 | 2010-02-04 00:33:05 |    302 | 0      |     0 |    -32767 | 0000003000000000 | 9899900000000000 | 
     91400 | 2010-02-04 06:00:00 |       -1 |     110 | 2010-02-04 13:10:56 |    302 | 0      |     0 |        -1 | 0000000000000000 | 9999900000000000 | 
     91400 | 2010-02-08 06:00:00 |        2 |     110 | 2010-02-09 08:18:34 |    302 | 0      |     0 |         2 | 0000000000000000 | 9999900000000000 | 
     91400 | 2010-02-09 06:00:00 |       -1 |     110 | 2010-02-09 08:19:35 |    302 | 0      |     0 |        -1 | 0000000000000000 | 9999900000000000 | 
     91400 | 2010-02-15 06:00:00 |     19.9 |     110 | 2010-02-15 06:52:48 |    302 | 0      |     0 |      19.9 | 0000000000000000 | 9999900000000000 | 
     91400 | 2010-02-16 06:00:00 |      1.2 |     110 | 2010-02-16 07:25:35 |    302 | 0      |     0 |       1.2 | 0000000000000000 | 9999900000000000 | 
(8 rows)

i.e. missing rows are not being generated ??? What controls this?

Turn back on range_checks:

 UPDATE checks SET active='* * * * *' WHERE checkname='RANGE_CHECK';
161 changes made ...

Mmmmmmm looks like this has been happening for a while … what generates missing rows?