Propagate Qc2 Data Downstream

These notes have been compiled in relation to investigations of https://kvoss.bugs.met.no/show_bug.cgi?id=1298.

kv2kl-Qc2test setup to run on dev-vm128 (or somewhere ???…. ) and retrieve data from dev-vm101 and send it to dev-vm116.

*Observation*

dev-vm101

kvalobs@dev-vm101:~$ psql
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 stationid=64330 and obstime='2010-11-01 11:00:00' and paramid=211;
 stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      | cfailed  
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------
     64330 | 2010-11-01 11:00:00 |   -32767 |     211 | 2010-11-01 11:30:25 |    311 | 0      |     0 |       4.2 | 0000001100000000 | 6894900000000000 |  QC2d-2 
(1 row)

dev-vm116:

kvalobs@dev-vm116:~$ psql kvalobs
Welcome to psql 8.3.5, 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 kv2klima where cfailed like '%QC2%;
kvalobs'# 
kvalobs=#  select * from kv2klima where cfailed like '%QC2%';
kvalobs=#  select * from kv2klima where cfailed like '%QC2%' and stationid=64330;
ERROR:  column "stationid" does not exist
LINE 1: ...ct * from kv2klima where cfailed like '%QC2%' and stationid=...
                                                             ^
kvalobs=#  select * from kv2klima where cfailed like '%QC2%' and stnr=64330; stnr  |        dato         | typeid | paramid | sensor | xlevel | original | corrected |     useinfo      | para_name | year |       kvstamp       |          klstamp           | old_name |   controlinfo    | cfailed  
-------+---------------------+--------+---------+--------+--------+----------+-----------+------------------+-----------+------+---------------------+----------------------------+----------+------------------+----------
 64330 | 2010-11-01 11:00:00 |    311 |     211 |      0 |      0 | -32767.0 |       4.2 | 6894900000000000 |           |      | 2010-11-01 11:30:25 | 2010-11-01 16:28:27.028156 |          | 0000001100000000 |  QC2d-2 
(1 rad)

murky:

kvalobs@murky:~$ 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 stationid=64330 and obstime='2010-11-01 11:00:00' and paramid=211;
 stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      | cfailed 
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+---------
     64330 | 2010-11-01 11:00:00 |      3.6 |     211 | 2010-11-01 10:53:28 |    311 | 0      |     0 |       3.6 | 0111100000000010 | 7000000000000000 | 
(1 row)

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?