drop table if exists `t1`; create table `t1`(`col1` multipolygon not null, spatial index using btree (`col1`))engine=MyISAM; insert ignore into t1 values (); check table t1 extended; sbester@box2:~/mysql/5.1/mysql-advanced-gpl-5.1.41-linux-i686-glibc23> valgrind --tool=memcheck --leak-check=full --db-attach=no -v --show-reachable=yes ./bin/mysqld --no-defau lts --innodb_buffer_pool_size=40M --server-id=4 --basedir=./ --datadir=./data --skip-grant-tables --skip-name-resolve --innodb_flush_log_at_trx_commit=0 --skip-slave-start ==31390== Memcheck, a memory error detector. ==31390== Copyright (C) 2002-2006, and GNU GPL'd, by Julian Seward et al. ==31390== Using LibVEX rev 1658, a library for dynamic binary translation. ==31390== Copyright (C) 2004-2006, and GNU GPL'd, by OpenWorks LLP. ==31390== Using valgrind-3.2.2.SVN, a dynamic binary instrumentation framework. ==31390== Copyright (C) 2000-2006, and GNU GPL'd, by Julian Seward et al. ==31390== --31390-- Command line --31390-- ./bin/mysqld --31390-- --no-defaults --31390-- --innodb_buffer_pool_size=40M --31390-- --server-id=4 --31390-- --basedir=./ --31390-- --datadir=./data --31390-- --skip-grant-tables --31390-- --skip-name-resolve --31390-- --innodb_flush_log_at_trx_commit=0 --31390-- --skip-slave-start --31390-- Startup, with flags: --31390-- --tool=memcheck --31390-- --leak-check=full --31390-- --db-attach=no --31390-- -v --31390-- --show-reachable=yes --31390-- Contents of /proc/version: --31390-- Linux version 2.6.18.2-34-default (geeko@buildhost) (gcc version 4.1.2 20061115 (prerelease) (SUSE Linux)) #1 SMP Mon Nov 27 11:46:27 UTC 2006 --31390-- Arch and hwcaps: X86, x86-sse1-sse2 --31390-- Valgrind library directory: /usr/lib64/valgrind --31390-- Reading syms from /lib/ld-2.5.so (0x4100000) --31390-- Reading syms from /home/sbester/mysql/5.1/mysql-advanced-gpl-5.1.41-linux-i686-glibc23/bin/mysqld (0x8048000) --31390-- Reading syms from /usr/lib64/valgrind/x86-linux/memcheck (0x38000000) --31390-- object doesn't have a symbol table --31390-- object doesn't have a dynamic symbol table --31390-- Reading suppressions file: /usr/lib64/valgrind/default.supp --31390-- REDIR: 0x4115970 (index) redirected to 0x38027D8B (???) --31390-- Reading syms from /usr/lib64/valgrind/x86-linux/vgpreload_core.so (0x5BCF000) --31390-- object doesn't have a symbol table --31390-- Reading syms from /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so (0x5BD6000) --31390-- object doesn't have a symbol table ==31390== WARNING: new redirection conflicts with existing -- ignoring it --31390-- new: 0x04115970 (index ) R-> 0x05BD90D0 index --31390-- REDIR: 0x4115B10 (strlen) redirected to 0x5BD9290 (strlen) --31390-- Reading syms from /lib/libpthread-2.5.so (0x5C03000) --31390-- Reading syms from /lib/libdl-2.5.so (0x5C23000) --31390-- Reading syms from /lib/libcrypt-2.5.so (0x5C2B000) --31390-- Reading syms from /lib/libnsl-2.5.so (0x5C67000) --31390-- Reading syms from /lib/libm-2.5.so (0x5C81000) --31390-- Reading syms from /lib/libc-2.5.so (0x5CAF000) --31390-- REDIR: 0x5D1AFB0 (memset) redirected to 0x5BD9580 (memset) --31390-- REDIR: 0x5D1B4B0 (memcpy) redirected to 0x5BD9C50 (memcpy) --31390-- REDIR: 0x5D1A130 (rindex) redirected to 0x5BD8FB0 (rindex) --31390-- REDIR: 0x5D19E30 (strnlen) redirected to 0x5BD9240 (strnlen) --31390-- REDIR: 0x5D1AF40 (memmove) redirected to 0x5BD95B0 (memmove) --31390-- REDIR: 0x5D19D80 (strlen) redirected to 0x5BD9270 (strlen) --31390-- REDIR: 0x5D16B20 (calloc) redirected to 0x5BD7698 (calloc) --31390-- REDIR: 0x5D17040 (malloc) redirected to 0x5BD836B (malloc) --31390-- Reading syms from /lib/libgcc_s.so.1 (0x5F6C000) --31390-- object doesn't have a symbol table --31390-- REDIR: 0x5D1AAB0 (memchr) redirected to 0x5BD9460 (memchr) --31390-- REDIR: 0x5D14CF0 (free) redirected to 0x5BD7F85 (free) --31390-- REDIR: 0x5D19F80 (strncmp) redirected to 0x5BD92D0 (strncmp) --31390-- REDIR: 0x5D1B1B0 (stpcpy) redirected to 0x5BD9910 (stpcpy) --31390-- REDIR: 0x5D19870 (strcpy) redirected to 0x5BD99F0 (strcpy) --31390-- REDIR: 0x5D19800 (strcmp) redirected to 0x5BD9340 (strcmp) --31390-- REDIR: 0x5D19690 (index) redirected to 0x5BD90A0 (index) --31390-- REDIR: 0x5D1BD60 (rawmemchr) redirected to 0x5BD9650 (rawmemchr) --31390-- REDIR: 0x5D194E0 (strcat) redirected to 0x5BD9670 (strcat) --31390-- REDIR: 0x5D17470 (realloc) redirected to 0x5BD841A (realloc) 091201 9:18:35 [Note] Plugin 'FEDERATED' is disabled. --31390-- memcheck GC: 1024 nodes, 1024 survivors (100.0%) --31390-- memcheck GC: increase table size to 2048 --31390-- memcheck GC: 2048 nodes, 2048 survivors (100.0%) --31390-- memcheck GC: increase table size to 4096 091201 9:18:39 InnoDB: Started; log sequence number 0 15256286 --31390-- REDIR: 0x5D1BE30 (strchrnul) redirected to 0x5BD9620 (strchrnul) --31390-- Reading syms from /lib/libnss_files-2.5.so (0x118D0000) 091201 9:18:40 [Note] ./bin/mysqld: ready for connections. Version: '5.1.41-enterprise-gpl-advanced' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (GPL) ==31390== Thread 10: ==31390== Syscall param pwrite64(buf) points to uninitialised byte(s) ==31390== at 0x5C0FDCB: do_pwrite64 (in /lib/libpthread-2.5.so) ==31390== by 0x5C0FE7F: pwrite64 (in /lib/libpthread-2.5.so) ==31390== by 0x84C448E: my_pwrite (my_pread.c:144) ==31390== by 0x84DD643: flush_cached_blocks (mf_keycache.c:3517) ==31390== by 0x84DF1D1: flush_key_blocks_int (mf_keycache.c:3808) ==31390== by 0x84DF86C: flush_key_blocks (mf_keycache.c:4065) ==31390== by 0x849061A: mi_lock_database (mi_locking.c:63) ==31390== by 0x82F2E17: handler::ha_external_lock(THD*, int) (handler.cc:4613) ==31390== by 0x81FBE50: mysql_unlock_tables(THD*, st_mysql_lock*) (lock.cc:786) ==31390== by 0x824F04D: close_thread_tables(THD*) (sql_base.cc:1340) ==31390== by 0x821B205: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1626) ==31390== by 0x821CB1F: do_command(THD*) (sql_parse.cc:872) ==31390== Address 0x78FF02A is 2 bytes inside a block of size 7,418,880 alloc'd ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84C7CA3: my_malloc (my_malloc.c:34) ==31390== by 0x84DBE15: my_large_malloc (my_largepage.c:64) ==31390== by 0x84DCC78: init_key_cache (mf_keycache.c:436) ==31390== by 0x82F36EC: ha_init_key_cache (handler.cc:3715) ==31390== by 0x821E0CF: process_key_caches(int (*)(char const*, st_key_cache*)) (set_var.cc:4121) ==31390== by 0x820425B: _ZL22init_server_componentsv (mysqld.cc:3921) ==31390== by 0x8208839: main (mysqld.cc:4399) ==31390== ==31390== Conditional jump or move depends on uninitialised value(s) ==31390== at 0x84B5F6B: rtree_key_cmp (rt_mbr.c:157) ==31390== by 0x84B569C: rtree_find_req (rt_index.c:112) ==31390== by 0x84A8781: chk_data_link (mi_check.c:1251) ==31390== by 0x8482036: ha_myisam::check(THD*, st_ha_check_opt*) (ha_myisam.cc:833) ==31390== by 0x82F8C81: handler::ha_check(THD*, st_ha_check_opt*) (handler.cc:3106) ==31390== by 0x8311CEF: _ZL17mysql_admin_tableP3THDP10TABLE_LISTP15st_ha_check_optPKc13thr_lock_typebbjPFiS0_S2_S4_EM7handlerFiS0_S4_EPFiS0_S2_E (sql_table.cc:4762) ==31390== by 0x8312C2A: mysql_check_table(THD*, TABLE_LIST*, st_ha_check_opt*) (sql_table.cc:5468) ==31390== by 0x8217356: mysql_execute_command(THD*) (sql_parse.cc:2999) ==31390== by 0x821B044: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:5970) ==31390== by 0x821C277: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1231) ==31390== by 0x821CB1F: do_command(THD*) (sql_parse.cc:872) ==31390== by 0x820D412: handle_one_connection (sql_connect.cc:1127) ==31390== ==31390== Invalid write of size 4 ==31390== at 0x84B57CD: rtree_find_req (rt_index.c:120) ==31390== by 0x84A8781: chk_data_link (mi_check.c:1251) ==31390== by 0x8482036: ha_myisam::check(THD*, st_ha_check_opt*) (ha_myisam.cc:833) ==31390== by 0x82F8C81: handler::ha_check(THD*, st_ha_check_opt*) (handler.cc:3106) ==31390== by 0x8311CEF: _ZL17mysql_admin_tableP3THDP10TABLE_LISTP15st_ha_check_optPKc13thr_lock_typebbjPFiS0_S2_S4_EM7handlerFiS0_S4_EPFiS0_S2_E (sql_table.cc:4762) ==31390== by 0x8312C2A: mysql_check_table(THD*, TABLE_LIST*, st_ha_check_opt*) (sql_table.cc:5468) ==31390== by 0x8217356: mysql_execute_command(THD*) (sql_parse.cc:2999) ==31390== by 0x821B044: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:5970) ==31390== by 0x821C277: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1231) ==31390== by 0x821CB1F: do_command(THD*) (sql_parse.cc:872) ==31390== by 0x820D412: handle_one_connection (sql_connect.cc:1127) ==31390== by 0x5C08111: start_thread (in /lib/libpthread-2.5.so) ==31390== Address 0x0 is not stack'd, malloc'd or (recently) free'd 091201 9:18:49 - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8384512 read_buffer_size=131072 max_used_connections=1 max_threads=151 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 337723 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0xc3a3408 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x1193f3b8 thread_stack 0x30000 ./bin/mysqld(my_print_stacktrace+0x21)[0x84dc0a1] ./bin/mysqld(handle_segfault+0x381)[0x8203ad1] /lib/libpthread.so.0[0x5c10628] ./bin/mysqld(chk_data_link+0xb12)[0x84a8782] ./bin/mysqld(_ZN9ha_myisam5checkEP3THDP15st_ha_check_opt+0x4a7)[0x8482037] ./bin/mysqld(_ZN7handler8ha_checkEP3THDP15st_ha_check_opt+0xa2)[0x82f8c82] ./bin/mysqld[0x8311cf0] ./bin/mysqld(_Z17mysql_check_tableP3THDP10TABLE_LISTP15st_ha_check_opt+0x5b)[0x8312c2b] ./bin/mysqld(_Z21mysql_execute_commandP3THD+0x3cf7)[0x8217357] ./bin/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x355)[0x821b045] ./bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1228)[0x821c278] ./bin/mysqld(_Z10do_commandP3THD+0xe0)[0x821cb20] ./bin/mysqld(handle_one_connection+0x253)[0x820d413] /lib/libpthread.so.0[0x5c08112] /lib/libc.so.6(clone+0x5e)[0x5d6e2ee] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0xdd8fe68 is an invalid pointer thd->thread_id=1 thd->killed=NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. --31390-- Discarding syms at 0x118D0000-0x118DA000 in /lib/libnss_files-2.5.so due to munmap() ==31390== ==31390== ERROR SUMMARY: 10 errors from 3 contexts (suppressed: 3 from 1) ==31390== ==31390== 1 errors in context 1 of 3: ==31390== Invalid write of size 4 ==31390== at 0x84B57CD: rtree_find_req (rt_index.c:120) ==31390== by 0x84A8781: chk_data_link (mi_check.c:1251) ==31390== by 0x8482036: ha_myisam::check(THD*, st_ha_check_opt*) (ha_myisam.cc:833) ==31390== by 0x82F8C81: handler::ha_check(THD*, st_ha_check_opt*) (handler.cc:3106) ==31390== by 0x8311CEF: _ZL17mysql_admin_tableP3THDP10TABLE_LISTP15st_ha_check_optPKc13thr_lock_typebbjPFiS0_S2_S4_EM7handlerFiS0_S4_EPFiS0_S2_E (sql_table.cc:4762) ==31390== by 0x8312C2A: mysql_check_table(THD*, TABLE_LIST*, st_ha_check_opt*) (sql_table.cc:5468) ==31390== by 0x8217356: mysql_execute_command(THD*) (sql_parse.cc:2999) ==31390== by 0x821B044: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:5970) ==31390== by 0x821C277: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1231) ==31390== by 0x821CB1F: do_command(THD*) (sql_parse.cc:872) ==31390== by 0x820D412: handle_one_connection (sql_connect.cc:1127) ==31390== by 0x5C08111: start_thread (in /lib/libpthread-2.5.so) ==31390== Address 0x0 is not stack'd, malloc'd or (recently) free'd ==31390== ==31390== 1 errors in context 2 of 3: ==31390== Syscall param pwrite64(buf) points to uninitialised byte(s) ==31390== at 0x5C0FDCB: do_pwrite64 (in /lib/libpthread-2.5.so) ==31390== by 0x5C0FE7F: pwrite64 (in /lib/libpthread-2.5.so) ==31390== by 0x84C448E: my_pwrite (my_pread.c:144) ==31390== by 0x84DD643: flush_cached_blocks (mf_keycache.c:3517) ==31390== by 0x84DF1D1: flush_key_blocks_int (mf_keycache.c:3808) ==31390== by 0x84DF86C: flush_key_blocks (mf_keycache.c:4065) ==31390== by 0x849061A: mi_lock_database (mi_locking.c:63) ==31390== by 0x82F2E17: handler::ha_external_lock(THD*, int) (handler.cc:4613) ==31390== by 0x81FBE50: mysql_unlock_tables(THD*, st_mysql_lock*) (lock.cc:786) ==31390== by 0x824F04D: close_thread_tables(THD*) (sql_base.cc:1340) ==31390== by 0x821B205: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1626) ==31390== by 0x821CB1F: do_command(THD*) (sql_parse.cc:872) ==31390== Address 0x78FF02A is 2 bytes inside a block of size 7,418,880 alloc'd ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84C7CA3: my_malloc (my_malloc.c:34) ==31390== by 0x84DBE15: my_large_malloc (my_largepage.c:64) ==31390== by 0x84DCC78: init_key_cache (mf_keycache.c:436) ==31390== by 0x82F36EC: ha_init_key_cache (handler.cc:3715) ==31390== by 0x821E0CF: process_key_caches(int (*)(char const*, st_key_cache*)) (set_var.cc:4121) ==31390== by 0x820425B: _ZL22init_server_componentsv (mysqld.cc:3921) ==31390== by 0x8208839: main (mysqld.cc:4399) ==31390== ==31390== 8 errors in context 3 of 3: ==31390== Conditional jump or move depends on uninitialised value(s) ==31390== at 0x84B5F6B: rtree_key_cmp (rt_mbr.c:157) ==31390== by 0x84B569C: rtree_find_req (rt_index.c:112) ==31390== by 0x84A8781: chk_data_link (mi_check.c:1251) ==31390== by 0x8482036: ha_myisam::check(THD*, st_ha_check_opt*) (ha_myisam.cc:833) ==31390== by 0x82F8C81: handler::ha_check(THD*, st_ha_check_opt*) (handler.cc:3106) ==31390== by 0x8311CEF: _ZL17mysql_admin_tableP3THDP10TABLE_LISTP15st_ha_check_optPKc13thr_lock_typebbjPFiS0_S2_S4_EM7handlerFiS0_S4_EPFiS0_S2_E (sql_table.cc:4762) ==31390== by 0x8312C2A: mysql_check_table(THD*, TABLE_LIST*, st_ha_check_opt*) (sql_table.cc:5468) ==31390== by 0x8217356: mysql_execute_command(THD*) (sql_parse.cc:2999) ==31390== by 0x821B044: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:5970) ==31390== by 0x821C277: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1231) ==31390== by 0x821CB1F: do_command(THD*) (sql_parse.cc:872) ==31390== by 0x820D412: handle_one_connection (sql_connect.cc:1127) --31390-- --31390-- supp: 3 dl-hack3 ==31390== ==31390== IN SUMMARY: 10 errors from 3 contexts (suppressed: 3 from 1) ==31390== ==31390== malloc/free: in use at exit: 61,989,983 bytes in 38,047 blocks. ==31390== malloc/free: 38,304 allocs, 257 frees, 87,586,550 bytes allocated. ==31390== ==31390== searching for pointers to 38,047 not-freed blocks. ==31390== checked 80,820,468 bytes. ==31390== ==31390== Thread 1: ==31390== ==31390== 1 bytes in 1 blocks are still reachable in loss record 1 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x837820F: Events::init(char) (events.cc:934) ==31390== by 0x8208C16: main (mysqld.cc:4473) ==31390== ==31390== ==31390== 3 bytes in 1 blocks are still reachable in loss record 2 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84EC89E: my_regex_init (reginit.c:51) ==31390== by 0x8207910: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:3372) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 4 bytes in 1 blocks are still reachable in loss record 3 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x829FF84: LOGGER::init_log_tables() (log.cc:912) ==31390== by 0x8204673: _ZL22init_server_componentsv (mysqld.cc:3987) ==31390== by 0x8208839: main (mysqld.cc:4399) ==31390== ==31390== ==31390== 8 bytes in 1 blocks are still reachable in loss record 4 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84ECA50: my_regex_init (reginit.c:51) ==31390== by 0x8207910: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:3372) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 11 bytes in 1 blocks are still reachable in loss record 5 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84EC91A: my_regex_init (reginit.c:51) ==31390== by 0x8207910: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:3372) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 19 bytes in 1 blocks are still reachable in loss record 6 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x410AA9D: _dl_new_object (in /lib/ld-2.5.so) ==31390== by 0x4106589: _dl_map_object_from_fd (in /lib/ld-2.5.so) ==31390== by 0x410848B: _dl_map_object (in /lib/ld-2.5.so) ==31390== by 0x4111DD4: dl_open_worker (in /lib/ld-2.5.so) ==31390== by 0x410E025: _dl_catch_error (in /lib/ld-2.5.so) ==31390== by 0x4111928: _dl_open (in /lib/ld-2.5.so) ==31390== by 0x5DA0F01: do_dlopen (in /lib/libc-2.5.so) ==31390== by 0x410E025: _dl_catch_error (in /lib/ld-2.5.so) ==31390== by 0x5DA1000: dlerror_run (in /lib/libc-2.5.so) ==31390== by 0x5DA112A: __libc_dlopen_mode (in /lib/libc-2.5.so) ==31390== by 0x5C10E66: pthread_cancel_init (in /lib/libpthread-2.5.so) ==31390== ==31390== ==31390== 19 bytes in 1 blocks are still reachable in loss record 7 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x4108A23: _dl_map_object (in /lib/ld-2.5.so) ==31390== by 0x4111DD4: dl_open_worker (in /lib/ld-2.5.so) ==31390== by 0x410E025: _dl_catch_error (in /lib/ld-2.5.so) ==31390== by 0x4111928: _dl_open (in /lib/ld-2.5.so) ==31390== by 0x5DA0F01: do_dlopen (in /lib/libc-2.5.so) ==31390== by 0x410E025: _dl_catch_error (in /lib/ld-2.5.so) ==31390== by 0x5DA1000: dlerror_run (in /lib/libc-2.5.so) ==31390== by 0x5DA112A: __libc_dlopen_mode (in /lib/libc-2.5.so) ==31390== by 0x5C10E66: pthread_cancel_init (in /lib/libpthread-2.5.so) ==31390== by 0x5C10F90: _Unwind_ForcedUnwind (in /lib/libpthread-2.5.so) ==31390== by 0x5C0E950: __pthread_unwind (in /lib/libpthread-2.5.so) ==31390== ==31390== ==31390== 23 bytes in 1 blocks are still reachable in loss record 8 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84ECAC8: my_regex_init (reginit.c:51) ==31390== by 0x8207910: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:3372) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 28 bytes in 1 blocks are still reachable in loss record 9 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x410CE43: _dl_map_object_deps (in /lib/ld-2.5.so) ==31390== by 0x4111E34: dl_open_worker (in /lib/ld-2.5.so) ==31390== by 0x410E025: _dl_catch_error (in /lib/ld-2.5.so) ==31390== by 0x4111928: _dl_open (in /lib/ld-2.5.so) ==31390== by 0x5DA0F01: do_dlopen (in /lib/libc-2.5.so) ==31390== by 0x410E025: _dl_catch_error (in /lib/ld-2.5.so) ==31390== by 0x5DA1000: dlerror_run (in /lib/libc-2.5.so) ==31390== by 0x5DA112A: __libc_dlopen_mode (in /lib/libc-2.5.so) ==31390== by 0x5C10E66: pthread_cancel_init (in /lib/libpthread-2.5.so) ==31390== by 0x5C10F90: _Unwind_ForcedUnwind (in /lib/libpthread-2.5.so) ==31390== by 0x5C0E950: __pthread_unwind (in /lib/libpthread-2.5.so) ==31390== ==31390== ==31390== 33 bytes in 1 blocks are still reachable in loss record 10 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84EC8DC: my_regex_init (reginit.c:51) ==31390== by 0x8207910: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:3372) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 61 bytes in 1 blocks are still reachable in loss record 11 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84ECA8E: my_regex_init (reginit.c:51) ==31390== by 0x8207910: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:3372) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 63 bytes in 1 blocks are still reachable in loss record 12 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84EC996: my_regex_init (reginit.c:51) ==31390== by 0x8207910: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:3372) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 85 bytes in 1 blocks are still reachable in loss record 13 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84ECA12: my_regex_init (reginit.c:51) ==31390== by 0x8207910: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:3372) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 120 bytes in 1 blocks are still reachable in loss record 14 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x82B7A4E: acl_init(bool) (sql_acl.cc:266) ==31390== by 0x8208B6B: main (mysqld.cc:4428) ==31390== ==31390== ==31390== 120 bytes in 1 blocks are still reachable in loss record 15 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x820B844: hostname_cache_init() (hostname.cc:65) ==31390== by 0x82040CE: _ZL22init_server_componentsv (mysqld.cc:3742) ==31390== by 0x8208839: main (mysqld.cc:4399) ==31390== ==31390== ==31390== 123 bytes in 1 blocks are still reachable in loss record 16 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84EC860: my_regex_init (reginit.c:51) ==31390== by 0x8207910: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:3372) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 133 bytes in 1 blocks are still reachable in loss record 17 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84EC822: my_regex_init (reginit.c:51) ==31390== by 0x8207910: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:3372) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 200 bytes in 1 blocks are still reachable in loss record 18 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x8206754: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:3202) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 200 bytes in 1 blocks are still reachable in loss record 19 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x8206738: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:3201) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 208 bytes in 1 blocks are still reachable in loss record 20 of 33 ==31390== at 0x5BD772F: calloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x410F910: _dl_check_map_versions (in /lib/ld-2.5.so) ==31390== by 0x41120C8: dl_open_worker (in /lib/ld-2.5.so) ==31390== by 0x410E025: _dl_catch_error (in /lib/ld-2.5.so) ==31390== by 0x4111928: _dl_open (in /lib/ld-2.5.so) ==31390== by 0x5DA0F01: do_dlopen (in /lib/libc-2.5.so) ==31390== by 0x410E025: _dl_catch_error (in /lib/ld-2.5.so) ==31390== by 0x5DA1000: dlerror_run (in /lib/libc-2.5.so) ==31390== by 0x5DA112A: __libc_dlopen_mode (in /lib/libc-2.5.so) ==31390== by 0x5C10E66: pthread_cancel_init (in /lib/libpthread-2.5.so) ==31390== by 0x5C10F90: _Unwind_ForcedUnwind (in /lib/libpthread-2.5.so) ==31390== by 0x5C0E950: __pthread_unwind (in /lib/libpthread-2.5.so) ==31390== ==31390== ==31390== 217 bytes in 1 blocks are still reachable in loss record 21 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84EC958: my_regex_init (reginit.c:51) ==31390== by 0x8207910: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:3372) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 219 bytes in 1 blocks are still reachable in loss record 22 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84EC9D4: my_regex_init (reginit.c:51) ==31390== by 0x8207910: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:3372) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 316 bytes in 2 blocks are possibly lost in loss record 23 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84C7CA3: my_malloc (my_malloc.c:34) ==31390== by 0x8487478: mi_open (mi_open.c:728) ==31390== by 0x8484363: ha_myisam::open(char const*, int, unsigned) (ha_myisam.cc:698) ==31390== by 0x82F3FA7: handler::ha_open(st_table*, char const*, int, int) (handler.cc:2090) ==31390== by 0x8257E86: open_table_from_share(THD*, st_table_share*, char const*, unsigned, unsigned, unsigned, st_table*, bool) (table.cc:1881) ==31390== by 0x8251BE8: _ZL17open_unireg_entryP3THDP8st_tableP10TABLE_LISTPKcPcjP11st_mem_rootj (sql_base.cc:3913) ==31390== by 0x8252AB9: open_table(THD*, TABLE_LIST*, st_mem_root*, bool*, unsigned) (sql_base.cc:2915) ==31390== by 0x825398F: open_tables(THD*, TABLE_LIST**, unsigned*, unsigned) (sql_base.cc:4581) ==31390== by 0x8253B87: open_and_lock_tables_derived(THD*, TABLE_LIST*, bool) (sql_base.cc:4987) ==31390== by 0x8287E88: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (mysql_priv.h:1562) ==31390== by 0x82151AF: mysql_execute_command(THD*) (sql_parse.cc:3179) ==31390== ==31390== ==31390== 372 bytes in 3 blocks are still reachable in loss record 24 of 33 ==31390== at 0x5BD772F: calloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84E219B: my_thread_init (my_thr_init.c:271) ==31390== by 0x84E2529: my_thread_global_init (my_thr_init.c:162) ==31390== by 0x84C3293: my_init (my_init.c:81) ==31390== by 0x8208697: main (mysqld.cc:4261) ==31390== ==31390== ==31390== 630 bytes in 1 blocks are still reachable in loss record 25 of 33 ==31390== at 0x5BD772F: calloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x410A80A: _dl_new_object (in /lib/ld-2.5.so) ==31390== by 0x4106589: _dl_map_object_from_fd (in /lib/ld-2.5.so) ==31390== by 0x410848B: _dl_map_object (in /lib/ld-2.5.so) ==31390== by 0x4111DD4: dl_open_worker (in /lib/ld-2.5.so) ==31390== by 0x410E025: _dl_catch_error (in /lib/ld-2.5.so) ==31390== by 0x4111928: _dl_open (in /lib/ld-2.5.so) ==31390== by 0x5DA0F01: do_dlopen (in /lib/libc-2.5.so) ==31390== by 0x410E025: _dl_catch_error (in /lib/ld-2.5.so) ==31390== by 0x5DA1000: dlerror_run (in /lib/libc-2.5.so) ==31390== by 0x5DA112A: __libc_dlopen_mode (in /lib/libc-2.5.so) ==31390== by 0x5C10E66: pthread_cancel_init (in /lib/libpthread-2.5.so) ==31390== ==31390== ==31390== 1,360 bytes in 10 blocks are possibly lost in loss record 26 of 33 ==31390== at 0x5BD772F: calloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x4111037: allocate_dtv (in /lib/ld-2.5.so) ==31390== by 0x41110FB: _dl_allocate_tls (in /lib/ld-2.5.so) ==31390== by 0x5C0890F: pthread_create@@GLIBC_2.1 (in /lib/libpthread-2.5.so) ==31390== by 0x84E25E9: my_thread_global_init (my_thr_init.c:113) ==31390== by 0x84C3293: my_init (my_init.c:81) ==31390== by 0x8208697: main (mysqld.cc:4261) ==31390== ==31390== ==31390== 1,760 bytes in 5 blocks are still reachable in loss record 27 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x5D047D6: fdopen@@GLIBC_2.1 (in /lib/libc-2.5.so) ==31390== by 0x840C1F6: os_file_create_tmpfile (os0file.c:547) ==31390== by 0x8443AE0: innobase_start_or_create_for_mysql (srv0start.c:1221) ==31390== by 0x83A07FD: _ZL13innobase_initPv (ha_innodb.cc:1922) ==31390== by 0x82F4453: ha_initialize_handlerton(st_plugin_int*) (handler.cc:435) ==31390== by 0x837CB5D: _ZL17plugin_initializeP13st_plugin_int (sql_plugin.cc:1014) ==31390== by 0x837F6FB: plugin_init(int*, char**, int) (sql_plugin.cc:1238) ==31390== by 0x82042AD: _ZL22init_server_componentsv (mysqld.cc:3928) ==31390== by 0x8208839: main (mysqld.cc:4399) ==31390== ==31390== ==31390== 1,896 bytes in 1 blocks are still reachable in loss record 28 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x82A307B: LOGGER::init_base() (log.cc:899) ==31390== by 0x82086BC: main (mysqld.cc:4275) ==31390== ==31390== ==31390== 12,300 bytes in 1 blocks are still reachable in loss record 29 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x833D8AE: init_slave() (slave.cc:234) ==31390== by 0x8208BDD: main (mysqld.cc:4466) ==31390== ==31390== ==31390== 21,760 bytes in 2 blocks are still reachable in loss record 30 of 33 ==31390== at 0x5BD84EB: realloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84C7E67: my_realloc (my_realloc.c:62) ==31390== by 0x84D098B: alloc_dynamic (array.c:151) ==31390== by 0x84CFE95: my_hash_insert (hash.c:346) ==31390== by 0x82280B6: mysql_add_sys_var_chain(sys_var*, my_option*) (set_var.cc:3253) ==31390== by 0x834256A: init_replication_sys_vars() (sql_repl.cc:1823) ==31390== by 0x82078F4: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:3367) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 44,968 bytes in 11 blocks are still reachable in loss record 31 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84C7FA3: my_once_alloc (my_once.c:61) ==31390== by 0x84D729F: init_state_maps (charset.c:62) ==31390== by 0x84D7D09: init_available_charsets (charset.c:435) ==31390== by 0x84D816D: get_charset_by_csname (charset.c:588) ==31390== by 0x8207950: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:3385) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 8,592,147 bytes in 119 blocks are still reachable in loss record 32 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x84C7CA3: my_malloc (my_malloc.c:34) ==31390== by 0x8227637: _ZL16create_key_cachePKcj (set_var.cc:4066) ==31390== by 0x8229FF2: get_or_create_key_cache(char const*, unsigned) (set_var.cc:4100) ==31390== by 0x820716D: _ZL21init_common_variablesPKciPPcPS0_ (mysqld.cc:7704) ==31390== by 0x82086D1: main (mysqld.cc:4301) ==31390== ==31390== ==31390== 53,310,576 bytes in 37,870 blocks are still reachable in loss record 33 of 33 ==31390== at 0x5BD83F0: malloc (in /usr/lib64/valgrind/x86-linux/vgpreload_memcheck.so) ==31390== by 0x845E863: ut_malloc_low (ut0mem.c:82) ==31390== by 0x845EA20: ut_malloc (ut0mem.c:189) ==31390== by 0x8410383: os_event_create (os0sync.c:144) ==31390== by 0x8447AD5: mutex_create_func (sync0sync.c:250) ==31390== by 0x8456EBB: trx_create (trx0trx.c:143) ==31390== by 0x845E108: sess_open (usr0sess.c:41) ==31390== by 0x8451DEC: trx_rollback_or_clean_all_without_sess (trx0roll.c:436) ==31390== by 0x5C08111: start_thread (in /lib/libpthread-2.5.so) ==31390== by 0x5D6E2ED: clone (in /lib/libc-2.5.so) ==31390== ==31390== LEAK SUMMARY: ==31390== definitely lost: 0 bytes in 0 blocks. ==31390== possibly lost: 1,676 bytes in 12 blocks. ==31390== still reachable: 61,988,307 bytes in 38,035 blocks. ==31390== suppressed: 0 bytes in 0 blocks. --31390-- memcheck: sanity checks: 193 cheap, 8 expensive --31390-- memcheck: auxmaps: 0 auxmap entries (0k, 0M) in use --31390-- memcheck: auxmaps: 0 searches, 0 comparisons --31390-- memcheck: SMs: n_issued = 344 (5504k, 5M) --31390-- memcheck: SMs: n_deissued = 58 (928k, 0M) --31390-- memcheck: SMs: max_noaccess = 65535 (1048560k, 1023M) --31390-- memcheck: SMs: max_undefined = 1004 (16064k, 15M) --31390-- memcheck: SMs: max_defined = 1182 (18912k, 18M) --31390-- memcheck: SMs: max_non_DSM = 293 (4688k, 4M) --31390-- memcheck: max sec V bit nodes: 3767 (191k, 0M) --31390-- memcheck: set_sec_vbits8 calls: 15638 (new: 3767, updates: 11871) --31390-- memcheck: max shadow mem size: 5183k, 5M --31390-- translate: fast SP updates identified: 22,384 ( 88.1%) --31390-- translate: generic_known SP updates identified: 2,453 ( 9.6%) --31390-- translate: generic_unknown SP updates identified: 569 ( 2.2%) --31390-- tt/tc: 52,778 tt lookups requiring 60,948 probes --31390-- tt/tc: 52,778 fast-cache updates, 4 flushes --31390-- transtab: new 17,746 (520,111 -> 7,248,864; ratio 139:10) [0 scs] --31390-- transtab: dumped 0 (0 -> ??) --31390-- transtab: discarded 126 (2,134 -> ??) --31390-- scheduler: 19,645,733 jumps (bb entries). --31390-- scheduler: 193/75,158 major/minor sched events. --31390-- sanity: 194 cheap, 8 expensive checks. --31390-- exectx: 30,011 lists, 665 contexts (avg 0 per list) --31390-- exectx: 38,573 searches, 37,916 full compares (982 per 1000) --31390-- exectx: 829,679 cmp2, 13 cmp4, 0 cmpAll sbester@box2:~/mysql/5.1/mysql-advanced-gpl-5.1.41-linux-i686-glibc23>