search

dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
40.33k stars 3.48k forks source link

DBeaver GUI freezes often #22348

Closed michalk-k closed 9 months ago

michalk-k commented 10 months ago

Description

Since 23.3.0 (or 23.3.1) DBeaver often freezes. It stops refreshing GUI/reacting on inputs for about 5-10 seconds to recover after a while.

Currently cannot confirm it happens only for networked database instances or for db run locally too. But it's frequent and annoying enough to report it. For sure it never happened before.

DBeaver Version

CE 23.3.x

Operating System

Fedora 39

Database and driver

Postgresql 15

Steps to reproduce

No steps. It's random.

Additional context

N/A

philosaur commented 10 months ago

I'm experiencing this too. Periodic 3-7 second stutters that, in my experience, most often occurs when switching from one query window to another.

DBeaver 23.3.1, Postgres DB over SSH, Windows 10

codefossa commented 10 months ago

I am experiencing a similar issue with the flatpak release. Since the upgrade to 23.3.1 it seems the way query syntax is being highlighted is causing an issue, which is only based on visual observation. It appears to freeze and after 5 or so seconds will either unfreeze, or more often crash showing JVM terminated. Exit code=1 along with the java command.

Flathub commit 652677a3c415190abc13152b9ad009f3be73d98ca4fde2cd2122b87f7195ffb0 (23.3.0) works normally. Flathub commit 9a3361dca0a99dc276da64d45a5b967ed665f58dc44b7420ba843563e369e1e1 (23.3.1) freezes / crashes.

For others in my situation, a temporary solution is to downgrade to 23.3.0:

flatpak update --commit 652677a3c415190abc13152b9ad009f3be73d98ca4fde2cd2122b87f7195ffb0 io.dbeaver.DBeaverCommunity
n5a5 commented 10 months ago

Hi folks. Can you try disabling our experimental parser and see if it fixes the issue?

image
codefossa commented 10 months ago

I've upgraded to the 23.3.2 flatpak and don't appear to be able to recreate the freeze issue so this may not matter longer.

For the sake of answering your question. Downgrading back to 23.3.1 makes it very easy to immediately replicate the issue. I've disabled the option you've highlighted in your image and it does not disable the new syntax highlighting for me. I tried reopening the application as well which still did not prevent the syntax highlighting or the crashes.

If you would like anything else tested, I would be happy to do so, but since this seems to be resolved in 23.3.2 I think we're good to resolve this.

michalk-k commented 9 months ago

I can confirm that after update to 23.3.2 I never noticed the freeze anymore.

E1izabeth commented 9 months ago

Thank you for update. I'm closing the issue then.