Version: '5.6.2-m5-valgrind-max-debug' socket: 'sock' port: 3306 Source distribution 110131 14:13:33 [ERROR] ./bin/mysqld: Table './test/tt' is marked as crashed and should be repaired 110131 14:13:33 [Warning] Checking table: './test/tt' 110131 14:24:33 [ERROR] ./bin/mysqld: Sort aborted 110131 14:29:22 [ERROR] ./bin/mysqld: Sort aborted 110131 14:35:27 [ERROR] ./bin/mysqld: Sort aborted 110131 14:39:21 [ERROR] ./bin/mysqld: Sort aborted 110131 14:42:35 [ERROR] ./bin/mysqld: Sort aborted 110131 14:45:56 [ERROR] ./bin/mysqld: Sort aborted 110131 14:47:54 [ERROR] ./bin/mysqld: Sort aborted 110131 14:48:18 [ERROR] ./bin/mysqld: Sort aborted 110131 14:49:13 [ERROR] ./bin/mysqld: Sort aborted 110131 14:51:21 [ERROR] ./bin/mysqld: Sort aborted 110131 14:51:25 [ERROR] ./bin/mysqld: Sort aborted 110131 14:57:59 [ERROR] ./bin/mysqld: Sort aborted 110131 15:00:16 [ERROR] ./bin/mysqld: Sort aborted ==16731== Thread 20: Conditional jump or move depends on uninitialised value(s) at: uses_index_fields_only (sql_select.cc:9960) by: uses_index_fields_only (sql_select.cc:9962) by: make_cond_for_index (sql_select.cc:10100) by: make_cond_for_index (sql_select.cc:10054) by: push_index_cond (sql_select.cc:10217) by: make_join_readinfo (sql_select.cc:11161) by: JOIN::optimize (sql_select.cc:2301) by: mysql_select (sql_select.cc:3570) by: mysql_explain_union (sql_select.cc:23205) by: execute_sqlcom_select (sql_parse.cc:4487) by: mysql_execute_command (sql_parse.cc:2096) by: mysql_parse (sql_parse.cc:5550) by: dispatch_command(sql_parse.cc:1078) by: do_command (sql_parse.cc:815) by: do_handle_one_connection (sql_connect.cc:748) by: handle_one_connection (sql_connect.cc:684) by: start_thread (pthread_create.c:301) Uninitialised value was created by a heap allocation at: malloc (vg_replace_malloc.c:195) by: my_malloc (my_malloc.c:38) by: alloc_root (my_alloc.c:166) by: Item::operator new (item.h:518) by: MYSQLparse (sql_yacc.yy:8460) by: parse_sql (sql_parse.cc:7275) by: mysql_parse (sql_parse.cc:5505) by: dispatch_command (sql_parse.cc:1078) by: do_command (sql_parse.cc:815) by: do_handle_one_connection (sql_connect.cc:748) by: handle_one_connection (sql_connect.cc:684) by: start_thread (pthread_create.c:301) ==16731== ==16731== ---- Attach to debugger ? --- [Return/N/n/Y/y/C/c] ---- (gdb) list 9955 { 9956 /* This is a function, apply condition recursively to arguments */ 9957 Item_func *item_func= (Item_func*)item; 9958 Item **child; 9959 Item **item_end= (item_func->arguments()) + item_func->argument_count(); 9960 for (child= item_func->arguments(); child != item_end; child++) 9961 { 9962 if (!uses_index_fields_only(*child, tbl, keyno, other_tbls_ok)) 9963 return FALSE; 9964 } (gdb) p item_end $1 = (Item **) 0x1a02e310 (gdb) p *item_end $2 = (Item *) 0x19fd9c50 (gdb) p **item_end $3 = { _vptr.Item = 0x0, is_expensive_cache = 2 '\002', rsize = 0, str_value = { Ptr = 0x2e
, str_length = 0, Alloced_length = 0, alloced = false, str_charset = 0x1172fe0 }, name = 0x0, orig_name = 0x5a0
, next = 0x60, max_length = 0, name_length = 0, marker = 0 '\000', decimals = 0 '\000', maybe_null = 1 '\001', null_value = 0 '\000', unsigned_flag = 0 '\000', with_sum_func = 0 '\000', fixed = 0 '\000', is_autogenerated_name = 1 '\001', collation = warning: can't find linker symbol for virtual table for `DTCollation' value { collation = 0x12b5fe0, derivation = 436049680, repertoire = 0 }, with_subselect = 0 '\000', cmp_context = 21 } (gdb) p child $4 = (Item **) 0x1a02e310 (gdb) p *child $5 = (Item *) 0x19fd9c50 (gdb) p **child $6 = { _vptr.Item = 0x0, is_expensive_cache = 2 '\002', rsize = 0, str_value = { Ptr = 0x2e
, str_length = 0, Alloced_length = 0, alloced = false, str_charset = 0x1172fe0 }, name = 0x0, orig_name = 0x5a0
, next = 0x60, max_length = 0, name_length = 0, marker = 0 '\000', decimals = 0 '\000', maybe_null = 1 '\001', null_value = 0 '\000', unsigned_flag = 0 '\000', with_sum_func = 0 '\000', fixed = 0 '\000', is_autogenerated_name = 1 '\001', collation = warning: can't find linker symbol for virtual table for `DTCollation' value { collation = 0x12b5fe0, derivation = 436049680, repertoire = 0 }, with_subselect = 0 '\000', cmp_context = 21 } (gdb) (gdb) bt #0 0x0000000000638379 in uses_index_fields_only (item=0x1a02e290, tbl=0x16848200, keyno=14, other_tbls_ok=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:9960 #1 0x0000000000638356 in uses_index_fields_only (item=0x1a02e410, tbl=0x16848200, keyno=14, other_tbls_ok=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:9962 #2 0x0000000000638891 in make_cond_for_index (cond=0x1a02e410, table=0x16848200, keyno=14, other_tbls_ok=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:10100 #3 0x000000000063860e in make_cond_for_index (cond=0x1a598e30, table=0x16848200, keyno=14, other_tbls_ok=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:10054 #4 0x0000000000638cee in push_index_cond (tab=0x16760828, keyno=14, other_tbls_ok=true) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:10217 #5 0x000000000063acdf in make_join_readinfo (join=0x1a3284a0, options=4, no_jbuf_after=1) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:11161 #6 0x00000000006243dc in JOIN::optimize (this=0x1a3284a0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:2301 #7 0x0000000000628f64 in mysql_select (thd=0x15cfeeb0, rref_pointer_array=0x15d01428, tables=0x1a206ab0, wild_num=0, fields=..., conds=0x1a02e5e0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2148797188, result=0x168db970, unit=0x15d00bc8, select_lex=0x15d01210) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:3570 #8 0x00000000006581ea in mysql_explain_union (thd=0x15cfeeb0, unit=0x15d00bc8, result=0x168db970) at /home/sbester/build/bzr/mysql-trunk/sql/sql_select.cc:23205 #9 0x0000000000601a84 in execute_sqlcom_select (thd=0x15cfeeb0, all_tables=0x1a206ab0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:4487 #10 0x00000000005fa8a6 in mysql_execute_command (thd=0x15cfeeb0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:2096 #11 0x0000000000603d9f in mysql_parse (thd=0x15cfeeb0, rawbuf=0x19e99b20 "/* */ \n\nexplain extended \n", ' ' , "(select `t78_1`.`col999` from t78 as `t78_1` where `t78_1`.`col1000` = \"3\"\n", ' ' , "and `t78_1`.`col1003` <=> sysdate()\n", ' ' , "for update )", length=188, parser_state=0x1b0f3610) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:5550 #12 0x00000000005f8166 in dispatch_command (command=COM_QUERY, thd=0x15cfeeb0, packet=0x15d02371 "", packet_length=188) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:1078 #13 0x00000000005f746e in do_command (thd=0x15cfeeb0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:815 #14 0x00000000006d73ed in do_handle_one_connection (thd_arg=0x15cfeeb0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:748 #15 0x00000000006d6f7e in handle_one_connection (arg=0x15cfeeb0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:684 #16 0x00000030e1807761 in start_thread (arg=0x1b0f4710) at pthread_create.c:301 #17 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 (gdb) (select `t78_1`.`col999` from t78 as `t78_1` where `t78_1`.`col1000` = "3" and `t78_1`.`col1003` <=> sysdate()) ;