dbeaver / dbeaver/dbeaver

MySQL stream fetch is broken

Open
#35,490 0 comments 0 reactions 0 assignees View on GitHub
can't reproduce x:mysql xf:data
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 13h
Merged PRs (30d)
183

Description

### Description

Big table data export doesn't work (fails with outofmemory or protocol failure).

Currently we use QueryTransformerFetchAll which sets fetch size to -1 . But it seems to be broken in the new driver or something else is broken on our side.

Workaround: set driver property `useCursorFetch` to TRUE.

Docs: https://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html

### DBeaver Version

24.1

### Operating System

_No response_

### Database and driver

MySQL 8+

### Steps to reproduce

Try to export big table (like 100 million rows) into any file format.

### Additional context

_No response_

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.