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

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

Open
Alkochm opened this issue Feb 6, 2024 · 1 comment
Labels
feature request Let's add something new xf:sql editor

Comments

@Alkochm
Copy link

Alkochm commented Feb 6, 2024

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

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.

@Alkochm Alkochm added bug Something isn't working wait for review labels Feb 6, 2024
@EvgeniaBzzz
Copy link
Contributor

Hi @Alkochm!
You are right we do not support simultanious queries so far. It's a known issue. We are going to add the capability for simultaneous connections.

Thank you for your request!

@EvgeniaBzzz EvgeniaBzzz added feature request Let's add something new and removed bug Something isn't working wait for review labels Feb 6, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature request Let's add something new xf:sql editor
Projects
None yet
Development

No branches or pull requests

3 participants