I have a production package that is using MySQL as it's database server. Randomly throughout the day, we are experiencing problems. The stated error is as follows:
mysql.data.mysqlclient mysqlexception: reading from the stream has failed -> System.IO.IOException: a connection was forcibly closed by the remote host.
I looked on the MySQL suport forums and noticed that this can be caused when something exceeds the maximum allowable packet size. I pushed the packet size in the mysql config file up to one gig, and we still have this error.
I should also mention that the software is C#, we are using the mysql C# connector, and the issue seems to be random, but crops up regularly.
See the attached jpg for details.