search

timescale / tsbs

Time Series Benchmark Suite, a tool for comparing and evaluating databases for time series data
MIT License
1.24k stars 293 forks source link

Fixed timescaledb loader initialization #255

Open Koheiru opened 1 month ago

Koheiru commented 1 month ago

At some point timescaledb's function create_hypertable became more strict and it starts to fail if 'replication_factor => NULL' part exists. In such case tsbs_load failed with error:

could not execute sql: SELECT create_hypertable('disk'::regclass, 'time'::name, replication_factor => NULL, chunk_time_interval => 43200000000, create_default_indexes=>FALSE)panic: ERROR: function create_hypertable(regclass, name, replication_factor => unknown, chunk_time_interval => bigint, create_default_indexes => boolean) does not exist (SQLSTATE 42883)

Other users also report about this issue: #248

To fix this issue timescaledb table initialization method was adjusted.

tomchon commented 2 weeks ago

has anyone merged this fix into the master branch? @Koheiru