Bug #28137 The error is generated No 2006
Submitted: 27 Apr 2007 13:45 Modified: 27 May 2007 14:13
Reporter: Devesh Chandra Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.0.37 OS:Any
Assigned to: CPU Architecture:Any
Tags: The error is generated No 2006

[27 Apr 2007 13:45] Devesh Chandra
Description:
Hi 
I am using the C APIs to populate the database tables in the application
The rate of incoming data is pretty fast.
Most of the time of runs the data base is being populated very nicely,but 
sometimes it shows following errors

2013 (Lost Connection to mysql)
2007
2006 ( CR_SERVER_GONE_ERROR)

Kindly shred more light on 
the nature of those errors and what could be the implications of these
error on the high rate data capturing system. 
Can it lead to data loss also ( as in our case data is not lost).

How to repeat:
the code snippet is copied below

 memset (rpQueryBufCIB, 0, 500);
            sprintf(rpQueryBufCIB,"lock table infoCIBTable write");
            printf("The lock query is %s\n", rpQueryBufCIB);
            if (mysql_query (connCIBTable, rpQueryBufCIB)!= 0)
                {
                  Log ("mysql_query() failed", __FILE__, __LINE__);
                  printf("The Query failed with error no %u",mysql_errno(connCIBTable));

                 }

             memset (rpQueryBufCIB, 0, 500);
             sprintf (rpQueryBufCIB, "update infoCIBTable set locationOSREntry ='%s'where RecordId = %lu",rpPathBuf,ulViolationId);

             printf ("Insert query = %s \n", rpQueryBufCIB);

             if (mysql_query (connCIBTable, rpQueryBufCIB)!= 0)
              {
             Log ("mysql_query() failed", __FILE__, __LINE__);
             printf("The Query failed with error no %u",mysql_errno(connCIBTable));
              }
[27 Apr 2007 14:13] MySQL Verification Team
Thank you for the bug report. Could you please provide the complete
test case: create table script, complete C code and your my.ini/my.cnf
files. Thanks in advance.
[27 May 2007 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".