Table UI view freezes

[PedroCostaMudey]

Description

The table UI freezes and I have to restart Dbeaver.
I still can press some buttons and some of other parts other then the table view show changes (very slowly).

DBeaver Version

Community Edition 23.2.0

Operating System

Ubuntu 22.04

Database and driver

mariadb mysql:8.0.20

docker container

Steps to reproduce

This only happens sometimes when I change to other application and come back with alt tab.

Additional context

No response

[Destrolaric]

Hi, Could you please try to generate a thread dump when it happens and attach it here? Here is the instruction: https://dbeaver.com/docs/wiki/Making-a-thread-dump/
Thank you.

[bodewig]

I'm not the original reporter but I'm seeing the same using dbeaver-ce installed via snap. While trying to create a thread dump I noticed pgrep simply doesn't find the PID and running jstack in the process manually results in

Unable to open socket file /proc/730091/root/tmp/.java_pid730091: target process 730091 doesn't respond within 10500ms or HotSpot VM not loaded

I'll use a version installed manually and report whether this changes things.

[bodewig]

I'm not a heavy user of dbeaver myself. Yesterday I used it for a few hours and had freezes every quarter of an hour. After switching to a non-snap version and working with it for a few more hours I have not seen any freezes at all. This doesn't proof there are no freezes anymore, of course.

Maybe other people facing the same problem can try the "nojdk" tar.gz (which is what I used).

BTW whenever dbeaver wants to show a popup I see GTK logging a warning like

(DBeaver:759071): Gtk-WARNING **: 12:38:26.872: Negative content width -8 (allocation 5, extents 6x7) while allocating gadget (node separator, owner GtkSeparatorToolItem)

[lubakka]

I have the same problem. Can you fix it? I'll wait for a fix.

[DandyEPurwanto]

i got the same issue, its almost always happened after I minimize the dbeaver

[jtcours]

I'm running into a similar issue, usually after minimizing dbeaver and then expanding it again. Ubuntu 22.04.3 LTS running xwayland 22.1.1-1ubuntu0.7 and gnome.

Ubuntu 22.04 uses snap to run dbeaver, which (I think) causes the standard instructions for getting a thread dump to fail and seems to interfere with jstack.

$ pgrep dbeaver
$ pgrep dbeaver-ce
$ pgrep '/snap/dbeaver-ce/'
$ ps -e -o pid,args | grep dbeaver
  87081 /snap/dbeaver-ce/268/usr/share/dbeaver-ce/jre/bin/java -XX:+IgnoreUnrecognizedVMOptions -Dosgi.requiredJavaVersion=17 -Dfile.encoding=UTF-8 --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.lang.reflect=ALL-UNNAMED --add-opens=java.base/java.net=ALL-UNNAMED --add-opens=java.base/java.nio=ALL-UNNAMED --add-opens=java.base/java.nio.charset=ALL-UNNAMED --add-opens=java.base/java.text=ALL-UNNAMED --add-opens=java.base/java.time=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.util.concurrent=ALL-UNNAMED --add-opens=java.base/java.util.concurrent.atomic=ALL-UNNAMED --add-opens=java.base/jdk.internal.vm=ALL-UNNAMED --add-opens=java.base/jdk.internal.misc=ALL-UNNAMED --add-opens=java.base/sun.nio.ch=ALL-UNNAMED --add-opens=java.base/sun.security.ssl=ALL-UNNAMED --add-opens=java.base/sun.security.action=ALL-UNNAMED --add-opens=java.base/sun.security.util=ALL-UNNAMED --add-opens=java.security.jgss/sun.security.jgss=ALL-UNNAMED --add-opens=java.security.jgss/sun.security.krb5=ALL-UNNAMED --add-opens=java.desktop/java.awt=ALL-UNNAMED --add-opens=java.desktop/java.awt.peer=ALL-UNNAMED --add-opens=java.sql/java.sql=ALL-UNNAMED -Xms64m -Xmx1024m -Ddbeaver.distribution.type=deb -jar /snap/dbeaver-ce/268/usr/share/dbeaver-ce/plugins/org.eclipse.equinox.launcher_1.6.500.v20230717-2134.jar -os linux -ws gtk -arch x86_64 -showsplash -launcher /snap/dbeaver-ce/268/usr/share/dbeaver-ce/dbeaver -name Dbeaver --launcher.library /snap/dbeaver-ce/268/usr/share/dbeaver-ce/plugins/org.eclipse.equinox.launcher.gtk.linux.x86_64_1.2.700.v20221108-1024/eclipse_11801.so -startup /snap/dbeaver-ce/268/usr/share/dbeaver-ce/plugins/org.eclipse.equinox.launcher_1.6.500.v20230717-2134.jar --launcher.overrideVmargs -exitdata e8038 -vm /snap/dbeaver-ce/268/usr/share/dbeaver-ce/jre/bin/java -vmargs -XX:+IgnoreUnrecognizedVMOptions -Dosgi.requiredJavaVersion=17 -Dfile.encoding=UTF-8 --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.lang.reflect=ALL-UNNAMED --add-opens=java.base/java.net=ALL-UNNAMED --add-opens=java.base/java.nio=ALL-UNNAMED --add-opens=java.base/java.nio.charset=ALL-UNNAMED --add-opens=java.base/java.text=ALL-UNNAMED --add-opens=java.base/java.time=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.util.concurrent=ALL-UNNAMED --add-opens=java.base/java.util.concurrent.atomic=ALL-UNNAMED --add-opens=java.base/jdk.internal.vm=ALL-UNNAMED --add-opens=java.base/jdk.internal.misc=ALL-UNNAMED --add-opens=java.base/sun.nio.ch=ALL-UNNAMED --add-opens=java.base/sun.security.ssl=ALL-UNNAMED --add-opens=java.base/sun.security.action=ALL-UNNAMED --add-opens=java.base/sun.security.util=ALL-UNNAMED --add-opens=java.security.jgss/sun.security.jgss=ALL-UNNAMED --add-opens=java.security.jgss/sun.security.krb5=ALL-UNNAMED --add-opens=java.desktop/java.awt=ALL-UNNAMED --add-opens=java.desktop/java.awt.peer=ALL-UNNAMED --add-opens=java.sql/java.sql=ALL-UNNAMED -Xms64m -Xmx1024m -Ddbeaver.distribution.type=deb -jar /snap/dbeaver-ce/268/usr/share/dbeaver-ce/plugins/org.eclipse.equinox.launcher_1.6.500.v20230717-2134.jar
  89179 grep --color=auto dbeaver
$ which jstack
$ find /snap/dbeaver-ce/268/ -name jstack -print
/snap/dbeaver-ce/268/usr/share/dbeaver-ce/jre/bin/jstack
$ /snap/dbeaver-ce/268/usr/share/dbeaver-ce/jre/bin/jstack 87081
87081: Unable to open socket file /proc/87081/root/tmp/.java_pid87081: target process 87081 doesn't respond within 10500ms or HotSpot VM not loaded
$ 

Edit: here's some more information. When I minimize dbeaver with a SQL script open, I get these messages in /var/log/syslog:

Nov 16 11:22:46 jcours-framework kernel: [190457.193287] audit: type=1400 audit(1700162566.536:1244): apparmor="DENIED" operation="open" class="file" profile="snap.dbeaver-ce.dbeaver-ce" name="/etc/pulse/client.conf" pid=87081 comm="java" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
Nov 16 11:22:46 jcours-framework kernel: [190457.193774] audit: type=1400 audit(1700162566.536:1245): apparmor="DENIED" operation="connect" class="file" profile="snap.dbeaver-ce.dbeaver-ce" name="/run/user/1000/pulse/native" pid=87081 comm="java" requested_mask="wr" denied_mask="wr" fsuid=1000 ouid=1000
Nov 16 11:22:53 jcours-framework gnome-shell[2375]: Window manager warning: Ping serial 190459076 was reused for window W794, previous use was for window 0xa001c9.
Nov 16 11:23:16 jcours-framework gnome-shell[2375]: Window manager warning: Ping serial 190482084 was reused for window 0xa001c9, previous use was for window W794.
Nov 16 11:23:20 jcours-framework kernel: [190491.162320] audit: type=1400 audit(1700162600.504:1246): apparmor="DENIED" operation="open" class="file" profile="snap.dbeaver-ce.dbeaver-ce" name="/etc/pulse/client.conf" pid=87081 comm="java" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
Nov 16 11:23:20 jcours-framework kernel: [190491.162536] audit: type=1400 audit(1700162600.504:1247): apparmor="DENIED" operation="connect" class="file" profile="snap.dbeaver-ce.dbeaver-ce" name="/run/user/1000/pulse/native" pid=87081 comm="java" requested_mask="wr" denied_mask="wr" fsuid=1000 ouid=1000

Expanding it after a while produces these and a hung SQL editor window:

Nov 16 11:28:39 jcours-framework kernel: [190810.225785] audit: type=1400 audit(1700162919.560:1282): apparmor="DENIED" operation="open" class="file" profile="snap.dbeaver-ce.dbeaver-ce" name="/etc/pulse/client.conf" pid=87081 comm="java" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
Nov 16 11:28:39 jcours-framework kernel: [190810.225963] audit: type=1400 audit(1700162919.560:1283): apparmor="DENIED" operation="connect" class="file" profile="snap.dbeaver-ce.dbeaver-ce" name="/run/user/1000/pulse/native" pid=87081 comm="java" requested_mask="wr" denied_mask="wr" fsuid=1000 ouid=1000

Clicking within the SQL script or the Databases tab produces no response. The menus (File, Help, etc.) at the top still pop up when I click on them, and I'm able to select a different databsae on the same connection through the database selection dropdown.

Mousing over the database connections sometimes produces the popup with name, url, and user, but it's inconsistent and sends these messages to /var/log/syslog:

Nov 16 11:37:00 jcours-framework kernel: [191311.227927] audit: type=1400 audit(1700163420.553:1400): apparmor="DENIED" operation="open" class="file" profile="snap.dbeaver-ce.dbeaver-ce" name="/etc/pulse/client.conf" pid=87081 comm="java" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
Nov 16 11:37:00 jcours-framework kernel: [191311.228152] audit: type=1400 audit(1700163420.553:1401): apparmor="DENIED" operation="connect" class="file" profile="snap.dbeaver-ce.dbeaver-ce" name="/run/user/1000/pulse/native" pid=87081 comm="java" requested_mask="wr" denied_mask="wr" fsuid=1000 ouid=1000

Clicking in the SQL scirpt window and trying to type produces no response.

[DandyEPurwanto]

any update on this issue ?

[petrisorciprian-vitals]

Confirming, also experiencing this issue with snap.
Version installed via apt on Debian using the .deb package has no such problems.

[lubakka]

The problem is still not solved. I'm still waiting on fix.

[martinyonatann]

i have same problem on ubuntu

[petrisorciprian-vitals]

@mayerro
Could you kindly provide some information as to why this was closed?
Was it fixed/will it be fixed?
If so, any ETA available ?

Thank you for your work!

[batosti]

I got the same issue here, have any workarround that we can do?

[Destrolaric]

@petrisorciprian-vitals This should have been fixed in this release. Are you using snap release?

[petrisorciprian-vitals]

@Destrolaric
I tried the snap release a couple of days ago, version 23.3.2 of dbeaver.

After some time, the UI would freeze up, and I'd have to restart dbeaver in order to get it to work again.
I noticed it especially does this when I minimze and bring the window up again.
This happened consistently throughout the day. I experienced the same behaviour on the prior release (23.3.1), also instaled via snap.

The .deb has no such issues, so I reverted to that in the meantime.

[Dzyamon]

Hi,
For me Dbeaver (Version 23.3.2.202401072024) main window freezes but upper nav menu is available and when exiting asks about saving as usual.
I noticed this freeze bug when switching windows with "Alt+Tab" combination on Ubuntu 22.04.3 LTS Wayland (Gnome v42.9).
When clicking separate windows as usual no freeze.

[shubhambarudwale]

Facing the same issue.

[brenoatgetmomo]

Installing by downloading from the website, instead of using snap solved to me.
The downside its not updating it automatically and every two days receiving the message to update it.

[davidtopalov]

Ubuntu 24.10 here. dbeaver installed via Ubuntu App Center (which works with snap). Had the same problem with the freezing tables when switching between tabs/screens/apps.
Downloaded the .deb package from the official dbeaver website and installed it. Works fine ever since.
Thanks for the valuable comment!

[monterhealth]

Facing the same very annoying issue.

DBeaver freezes all the time when I navigate to another window and click back to DBeaver. Restarting DBeaver is then required. Is there any way to solve this? This is not workable.

Operating System: Ubuntu 22.04.4 LTS
DBeaver version: 24.2.0.202409011551

[ShadelessFox]

Hi @monterhealth,

Unfortunately, such a complaint won't give us any insight into what actually causes your issue. Instead, during a freeze, please make a thread dump, as well as log files.

You can find instructions here:

• https://github.com/dbeaver/dbeaver/wiki/Making-a-thread-dump
• https://github.com/dbeaver/dbeaver/wiki/Log-files#dbeaver-log-files

[Tuyuyi99]

Hello,

I think I just resolved this bug in my computer.
It is someway related with Wayland. I changed it to Xorg And it works like a charm. Have you tried that?

To change from wayland to Xorg you have to edit the next files:

/etc/gdm3/custom.conf

In this file, uncomment the line with "WaylandEnable=false"

~/.bashrc or ~/.zshrc

Add the next line at the end of the file:
export QT_QPA_PLATFORM=xcb

And restart the computer.

I hope it helps :)

[khalt00]

Hi, @Tuyuyi99 I haven't try your solution yet but will this affect other apps ?
I think the fix should come from dbeaver, not our machine

[Tuyuyi99]

Hi, @Tuyuyi99 I haven't try your solution yet but will this affect other apps ? I think the fix should come from dbeaver, not our machine

Yes, it will affect other apps too, but it's the only solution I found for this problem :(

[vlasvlasvlas]

same here

[bmelman]

DBeaver has been freezing on multimonitor systems running Ubuntu (at least 18.x till 24.04) all the time, usually after switching focus to a different screen or workspace.

[ShadelessFox]

Please don't post unconsolidated comments like "+1" or "same issue"; they are pointless and don't shine any light on the issue. Instead, provide at least some basic information such as OS name and DBeaver version. This alone will help us greatly.

[faireks]

I deleted my comment from guthub. Version DBeaver: Version 24.3.5.202502162012 (and previous). OS: Ubuntu 22.04.1 Two monitors.

[Arthur-quiteja]

Hi, @Tuyuyi99 I haven't try your solution yet but will this affect other apps ? I think the fix should come from dbeaver, not our machine

Yes, it will affect other apps too, but it's the only solution I found for this problem :(

did you have a example of what kind of issues this fix can cause in ohter apps?

[guybrand]

Hi.

I'm having the same issue, Ubuntu 24.04.2 LTS, multiple displays, Dbeaver Version 25.0.5.202505181758.
I cannot go back to X cause I it causes other issues, especially with screen sharing and preformance.

The freeze happens to me various times a day, so I can easily reconstruct and run any needed command to debug, and assist in resolving this, just LMK

[ShadelessFox]

You can try launching DBeaver with GDK_BACKEND=x11. Solves some issues for me on KDE as well.

[jimddavis]

What solved my problem was allocating more memory to DBeaver processes. This is done in the .ini file. Below was copied from Googles AI response, but is exactly how I did it.

Here's how to do it:
Locate the dbeaver.ini file: This file is typically found in the DBeaver installation directory or in your user's application data folder (e.g., C:\Users<User>\AppData\Local\DBeaver).
Open the dbeaver.ini file: You can open it with a text editor like Notepad.
Find the -Xmx parameter: Look for a line that starts with -Xmx (e.g., -Xmx1024m). This specifies the maximum memory in megabytes (MB) that DBeaver can use.
Change the value: Increase the number after -Xmx to your desired memory limit (e.g., -Xmx4096m for 4GB). You can also set the initial memory with -Xms (e.g., -Xms2048m for 2GB).
Save the file: Save the modified dbeaver.ini file.
Restart DBeaver: You'll need to restart DBeaver for the changes to take effect.

[Tuyuyi99]

Hi, @Tuyuyi99 I haven't try your solution yet but will this affect other apps ? I think the fix should come from dbeaver, not our machine

Yes, it will affect other apps too, but it's the only solution I found for this problem :(

did you have a example of what kind of issues this fix can cause in ohter apps?

Hello. I personally didn't experimented any problem from the apps that I use for my work, so I don't know what problems can cause. As far as I know, it works like a charm for me.