Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error when using interpolated_delta during DST #790

Open
Countrycoin-de opened this issue Jan 4, 2024 · 0 comments
Open

Error when using interpolated_delta during DST #790

Countrycoin-de opened this issue Jan 4, 2024 · 0 comments
Labels
bug Something isn't working

Comments

@Countrycoin-de
Copy link

Relevant system information:

  • OS: Debian GNU/Linux 12
  • PostgreSQL version: PostgreSQL 14.10
  • TimescaleDB: 2.12.2
  • TimescaleDB Toolkit: 1.18.0
  • Installation method: self-hosted

Describe the bug
When using interpolated_delta during DST for DE , an error is received:

grafik

The error only occurs if the parameter "interval" is >= '1 day', so '2 day', '1 month' ... does not work.
The error does NOT occur if "interval" is < '1 day', i.e. '15 min', '1 hour' even '24 hour' or '48 hour' works.

The error only occurs if the entire time series runs over a period, in which the changeover from winter time -> summer time takes place (in spring).

The error does NOT occur during the transition from summer time -> winter time (in the fall).

To Reproduce
My test script:
test_code.txt

My table definition:
table_definition_counters.txt

Some test-data
counter_data.csv

Expected behavior
Should return result instead of an error.
All intervals should be possible, even with any change of time changeover (DST).

Actual behavior
Error is received:
ERROR: unable to add final interpolated point: OrderError

Screenshots
N/A

Additional context
I used the following example:
https://www.timescale.com/forum/t/dear-eon-measuring-deltas-correctly-for-smart-energy-meters/1266/3

Maybe the same/similar to this:
Error when using interpolated_average during DST
#788

@Countrycoin-de Countrycoin-de added the bug Something isn't working label Jan 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant