Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.14
-
None
Description
If a remote server used by a Spider table is unavailable, then some operations seem to hang for a long time. For example, if I have a database that contains some Spider tables, but if the remote server used by those tables is unavailable, then even executing the following statement in the mysql client can hang:
MariaDB [(none)]> use spider_test;
|
The full gdb output for the thread is here:
Thread 2 (Thread 0x7fea843f6700 (LWP 2203)):
|
#0 0x00007fea8ae89dfd in poll () from /lib64/libc.so.6
|
No symbol table info available.
|
#1 0x00007fea8d8add05 in poll (__timeout=6000, __nfds=1, __fds=0x7fea843f3210) at /usr/include/bits/poll2.h:46
|
No locals.
|
#2 vio_io_wait (vio=vio@entry=0x7fea8003f468, event=event@entry=VIO_IO_EVENT_CONNECT, timeout=timeout@entry=6000)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/vio/viosocket.c:945
|
ret = <optimized out>
|
revents = <optimized out>
|
pfd = {fd = 56, events = 4, revents = 0}
|
state = {m_flags = 16, m_socket = 0x7fea843f3280, m_thread = 0x7fea843f3240, m_number_of_bytes = 140645146817496, m_timer_start = 0,
|
m_timer = 0x1a684ab290fc7100, m_operation = 2048, m_src_file = 0x7fea00000cea <Address 0x7fea00000cea out of bounds>, m_src_line = -2147336248,
|
m_wait = 0x7fea8003cce8}
|
#3 0x00007fea8d8ae288 in vio_socket_connect (vio=0x7fea8003f468, addr=addr@entry=0x7fea8003f440, len=len@entry=16, timeout=6000)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/vio/viosocket.c:1113
|
ret = <optimized out>
|
wait = 1
|
not_used = 1 '\001'
|
#4 0x00007fea8d2c8ddc in connect_sync_or_async (net=0x7fea8003cce8, namelen=16, name=0x7fea8003f440, fd=56, mysql=0x7fea8003cce8)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/sql-common/client.c:3041
|
vio_timeout = -1
|
#5 mysql_real_connect (mysql=0x7fea8003cce8, host=0x7fea80023fc8 "172.30.0.249", user=0x7fea80024058 "spider_test", passwd=0x7fea80024088 "password",
|
db=0x0, port=3306, unix_socket=0x0, client_flag=65536)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/sql-common/client.c:3363
|
t_res = 0x7fea8003f410
|
sock = 56
|
status = <optimized out>
|
res_lst = 0x7fea8003f410
|
hints = {ai_flags = 0, ai_family = 0, ai_socktype = 1, ai_protocol = 6, ai_addrlen = 0, ai_addr = 0x0, ai_canonname = 0x0, ai_next = 0x0}
|
gai_errno = <optimized out>
|
port_buf = "3306\000\177\000\000\360f\002\200\352\177\000\000\000\000\000\000\000\000\000\000\060\271\002\200\352\177\000"
|
saved_error = 0
|
buff = "172.30.0.249 via TCP/IP\000H+\002\200\352\177\000\000p5?\204\352\177\000\000pD?\204\352\177\000\000 5?\204\352\177\000\000\027\360\037\215\352\177\000\000\321\034\003\200\352\177\000\000A\003.\215\352\177\000\000\320\034\003\200\352\177\000\000\030;\002\200\352\177\000\000\000\000\000\000\000\000\000\000H+\002\200\352\177\000\000p5?\204\352\177\000\000pD?\204\352\177\000\000P5?\204\352\177\000\000\f\244(t\352\177\000\000\000\000\000\000\352\177\000\000H+\002\200\352\177\000\000\000\000\000\000\000\000\000\000X[\002\200\352\177\000\000\260A?\204\352\177\000\000\336\266(t\352\177\000\000\000\000\000\000\000\000\000\000\005"...
|
scramble_data_len = <optimized out>
|
pkt_scramble_len = <optimized out>
|
end = <optimized out>
|
host_info = 0x7fea843f34a0 "172.30.0.249 via TCP/IP"
|
server_version_end = <optimized out>
|
pkt_end = <optimized out>
|
scramble_data = <optimized out>
|
scramble_plugin = <optimized out>
|
pkt_length = <optimized out>
|
net = 0x7fea8003cce8
|
UNIXaddr = {sun_family = 13107,
|
sun_path = "06\000\177\000\000\360f\002\200\352\177\000\000\000\000\000\000\000\000\000\000\060\271\002\200\352\177", '\000' <repeats 18 times>, "\260\064?\204\352\177\000\000^\235}\215\352\177\000\000\320\064?\204\352\177\000\000\235\064\211\215\352\177\000\000\060\066?\204\352\177\000\000@\000\000\000\000\000\000\000\320\064?\204\352\177\000\000\000q\374\220\262J"}
|
#6 0x00007fea742f2ebb in spider_db_mysql::connect (this=0x7fea8003c950, tgt_host=0x7fea80023fc8 "172.30.0.249", tgt_username=0x7fea80024058 "spider_test",
|
tgt_password=0x7fea80024088 "password", tgt_port=3306, tgt_socket=0x7fea80023ff8 "", server_name=0x7fea80023788 "srv1", connect_retry_count=839,
|
connect_retry_interval=1000)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/storage/spider/spd_db_mysql.cc:1576
|
error_num = <optimized out>
|
connect_mutex = 0 '\000'
|
#7 0x00007fea74294a71 in spider_db_connect (share=0x7fea80022b48, conn=conn@entry=0x7fea8003c1f8, link_idx=<optimized out>)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/storage/spider/spd_db_conn.cc:169
|
error_num = 0
|
connect_retry_count = 1000
|
connect_retry_interval = 1000
|
#8 0x00007fea74294f85 in spider_db_conn_queue_action (conn=conn@entry=0x7fea8003c1f8)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/storage/spider/spd_db_conn.cc:293
|
error_num = 0
|
sql_buf = "\000??\204\352\177", '\000' <repeats 11 times>, "U\001\200\352\177\000\000\330n\000\200\352\177\000\000\240\071?\204\352\177\000\000\215\203\352\212\352\177\000\000\300\350\n\216\352\177\000\000\226\215\205\215\352\177\000\000u\022\000\000\000\000\000\000)\276\326\021\000\000\000\000\060:?\204\352\177\000\000\003b=\215\352\177\000\000\200\063\341\001\000\000\000\000F\253\215\215\352\177\000\000xU\001\200\352\177\000\000\000\000\000\000\001\000\000\000\261\305\300{\001\000\000\000\330n\000\200\352\177\000\000\250U\001\200\352\177\000\000\070<?\204\352\177\000\000\070<?\204\352\177\000\000P\\\002\200\352\177\000\000\001\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\060<?\204\352\177\000\000"...
|
sql_str = {mem_calc_inited = true, str = {Ptr = 0x7fea843f3950 "", str_length = 0, Alloced_length = 1532, extra_alloc = 0, alloced = false,
|
thread_specific = false, str_charset = 0x7fea8e119d60 <my_charset_utf8_general_ci>}, id = 106,
|
func_name = 0x7fea7430e550 <spider_db_conn_queue_action(st_spider_conn*)::__FUNCTION__> "spider_db_conn_queue_action",
|
file_name = 0x7fea7430de40 "/home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/storage/spider/spd_db_conn.cc", line_no = 288, current_alloc_mem = 0, next = 0x0}
|
__FUNCTION__ = "spider_db_conn_queue_action"
|
#9 0x00007fea7429a40f in spider_db_before_query (conn=conn@entry=0x7fea8003c1f8, need_mon=need_mon@entry=0x7fea8003ab70)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/storage/spider/spd_db_conn.cc:568
|
error_num = <optimized out>
|
tmp_mta_conn_mutex_lock_already = true
|
__FUNCTION__ = "spider_db_before_query"
|
#10 0x00007fea7429a6bd in spider_db_set_names_internal (trx=0x7fea80031ed8, share=0x7fea80022b48, conn=0x7fea8003c1f8, all_link_idx=0,
|
need_mon=0x7fea8003ab70) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/storage/spider/spd_db_conn.cc:863
|
tmp_mta_conn_mutex_lock_already = true
|
__FUNCTION__ = "spider_db_set_names_internal"
|
#11 0x00007fea7429a946 in spider_db_set_names (spider=<optimized out>, conn=<optimized out>, link_idx=<optimized out>)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/storage/spider/spd_db_conn.cc:919
|
No locals.
|
#12 0x00007fea742f2505 in spider_mysql_handler::show_table_status (this=0x7fea8003acc0, link_idx=0, sts_mode=1, flag=<optimized out>)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/storage/spider/spd_db_mysql.cc:10343
|
request_key = {spider_thread_id = 9573179975459492652, query_id = 140644950656704, handler = 0x0, request_id = 140644950656816,
|
next = 0x7fea80022b48}
|
error_num = <optimized out>
|
conn = 0x7fea8003c1f8
|
share = 0x7fea80022b48
|
__FUNCTION__ = "show_table_status"
|
res = <optimized out>
|
pos = 0
|
auto_increment_value = 0
|
#13 0x00007fea742bcb2e in spider_get_sts (share=share@entry=0x7fea80022b48, link_idx=0, tmp_time=tmp_time@entry=1522265803, spider=spider@entry=
|
0x7fea80022070, sts_interval=sts_interval@entry=10, sts_mode=sts_mode@entry=1, sts_sync=sts_sync@entry=0, sts_sync_level=sts_sync_level@entry=1,
|
flag=flag@entry=88) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/storage/spider/spd_table.cc:7069
|
get_type = 1
|
error_num = 0
|
#14 0x00007fea742bf49c in spider_get_share (table_name=table_name@entry=0x7fea800201d8 "./spider_test/spider_tab", table=0x7fea800214d8,
|
thd=thd@entry=0x7fea80006ed8, spider=spider@entry=0x7fea80022070, error_num=error_num@entry=0x7fea843f4630)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/storage/spider/spd_table.cc:4769
|
spider_init_error_table = <optimized out>
|
tmp_time = 1522265803
|
old_elements = <optimized out>
|
semi_table_lock_conn = <optimized out>
|
tmp_cid = 0x7fea8003ab6f ""
|
first_byte = <optimized out>
|
share = 0x7fea80022b48
|
length = <optimized out>
|
roop_count = <optimized out>
|
search_link_idx = <optimized out>
|
mem_root = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 4056, block_num = 4, first_block_usage = 0, error_handler = 0x0}
|
table_tables = <optimized out>
|
init_mem_root = <optimized out>
|
hash_value = <optimized out>
|
table_share = <optimized out>
|
result_list = 0x7fea800225a0
|
tmp_name = 0x7fea8003ab09 ""
|
crd_interval = 51
|
open_tables_backup = {<Open_tables_state> = {m_reprepare_observer = 0x0, open_tables = 0x0, temporary_tables = 0x0, derived_tables = 0x0,
|
rec_tables = 0x0, lock = 0x0, extra_lock = 0x0, locked_tables_mode = LTM_NONE, current_tablenr = 0, state_flags = 0}, mdl_system_tables_svp = {
|
m_stmt_ticket = 0x0, m_trans_ticket = 0x7fea800152c0}}
|
tmp_conn_link_idx = 0
|
sts_interval = 10
|
sts_mode = 1
|
sts_sync = 0
|
auto_increment_mode = <optimized out>
|
__FUNCTION__ = "spider_get_share"
|
crd_mode = 1
|
crd_sync = 0
|
sql_command = <optimized out>
|
#15 0x00007fea742d5d63 in ha_spider::open (this=0x7fea80022070, name=0x7fea800201d8 "./spider_test/spider_tab", mode=<optimized out>,
|
test_if_locked=<optimized out>)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/storage/spider/ha_spider.cc:346
|
rnd_read_bitmap = 0x3d8 <Address 0x3d8 out of bounds>
|
pt_handler_share_handlers = 0x3e0
|
hash_value = <optimized out>
|
__FUNCTION__ = "open"
|
partition_share = <optimized out>
|
idx_read_bitmap = 0x7fea843f4680 "\020\020"
|
idx_write_bitmap = 0x3e0 <Address 0x3e0 out of bounds>
|
create_pt_handler_share = false
|
error_num = 0
|
roop_count = <optimized out>
|
init_sql_alloc_size = <optimized out>
|
rnd_write_bitmap = 0x1010 <Address 0x1010 out of bounds>
|
part_num = 2776
|
thd = 0x7fea80006ed8
|
pt_handler_mutex = false
|
may_be_clone = false
|
#16 0x00007fea8d2eeb23 in handler::ha_open (this=0x7fea80022070, table_arg=table_arg@entry=0x7fea800214d8, name=0x7fea800201d8 "./spider_test/spider_tab",
|
mode=mode@entry=2, test_if_locked=test_if_locked@entry=18)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/sql/handler.cc:2501
|
error = <optimized out>
|
#17 0x00007fea8d203445 in open_table_from_share (thd=thd@entry=0x7fea80006ed8, share=share@entry=0x7fea8001fdc0, alias=<optimized out>,
|
db_stat=db_stat@entry=33, prgflag=prgflag@entry=8, ha_open_flags=18, outparam=<optimized out>, is_create_table=<optimized out>,
|
is_create_table@entry=false) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/sql/table.cc:3328
|
ha_err = <optimized out>
|
records = <optimized out>
|
error_reported = false
|
record = <optimized out>
|
save_context_analysis_only = <optimized out>
|
bitmap_count = <optimized out>
|
bitmaps = <optimized out>
|
error = OPEN_FRM_ERROR_ALREADY_ISSUED
|
i = <optimized out>
|
bitmap_size = 4
|
field_ptr = <optimized out>
|
#18 0x00007fea8d10f122 in open_table (thd=thd@entry=0x7fea80006ed8, table_list=table_list@entry=0x7fea843f52b0, ot_ctx=ot_ctx@entry=0x7fea843f4ef0)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/sql/sql_base.cc:1877
|
error = <optimized out>
|
key = 0x7fea843f5721 "spider_test"
|
key_length = <optimized out>
|
flags = 1024
|
mdl_ticket = 0x7fea800152c0
|
share = 0x7fea8001fdc0
|
table = 0x7fea800214d8
|
alias = 0x7fea80015540 "spider_tab"
|
gts_flags = 3
|
#19 0x00007fea8d1120c1 in open_and_process_table (ot_ctx=0x7fea843f4ef0, has_prelocking_list=false, prelocking_strategy=0x7fea843f4f90, flags=1024,
|
counter=0x7fea843f4f8c, tables=0x7fea843f52b0, lex=0x7fea8000a7f8, thd=0x7fea80006ed8)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/sql/sql_base.cc:3409
|
error = <optimized out>
|
safe_to_ignore_table = false
|
#20 open_tables (thd=thd@entry=0x7fea80006ed8, options=..., start=start@entry=0x7fea843f4f78, counter=counter@entry=0x7fea843f4f8c, flags=flags@entry=1024,
|
prelocking_strategy=prelocking_strategy@entry=0x7fea843f4f90)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/sql/sql_base.cc:3928
|
table_to_open = 0x7fea843f4f78
|
sroutine_to_open = 0x7fea8000a890
|
__FUNCTION__ = "open_tables"
|
tables = 0x7fea843f52b0
|
ot_ctx = {m_thd = 0x7fea80006ed8, m_failed_table = 0x0, m_start_of_statement_svp = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0}, m_timeout = 86400,
|
m_flags = 1024, m_action = Open_table_context::OT_NO_ACTION, m_has_locks = false, m_has_protection_against_grl = false}
|
error = false
|
some_routine_modifies_data = false
|
has_prelocking_list = false
|
xa_state = <optimized out>
|
#21 0x00007fea8d1125c9 in open_tables (prelocking_strategy=0x7fea843f4f90, flags=1024, counter=0x7fea843f4f8c, tables=0x7fea843f4f78, thd=0x7fea80006ed8)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/sql/sql_base.h:237
|
No locals.
|
#22 open_normal_and_derived_tables (thd=thd@entry=0x7fea80006ed8, tables=tables@entry=0x7fea843f52b0, flags=flags@entry=1024, dt_phases=dt_phases@entry=35)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/sql/sql_base.cc:4745
|
prelocking_strategy = {<Prelocking_strategy> = {
|
_vptr.Prelocking_strategy = 0x7fea8dfa08f0 <vtable for DML_prelocking_strategy+16>}, <No data fields>}
|
counter = 1
|
mdl_savepoint = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0}
|
#23 0x00007fea8d1b4922 in mysqld_list_fields (thd=thd@entry=0x7fea80006ed8, table_list=table_list@entry=0x7fea843f52b0, wild=wild@entry=0x7fea80015570 "")
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/sql/sql_show.cc:1486
|
mem_root = 0x7fea8000be70
|
table = <optimized out>
|
field_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x1, last = 0x0, elements = 2147518680}, <No data fields>}
|
ptr = <optimized out>
|
field = <optimized out>
|
#24 0x00007fea8d1600a1 in dispatch_command (command=command@entry=COM_FIELD_LIST, thd=thd@entry=0x7fea80006ed8, packet=0x7fea8000d254 "",
|
packet@entry=0x7fea8000d249 "spider_tab", packet_length=packet_length@entry=11, is_com_multi=is_com_multi@entry=false,
|
is_next_command=is_next_command@entry=false)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/sql/sql_parse.cc:2009
|
packet_end = 0x7fea8000d254 ""
|
table_name = {str = 0x7fea80015540 "spider_tab", length = 10}
|
db = {str = 0x7fea80015530 "spider_test", length = 11}
|
mdl_savepoint = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0}
|
fields = 0x7fea80015570 ""
|
arg_end = <optimized out>
|
table_list = {next_local = 0x0, next_global = 0x0, prev_global = 0x7fea8000a808, db = 0x7fea80015530 "spider_test",
|
alias = 0x7fea80015540 "spider_tab", table_name = 0x7fea80015540 "spider_tab", schema_table_name = 0x0, option = 0x0, on_expr = 0x0,
|
sj_on_expr = 0x0, sj_inner_tables = 0, sj_in_exprs = 0, sj_subq_pred = 0x0, original_subq_pred_used_tables = 0, jtbm_subselect = 0x0,
|
jtbm_table_no = 0, sj_mat_info = 0x0, prep_on_expr = 0x0, cond_equal = 0x0, natural_join = 0x0, is_natural_join = false, join_using_fields = 0x0,
|
join_columns = 0x0, is_join_columns_complete = false, next_name_resolution_table = 0x0, index_hints = 0x0, table = 0x0, table_id = 0,
|
derived_result = 0x0, map = 0, correspondent_table = 0x0, derived = 0x0, with = 0x0, with_internal_reference_map = 0,
|
block_handle_derived = false, schema_table = 0x0, schema_select_lex = 0x0, schema_table_reformed = false, schema_table_param = 0x0,
|
select_lex = 0x7fea8000aff8, view = 0x0, field_translation = 0x0, field_translation_end = 0x0, field_translation_updated = false,
|
merge_underlying_list = 0x0, view_tables = 0x0, belong_to_view = 0x0, belong_to_derived = 0x0, referencing_view = 0x0, view_used_tables = 0,
|
map_exec = 0, tablenr_exec = 0, maybe_null_exec = 0, parent_l = 0x0, security_ctx = 0x0, view_sctx = 0x0, allowed_show = false, where = 0x0,
|
check_option = 0x0, select_stmt = {str = 0x0, length = 0}, md5 = {str = 0x0, length = 0}, source = {str = 0x0, length = 0}, view_db = {str = 0x0,
|
length = 0}, view_name = {str = 0x0, length = 0}, timestamp = {str = 0x0, length = 0}, definer = {user = {str = 0x0, length = 0}, host = {
|
str = 0x0, length = 0}, plugin = {str = 0x0, length = 0}, auth = {str = 0x0, length = 0}, pwtext = {str = 0x0, length = 0}, pwhash = {
|
str = 0x0, length = 0}}, file_version = 0, mariadb_version = 0, updatable_view = 0, algorithm = 0, view_suid = 0, with_check = 0,
|
effective_with_check = 0 '\000', derived_type = 0 '\000', grant = {grant_table_user = 0x0, grant_table_role = 0x0, version = 0,
|
privilege = 536870911, want_privilege = 0, orig_want_privilege = 1, m_internal = {m_schema_lookup_done = true, m_schema_access = 0x0,
|
m_table_lookup_done = true, m_table_access = 0x0}}, engine_data = 0, callback_func = 0x0, lock_type = TL_READ, outer_join = 0, shared = 0,
|
db_length = 11, table_name_length = 10, updatable = false, straight = false, updating = false, force_index = false, ignore_leaves = false,
|
crashed = false, dep_tables = 0, on_expr_dep_tables = 0, nested_join = 0x0, embedding = 0x0, join_list = 0x0, lifted = false,
|
cacheable_table = false, table_in_first_from_clause = false, open_type = OT_TEMPORARY_OR_BASE, contain_auto_increment = false,
|
compact_view_format = false, where_processed = false, check_option_processed = false, required_type = FRMTYPE_ERROR, db_type = 0x0,
|
timestamp_buffer = '\000' <repeats 19 times>, prelocking_placeholder = TABLE_LIST::USER, open_strategy = TABLE_LIST::OPEN_NORMAL,
|
lock_timeout = 0, lock_transactional = false, is_alias = false, is_fqtn = false, fill_me = false, merged = false, merged_for_insert = false,
|
skip_prepare_derived = false, used_items = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x0, last = 0x0,
|
elements = 0}, <No data fields>}, persistent_used_items = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x0, last = 0x0,
|
elements = 0}, <No data fields>}, materialized_items = 0x0, view_creation_ctx = 0x0, view_client_cs_name = {str = 0x0, length = 0},
|
view_connection_cl_name = {str = 0x0, length = 0}, view_body_utf8 = {str = 0x0, length = 0}, trg_event_map = 0 '\000', optimized_away = false,
|
materialized = false, i_s_requested_object = 0, prohibit_cond_pushdown = false, table_open_method = 0, schema_table_state = NOT_PROCESSED,
|
is_table_read_plan = 0x0, mdl_request = {type = MDL_SHARED_READ, duration = MDL_TRANSACTION, next_in_list = 0x0, prev_in_list = 0x0,
|
ticket = 0x0, key = {m_length = 24, m_db_name_length = 11, m_hash_value = 2089192294,
|
m_ptr = "\002spider_test\000spider_tab", '\000' <repeats 363 times>, static m_namespace_to_wait_state_name = {{m_key = 0,
|
m_name = 0x7fea8d8f66bf "Waiting for global read lock", m_flags = 0}, {m_key = 0,
|
m_name = 0x7fea8d8f6550 "Waiting for schema metadata lock", m_flags = 0}, {m_key = 0,
|
m_name = 0x7fea8d8f6578 "Waiting for table metadata lock", m_flags = 0}, {m_key = 0,
|
m_name = 0x7fea8d8f6598 "Waiting for stored function metadata lock", m_flags = 0}, {m_key = 0,
|
m_name = 0x7fea8d8f65c8 "Waiting for stored procedure metadata lock", m_flags = 0}, {m_key = 0,
|
m_name = 0x7fea8d8f65f8 "Waiting for trigger metadata lock", m_flags = 0}, {m_key = 0,
|
m_name = 0x7fea8d8f6620 "Waiting for event metadata lock", m_flags = 0}, {m_key = 0, m_name = 0x7fea8d8f66dc "Waiting for commit lock",
|
m_flags = 0}, {m_key = 0, m_name = 0x7fea8d8da937 "User lock", m_flags = 0}}}}, partition_names = 0x0, m_table_ref_type = TABLE_REF_NULL,
|
m_table_ref_version = 0}
|
arg_length = <optimized out>
|
query_length = 0
|
net = 0x7fea80007140
|
do_end_of_statement = true
|
__FUNCTION__ = "dispatch_command"
|
error = false
|
drop_more_results = false
|
#25 0x00007fea8d16076b in do_command (thd=0x7fea80006ed8)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/sql/sql_parse.cc:1369
|
return_value = <optimized out>
|
packet = 0x7fea8000d248 "\004spider_tab"
|
packet_length = 12
|
net = 0x7fea80007140
|
command = COM_FIELD_LIST
|
#26 0x00007fea8d227d3a in do_handle_one_connection (connect=connect@entry=0x7fea8f8e0598)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/sql/sql_connect.cc:1335
|
create_user = true
|
thr_create_utime = <optimized out>
|
thd = 0x7fea80006ed8
|
#27 0x00007fea8d227e5d in handle_one_connection (arg=0x7fea8f8e0598)
|
at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.14/sql/sql_connect.cc:1241
|
connect = 0x7fea8f8e0598
|
#28 0x00007fea8c840dc5 in start_thread () from /lib64/libpthread.so.0
|
No symbol table info available.
|
#29 0x00007fea8ae9473d in clone () from /lib64/libc.so.6
|
No symbol table info available.
|
I watched the thread's backtrace change in gdb, and it seems that the connect_retry_count argument to spider_db_mysql::connect is slowly decreasing, so it seems that Spider is configured to try connecting to the remote server many many times before it "officially" fails, even for operations that should probably fail fairly quickly.
The following statements also have this problem:
MariaDB [(none)]> SHOW TABLE STATUS FROM spider_test;
|
MariaDB [(none)]> SELECT * FROM information_schema.TABLES;
|