060729 10:20:00 [Note] /home/miguel/dbs/5.1/libexec/mysqld: ready for connections. Version: '5.1.12-beta-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution [New Thread 1118686128 (LWP 5726)] 060729 10:20:00 [Note] SCHEDULER: Manager thread booting 060729 10:20:00 [Note] SCHEDULER: Loaded 0 events 060729 10:20:00 [Note] SCHEDULER: Suspending operations [New Thread 1118886832 (LWP 5753)] mysqld: ../include/my_bitmap.h:111: void bitmap_set_bit(MY_BITMAP*, uint): Assertion `bit < (map)->n_bits' failed. Program received signal SIGABRT, Aborted. [Switching to Thread 1118886832 (LWP 5753)] 0xffffe410 in __kernel_vsyscall () (gdb) bt full #0 0xffffe410 in __kernel_vsyscall () No symbol table info available. #1 0x400ea541 in raise () from /lib/tls/libc.so.6 No symbol table info available. #2 0x400ebdbb in abort () from /lib/tls/libc.so.6 No symbol table info available. #3 0x400e3925 in __assert_fail () from /lib/tls/libc.so.6 No symbol table info available. #4 0x0831da40 in bitmap_set_bit (map=0x930ebac, bit=2) at my_bitmap.h:111 __PRETTY_FUNCTION__ = "void bitmap_set_bit(MY_BITMAP*, uint)" #5 0x0832196c in mark_full_partition_used_no_parts (part_info=0x930eb48, part_id=2) at opt_range.cc:2624 _db_func_ = 0x87e217b "prune_partitions" _db_file_ = 0x87e1625 "opt_range.cc" _db_level_ = 8 _db_framep_ = (char **) 0x42b0bd18 #6 0x08322a30 in find_used_partitions (ppar=0x42b0bd3c, key_tree=0x930f458) at opt_range.cc:3028 part_id = 2 found = true left_res = 0 right_res = 0 partno = 0 set_full_part_if_bad_ret = true res = -1 pushed = false __PRETTY_FUNCTION__ = "int find_used_partitions(PART_PRUNE_PARAM*, SEL_ARG*)" #7 0x0832a1da in prune_partitions (thd=0x92f23f8, table=0x930d3b0, pprune_cond=0x92ff400) at opt_range.cc:2496 retval = false _db_func_ = 0x87d2bfb "JOIN::optimize" _db_file_ = 0x87d1bc4 "sql_select.cc" _db_level_ = 7 _db_framep_ = (char **) 0x92f27b0 prune_param = {range_param = {thd = 0x92f23f8, table = 0x930d3b0, cond = 0x92ff400, prev_tables = 0, read_tables = 0, current_table = 1, key_parts = 0x930f148, key_parts_end = 0x930f15c, mem_root = 0x42b0bee8, old_root = 0x92f2418, keys = 1, using_real_indexes = false, remove_jump_scans = false, real_keynr = {0, 135955564, 154142464, 0, 1118879144, 1074046597, 0, 0, 1118879176, 141327938, 0, 0, 1118879192, 135988789, 154137224, 0, 1, 0, 1, 0, 1118879208, 135893816, 1118879364, 154137224, 1, 0, 1, 0, 1118879240, 136236908, 1118879364, 136027324, 1118879272, 136100851, 154137600, 0, 1118879272, 136237250, 1118879356, 136027324, 3, 154084344, 0, 0, 1, 0, 1, 0, 1118879320, 136026764, 154142720, 154137600, 1, 0, 1, 0, 1118879464, 1074046597, 154142276, 0, 1118879384, 1074046597, 154142276, 0}}, part_info = 0x930eb48, get_top_partition_id_func = 0x81a005c , ---Type to continue, or q to quit--- mark_full_partition_used = 0x8321902 , key = 0x930f148, part_fields = 1, subpart_fields = 0, last_part_partno = 0, last_subpart_partno = -1, is_part_keypart = 0x930f168 "\001еееееее", is_subpart_keypart = 0x930f170 "", arg_stack = 0x930f160, arg_stack_end = 0x930f160, cur_part_fields = 0, cur_subpart_fields = 0, part_iter = , subparts_bitmap = {bitmap = 0x92cdb80, n_bits = 1118879544, last_word_mask = 137066259, last_word_ptr = 0x2, mutex = 0x92cdb80}} arg = (SEL_ARG *) 0x92f26d4 res = 154142276 part_info = (partition_info *) 0x930eb48 alloc = {free = 0x930f138, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 1992, block_num = 5, first_block_usage = 0, error_handler = 0x820573a } old_read_set = (my_bitmap_map *) 0x9310fd0 tree = (SEL_TREE *) 0x930f178 range_par = (RANGE_OPT_PARAM *) 0x42b0bd3c old_write_set = (my_bitmap_map *) 0x9310fd4 #8 0x082c94d6 in JOIN::optimize (this=0x92ff910) at sql_select.cc:661 prune_cond = (class Item *) 0x92ff400 tbl = (TABLE_LIST *) 0x92ff0d0 _db_func_ = 0x87d30a2 "mysql_select" _db_file_ = 0x87d1bc4 "sql_select.cc" _db_level_ = 6 _db_framep_ = (char **) 0x14 sel = (SELECT_LEX *) 0x92f26d4 #9 0x082cf22d in mysql_select (thd=0x92f23f8, rref_pointer_array=0x92f27fc, tables=0x92ff0d0, wild_num=1, fields=@0x92f2760, conds=0x92ff400, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764740, result=0x92ff550, unit=0x92f24a0, select_lex=0x92f26d4) at sql_select.cc:1944 err = false free_join = true _db_func_ = 0x87d2ddc "mysql_explain_union" _db_file_ = 0x87d1bc4 "sql_select.cc" join = (JOIN *) 0x92ff910 _db_level_ = 5 _db_framep_ = (char **) 0x86c9596 #10 0x082cb87e in mysql_explain_union (thd=0x92f23f8, unit=0x92f24a0, result=0x92ff550) at sql_select.cc:14437 _db_func_ = 0x878f381 "mysql_execute_command" _db_file_ = 0x878e762 "sql_parse.cc" _db_level_ = 4 _db_framep_ = (char **) 0x89702e0 res = false first = (SELECT_LEX *) 0x92f26d4 #11 0x082647d0 in execute_sqlcom_select (thd=0x92f23f8, all_tables=0x92ff0d0) at sql_parse.cc:5269 ---Type to continue, or q to quit--- lex = (LEX *) 0x92f2438 result = (class select_result *) 0x92ff550 res = false #12 0x0826a2b0 in mysql_execute_command (thd=0x92f23f8) at sql_parse.cc:2626 res = false lex = (LEX *) 0x92f2438 _db_func_ = 0x878f7c4 "mysql_parse" _db_file_ = 0x878e762 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x92cdb80 need_start_waiting = false result = 0 select_lex = (SELECT_LEX *) 0x92f26d4 first_table = (TABLE_LIST *) 0x92ff0d0 all_tables = (TABLE_LIST *) 0x92ff0d0 unit = (SELECT_LEX_UNIT *) 0x92f24a0 __PRETTY_FUNCTION__ = "bool mysql_execute_command(THD*)" #13 0x082724de in mysql_parse (thd=0x92f23f8, inBuf=0x92fef70 "explain partitions select * from part_date1 where a between '2006-01-01' and\n'2007-06-01'", length=89) at sql_parse.cc:6095 lex = (LEX *) 0x92f2438 _db_func_ = 0x878f833 "dispatch_command" _db_file_ = 0x878e762 "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint)" #14 0x08272edc in dispatch_command (command=COM_QUERY, thd=0x92f23f8, packet=0x92f6f11 "", packet_length=90) at sql_parse.cc:1822 packet_end = 0x92fefc9 "" net = (NET *) 0x92f2c54 _db_func_ = 0x8863614 "?func" _db_file_ = 0x886361a "?file" error = false _db_level_ = 1 _db_framep_ = (char **) 0x4 #15 0x08274217 in do_command (thd=0x92f23f8) at sql_parse.cc:1608 packet = 0x92f6f10 "\001" old_timeout = 30 packet_length = 90 net = (NET *) 0x92f2c54 ---Type to continue, or q to quit--- command = COM_QUERY _db_func_ = 0x8863614 "?func" _db_file_ = 0x886361a "?file" _db_level_ = 1 _db_framep_ = (char **) 0x1010 #16 0x08274619 in handle_one_connection (arg=0x92f23f8) at sql_parse.cc:1222 error = 0 net = (NET *) 0x92f2c54 sctx = (Security_context *) 0x92f3478 thd = (class THD *) 0x92f23f8 launch_time = 0 set = {__val = {0 }} #17 0x40047297 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. #18 0x4018137e in clone () from /lib/tls/libc.so.6 No symbol table info available. #19 0x42b0dbb0 in ?? () No symbol table info available. (gdb)