DBeaver Freezes and Has High CPU Usage with Large Scripts #29996
Labels
bug
sp:5
xf:sql editor
SQL Editor and Editor Services like autocompletion, highlighting, folding, formatting, etc.
xp:major
Milestone
Description
DBeaver 24.0.3 and 24.0.4 freeze when performing certain actions on large script files (5,000 lines for example). This behavior began with 24.0.3 and I have verified that 24.0.2 behaves normally with the same large files. At first, I thought the app had completely hung, but I eventually realized that it will return to normal if I let it sit for 5 - 15 minutes depending on the script and system specs. During this time, the app is constantly using 10% - 25% CPU depending on system specs. I tried a clean install of 24.0.4 on a system that never had DBeaver and I get the same bug. If I then uninstall it and install 24.0.2, everything is fine. Some of the actions that cause the freeze are:
As mentioned above, the app eventually returns to normal after a considerable wait. When executing the script, everything runs normally. In previous versions of DBeaver I have worked with scripts up to 50,000 lines with no issues, but now it trips up on even a few thousand. Below is an example of the types of statements in these scripts. So far I have had the problem with INSERT or UPDATE statements, but haven't tried any deletes lately.
Example script lines:
UPDATE PROCS SET IS_ACTIVE = '0' WHERE PROC_NAME = '17-20AR-29' AND REVISION_LEVEL = '';
UPDATE PROCS SET IS_ACTIVE = '0' WHERE PROC_NAME = '33K1-4-716-1' AND REVISION_LEVEL = '';
UPDATE PROCS SET IS_ACTIVE = '0' WHERE PROC_NAME = '33K2-4-46-1' AND REVISION_LEVEL = '';
UPDATE PROCS SET IS_ACTIVE = '0' WHERE PROC_NAME = '33K3-4-2925-1' AND REVISION_LEVEL = '';
UPDATE PROCS SET IS_ACTIVE = '0' WHERE PROC_NAME = '33K3-4-3410-1' AND REVISION_LEVEL = '';
UPDATE PROCS SET IS_ACTIVE = '0' WHERE PROC_NAME = '33K3-4-3554-1' AND REVISION_LEVEL = '';
DBeaver Version
24.0.3 Community
Operating System
Windows 10 Pro
Database and driver
Database: Microsoft SQL Server 2014
Driver Name: MS SQL Server / SQL Server
Steps to reproduce
No response
Additional context
No response
The text was updated successfully, but these errors were encountered: