Bug #51517 Connector/.Net - query normalizer doesn't handle inserting binary value
Submitted: 25 Feb 2010 16:41 Modified: 9 Jan 2015 10:33
Reporter: Bill Weber Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Connector Plugins Severity:S3 (Non-critical)
Version:1.0.3.0 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[25 Feb 2010 16:41] Bill Weber
Description:
When inserting a binary file into the db, the following exception occurs in the c/.net plugin (and the query is not shown on the dashboard):

    at QueryNormalizer.CollapseValueList(List`1 tok, Int32& pos)  
    at QueryNormalizer.CollapseValueLists(List`1 tok)  
    at QueryNormalizer.Normalize(String sql)  
    at ServerAggregation.AddNewQuery(MySqlTraceQuery qi)  
    at EMTraceListener.processingThread_DoWork(Object sender, DoWorkEventArgs e)  
    at BackgroundWorker.OnDoWork(DoWorkEventArgs e)  
    at BackgroundWorker.WorkerThreadStart(Object argument)  
    at StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)  
    at StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)  
    at StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)  
    at AgileAsyncWorkerItem.DoAsyncCall()  
    at AgileAsyncWorkerItem.ThreadPoolCallBack(Object o)  
    at _ThreadPoolWaitCallback.WaitCallback_Context(Object state)  
    at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)  
    at _ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)  
    at _ThreadPoolWaitCallback.PerformWaitCallback(Object state)  

How to repeat:
- create a table with a blob field
- insert a .png file into the table

snippet:

 cmd.CommandText = "INSERT INTO staff VALUES('My', 'Name', @PngFile)";
 cmd.Parameters.AddWithValue("@PngFile", pngData);
[5 Mar 2010 20:22] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/102476
[30 Nov 2010 13:23] Enterprise Tools JIRA Robot
Mark Leith writes: 
Setting to Patch Pushed for workflow (QA testing), this appears to have been fixed.