dbeaver / dbeaver/cloudbeaver

[Execute SQL Script] hangs when consecutive postgresql queries finish quickly

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

Description

### Description

CloudBeaver intermittently hangs while executing multiple fast PostgreSQL statements.

With `pg_sleep(0.01)`, execution occasionally stops before all results appear and remains loading indefinitely. With `pg_sleep(0.1)`, it usually succeeds.

The issue also occurs through kubectl port-forward, bypassing the Ingress and ALB.

### Steps to reproduce

1. Open SQL Editor
2. Write SQL below
```sql
SELECT pg_sleep(0.1), pg_backend_pid(), 1;
SELECT pg_sleep(0.1), 2;
SELECT pg_sleep(0.1), 3;
SELECT pg_sleep(0.1), 4;
SELECT pg_sleep(0.1), 5;
```
3. [Execute SQL Script] 5 times -> `Usually succeeds`
4. Write SQL below
```sql
SELECT pg_sleep(0.01), pg_backend_pid(), 1;
SELECT pg_sleep(0.01), 2;
SELECT pg_sleep(0.01), 3;
SELECT pg_sleep(0.01), 4;
SELECT pg_sleep(0.01), 5;
```
5. [Execute SQL Script] 5 times-> `Often hangs`

### Expected/Desired Behavior

All five statements should complete, all results should appear, and the loading state should end on every execution.

```sql
SELECT 1;
SELECT 2;
SELECT 3;
SELECT 4;
SELECT 5;
```

### CloudBeaver Version

26.1.5

### Additional context

- CloudBeaver Community: 26.1.5
- Image: `dbeaver/cloudbeaver:26.1.5`
- Replicas: 1
- CPU: request 100m, limit 1 core
- Memory: request 512 MiB, limit 1 GiB
- Increasing the container resources from 1 CPU / 1 GiB to 2 CPUs / 4 GiB did not change the behavior.
- Database: PostgreSQL
- Browser: Firefox 154.0.1 (64bit)
- Client OS: MacOS 26.4.1

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.