Server hangs after too many connections in USER isolation level [Bug]

[hanna-liashchuk]

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

Search before asking

• [X] I have searched in the issues and found no similar issues.

Describe the bug

If you run too many queries in parallel from one user in engine share level USER, the Kyuubi server gets stuck and does not release connections. The jobs just hang without finishing

Affects Version(s)

1.7.0/1.7.1

Kyuubi Server Log Output

No response

Kyuubi Engine Log Output

No response

Kyuubi Server Configurations

kyuubi.engine.share.level=USER;

Kyuubi Engine Configurations

No response

Additional context

I can reproduce this issue by running a test plan in Jmeter with 30 threads(users) and ramp-up period - 600. Server restart helps

Are you willing to submit PR?

• [ ] Yes. I would be willing to submit a PR with guidance from the Kyuubi community to fix.
• [X] No. I cannot submit a PR at this time.

[pan3793]

Have you looked at the jstack output?