MySQL Bugs: #109141: Insert of data into a table results in System.ArgumentException

Bug #109141	Insert of data into a table results in System.ArgumentException
Submitted:	18 Nov 2022 18:41	Modified:	17 Apr 2023 8:29
Reporter:	Shane Leipper	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Executing a insert using C# MySql.Data package results in failure to insert the data. The attached project MySqlBug.zip contains a docker compose file that sets up the infrastructure using images:

mysql:8
proxysql/proxysql:2.4.4

There are 2 C# xUnit based tests that use the standard MySql.Data nuget package; one using a direct connection to MySQL database the other to ProxySQL, the latter fails with:

System.ArgumentException : Source array was not long enough. Check the source index, length, and the array's lower bounds. (Parameter 'sourceArray')

Stack Trace: 

Array.Copy(Array sourceArray, Int32 sourceIndex, Array destinationArray, Int32 destinationIndex, Int32 length, Boolean reliable)
Array.Copy(Array sourceArray, Int32 sourceIndex, Array destinationArray, Int32 destinationIndex, Int32 length)
MySqlPacket.ReadStringAsBytes()
OkPacket.ctor(MySqlPacket packet)
NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
Driver.NextResult(Int32 statementId, Boolean force)
MySqlDataReader.NextResult()
MySqlCommand.ExecuteReader(CommandBehavior behavior)
MySqlCommand.ExecuteReader()
MySqlCommand.ExecuteNonQuery()
MySqlConnection.BeginTransaction(IsolationLevel iso, String scope)
MySqlConnection.BeginTransaction()
Audit.InsertAudits(String connectionString) line 32
ProxySqlBugTests.InsertViaProxySql_ExpectPass() line 50

--- End of stack trace from previous location ---

How to repeat:
See attached project

Project used to reproduce the issue

Attachment: MySqlBug.zip (application/x-zip-compressed, text), 5.68 KiB.

For further information this works in 8.0.26 but starts failing for 8.0.27 upwards

Same situation. This error is reported just by starting a transaction.

Change severity.

Hello Shane,

Thank you for the bug report and details.
I tried to reproduce your issue on windows 10 with Connector/NET 8.0.32 using project provided but I am not seeing any issues at my end.

Regards,
Ashwini Patil

I updated the project to use 8.0.32.1 but this issue is still occurring. The test InsertViaProxySql_ExpectPass fails.

That said updating ProxySQL image to proxysql/proxysql:2.5.1 does result in the test passing so maybe you updated that also.

I started getting this error message  weeks ago on 8.0.31 and later versions. I had to downgrade to 8.0.6 for the error to stop.