CURRENT_TEST: index_merge_innodb ==27198== Memcheck, a memory error detector for x86-linux. ==27198== Copyright (C) 2002-2005, and GNU GPL'd, by Julian Seward et al. ==27198== Using valgrind-2.4.0, a program supervision framework for x86-linux. ==27198== Copyright (C) 2000-2005, and GNU GPL'd, by Julian Seward et al. ==27198== For more details, rerun with: -v ==27198== InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 081029 11:32:07 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 081029 11:32:08 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 081029 11:32:11 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... ==27198== Conditional jump or move depends on uninitialised value(s) ==27198== at 0x83DDD64: trx_sys_create_doublewrite_buf (trx0sys.c:198) ==27198== by 0x837D4AB: innobase_start_or_create_for_mysql (srv0start.c:1560) ==27198== by 0x82E7A4A: innobase_init() (ha_innodb.cc:1426) ==27198== by 0x82D85C3: ha_init() (handler.cc:481) ==27198== by 0x81E772C: init_server_components() (mysqld.cc:3422) ==27198== by 0x81EB5B2: main (mysqld.cc:3756) InnoDB: Doublewrite buffer not found: creating new ==27198== ==27198== Thread 5: ==27198== Syscall param pwrite64(buf) points to uninitialised byte(s) ==27198== at 0x464EA7: pwrite64 (in /lib/libpthread-2.3.6.so) ==27198== by 0x843535E: os_file_pwrite (os0file.c:2031) ==27198== by 0x8435550: os_file_write (os0file.c:2476) ==27198== by 0x84370DC: os_aio_simulated_handle (os0file.c:4015) ==27198== by 0x840F49A: fil_aio_wait (fil0fil.c:4131) ==27198== by 0x837BA3C: io_handler_thread (srv0start.c:446) ==27198== by 0x45FBD3: start_thread (in /lib/libpthread-2.3.6.so) ==27198== by 0x3B74FD: clone (in /lib/libc-2.3.6.so) ==27198== Address 0x1F34C000 is 14896 bytes inside a block of size 753680 alloc'd ==27198== at 0x1B909222: malloc (vg_replace_malloc.c:130) ==27198== by 0x84317A9: ut_malloc_low (ut0mem.c:81) ==27198== by 0x8431942: ut_malloc (ut0mem.c:177) ==27198== by 0x8436ECE: os_aio_simulated_handle (os0file.c:3965) ==27198== by 0x840F49A: fil_aio_wait (fil0fil.c:4131) ==27198== by 0x837BA3C: io_handler_thread (srv0start.c:446) ==27198== by 0x45FBD3: start_thread (in /lib/libpthread-2.3.6.so) ==27198== by 0x3B74FD: clone (in /lib/libc-2.3.6.so) InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 081029 11:32:16 InnoDB: Started; log sequence number 0 0 ==27198== ==27198== Thread 8: ==27198== Syscall param pwrite64(buf) points to uninitialised byte(s) ==27198== at 0x464EA7: pwrite64 (in /lib/libpthread-2.3.6.so) ==27198== by 0x843535E: os_file_pwrite (os0file.c:2031) ==27198== by 0x8435550: os_file_write (os0file.c:2476) ==27198== by 0x843686E: os_aio (os0file.c:3438) ==27198== by 0x840F317: fil_io (fil0fil.c:4020) ==27198== by 0x83EDEB3: buf_flush_buffered_writes (buf0flu.c:296) ==27198== by 0x83EF59C: buf_flush_batch (buf0flu.c:945) ==27198== by 0x837B1B6: srv_master_thread (srv0srv.c:2504) ==27198== by 0x45FBD3: start_thread (in /lib/libpthread-2.3.6.so) ==27198== by 0x3B74FD: clone (in /lib/libc-2.3.6.so) ==27198== Address 0x20958000 is 16344 bytes inside a block of size 2113552 alloc'd ==27198== at 0x1B909222: malloc (vg_replace_malloc.c:130) ==27198== by 0x84317A9: ut_malloc_low (ut0mem.c:81) ==27198== by 0x8431942: ut_malloc (ut0mem.c:177) ==27198== by 0x83DD8C9: trx_doublewrite_init (trx0sys.c:115) ==27198== by 0x83DDD70: trx_sys_create_doublewrite_buf (trx0sys.c:203) ==27198== by 0x837D4AB: innobase_start_or_create_for_mysql (srv0start.c:1560) ==27198== by 0x82E7A4A: innobase_init() (ha_innodb.cc:1426) ==27198== by 0x82D85C3: ha_init() (handler.cc:481) ==27198== by 0x81E772C: init_server_components() (mysqld.cc:3422) ==27198== by 0x81EB5B2: main (mysqld.cc:3756) 081029 11:32:17 [Note] /users/ssmirnova/src/mysql-5.0/sql/mysqld: ready for connections. Version: '5.0.74-debug-log' socket: '/users/ssmirnova/src/mysql-5.0/mysql-test/var/tmp/master.sock' port: 9306 Source distribution ==27198== ==27198== Thread 10: ==27198== Conditional jump or move depends on uninitialised value(s) ==27198== at 0x83DE557: trx_sys_update_mysql_binlog_offset (trx0sys.c:599) ==27198== by 0x83E13B4: trx_commit_off_kernel (trx0trx.c:799) ==27198== by 0x83E27E5: trx_commit_for_mysql (trx0trx.c:1629) ==27198== by 0x82E7D78: innobase_commit_low(trx_struct*) (ha_innodb.cc:1545) ==27198== by 0x82E800D: innobase_commit(THD*, bool) (ha_innodb.cc:1675) ==27198== by 0x82D89ED: ha_commit_one_phase(THD*, bool) (handler.cc:753) ==27198== by 0x82D9058: ha_commit_trans(THD*, bool) (handler.cc:723) ==27198== by 0x82D92D1: ha_autocommit_or_rollback(THD*, int) (handler.cc:870) ==27198== by 0x8274BBB: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:930) ==27198== by 0x8204CE2: mysql_execute_command(THD*) (sql_parse.cc:3666) ==27198== by 0x8209CA7: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:6266) ==27198== by 0x820A6D0: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1938) ==27198== by 0x820B9E1: do_command(THD*) (sql_parse.cc:1628) ==27198== by 0x820BEA7: handle_one_connection (sql_parse.cc:1234) ==27198== by 0x45FBD3: start_thread (in /lib/libpthread-2.3.6.so) ==27198== by 0x3B74FD: clone (in /lib/libc-2.3.6.so) ==27198== ==27198== Conditional jump or move depends on uninitialised value(s) ==27198== at 0x1B90A160: strcmp (mac_replace_strmem.c:251) ==27198== by 0x83DE586: trx_sys_update_mysql_binlog_offset (trx0sys.c:609) ==27198== by 0x83E13B4: trx_commit_off_kernel (trx0trx.c:799) ==27198== by 0x83E27E5: trx_commit_for_mysql (trx0trx.c:1629) ==27198== by 0x82E7D78: innobase_commit_low(trx_struct*) (ha_innodb.cc:1545) ==27198== by 0x82E800D: innobase_commit(THD*, bool) (ha_innodb.cc:1675) ==27198== by 0x82D89ED: ha_commit_one_phase(THD*, bool) (handler.cc:753) ==27198== by 0x82D9058: ha_commit_trans(THD*, bool) (handler.cc:723) ==27198== by 0x82D92D1: ha_autocommit_or_rollback(THD*, int) (handler.cc:870) ==27198== by 0x8274BBB: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:930) ==27198== by 0x8204CE2: mysql_execute_command(THD*) (sql_parse.cc:3666) ==27198== by 0x8209CA7: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:6266) ==27198== by 0x820A6D0: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1938) ==27198== by 0x820B9E1: do_command(THD*) (sql_parse.cc:1628) ==27198== by 0x820BEA7: handle_one_connection (sql_parse.cc:1234) ==27198== by 0x45FBD3: start_thread (in /lib/libpthread-2.3.6.so) ==27198== ==27198== Conditional jump or move depends on uninitialised value(s) ==27198== at 0x1B90A17F: strcmp (mac_replace_strmem.c:255) ==27198== by 0x83DE586: trx_sys_update_mysql_binlog_offset (trx0sys.c:609) ==27198== by 0x83E13B4: trx_commit_off_kernel (trx0trx.c:799) ==27198== by 0x83E27E5: trx_commit_for_mysql (trx0trx.c:1629) ==27198== by 0x82E7D78: innobase_commit_low(trx_struct*) (ha_innodb.cc:1545) ==27198== by 0x82E800D: innobase_commit(THD*, bool) (ha_innodb.cc:1675) ==27198== by 0x82D89ED: ha_commit_one_phase(THD*, bool) (handler.cc:753) ==27198== by 0x82D9058: ha_commit_trans(THD*, bool) (handler.cc:723) ==27198== by 0x82D92D1: ha_autocommit_or_rollback(THD*, int) (handler.cc:870) ==27198== by 0x8274BBB: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:930) ==27198== by 0x8204CE2: mysql_execute_command(THD*) (sql_parse.cc:3666) ==27198== by 0x8209CA7: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:6266) ==27198== by 0x820A6D0: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1938) ==27198== by 0x820B9E1: do_command(THD*) (sql_parse.cc:1628) ==27198== by 0x820BEA7: handle_one_connection (sql_parse.cc:1234) ==27198== by 0x45FBD3: start_thread (in /lib/libpthread-2.3.6.so) ==27198== ==27198== Conditional jump or move depends on uninitialised value(s) ==27198== at 0x83DE5CD: trx_sys_update_mysql_binlog_offset (trx0sys.c:616) ==27198== by 0x83E13B4: trx_commit_off_kernel (trx0trx.c:799) ==27198== by 0x83E27E5: trx_commit_for_mysql (trx0trx.c:1629) ==27198== by 0x82E7D78: innobase_commit_low(trx_struct*) (ha_innodb.cc:1545) ==27198== by 0x82E800D: innobase_commit(THD*, bool) (ha_innodb.cc:1675) ==27198== by 0x82D89ED: ha_commit_one_phase(THD*, bool) (handler.cc:753) ==27198== by 0x82D9058: ha_commit_trans(THD*, bool) (handler.cc:723) ==27198== by 0x82D92D1: ha_autocommit_or_rollback(THD*, int) (handler.cc:870) ==27198== by 0x8274BBB: mysql_insert(THD*, TABLE_LIST*, List&, List >&, List&, List&, enum_duplicates, bool) (sql_insert.cc:930) ==27198== by 0x8204CE2: mysql_execute_command(THD*) (sql_parse.cc:3666) ==27198== by 0x8209CA7: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:6266) ==27198== by 0x820A6D0: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1938) ==27198== by 0x820B9E1: do_command(THD*) (sql_parse.cc:1628) ==27198== by 0x820BEA7: handle_one_connection (sql_parse.cc:1234) ==27198== by 0x45FBD3: start_thread (in /lib/libpthread-2.3.6.so) ==27198== by 0x3B74FD: clone (in /lib/libc-2.3.6.so) ==27198== ==27198== Conditional jump or move depends on uninitialised value(s) ==27198== at 0x82813D1: compare_record(st_table*, unsigned long long) (sql_update.cc:32) ==27198== by 0x8282B22: mysql_update(THD*, TABLE_LIST*, List&, List&, Item*, unsigned, st_order*, unsigned long long, enum_duplicates, bool) (sql_update.cc:472) ==27198== by 0x8204978: mysql_execute_command(THD*) (sql_parse.cc:3589) ==27198== by 0x8209CA7: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:6266) ==27198== by 0x820A6D0: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1938) ==27198== by 0x820B9E1: do_command(THD*) (sql_parse.cc:1628) ==27198== by 0x820BEA7: handle_one_connection (sql_parse.cc:1234) ==27198== by 0x45FBD3: start_thread (in /lib/libpthread-2.3.6.so) ==27198== by 0x3B74FD: clone (in /lib/libc-2.3.6.so) ==27198== ==27198== Use of uninitialised value of size 4 ==27198== at 0x82813D1: compare_record(st_table*, unsigned long long) (sql_update.cc:32) ==27198== by 0x8282B22: mysql_update(THD*, TABLE_LIST*, List&, List&, Item*, unsigned, st_order*, unsigned long long, enum_duplicates, bool) (sql_update.cc:472) ==27198== by 0x8204978: mysql_execute_command(THD*) (sql_parse.cc:3589) ==27198== by 0x8209CA7: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:6266) ==27198== by 0x820A6D0: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1938) ==27198== by 0x820B9E1: do_command(THD*) (sql_parse.cc:1628) ==27198== by 0x820BEA7: handle_one_connection (sql_parse.cc:1234) ==27198== by 0x45FBD3: start_thread (in /lib/libpthread-2.3.6.so) ==27198== by 0x3B74FD: clone (in /lib/libc-2.3.6.so) ==27198== ==27198== Conditional jump or move depends on uninitialised value(s) ==27198== at 0x81D0D62: key_cmp(st_key_part_info*, char const*, unsigned) (key.cc:411) ==27198== by 0x82DCD83: handler::compare_key(st_key_range*) (handler.cc:2736) ==27198== by 0x82DD08D: handler::read_range_first(st_key_range const*, st_key_range const*, bool, bool) (handler.cc:2675) ==27198== by 0x82DCAF9: handler::read_multi_range_first(st_key_multi_range**, st_key_multi_range*, unsigned, bool, st_handler_buffer*) (handler.cc:2542) ==27198== by 0x82C7C21: QUICK_RANGE_SELECT::get_next() (opt_range.cc:6991) ==27198== by 0x82C8D10: QUICK_ROR_INTERSECT_SELECT::get_next() (opt_range.cc:6732) ==27198== by 0x82D34FB: rr_quick(st_read_record*) (records.cc:261) ==27198== by 0x825C5A7: join_init_read_record(st_join_table*) (sql_select.cc:11324) ==27198== by 0x82592DE: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:10660) ==27198== by 0x8259697: do_select(JOIN*, List*, st_table*, Procedure*) (sql_select.cc:10424) ==27198== by 0x826DCA8: JOIN::exec() (sql_select.cc:2096) ==27198== by 0x826E081: _Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex (sql_select.cc:2275) ==27198== by 0x826E343: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:257) ==27198== by 0x82025AD: mysql_execute_command(THD*) (sql_parse.cc:2789) ==27198== by 0x8209CA7: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:6266) ==27198== by 0x820A6D0: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1938) ==27198== ==27198== Conditional jump or move depends on uninitialised value(s) ==27198== at 0x81889B3: Item_func_isnull::val_int() (item_cmpfunc.cc:4128) ==27198== by 0x81422E3: Item::val_bool() (item.cc:175) ==27198== by 0x8188633: Item_cond_and::val_int() (item_cmpfunc.cc:4047) ==27198== by 0x8258DA1: evaluate_join_record(JOIN*, st_join_table*, int, char*) (sql_select.cc:10707) ==27198== by 0x82592F8: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:10661) ==27198== by 0x8259697: do_select(JOIN*, List*, st_table*, Procedure*) (sql_select.cc:10424) ==27198== by 0x826DCA8: JOIN::exec() (sql_select.cc:2096) ==27198== by 0x826E081: _Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex (sql_select.cc:2275) ==27198== by 0x826E343: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:257) ==27198== by 0x82025AD: mysql_execute_command(THD*) (sql_parse.cc:2789) ==27198== by 0x8209CA7: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:6266) ==27198== by 0x820A6D0: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1938) ==27198== by 0x820B9E1: do_command(THD*) (sql_parse.cc:1628) ==27198== by 0x820BEA7: handle_one_connection (sql_parse.cc:1234) ==27198== by 0x45FBD3: start_thread (in /lib/libpthread-2.3.6.so) ==27198== by 0x3B74FD: clone (in /lib/libc-2.3.6.so) ==27198== ==27198== Invalid read of size 1 ==27198== at 0x81E22DF: String::append(char const*, unsigned) (sql_string.cc:459) ==27198== by 0x8345B8C: mysql_create_view(THD*, TABLE_LIST*, enum_view_create_mode) (sql_view.cc:652) ==27198== by 0x8208FFB: mysql_execute_command(THD*) (sql_parse.cc:5054) ==27198== by 0x8209CA7: mysql_parse(THD*, char const*, unsigned, char const**) (sql_parse.cc:6266) ==27198== by 0x820A6D0: dispatch_command(enum_server_command, THD*, char*, unsigned) (sql_parse.cc:1938) ==27198== by 0x820B9E1: do_command(THD*) (sql_parse.cc:1628) ==27198== by 0x820BEA7: handle_one_connection (sql_parse.cc:1234) ==27198== by 0x45FBD3: start_thread (in /lib/libpthread-2.3.6.so) ==27198== by 0x3B74FD: clone (in /lib/libc-2.3.6.so) ==27198== Address 0x215BBBA3 is not stack'd, malloc'd or (recently) free'd 081029 11:33:41 [Note] /users/ssmirnova/src/mysql-5.0/sql/mysqld: Normal shutdown 081029 11:33:41 InnoDB: Starting shutdown... 081029 11:33:44 InnoDB: Shutdown completed; log sequence number 0 2354445 081029 11:33:45 [Note] /users/ssmirnova/src/mysql-5.0/sql/mysqld: Shutdown complete ==27198== ==27198== ERROR SUMMARY: 1609 errors from 12 contexts (suppressed: 21 from 1) ==27198== malloc/free: in use at exit: 1388 bytes in 11 blocks. ==27198== malloc/free: 33653 allocs, 33642 frees, 38196742 bytes allocated. ==27198== For counts of detected errors, rerun with: -v ==27198== searching for pointers to 11 not-freed blocks. ==27198== checked 75531628 bytes. ==27198== ==27198== LEAK SUMMARY: ==27198== definitely lost: 0 bytes in 0 blocks. ==27198== possibly lost: 0 bytes in 0 blocks. ==27198== still reachable: 0 bytes in 0 blocks. ==27198== suppressed: 1388 bytes in 11 blocks.