influxdata / influxdata/influxdb-comparisons
dead lock of TimescaleDB loading test with 5 workers
- Dominant language
- Go
- Stars
- 313
- Forks
- 110
- PR merge metrics
- No merged PRs in 30d
Description
My postgresql version is 16 and timescaleDB version is 2.14.2.
When I execute the command "bulk_data_gen -format timescaledb-sql -scale-var 10 | bulk_load_timescale -format timescaledb-sql -workers 5",it throws four same errors:"Error writing:Error: Detecting dead locks (SQLSTATE 40P01)", and it finishs with "load finished prematurely: Worker error"
Can you provide some suggestions so that I can complete the bulk_load_timescale program？I will grateful if you can provide some suggestions.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reproducing the reported command, `bulk_data_gen -format timescaledb-sql -scale-var 10 | bulk_load_timescale -format timescaledb-sql -workers 5`, with PostgreSQL 16 and TimescaleDB 2.14.2. Read the `bulk_load_timescale` entry point and trace the worker error reporting around SQLSTATE 40P01; done means the load completes without deadlock errors or premature termination.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100