% gdb /usr/sbin/mysqld-debug GNU gdb Red Hat Linux (6.5-25.el5rh) Copyright (C) 2006 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "i386-redhat-linux-gnu"...Using host libthread_db library "/lib/i686/nosegneg/libthread_db.so.1". (gdb) run Starting program: /usr/sbin/mysqld-debug [Thread debugging using libthread_db enabled] [New Thread -1208870704 (LWP 4187)] [New Thread -1759609968 (LWP 4190)] [New Thread -1770099824 (LWP 4191)] [New Thread -1780589680 (LWP 4192)] [New Thread -1791079536 (LWP 4193)] InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 080128 10:43:12 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... [New Thread -1801569392 (LWP 4194)] [Thread -1801569392 (LWP 4194) exited] [New Thread -1812059248 (LWP 4195)] [New Thread -1822549104 (LWP 4196)] [New Thread -1845073008 (LWP 4197)] 080128 10:43:12 InnoDB: Started; log sequence number 0 144769 [New Thread -1863955568 (LWP 4198)] 080128 10:43:12 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/lib/mysql/ace-relay-bin' to avoid this problem. [New Thread -1864156272 (LWP 4199)] [New Thread -1864356976 (LWP 4200)] 080128 10:43:12 [Note] Event Scheduler: Loaded 0 events 080128 10:43:12 [Note] /usr/sbin/mysqld-debug: ready for connections. Version: '5.1.22-rc-community-debug' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Debug (GPL) 080128 10:43:12 [Note] Slave SQL thread initialized, starting replication in log 'pair-bin.000005' at position 106, relay log '/var/lib/mysql/ace-relay-bin.000002' position: 250 080128 10:43:12 [Note] Slave I/O thread: connected to master 'rep@pair:3306',replication started in log 'pair-bin.000005' at position 356215 Program received signal SIGSEGV, Segmentation fault. [Switching to Thread -1864356976 (LWP 4200)] 0x0846430b in dict_accept (cs=0x896d440, ptr=0x0, string=0x869e5ee "SELECT", success=0x90e014e4) at dict/dict0dict.c:2232 2232 while (my_isspace(cs, *ptr)) { Current language: auto; currently c (gdb) backtrace #0 0x0846430b in dict_accept (cs=0x896d440, ptr=0x0, string=0x869e5ee "SELECT", success=0x90e014e4) at dict/dict0dict.c:2232 #1 0x08464382 in dict_str_starts_with_keyword (mysql_thd=0xaec7678, str=0x0, keyword=0x869e5ee "SELECT") at dict/dict0dict.c:3295 #2 0x084cdc8c in row_search_for_mysql (buf=0xaedb110 "", mode=2, prebuilt=0xb7dc8868, match_mode=1, direction=0) at row/row0sel.c:3562 #3 0x08440f80 in ha_innobase::index_read (this=0xaed9a28, buf=0xaedb110 "", key_ptr=0xaedd13c "\021x", key_len=372, find_flag=HA_READ_KEY_EXACT) at handler/ha_innodb.cc:4112 #4 0x0833cab9 in ha_partition::handle_unordered_scan_next_partition ( this=0xaed9818, buf=0xaedb110 "") at ha_partition.cc:3959 #5 0x0833d3ca in ha_partition::common_index_read (this=0xaed9818, buf=0xaedb110 "", key=0x90e01de0 "\021x", keypart_map=4294967295, find_flag=HA_READ_KEY_EXACT) at ha_partition.cc:3491 #6 0x0833d71d in ha_partition::index_read_map (this=0xaed9818, buf=0xaedb110 "", key=0x90e01de0 "\021x", keypart_map=4294967295, find_flag=HA_READ_KEY_EXACT) at ha_partition.cc:3436 #7 0x0832cc1e in handler::index_read_idx_map (this=0xaed9818, buf=0xaedb110 "", index=0, key=0x90e01de0 "\021x", keypart_map=4294967295, find_flag=HA_READ_KEY_EXACT) at handler.cc:3302 #8 0x08303440 in Rows_log_event::write_row (this=0xaed52b8, rli=0xaeb19d8, overwrite=true) at log_event.cc:7345 #9 0x08303778 in Write_rows_log_event::do_exec_row (this=0xaed52b8, rli=0xaeb19d8) at log_event.cc:7436 #10 0x08303af7 in Rows_log_event::do_apply_event (this=0xaed52b8, rli=0xaeb19d8) at log_event.cc:6144 #11 0x0838c440 in exec_relay_log_event (thd=0xaec7678, rli=0xaeb19d8) at log_event.h:836 #12 0x0838d30b in handle_slave_sql (arg=0xaeb0750) at slave.cc:2519 #13 0x00cfb302 in start_thread () from /lib/i686/nosegneg/libpthread.so.0 #14 0x00c5338e in clone () from /lib/i686/nosegneg/libc.so.6 (gdb) info local old_ptr = (gdb) up #1 0x08464382 in dict_str_starts_with_keyword (mysql_thd=0xaec7678, str=0x0, keyword=0x869e5ee "SELECT") at dict/dict0dict.c:3295 3295 dict_accept(cs, str, keyword, &success); (gdb) info local cs = (struct charset_info_st *) 0x896d440 success = 0 (gdb) up #2 0x084cdc8c in row_search_for_mysql (buf=0xaedb110 "", mode=2, prebuilt=0xb7dc8868, match_mode=1, direction=0) at row/row0sel.c:3562 3562 if (dict_str_starts_with_keyword( (gdb) info local index = (dict_index_t *) 0xb7dc8c68 search_tuple = (dtuple_t *) 0xb7dc9c68 pcur = (btr_pcur_t *) 0xb7dc9868 trx = (trx_t *) 0xb7dca068 clust_index = thr = rec = ( rec_t *) 0x90e01660 "\\+à\220pùê\n\230\026à\220\tnb\b\030\230í\n(rí\n\230\026à\220 t3\b¨rí\nü²í\n\b" result_rec = clust_rec = err = 10 unique_search = 1 unique_search_from_clust_index = 1 mtr_has_extra_clust_latch = moves_up = set_also_gap_locks = did_semi_consistent_read = next_offs = same_user_rec = mtr = {state = 2430606548, memo = {heap = 0x0, used = 0, data = "\000\000\000\000P\nÊ\227¸àÚ·\000\000\000\000h.Ü·\030\030à\220àçÏ\000H\030à\220\000\000\000\000\000\000\000\000`\nÊ\227h\030à\220d`J\bd\nÊ\227`Ðv\b+\000\000\000´àÚ·è\030à\220\000\000\000\000h\030à\220Q¢J\b¸àÚ·-\206w\bk\002\000\000\000\000\000\000\000\000\000\000\030\000\000\0007\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\001\000\000\000õÿÿÿ\n\000\000\000\f\033à\220¸àÚ·´àÚ·\000\000\005\000\000\000\000\000\005\000\000\000\004\033à\220\000\000\000\000ä\030à\220\000\000\000\000h.Ü·H\035à\2202¶N\bä\030à\220"..., base = {count = 0, start = 0x0, end = 0x0}, list = {prev = 0x0, next = 0x0}}, log = {heap = 0x0, used = 0, data = '\0' , "¶Ñí\n\001\000\000\000@Ô\226\bè\032à\220µMd\b@Ô\226\bØ\032à\220¶Ñí\n·Ñí\n", '\0' , "@Ô\226\b·Ñí\n`\237í\n.\000\000\000\004¹í\n?Ñí\nx\000\000\000x\000\000\000uä\"\b\034±í\n?Ñí\nx\000\000\000x\000\000\000(\033à\220\000\000\000\000\n\000\000\000\210\000\005\000&\000\000\000\005\000\000\000\001ÓÏ\000\000\000\000\000óq¾\000h\020\000\000\000Ó\177\222¥ýÏ\000ì¸í\n\\+à\220H\033à\220ãJb\b\000\000\000\000@Ô\226\bx\033à\220\rbb\b?Ñí\nx\000\000\000\f", '\0' ..., base = {count = 2430606408, start = 0x50106, end = 0x0}, list = {prev = 0xb7dca068, next = 0x174}}, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = { high = 2430606440, low = 139295412}, end_lsn = {high = 183268984, low = 3084685452}, magic_n = 1} heap = (mem_heap_t *) 0x0 ---Type to continue, or q to quit--- offsets_ = {100, 2430604900, 2430604896, 183171440, 183333416, 2430610268, 183171440, 2430604952, 140668425, 183343128, 183333416, 2430604952, 137589792, 183333544, 183350012, 8, 183333416, 183333416, 0, 2430607704, 136862327, 2704, 2430606764, 2430606760, 2430606756, 2430607290, 38, 2430607756, 0, 2430610268, 2430607290, 2430605048, 2430607819, 2430607756, 183149456, 183268984, 183333416, 38, 0, 0, 183268984, 2430605152, 2430605156, 2430605176, 13630885, 183268984, 2430610268, 2430605080, 140659427, 0, 2430605148, 13619969, 140665357, 183268984, 4200, 13619969, 0, 13624300, 4200, 183171440, 1, 13624300, 3084689984, 0, 619, 2430605144, 13625312, 2430605192, 140658602, 3084689984, 13625312, 2430605224, 140658420, 3084660336, 4200, 13619969, 3084689980, 3084689984, 0, 2430605224, 139108945, 3084689984, 142050861, 619, 3084660336, 3084660332, 3084812328, 2430606488, 139368863, 3084689984, 142004320, 43, 1, 13624300, 2546600548, 0, 619, 2430605272, 13625312, 3084660332} offsets = (ulint *) 0x90e0164c (gdb)