MySQL Forums
Forum List  »  Quality Assurance

net_write_timeout value adjustment
Posted by: Nikhil Karande
Date: August 03, 2023 02:02AM

Hi Team,

one of our application recently faced the below exception

** BEGIN NESTED EXCEPTION **
java.io.EOFException
MESSAGE: Can not read response from server. Expected to read 63 bytes, read 51 bytes before connection was unexpectedly lost.
STACKTRACE:
java.io.EOFException: Can not read response from server. Expected to read 63 bytes, read 51 bytes before connection was unexpectedly lost.
at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67)


After changing net_write_timeout default value from 60 to 180 resolves the issue.

Please let us know whether any other performance related impact will happen or it is safe to use 180.

Options: ReplyQuote


Subject
Views
Written By
Posted
net_write_timeout value adjustment
140
August 03, 2023 02:02AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.