search

timescale / tsbs

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

The specified user is not valid #178

Closed HuangSongZ closed 2 years ago

HuangSongZ commented 2 years ago 
$ cat /tmp/timescaledb-queries-breakdown-frequency.gz | gunzip | ~/go/bin/tsbs_run_queries_timescaledb --postgres="host=localhost user=hs sslmode=disable"
2021-09-17 15:26:28.469 CST [75497] FATAL:  role "postgres" does not exist
panic: failed to connect to `host=localhost user=postgres database=benchmark`: server error (FATAL: role "postgres" does not exist (SQLSTATE 28000))

goroutine 20 [running]:
github.com/timescale/tsbs/pkg/query.(*BenchmarkRunner).processorHandler(0xc0001300c0, 0x0, 0x0, 0x0, {0x1504ca8, 0xc000157270}, 0x0)
    /Users/huangsong/yMatrix/tsbs/pkg/query/benchmarker.go:227 +0x1d6
created by github.com/timescale/tsbs/pkg/query.(*BenchmarkRunner).Run
    /Users/huangsong/yMatrix/tsbs/pkg/query/benchmarker.go:160 +0x1e5

I have specified user=hs, but panic: FATAL: role "postgres" does not exist

jonatas commented 2 years ago

Hi @hanson69, I think you need to pass the --user instead of part of the queries.

See an example here: https://github.com/timescale/tsbs/blob/master/scripts/full_cycle_minitest/full_cycle_minitest_timescaledb.sh#L25

Closing the issue, feel free to reopen if it does not fix.