lovegq commented on issue #7998:
URL: https://github.com/apache/seatunnel/issues/7998#issuecomment-2469376506
即便设置 sink 的max-retry 也会出现这个问题
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: The last
packet successfully received from the server was 20,539,370 milliseconds ago.
The last packet sent successfully to the server was 20,539,379 milliseconds
ago. is longer than the server configured value of 'wait_timeout'. You should
consider either expiring and/or testing connection validity before use in your
application, increasing the server configured values for client timeouts, or
using the Connector/J connection property 'autoReconnect=true' to avoid this
problem.
at
jdk.internal.reflect.GeneratedConstructorAccessor36.newInstance(Unknown Source)
~[?:?]
at
jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
~[?:?]
at
java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499) ~[?:?]
at java.lang.reflect.Constructor.newInstance(Constructor.java:480)
~[?:?]
at
com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
~[mysql-connector-j-8.0.33.jar:8.0.33]
at
com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
~[mysql-connector-j-8.0.33.jar:8.0.33]
at
com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
~[mysql-connector-j-8.0.33.jar:8.0.33]
at
com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
~[mysql-connector-j-8.0.33.jar:8.0.33]
at com.mysql.cj.protocol.a.NativeProtocol.send(NativeProtocol.java:629)
~[mysql-connector-j-8.0.33.jar:8.0.33]
at
com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:684)
~[mysql-connector-j-8.0.33.jar:8.0.33]
at
com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:156)
~[mysql-connector-j-8.0.33.jar:8.0.33]
at
com.mysql.cj.NativeSession.queryServerVariable(NativeSession.java:589)
~[mysql-connector-j-8.0.33.jar:8.0.33]
at
com.mysql.cj.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:1366)
~[mysql-connector-j-8.0.33.jar:8.0.33]
... 18 more
Caused by: java.net.SocketException: Broken pipe
at sun.nio.ch.NioSocketImpl.implWrite(NioSocketImpl.java:425) ~[?:?]
at sun.nio.ch.NioSocketImpl.write(NioSocketImpl.java:445) ~[?:?]
at sun.nio.ch.NioSocketImpl$2.write(NioSocketImpl.java:831) ~[?:?]
at java.net.Socket$SocketOutputStream.write(Socket.java:1035) ~[?:?]
at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:81) ~[?:?]
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:142)
~[?:?]
at
com.mysql.cj.protocol.a.SimplePacketSender.send(SimplePacketSender.java:55)
~[mysql-connector-j-8.0.33.jar:8.0.33]
at
com.mysql.cj.protocol.a.TimeTrackingPacketSender.send(TimeTrackingPacketSender.java:50)
~[mysql-connector-j-8.0.33.jar:8.0.33]
at com.mysql.cj.protocol.a.NativeProtocol.send(NativeProtocol.java:620)
~[mysql-connector-j-8.0.33.jar:8.0.33]
at
com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:684)
~[mysql-connector-j-8.0.33.jar:8.0.33]
at
com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:156)
~[mysql-connector-j-8.0.33.jar:8.0.33]
at
com.mysql.cj.NativeSession.queryServerVariable(NativeSession.java:589)
~[mysql-connector-j-8.0.33.jar:8.0.33]
at
com.mysql.cj.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:1366)
~[mysql-connector-j-8.0.33.jar:8.0.33]
... 18 more
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
