dbeaver / dbeaver/dbeaver

Java heap space error while importing data: no solutions found

Open
#11,931 8 comments 1 reaction 0 assignees View on GitHub
xf:data xf:datatransfer
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

I cannot import a table of 10 millions of records, neither from a csv file, nor from a table of another database. I have tried with:

1) changing parameters in dbeaver.ini file:

-Xms512m
-Xmx8192m

2) making import with "by segments" option

3) reducing fetching parameter and "commit after rows" parameters

but without success.

Is there any other suggestion? I don't understand why this abnormal use of memory.
Thanks.

- Windows 10
- DBeaver version: 21.0.1
- Database: HSQL, with default driver

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.