This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
commit e50a42711379ee0ee2d44fda0bfa942ead2d030d
Author: Petrichor <31833513+vinle...@users.noreply.github.com>
AuthorDate: Fri Feb 23 20:33:25 2024 +0800
[improvment](doc) add FAQ for Jdbc catalog (#31338)
---
docs/en/docs/lakehouse/multi-catalog/jdbc.md | 2 ++
docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md | 3 +++
2 files changed, 5 insertions(+)
diff --git a/docs/en/docs/lakehouse/multi-catalog/jdbc.md
b/docs/en/docs/lakehouse/multi-catalog/jdbc.md
index b0019373f72..7929e34f756 100644
--- a/docs/en/docs/lakehouse/multi-catalog/jdbc.md
+++ b/docs/en/docs/lakehouse/multi-catalog/jdbc.md
@@ -993,3 +993,5 @@ It is recommended to use the following versions of Driver
to connect to the corr
You can download the
[lz4-1.3.0.jar](https://repo1.maven.org/maven2/net/jpountz/lz4/lz4/1.3.0/lz4-1.3.0.jar)
package first, and then put it in DorisFE lib directory and BE's
`lib/lib/java_extensions` directory (versions before Doris 2.0 need to be
placed in BE's lib directory).
Starting from version 2.0.2, this file can be placed in the `custom_lib/`
directory of FE and BE (if it does not exist, just create it manually) to
prevent the file from being lost due to the replacement of the lib directory
when upgrading the cluster.
+
+11. If there is a prolonged delay or no response when querying MySQL through
JDBC catalog, or if it hangs for an extended period and a significant number of
"write lock" logs appear in the fe.warn.log, consider adding a socketTimeout
parameter to the URL. For example:
`jdbc:mysql://host:port/database?socketTimeout=30000`. This prevents the JDBC
client from waiting indefinitely after MySQL closes the connection.
diff --git a/docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md
b/docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md
index 00ef1afcf65..fe308c44487 100644
--- a/docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md
+++ b/docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md
@@ -996,3 +996,6 @@ CREATE CATALOG jdbc_oceanbase PROPERTIES (
可以先下载[lz4-1.3.0.jar](https://repo1.maven.org/maven2/net/jpountz/lz4/lz4/1.3.0/lz4-1.3.0.jar)包，然后放到DorisFE
lib 目录以及BE 的 `lib/lib/java_extensions`目录中（Doris 2.0 之前的版本需放到 BE 的 lib 目录下）。
从 2.0.2 版本起，可以将这个文件放置在 FE 和 BE 的 `custom_lib/` 目录下（如不存在，手动创建即可），以防止升级集群时因为
lib 目录被替换而导致文件丢失。
+
+11. 如果通过 Jdbc catalog 查询 MySQL 的时候，出现长时间卡住没有返回结果，或着卡住很长时间并且 fe.warn.log
中出现出现大量 write lock 日志，可以尝试在 url 添加 socketTimeout
，例如：`jdbc:mysql://host:port/database?socketTimeout=30000` ， 防止 MySQL 在关闭连接后
Jdbc 客户端无限等待。
+
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
