Skip to content

[Bug] Memory consumption of JDBC MySQL Driver #7028

@KKtwo

Description

@KKtwo

Search before asking

  • I had searched in the issues and found no similar issues.

Version

0.14.0

What's Wrong?

Describe the bug
我的项目部署在docker中,当我使用jdbc:mysql连接doris查询3000W行数据的时候,内存消耗过大OOM,导致项目自动重启了,我的连接信息是
My project is deployed in Docker. When I used JDBC :mysql to connect Doris to query 3000W rows of data, the memory consumption was too large, causing the project to restart automatically. My connection information is
jdbc:mysql://$host:$port/$database?zeroDateTimeBehavior=convertToNull&tinyInt1isBit=false&useUnicode=true&characterEncoding=UTF8&useCursorFetch=true
并且设置了FetchSize
val settings = new Settings().withParamType(ParamType.INLINED).withFetchSize(500).withStatementType(StatementType.STATIC_STATEMENT)
我也尝试把FetchSize设置为Integer.MIN_VALUE,但是还是出现了OOM
驱动的版本是mysql-connector-java-5.1.47.jar
image
As far as I know, this problem was fixed in version 0.14.0

What You Expected?

fixed

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Assignees

No one assigned

    Labels

    kind/fixCategorizes issue or PR as related to a bug.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions