MySQL Connector 8.2.0 issue about dbeaver HOT 12 OPEN

Yes, the problem happens with and without filtering. As reported in the first post I have increased the maximum memory up to 5Gb and the problem is still there. Using the task monitor I can see the memory occupation growing up to the maximum and then I get Java Heap Space error. DBeaver version 22.3.5 works perfectly with and without filtering out tables and even with a 1Gb of maximum memory.

from dbeaver.

Did you try to use the same version of the mysql-connector-j-8.0.29 and driver mysql-8.0.31-win64?

from dbeaver.

Please make screenshot of libriries

from dbeaver.

I tried to keep the previous mysql-connector-j-8.0.29 but the DBeaver 24.0.4 install procedure forced me to replace it. If you could explain to me how to install it with the latest DBeaver version I will do a try.

from dbeaver.

Using DBeaver from version 23.x.x up to 24.0.4

from dbeaver.

Using DBeaver 22.3.5 (last version which is working well)

from dbeaver.

MySQL driver version common to all DBeaver versions.

from dbeaver.

Please try decreasing the driver version

from dbeaver.

I tried but the problem is still there. I have also tried with the last 24.0.5 version with both connector versions and the problem persists. The last working version is still 22.3.5
EDIT: I have to say that Dbeaver version 22.3.5 uses mysql-connector-j-8.0.29 but with newer DBeaver versions I cannot install connector versions earlier than 8.0.31. So there is still a difference with the connector.

from dbeaver.

@Charles-II
Does it reproducible without filtering?

from dbeaver.

How many tables do you have in this database?
Have you tried changing -Xmx1024m into -Xmx4096m to increase maximum memory to 4Gb in dbeaver.ini file?

from dbeaver.

I would like to add that I'm not the only one facing this problem. The entire team which is working on the same DB has faced the same issue and we are all forced to use DBeaver version 22.3.5. to avoid it.
We are using MySQL InnoDB version 8.0.36 with 234071 tables, 58 tables have more than 1GB of data of which 3 tables have data length of 110GB (72MB index), 226GB (3GB index) and 1207GB (19GB index) .

from dbeaver.