search

noi-techpark / bdp-elaborations

GNU Affero General Public License v3.0
0 stars 4 forks source link

Some elaborations still use the old schema and thus generate errors on prod-pg-bdp #5

Closed Piiit closed 2 years ago

Piiit commented 3 years ago 
2021-01-28 09:29:17 UTC:172.31.43.233(55902):bdp@bdp:[23519]:ERROR:  relation "intime.elaboration" does not exist at character 169
2021-01-28 09:29:17 UTC:172.31.43.233(55902):bdp@bdp:[23519]:STATEMENT:  select * from (SELECT
        elaboration.station_id,
        (elaboration.value - elapsed_time_default) / elapsed_time_default as congestion_index,
        linegeometry
    FROM intime.elaboration
    LEFT JOIN intime.station ON elaboration.station_id=station.id
    LEFT JOIN intime.linkbasicdata ON elaboration.station_id=linkbasicdata.station_id
    WHERE  intime.station.available=TRUE and type_id=918 and stationtype ='Linkstation' and current_timestamp < (intime.elaboration.timestamp + interval '1 hour')
    ) as "vtable" where 1 = 0
Piiit commented 2 years ago

This bug has already been fixed