Kettle Automatically Disconnects When Writing to TiDB

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: kettle写入tidb自动断开

| username: TiDBer_TVKpabeM

【TiDB Usage Environment】Production Environment / Testing / PoC
【TiDB Version】
【Reproduction Path】What operations were performed when the issue occurred
Pushing data from Kettle to TiDB
【Encountered Issue: Problem Phenomenon and Impact】
Kettle displays an issue


Packet capture confirmed that TiDB actively disconnected
【Resource Configuration】Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
【Attachments: Screenshots/Logs/Monitoring】

Check logs and monitoring as shown in the image

| username: RenlySir | Original post link

Connection link failure can refer to 连接池与连接参数 | PingCAP 文档中心 and the Asktug posts. Additionally, you can also try reducing the batch size for Kettle imports.

| username: RenlySir | Original post link

“Negative Repeat Count” probably means “负重复次数”. Take a look at the logic of batch splitting in Kettle.

| username: tidb狂热爱好者 | Original post link

This error is generally due to too many connections, which makes it too busy to handle. Replace it with OOM (Out of Memory) in this case.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.