Skip to content

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

Description

@FGPRJS

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
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;
  1. [Execute SQL Script] 5 times -> Usually succeeds
  2. Write SQL below
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;
  1. [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.

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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions