• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 858
  • Last Modified:

MYSQL Problems

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.
mysqlerror.JPG
0
BakWoodz99
Asked:
BakWoodz99
1 Solution
 
NovaDenizenCommented:
Make sure you increase the max packet size on both the server and the client side.
0
 
BakWoodz99Author Commented:
It also turns out that switching off connection pooling altogether solved several issues for us. The C# MySQL connector just seems a little buggy.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now