Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL)
-
None
Description
Checkout branch bb-10.2-MDEV-13626
Core was generated by `/home/jan/mysql/10.2-orig/sql/mysqld --defaults-group-suffix=.1 --defaults-file'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
|
57 ../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory.
|
[Current thread is 1 (Thread 0x7fb968206700 (LWP 30258))]
|
#0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
|
#1 0x00005642a02c2466 in my_write_core (sig=6) at /home/jan/mysql/10.2-orig/mysys/stacktrace.c:477
|
#2 0x000056429fb566fe in handle_fatal_signal (sig=6) at /home/jan/mysql/10.2-orig/sql/signal_handler.cc:303
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
|
#5 0x00007fb96e64a3fa in __GI_abort () at abort.c:89
|
#6 0x00007fb96e641e37 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x5642a047f0a0 "offset >= ((38U + 36 + 2 * 10) + 5)", file=file@entry=0x5642a047f028 "/home/jan/mysql/10.2-orig/storage/innobase/include/page0page.h", line=line@entry=318, function=function@entry=0x5642a0483720 <page_rec_is_infimum_low(unsigned long)::__PRETTY_FUNCTION__> "bool page_rec_is_infimum_low(ulint)") at assert.c:92
|
#7 0x00007fb96e641ee2 in __GI___assert_fail (assertion=0x5642a047f0a0 "offset >= ((38U + 36 + 2 * 10) + 5)", file=0x5642a047f028 "/home/jan/mysql/10.2-orig/storage/innobase/include/page0page.h", line=318, function=0x5642a0483720 <page_rec_is_infimum_low(unsigned long)::__PRETTY_FUNCTION__> "bool page_rec_is_infimum_low(ulint)") at assert.c:101
|
#8 0x000056429fdd0482 in page_rec_is_infimum_low (offset=0) at /home/jan/mysql/10.2-orig/storage/innobase/include/page0page.h:318
|
#9 0x000056429fe369f2 in page_check_dir (page=0x7fb91004c000 "") at /home/jan/mysql/10.2-orig/storage/innobase/page/page0page.cc:1979
|
#10 0x000056429fe29a98 in page_cur_search_with_match (block=0x7fb91005c360, index=0x7fb90c03a4d8, tuple=0x7fb91001d728, mode=PAGE_CUR_LE, iup_matched_fields=0x7fb968202648, ilow_matched_fields=0x7fb968202640, cursor=0x7fb968202700, rtr_info=0x0) at /home/jan/mysql/10.2-orig/storage/innobase/page/page0cur.cc:358
|
#11 0x000056429fed2f4a in page_cur_search (block=0x7fb91005c360, index=0x7fb90c03a4d8, tuple=0x7fb91001d728, mode=PAGE_CUR_LE, cursor=0x7fb968202700) at /home/jan/mysql/10.2-orig/storage/innobase/include/page0cur.ic:222
|
#12 0x000056429fedafae in row_sel_get_clust_rec_for_mysql (prebuilt=0x7fb90c0b0b68, sec_index=0x7fb90c03a4d8, rec=0x7fb91004d156 "", thr=0x7fb90c0b15c8, out_rec=0x7fb968202940, offsets=0x7fb968202960, offset_heap=0x7fb968202958, vrow=0x0, mtr=0x7fb968203500) at /home/jan/mysql/10.2-orig/storage/innobase/row/row0sel.cc:3404
|
#13 0x000056429fedf279 in row_search_mvcc (buf=0x7fb90c172d98 "\377", mode=PAGE_CUR_CONTAIN, prebuilt=0x7fb90c0b0b68, match_mode=0, direction=0) at /home/jan/mysql/10.2-orig/storage/innobase/row/row0sel.cc:5237
|
#14 0x000056429fd667b9 in ha_innobase::index_read (this=0x7fb90c04ec18, buf=0x7fb90c172d98 "\377", key_ptr=0x7fb91001e028 "", key_len=34, find_flag=HA_READ_MBR_CONTAIN) at /home/jan/mysql/10.2-orig/storage/innobase/handler/ha_innodb.cc:9823
|
#15 0x000056429fb67224 in handler::index_read_map (this=0x7fb90c04ec18, buf=0x7fb90c172d98 "\377", key=0x7fb91001e028 "", keypart_map=1, find_flag=HA_READ_MBR_CONTAIN) at /home/jan/mysql/10.2-orig/sql/handler.h:3116
|
#16 0x000056429fb5d52b in handler::ha_index_read_map (this=0x7fb90c04ec18, buf=0x7fb90c172d98 "\377", key=0x7fb91001e028 "", keypart_map=1, find_flag=HA_READ_MBR_CONTAIN) at /home/jan/mysql/10.2-orig/sql/handler.cc:2626
|
#17 0x000056429fcb237e in QUICK_RANGE_SELECT_GEOM::get_next (this=0x7fb910006580) at /home/jan/mysql/10.2-orig/sql/opt_range.cc:11511
|
#18 0x000056429fcc2c6c in rr_quick (info=0x7fb910013790) at /home/jan/mysql/10.2-orig/sql/records.cc:366
|
#19 0x000056429f95b8de in join_init_read_record (tab=0x7fb9100136c8) at /home/jan/mysql/10.2-orig/sql/sql_select.cc:19485
|
#20 0x000056429f9596aa in sub_select (join=0x7fb910011de0, join_tab=0x7fb9100136c8, end_of_records=false) at /home/jan/mysql/10.2-orig/sql/sql_select.cc:18560
|
#21 0x000056429f958c93 in do_select (join=0x7fb910011de0, procedure=0x0) at /home/jan/mysql/10.2-orig/sql/sql_select.cc:18107
|
#22 0x000056429f9338ff in JOIN::exec_inner (this=0x7fb910011de0) at /home/jan/mysql/10.2-orig/sql/sql_select.cc:3483
|
#23 0x000056429f932db0 in JOIN::exec (this=0x7fb910011de0) at /home/jan/mysql/10.2-orig/sql/sql_select.cc:3278
|
#24 0x000056429f933f70 in mysql_select (thd=0x7fb910000b00, tables=0x7fb910011380, wild_num=0, fields=..., conds=0x7fb910011c00, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fb910011dc0, unit=0x7fb9100046a0, select_lex=0x7fb910004dd8) at /home/jan/mysql/10.2-orig/sql/sql_select.cc:3678
|
#25 0x000056429f92891b in handle_select (thd=0x7fb910000b00, lex=0x7fb9100045d8, result=0x7fb910011dc0, setup_tables_done_option=0) at /home/jan/mysql/10.2-orig/sql/sql_select.cc:361
|
#26 0x000056429f8f4767 in execute_sqlcom_select (thd=0x7fb910000b00, all_tables=0x7fb910011380) at /home/jan/mysql/10.2-orig/sql/sql_parse.cc:6427
|
#27 0x000056429f8ea4ba in mysql_execute_command (thd=0x7fb910000b00) at /home/jan/mysql/10.2-orig/sql/sql_parse.cc:3461
|
#28 0x000056429f8f8103 in mysql_parse (thd=0x7fb910000b00, rawbuf=0x7fb910011078 "select count(*) from t1 where MBRWithin(t1.c2, @g1)", length=51, parser_state=0x7fb968205080, is_com_multi=false, is_next_command=false) at /home/jan/mysql/10.2-orig/sql/sql_parse.cc:7868
|
#29 0x000056429f8e5e17 in dispatch_command (command=COM_QUERY, thd=0x7fb910000b00, packet=0x7fb910008891 "", packet_length=52, is_com_multi=false, is_next_command=false) at /home/jan/mysql/10.2-orig/sql/sql_parse.cc:1812
|
#30 0x000056429f8e47c6 in do_command (thd=0x7fb910000b00) at /home/jan/mysql/10.2-orig/sql/sql_parse.cc:1359
|
#31 0x000056429fa30847 in do_handle_one_connection (connect=0x5642a34c7d60) at /home/jan/mysql/10.2-orig/sql/sql_connect.cc:1354
|
#32 0x000056429fa305c7 in handle_one_connection (arg=0x5642a34c7d60) at /home/jan/mysql/10.2-orig/sql/sql_connect.cc:1260
|
#33 0x00005642a0268753 in pfs_spawn_thread (arg=0x5642a34d2ab0) at /home/jan/mysql/10.2-orig/storage/perfschema/pfs.cc:1862
|
#34 0x00007fb970e6c494 in start_thread (arg=0x7fb968206700) at pthread_create.c:333
|
#35 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 30 (Thread 0x7fb9537fe700 (LWP 30244)):
|
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
|
#1 0x000056429fe24028 in os_event::wait (this=0x5642a2f45e20) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:166
|
#2 0x000056429fe23a54 in os_event::wait_low (this=0x5642a2f45e20, reset_sig_count=225) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:336
|
#3 0x000056429fe23dd1 in os_event_wait_low (event=0x5642a2f45e20, reset_sig_count=0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:535
|
#4 0x000056429ff103d8 in srv_resume_thread (slot=0x5642a0c56900 <srv_sys+384>, sig_count=0, wait=true, timeout_usec=0) at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0srv.cc:940
|
#5 0x000056429ff13ed9 in srv_worker_thread (arg=0x0) at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0srv.cc:2647
|
#6 0x00007fb970e6c494 in start_thread (arg=0x7fb9537fe700) at pthread_create.c:333
|
#7 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 29 (Thread 0x7fb950ff9700 (LWP 30250)):
|
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
|
#1 0x00005642a02c7cee in safe_cond_timedwait (cond=0x5642a169aca0 <COND_checkpoint>, mp=0x5642a169abe0 <LOCK_checkpoint>, abstime=0x7fb950ff8c80, file=0x5642a05c3d70 "/home/jan/mysql/10.2-orig/include/mysql/psi/mysql_thread.h", line=1175) at /home/jan/mysql/10.2-orig/mysys/thr_mutex.c:545
|
#2 0x00005642a01482cd in inline_mysql_cond_timedwait (that=0x5642a169aca0 <COND_checkpoint>, mutex=0x5642a169abe0 <LOCK_checkpoint>, abstime=0x7fb950ff8c80, src_file=0x5642a05c3db0 "/home/jan/mysql/10.2-orig/storage/maria/ma_servicethread.c", src_line=116) at /home/jan/mysql/10.2-orig/include/mysql/psi/mysql_thread.h:1175
|
#3 0x00005642a01487cf in my_service_thread_sleep (control=0x5642a0c59b80 <checkpoint_control>, sleep_time=29000000000) at /home/jan/mysql/10.2-orig/storage/maria/ma_servicethread.c:115
|
#4 0x00005642a013d41b in ma_checkpoint_background (arg=0x1e) at /home/jan/mysql/10.2-orig/storage/maria/ma_checkpoint.c:709
|
#5 0x00005642a0268753 in pfs_spawn_thread (arg=0x5642a33e5720) at /home/jan/mysql/10.2-orig/storage/perfschema/pfs.cc:1862
|
#6 0x00007fb970e6c494 in start_thread (arg=0x7fb950ff9700) at pthread_create.c:333
|
#7 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 28 (Thread 0x7fb958ff9700 (LWP 30242)):
|
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
|
#1 0x000056429fe24028 in os_event::wait (this=0x5642a2f45da0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:166
|
#2 0x000056429fe23a54 in os_event::wait_low (this=0x5642a2f45da0, reset_sig_count=139) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:336
|
#3 0x000056429fe23dd1 in os_event_wait_low (event=0x5642a2f45da0, reset_sig_count=139) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:535
|
#4 0x000056429ff103d8 in srv_resume_thread (slot=0x5642a0c568c8 <srv_sys+328>, sig_count=139, wait=true, timeout_usec=0) at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0srv.cc:940
|
#5 0x000056429ff143a8 in srv_purge_coordinator_suspend (slot=0x5642a0c568c8 <srv_sys+328>, rseg_history_len=4) at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0srv.cc:2800
|
#6 0x000056429ff1475d in srv_purge_coordinator_thread (arg=0x0) at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0srv.cc:2887
|
#7 0x00007fb970e6c494 in start_thread (arg=0x7fb958ff9700) at pthread_create.c:333
|
#8 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 27 (Thread 0x7fb9517fa700 (LWP 30249)):
|
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
|
#1 0x00005642a02c79e4 in safe_cond_wait (cond=0x7fb9517f9c40, mp=0x7fb9517f9c80, file=0x5642a045cf28 "/home/jan/mysql/10.2-orig/include/mysql/psi/mysql_thread.h", line=1149) at /home/jan/mysql/10.2-orig/mysys/thr_mutex.c:491
|
#2 0x000056429fd5078e in inline_mysql_cond_wait (that=0x7fb9517f9c40, mutex=0x7fb9517f9c80, src_file=0x5642a045e9a8 "/home/jan/mysql/10.2-orig/storage/innobase/handler/ha_innodb.cc", src_line=341) at /home/jan/mysql/10.2-orig/include/mysql/psi/mysql_thread.h:1149
|
#3 0x000056429fd550cc in thd_destructor_proxy () at /home/jan/mysql/10.2-orig/storage/innobase/handler/ha_innodb.cc:341
|
#4 0x00005642a0268753 in pfs_spawn_thread (arg=0x5642a31063a0) at /home/jan/mysql/10.2-orig/storage/perfschema/pfs.cc:1862
|
#5 0x00007fb970e6c494 in start_thread (arg=0x7fb9517fa700) at pthread_create.c:333
|
#6 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 26 (Thread 0x7fb968250700 (LWP 30255)):
|
#0 0x00007fb96e6f56ad in poll () at ../sysdeps/unix/syscall-template.S:84
|
#1 0x00005642a0327bca in vio_io_wait (vio=0x5642a34131d0, event=VIO_IO_EVENT_READ, timeout=28800000) at /home/jan/mysql/10.2-orig/vio/viosocket.c:945
|
#2 0x00005642a03263d9 in vio_socket_io_wait (vio=0x5642a34131d0, event=VIO_IO_EVENT_READ) at /home/jan/mysql/10.2-orig/vio/viosocket.c:108
|
#3 0x00005642a032658f in vio_read (vio=0x5642a34131d0, buf=0x7fb90c084b10 "\a", size=4) at /home/jan/mysql/10.2-orig/vio/viosocket.c:184
|
#4 0x000056429f81b97f in my_real_read (net=0x7fb90c000dc8, complen=0x7fb96824f7c0, header=1 '\001') at /home/jan/mysql/10.2-orig/sql/net_serv.cc:888
|
#5 0x000056429f81c17e in my_net_read_packet_reallen (net=0x7fb90c000dc8, read_from_server=1 '\001', reallen=0x7fb96824f828) at /home/jan/mysql/10.2-orig/sql/net_serv.cc:1158
|
#6 0x000056429f81c132 in my_net_read_packet (net=0x7fb90c000dc8, read_from_server=1 '\001') at /home/jan/mysql/10.2-orig/sql/net_serv.cc:1142
|
#7 0x000056429f8e4295 in do_command (thd=0x7fb90c000b00) at /home/jan/mysql/10.2-orig/sql/sql_parse.cc:1242
|
#8 0x000056429fa30847 in do_handle_one_connection (connect=0x5642a34af680) at /home/jan/mysql/10.2-orig/sql/sql_connect.cc:1354
|
#9 0x000056429fa305c7 in handle_one_connection (arg=0x5642a34af680) at /home/jan/mysql/10.2-orig/sql/sql_connect.cc:1260
|
#10 0x00005642a0268753 in pfs_spawn_thread (arg=0x5642a34131d0) at /home/jan/mysql/10.2-orig/storage/perfschema/pfs.cc:1862
|
#11 0x00007fb970e6c494 in start_thread (arg=0x7fb968250700) at pthread_create.c:333
|
#12 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 25 (Thread 0x7fb961ffb700 (LWP 30232)):
|
#0 0x00007fb9701e86ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#1 0x000056429fe179d7 in LinuxAIOHandler::collect (this=0x7fb961ffaaa0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:1896
|
#2 0x000056429fe17f0d in LinuxAIOHandler::poll (this=0x7fb961ffaaa0, m1=0x7fb961ffab48, m2=0x7fb961ffab50, request=0x7fb961ffab80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:2041
|
#3 0x000056429fe18087 in os_aio_linux_handler (global_segment=4, m1=0x7fb961ffab48, m2=0x7fb961ffab50, request=0x7fb961ffab80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:2095
|
#4 0x000056429fe1cacd in os_aio_handler (segment=4, m1=0x7fb961ffab48, m2=0x7fb961ffab50, request=0x7fb961ffab80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:5740
|
#5 0x00005642a0070376 in fil_aio_wait (segment=4) at /home/jan/mysql/10.2-orig/storage/innobase/fil/fil0fil.cc:5295
|
#6 0x000056429ff16e87 in io_handler_thread (arg=0x5642a0e8a9c0 <n+32>) at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0start.cc:343
|
#7 0x00007fb970e6c494 in start_thread (arg=0x7fb961ffb700) at pthread_create.c:333
|
#8 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 24 (Thread 0x7fb951ffb700 (LWP 30248)):
|
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
|
#1 0x000056429fe24028 in os_event::wait (this=0x5642a2f461a0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:166
|
#2 0x000056429fe23a54 in os_event::wait_low (this=0x5642a2f461a0, reset_sig_count=1) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:336
|
#3 0x000056429fe23dd1 in os_event_wait_low (event=0x5642a2f461a0, reset_sig_count=0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:535
|
#4 0x000056429ffd9b2f in buf_resize_thread () at /home/jan/mysql/10.2-orig/storage/innobase/buf/buf0buf.cc:3080
|
#5 0x00007fb970e6c494 in start_thread (arg=0x7fb951ffb700) at pthread_create.c:333
|
#6 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 23 (Thread 0x7fb9627fc700 (LWP 30231)):
|
#0 0x00007fb9701e86ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#1 0x000056429fe179d7 in LinuxAIOHandler::collect (this=0x7fb9627fbaa0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:1896
|
#2 0x000056429fe17f0d in LinuxAIOHandler::poll (this=0x7fb9627fbaa0, m1=0x7fb9627fbb48, m2=0x7fb9627fbb50, request=0x7fb9627fbb80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:2041
|
#3 0x000056429fe18087 in os_aio_linux_handler (global_segment=3, m1=0x7fb9627fbb48, m2=0x7fb9627fbb50, request=0x7fb9627fbb80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:2095
|
#4 0x000056429fe1cacd in os_aio_handler (segment=3, m1=0x7fb9627fbb48, m2=0x7fb9627fbb50, request=0x7fb9627fbb80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:5740
|
#5 0x00005642a0070376 in fil_aio_wait (segment=3) at /home/jan/mysql/10.2-orig/storage/innobase/fil/fil0fil.cc:5295
|
#6 0x000056429ff16e87 in io_handler_thread (arg=0x5642a0e8a9b8 <n+24>) at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0start.cc:343
|
#7 0x00007fb970e6c494 in start_thread (arg=0x7fb9627fc700) at pthread_create.c:333
|
#8 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 22 (Thread 0x7fb953fff700 (LWP 30243)):
|
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
|
#1 0x000056429fe24028 in os_event::wait (this=0x5642a2f45f20) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:166
|
#2 0x000056429fe23a54 in os_event::wait_low (this=0x5642a2f45f20, reset_sig_count=211) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:336
|
#3 0x000056429fe23dd1 in os_event_wait_low (event=0x5642a2f45f20, reset_sig_count=0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:535
|
#4 0x000056429ff103d8 in srv_resume_thread (slot=0x5642a0c56970 <srv_sys+496>, sig_count=0, wait=true, timeout_usec=0) at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0srv.cc:940
|
#5 0x000056429ff13ed9 in srv_worker_thread (arg=0x0) at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0srv.cc:2647
|
#6 0x00007fb970e6c494 in start_thread (arg=0x7fb953fff700) at pthread_create.c:333
|
#7 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 21 (Thread 0x7fb968172700 (LWP 30260)):
|
#0 0x00007fb96e6f56ad in poll () at ../sysdeps/unix/syscall-template.S:84
|
#1 0x00005642a0327bca in vio_io_wait (vio=0x5642a3412590, event=VIO_IO_EVENT_READ, timeout=28800000) at /home/jan/mysql/10.2-orig/vio/viosocket.c:945
|
#2 0x00005642a03263d9 in vio_socket_io_wait (vio=0x5642a3412590, event=VIO_IO_EVENT_READ) at /home/jan/mysql/10.2-orig/vio/viosocket.c:108
|
#3 0x00005642a032658f in vio_read (vio=0x5642a3412590, buf=0x7fb908008890 "\001", size=4) at /home/jan/mysql/10.2-orig/vio/viosocket.c:184
|
#4 0x000056429f81b97f in my_real_read (net=0x7fb908000dc8, complen=0x7fb9681717c0, header=1 '\001') at /home/jan/mysql/10.2-orig/sql/net_serv.cc:888
|
#5 0x000056429f81c17e in my_net_read_packet_reallen (net=0x7fb908000dc8, read_from_server=1 '\001', reallen=0x7fb968171828) at /home/jan/mysql/10.2-orig/sql/net_serv.cc:1158
|
#6 0x000056429f81c132 in my_net_read_packet (net=0x7fb908000dc8, read_from_server=1 '\001') at /home/jan/mysql/10.2-orig/sql/net_serv.cc:1142
|
#7 0x000056429f8e4295 in do_command (thd=0x7fb908000b00) at /home/jan/mysql/10.2-orig/sql/sql_parse.cc:1242
|
#8 0x000056429fa30847 in do_handle_one_connection (connect=0x5642a34af680) at /home/jan/mysql/10.2-orig/sql/sql_connect.cc:1354
|
#9 0x000056429fa305c7 in handle_one_connection (arg=0x5642a34af680) at /home/jan/mysql/10.2-orig/sql/sql_connect.cc:1260
|
#10 0x00005642a0268753 in pfs_spawn_thread (arg=0x5642a34d3230) at /home/jan/mysql/10.2-orig/storage/perfschema/pfs.cc:1862
|
#11 0x00007fb970e6c494 in start_thread (arg=0x7fb968172700) at pthread_create.c:333
|
#12 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 20 (Thread 0x7fb963fff700 (LWP 30228)):
|
#0 0x00007fb9701e86ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#1 0x000056429fe179d7 in LinuxAIOHandler::collect (this=0x7fb963ffeaa0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:1896
|
#2 0x000056429fe17f0d in LinuxAIOHandler::poll (this=0x7fb963ffeaa0, m1=0x7fb963ffeb48, m2=0x7fb963ffeb50, request=0x7fb963ffeb80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:2041
|
#3 0x000056429fe18087 in os_aio_linux_handler (global_segment=0, m1=0x7fb963ffeb48, m2=0x7fb963ffeb50, request=0x7fb963ffeb80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:2095
|
#4 0x000056429fe1cacd in os_aio_handler (segment=0, m1=0x7fb963ffeb48, m2=0x7fb963ffeb50, request=0x7fb963ffeb80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:5740
|
#5 0x00005642a0070376 in fil_aio_wait (segment=0) at /home/jan/mysql/10.2-orig/storage/innobase/fil/fil0fil.cc:5295
|
#6 0x000056429ff16e87 in io_handler_thread (arg=0x5642a0e8a9a0 <n>) at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0start.cc:343
|
#7 0x00007fb970e6c494 in start_thread (arg=0x7fb963fff700) at pthread_create.c:333
|
#8 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 19 (Thread 0x7fb95affd700 (LWP 30238)):
|
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
|
#1 0x000056429fe238be in os_event::timed_wait (this=0x5642a2f46020, abstime=0x7fb95affccd0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:286
|
#2 0x000056429fe23bf2 in os_event::wait_time_low (this=0x5642a2f46020, time_in_usec=5000000, reset_sig_count=1) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:413
|
#3 0x000056429fe23dac in os_event_wait_time_low (event=0x5642a2f46020, time_in_usec=5000000, reset_sig_count=1) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:518
|
#4 0x000056429ff1218c in srv_monitor_thread () at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0srv.cc:1744
|
#5 0x00007fb970e6c494 in start_thread (arg=0x7fb95affd700) at pthread_create.c:333
|
#6 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 18 (Thread 0x7fb96829a700 (LWP 30252)):
|
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
|
#1 0x00005642a02c79e4 in safe_cond_wait (cond=0x5642a0e17e40 <COND_slave_background>, mp=0x5642a0e1b040 <LOCK_slave_background>, file=0x5642a0339b08 "/home/jan/mysql/10.2-orig/include/mysql/psi/mysql_thread.h", line=1138) at /home/jan/mysql/10.2-orig/mysys/thr_mutex.c:491
|
#2 0x000056429f8338be in inline_mysql_cond_wait (that=0x5642a0e17e40 <COND_slave_background>, mutex=0x5642a0e1b040 <LOCK_slave_background>, src_file=0x5642a033a430 "/home/jan/mysql/10.2-orig/sql/slave.cc", src_line=334) at /home/jan/mysql/10.2-orig/include/mysql/psi/mysql_thread.h:1138
|
#3 0x000056429f8344f0 in handle_slave_background (arg=0x0) at /home/jan/mysql/10.2-orig/sql/slave.cc:334
|
#4 0x00005642a0268753 in pfs_spawn_thread (arg=0x5642a34b4ea0) at /home/jan/mysql/10.2-orig/storage/perfschema/pfs.cc:1862
|
#5 0x00007fb970e6c494 in start_thread (arg=0x7fb96829a700) at pthread_create.c:333
|
#6 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 17 (Thread 0x7fb95b7fe700 (LWP 30237)):
|
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
|
#1 0x000056429fe238be in os_event::timed_wait (this=0x5642a2f45fa0, abstime=0x7fb95b7fdb40) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:286
|
#2 0x000056429fe23bf2 in os_event::wait_time_low (this=0x5642a2f45fa0, time_in_usec=1000000, reset_sig_count=1) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:413
|
#3 0x000056429fe23dac in os_event_wait_time_low (event=0x5642a2f45fa0, time_in_usec=1000000, reset_sig_count=1) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:518
|
#4 0x000056429ff12865 in srv_error_monitor_thread () at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0srv.cc:1969
|
#5 0x00007fb970e6c494 in start_thread (arg=0x7fb95b7fe700) at pthread_create.c:333
|
#6 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 16 (Thread 0x7fb9681bc700 (LWP 30259)):
|
#0 0x00007fb96e6f56ad in poll () at ../sysdeps/unix/syscall-template.S:84
|
#1 0x00005642a0327bca in vio_io_wait (vio=0x5642a34d2ab0, event=VIO_IO_EVENT_READ, timeout=28800000) at /home/jan/mysql/10.2-orig/vio/viosocket.c:945
|
#2 0x00005642a03263d9 in vio_socket_io_wait (vio=0x5642a34d2ab0, event=VIO_IO_EVENT_READ) at /home/jan/mysql/10.2-orig/vio/viosocket.c:108
|
#3 0x00005642a032658f in vio_read (vio=0x5642a34d2ab0, buf=0x7fb904008890 "\a", size=4) at /home/jan/mysql/10.2-orig/vio/viosocket.c:184
|
#4 0x000056429f81b97f in my_real_read (net=0x7fb904000dc8, complen=0x7fb9681bb7c0, header=1 '\001') at /home/jan/mysql/10.2-orig/sql/net_serv.cc:888
|
#5 0x000056429f81c17e in my_net_read_packet_reallen (net=0x7fb904000dc8, read_from_server=1 '\001', reallen=0x7fb9681bb828) at /home/jan/mysql/10.2-orig/sql/net_serv.cc:1158
|
#6 0x000056429f81c132 in my_net_read_packet (net=0x7fb904000dc8, read_from_server=1 '\001') at /home/jan/mysql/10.2-orig/sql/net_serv.cc:1142
|
#7 0x000056429f8e4295 in do_command (thd=0x7fb904000b00) at /home/jan/mysql/10.2-orig/sql/sql_parse.cc:1242
|
#8 0x000056429fa30847 in do_handle_one_connection (connect=0x5642a3430320) at /home/jan/mysql/10.2-orig/sql/sql_connect.cc:1354
|
#9 0x000056429fa305c7 in handle_one_connection (arg=0x5642a3430320) at /home/jan/mysql/10.2-orig/sql/sql_connect.cc:1260
|
#10 0x00005642a0268753 in pfs_spawn_thread (arg=0x5642a34d2e70) at /home/jan/mysql/10.2-orig/storage/perfschema/pfs.cc:1862
|
#11 0x00007fb970e6c494 in start_thread (arg=0x7fb9681bc700) at pthread_create.c:333
|
#12 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 15 (Thread 0x7fb9682e4700 (LWP 30251)):
|
#0 do_sigwait (set=<optimized out>, set@entry=0x7fb9682e3cb0, sig=sig@entry=0x7fb9682e3c80) at ../sysdeps/unix/sysv/linux/sigwait.c:64
|
#1 0x00007fb970e75ced in __sigwait (set=0x7fb9682e3cb0, sig=0x7fb9682e3c80) at ../sysdeps/unix/sysv/linux/sigwait.c:96
|
#2 0x000056429f80ce22 in signal_hand (arg=0x0) at /home/jan/mysql/10.2-orig/sql/mysqld.cc:3499
|
#3 0x00005642a0268753 in pfs_spawn_thread (arg=0x5642a3408d20) at /home/jan/mysql/10.2-orig/storage/perfschema/pfs.cc:1862
|
#4 0x00007fb970e6c494 in start_thread (arg=0x7fb9682e4700) at pthread_create.c:333
|
#5 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 14 (Thread 0x7fb960ff9700 (LWP 30234)):
|
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
|
#1 0x000056429fe238be in os_event::timed_wait (this=0x5642a2f46120, abstime=0x7fb960ff8aa0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:286
|
#2 0x000056429fe23bf2 in os_event::wait_time_low (this=0x5642a2f46120, time_in_usec=1000000, reset_sig_count=2) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:413
|
#3 0x000056429fe23dac in os_event_wait_time_low (event=0x5642a2f46120, time_in_usec=1000000, reset_sig_count=2) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:518
|
#4 0x000056429fffa0e8 in pc_sleep_if_needed (next_loop_time=1507817677992, sig_count=2) at /home/jan/mysql/10.2-orig/storage/innobase/buf/buf0flu.cc:2717
|
#5 0x000056429fffb1d5 in buf_flush_page_cleaner_coordinator () at /home/jan/mysql/10.2-orig/storage/innobase/buf/buf0flu.cc:3212
|
#6 0x00007fb970e6c494 in start_thread (arg=0x7fb960ff9700) at pthread_create.c:333
|
#7 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 13 (Thread 0x7fb9527fc700 (LWP 30247)):
|
#0 0x00007fb970e757dd in nanosleep () at ../sysdeps/unix/syscall-template.S:84
|
#1 0x000056429fe24348 in os_thread_sleep (tm=1000000) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0thread.cc:230
|
#2 0x000056429ffcc58f in btr_defragment_thread () at /home/jan/mysql/10.2-orig/storage/innobase/btr/btr0defragment.cc:760
|
#3 0x00007fb970e6c494 in start_thread (arg=0x7fb9527fc700) at pthread_create.c:333
|
#4 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 12 (Thread 0x7fb962ffd700 (LWP 30230)):
|
#0 0x00007fb9701e86ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#1 0x000056429fe179d7 in LinuxAIOHandler::collect (this=0x7fb962ffcaa0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:1896
|
#2 0x000056429fe17f0d in LinuxAIOHandler::poll (this=0x7fb962ffcaa0, m1=0x7fb962ffcb48, m2=0x7fb962ffcb50, request=0x7fb962ffcb80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:2041
|
#3 0x000056429fe18087 in os_aio_linux_handler (global_segment=2, m1=0x7fb962ffcb48, m2=0x7fb962ffcb50, request=0x7fb962ffcb80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:2095
|
#4 0x000056429fe1cacd in os_aio_handler (segment=2, m1=0x7fb962ffcb48, m2=0x7fb962ffcb50, request=0x7fb962ffcb80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:5740
|
#5 0x00005642a0070376 in fil_aio_wait (segment=2) at /home/jan/mysql/10.2-orig/storage/innobase/fil/fil0fil.cc:5295
|
#6 0x000056429ff16e87 in io_handler_thread (arg=0x5642a0e8a9b0 <n+16>) at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0start.cc:343
|
#7 0x00007fb970e6c494 in start_thread (arg=0x7fb962ffd700) at pthread_create.c:333
|
#8 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 11 (Thread 0x7fb94affd700 (LWP 30245)):
|
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
|
#1 0x000056429fe24028 in os_event::wait (this=0x5642a2f45ea0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:166
|
#2 0x000056429fe23a54 in os_event::wait_low (this=0x5642a2f45ea0, reset_sig_count=214) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:336
|
#3 0x000056429fe23dd1 in os_event_wait_low (event=0x5642a2f45ea0, reset_sig_count=0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:535
|
#4 0x000056429ff103d8 in srv_resume_thread (slot=0x5642a0c56938 <srv_sys+440>, sig_count=0, wait=true, timeout_usec=0) at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0srv.cc:940
|
#5 0x000056429ff13ed9 in srv_worker_thread (arg=0x0) at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0srv.cc:2647
|
#6 0x00007fb970e6c494 in start_thread (arg=0x7fb94affd700) at pthread_create.c:333
|
#7 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 10 (Thread 0x7fb952ffd700 (LWP 30246)):
|
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
|
#1 0x000056429fe24028 in os_event::wait (this=0x5642a2f460a0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:166
|
#2 0x000056429fe23a54 in os_event::wait_low (this=0x5642a2f460a0, reset_sig_count=1) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:336
|
#3 0x000056429fe23dd1 in os_event_wait_low (event=0x5642a2f460a0, reset_sig_count=0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:535
|
#4 0x000056429fff0c5a in buf_dump_thread () at /home/jan/mysql/10.2-orig/storage/innobase/buf/buf0dump.cc:824
|
#5 0x00007fb970e6c494 in start_thread (arg=0x7fb952ffd700) at pthread_create.c:333
|
#6 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 9 (Thread 0x7fb9711e7d00 (LWP 30226)):
|
#0 0x00007fb96e6f56ad in poll () at ../sysdeps/unix/syscall-template.S:84
|
#1 0x000056429f812c15 in handle_connections_sockets () at /home/jan/mysql/10.2-orig/sql/mysqld.cc:6598
|
#2 0x000056429f811ed2 in mysqld_main (argc=144, argv=0x5642a2d90160) at /home/jan/mysql/10.2-orig/sql/mysqld.cc:6064
|
#3 0x000056429f8065b0 in main (argc=22, argv=0x7ffee3dbb3b8) at /home/jan/mysql/10.2-orig/sql/main.cc:25
|
|
|
Thread 8 (Thread 0x7fb9637fe700 (LWP 30229)):
|
#0 0x00007fb9701e86ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#1 0x000056429fe179d7 in LinuxAIOHandler::collect (this=0x7fb9637fdaa0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:1896
|
#2 0x000056429fe17f0d in LinuxAIOHandler::poll (this=0x7fb9637fdaa0, m1=0x7fb9637fdb48, m2=0x7fb9637fdb50, request=0x7fb9637fdb80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:2041
|
#3 0x000056429fe18087 in os_aio_linux_handler (global_segment=1, m1=0x7fb9637fdb48, m2=0x7fb9637fdb50, request=0x7fb9637fdb80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:2095
|
#4 0x000056429fe1cacd in os_aio_handler (segment=1, m1=0x7fb9637fdb48, m2=0x7fb9637fdb50, request=0x7fb9637fdb80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:5740
|
#5 0x00005642a0070376 in fil_aio_wait (segment=1) at /home/jan/mysql/10.2-orig/storage/innobase/fil/fil0fil.cc:5295
|
#6 0x000056429ff16e87 in io_handler_thread (arg=0x5642a0e8a9a8 <n+8>) at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0start.cc:343
|
#7 0x00007fb970e6c494 in start_thread (arg=0x7fb9637fe700) at pthread_create.c:333
|
#8 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 7 (Thread 0x7fb9597fa700 (LWP 30241)):
|
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
|
#1 0x000056429fe238be in os_event::timed_wait (this=0x5642a30de590, abstime=0x7fb9597f9af0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:286
|
#2 0x000056429fe23bf2 in os_event::wait_time_low (this=0x5642a30de590, time_in_usec=5000000, reset_sig_count=1) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:413
|
#3 0x000056429fe23dac in os_event_wait_time_low (event=0x5642a30de590, time_in_usec=5000000, reset_sig_count=1) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:518
|
#4 0x000056429ff7d930 in ib_wqueue_timedwait (wq=0x5642a30de420, wait_in_usecs=5000000) at /home/jan/mysql/10.2-orig/storage/innobase/ut/ut0wqueue.cc:163
|
#5 0x00005642a00b7fe0 in fts_optimize_thread (arg=0x5642a30de420) at /home/jan/mysql/10.2-orig/storage/innobase/fts/fts0opt.cc:3041
|
#6 0x00007fb970e6c494 in start_thread (arg=0x7fb9597fa700) at pthread_create.c:333
|
#7 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 6 (Thread 0x7fb959ffb700 (LWP 30240)):
|
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
|
#1 0x000056429fe238be in os_event::timed_wait (this=0x5642a3096aa0, abstime=0x7fb959ffad20) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:286
|
#2 0x000056429fe23bf2 in os_event::wait_time_low (this=0x5642a3096aa0, time_in_usec=10000000, reset_sig_count=1) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:413
|
#3 0x000056429fe23dac in os_event_wait_time_low (event=0x5642a3096aa0, time_in_usec=10000000, reset_sig_count=0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:518
|
#4 0x00005642a0057607 in dict_stats_thread () at /home/jan/mysql/10.2-orig/storage/innobase/dict/dict0stats_bg.cc:451
|
#5 0x00007fb970e6c494 in start_thread (arg=0x7fb959ffb700) at pthread_create.c:333
|
#6 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 5 (Thread 0x7fb95a7fc700 (LWP 30239)):
|
#0 0x00007fb970e757dd in nanosleep () at ../sysdeps/unix/syscall-template.S:84
|
#1 0x000056429fe24348 in os_thread_sleep (tm=1000000) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0thread.cc:230
|
#2 0x000056429ff13906 in srv_master_sleep () at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0srv.cc:2458
|
#3 0x000056429ff13a44 in srv_master_thread (arg=0x0) at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0srv.cc:2503
|
#4 0x00007fb970e6c494 in start_thread (arg=0x7fb95a7fc700) at pthread_create.c:333
|
#5 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 4 (Thread 0x7fb95bfff700 (LWP 30236)):
|
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
|
#1 0x000056429fe238be in os_event::timed_wait (this=0x5642a3083700, abstime=0x7fb95bffed00) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:286
|
#2 0x000056429fe23bf2 in os_event::wait_time_low (this=0x5642a3083700, time_in_usec=1000000, reset_sig_count=1) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:413
|
#3 0x000056429fe23dac in os_event_wait_time_low (event=0x5642a3083700, time_in_usec=1000000, reset_sig_count=1) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0event.cc:518
|
#4 0x000056429fdf28a3 in lock_wait_timeout_thread () at /home/jan/mysql/10.2-orig/storage/innobase/lock/lock0wait.cc:529
|
#5 0x00007fb970e6c494 in start_thread (arg=0x7fb95bfff700) at pthread_create.c:333
|
#6 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 3 (Thread 0x7fb9617fa700 (LWP 30233)):
|
#0 0x00007fb9701e86ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
|
#1 0x000056429fe179d7 in LinuxAIOHandler::collect (this=0x7fb9617f9aa0) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:1896
|
#2 0x000056429fe17f0d in LinuxAIOHandler::poll (this=0x7fb9617f9aa0, m1=0x7fb9617f9b48, m2=0x7fb9617f9b50, request=0x7fb9617f9b80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:2041
|
#3 0x000056429fe18087 in os_aio_linux_handler (global_segment=5, m1=0x7fb9617f9b48, m2=0x7fb9617f9b50, request=0x7fb9617f9b80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:2095
|
#4 0x000056429fe1cacd in os_aio_handler (segment=5, m1=0x7fb9617f9b48, m2=0x7fb9617f9b50, request=0x7fb9617f9b80) at /home/jan/mysql/10.2-orig/storage/innobase/os/os0file.cc:5740
|
#5 0x00005642a0070376 in fil_aio_wait (segment=5) at /home/jan/mysql/10.2-orig/storage/innobase/fil/fil0fil.cc:5295
|
#6 0x000056429ff16e87 in io_handler_thread (arg=0x5642a0e8a9c8 <n+40>) at /home/jan/mysql/10.2-orig/storage/innobase/srv/srv0start.cc:343
|
#7 0x00007fb970e6c494 in start_thread (arg=0x7fb9617fa700) at pthread_create.c:333
|
#8 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 2 (Thread 0x7fb969b2d700 (LWP 30227)):
|
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225
|
#1 0x00005642a02c7cee in safe_cond_timedwait (cond=0x5642a16ac3a0 <COND_timer>, mp=0x5642a16ac2e0 <LOCK_timer>, abstime=0x7fb969b2cd30, file=0x5642a0600dd0 "/home/jan/mysql/10.2-orig/include/mysql/psi/mysql_thread.h", line=1175) at /home/jan/mysql/10.2-orig/mysys/thr_mutex.c:545
|
#2 0x00005642a02c8c63 in inline_mysql_cond_timedwait (that=0x5642a16ac3a0 <COND_timer>, mutex=0x5642a16ac2e0 <LOCK_timer>, abstime=0x7fb969b2cd30, src_file=0x5642a0600e10 "/home/jan/mysql/10.2-orig/mysys/thr_timer.c", src_line=292) at /home/jan/mysql/10.2-orig/include/mysql/psi/mysql_thread.h:1175
|
#3 0x00005642a02c9770 in timer_handler (arg=0x0) at /home/jan/mysql/10.2-orig/mysys/thr_timer.c:292
|
#4 0x00005642a0268753 in pfs_spawn_thread (arg=0x5642a2ed5700) at /home/jan/mysql/10.2-orig/storage/perfschema/pfs.cc:1862
|
#5 0x00007fb970e6c494 in start_thread (arg=0x7fb969b2d700) at pthread_create.c:333
|
#6 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
|
Thread 1 (Thread 0x7fb968206700 (LWP 30258)):
|
#0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
|
#1 0x00005642a02c2466 in my_write_core (sig=6) at /home/jan/mysql/10.2-orig/mysys/stacktrace.c:477
|
#2 0x000056429fb566fe in handle_fatal_signal (sig=6) at /home/jan/mysql/10.2-orig/sql/signal_handler.cc:303
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
|
#5 0x00007fb96e64a3fa in __GI_abort () at abort.c:89
|
#6 0x00007fb96e641e37 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x5642a047f0a0 "offset >= ((38U + 36 + 2 * 10) + 5)", file=file@entry=0x5642a047f028 "/home/jan/mysql/10.2-orig/storage/innobase/include/page0page.h", line=line@entry=318, function=function@entry=0x5642a0483720 <page_rec_is_infimum_low(unsigned long)::__PRETTY_FUNCTION__> "bool page_rec_is_infimum_low(ulint)") at assert.c:92
|
#7 0x00007fb96e641ee2 in __GI___assert_fail (assertion=0x5642a047f0a0 "offset >= ((38U + 36 + 2 * 10) + 5)", file=0x5642a047f028 "/home/jan/mysql/10.2-orig/storage/innobase/include/page0page.h", line=318, function=0x5642a0483720 <page_rec_is_infimum_low(unsigned long)::__PRETTY_FUNCTION__> "bool page_rec_is_infimum_low(ulint)") at assert.c:101
|
#8 0x000056429fdd0482 in page_rec_is_infimum_low (offset=0) at /home/jan/mysql/10.2-orig/storage/innobase/include/page0page.h:318
|
#9 0x000056429fe369f2 in page_check_dir (page=0x7fb91004c000 "") at /home/jan/mysql/10.2-orig/storage/innobase/page/page0page.cc:1979
|
#10 0x000056429fe29a98 in page_cur_search_with_match (block=0x7fb91005c360, index=0x7fb90c03a4d8, tuple=0x7fb91001d728, mode=PAGE_CUR_LE, iup_matched_fields=0x7fb968202648, ilow_matched_fields=0x7fb968202640, cursor=0x7fb968202700, rtr_info=0x0) at /home/jan/mysql/10.2-orig/storage/innobase/page/page0cur.cc:358
|
#11 0x000056429fed2f4a in page_cur_search (block=0x7fb91005c360, index=0x7fb90c03a4d8, tuple=0x7fb91001d728, mode=PAGE_CUR_LE, cursor=0x7fb968202700) at /home/jan/mysql/10.2-orig/storage/innobase/include/page0cur.ic:222
|
#12 0x000056429fedafae in row_sel_get_clust_rec_for_mysql (prebuilt=0x7fb90c0b0b68, sec_index=0x7fb90c03a4d8, rec=0x7fb91004d156 "", thr=0x7fb90c0b15c8, out_rec=0x7fb968202940, offsets=0x7fb968202960, offset_heap=0x7fb968202958, vrow=0x0, mtr=0x7fb968203500) at /home/jan/mysql/10.2-orig/storage/innobase/row/row0sel.cc:3404
|
#13 0x000056429fedf279 in row_search_mvcc (buf=0x7fb90c172d98 "\377", mode=PAGE_CUR_CONTAIN, prebuilt=0x7fb90c0b0b68, match_mode=0, direction=0) at /home/jan/mysql/10.2-orig/storage/innobase/row/row0sel.cc:5237
|
#14 0x000056429fd667b9 in ha_innobase::index_read (this=0x7fb90c04ec18, buf=0x7fb90c172d98 "\377", key_ptr=0x7fb91001e028 "", key_len=34, find_flag=HA_READ_MBR_CONTAIN) at /home/jan/mysql/10.2-orig/storage/innobase/handler/ha_innodb.cc:9823
|
#15 0x000056429fb67224 in handler::index_read_map (this=0x7fb90c04ec18, buf=0x7fb90c172d98 "\377", key=0x7fb91001e028 "", keypart_map=1, find_flag=HA_READ_MBR_CONTAIN) at /home/jan/mysql/10.2-orig/sql/handler.h:3116
|
#16 0x000056429fb5d52b in handler::ha_index_read_map (this=0x7fb90c04ec18, buf=0x7fb90c172d98 "\377", key=0x7fb91001e028 "", keypart_map=1, find_flag=HA_READ_MBR_CONTAIN) at /home/jan/mysql/10.2-orig/sql/handler.cc:2626
|
#17 0x000056429fcb237e in QUICK_RANGE_SELECT_GEOM::get_next (this=0x7fb910006580) at /home/jan/mysql/10.2-orig/sql/opt_range.cc:11511
|
#18 0x000056429fcc2c6c in rr_quick (info=0x7fb910013790) at /home/jan/mysql/10.2-orig/sql/records.cc:366
|
#19 0x000056429f95b8de in join_init_read_record (tab=0x7fb9100136c8) at /home/jan/mysql/10.2-orig/sql/sql_select.cc:19485
|
#20 0x000056429f9596aa in sub_select (join=0x7fb910011de0, join_tab=0x7fb9100136c8, end_of_records=false) at /home/jan/mysql/10.2-orig/sql/sql_select.cc:18560
|
#21 0x000056429f958c93 in do_select (join=0x7fb910011de0, procedure=0x0) at /home/jan/mysql/10.2-orig/sql/sql_select.cc:18107
|
#22 0x000056429f9338ff in JOIN::exec_inner (this=0x7fb910011de0) at /home/jan/mysql/10.2-orig/sql/sql_select.cc:3483
|
#23 0x000056429f932db0 in JOIN::exec (this=0x7fb910011de0) at /home/jan/mysql/10.2-orig/sql/sql_select.cc:3278
|
#24 0x000056429f933f70 in mysql_select (thd=0x7fb910000b00, tables=0x7fb910011380, wild_num=0, fields=..., conds=0x7fb910011c00, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fb910011dc0, unit=0x7fb9100046a0, select_lex=0x7fb910004dd8) at /home/jan/mysql/10.2-orig/sql/sql_select.cc:3678
|
#25 0x000056429f92891b in handle_select (thd=0x7fb910000b00, lex=0x7fb9100045d8, result=0x7fb910011dc0, setup_tables_done_option=0) at /home/jan/mysql/10.2-orig/sql/sql_select.cc:361
|
#26 0x000056429f8f4767 in execute_sqlcom_select (thd=0x7fb910000b00, all_tables=0x7fb910011380) at /home/jan/mysql/10.2-orig/sql/sql_parse.cc:6427
|
#27 0x000056429f8ea4ba in mysql_execute_command (thd=0x7fb910000b00) at /home/jan/mysql/10.2-orig/sql/sql_parse.cc:3461
|
#28 0x000056429f8f8103 in mysql_parse (thd=0x7fb910000b00, rawbuf=0x7fb910011078 "select count(*) from t1 where MBRWithin(t1.c2, @g1)", length=51, parser_state=0x7fb968205080, is_com_multi=false, is_next_command=false) at /home/jan/mysql/10.2-orig/sql/sql_parse.cc:7868
|
#29 0x000056429f8e5e17 in dispatch_command (command=COM_QUERY, thd=0x7fb910000b00, packet=0x7fb910008891 "", packet_length=52, is_com_multi=false, is_next_command=false) at /home/jan/mysql/10.2-orig/sql/sql_parse.cc:1812
|
#30 0x000056429f8e47c6 in do_command (thd=0x7fb910000b00) at /home/jan/mysql/10.2-orig/sql/sql_parse.cc:1359
|
#31 0x000056429fa30847 in do_handle_one_connection (connect=0x5642a34c7d60) at /home/jan/mysql/10.2-orig/sql/sql_connect.cc:1354
|
#32 0x000056429fa305c7 in handle_one_connection (arg=0x5642a34c7d60) at /home/jan/mysql/10.2-orig/sql/sql_connect.cc:1260
|
#33 0x00005642a0268753 in pfs_spawn_thread (arg=0x5642a34d2ab0) at /home/jan/mysql/10.2-orig/storage/perfschema/pfs.cc:1862
|
#34 0x00007fb970e6c494 in start_thread (arg=0x7fb968206700) at pthread_create.c:333
|
#35 0x00007fb96e6feaff in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
Attachments
Issue Links
- relates to
-
-
- Closed
-
-
-
- Open
-
-
-
- Confirmed
-
-
-
- Open
-
-
-
- Stalled
-
Activity
The failure occurs in the SPATIAL INDEX root page.
The purpose of the test is to see what happens when ROLLBACK removes records while an R-tree search is in effect.
The crash occurs in a debug check. With the following patch (reverting to MySQL 5.7 behaviour), the test will complete (with some result difference):
diff --git a/storage/innobase/row/row0sel.cc b/storage/innobase/row/row0sel.cc
|
index 9cad3ab7de6..c0e9f103f45 100644
|
--- a/storage/innobase/row/row0sel.cc
|
+++ b/storage/innobase/row/row0sel.cc
|
@@ -3392,8 +3392,14 @@ row_sel_get_clust_rec_for_mysql(
|
goto func_exit;
|
}
|
|
- buf_block_t* block = btr_pcur_get_block(
|
- prebuilt->pcur);
|
+ /* FIXME: Why is this block not the
|
+ same as btr_pcur_get_block(prebuilt->pcur),
|
+ and is it not unsafe to use RW_NO_LATCH here? */
|
+ buf_block_t* block = buf_page_get_gen(
|
+ btr_pcur_get_block(prebuilt->pcur)->page.id,
|
+ dict_table_page_size(sec_index->table),
|
+ RW_NO_LATCH, NULL, BUF_GET,
|
+ __FILE__, __LINE__, mtr, &err);
|
mem_heap_t* heap = mem_heap_create(256);
|
dtuple_t* tuple = dict_index_build_data_tuple(
|
rec, sec_index, true, |
The call to buf_page_get_gen() seems redundant, but for some reason the block is not the same as btr_pcur_get_block(prebuilt->pcur). The RW_NO_LATCH seems dangerous, because we are not prohibiting concurrent modifications to the page.
This screams that it is only a work-around, and the SPATIAL INDEX code in MySQL 5.7 is doing something strange. A SELECT concurrently with the ROLLBACK of an INSERT could crash in non-debug servers as well. For purge, I believe that there is a workaround that would leave garbage in the R-tree index when it is considered unsafe to perform the purge.
Please debug this further. I can confirm the failure.
The tail of the page (from offset 0x11a8 onwards to the end of the 16k page) is all zero.
The test uses debug instrumentation, so it may be related to this.