dbeaver / dbeaver/cloudbeaver

Simultaneous active queries to one server from one user session are not working

Open
#2,361 3 comments 0 reactions 0 assignees View on GitHub
xf:connection xf:sql editor
Dominant language
TypeScript
Stars
5.1k
Forks
563
Avg merge
3d 9h
Merged PRs (30d)
59

Description

Two or more simultaneous active queries to one server from one user session are not working

Steps to reproduce the behavior:
1. Connect to MSSQL server
2. Open SQL Editor and start long running query (i.e. "WAITFOR DELAY '00:01:00'")
3. Open second SQL Editor and start short simple query (i.e. sp_who2)
4. Second SQLquery will wait untill first query finishes with "Loading..."

![image](https://github.com/dbeaver/cloudbeaver/assets/29176614/89161b1b-a9dc-40f3-9b98-1b5272feb1af)

Simultaneous queries to diferent SQL servers do work in parallel.

Chrome Version 121.0.6167.140

I see that CB opens two connections per user to SQL (Main + Metadata) and it doesn't open additional connections to execute additional simultaneous queries. Also it doesn't seem to use Multiple Active Result Sets on main connection.

It is standard practice to run long query and look who is bloking you or who is blocked by you so I don't see why it should be by design.

Contributor guide

No contributing guide indexed for this repository

Research direction

No source file or test is named. Reproduce the issue against MSSQL with a long WAITFOR DELAY query in one SQL Editor and sp_who2 in another, then trace how CloudBeaver manages connections and concurrent SQL Editor requests within one user session. Done means the second query executes without waiting while the first remains active, as queries to different servers already do.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql, typescript
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.