chenzichu created SPARK-50407:
---------------------------------
Summary: accessing a MySQL database through a proxy that has a set
timeout, an error occurs when using df.write.jdbc
Key: SPARK-50407
URL: https://issues.apache.org/jira/browse/SPARK-50407
Project: Spark
Issue Type: Bug
Components: Connect
Affects Versions: 3.1.0
Reporter: chenzichu
When accessing a MySQL database through a proxy that has a set timeout, an
error occurs when using {{{}df.write.mode(SaveMode.Append).jdbc(url, table,
properties){}}}.
error msg : !image-2024-11-25-16-22-01-206.png!
The reason for this error is that the JdbcRelationProvider created a connection
on the driver side, but did not close it after use; instead, it was closed
after the saveTable method was called. At this point, Nginx detected that there
was no data transfer on the connection and directly closed the connection,
leading to an error when calling conn.close(): "no more data to read from
socket".
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
