/home/miguel/dbs/4.1/libexec/mysqld: ready for connections. Version: '4.1.3-beta-debug-log' socket: '/home/miguel/dbs/4.1/mysql41.sock' port: 3306 [New Thread 147466 (LWP 3440)] [New Thread 163851 (LWP 16662)] pure virtual method called Program received signal SIGABRT, Aborted. [Switching to Thread 163851 (LWP 16662)] 0x40205b71 in kill () from /lib/i686/libc.so.6 (gdb) backtrace full #0 0x40205b71 in kill () from /lib/i686/libc.so.6 No symbol table info available. #1 0x40051cf1 in pthread_kill () from /lib/i686/libpthread.so.0 No symbol table info available. #2 0x4005200b in raise () from /lib/i686/libpthread.so.0 No symbol table info available. #3 0x40205904 in raise () from /lib/i686/libc.so.6 No symbol table info available. #4 0x40206e8c in abort () from /lib/i686/libc.so.6 No symbol table info available. #5 0x40187305 in __cxxabiv1::__terminate(void (*)()) () from /usr/lib/libstdc++.so.5 No symbol table info available. #6 0x40187342 in std::terminate() () from /usr/lib/libstdc++.so.5 No symbol table info available. #7 0x40187855 in __cxa_pure_virtual () from /usr/lib/libstdc++.so.5 No symbol table info available. #8 0x080d9336 in Item::save_in_field(Field*, bool) (this=0x851b4a8, field=0x8523238, no_conversions=true) at item.cc:1564 result = (class String *) 0x6 cs = (CHARSET_INFO *) 0x400599f0 buff = "\001\000\000\000L]\206BÔZ\206B\a\000\000\000L]\206B(1R\b\004[\206Bĵ2\b5\000\000\000ìZ\206BðZ\206BôZ\206B,[\206BL]\206BS]\206B\\]\206BS]\206B(1R\b4]\206BÖ¶2\b5\000\000\000\034[\206B [\206B$[\206B,[---Type to continue, or q to quit--- \206BL]\206B([\206B¯\210\206Bÿ", '\0' , " \000\000\000./test/\0008\00319þ\210\206BÀ\202\206B\020x\206B°\217Q\b\004\000\000\000\f\222Q\b \213\001@P\221Q\b]\207\206B\f\\\206Bs\217\000@]\207\206Bé\227\031\a@}\206B¼[\206B¸"... error = 0 #9 0x080f6278 in convert_constant_item (field=0x8523238, item=0x851eee4) at item_cmpfunc.cc:152 No locals. #10 0x080f7c03 in Item_func_between::fix_length_and_dec() ( this=0x851ee38) at item_cmpfunc.cc:748 field = (class Field *) 0x8523238 #11 0x080e8331 in Item_func::fix_fields(THD*, st_table_list*, Item**) (this=0x851ee38, thd=0x850ce30, tables=0x851ec48, ref=0x42866604) at item_func.cc:235 arg = (class Item **) 0x851eeec arg_end = (class Item **) 0x851eeec buff = "\034d\206BHìQ\b\204^\206Bu¥2\b\002\001\000\000l^\206B\204^\206B\016\220\023\b\b`\206Bst/\000:Â\004@¯\210\206B\034_\206B _\206B¤^\206B\220w\023\b" #12 0x081783f4 in setup_conds(THD*, st_table_list*, Item**) ( thd=0x850ce30, tables=0x851ec48, conds=0x42866604) at sql_base.cc:2440 not_null_tables = 0 stmt = (class Statement *) 0x0 ---Type to continue, or q to quit--- backup = {_vptr.Statement = 0x83657f0, main_lex = { yylineno = 1073846224, yytoklen = 1116102476, yylval = 0x400532ae, unit = { = { _vptr.st_select_lex_node = 0x8348828, next = 0x0, prev = 0x0, master = 0x4005315a, slave = 0x85234d8, link_next = 0x5, link_prev = 0x25, options = 1074082138, uncacheable = 0 '\0', linkage = UNSPECIFIED_TYPE, no_table_names_allowed = 255, no_error = 255}, result_table_list = {next = 0xffffffff, db = 0x4030ca30 "", alias = 0x4030bfd8 "ìþ\022", real_name = 0x42865f84 "", option = 0x40250ed1 "\201Ã\a±\v", on_expr = 0x0, natural_join = 0x0, use_index = 0xffffffff, ignore_index = 0x8, table = 0x400, table_list = 0x0, derived = 0xfffffc00, grant = {grant_table = 0x3, version = 0, privilege = 0, want_privilege = 9}, lock_type = TL_UNLOCK, outer_join = 139605312, shared = 139606256, db_length = 1116102660, real_name_length = 139605312, straight = 240, updating = 56, force_index = 82, ignore_leaves = 8, cacheable_table = false, table_in_update_from_clause = false}, union_result = 0x42866004, table = 0x82eccac, result = 0x177, res = 1116102628, found_rows_for_union = 1116102632, prepared = 236, optimized = 95, executed = 134, cleaned = 66, item_list = { = { = {}, first = 0x83fc0fc, last = 0x42865fcc, ---Type to continue, or q to quit--- elements = 0}, }, types = { = { = {}, first = 0x83fc0fc, last = 0x42865fd8, elements = 0}, }, global_parameters = 0x0, return_to = 0x0, select_limit_cnt = 138436384, offset_limit_cnt = 98, item = 0x42866004, thd = 0x5, fake_select_lex = 0x0, union_distinct = 0x2, describe = 36}, select_lex = { = { _vptr.st_select_lex_node = 0x83487c8, next = 0x85238f0, prev = 0x5, master = 0x8522d44, slave = 0x8523128, link_next = 0x0, link_prev = 0x2, options = 1116102756, uncacheable = 91 '[', linkage = UNSPECIFIED_TYPE, no_table_names_allowed = 72, no_error = 96}, db = 0x4286604c "=", db1 = 0x42866050 "``\206Bd`\206Bq\"\005@à+R\b", table1 = 0x8522be0 "(1R\b\0302R\b\0342R\b", db2 = 0x8523238 "¨?6\bá1R\bà1R\bà+R\bà+R\bÐ4R\b12R\bHs4\b", table2 = 0x42866074 "p`\206B", where = 0x8329cf2, having = 0x3d, prep_where = 0x42866060, olap = 1116102756, table_list = {elements = 1074078321, first = 0x8522be0 "(1R\b\0302R\b\0342R\b", next = 0x0}, group_list = {elements = 2, first = 0x85231e0 "ý\214c<ó9\022", next = 0x8522be0}, item_list = { = { = {}, ---Type to continue, or q to quit--- first = 0x83fc0fc, last = 0x42866070, elements = 0}, }, interval_list = { = { = {}, first = 0x83fc0fc, last = 0x4286607c, elements = 0}, }, use_index = { = { = {}, first = 0x83fc0fc, last = 0x42866088, elements = 0}, }, use_index_ptr = 0x40018f48, ignore_index = { = { = {}, first = 0x83fc0fc, last = 0x42866098, elements = 0}, }, ignore_index_ptr = 0x428660f4, ftfunc_list = 0x8344d5b, ftfunc_list_alloc = { = { = {}, first = 0x83fc0fc, last = 0x428660ac, elements = 0}, }, join = 0x851eca4, type = 0x83fa2e0 "!", order_list = {elements = 1116102884, first = 0x8523234 "e", next = 0x4005315a}, expr_list = { = { = {}, first = 0x83fc0fc, last = 0x428660cc, elements = 0}, }, when_list = { = { = {}, first = 0x83fc0fc, last = 0x428660d8, elements = 0}, }, gorder_list = 0x4004d920, ---Type to continue, or q to quit--- select_limit = 1, offset_limit = 11, ref_pointer_array = 0x8516140, select_n_having_items = 1116102980, cond_count = 20969760, parsing_place = NO_MATTER, with_sum_func = 72, table_join_options = 1116102980, in_sum_expr = 139559328, select_number = 648, with_wild = 0, braces = 9, having_fix_field = false, explicit_limit = false, resolve_mode = NOMATTER_MODE}, current_select = 0x428663dc, all_selects_list = 0x8523540, ptr = 0x428661c4 "", tok_start = 0x82ed02e "¸", tok_end = 0x6a
, end_of_query = 0x4286613c "`×?\b\224\003", length = 0x42866140 "\224\003", dec = 0x42866144 "Ta\206Bo\001\005@p×?\b", change = 0x83fd760 "", name = 0x394
, help_arg = 0x42866154 "\204a\206B¶¤3\b`×?\b\v\200\002", backup_dir = 0x4005016f "ëÏ\213A\020\205ÀtÛÇA\b", to_log = 0x83fd770 "", purge_time = 0, x509_subject = 0x42866184 "ôc\206BßX\027\b²\003", x509_issuer = 0x833a4b6 "\211Ø\215eô[^_]ÃU\211åWVS\203ì\030\213]\f\213}\024SèC{Ùÿ\203Ä\020\203{8", ssl_cipher = 0x83fd760 "", found_colon = 0x2800b
, wild = 0x1, exchange = 0x833a3d7, result = 0x851ec48, default_value = 0x850ce30, on_update_value = 0x428663f4, ---Type to continue, or q to quit--- comment = 0x8522be0, name_and_length = { str = 0x850ce30 "ÈW6\b\030Ô?\bøìO\bØW6\b", length = 1116103800}, grant_user = 0x428663f4, yacc_yyss = 0x81758df "\211Ø\215eô[^_]Ã\220U\211åWVS\201ì4\002", yacc_yyvs = 0x3b2
, thd = 0x428661bc, charset = 0x428661c0, col_list = { = { = {}, first = 0x83fc0fc, last = 0x42866198, elements = 0}, }, ref_list = { = { = {}, first = 0x83fc0fc, last = 0x428661a4, elements = 0}, }, interval_list = { = { = {}, first = 0x83fc0fc, last = 0x428661b0, elements = 0}, }, users_list = { = { = {}, first = 0x83fc0fc, last = 0x428661bc, elements = 0}, }, columns = { = { = {}, first = 0x83fc0fc, last = 0x428661c8, elements = 0}, }, key_list = { = { = {}, first = 0x83fc0fc, last = 0x428661d4, elements = 0}, }, ---Type to continue, or q to quit--- create_list = { = { = {}, first = 0x83fc0fc, last = 0x428661e0, elements = 0}, }, insert_list = 0x0, field_list = { = { = {}, first = 0x83fc0fc, last = 0x428661f0, elements = 0}, }, value_list = { = { = {}, first = 0x83fc0fc, last = 0x428661fc, elements = 0}, }, many_values = { = { = {}, first = 0x83fc0fc, last = 0x42866208, elements = 0}, }, var_list = { = { = {}, first = 0x83fc0fc, last = 0x42866214, elements = 0}, }, param_list = { = { = {}, first = 0x83fc0fc, last = 0x42866220, elements = 0}, }, proc_list = { elements = 139514716, first = 0x4286625c "", next = 0x7}, auxilliary_table_list = {elements = 1, first = 0x8400ec0 "Ú\034", next = 0x42866200}, save_list = {elements = 0, first = 0x0, next = 0x42866200}, interval = 0x55, last_field = 0x42866294, savepoint_name = 0x1323f1a
, udf = {name = { ---Type to continue, or q to quit--- str = 0x22000000
, length = 1107296256}, returns = 1116103292, type = 139559328, dl = 0x0, dlhandle = 0x0, func = 0x0, func_init = 0x400532ae, func_deinit = 0x8400ec0, func_clear = 0x8400ec0, func_add = 0x428662e4, usage_count = 1074082138}, check_opt = { sort_buffer_size = 138415616, flags = 138415616, sql_flags = 1116103348, key_cache = 0x4005768c}, create_info = { table_charset = 0x0, default_table_charset = 0x8523540, comment = 0x42866334 "dc\206B¶¤3\bl7R\b\v\200\002", password = 0x4005315a "\201Ã2E", data_file_name = 0x8523540 "þþ\a\001", index_file_name = 0x19
, alias = 0x42866334 "dc\206B¶¤3\bl7R\b\v\200\002", max_rows = 176111746162, min_rows = 4793627568710771420, auto_increment_value = 1, table_options = 0, avg_row_length = 0, raid_chunksize = 17117870, used_fields = 138415616, merge_list = {elements = 139513392, first = 0x42866494 "ôe\206B±Ó\031\b0ÎP\bHìQ\b\004f\206Bôd\206BLe\206B0ÎP\bÔd\206B", next = 0x85181a0}, db_type = DB_TYPE_UNKNOWN, row_type = 139605988, options = 0, raid_type = 1074082478, raid_chunks = 139605988, merge_insert_method = 212, table_existed = 20}, mi = {host = 0x4005768c "\214å", user = 0x1
, password = 0x852376c "", ---Type to continue, or q to quit--- log_file_name = 0x42866334 "dc\206B¶¤3\bl7R\b\v\200\002", port = 1074099852, connect_retry = 139605868, pos = 4793627928371921495, server_id = 1074069871, ssl = 139605884, ssl_key = 0x0, ssl_cert = 0x42866364 "\214c\206B\220c\206Bl7R\b\201ý=\bW\002", ssl_ca = 0x833a4b6 "\211Ø\215eô[^_]ÃU\211åWVS\203ì\030\213]\f\213}\024SèC{Ùÿ\203Ä\020\203{8", ssl_capath = 0x852376c "", ssl_cipher = 0x2800b
, relay_log_name = 0x42866354 "¤c\206B³\2173\bX\002", relay_log_pos = 139479524}, mqh = {questions = 139605856, updates = 10, connections = 1116103588, bits = 137596851}, thread_id = 600, type = 1116103560, sql_command = 1116103564, lock_option = 1116103568, ssl_type = 139605868, next_state = 138280321, duplicates = 599, tx_isolation = 137595788, ha_read_mode = RNEXT, ha_rkey_mode = HA_READ_KEY_OR_NEXT, option_type = OPT_DEFAULT, uint_geom_type = 136092506, grant = 139479504, grant_tot_col = 139513392, which_columns = 1116103652, fk_delete_opt = 139479524, fk_update_opt = 139479524, fk_match_option = 1, slave_thd_opt = 1116103652, describe = 97 'a', drop_if_exists = 153, drop_temporary = 51, local_file = 8, one_shot_set = 125, in_comment = 3, ignore_space = false, verbose = false, no_write_to_binlog = 200, derived_tables = 99, safe_to_cache_query = 134, alter_info = { ---Type to continue, or q to quit--- drop_list = { = { = {}, first = 0x83fc0fc, last = 0x428663b4, elements = 0}, }, alter_list = { = { = {}, first = 0x83fc0fc, last = 0x428663c0, elements = 0}, }, flags = 139513392, keys_onoff = LEAVE_AS_IS, tablespace_op = NO_TABLESPACE_OP, is_simple = 208}, prepared_stmt_name = { str = 0x48
, length = 0}, prepared_stmt_code = { str = 0xffffffff
, length = 4294967295}, prepared_stmt_code_is_varref = 164, prepared_stmt_params = { = { = {}, first = 0x83fc0fc, last = 0x428663f0, elements = 0}, }}, id = 0, set_query_id = true, allow_sum_func = false, name = { str = 0x8522be0 "(1R\b\0302R\b\0342R\b", length = 135364287}, lex = 0x42865f20, query = 0x0, query_length = 0, free_list = 0x0, mem_root = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 0, block_size = 0, block_num = 0, first_block_usage = 0, error_handler = 0}} _db_func_ = 0x8519328 "¯\210\206B\020ii\r" _db_file_ = 0x4030ce20 "\024Î0@\034Î0@\034Î0@$Î0@$Î0@,Î0@,Î0@4Î0@4Î0@<Î0@<Î0@DÎ0@DÎ0@LÎ0@LÎ0@TÎ0@TÎ0@\\Î0@\\Î0@dÎ0@dÎ0@lÎ0@lÎ0@\004" ---Type to continue, or q to quit--- _db_level_ = 1076939388 _db_framep_ = (char **) 0x4030ca20 #13 0x0819dc94 in mysql_prepare_delete(THD*, st_table_list*, Item**) ( thd=0x850ce30, table_list=0x851ec48, conds=0x42866604) at sql_delete.cc:269 delete_table_list = (TABLE_LIST *) 0x851ec48 _db_func_ = 0x1
_db_file_ = 0x851e401 "" _db_level_ = 139584860 _db_framep_ = (char **) 0x428665f4 #14 0x0819d3b1 in mysql_delete(THD*, st_table_list*, Item*, st_sql_list*, unsigned long, unsigned long) (thd=0x850ce30, table_list=0x851ec48, conds=0x851ee38, order=0x851e614, limit=4294967295, options=0) at sql_delete.cc:49 error = -1 table = (TABLE *) 0x8522be0 select = (class SQL_SELECT *) 0x0 info = {table = 0x0, file = 0x8523128, forms = 0x4286657c, read_record = 0x851ec48, thd = 0x850ce30, select = 0x8, cache_records = 1116104148, ref_length = 135638026, struct_length = 139513392, reclength = 8, rec_cache_size = 139572224, error_offset = 139586688, index = 0, ref_pos = 0x0, record = 0x428665c0 "\\åQ\b\004f\206BHìQ\b\\åQ\b0ÎP\b\004f\206B\003Þ\---Type to continue, or q to quit--- 025\b£\024", rec_buf = 0x428665c4 "\004f\206BHìQ\b\\åQ\b0ÎP\b\004f\206B\003Þ\025\b£\024", cache = 0x851ec48 "", cache_pos = 0x851e55c "È\2074\b", cache_end = 0x42866604 "8îQ\b\024æQ\bÿÿÿÿ", read_positions = 0x851ec48 "", io_cache = 0x851e55c, print_error = 48, ignore_not_found_rows = 206} using_limit = false transactional_table = false log_delayed = false safe_update = false const_cond = true deleted = 0 _db_func_ = 0xd1
_db_file_ = 0x4286651c "" _db_level_ = 1116103968 _db_framep_ = (char **) 0x1866524 #15 0x08158db3 in mysql_execute_command(THD*) (thd=0x850ce30) at sql_parse.cc:2718 res = 0 lex = (LEX *) 0x851e474 tables = (TABLE_LIST *) 0x851ec48 select_lex = (SELECT_LEX *) 0x851e55c unit = (SELECT_LEX_UNIT *) 0x851e480 _db_func_ = 0x88
---Type to continue, or q to quit--- _db_file_ = 0x83fc0fc "üÀ?\b" _db_level_ = 1116104352 _db_framep_ = (char **) 0x0 #16 0x08199df6 in execute_stmt (thd=0x850ce30, stmt=0x851e470, expanded_query=0x42866b5c, set_context=true) at sql_prepare.cc:1904 _db_func_ = 0x851e470 "àC:\b\001" _db_file_ = 0x850ce30 "ÈW6\b\030Ô?\bøìO\bØW6\b" _db_level_ = 139551050 _db_framep_ = (char **) 0x42866b94 #17 0x08199aa7 in mysql_stmt_execute(THD*, char*, unsigned) ( thd=0x850ce30, packet=0x851614c "", packet_length=0) at sql_prepare.cc:1811 stmt_id = 139584624 expanded_query = { Ptr = 0x85049f0 "DELETE FROM date_test WHERE date BETWEEN '' AND ''", str_length = 50, Alloced_length = 56, alloced = true, str_charset = 0x83fb620} packet_end = (uchar *) 0x851614e "" stmt = (Prepared_statement *) 0x851e470 _db_func_ = 0x83fd7a0 "" _db_file_ = 0x51f
_db_level_ = 1116105572 _db_framep_ = (char **) 0x4005016f ---Type to continue, or q to quit--- #18 0x08155c9b in dispatch_command(enum_server_command, THD*, char*, unsigned) (command=COM_EXECUTE, thd=0x850ce30, packet=0x8516141 "\002", packet_length=14) at sql_parse.cc:1427 net = (NET *) 0x850d35c error = false _db_func_ = 0xe
_db_file_ = 0xe
_db_level_ = 1116106020 _db_framep_ = (char **) 0xe start_of_query = 139513392 #19 0x081557d5 in do_command(THD*) (thd=0x850ce30) at sql_parse.cc:1272 packet = 0x8516140 "\027\002" old_timeout = 30 packet_length = 14 net = (NET *) 0x850d35c command = COM_EXECUTE _db_func_ = 0x8134369 "\203Ä\020\213]üÉÃ\220U\211åS\203ì\020\213]\bSè:" _db_file_ = 0x850df04 "XÔQ\b" _db_level_ = 8192 _db_framep_ = (char **) 0x1000 #20 0x08154de1 in handle_one_connection (arg=0x0) at sql_parse.cc:1016 error = 1074099852 ---Type to continue, or q to quit--- net = (NET *) 0x850d35c thd = (class THD *) 0x850ce30 launch_time = 0 set = {__val = {0 }} #21 0x4004ef60 in pthread_start_thread () from /lib/i686/libpthread.so.0 No symbol table info available. #22 0x4004f0fe in pthread_start_thread_event () from /lib/i686/libpthread.so.0 No symbol table info available. #23 0x402b8327 in clone () from /lib/i686/libc.so.6 No symbol table info available. (gdb)