Streaming websocket data into a table, blocks `INSERT INTO` data to this table from another source.
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 17.3k
- Forks
- 1.6k
- Avg merge
- 5d 10h
- Merged PRs (30d)
- 28
Description
Describe the bug
A clear and concise description of what the bug is.
To Reproduce
Steps to reproduce the behavior:
- Create two tables: table A and table B. Both table need to have the same schema.
- Populate table B and leave table A empty.
- Stream data into this table A via websocket (I do it via python).
- While data is being saved into table A (multiple rows per second), try and
INSERT INTOdata from table B to table A. - Observe how it's not possible (i.e. the bug).
Expected behavior
I would expect to be able to write to a table with streaming data from multiple streams, via the UI and via other places too.
Screenshots
None.
Environment (please complete the following information):
- OS: Ubuntu 20.04.2 LTS (GNU/Linux 5.4.0-77-generic x86_64)
- Browser: chrome and safari
- Version: 6.0.4
Additional context
This issue became apparent following a Slack discussion here: https://questdb.slack.com/archives/C1NFJEER0/p1629298544172800
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No files or tests are named. Reproduce with two same-schema tables, a Python websocket stream into the empty table, and a concurrent INSERT INTO from the second table; done means both write paths can continue successfully while streaming data is received.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sql
- Domain
- backend, database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100