MySQL Bugs: #64086: Valgrind and 5.5.20

Bug #64086	Valgrind and 5.5.20
Submitted:	20 Jan 2012 18:17	Modified:	21 Jul 2012 20:50
Reporter:	Robert Gebis	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: C API (client library)	Severity:	S3 (Non-critical)
Version:	5.5.20	OS:	MacOS (10.7.2)
Assigned to:		CPU Architecture:	Any

Description:
When running valgrind on my application that links to mysql c lib produces this

==22230== Syscall param socketcall.setsockopt(optval) points to uninitialised byte(s)
==22230==    at 0x730D86: setsockopt (in /usr/lib/system/libsystem_kernel.dylib)
==22230==    by 0x5689D: my_net_local_init (in /usr/local/mysql-5.5.20-osx10.6-x86_64/lib/libmysqlclient.18.dylib)
==22230==    by 0x6083B: my_net_init (in /usr/local/mysql-5.5.20-osx10.6-x86_64/lib/libmysqlclient.18.dylib)
==22230==    by 0x5C83A: mysql_real_connect (in /usr/local/mysql-5.5.20-osx10.6-x86_64/lib/libmysqlclient.18.dylib)

How to repeat:
valgrind --dsymutil=yes --tool=memcheck --leak-check=full --show-reachable=yes a.out

Suggested fix:
none

Thank you for the report.

Please provide code of your application.

Not sure if my code will help. This is clearly not in my code.
All I did is download your Mac x64 binary dmg and after installing it I rebuild my code.

Than I linked to -Bdynamic -lmysqlclient_r

Not sure if my code will help. This is clearly not in my code.
All I did is download your Mac x64 binary dmg and after installing it I rebuild my code.

Than I linked to -Bdynamic -lmysqlclient_r

Thank you for the feedback.

But to fix this issue we need to confirm, i.e. repeat it first. We also must be sure you call MySQL functions properly. Thus we need repeatable test case from you.

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".

This is still a bug on 5.5.21:
====
Bruno-Limas-MacBook:crawler bslima$ mysql --version
mysql  Ver 14.14 Distrib 5.5.21, for osx10.6 (i386) using readline 5.1
====

mysql_conn.c:

#include <stdio.h>
#include <mysql.h>
#include <unistd.h>

int main ()
{
	MYSQL connection,conn;
    mysql_init(&connection);
    if (mysql_real_connect(&(connection),"localhost","root","",
        "db",3306,NULL,0) == NULL)
      {
        printf("No connection with DB\n");
      }
	sleep(3);
	mysql_close(&connection);
}

========
valgrind output:

==47912== ERROR SUMMARY: 2 errors from 2 contexts (suppressed: 0 from 0)
==47912== 
==47912== 1 errors in context 1 of 2:
==47912== Syscall param socketcall.setsockopt(optval) points to uninitialised byte(s)
==47912==    at 0x1002B3FA2: setsockopt (in /usr/lib/libSystem.B.dylib)
==47912==    by 0x1000245DC: my_net_local_init (in /usr/local/mysql-5.5.21/lib/libmysql.16.0.0.dylib)
==47912==    by 0x10002B854: my_net_init (in /usr/local/mysql-5.5.21/lib/libmysql.16.0.0.dylib)
==47912==    by 0x100021B31: mysql_real_connect (in /usr/local/mysql-5.5.21/lib/libmysql.16.0.0.dylib)
==47912==    by 0x100000E75: main (mysql_conn.c:10)
==47912==  Address 0x7fff5fbfeafc is on thread 1's stack
==47912==  Uninitialised value was created by a stack allocation
==47912==    at 0x10002B690: my_net_set_write_timeout (in /usr/local/mysql-5.5.21/lib/libmysql.16.0.0.dylib)
==47912== 
==47912== 
==47912== 1 errors in context 2 of 2:
==47912== Syscall param socketcall.setsockopt(optval) points to uninitialised byte(s)
==47912==    at 0x1002B3FA2: setsockopt (in /usr/lib/libSystem.B.dylib)
==47912==    by 0x1000245CF: my_net_local_init (in /usr/local/mysql-5.5.21/lib/libmysql.16.0.0.dylib)
==47912==    by 0x10002B854: my_net_init (in /usr/local/mysql-5.5.21/lib/libmysql.16.0.0.dylib)
==47912==    by 0x100021B31: mysql_real_connect (in /usr/local/mysql-5.5.21/lib/libmysql.16.0.0.dylib)
==47912==    by 0x100000E75: main (mysql_conn.c:10)
==47912==  Address 0x7fff5fbfeafc is on thread 1's stack
==47912==  Uninitialised value was created by a stack allocation
==47912==    at 0x10002B650: my_net_set_read_timeout (in /usr/local/mysql-5.5.21/lib/libmysql.16.0.0.dylib)
==47912== 
--47912-- 
--47912-- used_suppression:      1 libSystem-keymgr-leak-at-exit
==47912== 
==47912== ERROR SUMMARY: 2 errors from 2 contexts (suppressed: 0 from 0)

Bruno,

thank you for the feedback.

I can not repeat described behavior on Linux. Additionally version 5.5.21 is old and this can be fixed. Please try with version 5.5.25 and inform us if problem still exists.

I moved on version 5.5.24. I will upgrade to 5.5.25 and will try it again and report on latest version

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".