Differences

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

--- kvalobs:kvoss:system:qc2:test:downstream [2010-11-25 20:16:45]
paule
+++ kvalobs:kvoss:system:qc2:test:downstream [2022-05-31 09:29:32] (current)
@@ Line 255: / Line 255: @@
 kvalobs=# \q
 kvalobs@dev-vm101:~$
+</code>
+Double check that at least one of the rows is in rcvtest_data but not in the dev-vm101 data table!
+<code>
+kvalobs=# select * from rcvtest_data where paramid=262 and cfailed like '%QC2%' and obstime>'yesterday' and stationid=17090;
+ stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |      cfailed
+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
+| 2010-11-25 10:00:00 |   -32767 |     262 | 2010-11-25 10:45:56 |    502 | 0      |     0 |      69.5 | 0000601100000000 | 5894700000000001 | QC1-4-262:1,QC2d-2
+(1 row)
+kvalobs=# select * from data where paramid=262 and cfailed like '%QC2%' and obstime>'yesterday' and stationid=17090;
+ stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
+-----------+---------+----------+---------+--------+--------+--------+-------+-----------+-------------+---------+---------
+(0 rows)
+</code>
+and did come from murky:
+<code>
+kvalobs@murky:/etc/kvalobs/Qc2Config$ psql kvalobs
+Welcome to psql 8.3.3, the PostgreSQL interactive terminal.
+Type:  \copyright for distribution terms
+       \h for help with SQL commands
+       \? for help with psql commands
+       \g or terminate with semicolon to execute query
+       \q to quit
+kvalobs=#  select * from data where paramid=262 and cfailed like '%QC2%' and obstime>'yesterday' and stationid=17090 and obstime='2010-11-25 10:00:00';
+ stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |      cfailed
+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
+| 2010-11-25 10:00:00 |   -32767 |     262 | 2010-11-25 10:45:56 |    502 | 0      |     0 |      69.5 | 0000601100000000 | 5894700000000001 | QC1-4-262:1,QC2d-2
+(1 row)
 </code>
@@ Line 335: / Line 370: @@
 This looks like it worked ... i.e. it did not come from murky! But we fiddled with HQC at the end of the day and did this trigger the transfer?
-====== Yes it works! ======
+====== Yes it works - but only when kv2kl is restarted ... ! ======
 The following contains a mixture of output (note before and after comman bug fix too!)