New update causing issues.

[junghao]

Downstream services failed due to sending the following query which created unexpected result:

https://service.geonet.org.nz/fdsnws/station/1/query?level=channel&format=text&network=NZ&endafter=2033-03-19&startbefore=2023-03-19

A rollback as emergency fix has applied.

[junghao]

Detail:

When queried with query?level=channel&format=text&network=NZ&endafter=2033-03-19&startbefore=2023-03-19&station=WN*

Got the result of:

#Network | Station | Location | Channel | Latitude | Longitude | Elevation | Depth | Azimuth | Dip | SensorDescription | Scale | ScaleFreq | ScaleUnits | SampleRate | StartTime | EndTime
NZ|WN||||||
NZ|WNAS|20|HN1|-41.326409|174.809034|14.000000|0.000000|37.000000|0.000000|Strong Motion Sensor|101971.621298|1.000000|m/s**2|200.000000|2015-04-29T00:10:00|
NZ|WNAS|20|HN2|-41.326409|174.809034|14.000000|0.000000|127.000000|0.000000|Strong Motion Sensor|101971.621298|1.000000|m/s**2|200.000000|2015-04-29T00:10:00|
NZ|WNAS|20|HNZ|-41.326409|174.809034|14.000000|0.000000|0.000000|-90.000000|Strong Motion Sensor|101971.621298|1.000000|m/s**2|200.000000|2015-04-29T00:10:00|
NZ|WNHS|20|HN1|-41.300778|174.775514|43.000000|0.000000|85.000000|0.000000|Strong Motion Sensor|101971.621298|1.000000|m/s**2|200.000000|2015-04-14T00:00:05|
NZ|WNHS|20|HN2|-41.300778|174.775514|43.000000|0.000000|175.000000|0.000000|Strong Motion Sensor|101971.621298|1.000000|m/s**2|200.000000|2015-04-14T00:00:05|
NZ|WNHS|20|HNZ|-41.300778|174.775514|43.000000|0.000000|0.000000|-90.000000|Strong Motion Sensor|101971.621298|1.000000|m/s**2|200.000000|2015-04-14T00:00:05|
NZ|WNKS|20|HN1|-41.284818|174.742054|181.000000|0.000000|149.000000|0.000000|Strong Motion Sensor|101971.621298|1.000000|m/s**2|200.000000|2023-01-12T20:59:00|
NZ|WNKS|20|HN2|-41.284818|174.742054|181.000000|0.000000|239.000000|0.000000|Strong Motion Sensor|101971.621298|1.000000|m/s**2|200.000000|2023-01-12T20:59:00|
NZ|WNKS|20|HNZ|-41.284818|174.742054|181.000000|0.000000|0.000000|-90.000000|Strong Motion Sensor|101971.621298|1.000000|m/s**2|200.000000|2023-01-12T20:59:00|
NZ|WNPS|20|HN1|-44.694588|169.142964|287.000000|0.000000|7.000000|0.000000|Strong Motion Sensor|101971.621298|1.000000|m/s**2|200.000000|2016-05-26T00:16:22|
NZ|WNPS|20|HN2|-44.694588|169.142964|287.000000|0.000000|97.000000|0.000000|Strong Motion Sensor|101971.621298|1.000000|m/s**2|200.000000|2016-05-26T00:16:22|
NZ|WNPS|20|HNZ|-44.694588|169.142964|287.000000|0.000000|0.000000|-90.000000|Strong Motion Sensor|101971.621298|1.000000|m/s**2|200.000000|2016-05-26T00:16:22|
NZ|WNVZ|11|EH1|-39.326997|175.597862|1566.000000|52.000000|340.000000|0.000000|Short Period Borehole Seismometer|834834268.160000|15.000000|m/s|100.000000|2017-05-30T11:40:01|
NZ|WNVZ|11|EH2|-39.326997|175.597862|1566.000000|52.000000|70.000000|0.000000|Short Period Borehole Seismometer|834834268.160000|15.000000|m/s|100.000000|2017-05-30T11:40:01|
NZ|WNVZ|11|EHZ|-39.326997|175.597862|1566.000000|52.000000|0.000000|90.000000|Short Period Borehole Seismometer|834834268.160000|15.000000|m/s|100.000000|2017-05-30T11:40:01|
NZ|WNVZ|30|HDF|-39.326997|175.597862|1566.000000|0.000000|0.000000|0.000000|Barometer|4194.304000|15.000000|hPa|100.000000|2017-05-31T19:00:00|
NZ|WNZ||||||

The rows without channel don't have enough separator thus caused the downstream parser failed.

[salichon]

endafter=2033-03-19 looks like very weird - not very logical? ha. (should that be allowed at first place ?)

[junghao]

Most of active sites having endDate of 9999-01-01, and the query is generated by geonet-api which use "a year later" as default of backend query.