kvalobs:kvoss:system:qc2:8hdk376snf09zj37dk82s92:qc1tweaks

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision 		Previous revision
kvalobs:kvoss:system:qc2:8hdk376snf09zj37dk82s92:qc1tweaks [2010-02-13 21:31:39]
paule created 		kvalobs:kvoss:system:qc2:8hdk376snf09zj37dk82s92:qc1tweaks [2022-05-31 09:29:32] (current)
Line 12: Line 12:
  
 Try this first then see if need to update the -46080 (is this already 32 days or 12 hours?) Try this first then see if need to update the -46080 (is this already 32 days or 12 hours?)
 +
 +Strange thinsg now happening:
 +
 +<code>
 +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)
 +</code>
 +
 +i.e. missing rows are not being generated ??? What controls this?
 +
 +Turn back on range_checks:
 +
 +<code>
 + UPDATE checks SET active='* * * * *' WHERE checkname='RANGE_CHECK';
 +161 changes made ...
 +</code>
 +
 +Mmmmmmm looks like this has been happening for a while ... what generates missing rows?
  • kvalobs/kvoss/system/qc2/8hdk376snf09zj37dk82s92/qc1tweaks.1266096699.txt.gz
  • Last modified: 2022-05-31 09:23:18
  • (external edit)