[sbester@box1 mysql-advanced-gpl-5.1.44-linux-i686-glibc23]$ valgrind --tool=memcheck --num-callers=50 --track-origins=yes --leak-check=full --db-attach=no -v --show-reachable=yes ./bin/mysqld --no-defaults --basedir=./ --datadir=./data --skip-name-resolve --skip-grant-tables --sync-frm=0 ==7862== Memcheck, a memory error detector ==7862== Copyright (C) 2002-2009, and GNU GPL'd, by Julian Seward et al. ==7862== Using Valgrind-3.5.0 and LibVEX; rerun with -h for copyright info ==7862== Command: ./bin/mysqld --no-defaults --basedir=./ --datadir=./data --skip-name-resolve --skip-grant-tables --sync-frm=0 ==7862== --7862-- Valgrind options: --7862-- --tool=memcheck --7862-- --num-callers=50 --7862-- --track-origins=yes --7862-- --leak-check=full --7862-- --db-attach=no --7862-- -v --7862-- --show-reachable=yes --7862-- Contents of /proc/version: --7862-- Linux version 2.6.18-1.2798.fc6xen (brewbuilder@hs20-bc2-4.build.redhat.com) (gcc version 4.1.1 20061011 (Red Hat 4.1.1-30)) #1 SMP Mon Oct 16 15:11:19 EDT 2006 --7862-- Arch and hwcaps: X86, x86-sse1-sse2 --7862-- Page sizes: currently 4096, max supported 4096 --7862-- Valgrind library directory: /home/sbester/valgrind/lib/valgrind --7862-- Reading syms from /lib/ld-2.5.so (0x2c3000) --7862-- Reading syms from /home/sbester/mysql/5.1/mysql-advanced-gpl-5.1.44-linux-i686-glibc23/bin/mysqld (0x8048000) --7862-- Reading syms from /home/sbester/valgrind/lib/valgrind/memcheck-x86-linux (0x38000000) --7862-- object doesn't have a dynamic symbol table --7862-- Reading suppressions file: /home/sbester/valgrind/lib/valgrind/default.supp --7862-- REDIR: 0x2d80f0 (index) redirected to 0x3803e413 (vgPlain_x86_linux_REDIR_FOR_index) --7862-- Reading syms from /home/sbester/valgrind/lib/valgrind/vgpreload_core-x86-linux.so (0x4001000) --7862-- Reading syms from /home/sbester/valgrind/lib/valgrind/vgpreload_memcheck-x86-linux.so (0x4003000) ==7862== WARNING: new redirection conflicts with existing -- ignoring it --7862-- new: 0x002d80f0 (index ) R-> 0x040066d0 index --7862-- REDIR: 0x2d8290 (strlen) redirected to 0x40068b0 (strlen) --7862-- Reading syms from /lib/libpthread-2.5.so (0x484000) --7862-- Reading syms from /lib/libdl-2.5.so (0xdd5000) --7862-- Reading syms from /lib/libcrypt-2.5.so (0x50d8000) --7862-- Reading syms from /lib/libnsl-2.5.so (0x2e0000) --7862-- Reading syms from /lib/libm-2.5.so (0x401b000) --7862-- Reading syms from /lib/libc-2.5.so (0x309000) --7862-- REDIR: 0x3764e0 (memset) redirected to 0x4006c10 (memset) --7862-- REDIR: 0x3769d0 (memcpy) redirected to 0x4007ad0 (memcpy) --7862-- REDIR: 0x375640 (rindex) redirected to 0x40065e0 (rindex) --7862-- REDIR: 0x375350 (strnlen) redirected to 0x4006860 (strnlen) --7862-- REDIR: 0x376470 (memmove) redirected to 0x4006c60 (memmove) --7862-- REDIR: 0x3752a0 (strlen) redirected to 0x4006890 (strlen) --7862-- REDIR: 0x3709b0 (calloc) redirected to 0x4004c1e (calloc) --7862-- REDIR: 0x370cb0 (malloc) redirected to 0x400590e (malloc) --7862-- Reading syms from /lib/libgcc_s-4.1.1-20061011.so.1 (0x4ece000) --7862-- object doesn't have a symbol table --7862-- REDIR: 0x375fe0 (memchr) redirected to 0x4006a80 (memchr) --7862-- REDIR: 0x3724c0 (free) redirected to 0x4005528 (free) --7862-- REDIR: 0x375490 (strncmp) redirected to 0x40068f0 (strncmp) --7862-- REDIR: 0x3766d0 (stpcpy) redirected to 0x40075b0 (stpcpy) --7862-- REDIR: 0x374db0 (strcpy) redirected to 0x4007d60 (strcpy) --7862-- REDIR: 0x374d40 (strcmp) redirected to 0x4006960 (strcmp) --7862-- REDIR: 0x374bd0 (index) redirected to 0x4006670 (index) --7862-- REDIR: 0x377280 (rawmemchr) redirected to 0x4006cf0 (rawmemchr) --7862-- REDIR: 0x374a20 (strcat) redirected to 0x4007060 (strcat) --7862-- REDIR: 0x376540 (mempcpy) redirected to 0x4007330 (mempcpy) --7862-- REDIR: 0x3726b0 (realloc) redirected to 0x40059bd (realloc) 091208 12:24:23 [Note] Plugin 'FEDERATED' is disabled. 091208 12:25:06 InnoDB: Started; log sequence number 0 3188214 --7862-- memcheck GC: 1024 nodes, 1024 survivors (100.0%) --7862-- memcheck GC: increase table size to 2048 --7862-- REDIR: 0x377350 (strchrnul) redirected to 0x4006cc0 (strchrnul) --7862-- Reading syms from /lib/libnss_files-2.5.so (0x400f000) 091208 12:25:14 [Note] ./bin/mysqld: ready for connections. Version: '5.1.44-enterprise-gpl-advanced' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (GPL) ==7862== Thread 11: ==7862== Conditional jump or move depends on uninitialised value(s) ==7862== at 0x84F5A72: my_long10_to_str_8bit (ctype-simple.c:855) ==7862== by 0x81DE00B: Field_long::val_str(String*, String*) (field.cc:3754) ==7862== by 0x814D487: Item_field::val_str(String*) (item.cc:2009) ==7862== by 0x819C95F: Item_func_soundex::val_str(String*) (item_strfunc.cc:1931) ==7862== by 0x818D364: Arg_comparator::compare_binary_string() (item_cmpfunc.cc:1298) ==7862== by 0x818FAA1: Item_func_eq::val_int() (item_cmpfunc.h:81) ==7862== by 0x814FAC7: Item::val_bool() (item.cc:184) ==7862== by 0x8189B08: Item_cond_and::val_int() (item_cmpfunc.cc:4388) ==7862== by 0x827B83B: JOIN::optimize() (sql_select.cc:6160) ==7862== by 0x827E20B: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:2445) ==7862== by 0x827EA84: mysql_explain_union(THD*, st_select_lex_unit*, select_result*) (sql_select.cc:16617) ==7862== by 0x8212221: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5030) ==7862== by 0x8216D67: mysql_execute_command(THD*) (sql_parse.cc:2248) ==7862== by 0x821C504: mysql_parse(THD*, char const*, unsigned int, char const**) (sql_parse.cc:5971) ==7862== by 0x821D72F: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1233) ==7862== by 0x821DFDF: do_command(THD*) (sql_parse.cc:874) ==7862== by 0x820E8A2: handle_one_connection (sql_connect.cc:1127) ==7862== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==7862== by 0x3D606D: clone (in /lib/libc-2.5.so) ==7862== Uninitialised value was created by a heap allocation ==7862== at 0x4005993: malloc (vg_replace_malloc.c:195) ==7862== by 0x84CCBE3: my_malloc (my_malloc.c:34) ==7862== by 0x84CD2CE: alloc_root (my_alloc.c:201) ==7862== by 0x84C4098: myisammrg_create_handler(handlerton*, st_table_share*, st_mem_root*) (sql_list.h:39) ==7862== by 0x82F86C2: get_new_handler(st_table_share*, st_mem_root*, handlerton*) (handler.cc:248) ==7862== by 0x8259715: open_table_from_share(THD*, st_table_share*, char const*, unsigned int, unsigned int, unsigned int, st_table*, bool) (table.cc:1675) ==7862== by 0x8253918: open_unireg_entry(THD*, st_table*, TABLE_LIST*, char const*, char*, unsigned int, st_mem_root*, unsigned int) (sql_base.cc:3922) ==7862== by 0x8254809: open_table(THD*, TABLE_LIST*, st_mem_root*, bool*, unsigned int) (sql_base.cc:2919) ==7862== by 0x82556EF: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int) (sql_base.cc:4594) ==7862== by 0x82558E7: open_and_lock_tables_derived(THD*, TABLE_LIST*, bool) (sql_base.cc:5000) ==7862== by 0x82120B9: execute_sqlcom_select(THD*, TABLE_LIST*) (mysql_priv.h:1576) ==7862== by 0x8216D67: mysql_execute_command(THD*) (sql_parse.cc:2248) ==7862== by 0x821C504: mysql_parse(THD*, char const*, unsigned int, char const**) (sql_parse.cc:5971) ==7862== by 0x821D72F: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1233) ==7862== by 0x821DFDF: do_command(THD*) (sql_parse.cc:874) ==7862== by 0x820E8A2: handle_one_connection (sql_connect.cc:1127) ==7862== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==7862== by 0x3D606D: clone (in /lib/libc-2.5.so) ==7862== ==7862== Conditional jump or move depends on uninitialised value(s) ==7862== at 0x84F5A13: my_long10_to_str_8bit (ctype-simple.c:869) ==7862== by 0x81DE00B: Field_long::val_str(String*, String*) (field.cc:3754) ==7862== by 0x814D487: Item_field::val_str(String*) (item.cc:2009) ==7862== by 0x819C95F: Item_func_soundex::val_str(String*) (item_strfunc.cc:1931) ==7862== by 0x818D364: Arg_comparator::compare_binary_string() (item_cmpfunc.cc:1298) ==7862== by 0x818FAA1: Item_func_eq::val_int() (item_cmpfunc.h:81) ==7862== by 0x814FAC7: Item::val_bool() (item.cc:184) ==7862== by 0x8189B08: Item_cond_and::val_int() (item_cmpfunc.cc:4388) ==7862== by 0x827B83B: JOIN::optimize() (sql_select.cc:6160) ==7862== by 0x827E20B: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:2445) ==7862== by 0x827EA84: mysql_explain_union(THD*, st_select_lex_unit*, select_result*) (sql_select.cc:16617) ==7862== by 0x8212221: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5030) ==7862== by 0x8216D67: mysql_execute_command(THD*) (sql_parse.cc:2248) ==7862== by 0x821C504: mysql_parse(THD*, char const*, unsigned int, char const**) (sql_parse.cc:5971) ==7862== by 0x821D72F: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1233) ==7862== by 0x821DFDF: do_command(THD*) (sql_parse.cc:874) ==7862== by 0x820E8A2: handle_one_connection (sql_connect.cc:1127) ==7862== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==7862== by 0x3D606D: clone (in /lib/libc-2.5.so) ==7862== Uninitialised value was created by a heap allocation ==7862== at 0x4005993: malloc (vg_replace_malloc.c:195) ==7862== by 0x84CCBE3: my_malloc (my_malloc.c:34) ==7862== by 0x84CD2CE: alloc_root (my_alloc.c:201) ==7862== by 0x84C4098: myisammrg_create_handler(handlerton*, st_table_share*, st_mem_root*) (sql_list.h:39) ==7862== by 0x82F86C2: get_new_handler(st_table_share*, st_mem_root*, handlerton*) (handler.cc:248) ==7862== by 0x8259715: open_table_from_share(THD*, st_table_share*, char const*, unsigned int, unsigned int, unsigned int, st_table*, bool) (table.cc:1675) ==7862== by 0x8253918: open_unireg_entry(THD*, st_table*, TABLE_LIST*, char const*, char*, unsigned int, st_mem_root*, unsigned int) (sql_base.cc:3922) ==7862== by 0x8254809: open_table(THD*, TABLE_LIST*, st_mem_root*, bool*, unsigned int) (sql_base.cc:2919) ==7862== by 0x82556EF: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int) (sql_base.cc:4594) ==7862== by 0x82558E7: open_and_lock_tables_derived(THD*, TABLE_LIST*, bool) (sql_base.cc:5000) ==7862== by 0x82120B9: execute_sqlcom_select(THD*, TABLE_LIST*) (mysql_priv.h:1576) ==7862== by 0x8216D67: mysql_execute_command(THD*) (sql_parse.cc:2248) ==7862== by 0x821C504: mysql_parse(THD*, char const*, unsigned int, char const**) (sql_parse.cc:5971) ==7862== by 0x821D72F: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1233) ==7862== by 0x821DFDF: do_command(THD*) (sql_parse.cc:874) ==7862== by 0x820E8A2: handle_one_connection (sql_connect.cc:1127) ==7862== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==7862== by 0x3D606D: clone (in /lib/libc-2.5.so) ==7862== ==7862== Use of uninitialised value of size 4 ==7862== at 0x819CB6C: Item_func_soundex::val_str(String*) (item_strfunc.cc:1955) ==7862== by 0x818D364: Arg_comparator::compare_binary_string() (item_cmpfunc.cc:1298) ==7862== by 0x818FAA1: Item_func_eq::val_int() (item_cmpfunc.h:81) ==7862== by 0x814FAC7: Item::val_bool() (item.cc:184) ==7862== by 0x8189B08: Item_cond_and::val_int() (item_cmpfunc.cc:4388) ==7862== by 0x827B83B: JOIN::optimize() (sql_select.cc:6160) ==7862== by 0x827E20B: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:2445) ==7862== by 0x827EA84: mysql_explain_union(THD*, st_select_lex_unit*, select_result*) (sql_select.cc:16617) ==7862== by 0x8212221: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5030) ==7862== by 0x8216D67: mysql_execute_command(THD*) (sql_parse.cc:2248) ==7862== by 0x821C504: mysql_parse(THD*, char const*, unsigned int, char const**) (sql_parse.cc:5971) ==7862== by 0x821D72F: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1233) ==7862== by 0x821DFDF: do_command(THD*) (sql_parse.cc:874) ==7862== by 0x820E8A2: handle_one_connection (sql_connect.cc:1127) ==7862== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==7862== by 0x3D606D: clone (in /lib/libc-2.5.so) ==7862== Uninitialised value was created by a heap allocation ==7862== at 0x4005993: malloc (vg_replace_malloc.c:195) ==7862== by 0x84CCBE3: my_malloc (my_malloc.c:34) ==7862== by 0x84CD2CE: alloc_root (my_alloc.c:201) ==7862== by 0x84C4098: myisammrg_create_handler(handlerton*, st_table_share*, st_mem_root*) (sql_list.h:39) ==7862== by 0x82F86C2: get_new_handler(st_table_share*, st_mem_root*, handlerton*) (handler.cc:248) ==7862== by 0x8259715: open_table_from_share(THD*, st_table_share*, char const*, unsigned int, unsigned int, unsigned int, st_table*, bool) (table.cc:1675) ==7862== by 0x8253918: open_unireg_entry(THD*, st_table*, TABLE_LIST*, char const*, char*, unsigned int, st_mem_root*, unsigned int) (sql_base.cc:3922) ==7862== by 0x8254809: open_table(THD*, TABLE_LIST*, st_mem_root*, bool*, unsigned int) (sql_base.cc:2919) ==7862== by 0x82556EF: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int) (sql_base.cc:4594) ==7862== by 0x82558E7: open_and_lock_tables_derived(THD*, TABLE_LIST*, bool) (sql_base.cc:5000) ==7862== by 0x82120B9: execute_sqlcom_select(THD*, TABLE_LIST*) (mysql_priv.h:1576) ==7862== by 0x8216D67: mysql_execute_command(THD*) (sql_parse.cc:2248) ==7862== by 0x821C504: mysql_parse(THD*, char const*, unsigned int, char const**) (sql_parse.cc:5971) ==7862== by 0x821D72F: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1233) ==7862== by 0x821DFDF: do_command(THD*) (sql_parse.cc:874) ==7862== by 0x820E8A2: handle_one_connection (sql_connect.cc:1127) ==7862== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==7862== by 0x3D606D: clone (in /lib/libc-2.5.so) ==7862== ==7862== Conditional jump or move depends on uninitialised value(s) ==7862== at 0x81DD542: Field_blob::val_str(String*, String*) (field.cc:7818) ==7862== by 0x814D487: Item_field::val_str(String*) (item.cc:2009) ==7862== by 0x819C95F: Item_func_soundex::val_str(String*) (item_strfunc.cc:1931) ==7862== by 0x818D37E: Arg_comparator::compare_binary_string() (item_cmpfunc.cc:1300) ==7862== by 0x818FAA1: Item_func_eq::val_int() (item_cmpfunc.h:81) ==7862== by 0x814FAC7: Item::val_bool() (item.cc:184) ==7862== by 0x8189B08: Item_cond_and::val_int() (item_cmpfunc.cc:4388) ==7862== by 0x827B83B: JOIN::optimize() (sql_select.cc:6160) ==7862== by 0x827E20B: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:2445) ==7862== by 0x827EA84: mysql_explain_union(THD*, st_select_lex_unit*, select_result*) (sql_select.cc:16617) ==7862== by 0x8212221: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5030) ==7862== by 0x8216D67: mysql_execute_command(THD*) (sql_parse.cc:2248) ==7862== by 0x821C504: mysql_parse(THD*, char const*, unsigned int, char const**) (sql_parse.cc:5971) ==7862== by 0x821D72F: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1233) ==7862== by 0x821DFDF: do_command(THD*) (sql_parse.cc:874) ==7862== by 0x820E8A2: handle_one_connection (sql_connect.cc:1127) ==7862== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==7862== by 0x3D606D: clone (in /lib/libc-2.5.so) ==7862== Uninitialised value was created by a heap allocation ==7862== at 0x4005993: malloc (vg_replace_malloc.c:195) ==7862== by 0x84CCBE3: my_malloc (my_malloc.c:34) ==7862== by 0x84CD2CE: alloc_root (my_alloc.c:201) ==7862== by 0x84C4098: myisammrg_create_handler(handlerton*, st_table_share*, st_mem_root*) (sql_list.h:39) ==7862== by 0x82F86C2: get_new_handler(st_table_share*, st_mem_root*, handlerton*) (handler.cc:248) ==7862== by 0x8259715: open_table_from_share(THD*, st_table_share*, char const*, unsigned int, unsigned int, unsigned int, st_table*, bool) (table.cc:1675) ==7862== by 0x8253918: open_unireg_entry(THD*, st_table*, TABLE_LIST*, char const*, char*, unsigned int, st_mem_root*, unsigned int) (sql_base.cc:3922) ==7862== by 0x8254809: open_table(THD*, TABLE_LIST*, st_mem_root*, bool*, unsigned int) (sql_base.cc:2919) ==7862== by 0x82556EF: open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int) (sql_base.cc:4594) ==7862== by 0x82558E7: open_and_lock_tables_derived(THD*, TABLE_LIST*, bool) (sql_base.cc:5000) ==7862== by 0x82120B9: execute_sqlcom_select(THD*, TABLE_LIST*) (mysql_priv.h:1576) ==7862== by 0x8216D67: mysql_execute_command(THD*) (sql_parse.cc:2248) ==7862== by 0x821C504: mysql_parse(THD*, char const*, unsigned int, char const**) (sql_parse.cc:5971) ==7862== by 0x821D72F: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1233) ==7862== by 0x821DFDF: do_command(THD*) (sql_parse.cc:874) ==7862== by 0x820E8A2: handle_one_connection (sql_connect.cc:1127) ==7862== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==7862== by 0x3D606D: clone (in /lib/libc-2.5.so) ==7862==