[New LWP 76287] [New LWP 76290] [New LWP 76291] [New LWP 76292] [New LWP 76293] [New LWP 76294] [New LWP 76295] [New LWP 76296] [New LWP 76297] [New LWP 76299] [New LWP 76300] [New LWP 76301] [New LWP 76302] [New LWP 76303] [New LWP 76304] [New LWP 76305] [New LWP 76306] [New LWP 76307] [New LWP 76308] [New LWP 76309] [New LWP 76310] [New LWP 76312] [New LWP 76326] [New LWP 76327] [New LWP 76328] [New LWP 76329] [New LWP 76330] [New LWP 76331] [New LWP 76332] [New LWP 76334] [New LWP 76335] To enable execution of this file add add-auto-load-safe-path /opt/at10.0/lib64/power8/libthread_db-1.0.so line to your configuration file "/home/mariadb/.gdbinit". To completely disable this security protection add set auto-load safe-path / line to your configuration file "/home/mariadb/.gdbinit". For more information about this security protection see the "Auto-loading safe path" section in the GDB manual. E.g., run from the shell: info "(gdb)Auto-loading safe path" 0x00003fff90623878 in poll () from /opt/at10.0/lib64/power8/libc.so.6 Thread 32 (LWP 76335): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x1002ed73910) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x1002ed73910, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042d9bad4 in sync_array_wait_event (arr=0x100216f4e00, cell=@0x3ff80fc319c0: 0x100216f4f80) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0arr.cc:490 #5 0x0000000042d9f844 in rw_lock_x_lock_wait_func (line=3120, file_name=0x432e7d88 "/home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc", threshold=0, lock=0x3ffd345d4bc8) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:518 #6 rw_lock_x_lock_low (line=, file_name=, pass=, lock=0x3ffd345d4bc8) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:591 #7 rw_lock_x_lock_func (lock=0x3ffd345d4bc8, pass=, file_name=0x432e7d88 "/home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc", line=3120) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:761 #8 0x0000000042e3b7c0 in pfs_rw_lock_x_lock_func (lock=, file_name=0x432e7d88 "/home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc", line=3120, pass=0) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:720 #9 0x0000000042e44528 in buf_page_get_gen (page_id=..., page_size=..., rw_latch=, guess=, mode=10, file=, line=, mtr=, err=, dirty_with_no_latch=) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0buf.cc:4779 #10 0x0000000042e1e5ec in btr_cur_search_to_nth_level (index=, level=, tuple=, mode=, latch_mode=, cursor=, has_search_latch=, file=, line=, mtr=) at /home/mariadb/svoj/mariadb/storage/innobase/btr/btr0cur.cc:1109 #11 0x0000000042e26ae4 in btr_pcur_open_with_no_init_func (has_search_latch=0, mtr=0x3ff80fc33980, line=3120, file=0x432e7d88 "/home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc", cursor=0x3ff7c800a2d0, latch_mode=, mode=, tuple=, index=0x3ff7c80380b0) at /home/mariadb/svoj/mariadb/storage/innobase/include/btr0pcur.ic:534 #12 btr_pcur_restore_position_func (latch_mode=, cursor=0x3ff7c800a2d0, file=0x432e7d88 "/home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc", line=3120, mtr=0x3ff80fc33980) at /home/mariadb/svoj/mariadb/storage/innobase/btr/btr0pcur.cc:368 #13 0x0000000042d78614 in row_upd_clust_step (node=0x3ff7c8009730, thr=0x3ff7c8009ab0) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc:3120 #14 0x0000000042d7b498 in row_upd (node=0x3ff7c8009730, thr=0x3ff7c8009ab0) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc:3298 #15 0x0000000042d7b85c in row_upd_step (thr=0x3ff7c8009ab0) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc:3444 #16 0x0000000042d40674 in row_update_for_mysql_using_upd_graph (prebuilt=0x3ff7c8008ee0, mysql_rec=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0mysql.cc:2589 #17 0x0000000042d433bc in row_update_for_mysql (mysql_rec=, prebuilt=0x3ff7c8008ee0) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0mysql.cc:2802 #18 0x0000000042c4a12c in ha_innobase::update_row (this=, old_row=, new_row=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:9919 #19 0x0000000042a37ca4 in handler::ha_update_row (this=0x3ff7c8008710, old_data=0x3ff7c8006cc0 "\377\265&", new_data=0x3ff7c8006c00 "\377\265&") at /home/mariadb/svoj/mariadb/sql/handler.cc:5955 #20 0x00000000428d8234 in mysql_update (thd=0x3ff7ac0009a8, table_list=, fields=..., values=..., conds=, order_num=, order=, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x3ff80fc34f10, updated_return=0x3ff80fc34fb8) at /home/mariadb/svoj/mariadb/sql/sql_update.cc:814 #21 0x00000000428253b0 in mysql_execute_command (thd=0x3ff7ac0009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:4178 #22 0x000000004282b70c in mysql_parse (thd=0x3ff7ac0009a8, rawbuf=0x3ff7ac00ef00 "UPDATE sbtest1 SET k=k+1 WHERE id=9909", length=, parser_state=0x3ff80fc36540, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:7799 #23 0x000000004282e58c in dispatch_command (command=, thd=, packet=, packet_length=, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1808 #24 0x000000004282ef4c in do_command (thd=0x3ff7ac0009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1367 #25 0x000000004291bd84 in do_handle_one_connection (connect=) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1354 #26 0x000000004291bfe4 in handle_one_connection (arg=0x1004c141d68) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1260 #27 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #28 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 31 (LWP 76334): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x1002ae34400) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x1002ae34400, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042d9bad4 in sync_array_wait_event (arr=0x100216f4e00, cell=@0x3ff80fc92328: 0x100216f4e80) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0arr.cc:490 #5 0x0000000042d9f13c in rw_lock_s_lock_spin (lock=0x3ffde1a37148, pass=, file_name=0x432f1890 "/home/mariadb/svoj/mariadb/storage/innobase/include/trx0undo.ic", line=191) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:432 #6 0x0000000042e3bb6c in rw_lock_s_lock_func (pass=0, line=191, file_name=0x432f1890 "/home/mariadb/svoj/mariadb/storage/innobase/include/trx0undo.ic", lock=0x3ffde1a37148) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:426 #7 pfs_rw_lock_s_lock_func (lock=0x3ffde1a37148, file_name=0x432f1890 "/home/mariadb/svoj/mariadb/storage/innobase/include/trx0undo.ic", line=191, pass=0) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:813 #8 0x0000000042e44be4 in buf_page_get_gen (page_id=..., page_size=..., rw_latch=, guess=, mode=10, file=, line=, mtr=, err=, dirty_with_no_latch=) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0buf.cc:4766 #9 0x0000000042dc3794 in trx_undo_page_get_s_latched (mtr=0x3ff80fc92780, page_size=..., page_id=...) at /home/mariadb/svoj/mariadb/storage/innobase/include/trx0undo.ic:190 #10 trx_undo_get_undo_rec_low (roll_ptr=16607023659101738, heap=0x3ff7a8897f80, is_redo_rseg=true) at /home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc:2136 #11 0x0000000042dc3eb4 in trx_undo_get_undo_rec (undo_rec=, name=..., is_redo_rseg=true, heap=0x3ff7a8897f80, trx_id=, roll_ptr=16607023659101738) at /home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc:2176 #12 trx_undo_prev_version_build (index_rec=, index_mtr=, rec=0x3ffd34a30e2b "", index=0x3ff7c80380b0, offsets=0x3ff80fc93028, heap=0x3ff7a8897f80, old_vers=0x3ff80fc92e58, v_heap=0x0, vrow=, v_status=) at /home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc:2266 #13 0x0000000042d7f5d0 in row_vers_build_for_consistent_read (rec=0x3ffd34a30e2b "", mtr=0x3ff80fc93dc0, index=0x3ff7c80380b0, offsets=0x3ff80fc92fe8, view=0x1004bd8fe70, offset_heap=0x3ff80fc92fe0, in_heap=0x3ff7c8009f90, old_vers=0x3ff80fc93348, vrow=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0vers.cc:1169 #14 0x0000000042d63bfc in row_sel_build_prev_vers_for_mysql (mtr=0x3ff80fc93dc0, vrow=0x0, old_vers=, offset_heap=0x3ff80fc92fe0, offsets=, rec=0x3ffd34a30e2b "", prebuilt=0x3ff7b8017690, clust_index=0x3ff7c80380b0, read_view=0x1004bd8fe70) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc:3364 #15 row_search_mvcc (buf=0x3ff7b8006030 "\377\257&", mode=PAGE_CUR_GE, prebuilt=0x3ff7b8017690, match_mode=0, direction=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc:5466 #16 0x0000000042c4665c in ha_innobase::general_fetch (this=0x3ff7b8016ad0, buf=0x3ff7b8006030 "\377\257&", direction=, match_mode=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:10768 #17 0x0000000042a306e0 in handler::ha_index_next (this=0x3ff7b8016ad0, buf=0x3ff7b8006030 "\377\257&") at /home/mariadb/svoj/mariadb/sql/handler.cc:2665 #18 0x0000000042a36680 in handler::read_range_next (this=) at /home/mariadb/svoj/mariadb/sql/handler.cc:5332 #19 0x000000004295eb64 in handler::multi_range_read_next (this=, range_info=) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:257 #20 0x000000004295ebfc in Mrr_simple_index_reader::get_next (this=0x3ff7b8017038, range_info=0x3ff80fc945b8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:322 #21 0x0000000042960838 in DsMrr_impl::dsmrr_next (this=0x3ff7b8016ef8, range_info=0x3ff80fc945b8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:1408 #22 0x0000000042c2f0f4 in ha_innobase::multi_range_read_next (this=, range_info=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:23948 #23 0x0000000042b82e50 in QUICK_RANGE_SELECT::get_next (this=0x3ff7a889b330) at /home/mariadb/svoj/mariadb/sql/opt_range.cc:11179 #24 0x0000000042ba4990 in rr_quick (info=0x3ff7a8011730) at /home/mariadb/svoj/mariadb/sql/records.cc:353 #25 0x0000000042863dc4 in sub_select (join=0x3ff7a800fda0, join_tab=0x3ff7a8011668, end_of_records=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:18358 #26 0x0000000042886b70 in do_select (procedure=, join=0x3ff7a800fda0) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:17883 #27 JOIN::exec_inner (this=0x3ff7a800fda0) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3373 #28 0x0000000042886d70 in JOIN::exec (this=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3184 #29 0x0000000042886f58 in mysql_select (thd=0x3ff7a80009a8, tables=, wild_num=, fields=..., conds=0x3ff7a800fb68, og_num=, order=0x0, group=, having=0x0, proc_param=0x0, select_options=2148797184, result=0x3ff7a800fd80, unit=0x3ff7a8004340, select_lex=0x3ff7a8004a78) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3569 #30 0x00000000428876a0 in handle_select (thd=0x3ff7a80009a8, lex=0x3ff7a8004278, result=0x3ff7a800fd80, setup_tables_done_option=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:361 #31 0x000000004281a764 in execute_sqlcom_select (thd=0x3ff7a80009a8, all_tables=0x3ff7a800f318) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:6356 #32 0x0000000042827f44 in mysql_execute_command (thd=0x3ff7a80009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:3379 #33 0x000000004282b70c in mysql_parse (thd=0x3ff7a80009a8, rawbuf=0x3ff7a800ef00 "SELECT SUM(K) FROM sbtest1 WHERE id BETWEEN 9899 AND 9998", length=, parser_state=0x3ff80fc96540, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:7799 #34 0x000000004282e58c in dispatch_command (command=, thd=, packet=, packet_length=, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1808 #35 0x000000004282ef4c in do_command (thd=0x3ff7a80009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1367 #36 0x000000004291bd84 in do_handle_one_connection (connect=) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1354 #37 0x000000004291bfe4 in handle_one_connection (arg=0x1004c115b08) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1260 #38 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #39 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 30 (LWP 76332): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x1004bdca220) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x1004bdca220, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042d9bad4 in sync_array_wait_event (arr=0x100216f4e00, cell=@0x3ff80fcf2bf8: 0x100216f4ec0) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0arr.cc:490 #5 0x0000000042d9f13c in rw_lock_s_lock_spin (lock=0x1004bdc9f70, pass=, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:432 #6 0x0000000042dc43ac in rw_lock_s_lock_func (pass=0, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172, lock=0x1004bdc9f70) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:426 #7 pfs_rw_lock_s_lock_func (pass=0, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172, lock=0x1004bdc9f70) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:813 #8 trx_undo_get_undo_rec (undo_rec=, name=..., is_redo_rseg=true, heap=0x3ff7b4618320, trx_id=2498331, roll_ptr=19140298445883160) at /home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc:2172 #9 trx_undo_prev_version_build (index_rec=, index_mtr=, rec=0x3ffd6e645163 "", index=0x3ff7c80380b0, offsets=0x3ff80fcf3028, heap=0x3ff7b4618320, old_vers=0x3ff80fcf2e58, v_heap=0x0, vrow=, v_status=) at /home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc:2266 #10 0x0000000042d7f5d0 in row_vers_build_for_consistent_read (rec=0x3ffd6e645163 "", mtr=0x3ff80fcf3dc0, index=0x3ff7c80380b0, offsets=0x3ff80fcf2fe8, view=0x1004bd90ec0, offset_heap=0x3ff80fcf2fe0, in_heap=0x3ff7c0019330, old_vers=0x3ff80fcf3348, vrow=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0vers.cc:1169 #11 0x0000000042d63bfc in row_sel_build_prev_vers_for_mysql (mtr=0x3ff80fcf3dc0, vrow=0x0, old_vers=, offset_heap=0x3ff80fcf2fe0, offsets=, rec=0x3ffd6e645163 "", prebuilt=0x3ff7c4017690, clust_index=0x3ff7c80380b0, read_view=0x1004bd90ec0) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc:3364 #12 row_search_mvcc (buf=0x3ff7c4006030 "", mode=PAGE_CUR_GE, prebuilt=0x3ff7c4017690, match_mode=0, direction=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc:5466 #13 0x0000000042c4665c in ha_innobase::general_fetch (this=0x3ff7c4016ad0, buf=0x3ff7c4006030 "", direction=, match_mode=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:10768 #14 0x0000000042a306e0 in handler::ha_index_next (this=0x3ff7c4016ad0, buf=0x3ff7c4006030 "") at /home/mariadb/svoj/mariadb/sql/handler.cc:2665 #15 0x0000000042a36680 in handler::read_range_next (this=) at /home/mariadb/svoj/mariadb/sql/handler.cc:5332 #16 0x000000004295eb64 in handler::multi_range_read_next (this=, range_info=) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:257 #17 0x000000004295ebfc in Mrr_simple_index_reader::get_next (this=0x3ff7c4017038, range_info=0x3ff80fcf45b8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:322 #18 0x0000000042960838 in DsMrr_impl::dsmrr_next (this=0x3ff7c4016ef8, range_info=0x3ff80fcf45b8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:1408 #19 0x0000000042c2f0f4 in ha_innobase::multi_range_read_next (this=, range_info=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:23948 #20 0x0000000042b82e50 in QUICK_RANGE_SELECT::get_next (this=0x3ff7b4618ec0) at /home/mariadb/svoj/mariadb/sql/opt_range.cc:11179 #21 0x0000000042ba4990 in rr_quick (info=0x3ff7b40114e8) at /home/mariadb/svoj/mariadb/sql/records.cc:353 #22 0x0000000042863dc4 in sub_select (join=0x3ff7b400fbb0, join_tab=0x3ff7b4011420, end_of_records=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:18358 #23 0x0000000042886b70 in do_select (procedure=, join=0x3ff7b400fbb0) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:17883 #24 JOIN::exec_inner (this=0x3ff7b400fbb0) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3373 #25 0x0000000042886d70 in JOIN::exec (this=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3184 #26 0x0000000042886f58 in mysql_select (thd=0x3ff7b40009a8, tables=, wild_num=, fields=..., conds=0x3ff7b400f978, og_num=, order=0x0, group=, having=0x0, proc_param=0x0, select_options=2148797184, result=0x3ff7b400fb90, unit=0x3ff7b4004340, select_lex=0x3ff7b4004a78) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3569 #27 0x00000000428876a0 in handle_select (thd=0x3ff7b40009a8, lex=0x3ff7b4004278, result=0x3ff7b400fb90, setup_tables_done_option=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:361 #28 0x000000004281a764 in execute_sqlcom_select (thd=0x3ff7b40009a8, all_tables=0x3ff7b400f128) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:6356 #29 0x0000000042827f44 in mysql_execute_command (thd=0x3ff7b40009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:3379 #30 0x000000004282b70c in mysql_parse (thd=0x3ff7b40009a8, rawbuf=0x3ff7b400ef00 "SELECT c FROM sbtest1 WHERE id BETWEEN 4969 AND 5068", length=, parser_state=0x3ff80fcf6540, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:7799 #31 0x000000004282e58c in dispatch_command (command=, thd=, packet=, packet_length=, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1808 #32 0x000000004282ef4c in do_command (thd=0x3ff7b40009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1367 #33 0x000000004291bd84 in do_handle_one_connection (connect=) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1354 #34 0x000000004291bfe4 in handle_one_connection (arg=0x1004c115b08) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1260 #35 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #36 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 29 (LWP 76331): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x1004bdca220) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x1004bdca220, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042d9bad4 in sync_array_wait_event (arr=0x100216f4e00, cell=@0x3ff80fd526e8: 0x100216f5180) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0arr.cc:490 #5 0x0000000042d9f13c in rw_lock_s_lock_spin (lock=0x1004bdc9f70, pass=, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:432 #6 0x0000000042dc43ac in rw_lock_s_lock_func (pass=0, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172, lock=0x1004bdc9f70) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:426 #7 pfs_rw_lock_s_lock_func (pass=0, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172, lock=0x1004bdc9f70) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:813 #8 trx_undo_get_undo_rec (undo_rec=, name=..., is_redo_rseg=true, heap=0x3ff7b0886930, trx_id=2498331, roll_ptr=19140298445882713) at /home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc:2172 #9 trx_undo_prev_version_build (index_rec=, index_mtr=, rec=0x3ffd6e5c2f29 "", index=0x3ff7c80380b0, offsets=0x3ff80fd52b18, heap=0x3ff7b0886930, old_vers=0x3ff80fd52948, v_heap=0x0, vrow=, v_status=) at /home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc:2266 #10 0x0000000042d7f5d0 in row_vers_build_for_consistent_read (rec=0x3ffd6e5c2f29 "", mtr=0x3ff80fd538b0, index=0x3ff7c80380b0, offsets=0x3ff80fd52ad8, view=0x1004bd90c80, offset_heap=0x3ff80fd52ad0, in_heap=0x3ff7ac017170, old_vers=0x3ff80fd52e38, vrow=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0vers.cc:1169 #11 0x0000000042d63bfc in row_sel_build_prev_vers_for_mysql (mtr=0x3ff80fd538b0, vrow=0x0, old_vers=, offset_heap=0x3ff80fd52ad0, offsets=, rec=0x3ffd6e5c2f29 "", prebuilt=0x3ff7bc017690, clust_index=0x3ff7c80380b0, read_view=0x1004bd90c80) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc:3364 #12 row_search_mvcc (buf=0x3ff7bc006030 "", mode=PAGE_CUR_GE, prebuilt=0x3ff7bc017690, match_mode=0, direction=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc:5466 #13 0x0000000042c4665c in ha_innobase::general_fetch (this=0x3ff7bc016ad0, buf=0x3ff7bc006030 "", direction=, match_mode=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:10768 #14 0x0000000042a306e0 in handler::ha_index_next (this=0x3ff7bc016ad0, buf=0x3ff7bc006030 "") at /home/mariadb/svoj/mariadb/sql/handler.cc:2665 #15 0x0000000042a36680 in handler::read_range_next (this=) at /home/mariadb/svoj/mariadb/sql/handler.cc:5332 #16 0x000000004295eb64 in handler::multi_range_read_next (this=, range_info=) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:257 #17 0x000000004295ebfc in Mrr_simple_index_reader::get_next (this=0x3ff7bc017038, range_info=0x3ff80fd540a8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:322 #18 0x0000000042960838 in DsMrr_impl::dsmrr_next (this=0x3ff7bc016ef8, range_info=0x3ff80fd540a8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:1408 #19 0x0000000042c2f0f4 in ha_innobase::multi_range_read_next (this=, range_info=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:23948 #20 0x0000000042b82e50 in QUICK_RANGE_SELECT::get_next (this=0x3ff7b08816d0) at /home/mariadb/svoj/mariadb/sql/opt_range.cc:11179 #21 0x0000000042a27f2c in find_all_keys (found_rows=0x3ff7b0887200, pq=0x0, tempfile=0x3ff80fd54298, buffpek_pointers=0x3ff80fd54398, fs_info=0x3ff7b0887090, select=0x3ff7b0011ee0, param=0x3ff80fd54208, thd=0x3ff7b00009a8) at /home/mariadb/svoj/mariadb/sql/filesort.cc:785 #22 filesort (thd=0x3ff7b00009a8, table=0x3ff7bc015f48, filesort=, tracker=0x3ff7b0012818, join=, first_table_bit=) at /home/mariadb/svoj/mariadb/sql/filesort.cc:279 #23 0x00000000428747e4 in create_sort_index (thd=0x3ff7b00009a8, join=0x3ff7b000fd18, tab=0x3ff7b0011600, fsort=0x3ff7b0012040) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:21467 #24 0x0000000042874b20 in st_join_table::sort_table (this=0x3ff7b0011600) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:19304 #25 0x0000000042874bc8 in join_init_read_record (tab=0x3ff7b0011600) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:19251 #26 0x0000000042863d44 in sub_select (join=0x3ff7b000fd18, join_tab=0x3ff7b0011600, end_of_records=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:18336 #27 0x0000000042886b70 in do_select (procedure=, join=0x3ff7b000fd18) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:17883 #28 JOIN::exec_inner (this=0x3ff7b000fd18) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3373 #29 0x0000000042886d70 in JOIN::exec (this=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3184 #30 0x0000000042886f58 in mysql_select (thd=0x3ff7b00009a8, tables=, wild_num=, fields=..., conds=0x3ff7b000f988, og_num=, order=0x3ff7b000fbe8, group=, having=0x0, proc_param=0x0, select_options=2148797184, result=0x3ff7b000fcf8, unit=0x3ff7b0004340, select_lex=0x3ff7b0004a78) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3569 #31 0x00000000428876a0 in handle_select (thd=0x3ff7b00009a8, lex=0x3ff7b0004278, result=0x3ff7b000fcf8, setup_tables_done_option=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:361 #32 0x000000004281a764 in execute_sqlcom_select (thd=0x3ff7b00009a8, all_tables=0x3ff7b000f138) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:6356 #33 0x0000000042827f44 in mysql_execute_command (thd=0x3ff7b00009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:3379 #34 0x000000004282b70c in mysql_parse (thd=0x3ff7b00009a8, rawbuf=0x3ff7b000ef00 "SELECT c FROM sbtest1 WHERE id BETWEEN 2570 AND 2669 ORDER BY c", length=, parser_state=0x3ff80fd56540, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:7799 #35 0x000000004282e58c in dispatch_command (command=, thd=, packet=, packet_length=, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1808 #36 0x000000004282ef4c in do_command (thd=0x3ff7b00009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1367 #37 0x000000004291bd84 in do_handle_one_connection (connect=) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1354 #38 0x000000004291bfe4 in handle_one_connection (arg=0x1004c141d68) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1260 #39 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #40 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 28 (LWP 76330): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x1002ed73890) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x1002ed73890, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042d9bad4 in sync_array_wait_event (arr=0x100216f4e00, cell=@0x3ff80fdb1dd8: 0x100216f5040) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0arr.cc:490 #5 0x0000000042d9f13c in rw_lock_s_lock_spin (lock=0x3ffd345d4bc8, pass=, file_name=0x432e6ea8 "/home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc", line=4995) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:432 #6 0x0000000042e3bb6c in rw_lock_s_lock_func (pass=0, line=4995, file_name=0x432e6ea8 "/home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc", lock=0x3ffd345d4bc8) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:426 #7 pfs_rw_lock_s_lock_func (lock=0x3ffd345d4bc8, file_name=0x432e6ea8 "/home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc", line=4995, pass=0) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:813 #8 0x0000000042e44be4 in buf_page_get_gen (page_id=..., page_size=..., rw_latch=, guess=, mode=10, file=, line=, mtr=, err=, dirty_with_no_latch=) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0buf.cc:4766 #9 0x0000000042e1e5ec in btr_cur_search_to_nth_level (index=, level=, tuple=, mode=, latch_mode=, cursor=, has_search_latch=, file=, line=, mtr=) at /home/mariadb/svoj/mariadb/storage/innobase/btr/btr0cur.cc:1109 #10 0x000000004274337c in btr_pcur_open_with_no_init_func (index=, tuple=, mode=PAGE_CUR_GE, cursor=0x3ff7c8031f88, has_search_latch=, line=4995, mtr=0x3ff80fdb4060, file=0x432e6ea8 "/home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc", latch_mode=1) at /home/mariadb/svoj/mariadb/storage/innobase/include/btr0pcur.ic:534 #11 0x0000000042d6221c in row_search_mvcc (buf=0x3ff7c8007290 "\377", mode=PAGE_CUR_GE, prebuilt=0x3ff7c8031d90, match_mode=1, direction=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc:4993 #12 0x0000000042c47798 in ha_innobase::index_read (this=0x3ff7c803b6a0, buf=0x3ff7c8007290 "\377", key_ptr=, key_len=, find_flag=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:10436 #13 0x0000000042a39c34 in handler::index_read_map (this=0x3ff7c803b6a0, buf=0x3ff7c8007290 "\377", key=0x3ff7bc619180 "\323&", keypart_map=, find_flag=) at /home/mariadb/svoj/mariadb/sql/handler.h:3073 #14 0x0000000042a301ec in handler::ha_index_read_map (this=0x3ff7c803b6a0, buf=0x3ff7c8007290 "\377", key=0x3ff7bc619180 "\323&", keypart_map=1, find_flag=) at /home/mariadb/svoj/mariadb/sql/handler.cc:2621 #15 0x0000000042a36548 in handler::read_range_first (this=0x3ff7c803b6a0, start_key=0x3ff7c803b788, end_key=, eq_range_arg=, sorted=) at /home/mariadb/svoj/mariadb/sql/handler.cc:5285 #16 0x000000004295eafc in handler::multi_range_read_next (this=0x3ff7c803b6a0, range_info=0x3ff80fdb48d8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:285 #17 0x000000004295ebfc in Mrr_simple_index_reader::get_next (this=0x3ff7c803bc08, range_info=0x3ff80fdb48d8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:322 #18 0x0000000042960838 in DsMrr_impl::dsmrr_next (this=0x3ff7c803bac8, range_info=0x3ff80fdb48d8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:1408 #19 0x0000000042c2f0f4 in ha_innobase::multi_range_read_next (this=, range_info=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:23948 #20 0x0000000042b82e50 in QUICK_RANGE_SELECT::get_next (this=0x3ff7bc6109e0) at /home/mariadb/svoj/mariadb/sql/opt_range.cc:11179 #21 0x0000000042ba4990 in rr_quick (info=0x3ff80fdb4a80) at /home/mariadb/svoj/mariadb/sql/records.cc:353 #22 0x00000000428d7a54 in mysql_update (thd=0x3ff7bc0009a8, table_list=, fields=..., values=..., conds=, order_num=, order=, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x3ff80fdb4f10, updated_return=0x3ff80fdb4fb8) at /home/mariadb/svoj/mariadb/sql/sql_update.cc:737 #23 0x00000000428253b0 in mysql_execute_command (thd=0x3ff7bc0009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:4178 #24 0x000000004282b70c in mysql_parse (thd=0x3ff7bc0009a8, rawbuf=0x3ff7bc00ef00 "UPDATE sbtest1 SET c='37275156844-08289605527-27566576513-09012921038-84650308769-30211936952-96140839866-48437103911-96854945337-44304176159' WHERE id=9939", length=, parser_state=0x3ff80fdb6540, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:7799 #25 0x000000004282e58c in dispatch_command (command=, thd=, packet=, packet_length=, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1808 #26 0x000000004282ef4c in do_command (thd=0x3ff7bc0009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1367 #27 0x000000004291bd84 in do_handle_one_connection (connect=) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1354 #28 0x000000004291bfe4 in handle_one_connection (arg=0x1004c115b08) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1260 #29 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #30 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 27 (LWP 76329): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x1004bdca220) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x1004bdca220, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042d9bad4 in sync_array_wait_event (arr=0x100216f4e00, cell=@0x3ff80fe126e8: 0x100216f4fc0) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0arr.cc:490 #5 0x0000000042d9f13c in rw_lock_s_lock_spin (lock=0x1004bdc9f70, pass=, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:432 #6 0x0000000042dc43ac in rw_lock_s_lock_func (pass=0, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172, lock=0x1004bdc9f70) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:426 #7 pfs_rw_lock_s_lock_func (pass=0, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172, lock=0x1004bdc9f70) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:813 #8 trx_undo_get_undo_rec (undo_rec=, name=..., is_redo_rseg=true, heap=0x3ff7b8892da0, trx_id=2498331, roll_ptr=19140298445882274) at /home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc:2172 #9 trx_undo_prev_version_build (index_rec=, index_mtr=, rec=0x3ffda8249569 "", index=0x3ff7c80380b0, offsets=0x3ff80fe12b18, heap=0x3ff7b8892da0, old_vers=0x3ff80fe12948, v_heap=0x0, vrow=, v_status=) at /home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc:2266 #10 0x0000000042d7f5d0 in row_vers_build_for_consistent_read (rec=0x3ffda8249569 "", mtr=0x3ff80fe138b0, index=0x3ff7c80380b0, offsets=0x3ff80fe12ad8, view=0x1004bd90380, offset_heap=0x3ff80fe12ad0, in_heap=0x3ff7c8046a20, old_vers=0x3ff80fe12e38, vrow=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0vers.cc:1169 #11 0x0000000042d63bfc in row_sel_build_prev_vers_for_mysql (mtr=0x3ff80fe138b0, vrow=0x0, old_vers=, offset_heap=0x3ff80fe12ad0, offsets=, rec=0x3ffda8249569 "", prebuilt=0x3ff7c0017690, clust_index=0x3ff7c80380b0, read_view=0x1004bd90380) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc:3364 #12 row_search_mvcc (buf=0x3ff7c0006030 "\377\032", mode=PAGE_CUR_GE, prebuilt=0x3ff7c0017690, match_mode=0, direction=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc:5466 #13 0x0000000042c4665c in ha_innobase::general_fetch (this=0x3ff7c0016ad0, buf=0x3ff7c0006030 "\377\032", direction=, match_mode=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:10768 #14 0x0000000042a306e0 in handler::ha_index_next (this=0x3ff7c0016ad0, buf=0x3ff7c0006030 "\377\032") at /home/mariadb/svoj/mariadb/sql/handler.cc:2665 #15 0x0000000042a36680 in handler::read_range_next (this=) at /home/mariadb/svoj/mariadb/sql/handler.cc:5332 #16 0x000000004295eb64 in handler::multi_range_read_next (this=, range_info=) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:257 #17 0x000000004295ebfc in Mrr_simple_index_reader::get_next (this=0x3ff7c0017038, range_info=0x3ff80fe140a8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:322 #18 0x0000000042960838 in DsMrr_impl::dsmrr_next (this=0x3ff7c0016ef8, range_info=0x3ff80fe140a8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:1408 #19 0x0000000042c2f0f4 in ha_innobase::multi_range_read_next (this=, range_info=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:23948 #20 0x0000000042b82e50 in QUICK_RANGE_SELECT::get_next (this=0x3ff7b8889c60) at /home/mariadb/svoj/mariadb/sql/opt_range.cc:11179 #21 0x0000000042a27f2c in find_all_keys (found_rows=0x3ff7b8887630, pq=0x0, tempfile=0x3ff80fe14298, buffpek_pointers=0x3ff80fe14398, fs_info=0x3ff7b88874c0, select=0x3ff7b8011ee0, param=0x3ff80fe14208, thd=0x3ff7b80009a8) at /home/mariadb/svoj/mariadb/sql/filesort.cc:785 #22 filesort (thd=0x3ff7b80009a8, table=0x3ff7c0015f48, filesort=, tracker=0x3ff7b8012818, join=, first_table_bit=) at /home/mariadb/svoj/mariadb/sql/filesort.cc:279 #23 0x00000000428747e4 in create_sort_index (thd=0x3ff7b80009a8, join=0x3ff7b800fd18, tab=0x3ff7b8011600, fsort=0x3ff7b8012040) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:21467 #24 0x0000000042874b20 in st_join_table::sort_table (this=0x3ff7b8011600) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:19304 #25 0x0000000042874bc8 in join_init_read_record (tab=0x3ff7b8011600) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:19251 #26 0x0000000042863d44 in sub_select (join=0x3ff7b800fd18, join_tab=0x3ff7b8011600, end_of_records=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:18336 #27 0x0000000042886b70 in do_select (procedure=, join=0x3ff7b800fd18) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:17883 #28 JOIN::exec_inner (this=0x3ff7b800fd18) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3373 #29 0x0000000042886d70 in JOIN::exec (this=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3184 #30 0x0000000042886f58 in mysql_select (thd=0x3ff7b80009a8, tables=, wild_num=, fields=..., conds=0x3ff7b800f988, og_num=, order=0x3ff7b800fbe8, group=, having=0x0, proc_param=0x0, select_options=2148797184, result=0x3ff7b800fcf8, unit=0x3ff7b8004340, select_lex=0x3ff7b8004a78) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3569 #31 0x00000000428876a0 in handle_select (thd=0x3ff7b80009a8, lex=0x3ff7b8004278, result=0x3ff7b800fcf8, setup_tables_done_option=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:361 #32 0x000000004281a764 in execute_sqlcom_select (thd=0x3ff7b80009a8, all_tables=0x3ff7b800f138) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:6356 #33 0x0000000042827f44 in mysql_execute_command (thd=0x3ff7b80009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:3379 #34 0x000000004282b70c in mysql_parse (thd=0x3ff7b80009a8, rawbuf=0x3ff7b800ef00 "SELECT c FROM sbtest1 WHERE id BETWEEN 24 AND 123 ORDER BY c", length=, parser_state=0x3ff80fe16540, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:7799 #35 0x000000004282e58c in dispatch_command (command=, thd=, packet=, packet_length=, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1808 #36 0x000000004282ef4c in do_command (thd=0x3ff7b80009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1367 #37 0x000000004291bd84 in do_handle_one_connection (connect=) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1354 #38 0x000000004291bfe4 in handle_one_connection (arg=0x1004c112fb8) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1260 #39 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #40 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 26 (LWP 76328): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x1004bdca220) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x1004bdca220, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042d9bad4 in sync_array_wait_event (arr=0x100216f4e00, cell=@0x3ff80fe72bf8: 0x100216f4f40) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0arr.cc:490 #5 0x0000000042d9f13c in rw_lock_s_lock_spin (lock=0x1004bdc9f70, pass=, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:432 #6 0x0000000042dc43ac in rw_lock_s_lock_func (pass=0, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172, lock=0x1004bdc9f70) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:426 #7 pfs_rw_lock_s_lock_func (pass=0, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172, lock=0x1004bdc9f70) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:813 #8 trx_undo_get_undo_rec (undo_rec=, name=..., is_redo_rseg=true, heap=0x3ff7c46138e0, trx_id=2498314, roll_ptr=16888498635877936) at /home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc:2172 #9 trx_undo_prev_version_build (index_rec=, index_mtr=, rec=0x3ffd6e6047bb "", index=0x3ff7c80380b0, offsets=0x3ff80fe73028, heap=0x3ff7c46138e0, old_vers=0x3ff80fe72e58, v_heap=0x0, vrow=, v_status=) at /home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc:2266 #10 0x0000000042d7f5d0 in row_vers_build_for_consistent_read (rec=0x3ffd6e6047bb "", mtr=0x3ff80fe73dc0, index=0x3ff7c80380b0, offsets=0x3ff80fe72fe8, view=0x1004bd8f7b0, offset_heap=0x3ff80fe72fe0, in_heap=0x3ff7ac018160, old_vers=0x3ff80fe73348, vrow=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0vers.cc:1169 #11 0x0000000042d63bfc in row_sel_build_prev_vers_for_mysql (mtr=0x3ff80fe73dc0, vrow=0x0, old_vers=, offset_heap=0x3ff80fe72fe0, offsets=, rec=0x3ffd6e6047bb "", prebuilt=0x3ff7a8017690, clust_index=0x3ff7c80380b0, read_view=0x1004bd8f7b0) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc:3364 #12 row_search_mvcc (buf=0x3ff7a8006030 "", mode=PAGE_CUR_GE, prebuilt=0x3ff7a8017690, match_mode=0, direction=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc:5466 #13 0x0000000042c4665c in ha_innobase::general_fetch (this=0x3ff7a8016ad0, buf=0x3ff7a8006030 "", direction=, match_mode=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:10768 #14 0x0000000042a306e0 in handler::ha_index_next (this=0x3ff7a8016ad0, buf=0x3ff7a8006030 "") at /home/mariadb/svoj/mariadb/sql/handler.cc:2665 #15 0x0000000042a36680 in handler::read_range_next (this=) at /home/mariadb/svoj/mariadb/sql/handler.cc:5332 #16 0x000000004295eb64 in handler::multi_range_read_next (this=, range_info=) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:257 #17 0x000000004295ebfc in Mrr_simple_index_reader::get_next (this=0x3ff7a8017038, range_info=0x3ff80fe745b8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:322 #18 0x0000000042960838 in DsMrr_impl::dsmrr_next (this=0x3ff7a8016ef8, range_info=0x3ff80fe745b8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:1408 #19 0x0000000042c2f0f4 in ha_innobase::multi_range_read_next (this=, range_info=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:23948 #20 0x0000000042b82e50 in QUICK_RANGE_SELECT::get_next (this=0x3ff7c46177e0) at /home/mariadb/svoj/mariadb/sql/opt_range.cc:11179 #21 0x0000000042ba4990 in rr_quick (info=0x3ff7c4011730) at /home/mariadb/svoj/mariadb/sql/records.cc:353 #22 0x0000000042863dc4 in sub_select (join=0x3ff7c400fda0, join_tab=0x3ff7c4011668, end_of_records=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:18358 #23 0x0000000042886b70 in do_select (procedure=, join=0x3ff7c400fda0) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:17883 #24 JOIN::exec_inner (this=0x3ff7c400fda0) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3373 #25 0x0000000042886d70 in JOIN::exec (this=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3184 #26 0x0000000042886f58 in mysql_select (thd=0x3ff7c40009a8, tables=, wild_num=, fields=..., conds=0x3ff7c400fb68, og_num=, order=0x0, group=, having=0x0, proc_param=0x0, select_options=2148797184, result=0x3ff7c400fd80, unit=0x3ff7c4004340, select_lex=0x3ff7c4004a78) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3569 #27 0x00000000428876a0 in handle_select (thd=0x3ff7c40009a8, lex=0x3ff7c4004278, result=0x3ff7c400fd80, setup_tables_done_option=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:361 #28 0x000000004281a764 in execute_sqlcom_select (thd=0x3ff7c40009a8, all_tables=0x3ff7c400f318) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:6356 #29 0x0000000042827f44 in mysql_execute_command (thd=0x3ff7c40009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:3379 #30 0x000000004282b70c in mysql_parse (thd=0x3ff7c40009a8, rawbuf=0x3ff7c400ef00 "SELECT SUM(K) FROM sbtest1 WHERE id BETWEEN 3775 AND 3874", length=, parser_state=0x3ff80fe76540, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:7799 #31 0x000000004282e58c in dispatch_command (command=, thd=, packet=, packet_length=, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1808 #32 0x000000004282ef4c in do_command (thd=0x3ff7c40009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1367 #33 0x000000004291bd84 in do_handle_one_connection (connect=) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1354 #34 0x000000004291bfe4 in handle_one_connection (arg=0x1004c115b08) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1260 #35 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #36 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 25 (LWP 76327): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x1002d85c180) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x1002d85c180, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042d9bad4 in sync_array_wait_event (arr=0x100216f4e00, cell=@0x3ff80fed19c0: 0x100216f5080) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0arr.cc:490 #5 0x0000000042d9f844 in rw_lock_x_lock_wait_func (line=3120, file_name=0x432e7d88 "/home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc", threshold=0, lock=0x3ffd6e1f2828) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:518 #6 rw_lock_x_lock_low (line=, file_name=, pass=, lock=0x3ffd6e1f2828) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:591 #7 rw_lock_x_lock_func (lock=0x3ffd6e1f2828, pass=, file_name=0x432e7d88 "/home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc", line=3120) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:761 #8 0x0000000042e3b7c0 in pfs_rw_lock_x_lock_func (lock=, file_name=0x432e7d88 "/home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc", line=3120, pass=0) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:720 #9 0x0000000042e44528 in buf_page_get_gen (page_id=..., page_size=..., rw_latch=, guess=, mode=10, file=, line=, mtr=, err=, dirty_with_no_latch=) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0buf.cc:4779 #10 0x0000000042e1e5ec in btr_cur_search_to_nth_level (index=, level=, tuple=, mode=, latch_mode=, cursor=, has_search_latch=, file=, line=, mtr=) at /home/mariadb/svoj/mariadb/storage/innobase/btr/btr0cur.cc:1109 #11 0x0000000042e26ae4 in btr_pcur_open_with_no_init_func (has_search_latch=0, mtr=0x3ff80fed3980, line=3120, file=0x432e7d88 "/home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc", cursor=0x3ff7c802b380, latch_mode=, mode=, tuple=, index=0x3ff7c80380b0) at /home/mariadb/svoj/mariadb/storage/innobase/include/btr0pcur.ic:534 #12 btr_pcur_restore_position_func (latch_mode=, cursor=0x3ff7c802b380, file=0x432e7d88 "/home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc", line=3120, mtr=0x3ff80fed3980) at /home/mariadb/svoj/mariadb/storage/innobase/btr/btr0pcur.cc:368 #13 0x0000000042d78614 in row_upd_clust_step (node=0x3ff7b0017ee0, thr=0x3ff7b0018260) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc:3120 #14 0x0000000042d7b498 in row_upd (node=0x3ff7b0017ee0, thr=0x3ff7b0018260) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc:3298 #15 0x0000000042d7b85c in row_upd_step (thr=0x3ff7b0018260) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc:3444 #16 0x0000000042d40674 in row_update_for_mysql_using_upd_graph (prebuilt=0x3ff7b0017690, mysql_rec=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0mysql.cc:2589 #17 0x0000000042d433bc in row_update_for_mysql (mysql_rec=, prebuilt=0x3ff7b0017690) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0mysql.cc:2802 #18 0x0000000042c4a12c in ha_innobase::update_row (this=, old_row=, new_row=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:9919 #19 0x0000000042a37ca4 in handler::ha_update_row (this=0x3ff7b0016ad0, old_data=0x3ff7b00060f0 "\377\371\016", new_data=0x3ff7b0006030 "\377\371\016") at /home/mariadb/svoj/mariadb/sql/handler.cc:5955 #20 0x00000000428d8234 in mysql_update (thd=0x3ff7c00009a8, table_list=, fields=..., values=..., conds=, order_num=, order=, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x3ff80fed4f10, updated_return=0x3ff80fed4fb8) at /home/mariadb/svoj/mariadb/sql/sql_update.cc:814 #21 0x00000000428253b0 in mysql_execute_command (thd=0x3ff7c00009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:4178 #22 0x000000004282b70c in mysql_parse (thd=0x3ff7c00009a8, rawbuf=0x3ff7c000ef00 "UPDATE sbtest1 SET k=k+1 WHERE id=3833", length=, parser_state=0x3ff80fed6540, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:7799 #23 0x000000004282e58c in dispatch_command (command=, thd=, packet=, packet_length=, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1808 #24 0x000000004282ef4c in do_command (thd=0x3ff7c00009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1367 #25 0x000000004291bd84 in do_handle_one_connection (connect=) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1354 #26 0x000000004291bfe4 in handle_one_connection (arg=0x1004c112fb8) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1260 #27 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #28 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 24 (LWP 76326): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x1004bdca220) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x1004bdca220, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042d9bad4 in sync_array_wait_event (arr=0x100216f4e00, cell=@0x3ff80ff32bf8: 0x100216f5000) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0arr.cc:490 #5 0x0000000042d9f13c in rw_lock_s_lock_spin (lock=0x1004bdc9f70, pass=, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:432 #6 0x0000000042dc43ac in rw_lock_s_lock_func (pass=0, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172, lock=0x1004bdc9f70) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:426 #7 pfs_rw_lock_s_lock_func (pass=0, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172, lock=0x1004bdc9f70) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:813 #8 trx_undo_get_undo_rec (undo_rec=, name=..., is_redo_rseg=true, heap=0x3ff7cc619310, trx_id=2498314, roll_ptr=16888498635878359) at /home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc:2172 #9 trx_undo_prev_version_build (index_rec=, index_mtr=, rec=0x3ffd349a0d5d "", index=0x3ff7c80380b0, offsets=0x3ff80ff33028, heap=0x3ff7cc619310, old_vers=0x3ff80ff32e58, v_heap=0x0, vrow=, v_status=) at /home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc:2266 #10 0x0000000042d7f5d0 in row_vers_build_for_consistent_read (rec=0x3ffd349a0d5d "", mtr=0x3ff80ff33dc0, index=0x3ff7c80380b0, offsets=0x3ff80ff32fe8, view=0x1004bd90bf0, offset_heap=0x3ff80ff32fe0, in_heap=0x3ff7b401aab0, old_vers=0x3ff80ff33348, vrow=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0vers.cc:1169 #11 0x0000000042d63bfc in row_sel_build_prev_vers_for_mysql (mtr=0x3ff80ff33dc0, vrow=0x0, old_vers=, offset_heap=0x3ff80ff32fe0, offsets=, rec=0x3ffd349a0d5d "", prebuilt=0x3ff7b4017690, clust_index=0x3ff7c80380b0, read_view=0x1004bd90bf0) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc:3364 #12 row_search_mvcc (buf=0x3ff7b4006030 "\377o\034", mode=PAGE_CUR_GE, prebuilt=0x3ff7b4017690, match_mode=0, direction=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc:5466 #13 0x0000000042c4665c in ha_innobase::general_fetch (this=0x3ff7b4016ad0, buf=0x3ff7b4006030 "\377o\034", direction=, match_mode=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:10768 #14 0x0000000042a306e0 in handler::ha_index_next (this=0x3ff7b4016ad0, buf=0x3ff7b4006030 "\377o\034") at /home/mariadb/svoj/mariadb/sql/handler.cc:2665 #15 0x0000000042a36680 in handler::read_range_next (this=) at /home/mariadb/svoj/mariadb/sql/handler.cc:5332 #16 0x000000004295eb64 in handler::multi_range_read_next (this=, range_info=) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:257 #17 0x000000004295ebfc in Mrr_simple_index_reader::get_next (this=0x3ff7b4017038, range_info=0x3ff80ff345b8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:322 #18 0x0000000042960838 in DsMrr_impl::dsmrr_next (this=0x3ff7b4016ef8, range_info=0x3ff80ff345b8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:1408 #19 0x0000000042c2f0f4 in ha_innobase::multi_range_read_next (this=, range_info=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:23948 #20 0x0000000042b82e50 in QUICK_RANGE_SELECT::get_next (this=0x3ff7cc61adb0) at /home/mariadb/svoj/mariadb/sql/opt_range.cc:11179 #21 0x0000000042ba4990 in rr_quick (info=0x3ff7cc011730) at /home/mariadb/svoj/mariadb/sql/records.cc:353 #22 0x0000000042863dc4 in sub_select (join=0x3ff7cc00fda0, join_tab=0x3ff7cc011668, end_of_records=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:18358 #23 0x0000000042886b70 in do_select (procedure=, join=0x3ff7cc00fda0) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:17883 #24 JOIN::exec_inner (this=0x3ff7cc00fda0) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3373 #25 0x0000000042886d70 in JOIN::exec (this=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3184 #26 0x0000000042886f58 in mysql_select (thd=0x3ff7cc0009a8, tables=, wild_num=, fields=..., conds=0x3ff7cc00fb68, og_num=, order=0x0, group=, having=0x0, proc_param=0x0, select_options=2148797184, result=0x3ff7cc00fd80, unit=0x3ff7cc004340, select_lex=0x3ff7cc004a78) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3569 #27 0x00000000428876a0 in handle_select (thd=0x3ff7cc0009a8, lex=0x3ff7cc004278, result=0x3ff7cc00fd80, setup_tables_done_option=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:361 #28 0x000000004281a764 in execute_sqlcom_select (thd=0x3ff7cc0009a8, all_tables=0x3ff7cc00f318) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:6356 #29 0x0000000042827f44 in mysql_execute_command (thd=0x3ff7cc0009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:3379 #30 0x000000004282b70c in mysql_parse (thd=0x3ff7cc0009a8, rawbuf=0x3ff7cc00ef00 "SELECT SUM(K) FROM sbtest1 WHERE id BETWEEN 7278 AND 7377", length=, parser_state=0x3ff80ff36540, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:7799 #31 0x000000004282e58c in dispatch_command (command=, thd=, packet=, packet_length=, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1808 #32 0x000000004282ef4c in do_command (thd=0x3ff7cc0009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1367 #33 0x000000004291bd84 in do_handle_one_connection (connect=) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1354 #34 0x000000004291bfe4 in handle_one_connection (arg=0x1004c115b08) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1260 #35 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #36 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 23 (LWP 76312): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x1004bdca220) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x1004bdca220, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042d9bad4 in sync_array_wait_event (arr=0x100216f4e00, cell=@0x3ff80ff92bf8: 0x100216f4f00) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0arr.cc:490 #5 0x0000000042d9f13c in rw_lock_s_lock_spin (lock=0x1004bdc9f70, pass=, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:432 #6 0x0000000042dc43ac in rw_lock_s_lock_func (pass=0, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172, lock=0x1004bdc9f70) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:426 #7 pfs_rw_lock_s_lock_func (pass=0, file_name=0x432f1c40 "/home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc", line=2172, lock=0x1004bdc9f70) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:813 #8 trx_undo_get_undo_rec (undo_rec=, name=..., is_redo_rseg=true, heap=0x3ff7c8a86e60, trx_id=2498331, roll_ptr=19140298445882564) at /home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc:2172 #9 trx_undo_prev_version_build (index_rec=, index_mtr=, rec=0x3ffd6e66acbf "", index=0x3ff7c80380b0, offsets=0x3ff80ff93028, heap=0x3ff7c8a86e60, old_vers=0x3ff80ff92e58, v_heap=0x0, vrow=, v_status=) at /home/mariadb/svoj/mariadb/storage/innobase/trx/trx0rec.cc:2266 #10 0x0000000042d7f5d0 in row_vers_build_for_consistent_read (rec=0x3ffd6e66acbf "", mtr=0x3ff80ff93dc0, index=0x3ff7c80380b0, offsets=0x3ff80ff92fe8, view=0x1004bd8ae00, offset_heap=0x3ff80ff92fe0, in_heap=0x3ff7a8019330, old_vers=0x3ff80ff93348, vrow=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0vers.cc:1169 #11 0x0000000042d63bfc in row_sel_build_prev_vers_for_mysql (mtr=0x3ff80ff93dc0, vrow=0x0, old_vers=, offset_heap=0x3ff80ff92fe0, offsets=, rec=0x3ffd6e66acbf "", prebuilt=0x3ff7cc017690, clust_index=0x3ff7c80380b0, read_view=0x1004bd8ae00) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc:3364 #12 row_search_mvcc (buf=0x3ff7cc006030 "", mode=PAGE_CUR_GE, prebuilt=0x3ff7cc017690, match_mode=0, direction=) at /home/mariadb/svoj/mariadb/storage/innobase/row/row0sel.cc:5466 #13 0x0000000042c4665c in ha_innobase::general_fetch (this=0x3ff7cc016ad0, buf=0x3ff7cc006030 "", direction=, match_mode=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:10768 #14 0x0000000042a306e0 in handler::ha_index_next (this=0x3ff7cc016ad0, buf=0x3ff7cc006030 "") at /home/mariadb/svoj/mariadb/sql/handler.cc:2665 #15 0x0000000042a36680 in handler::read_range_next (this=) at /home/mariadb/svoj/mariadb/sql/handler.cc:5332 #16 0x000000004295eb64 in handler::multi_range_read_next (this=, range_info=) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:257 #17 0x000000004295ebfc in Mrr_simple_index_reader::get_next (this=0x3ff7cc017038, range_info=0x3ff80ff945b8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:322 #18 0x0000000042960838 in DsMrr_impl::dsmrr_next (this=0x3ff7cc016ef8, range_info=0x3ff80ff945b8) at /home/mariadb/svoj/mariadb/sql/multi_range_read.cc:1408 #19 0x0000000042c2f0f4 in ha_innobase::multi_range_read_next (this=, range_info=) at /home/mariadb/svoj/mariadb/storage/innobase/handler/ha_innodb.cc:23948 #20 0x0000000042b82e50 in QUICK_RANGE_SELECT::get_next (this=0x3ff7c8a83330) at /home/mariadb/svoj/mariadb/sql/opt_range.cc:11179 #21 0x0000000042ba4990 in rr_quick (info=0x3ff7c80114b8) at /home/mariadb/svoj/mariadb/sql/records.cc:353 #22 0x0000000042863dc4 in sub_select (join=0x3ff7c800fb80, join_tab=0x3ff7c80113f0, end_of_records=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:18358 #23 0x0000000042886b70 in do_select (procedure=, join=0x3ff7c800fb80) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:17883 #24 JOIN::exec_inner (this=0x3ff7c800fb80) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3373 #25 0x0000000042886d70 in JOIN::exec (this=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3184 #26 0x0000000042886f58 in mysql_select (thd=0x3ff7c80009a8, tables=, wild_num=, fields=..., conds=0x3ff7c800f948, og_num=, order=0x0, group=, having=0x0, proc_param=0x0, select_options=2148797184, result=0x3ff7c800fb60, unit=0x3ff7c8004340, select_lex=0x3ff7c8004a78) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:3569 #27 0x00000000428876a0 in handle_select (thd=0x3ff7c80009a8, lex=0x3ff7c8004278, result=0x3ff7c800fb60, setup_tables_done_option=) at /home/mariadb/svoj/mariadb/sql/sql_select.cc:361 #28 0x000000004281a764 in execute_sqlcom_select (thd=0x3ff7c80009a8, all_tables=0x3ff7c800f0f8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:6356 #29 0x0000000042827f44 in mysql_execute_command (thd=0x3ff7c80009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:3379 #30 0x000000004282b70c in mysql_parse (thd=0x3ff7c80009a8, rawbuf=0x3ff7c800eed0 "SELECT c FROM sbtest1 WHERE id BETWEEN 5650 AND 5749", length=, parser_state=0x3ff80ff96540, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:7799 #31 0x000000004282e58c in dispatch_command (command=, thd=, packet=, packet_length=, is_com_multi=, is_next_command=) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1808 #32 0x000000004282ef4c in do_command (thd=0x3ff7c80009a8) at /home/mariadb/svoj/mariadb/sql/sql_parse.cc:1367 #33 0x000000004291bd84 in do_handle_one_connection (connect=) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1354 #34 0x000000004291bfe4 in handle_one_connection (arg=0x1004c112fb8) at /home/mariadb/svoj/mariadb/sql/sql_connect.cc:1260 #35 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #36 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 22 (LWP 76310): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x000000004279251c in inline_mysql_cond_wait (that=, mutex=, src_file=0x4323edc0 "/home/mariadb/svoj/mariadb/sql/slave.cc", src_line=339) at /home/mariadb/svoj/mariadb/include/mysql/psi/mysql_thread.h:1149 #2 handle_slave_background (arg=) at /home/mariadb/svoj/mariadb/sql/slave.cc:339 #3 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #4 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 21 (LWP 76309): #0 0x00003fff90b28490 in sigwait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042766c4c in signal_hand (arg=) at /home/mariadb/svoj/mariadb/sql/mysqld.cc:3560 #2 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #3 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 20 (LWP 76308): #0 0x00003fff90b277c8 in nanosleep () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9854 in os_thread_sleep (tm=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0thread.cc:230 #2 0x0000000042e39e5c in btr_defragment_thread (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/btr/btr0defragment.cc:770 #3 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #4 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 19 (LWP 76307): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x10021737d50) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x10021737d50, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042e4b60c in buf_resize_thread (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0buf.cc:3093 #5 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #6 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 18 (LWP 76306): #0 0x00003fff90b21980 in pthread_cond_timedwait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd8be8 in os_event::timed_wait (this=, abstime=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:286 #2 0x0000000042cd8f28 in os_event::wait_time_low (this=0x1004bdddaa0, time_in_usec=, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:413 #3 0x0000000042df8964 in ib_wqueue_timedwait (wq=0x1004bddf670, wait_in_usecs=) at /home/mariadb/svoj/mariadb/storage/innobase/ut/ut0wqueue.cc:160 #4 0x0000000042f2f6f4 in fts_optimize_thread (arg=0x1004bddf670) at /home/mariadb/svoj/mariadb/storage/innobase/fts/fts0opt.cc:3045 #5 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #6 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 17 (LWP 76305): #0 0x00003fff90b21980 in pthread_cond_timedwait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd8be8 in os_event::timed_wait (this=, abstime=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:286 #2 0x0000000042cd8f28 in os_event::wait_time_low (this=0x1004bd75c90, time_in_usec=, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:413 #3 0x0000000042ec531c in dict_stats_thread (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/dict/dict0stats_bg.cc:429 #4 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #5 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 16 (LWP 76304): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x10021737c50) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x10021737c50, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042e57340 in buf_dump_thread (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0dump.cc:803 #5 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #6 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 15 (LWP 76303): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x1004bdca2a0) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x1004bdca2a0, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042d9bad4 in sync_array_wait_event (arr=0x100216f4e00, cell=@0x3ff81f7fe450: 0x100216f50c0) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0arr.cc:490 #5 0x0000000042d9f844 in rw_lock_x_lock_wait_func (line=2953, file_name=0x432ed950 "/home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc", threshold=0, lock=0x1004bdc9f70) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:518 #6 rw_lock_x_lock_low (line=, file_name=, pass=, lock=0x1004bdc9f70) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:591 #7 rw_lock_x_lock_func (lock=0x1004bdc9f70, pass=, file_name=0x432ed950 "/home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc", line=2953) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:761 #8 0x0000000042d8ff10 in pfs_rw_lock_x_lock_func (pass=0, file_name=0x432ed950 "/home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc", line=2953, lock=0x1004bdc9f70) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:720 #9 srv_purge_coordinator_suspend (rseg_history_len=, slot=) at /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc:2953 #10 srv_purge_coordinator_thread (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc:3047 #11 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #12 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 14 (LWP 76302): #0 0x00003fff90b277c8 in nanosleep () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9854 in os_thread_sleep (tm=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0thread.cc:230 #2 0x0000000042d8d57c in srv_master_sleep () at /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc:2578 #3 srv_master_thread (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc:2625 #4 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #5 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 13 (LWP 76301): #0 0x00003fff90b21980 in pthread_cond_timedwait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd8be8 in os_event::timed_wait (this=, abstime=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:286 #2 0x0000000042cd8f28 in os_event::wait_time_low (this=0x10021737bd0, time_in_usec=, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:413 #3 0x0000000042d8cc28 in srv_monitor_thread (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc:1761 #4 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #5 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 12 (LWP 76300): #0 0x00003fff90b21980 in pthread_cond_timedwait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd8be8 in os_event::timed_wait (this=, abstime=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:286 #2 0x0000000042cd8f28 in os_event::wait_time_low (this=0x10021737b50, time_in_usec=, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:413 #3 0x0000000042d8bc10 in srv_error_monitor_thread (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc:1993 #4 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #5 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 11 (LWP 76299): #0 0x00003fff90b21980 in pthread_cond_timedwait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd8be8 in os_event::timed_wait (this=, abstime=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:286 #2 0x0000000042cd8f28 in os_event::wait_time_low (this=0x1004bd73ce0, time_in_usec=, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:413 #3 0x0000000042c98a48 in lock_wait_timeout_thread (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/lock/lock0wait.cc:535 #4 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #5 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 10 (LWP 76297): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x1004bd74740) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x1004bd74740, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042e65754 in buf_flush_page_cleaner_worker (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0flu.cc:3529 #5 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #6 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 9 (LWP 76296): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x1002d85c100) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x1002d85c100, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042d9bad4 in sync_array_wait_event (arr=0x100216f4e00, cell=@0x3ff7f0badf98: 0x100216f5100) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0arr.cc:490 #5 0x0000000042da0b64 in rw_lock_sx_lock_func (lock=0x3ffd6e1f2828, pass=2, file_name=0x432f8978 "/home/mariadb/svoj/mariadb/storage/innobase/buf/buf0flu.cc", line=1220) at /home/mariadb/svoj/mariadb/storage/innobase/sync/sync0rw.cc:935 #6 0x0000000042e5daf4 in pfs_rw_lock_sx_lock_func (pass=2, file_name=0x432f8978 "/home/mariadb/svoj/mariadb/storage/innobase/buf/buf0flu.cc", line=1220, lock=0x3ffd6e1f2828) at /home/mariadb/svoj/mariadb/storage/innobase/include/sync0rw.ic:848 #7 buf_flush_page (buf_pool=0x10021a8faa0, bpage=0x3ffd6e1f2760, flush_type=, sync=) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0flu.cc:1220 #8 0x0000000042e5e814 in buf_flush_try_neighbors (page_id=..., flush_type=BUF_FLUSH_LIST, n_flushed=8, n_to_flush=13) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0flu.cc:1464 #9 0x0000000042e5f6b8 in buf_flush_page_and_try_neighbors (flush_type=BUF_FLUSH_LIST, count=, n_to_flush=, bpage=) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0flu.cc:1536 #10 buf_do_flush_list_batch (buf_pool=0x10021a8faa0, min_n=13, lsn_limit=18446744073709551615) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0flu.cc:1797 #11 0x0000000042e65584 in buf_flush_batch (n=0x3ff7f0bae4c8, lsn_limit=18446744073709551615, min_n=13, flush_type=BUF_FLUSH_LIST, buf_pool=) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0flu.cc:1875 #12 buf_flush_do_batch (type=BUF_FLUSH_LIST, n=0x3ff7f0bae4c8, lsn_limit=18446744073709551615, min_n=13, buf_pool=) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0flu.cc:2046 #13 pc_flush_slot () at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0flu.cc:2903 #14 0x0000000042e65744 in buf_flush_page_cleaner_worker (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0flu.cc:3537 #15 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #16 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 8 (LWP 76295): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x1004bd74740) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x1004bd74740, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042e65754 in buf_flush_page_cleaner_worker (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0flu.cc:3529 #5 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #6 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 7 (LWP 76294): #0 0x00003fff90b213dc in pthread_cond_wait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000042cd9594 in os_event::wait (this=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:166 #2 os_event::wait_low (reset_sig_count=, this=0x1004bd747c0) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:336 #3 os_event_wait_low (event=0x1004bd747c0, reset_sig_count=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0event.cc:535 #4 0x0000000042e58280 in pc_wait_finished (n_flushed_lru=0x3ff7f9bae470, n_flushed_list=0x3ff7f9bae4a0) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0flu.cc:2959 #5 0x0000000042e684bc in buf_flush_page_cleaner_coordinator (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/buf/buf0flu.cc:3344 #6 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #7 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 6 (LWP 76293): #0 0x00003fff90ac0738 in ?? () from /lib64/libaio.so.1 #1 0x00003fff90ac07a0 in io_getevents () from /lib64/libaio.so.1 #2 0x0000000042cca9c0 in LinuxAIOHandler::collect (this=0x3ff7fa3ae588) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0file.cc:2519 #3 0x0000000042cd1b68 in LinuxAIOHandler::poll (this=0x3ff7fa3ae588, m1=0x3ff7fa3ae680, m2=0x3ff7fa3ae688, request=0x3ff7fa3ae690) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0file.cc:2665 #4 0x0000000042cd3ee8 in os_aio_linux_handler (request=0x3ff7fa3ae690, m2=0x3ff7fa3ae688, m1=0x3ff7fa3ae680, global_segment=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0file.cc:2721 #5 os_aio_handler (segment=, m1=0x3ff7fa3ae680, m2=0x3ff7fa3ae688, request=0x3ff7fa3ae690) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0file.cc:6450 #6 0x0000000042ed37a0 in fil_aio_wait (segment=) at /home/mariadb/svoj/mariadb/storage/innobase/fil/fil0fil.cc:5807 #7 0x0000000042d91868 in io_handler_thread (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0start.cc:331 #8 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #9 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 5 (LWP 76292): #0 0x00003fff90ac0738 in ?? () from /lib64/libaio.so.1 #1 0x00003fff90ac07a0 in io_getevents () from /lib64/libaio.so.1 #2 0x0000000042cca9c0 in LinuxAIOHandler::collect (this=0x3ff7fabae588) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0file.cc:2519 #3 0x0000000042cd1b68 in LinuxAIOHandler::poll (this=0x3ff7fabae588, m1=0x3ff7fabae680, m2=0x3ff7fabae688, request=0x3ff7fabae690) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0file.cc:2665 #4 0x0000000042cd3ee8 in os_aio_linux_handler (request=0x3ff7fabae690, m2=0x3ff7fabae688, m1=0x3ff7fabae680, global_segment=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0file.cc:2721 #5 os_aio_handler (segment=, m1=0x3ff7fabae680, m2=0x3ff7fabae688, request=0x3ff7fabae690) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0file.cc:6450 #6 0x0000000042ed37a0 in fil_aio_wait (segment=) at /home/mariadb/svoj/mariadb/storage/innobase/fil/fil0fil.cc:5807 #7 0x0000000042d91868 in io_handler_thread (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0start.cc:331 #8 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #9 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 4 (LWP 76291): #0 0x00003fff90ac0738 in ?? () from /lib64/libaio.so.1 #1 0x00003fff90ac07a0 in io_getevents () from /lib64/libaio.so.1 #2 0x0000000042cca9c0 in LinuxAIOHandler::collect (this=0x3ff7fb3ae588) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0file.cc:2519 #3 0x0000000042cd1b68 in LinuxAIOHandler::poll (this=0x3ff7fb3ae588, m1=0x3ff7fb3ae680, m2=0x3ff7fb3ae688, request=0x3ff7fb3ae690) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0file.cc:2665 #4 0x0000000042cd3ee8 in os_aio_linux_handler (request=0x3ff7fb3ae690, m2=0x3ff7fb3ae688, m1=0x3ff7fb3ae680, global_segment=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0file.cc:2721 #5 os_aio_handler (segment=, m1=0x3ff7fb3ae680, m2=0x3ff7fb3ae688, request=0x3ff7fb3ae690) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0file.cc:6450 #6 0x0000000042ed37a0 in fil_aio_wait (segment=) at /home/mariadb/svoj/mariadb/storage/innobase/fil/fil0fil.cc:5807 #7 0x0000000042d91868 in io_handler_thread (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0start.cc:331 #8 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #9 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 3 (LWP 76290): #0 0x00003fff90ac0738 in ?? () from /lib64/libaio.so.1 #1 0x00003fff90ac07a0 in io_getevents () from /lib64/libaio.so.1 #2 0x0000000042cca9c0 in LinuxAIOHandler::collect (this=0x3ff7fbbae588) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0file.cc:2519 #3 0x0000000042cd1b68 in LinuxAIOHandler::poll (this=0x3ff7fbbae588, m1=0x3ff7fbbae680, m2=0x3ff7fbbae688, request=0x3ff7fbbae690) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0file.cc:2665 #4 0x0000000042cd3ee8 in os_aio_linux_handler (request=0x3ff7fbbae690, m2=0x3ff7fbbae688, m1=0x3ff7fbbae680, global_segment=) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0file.cc:2721 #5 os_aio_handler (segment=, m1=0x3ff7fbbae680, m2=0x3ff7fbbae688, request=0x3ff7fbbae690) at /home/mariadb/svoj/mariadb/storage/innobase/os/os0file.cc:6450 #6 0x0000000042ed37a0 in fil_aio_wait (segment=) at /home/mariadb/svoj/mariadb/storage/innobase/fil/fil0fil.cc:5807 #7 0x0000000042d91868 in io_handler_thread (arg=) at /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0start.cc:331 #8 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #9 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 2 (LWP 76287): #0 0x00003fff90b21980 in pthread_cond_timedwait () from /opt/at10.0/lib64/power8/libpthread.so.0 #1 0x0000000043121190 in inline_mysql_cond_timedwait (that=0x4415dca0 , mutex=0x4415dc38 , src_file=0x43324928 "/home/mariadb/svoj/mariadb/mysys/thr_timer.c", src_line=292, abstime=0x3fff9036e658) at /home/mariadb/svoj/mariadb/include/mysql/psi/mysql_thread.h:1186 #2 timer_handler (arg=) at /home/mariadb/svoj/mariadb/mysys/thr_timer.c:292 #3 0x00003fff90b182c0 in ?? () from /opt/at10.0/lib64/power8/libpthread.so.0 #4 0x00003fff90634bd4 in clone () from /opt/at10.0/lib64/power8/libc.so.6 Thread 1 (LWP 76284): #0 0x00003fff90623878 in poll () from /opt/at10.0/lib64/power8/libc.so.6 #1 0x00003fff9064f374 in __poll_chk () from /opt/at10.0/lib64/power8/libc.so.6 #2 0x0000000042769e78 in poll (__timeout=-1, __nfds=2, __fds=) at /opt/at10.0/include/bits/poll2.h:41 #3 handle_connections_sockets () at /home/mariadb/svoj/mariadb/sql/mysqld.cc:6607 #4 0x00000000427746ec in mysqld_main (argc=, argv=) at /home/mariadb/svoj/mariadb/sql/mysqld.cc:6073 #5 0x000000004274aa10 in main (argc=, argv=) at /home/mariadb/svoj/mariadb/sql/main.cc:25