sources from bzr branch lp:mysql-server/5.0 [sbester@box1 5.0]$ bzr revno 2778 build script : make clean aclocal; autoheader libtoolize --automake --force automake --force --add-missing; autoconf (cd innobase; aclocal; autoheader; autoconf; automake) (cd bdb/dist; sh s_all) CC=gcc CFLAGS=" -O1 -g " CXX=gcc CXXFLAGS=" -O1 -g -felide-constructors -fno-exceptions -fno-rtti" ./configure \ --with-debug \ --with-extra-charsets=all \ --with-experimental-collations \ --with-example-storage-engine \ --with-archive-storage-engine \ --with-csv-storage-engine \ --with-blackhole-storage-engine \ --with-federated-storage-engine \ --with-ssl \ --enable-thread-safe-client \ --enable-assembler \ --with-isam \ --enable-shared \ --with-vio \ --with-innodb \ --with-comment \ --with-big-tables \ --enable-local-infile make make bin-dist [sbester@box1 5.0]$ tar zxvf mysql-5.0.82-linux-i686.tar.gz [sbester@box1 5.0]$ cd mysql-5.0.82-linux-i686 [sbester@box1 mysql-5.0.82-linux-i686]$ ./scripts/mysql_install_db Installing MySQL system tables... OK Filling help tables... OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h box1.hti.co.za password 'new-password' Alternatively you can run: ./bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd mysql-test ; perl mysql-test-run.pl Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://shop.mysql.com [sbester@box1 mysql-5.0.82-linux-i686]$ running mysqld with clean datadir: [sbester@box1 5.0]$ valgrind --tool=memcheck --leak-check=full --db-attach=yes --db-command="/home/sbester/gdb-6.8/gdb/gdb --pid=%p" -v --show-reachable=yes ./sql/mysqld --no-defaults --basedir=/home/sbester/mysql/5.0/mysql-5.0.82-linux-i686 --datadir=/home/sbester/mysql/5.0/mysql-5.0.82-linux-i686/data --skip-grant-tables --skip-name-resolve --server-id=2 --port=3310 --socket=sock.sock ==20485== Memcheck, a memory error detector. ==20485== Copyright (C) 2002-2006, and GNU GPL'd, by Julian Seward et al. ==20485== Using LibVEX rev 1658, a library for dynamic binary translation. ==20485== Copyright (C) 2004-2006, and GNU GPL'd, by OpenWorks LLP. ==20485== Using valgrind-3.2.1, a dynamic binary instrumentation framework. ==20485== Copyright (C) 2000-2006, and GNU GPL'd, by Julian Seward et al. ==20485== --20485-- Command line --20485-- ./sql/mysqld --20485-- --no-defaults --20485-- --basedir=/home/sbester/mysql/5.0/mysql-5.0.82-linux-i686 --20485-- --datadir=/home/sbester/mysql/5.0/mysql-5.0.82-linux-i686/data --20485-- --skip-grant-tables --20485-- --skip-name-resolve --20485-- --server-id=2 --20485-- --port=3310 --20485-- --socket=sock.sock --20485-- Startup, with flags: --20485-- --tool=memcheck --20485-- --leak-check=full --20485-- --db-attach=yes --20485-- --db-command=/home/sbester/gdb-6.8/gdb/gdb --pid=%p --20485-- -v --20485-- --show-reachable=yes --20485-- Contents of /proc/version: --20485-- 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 --20485-- Arch and hwcaps: X86, x86-sse1-sse2 --20485-- Valgrind library directory: /usr/lib/valgrind --20485-- Reading syms from /lib/ld-2.5.so (0x2C3000) --20485-- Reading syms from /home/sbester/build/bzr/5.0/sql/mysqld (0x8048000) --20485-- Reading syms from /usr/lib/valgrind/x86-linux/memcheck (0x38000000) --20485-- object doesn't have a dynamic symbol table --20485-- Reading suppressions file: /usr/lib/valgrind/default.supp --20485-- REDIR: 0x2D80F0 (index) redirected to 0x38027D0F (vgPlain_x86_linux_REDIR_FOR_index) --20485-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_core.so (0x4001000) --20485-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_memcheck.so (0x4003000) ==20485== WARNING: new redirection conflicts with existing -- ignoring it --20485-- new: 0x002D80F0 (index ) R-> 0x040060C0 index --20485-- REDIR: 0x2D8290 (strlen) redirected to 0x4006290 (strlen) --20485-- Reading syms from /lib/librt-2.5.so (0x4C3000) --20485-- Reading syms from /usr/lib/libz.so.1.2.3 (0x12A000) --20485-- object doesn't have a symbol table --20485-- Reading syms from /lib/libdl-2.5.so (0xDD5000) --20485-- Reading syms from /lib/libpthread-2.5.so (0x484000) --20485-- Reading syms from /lib/libcrypt-2.5.so (0x50D8000) --20485-- Reading syms from /lib/libnsl-2.5.so (0x2E0000) --20485-- Reading syms from /usr/lib/libstdc++.so.6.0.8 (0x4FC6000) --20485-- object doesn't have a symbol table --20485-- Reading syms from /lib/libm-2.5.so (0x4019000) --20485-- Reading syms from /lib/libgcc_s-4.1.1-20061011.so.1 (0x4ECE000) --20485-- object doesn't have a symbol table --20485-- Reading syms from /lib/libc-2.5.so (0x309000) --20485-- REDIR: 0x3764E0 (memset) redirected to 0x4006580 (memset) --20485-- REDIR: 0x3769D0 (memcpy) redirected to 0x4006C60 (memcpy) --20485-- REDIR: 0x375640 (rindex) redirected to 0x4005FA0 (rindex) --20485-- REDIR: 0x3752A0 (strlen) redirected to 0x4006270 (strlen) --20485-- REDIR: 0x3709B0 (calloc) redirected to 0x40046A8 (calloc) --20485-- REDIR: 0x370CB0 (malloc) redirected to 0x400537B (malloc) --20485-- REDIR: 0x375490 (strncmp) redirected to 0x40062D0 (strncmp) --20485-- REDIR: 0x374A20 (strcat) redirected to 0x4006660 (strcat) --20485-- REDIR: 0x3724C0 (free) redirected to 0x4004F95 (free) --20485-- REDIR: 0x374DB0 (strcpy) redirected to 0x40069F0 (strcpy) --20485-- REDIR: 0x374D40 (strcmp) redirected to 0x4006340 (strcmp) --20485-- REDIR: 0x374BD0 (index) redirected to 0x4006090 (index) --20485-- REDIR: 0x3766D0 (stpcpy) redirected to 0x4006910 (stpcpy) --20485-- REDIR: 0x507BD00 (operator new(unsigned)) redirected to 0x4005B19 (operator new(unsigned)) InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 090522 10:23:37 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 090522 10:23:38 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... 090522 10:23:38 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... ==20485== Conditional jump or move depends on uninitialised value(s) ==20485== at 0x8373758: trx_sys_create_doublewrite_buf (trx0sys.c:198) ==20485== by 0x83006D2: innobase_start_or_create_for_mysql (srv0start.c:1560) ==20485== by 0x82729A9: innobase_init() (ha_innodb.cc:1440) ==20485== by 0x82668DD: ha_init() (handler.cc:482) ==20485== by 0x818B917: init_server_components() (mysqld.cc:3426) ==20485== by 0x818F467: main (mysqld.cc:3802) ==20485== ==20485== ---- Attach to debugger ? --- [Return/N/n/Y/y/C/c] ---- c InnoDB: Doublewrite buffer not found: creating new ==20485== ==20485== Thread 5: ==20485== Syscall param pwrite64(buf) points to uninitialised byte(s) ==20485== at 0x490AA6: pwrite64 (in /lib/libpthread-2.5.so) ==20485== by 0x83DBD2C: os_file_write (os0file.c:2031) ==20485== by 0x83DD81E: os_aio_simulated_handle (os0file.c:4015) ==20485== by 0x83ABCDF: fil_aio_wait (fil0fil.c:4131) ==20485== by 0x82FE538: io_handler_thread (srv0start.c:446) ==20485== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==20485== by 0x3D606D: clone (in /lib/libc-2.5.so) ==20485== Address 0xA274000 is 8,152 bytes inside a block of size 753,680 alloc'd ==20485== at 0x4005400: malloc (vg_replace_malloc.c:149) ==20485== by 0x83D8DA5: ut_malloc_low (ut0mem.c:81) ==20485== by 0x83D8F08: ut_malloc (ut0mem.c:177) ==20485== by 0x83DD614: os_aio_simulated_handle (os0file.c:3965) ==20485== by 0x83ABCDF: fil_aio_wait (fil0fil.c:4131) ==20485== by 0x82FE538: io_handler_thread (srv0start.c:446) ==20485== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==20485== by 0x3D606D: clone (in /lib/libc-2.5.so) InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 090522 10:23:42 InnoDB: Started; log sequence number 0 0 --20485-- REDIR: 0x377280 (rawmemchr) redirected to 0x4006640 (rawmemchr) 090522 10:23:43 [Note] ./sql/mysqld: ready for connections. Version: '5.0.82-debug' socket: 'sock.sock' port: 3310 yes ==20485== ==20485== Thread 8: ==20485== Syscall param pwrite64(buf) points to uninitialised byte(s) ==20485== at 0x490AA6: pwrite64 (in /lib/libpthread-2.5.so) ==20485== by 0x83DBD2C: os_file_write (os0file.c:2031) ==20485== by 0x83DC15A: os_aio (os0file.c:3438) ==20485== by 0x83AC23C: fil_io (fil0fil.c:4020) ==20485== by 0x8385839: buf_flush_buffered_writes (buf0flu.c:296) ==20485== by 0x8387A9F: buf_flush_batch (buf0flu.c:945) ==20485== by 0x82FE0BB: srv_master_thread (srv0srv.c:2513) ==20485== by 0x4893DA: start_thread (in /lib/libpthread-2.5.so) ==20485== by 0x3D606D: clone (in /lib/libc-2.5.so) ==20485== Address 0xA478000 is 4,056 bytes inside a block of size 2,113,552 alloc'd ==20485== at 0x4005400: malloc (vg_replace_malloc.c:149) ==20485== by 0x83D8DA5: ut_malloc_low (ut0mem.c:81) ==20485== by 0x83D8F08: ut_malloc (ut0mem.c:177) ==20485== by 0x8373094: trx_doublewrite_init (trx0sys.c:115) ==20485== by 0x8373764: trx_sys_create_doublewrite_buf (trx0sys.c:203) ==20485== by 0x83006D2: innobase_start_or_create_for_mysql (srv0start.c:1560) ==20485== by 0x82729A9: innobase_init() (ha_innodb.cc:1440) ==20485== by 0x82668DD: ha_init() (handler.cc:482) ==20485== by 0x818B917: init_server_components() (mysqld.cc:3426) ==20485== by 0x818F467: main (mysqld.cc:3802) --20485-- REDIR: 0x3726B0 (realloc) redirected to 0x400542A (realloc) Now login and create that table: -------------------------------- [sbester@box1 ~]$ mysql -uroot -A -P3310 test -h127.0.0.1 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.82-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create table t1(id int not null auto_increment primary key)engine=innodb; Query OK, 0 rows affected (0.40 sec) mysql> exit Bye [sbester@box1 ~]$ mysqladmin shutdown -P3310 -h127.0.0.1 090522 10:24:44 [Note] ./sql/mysqld: Normal shutdown --20485-- REDIR: 0x507A850 (operator delete(void*)) redirected to 0x4004CAC (operator delete(void*)) 090522 10:24:44 InnoDB: Starting shutdown... 090522 10:24:46 InnoDB: Shutdown completed; log sequence number 0 45206 090522 10:24:46 [Note] ./sql/mysqld: Shutdown complete Startup again under valgrind: ---------------------------------- [sbester@box1 5.0]$ valgrind --tool=memcheck --leak-check=full --db-attach=yes --db-command="/home/sbester/gdb-6.8/gdb/gdb --pid=%p" -v --show-reachable=yes ./sql/mysqld --no-defaults --basedir=/home/sbester/mysql/5.0/mysql-5.0.82-linux-i686 --datadir=/home/sbester/mysql/5.0/mysql-5.0.82-linux-i686/data --skip-grant-tables --skip-name-resolve --server-id=2 --port=3310 --socket=sock.sock ==20523== Memcheck, a memory error detector. ==20523== Copyright (C) 2002-2006, and GNU GPL'd, by Julian Seward et al. ==20523== Using LibVEX rev 1658, a library for dynamic binary translation. ==20523== Copyright (C) 2004-2006, and GNU GPL'd, by OpenWorks LLP. ==20523== Using valgrind-3.2.1, a dynamic binary instrumentation framework. ==20523== Copyright (C) 2000-2006, and GNU GPL'd, by Julian Seward et al. ==20523== --20523-- Command line --20523-- ./sql/mysqld --20523-- --no-defaults --20523-- --basedir=/home/sbester/mysql/5.0/mysql-5.0.82-linux-i686 --20523-- --datadir=/home/sbester/mysql/5.0/mysql-5.0.82-linux-i686/data --20523-- --skip-grant-tables --20523-- --skip-name-resolve --20523-- --server-id=2 --20523-- --port=3310 --20523-- --socket=sock.sock --20523-- Startup, with flags: --20523-- --tool=memcheck --20523-- --leak-check=full --20523-- --db-attach=yes --20523-- --db-command=/home/sbester/gdb-6.8/gdb/gdb --pid=%p --20523-- -v --20523-- --show-reachable=yes --20523-- Contents of /proc/version: --20523-- 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 --20523-- Arch and hwcaps: X86, x86-sse1-sse2 --20523-- Valgrind library directory: /usr/lib/valgrind --20523-- Reading syms from /lib/ld-2.5.so (0x2C3000) --20523-- Reading syms from /home/sbester/build/bzr/5.0/sql/mysqld (0x8048000) --20523-- Reading syms from /usr/lib/valgrind/x86-linux/memcheck (0x38000000) --20523-- object doesn't have a dynamic symbol table --20523-- Reading suppressions file: /usr/lib/valgrind/default.supp --20523-- REDIR: 0x2D80F0 (index) redirected to 0x38027D0F (vgPlain_x86_linux_REDIR_FOR_index) --20523-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_core.so (0x4001000) --20523-- Reading syms from /usr/lib/valgrind/x86-linux/vgpreload_memcheck.so (0x4003000) ==20523== WARNING: new redirection conflicts with existing -- ignoring it --20523-- new: 0x002D80F0 (index ) R-> 0x040060C0 index --20523-- REDIR: 0x2D8290 (strlen) redirected to 0x4006290 (strlen) --20523-- Reading syms from /lib/librt-2.5.so (0x4C3000) --20523-- Reading syms from /usr/lib/libz.so.1.2.3 (0x12A000) --20523-- object doesn't have a symbol table --20523-- Reading syms from /lib/libdl-2.5.so (0xDD5000) --20523-- Reading syms from /lib/libpthread-2.5.so (0x484000) --20523-- Reading syms from /lib/libcrypt-2.5.so (0x50D8000) --20523-- Reading syms from /lib/libnsl-2.5.so (0x2E0000) --20523-- Reading syms from /usr/lib/libstdc++.so.6.0.8 (0x4FC6000) --20523-- object doesn't have a symbol table --20523-- Reading syms from /lib/libm-2.5.so (0x4019000) --20523-- Reading syms from /lib/libgcc_s-4.1.1-20061011.so.1 (0x4ECE000) --20523-- object doesn't have a symbol table --20523-- Reading syms from /lib/libc-2.5.so (0x309000) --20523-- REDIR: 0x3764E0 (memset) redirected to 0x4006580 (memset) --20523-- REDIR: 0x3769D0 (memcpy) redirected to 0x4006C60 (memcpy) --20523-- REDIR: 0x375640 (rindex) redirected to 0x4005FA0 (rindex) --20523-- REDIR: 0x3752A0 (strlen) redirected to 0x4006270 (strlen) --20523-- REDIR: 0x3709B0 (calloc) redirected to 0x40046A8 (calloc) --20523-- REDIR: 0x370CB0 (malloc) redirected to 0x400537B (malloc) --20523-- REDIR: 0x375490 (strncmp) redirected to 0x40062D0 (strncmp) --20523-- REDIR: 0x374A20 (strcat) redirected to 0x4006660 (strcat) --20523-- REDIR: 0x3724C0 (free) redirected to 0x4004F95 (free) --20523-- REDIR: 0x374DB0 (strcpy) redirected to 0x40069F0 (strcpy) --20523-- REDIR: 0x374D40 (strcmp) redirected to 0x4006340 (strcmp) --20523-- REDIR: 0x374BD0 (index) redirected to 0x4006090 (index) --20523-- REDIR: 0x3766D0 (stpcpy) redirected to 0x4006910 (stpcpy) --20523-- REDIR: 0x507BD00 (operator new(unsigned)) redirected to 0x4005B19 (operator new(unsigned)) 090522 10:25:04 InnoDB: Started; log sequence number 0 45206 --20523-- REDIR: 0x377280 (rawmemchr) redirected to 0x4006640 (rawmemchr) 090522 10:25:04 [Note] ./sql/mysqld: ready for connections. Version: '5.0.82-debug' socket: 'sock.sock' port: 3310 yes --20523-- REDIR: 0x3726B0 (realloc) redirected to 0x400542A (realloc) --20523-- REDIR: 0x376470 (memmove) redirected to 0x40065B0 (memmove) ==20523== Thread 10: ==20523== Conditional jump or move depends on uninitialised value(s) ==20523== at 0x8271716: build_template(row_prebuilt_struct*, THD*, st_table*, unsigned long) (ha_innodb.cc:2953) ==20523== by 0x8273E03: ha_innobase::change_active_index(unsigned) (ha_innodb.cc:4000) ==20523== by 0x8273F24: ha_innobase::index_init(unsigned) (ha_innodb.cc:3693) ==20523== by 0x827482F: ha_innobase::innobase_read_and_init_auto_inc(long long*) (ha_innodb.cc:6888) ==20523== by 0x82765E9: ha_innobase::info(unsigned) (ha_innodb.cc:5557) ==20523== by 0x829061D: get_schema_tables_record(THD*, TABLE_LIST*, st_table*, bool, char const*, char const*) (sql_show.cc:2521) ==20523== by 0x829342C: get_all_tables(THD*, TABLE_LIST*, Item*) (sql_show.cc:2391) ==20523== by 0x828DBD1: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:4119) ==20523== by 0x8202BD3: JOIN::exec() (sql_select.cc:1704) ==20523== by 0x8205171: mysql_select(THD*, Item***, TABLE_LIST*, unsigned, List&, Item*, unsigned, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:2292) ==20523== by 0x8205667: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:256) ==20523== by 0x81AB1F4: mysql_execute_command(THD*) (sql_parse.cc:2836) ==20523== ==20523== ---- Attach to debugger ? --- [Return/N/n/Y/y/C/c] ---- c ==20523== ==20523== Conditional jump or move depends on uninitialised value(s) ==20523== at 0x8271746: build_template(row_prebuilt_struct*, THD*, st_table*, unsigned long) (ha_innodb.cc:2971) ==20523== by 0x8273E03: ha_innobase::change_active_index(unsigned) (ha_innodb.cc:4000) ==20523== by 0x8273F24: ha_innobase::index_init(unsigned) (ha_innodb.cc:3693) ==20523== by 0x827482F: ha_innobase::innobase_read_and_init_auto_inc(long long*) (ha_innodb.cc:6888) ==20523== by 0x82765E9: ha_innobase::info(unsigned) (ha_innodb.cc:5557) ==20523== by 0x829061D: get_schema_tables_record(THD*, TABLE_LIST*, st_table*, bool, char const*, char const*) (sql_show.cc:2521) ==20523== by 0x829342C: get_all_tables(THD*, TABLE_LIST*, Item*) (sql_show.cc:2391) ==20523== by 0x828DBD1: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:4119) ==20523== by 0x8202BD3: JOIN::exec() (sql_select.cc:1704) ==20523== by 0x8205171: mysql_select(THD*, Item***, TABLE_LIST*, unsigned, List&, Item*, unsigned, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) (sql_select.cc:2292) ==20523== by 0x8205667: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:256) ==20523== by 0x81AB1F4: mysql_execute_command(THD*) (sql_parse.cc:2836) [sbester@box1 ~]$ mysql -uroot -A -P3310 test -h127.0.0.1 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.82-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show table status; +------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------+ | t1 | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | 1 | 2009-05-22 10:24:31 | NULL | NULL | latin1_swedish_ci | NULL | NULL | InnoDB free: 4096 kB | +------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------+ 1 row in set (7.14 sec) ha_innodb.cc:2953 is this: if (prebuilt->hint_need_to_fetch_extra_cols == ROW_RETRIEVE_ALL_COLS) { ha_innodb.cc:2971 is this: } else if (prebuilt->hint_need_to_fetch_extra_cols == ROW_RETRIEVE_PRIMARY_KEY) {