(gdb) run Starting program: /usr/local/libexec/mysqld [Thread debugging using libthread_db enabled] [New Thread -1221304192 (LWP 29642)] 051115 17:59:48 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=grays-bin' to avoid this proble m. [New Thread -1249682512 (LWP 29645)] [New Thread -1260172368 (LWP 29646)] [New Thread -1270662224 (LWP 29647)] [New Thread -1281152080 (LWP 29648)] [New Thread -1296421968 (LWP 29649)] [New Thread -1306911824 (LWP 29650)] [New Thread -1317401680 (LWP 29651)] [New Thread -1327891536 (LWP 29652)] 051115 17:59:48 InnoDB: Started; log sequence number 9 2781752996 [New Thread -1606820944 (LWP 29653)] 051115 17:59:48 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL serv er acts as a slave and has his hostname changed!! Please use '--relay-log=grays-relay-bin' to avoid this problem. [New Thread -1607021648 (LWP 29654)] [New Thread -1607222352 (LWP 29655)] 051115 17:59:48 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.15-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 051115 17:59:48 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000022' at position 443563943, r elay log './grays-relay-bin.001215' position: 3588712 051115 17:59:49 [Note] Slave I/O thread: connected to master 'gbs_replicator@orw-gbsdb2.wv.mentorg.com:3306', replication s tarted in log 'mysql-bin.000022' at position 443563943 [New Thread -1608516688 (LWP 29673)] [New Thread -1608717392 (LWP 29689)] Program received signal SIGSEGV, Segmentation fault. [Switching to Thread -1608516688 (LWP 29673)] 0x0830182c in rec_get_offsets_func (rec=0xb61658b1 "\200\0011£", index=0x0, offsets=0x8219b574, n_fields=2686443716, heap=0xa01fe0c4, file=0x83cada0 "btr0sea.c", line=978) at rem0rec.c:324 324 if (UNIV_LIKELY(index->table->comp)) { Current language: auto; currently c (gdb) bt full #0 0x0830182c in rec_get_offsets_func (rec=0xb61658b1 "\200\0011£", index=0x0, offsets=0x8219b574, n_fields=2686443716, heap=0xa01fe0c4, file=0x83cada0 "btr0sea.c", line=978) at rem0rec.c:324 n = 2 size = 3054917809 #1 0x082a1520 in btr_search_drop_page_hash_index (page=0xb6164000 "뤠c") at btr0sea.c:977 table = (hash_table_t *) 0xb61dcc68 n_fields = 0 n_bytes = 2 rec = (rec_t *) 0xb61658b1 "\200\0011£" fold = 2182722932 prev_fold = 2182722932 n_cached = 2 i = 2182722932 heap = (mem_heap_t *) 0x8a98a50 offsets = (ulint *) 0x8a98a90 #2 0x082a1fad in btr_search_build_page_hash_index (index=0x89bf298, page=0xb6164000 "뤠c", n_fields=0, n_bytes=1, side=1) at btr0sea.c:1108 table = (hash_table_t *) 0xb61dcc68 rec = (rec_t *) 0x0 fold = 140055528 next_fold = 0 n_cached = 13 i = 0 heap = (mem_heap_t *) 0x0 offsets_ = {100, 0, 0, 11, 12, 140055660, 2686443896, 137418933, 12, 140055528, 2, 0, 100, 1, 8, 10, 11, 140055648, 2686443944, 137418933, 11, 140055528, 21, 21, 22, 0, 3, 9, 10, 140055636, 2686443992, 137418933, 10, 140055528, 2686444008, 137369741, 6, 1, 145410044, 8, 9, 140055624, 2686444040, 137418933, 9, 140055528, 3074937800, 105, 145312000, 13, 109, 3074937728, 3074935448, 3074937728, 1, 2686444072, 3074133229, 3074937728, 145312008, 0, 2686444072, 3076159888, 2686444120, 137424045, 138745268, 3076159888, 2686444152, 137419693, 140055544, 140055528, 138826808, 12, 80, 0, 2686444152, 137425522, 145312028, 138194338, 8, 138194336, 145312024, 0, 2686444200, 137415810, 145312028, 138194336, 8, 0, 3055405164, 2183313779, 2686444216, 0, 0, 145073272, 2686444248, 136990607, 0, 12, 0, 0} offsets = (ulint *) 0xa01fe130 #3 0x082a055c in btr_search_info_update_slow (info=0x89bf688, cursor=0x8a94918) at btr0sea.c:515 build_index = 1 params2 = (ulint *) 0x0 #4 0x08295968 in btr_cur_search_to_nth_level (index=0x89bf298, level=0, tuple=0x8a60720, mode=2, latch_mode=1, cursor=0x8a5a478, has_search_latch=1, mtr=0xa01fe820) at btr0sea.ic:66 tree = (dict_tree_t *) 0x89bf878 page = (ib_page_t *) 0x0 guess = (ib_page_t *) 0x0 page_no = 1 space = 0 up_match = 0 up_bytes = 2 low_match = 0 low_bytes = 0 height = 0 rw_latch = 1 page_mode = 2 insert_planned = 0 buf_mode = 10 estimate = 0 ignore_sec_unique = 0 root_height = 1 info = (btr_search_t *) 0x89bf688 heap = (mem_heap_t *) 0x0 offsets_ = {100, 2, 8, 4, 8, 1, 0, 0, 0, 144439416, 4, 0, 0, 2, 0, 3, 100, 2, 8, 4, 8, 140056260, 2686444600, 137418933, 62, 140055528, 2686445064, 136269007, 2686445232, 0, 0, 60, 61, 140056248, 3046633680, 3046633648, ---Type to continue, or q to quit--- 2686444616, 3076159888, 2686444680, 137088884, 3046633700, 213018, 144509629, 59, 3046633648, 0, 2686444680, 137119350, 3046633648, 0, 1, 144662232, 3053895680, 3053895680, 2686444744, 136960727, 0, 213018, 1, 0, 10, 138142558, 28, 2686445904, 3055405160, 0, 2686444808, 137395262, 3055405164, 213018, 144866476, 3053895680, 2686444760, 3076159888, 3055405164, 0, 0, 0, 3046583472, 3046583476, 2686444792, 3076159888, 3055405160, 3046654632, 2686444808, 3076159888, 2686444872, 137318027, 3055405164, 138142100, 621, 16, 3048898560, 3048898717, 2686444888, 0, 0, 2686445600, 3, 2686445620} offsets = (ulint *) 0xa01fe3b0 #5 0x0827b0af in row_sel_try_search_shortcut_for_mysql (out_rec=0x0, prebuilt=0x0, offsets=0xa01fe688, heap=0xa01fe68c, mtr=0xa01fe820) at btr0pcur.ic:535 index = (dict_index_t *) 0x89bf298 search_tuple = (dtuple_t *) 0x8a60720 pcur = (btr_pcur_t *) 0x8a5a478 trx = (trx_t *) 0x8a98258 #6 0x08277b41 in row_search_for_mysql (buf=0x8a5f7d0 "$z\001", mode=2, prebuilt=0x8a58a30, match_mode=1, direction=0) at row0sel.c:3324 index = (dict_index_t *) 0x89bf298 comp = 0 search_tuple = (dtuple_t *) 0x8a60720 pcur = (btr_pcur_t *) 0x8a5a478 trx = (trx_t *) 0x8a98258 clust_index = (dict_index_t *) 0xb75a7990 thr = (que_thr_t *) 0xa01fe684 rec = (rec_t *) 0xb5e9cc7c "any\200" result_rec = (rec_t *) 0xa01fe658 "X\202©\bx¤¥\b \a¦\b" clust_rec = (rec_t *) 0xb5e9cc7c "any\200" old_vers = (rec_t *) 0x3
err = 10 unique_search = 1 unique_search_from_clust_index = 1 mtr_has_extra_clust_latch = 0 moves_up = 0 set_also_gap_locks = 1 next_offs = 2686445192 same_user_rec = 144866376 mtr = {state = 0, memo = {heap = 0x0, used = 24, data = "7\000\000\000\000\000\000\000\003\000\000\000¨B\230µ\001\000\000\000\000D\230µ\001\000\000\000\000\000\000\000ð\210¥\bX\000\000\000pd«\bxè\037 \024Û4\b\210d«\bð\210¥\bX\000\000\000\210d«\bð\210¥\bð\210¥\b\230è\037 \207û\022\b\210d«\bð\210¥\bX\000\000\000\000\000\000\000ÿÿÿÿ\b\206@\b¸è\037 ¨û\022\bð\210¥\b\024n©\b\230\200¥\b4\177ª\0010\177ª\bÈÓG·øè\037 ÈX\032\bð\210¥\b\024n©\b\230\200¥\bPd«\b\000\000\000\000\001\000\000\000\024n©\b(Ä>\bà\205©\b ~ª\b\bé\037 pd«\bà\205©\b"..., base = {count = 1073741824, start = 0x1, end = 0x1}, list = {prev = 0x8ab6068, next = 0x0}}, log = {heap = 0x0, used = 0, data = "Xì\037 c;\031\b(H«\b\001", '\0' , "øm©\bèaª\bð`ª\bð`ª\b\000\000\000\000øm©\b\001", '\0' , "(H«\b(H«\b\020H«\bpH«\b\000\000\000\000Èê\037 .(\016\bÈ}ª\b\210H«\bÈê\037 6\000\017\bÈ}ª\bDë\037 \000\000\000\000È}ª\b\001\000\000\000\000\000\000\000øê\037 \225ý\016\bÈ}ª\bÈ}ª\b\001\000\000\000È}ª\b\001\000\000\000Ð÷¥\b\001\000\000\000(Ä>\bð\210¥\b ~ª\b(ë\037 ùü\031\b ~ª\b ~ª\b\001\000\000\000 ~ª\b", '\0' ..., base = { count = 2686446760, start = 0x81f3c3a, end = 0x1}, list = {prev = 0x8ab6454, next = 0x0}}, modifications = 0, n_log_recs = 0, log_mode = 21, start_lsn = {high = 145450064, low = 145097944}, end_lsn = {high = 145326680, low = 4}, magic_n = 145450068} heap = (mem_heap_t *) 0x0 offsets_ = {100, 2686445952, 1, 2686445964, 0, 2686445956, 2686445272, 137319015, 3046593744, 1, 2686445952, 0, 3051998324, 2, 7, 136818080, 144746288, 145068500, 38, 0, 2686445952, 144748024, 3051998332, 2686445552, 0, 3196, 144866376, 0, 144748024, 8, 2686447096, 136799972, 144746288, 144748024, 2686445552, 144857912, 52, 0, 2686445400, 44, 45, 140056056, 2686445416, 137418933, 45, 140055528, 7, 50, 51, 140056128, 2686445448, 43, 44, 140056044, 148, 1, 1, 0, 0, 0, 3053895813, 144857912, 145326680, 144662232, 145077312, 0, 3211, 1, 1, 0, 0, 0, 3051998332, 144857912, 145326680, 144662232, 145077312, 0, 144865760, 10, 7, 140055528, 2686445560, 1, 145391048, 3051998332, 2686445552, 0, 100, 2, 8, 3, 7, 0, 24, 55, 0, 3, 0, 1} offsets = (ulint *) 0xa01fe690 #7 0x081effef in ha_innobase::index_read (this=0x8a587c0, buf=0x8a5f7d0 "$z\001", key_ptr=0x8ab6450 "÷ò", key_len=4, ---Type to continue, or q to quit--- find_flag=HA_READ_KEY_EXACT) at ha_innodb.cc:3917 prebuilt = (row_prebuilt_t *) 0x8a58a30 index = (dict_index_t *) 0x1 match_mode = 1 error = -1248312320 ret = 1 #8 0x0812a81c in subselect_uniquesubquery_engine::exec (this=0x8ab6690) at item_subselect.cc:1613 error = 145449712 table = (TABLE *) 0x8a58098 #9 0x08126d9b in Item_subselect::exec (this=0x8aa6c00) at item_subselect.cc:198 res = 0 #10 0x08127ca7 in Item_in_subselect::val_bool (this=0x8aa6c00) at item_subselect.cc:727 No locals. #11 0x080eef83 in Item::val_bool_result (this=0x0) at item.h:543 No locals. #12 0x081078f7 in Item_in_optimizer::val_int (this=0x8aa7d50) at item_cmpfunc.cc:738 tmp = false #13 0x080e1cb9 in Item::val_bool (this=0x8aa7d50) at item.cc:180 No locals. #14 0x0810c481 in Item_cond_and::val_int (this=0x8ab5d10) at item_cmpfunc.cc:2757 li = { = {list = 0x8ab5d7c, el = 0x8ab5db0, prev = 0x0, current = 0x0}, } item = (class Item *) 0x8aa7d50 #15 0x08197345 in evaluate_join_record (join=0x8aa6f28, join_tab=0x8ab5a40, error=-1608523580, report_error=0x0) at sql_select.cc:9340 not_exists_optimize = false not_used_in_distinct = false found_records = 0 select_cond = (COND *) 0xb5984400 #16 0x08191536 in sub_select (join=0x8aa6f28, join_tab=0x8ab5a40, end_of_records=false) at sql_select.cc:9299 error = 0 rc = -1248312320 report_error = (my_bool *) 0x8a97824 "" info = (READ_RECORD *) 0x8ab5a7c #17 0x0819709a in do_select (join=0x8aa6f28, fields=0x0, table=0x0, procedure=0x0) at sql_select.cc:9056 rc = 0 error = NESTED_LOOP_OK join_tab = (JOIN_TAB *) 0x8ab5a40 #18 0x0818ded5 in JOIN::exec (this=0x8aa6f28) at sql_select.cc:1669 tmp_error = 145387304 curr_join = (JOIN *) 0x8aa6f28 curr_all_fields = (List *) 0x8aa7c3c curr_fields_list = (List *) 0x8aa7c84 curr_tmp_table = (TABLE *) 0xa01fef88 #19 0x0818e9dd in mysql_select (thd=0x8a96df8, rref_pointer_array=0x8a9716c, tables=0x8aa61e8, wild_num=0, fields=@0x8a970d0, conds=0x8aa6cc8, og_num=1, order=0x8aa6e40, group=0x0, having=0x0, proc_param=0x0, select_options=2156153345, result=0x8aa6f18, unit=0x8a96e44, select_lex=0x8a97050) at sql_select.cc:1833 err = false free_join = true join = (JOIN *) 0x8aa6f28 #20 0x0818ad82 in handle_select (thd=0x8a96df8, lex=0x8a96e34, result=0x8aa6f18, setup_tables_done_option=0) at sql_select.cc:234 unit = (SELECT_LEX_UNIT *) 0x8a9716c res = 108 select_lex = (SELECT_LEX *) 0x8a97050 #21 0x08160935 in mysql_execute_command (thd=0x8a96df8) at sql_parse.cc:2484 param = (SELECT_LEX *) 0x8a97050 result = (class select_result *) 0x8aa6f18 res = false ---Type to continue, or q to quit--- result = 0 lex = (LEX *) 0x8a96e34 select_lex = (SELECT_LEX *) 0x8a97050 first_table = (TABLE_LIST *) 0x8aa61e8 all_tables = (TABLE_LIST *) 0x8aa61e8 unit = (SELECT_LEX_UNIT *) 0x8a96e44 fields = { = { = {}, first = 0xe, last = 0xffffffff, elements = 0}, } keys = { = { = {}, first = 0xa01ff860, last = 0xa01ff70c, elements = 0}, } create_info = {table_charset = 0x0, default_table_charset = 0x0, connect_string = {str = 0xa01ff338 "0ô\037 \001", length = 137694768}, comment = 0x0, password = 0xa01ff430 "¼u©\b\001", data_file_name = 0xa01ff430 "¼u©\b\001", index_file_name = 0x1
, alias = 0x0, max_rows = 0, min_rows = 11544635696648028160, auto_increment_value = 11538209257342107649, table_options = 1, avg_row_length = 1, raid_chunksize = 2686448680, used_fields = 2686448632, merge_list = {elements = 137733969, first = 0x2
, next = 0xa01ff360}, db_type = DB_TYPE_UNKNOWN, row_type = 16777216, null_bits = 552967, options = 0, raid_type = 0, raid_chunks = 0, merge_insert_method = 0, extra_size = 0, table_existed = 84, frm_only = 72, varchar = 165} #22 0x08167486 in mysql_parse (thd=0x8a96df8, inBuf=0x8aa6028 "SELECT DISTINCT UnitName FROM Build WHERE UnitName LIKE '%%' AND BuildId IN (SELECT DISTINCT BuildId FROM Sod) ORDER BY UnitName LIMIT 32,10", length=145321524) at sql_parse.cc:5536 lex = (LEX *) 0x8a96e34 #23 0x0815f22e in dispatch_command (command=145321464, thd=0x8a96df8, packet=0x8a9dff9 "", packet_length=145383464) at sql_parse.cc:1697 packet_end = 0x8aa60b5 "" net = (NET *) 0x8a975bc error = false #24 0x0815ed59 in do_command (thd=0x8a96df8) at sql_parse.cc:1498 packet = 0x0 old_timeout = 30 packet_length = 2686443716 net = (NET *) 0x8a975bc command = 3046654976 #25 0x0815e213 in handle_one_connection (arg=0x0) at sql_parse.cc:1143 error = 0 net = (NET *) 0x8a975bc sctx = (Security_context *) 0x8a97d5c thd = (class THD *) 0x8a96df8 set = {__val = {0 }} #26 0xb75a5dec in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. #27 0xb7423e8a in clone () from /lib/tls/libc.so.6 No symbol table info available. (gdb) info threads 14 Thread -1608717392 (LWP 29689) 0x08301edd in rec_copy_prefix_to_buf (rec=0x8a27c48 "", index=0x8a27c48, n_fields=1783, buf=0x0, buf_size=0xa01cd7f0) at rem0rec.c:1129 * 13 Thread -1608516688 (LWP 29673) 0x0830182c in rec_get_offsets_func (rec=0xb61658b1 "\200\0011£", index=0x0, offsets=0x8219b574, n_fields=2686443716, heap=0xa01fe0c4, file=0x83cada0 "btr0sea.c", line=978) at rem0rec.c:324 12 Thread -1607222352 (LWP 29655) 0xb75a81fb in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/libpthread.so.0 11 Thread -1607021648 (LWP 29654) 0xb75aa941 in __read_nocancel () from /lib/tls/libpthread.so.0 10 Thread -1606820944 (LWP 29653) 0xb75aba24 in sigwait () from /lib/tls/libpthread.so.0 9 Thread -1327891536 (LWP 29652) 0xb741d337 in ___newselect_nocancel () from /lib/tls/libc.so.6 8 Thread -1317401680 (LWP 29651) 0xb741d337 in ___newselect_nocancel () from /lib/tls/libc.so.6 7 Thread -1306911824 (LWP 29650) 0xb741d337 in ___newselect_nocancel () from /lib/tls/libc.so.6 5 Thread -1281152080 (LWP 29648) 0xb75a81fb in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/libpthread.so.0 4 Thread -1270662224 (LWP 29647) 0xb75a81fb in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/libpthread.so.0 3 Thread -1260172368 (LWP 29646) 0xb75a81fb in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/libpthread.so.0 2 Thread -1249682512 (LWP 29645) 0xb75a81fb in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/libpthread.so.0 1 Thread -1221304192 (LWP 29642) 0xb741d337 in ___newselect_nocancel () from /lib/tls/libc.so.6