raster data: undefined column error
I in the course of freshly installing the datapool on my local machine due to issue #47 (closed), I create an elz
, ran update-operational
and this error came up.
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-datapool-1 | - dispatch data/sensor_from_xyz/sensor_abc_from_xyz/raster_data/raster_data_spec.yaml
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-postgis-1 | 2022-06-21 08:33:50.688 UTC [107] ERROR: column raster_data.timestamp does not exist at character 80
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-postgis-1 | 2022-06-21 08:33:50.688 UTC [107] HINT: Perhaps you meant to reference the column "raster_data.timstamp".
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-postgis-1 | 2022-06-21 08:33:50.688 UTC [107] STATEMENT: SELECT raster_data.data
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-postgis-1 | FROM raster_data
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-postgis-1 | WHERE raster_data.source_id = 1 AND raster_data.timestamp = '2020-12-22T13:30:00'::timestamp AND raster_data.parameter_id = 11
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-datapool-1 | error: (psycopg2.errors.UndefinedColumn) column raster_data.timestamp does not exist
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-datapool-1 | LINE 3: WHERE raster_data.source_id = 1 AND raster_data.timestamp = ...
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-datapool-1 | ^
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-datapool-1 | HINT: Perhaps you meant to reference the column "raster_data.timstamp".
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-datapool-1 |
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-datapool-1 | [SQL: SELECT raster_data.data
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-datapool-1 | FROM raster_data
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-datapool-1 | WHERE raster_data.source_id = %(source_id_1)s AND raster_data.timestamp = %(timestamp_1)s AND raster_data.parameter_id = %(parameter_id_1)s]
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-datapool-1 | [parameters: {'source_id_1': 1, 'timestamp_1': datetime.datetime(2020, 12, 22, 13, 30), 'parameter_id_1': 11}]
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-datapool-1 | (Background on this error at: https://sqlalche.me/e/14/f405)
Jun 21 10:33:50 jasmin docker-compose[42768]: docker-datapool-1 | dispatch done