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

tsbs_load_timescaledb option 'replication-factor' was not supported for PostgreSQL versions 16, 17 #268

Open
orcarex opened this issue Mar 19, 2025 · 2 comments

Comments

@orcarex
Copy link

orcarex commented Mar 19, 2025

https://docs.timescale.com/api/latest/distributed-hypertables/set_replication_factor/#set_replication_factor

Multi-node support is sunsetted.

TimescaleDB v2.13 is the last release that includes multi-node support for PostgreSQL versions 13, 14, and 15.

cat /tmp/timescaledb-data.gz | gunzip | ./tsbs_load_timescaledb
--postgres="sslmode=disable"
--host="localhost" --port=5431 --pass="postgres"
--replication-factor=0
--user="postgres" --admin-db-name=postgres --workers=8
--in-table-partition-tag=true --chunk-time=8h --write-profile=
--field-index-count=1 --do-create-db=false --force-text-format=false
--do-abort-on-exist=false
could not execute sql: SELECT create_hypertable('diagnostics'::regclass, 'time'::name, replication_factor => NULL, chunk_time_interval => 28800000000, 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)

@orcarex
Copy link
Author

orcarex commented Mar 19, 2025

goroutine 1 [running]:
github.com/timescale/tsbs/pkg/targets/timescaledb.MustExec(0x1024d7ab4?, {0xc0001d4000, 0x9e}, {0x0?, 0x4?, 0x4?})
/tsbs/pkg/targets/timescaledb/creator.go:296 +0xd0
github.com/timescale/tsbs/pkg/targets/timescaledb.(*dbCreator).createTableAndIndexes(0xc0001561e0, 0xc0000f4340, {0xc000152330, 0xb}, {0xc0000afc40, 0x4, 0x4}, {0xc0000acae0, 0x1, 0x1})
/tsbs/pkg/targets/timescaledb/creator.go:224 +0x6ff
github.com/timescale/tsbs/pkg/targets/timescaledb.(*dbCreator).PostCreateDB(0xc0001561e0, {0x1024b7396?, 0x9?})
/tsbs/pkg/targets/timescaledb/creator.go:105 +0x345
github.com/timescale/tsbs/load.(*CommonBenchmarkRunner).useDBCreator(0xc000216000, {0x1026505f0, 0xc0001561e0})
/tsbs/load/loader.go:252 +0x1bf
github.com/timescale/tsbs/load.(*CommonBenchmarkRunner).preRun(0xc000216000, {0x102650e00, 0xc000114c60})
/tsbs/load/loader.go:128 +0x72
github.com/timescale/tsbs/load.(*CommonBenchmarkRunner).RunBenchmark(0xc000216000, {0x102650e00, 0xc000114c60})
/tsbs/load/loader.go:184 +0x37
main.main()
/tsbs/cmd/tsbs_load_timescaledb/main.go:102 +0x210

@orcarex
Copy link
Author

orcarex commented Mar 19, 2025

  1. remove partitionsOption in /tsbs/pkg/targets/timescaledb/creator.go
Image
  1. then make again

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant