Bug #82006 Packets larger than max_allowed_packet are not allowed

• Submitted: 26 Jun 2016 13:52
• Modified: 1 Jul 2016 17:41
• Reporter: Oren Levin
• Status: Can't repeat
• Category: Connector / NET
• Severity: S2 (Serious)
• Version: 6.9.8
• OS: Windows
• CPU Architecture: Any
• Tags: .net Connector, max_allowed_packet

[26 Jun 2016 13:52] Oren Levin

Description:
Using MySql 5.6 on windows server 2012 R2
I used .net connector 6.8.3 and upgraded to 6.9.8
Im using pooled connection.
I have both Ef6 and MySqlConnection on my project.
Max allowed packet is defined to 700MB (On ini file).

After some time of work. Can be a few days or a week connections gets
Packets larger than max_allowed_packet are not allowed.
If i run the same query directly from workbench it will work.
Also after reseting mysql service new conenction are ok.
Upgrade to connector 6.9.8 didn't seems to help.
Any Advice ?

How to repeat:
No specific scenrio.
Happens after a few days of work.

Suggested fix:
No fix other than reset mysql service.

[27 Jun 2016 6:36] Chiranjeevi Battula

Hello Oren Levin,

Thank you for the bug report.
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

Please provide a small database schema and Visual Studio project where this error consistently appear.

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Thanks,
Chiranjeevi.

[1 Jul 2016 17:41] Oren Levin

I use blobs of up to 5MB saved as mediumblob on DB.
Can it be realred to it ?