[sbester@box1 mysql-5.1.35-linux-i686]$ valgrind --tool=memcheck --leak-check=full --db-attach=yes --db-command="/home/sbester/gdb-6.8/gdb/gdb --pid=%p" -v --show-reachable=yes ./bin/mysqld --no-defaults --basedir=./ --datadir=./data --skip-grant-tables --skip-name-resolve --server-id=2 --port=3310 --socket=sock.sock --gdb --skip-stack-trace ==4136== Memcheck, a memory error detector. ==4136== Copyright (C) 2002-2006, and GNU GPL'd, by Julian Seward et al. ==4136== Using LibVEX rev 1658, a library for dynamic binary translation. ==4136== Copyright (C) 2004-2006, and GNU GPL'd, by OpenWorks LLP. ==4136== Using valgrind-3.2.1, a dynamic binary instrumentation framework. ==4136== Copyright (C) 2000-2006, and GNU GPL'd, by Julian Seward et al. ==4136== --4136-- Command line --4136-- ./bin/mysqld --4136-- --no-defaults --4136-- --basedir=./ --4136-- --datadir=./data --4136-- --skip-grant-tables --4136-- --skip-name-resolve --4136-- --server-id=2 --4136-- --port=3310 --4136-- --socket=sock.sock --4136-- --gdb --4136-- --skip-stack-trace --4136-- Startup, with flags: --4136-- --tool=memcheck --4136-- --leak-check=full --4136-- --db-attach=yes --4136-- --db-command=/home/sbester/gdb-6.8/gdb/gdb --pid=%p --4136-- -v --4136-- --show-reachable=yes --4136-- Contents of /proc/version: --4136-- 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 --4136-- Arch and hwcaps: X86, x86-sse1-sse2 --4136-- Valgrind library directory: /usr/lib/valgrind --4136-- Reading syms from /lib/ld-2.5.so (0x2C3000) --4136-- Reading syms from /home/sbester/mysql/5.1/mysql-5.1.35-linux-i686/bin/mysqld (0x8048000) --4136-- Reading syms from /usr/lib/valgrind/x86-linux/memcheck (0x38000000) --4136-- object doesn't have a dynamic symbol table --4136-- Reading suppressions file: /usr/lib/valgrind/default.supp --4136-- REDIR: 0x2D80F0 (index) redirected to 0x38027D0F (vgPlain_x86_linux_REDIR_FOR_index) --4136-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_core.so (0x4001000) --4136-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_memcheck.so (0x4003000) ==4136== WARNING: new redirection conflicts with existing -- ignoring it --4136-- new: 0x002D80F0 (index ) R-> 0x040060C0 index --4136-- REDIR: 0x2D8290 (strlen) redirected to 0x4006290 (strlen) --4136-- Reading syms from /lib/libpthread-2.5.so (0x484000) --4136-- Reading syms from /usr/lib/libz.so.1.2.3 (0x12A000) --4136-- object doesn't have a symbol table --4136-- Reading syms from /lib/libdl-2.5.so (0xDD5000) --4136-- Reading syms from /lib/libcrypt-2.5.so (0x50D8000) --4136-- Reading syms from /lib/libnsl-2.5.so (0x2E0000) --4136-- Reading syms from /usr/lib/libstdc++.so.6.0.8 (0x4FC6000) --4136-- object doesn't have a symbol table --4136-- Reading syms from /lib/libm-2.5.so (0x4019000) --4136-- Reading syms from /lib/libgcc_s-4.1.1-20061011.so.1 (0x4ECE000) --4136-- object doesn't have a symbol table --4136-- Reading syms from /lib/libc-2.5.so (0x309000) --4136-- REDIR: 0x3764E0 (memset) redirected to 0x4006580 (memset) --4136-- REDIR: 0x3769D0 (memcpy) redirected to 0x4006C60 (memcpy) --4136-- REDIR: 0x375640 (rindex) redirected to 0x4005FA0 (rindex) --4136-- REDIR: 0x3752A0 (strlen) redirected to 0x4006270 (strlen) --4136-- REDIR: 0x375350 (strnlen) redirected to 0x4006240 (strnlen) --4136-- REDIR: 0x376470 (memmove) redirected to 0x40065B0 (memmove) --4136-- REDIR: 0x3709B0 (calloc) redirected to 0x40046A8 (calloc) --4136-- REDIR: 0x370CB0 (malloc) redirected to 0x400537B (malloc) --4136-- REDIR: 0x375490 (strncmp) redirected to 0x40062D0 (strncmp) --4136-- REDIR: 0x374DB0 (strcpy) redirected to 0x40069F0 (strcpy) --4136-- REDIR: 0x507BD00 (operator new(unsigned)) redirected to 0x4005B19 (operator new(unsigned)) --4136-- REDIR: 0x3724C0 (free) redirected to 0x4004F95 (free) --4136-- REDIR: 0x374D40 (strcmp) redirected to 0x4006340 (strcmp) --4136-- REDIR: 0x374BD0 (index) redirected to 0x4006090 (index) --4136-- REDIR: 0x377280 (rawmemchr) redirected to 0x4006640 (rawmemchr) --4136-- REDIR: 0x374A20 (strcat) redirected to 0x4006660 (strcat) --4136-- REDIR: 0x3766D0 (stpcpy) redirected to 0x4006910 (stpcpy) --4136-- REDIR: 0x3726B0 (realloc) redirected to 0x400542A (realloc) 090521 18:09:38 InnoDB: Started; log sequence number 0 750073566 --4136-- memcheck GC: 1024 nodes, 1024 survivors (100.0%) --4136-- memcheck GC: increase table size to 2048 090521 18:09:40 [Note] ./bin/mysqld: ready for connections. Version: '5.1.35-debug' socket: 'sock.sock' port: 3310 yes 090521 18:16:45 [ERROR] ./bin/mysqld: Can't find file: './test/@1G@0002@000e@0r@005e@0040@2014@001d@00a9@1m@1K@1Q@0J@0p@000c@0023@0w@2026@1l@2022@4h@0005@0028@0P@0006@001f@2019@00a1@1H@0011@1i@00af@0021@002a@00a3@0T@001f@0k@1h@00bd@1H@00b7@2020_@201d@0004@' (errno: 36) ==4136== Thread 10: ==4136== Invalid read of size 1 ==4136== at 0x813A291: MYSQLlex(void*, void*) (sql_lex.cc:982) ==4136== by 0x82232DE: MYSQLparse(void*) (sql_yacc.cc:15681) ==4136== by 0x8200D7A: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:7797) ==4136== by 0x820FD6A: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:5893) ==4136== by 0x8211123: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1216) ==4136== by 0x82121F0: do_command(THD*) (sql_parse.cc:857) ==4136== by 0x8200889: handle_one_connection (sql_connect.cc:1115) ==4136== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==4136== by 0x3D606D: clone (in /lib/libc-2.5.so) ==4136== Address 0x4079D2F is not stack'd, malloc'd or (recently) free'd ==4136== ==4136== ---- Attach to debugger ? --- [Return/N/n/Y/y/C/c] ---- c ==4136== ==4136== Invalid read of size 1 ==4136== at 0x813A15F: MYSQLlex(void*, void*) (sql_lex.cc:934) ==4136== by 0x82232DE: MYSQLparse(void*) (sql_yacc.cc:15681) ==4136== by 0x8200D7A: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:7797) ==4136== by 0x820FD6A: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:5893) ==4136== by 0x8211123: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1216) ==4136== by 0x82121F0: do_command(THD*) (sql_parse.cc:857) ==4136== by 0x8200889: handle_one_connection (sql_connect.cc:1115) ==4136== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==4136== by 0x3D606D: clone (in /lib/libc-2.5.so) ==4136== Address 0x4079D1C is 4 bytes after a block of size 4,088 alloc'd ==4136== at 0x4005400: malloc (vg_replace_malloc.c:149) ==4136== by 0x84F53DF: my_once_alloc (my_once.c:61) ==4136== by 0x8504813: init_state_maps (charset.c:62) ==4136== by 0x85051AA: init_available_charsets (charset.c:435) ==4136== by 0x85053FD: get_charset_by_csname (charset.c:588) ==4136== by 0x81F98CD: init_common_variables(char const*, int, char**, char const**) (mysqld.cc:3349) ==4136== by 0x81FB569: main (mysqld.cc:4255) --4136-- REDIR: 0x375FE0 (memchr) redirected to 0x4006460 (memchr) --4136-- REDIR: 0x377350 (strchrnul) redirected to 0x4006610 (strchrnul) --4136-- Reading syms from /lib/libnss_files-2.5.so (0x4EB5000) ==4136== ==4136== Conditional jump or move depends on uninitialised value(s) ==4136== at 0x813A295: MYSQLlex(void*, void*) (sql_lex.cc:982) ==4136== by 0x82232DE: MYSQLparse(void*) (sql_yacc.cc:15681) ==4136== by 0x8200D7A: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:7797) ==4136== by 0x820FD6A: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:5893) ==4136== by 0x8211123: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1216) ==4136== by 0x82121F0: do_command(THD*) (sql_parse.cc:857) ==4136== by 0x8200889: handle_one_connection (sql_connect.cc:1115) ==4136== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==4136== by 0x3D606D: clone (in /lib/libc-2.5.so) ==4136== ==4136== Invalid read of size 1 ==4136== at 0x813A6DD: MYSQLlex(void*, void*) (sql_lex.cc:1068) ==4136== by 0x82232DE: MYSQLparse(void*) (sql_yacc.cc:15681) ==4136== by 0x8200D7A: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:7797) ==4136== by 0x820FD6A: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:5893) ==4136== by 0x8211123: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1216) ==4136== by 0x82121F0: do_command(THD*) (sql_parse.cc:857) ==4136== by 0x8200889: handle_one_connection (sql_connect.cc:1115) ==4136== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==4136== by 0x3D606D: clone (in /lib/libc-2.5.so) ==4136== Address 0x4079D3A is 14 bytes before a block of size 4,088 alloc'd ==4136== at 0x4005400: malloc (vg_replace_malloc.c:149) ==4136== by 0x84F53DF: my_once_alloc (my_once.c:61) ==4136== by 0x8504835: init_state_maps (charset.c:65) ==4136== by 0x85051AA: init_available_charsets (charset.c:435) ==4136== by 0x85053FD: get_charset_by_csname (charset.c:588) ==4136== by 0x81F98CD: init_common_variables(char const*, int, char**, char const**) (mysqld.cc:3349) ==4136== by 0x81FB569: main (mysqld.cc:4255) ==4136== ==4136== Conditional jump or move depends on uninitialised value(s) ==4136== at 0x813A163: MYSQLlex(void*, void*) (sql_lex.cc:934) ==4136== by 0x82232DE: MYSQLparse(void*) (sql_yacc.cc:15681) ==4136== by 0x8200D7A: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:7797) ==4136== by 0x820FD6A: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:5893) ==4136== by 0x8211123: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1216) ==4136== by 0x82121F0: do_command(THD*) (sql_parse.cc:857) ==4136== by 0x8200889: handle_one_connection (sql_connect.cc:1115) ==4136== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==4136== by 0x3D606D: clone (in /lib/libc-2.5.so) 090521 18:22:26 [Note] ./bin/mysqld: Normal shutdown --4136-- REDIR: 0x507A850 (operator delete(void*)) redirected to 0x4004CAC (operator delete(void*)) 090521 18:22:27 InnoDB: Starting shutdown... 090521 18:22:29 InnoDB: Shutdown completed; log sequence number 0 750073566 090521 18:22:29 [Warning] Forcing shutdown of 1 plugins 090521 18:22:29 [Note] ./bin/mysqld: Shutdown complete --4136-- Discarding syms at 0x4EB5000-0x4EC0000 in /lib/libnss_files-2.5.so due to munmap() ==4136== ==4136== ERROR SUMMARY: 36 errors from 5 contexts (suppressed: 24 from 1) ==4136== ==4136== 2 errors in context 1 of 5: ==4136== Invalid read of size 1 ==4136== at 0x813A6DD: MYSQLlex(void*, void*) (sql_lex.cc:1068) ==4136== by 0x82232DE: MYSQLparse(void*) (sql_yacc.cc:15681) ==4136== by 0x8200D7A: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:7797) ==4136== by 0x820FD6A: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:5893) ==4136== by 0x8211123: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1216) ==4136== by 0x82121F0: do_command(THD*) (sql_parse.cc:857) ==4136== by 0x8200889: handle_one_connection (sql_connect.cc:1115) ==4136== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==4136== by 0x3D606D: clone (in /lib/libc-2.5.so) ==4136== Address 0x4079D3A is 14 bytes before a block of size 4,088 alloc'd ==4136== at 0x4005400: malloc (vg_replace_malloc.c:149) ==4136== by 0x84F53DF: my_once_alloc (my_once.c:61) ==4136== by 0x8504835: init_state_maps (charset.c:65) ==4136== by 0x85051AA: init_available_charsets (charset.c:435) ==4136== by 0x85053FD: get_charset_by_csname (charset.c:588) ==4136== by 0x81F98CD: init_common_variables(char const*, int, char**, char const**) (mysqld.cc:3349) ==4136== by 0x81FB569: main (mysqld.cc:4255) ==4136== ==4136== 4 errors in context 2 of 5: ==4136== Conditional jump or move depends on uninitialised value(s) ==4136== at 0x813A295: MYSQLlex(void*, void*) (sql_lex.cc:982) ==4136== by 0x82232DE: MYSQLparse(void*) (sql_yacc.cc:15681) ==4136== by 0x8200D7A: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:7797) ==4136== by 0x820FD6A: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:5893) ==4136== by 0x8211123: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1216) ==4136== by 0x82121F0: do_command(THD*) (sql_parse.cc:857) ==4136== by 0x8200889: handle_one_connection (sql_connect.cc:1115) ==4136== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==4136== by 0x3D606D: clone (in /lib/libc-2.5.so) ==4136== ==4136== 4 errors in context 3 of 5: ==4136== Conditional jump or move depends on uninitialised value(s) ==4136== at 0x813A163: MYSQLlex(void*, void*) (sql_lex.cc:934) ==4136== by 0x82232DE: MYSQLparse(void*) (sql_yacc.cc:15681) ==4136== by 0x8200D7A: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:7797) ==4136== by 0x820FD6A: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:5893) ==4136== by 0x8211123: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1216) ==4136== by 0x82121F0: do_command(THD*) (sql_parse.cc:857) ==4136== by 0x8200889: handle_one_connection (sql_connect.cc:1115) ==4136== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==4136== by 0x3D606D: clone (in /lib/libc-2.5.so) ==4136== ==4136== 9 errors in context 4 of 5: ==4136== Invalid read of size 1 ==4136== at 0x813A291: MYSQLlex(void*, void*) (sql_lex.cc:982) ==4136== by 0x82232DE: MYSQLparse(void*) (sql_yacc.cc:15681) ==4136== by 0x8200D7A: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:7797) ==4136== by 0x820FD6A: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:5893) ==4136== by 0x8211123: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1216) ==4136== by 0x82121F0: do_command(THD*) (sql_parse.cc:857) ==4136== by 0x8200889: handle_one_connection (sql_connect.cc:1115) ==4136== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==4136== by 0x3D606D: clone (in /lib/libc-2.5.so) ==4136== Address 0x4079D2F is not stack'd, malloc'd or (recently) free'd ==4136== ==4136== 17 errors in context 5 of 5: ==4136== Invalid read of size 1 ==4136== at 0x813A15F: MYSQLlex(void*, void*) (sql_lex.cc:934) ==4136== by 0x82232DE: MYSQLparse(void*) (sql_yacc.cc:15681) ==4136== by 0x8200D7A: parse_sql(THD*, Parser_state*, Object_creation_ctx*) (sql_parse.cc:7797) ==4136== by 0x820FD6A: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:5893) ==4136== by 0x8211123: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1216) ==4136== by 0x82121F0: do_command(THD*) (sql_parse.cc:857) ==4136== by 0x8200889: handle_one_connection (sql_connect.cc:1115) ==4136== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==4136== by 0x3D606D: clone (in /lib/libc-2.5.so) ==4136== Address 0x4079D1C is 4 bytes after a block of size 4,088 alloc'd ==4136== at 0x4005400: malloc (vg_replace_malloc.c:149) ==4136== by 0x84F53DF: my_once_alloc (my_once.c:61) ==4136== by 0x8504813: init_state_maps (charset.c:62) ==4136== by 0x85051AA: init_available_charsets (charset.c:435) ==4136== by 0x85053FD: get_charset_by_csname (charset.c:588) ==4136== by 0x81F98CD: init_common_variables(char const*, int, char**, char const**) (mysqld.cc:3349) ==4136== by 0x81FB569: main (mysqld.cc:4255) --4136-- --4136-- supp: 24 Fedora-Core-6-hack3-ld25 ==4136== ==4136== IN SUMMARY: 36 errors from 5 contexts (suppressed: 24 from 1) ==4136== ==4136== malloc/free: in use at exit: 1,324 bytes in 10 blocks. ==4136== malloc/free: 286,295 allocs, 286,285 frees, 690,909,690 bytes allocated. ==4136== ==4136== searching for pointers to 10 not-freed blocks. ==4136== checked 84,755,968 bytes. ==4136== ==4136== Thread 1: ==4136== ==4136== 28 bytes in 1 blocks are still reachable in loss record 1 of 2 ==4136== at 0x4005400: malloc (vg_replace_malloc.c:149) ==4136== by 0x2CFA38: _dl_map_object_deps (in /lib/ld-2.5.so) ==4136== by 0x2D46C4: dl_open_worker (in /lib/ld-2.5.so) ==4136== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==4136== by 0x2D4191: _dl_open (in /lib/ld-2.5.so) ==4136== by 0x40B3A1: do_dlopen (in /lib/libc-2.5.so) ==4136== by 0x2D0C05: _dl_catch_error (in /lib/ld-2.5.so) ==4136== by 0x40B554: __libc_dlopen_mode (in /lib/libc-2.5.so) ==4136== by 0x491A46: pthread_cancel_init (in /lib/libpthread-2.5.so) ==4136== by 0x491B70: _Unwind_ForcedUnwind (in /lib/libpthread-2.5.so) ==4136== by 0x48F640: __pthread_unwind (in /lib/libpthread-2.5.so) ==4136== by 0x48A31F: pthread_exit (in /lib/libpthread-2.5.so) ==4136== ==4136== ==4136== 1,296 bytes in 9 blocks are possibly lost in loss record 2 of 2 ==4136== at 0x400473F: calloc (vg_replace_malloc.c:279) ==4136== by 0x2D3AA9: _dl_allocate_tls (in /lib/ld-2.5.so) ==4136== by 0x489AC8: pthread_create@@GLIBC_2.1 (in /lib/libpthread-2.5.so) ==4136== by 0x850C6C9: my_thread_global_init (my_thr_init.c:113) ==4136== by 0x84E92FC: my_init (my_init.c:81) ==4136== by 0x81FB52D: main (mysqld.cc:4215) ==4136== ==4136== LEAK SUMMARY: ==4136== definitely lost: 0 bytes in 0 blocks. ==4136== possibly lost: 1,296 bytes in 9 blocks. ==4136== still reachable: 28 bytes in 1 blocks. ==4136== suppressed: 0 bytes in 0 blocks. --4136-- memcheck: sanity checks: 11242 cheap, 450 expensive --4136-- memcheck: auxmaps: 0 auxmap entries (0k, 0M) in use --4136-- memcheck: auxmaps: 0 searches, 0 comparisons --4136-- memcheck: SMs: n_issued = 443 (7088k, 6M) --4136-- memcheck: SMs: n_deissued = 71 (1136k, 1M) --4136-- memcheck: SMs: max_noaccess = 65535 (1048560k, 1023M) --4136-- memcheck: SMs: max_undefined = 516 (8256k, 8M) --4136-- memcheck: SMs: max_defined = 1460 (23360k, 22M) --4136-- memcheck: SMs: max_non_DSM = 432 (6912k, 6M) --4136-- memcheck: max sec V bit nodes: 1229 (62k, 0M) --4136-- memcheck: set_sec_vbits8 calls: 3892 (new: 1229, updates: 2663) --4136-- memcheck: max shadow mem size: 7278k, 7M --4136-- translate: fast SP updates identified: 31,906 ( 85.2%) --4136-- translate: generic_known SP updates identified: 4,709 ( 12.5%) --4136-- translate: generic_unknown SP updates identified: 794 ( 2.1%) --4136-- tt/tc: 10,761,905 tt lookups requiring 13,020,209 probes --4136-- tt/tc: 10,761,905 fast-cache updates, 4 flushes --4136-- transtab: new 21,557 (659,950 -> 8,946,050; ratio 135:10) [0 scs] --4136-- transtab: dumped 0 (0 -> ??) --4136-- transtab: discarded 75 (1,349 -> ??) --4136-- scheduler: 1,123,042,269 jumps (bb entries). --4136-- scheduler: 11,242/12,206,678 major/minor sched events. --4136-- sanity: 11243 cheap, 450 expensive checks. --4136-- exectx: 30,011 lists, 831 contexts (avg 0 per list) --4136-- exectx: 572,632 searches, 571,810 full compares (998 per 1000) --4136-- exectx: 8 cmp2, 154 cmp4, 0 cmpAll [sbester@box1 mysql-5.1.35-linux-i686]$