任务执行一段时间后报错 before connection was unexpectedly lost.，偶现错误
- Dominant language
- Java
- Stars
- 17.4k
- Forks
- 5.7k
- PR merge metrics
- No merged PRs in 30d
Description
java.io.EOFException: Can not read response from server. Expected to read 720 bytes, read 447 bytes before connection was unexpectedly lost.
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.mysql.cj.protocol.a.SimplePacketReader.readMessageLocal(SimplePacketReader.java:137)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.mysql.cj.protocol.a.SimplePacketReader.readMessage(SimplePacketReader.java:102)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.mysql.cj.protocol.a.SimplePacketReader.readMessage(SimplePacketReader.java:45)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readMessage(TimeTrackingPacketReader.java:62)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readMessage(TimeTrackingPacketReader.java:41)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.mysql.cj.protocol.a.MultiPacketReader.readMessage(MultiPacketReader.java:66)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.mysql.cj.protocol.a.MultiPacketReader.readMessage(MultiPacketReader.java:44)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.mysql.cj.protocol.a.ResultsetRowReader.read(ResultsetRowReader.java:75)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.mysql.cj.protocol.a.ResultsetRowReader.read(ResultsetRowReader.java:42)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.mysql.cj.protocol.a.NativeProtocol.read(NativeProtocol.java:1651)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.mysql.cj.protocol.a.result.ResultsetRowsStreaming.next(ResultsetRowsStreaming.java:194)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.mysql.cj.protocol.a.result.ResultsetRowsStreaming.next(ResultsetRowsStreaming.java:62)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.mysql.cj.jdbc.result.ResultSetImpl.next(ResultSetImpl.java:1813)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:207)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.alibaba.datax.plugin.reader.mysqlreader.MysqlReader$Task.startRead(MysqlReader.java:81)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:57)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164] at java.lang.Thread.run(Thread.java:748)
2024-07-19 09:01:31 [SampleXxlJob.java#analysisStatisticsLog-164]
Contributor guide
No contributing guide indexed for this repository
Research direction
Start at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead (CommonRdbmsReader.java:207) and MysqlReader$Task.startRead (MysqlReader.java:81), where the streaming ResultSet fails. Reproduce the long-running task and investigate the MySQL connection loss shown in the stack trace. Done means the intermittent failure has a documented cause and a verified corrective change or reproduction result.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, mysql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100