Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 11.8.2
-
None
Description
Uncompressing a table with parallel-recovers stalls at around 268KB of TMD file. The original table is 2GB compressed and 3.4GB uncompressed.
Command used:
myisamchk --tmpdir=/mnt/bv/db/mysql/../tmp --unpack --force --safe-recover --sort-index --analyze --parallel-recover /mnt/bv/db/mysql/BV/ctgov_paper
|
Thread 7 (Thread 0x7f28ac5c46c0 (LWP 299838) "myisamchk"):
|
#0 __syscall_cancel_arch () at ../sysdeps/unix/sysv/linux/x86_64/syscall_cancel.S:56
|
#1 0x00007f28ac656668 in __internal_syscall_cancel (a1=<optimized out>, a2=<optimized out>, a3=<optimized out>, a4=<optimized out>, a5=a5@entry=0, a6=a6@entry=4294967295, nr=202) at ./nptl/cancellation.c:49
|
#2 0x00007f28ac656c9c in __futex_abstimed_wait_common64 (private=0, futex_word=0x7ffdea1708e8, expected=<optimized out>, op=<optimized out>, abstime=0x0, cancel=true) at ./nptl/futex-internal.c:57
|
#3 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x7ffdea1708e8, expected=<optimized out>, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#4 0x00007f28ac656cfb in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x7ffdea1708e8, expected=<optimized out>, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#5 0x00007f28ac659158 in __pthread_cond_wait_common (cond=0x7ffdea1708c8, mutex=0x7ffdea170860, clockid=0, abstime=0x0) at ./nptl/pthread_cond_wait.c:426
|
#6 ___pthread_cond_wait (cond=cond@entry=0x7ffdea1708c8, mutex=mutex@entry=0x7ffdea170860) at ./nptl/pthread_cond_wait.c:458
|
#7 0x000055a01208d149 in inline_mysql_cond_wait (src_file=0x55a01210aef1 "./mysys/mf_iocache.c", that=<optimized out>, mutex=0x7ffdea170860, src_line=1084) at ./include/mysql/psi/mysql_thread.h:1072
|
#8 lock_io_cache (cache=cache@entry=0x55a02bce0ef8, pos=pos@entry=262144) at ./mysys/mf_iocache.c:1084
|
#9 0x000055a01208da10 in copy_to_read_buffer (write_cache=0x55a02bce0ef8, write_buffer=0x55a02bd86328 "TERVENTIONAL\001\aA@\376o", pos_in_file=262144) at ./mysys/mf_iocache.c:1396
|
#10 _my_b_cache_write_r (info=0x55a02bce0ef8, Buffer=<optimized out>, Count=<optimized out>) at ./mysys/mf_iocache.c:1633
|
#11 0x000055a01208f4a2 in my_b_flush_io_cache (info=info@entry=0x55a02bce0ef8, need_append_buffer_lock=0, need_append_buffer_lock@entry=1) at ./mysys/mf_iocache.c:1810
|
#12 0x000055a01208fea6 in _my_b_write (info=info@entry=0x55a02bce0ef8, Buffer=0x7f28a4002d89 "ere on the average thicker and flatter and had a larger diameter.~Following the dispensing visit, subjects progressed through three study phases. In the adaption phase (Phase A), subjects were examine"..., Count=1564, Count@entry=9800) at ./mysys/mf_iocache.c:637
|
#13 0x000055a01205f829 in my_b_write (info=0x55a02bce0ef8, Buffer=<optimized out>, Count=9800) at ./include/my_sys.h:555
|
#14 _mi_write_part_record (info=info@entry=0x55a02bce0cd8, filepos=filepos@entry=0, length=length@entry=9800, next_filepos=<optimized out>, record=record@entry=0x7f28ac5c3df0, reclength=reclength@entry=0x7f28ac5c3de8, flag=0x7f28ac5c3de4) at ./storage/myisam/mi_dynrec.c:760
|
#15 0x000055a012051194 in sort_write_record (sort_param=0x55a02be06368) at ./storage/myisam/mi_check.c:3753
|
#16 0x000055a012080a07 in thr_find_all_keys_exec (sort_param=0x55a02be06368) at ./storage/myisam/sort.c:475
|
#17 thr_find_all_keys (arg=0x55a02be06368) at ./storage/myisam/sort.c:541
|
#18 0x00007f28ac659b7b in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:448
|
#19 0x00007f28ac6d77b8 in __GI___clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
 |
Thread 6 (Thread 0x7f28abdc36c0 (LWP 299839) "myisamchk"):
|
#0 __syscall_cancel_arch () at ../sysdeps/unix/sysv/linux/x86_64/syscall_cancel.S:56
|
#1 0x00007f28ac656668 in __internal_syscall_cancel (a1=<optimized out>, a2=<optimized out>, a3=<optimized out>, a4=<optimized out>, a5=a5@entry=0, a6=a6@entry=4294967295, nr=202) at ./nptl/cancellation.c:49
|
#2 0x00007f28ac656c9c in __futex_abstimed_wait_common64 (private=0, futex_word=0x7ffdea1708b4, expected=<optimized out>, op=<optimized out>, abstime=0x0, cancel=true) at ./nptl/futex-internal.c:57
|
#3 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x7ffdea1708b4, expected=<optimized out>, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#4 0x00007f28ac656cfb in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x7ffdea1708b4, expected=<optimized out>, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#5 0x00007f28ac659158 in __pthread_cond_wait_common (cond=0x7ffdea170890, mutex=0x7ffdea170860, clockid=0, abstime=0x0) at ./nptl/pthread_cond_wait.c:426
|
#6 ___pthread_cond_wait (cond=cond@entry=0x7ffdea170890, mutex=mutex@entry=0x7ffdea170860) at ./nptl/pthread_cond_wait.c:458
|
#7 0x000055a01208d01e in inline_mysql_cond_wait (src_file=0x55a01210aef1 "./mysys/mf_iocache.c", src_line=1108, that=0x7ffdea170890, mutex=0x7ffdea170860) at ./include/mysql/psi/mysql_thread.h:1072
|
#8 lock_io_cache (cache=cache@entry=0x55a02be06a08, pos=pos@entry=136312) at ./mysys/mf_iocache.c:1108
|
#9 0x000055a01208d21a in _my_b_cache_read_r (cache=0x55a02be06a08, Buffer=0x7f28abdc2d90 "", Count=10) at ./mysys/mf_iocache.c:1284
|
#10 0x000055a01208f2b6 in _my_b_read (info=info@entry=0x55a02be06a08, Buffer=<optimized out>, Buffer@entry=0x7f28abdc2d90 "", Count=Count@entry=10) at ./mysys/mf_iocache.c:610
|
#11 0x000055a012086bbb in _mi_read_cache (info=info@entry=0x55a02be06a08, buff=buff@entry=0x7f28abdc2d90 "", pos=136312, length=10, flag=flag@entry=1) at ./storage/myisam/mi_cache.c:85
|
#12 0x000055a01204a341 in sort_get_next_record (sort_param=sort_param@entry=0x55a02be06a00) at ./storage/myisam/mi_check.c:3600
|
#13 0x000055a0120513e5 in sort_key_read (sort_param=0x55a02be06a00, key=0x7f289ad54a70) at ./storage/myisam/mi_check.c:3133
|
#14 0x000055a012080a07 in thr_find_all_keys_exec (sort_param=0x55a02be06a00) at ./storage/myisam/sort.c:475
|
#15 thr_find_all_keys (arg=0x55a02be06a00) at ./storage/myisam/sort.c:541
|
#16 0x00007f28ac659b7b in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:448
|
#17 0x00007f28ac6d77b8 in __GI___clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
 |
Thread 5 (Thread 0x7f28ab5c26c0 (LWP 299840) "myisamchk"):
|
#0 __syscall_cancel_arch () at ../sysdeps/unix/sysv/linux/x86_64/syscall_cancel.S:56
|
#1 0x00007f28ac656668 in __internal_syscall_cancel (a1=<optimized out>, a2=<optimized out>, a3=<optimized out>, a4=<optimized out>, a5=a5@entry=0, a6=a6@entry=4294967295, nr=202) at ./nptl/cancellation.c:49
|
#2 0x00007f28ac656c9c in __futex_abstimed_wait_common64 (private=0, futex_word=0x7ffdea1708b4, expected=<optimized out>, op=<optimized out>, abstime=0x0, cancel=true) at ./nptl/futex-internal.c:57
|
#3 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x7ffdea1708b4, expected=<optimized out>, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#4 0x00007f28ac656cfb in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x7ffdea1708b4, expected=<optimized out>, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#5 0x00007f28ac659158 in __pthread_cond_wait_common (cond=0x7ffdea170890, mutex=0x7ffdea170860, clockid=0, abstime=0x0) at ./nptl/pthread_cond_wait.c:426
|
#6 ___pthread_cond_wait (cond=cond@entry=0x7ffdea170890, mutex=mutex@entry=0x7ffdea170860) at ./nptl/pthread_cond_wait.c:458
|
#7 0x000055a01208d01e in inline_mysql_cond_wait (src_file=0x55a01210aef1 "./mysys/mf_iocache.c", src_line=1108, that=0x7ffdea170890, mutex=0x7ffdea170860) at ./include/mysql/psi/mysql_thread.h:1072
|
#8 lock_io_cache (cache=cache@entry=0x55a02be070a0, pos=pos@entry=136312) at ./mysys/mf_iocache.c:1108
|
#9 0x000055a01208d21a in _my_b_cache_read_r (cache=0x55a02be070a0, Buffer=0x7f28ab5c1d90 "", Count=10) at ./mysys/mf_iocache.c:1284
|
#10 0x000055a01208f2b6 in _my_b_read (info=info@entry=0x55a02be070a0, Buffer=<optimized out>, Buffer@entry=0x7f28ab5c1d90 "", Count=Count@entry=10) at ./mysys/mf_iocache.c:610
|
#11 0x000055a012086bbb in _mi_read_cache (info=info@entry=0x55a02be070a0, buff=buff@entry=0x7f28ab5c1d90 "", pos=136312, length=10, flag=flag@entry=1) at ./storage/myisam/mi_cache.c:85
|
#12 0x000055a01204a341 in sort_get_next_record (sort_param=sort_param@entry=0x55a02be07098) at ./storage/myisam/mi_check.c:3600
|
#13 0x000055a0120513e5 in sort_key_read (sort_param=0x55a02be07098, key=0x7f28997fea70) at ./storage/myisam/mi_check.c:3133
|
#14 0x000055a012080a07 in thr_find_all_keys_exec (sort_param=0x55a02be07098) at ./storage/myisam/sort.c:475
|
#15 thr_find_all_keys (arg=0x55a02be07098) at ./storage/myisam/sort.c:541
|
#16 0x00007f28ac659b7b in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:448
|
#17 0x00007f28ac6d77b8 in __GI___clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
 |
Thread 4 (Thread 0x7f28a986b6c0 (LWP 299841) "myisamchk"):
|
#0 __syscall_cancel_arch () at ../sysdeps/unix/sysv/linux/x86_64/syscall_cancel.S:56
|
#1 0x00007f28ac656668 in __internal_syscall_cancel (a1=<optimized out>, a2=<optimized out>, a3=<optimized out>, a4=<optimized out>, a5=a5@entry=0, a6=a6@entry=4294967295, nr=202) at ./nptl/cancellation.c:49
|
#2 0x00007f28ac656c9c in __futex_abstimed_wait_common64 (private=0, futex_word=0x7ffdea1708b4, expected=<optimized out>, op=<optimized out>, abstime=0x0, cancel=true) at ./nptl/futex-internal.c:57
|
#3 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x7ffdea1708b4, expected=<optimized out>, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#4 0x00007f28ac656cfb in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x7ffdea1708b4, expected=<optimized out>, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#5 0x00007f28ac659158 in __pthread_cond_wait_common (cond=0x7ffdea170890, mutex=0x7ffdea170860, clockid=0, abstime=0x0) at ./nptl/pthread_cond_wait.c:426
|
#6 ___pthread_cond_wait (cond=cond@entry=0x7ffdea170890, mutex=mutex@entry=0x7ffdea170860) at ./nptl/pthread_cond_wait.c:458
|
#7 0x000055a01208d01e in inline_mysql_cond_wait (src_file=0x55a01210aef1 "./mysys/mf_iocache.c", src_line=1108, that=0x7ffdea170890, mutex=0x7ffdea170860) at ./include/mysql/psi/mysql_thread.h:1072
|
#8 lock_io_cache (cache=cache@entry=0x55a02be07738, pos=pos@entry=136312) at ./mysys/mf_iocache.c:1108
|
#9 0x000055a01208d21a in _my_b_cache_read_r (cache=0x55a02be07738, Buffer=0x7f28a986ad90 "", Count=10) at ./mysys/mf_iocache.c:1284
|
#10 0x000055a01208f2b6 in _my_b_read (info=info@entry=0x55a02be07738, Buffer=<optimized out>, Buffer@entry=0x7f28a986ad90 "", Count=Count@entry=10) at ./mysys/mf_iocache.c:610
|
#11 0x000055a012086bbb in _mi_read_cache (info=info@entry=0x55a02be07738, buff=buff@entry=0x7f28a986ad90 "", pos=136312, length=10, flag=flag@entry=1) at ./storage/myisam/mi_cache.c:85
|
#12 0x000055a01204a341 in sort_get_next_record (sort_param=sort_param@entry=0x55a02be07730) at ./storage/myisam/mi_check.c:3600
|
#13 0x000055a0120513e5 in sort_key_read (sort_param=0x55a02be07730, key=0x7f2892d54a70) at ./storage/myisam/mi_check.c:3133
|
#14 0x000055a012080a07 in thr_find_all_keys_exec (sort_param=0x55a02be07730) at ./storage/myisam/sort.c:475
|
#15 thr_find_all_keys (arg=0x55a02be07730) at ./storage/myisam/sort.c:541
|
#16 0x00007f28ac659b7b in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:448
|
#17 0x00007f28ac6d77b8 in __GI___clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
 |
Thread 3 (Thread 0x7f28a906a6c0 (LWP 299842) "myisamchk"):
|
#0 __syscall_cancel_arch () at ../sysdeps/unix/sysv/linux/x86_64/syscall_cancel.S:56
|
--Type <RET> for more, q to quit, c to continue without paging--
|
#1 0x00007f28ac656668 in __internal_syscall_cancel (a1=<optimized out>, a2=<optimized out>, a3=<optimized out>, a4=<optimized out>, a5=a5@entry=0, a6=a6@entry=4294967295, nr=202) at ./nptl/cancellation.c:49
|
#2 0x00007f28ac656c9c in __futex_abstimed_wait_common64 (private=0, futex_word=0x7ffdea1708b4, expected=<optimized out>, op=<optimized out>, abstime=0x0, cancel=true) at ./nptl/futex-internal.c:57
|
#3 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x7ffdea1708b4, expected=<optimized out>, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#4 0x00007f28ac656cfb in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x7ffdea1708b4, expected=<optimized out>, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#5 0x00007f28ac659158 in __pthread_cond_wait_common (cond=0x7ffdea170890, mutex=0x7ffdea170860, clockid=0, abstime=0x0) at ./nptl/pthread_cond_wait.c:426
|
#6 ___pthread_cond_wait (cond=cond@entry=0x7ffdea170890, mutex=mutex@entry=0x7ffdea170860) at ./nptl/pthread_cond_wait.c:458
|
#7 0x000055a01208d01e in inline_mysql_cond_wait (src_file=0x55a01210aef1 "./mysys/mf_iocache.c", src_line=1108, that=0x7ffdea170890, mutex=0x7ffdea170860) at ./include/mysql/psi/mysql_thread.h:1072
|
#8 lock_io_cache (cache=cache@entry=0x55a02be07dd0, pos=pos@entry=136312) at ./mysys/mf_iocache.c:1108
|
#9 0x000055a01208d21a in _my_b_cache_read_r (cache=0x55a02be07dd0, Buffer=0x7f28a9069d90 "", Count=10) at ./mysys/mf_iocache.c:1284
|
#10 0x000055a01208f2b6 in _my_b_read (info=info@entry=0x55a02be07dd0, Buffer=<optimized out>, Buffer@entry=0x7f28a9069d90 "", Count=Count@entry=10) at ./mysys/mf_iocache.c:610
|
#11 0x000055a012086bbb in _mi_read_cache (info=info@entry=0x55a02be07dd0, buff=buff@entry=0x7f28a9069d90 "", pos=136312, length=10, flag=flag@entry=1) at ./storage/myisam/mi_cache.c:85
|
#12 0x000055a01204a341 in sort_get_next_record (sort_param=sort_param@entry=0x55a02be07dc8) at ./storage/myisam/mi_check.c:3600
|
#13 0x000055a0120513e5 in sort_key_read (sort_param=0x55a02be07dc8, key=0x7f2891e4f7b0) at ./storage/myisam/mi_check.c:3133
|
#14 0x000055a012080a07 in thr_find_all_keys_exec (sort_param=0x55a02be07dc8) at ./storage/myisam/sort.c:475
|
#15 thr_find_all_keys (arg=0x55a02be07dc8) at ./storage/myisam/sort.c:541
|
#16 0x00007f28ac659b7b in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:448
|
#17 0x00007f28ac6d77b8 in __GI___clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
 |
Thread 2 (Thread 0x7f28a88696c0 (LWP 299843) "myisamchk"):
|
#0 __syscall_cancel_arch () at ../sysdeps/unix/sysv/linux/x86_64/syscall_cancel.S:56
|
#1 0x00007f28ac656668 in __internal_syscall_cancel (a1=<optimized out>, a2=<optimized out>, a3=<optimized out>, a4=<optimized out>, a5=a5@entry=0, a6=a6@entry=4294967295, nr=202) at ./nptl/cancellation.c:49
|
#2 0x00007f28ac656c9c in __futex_abstimed_wait_common64 (private=0, futex_word=0x7ffdea1708b4, expected=<optimized out>, op=<optimized out>, abstime=0x0, cancel=true) at ./nptl/futex-internal.c:57
|
#3 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x7ffdea1708b4, expected=<optimized out>, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#4 0x00007f28ac656cfb in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x7ffdea1708b4, expected=<optimized out>, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#5 0x00007f28ac659158 in __pthread_cond_wait_common (cond=0x7ffdea170890, mutex=0x7ffdea170860, clockid=0, abstime=0x0) at ./nptl/pthread_cond_wait.c:426
|
#6 ___pthread_cond_wait (cond=cond@entry=0x7ffdea170890, mutex=mutex@entry=0x7ffdea170860) at ./nptl/pthread_cond_wait.c:458
|
#7 0x000055a01208d01e in inline_mysql_cond_wait (src_file=0x55a01210aef1 "./mysys/mf_iocache.c", src_line=1108, that=0x7ffdea170890, mutex=0x7ffdea170860) at ./include/mysql/psi/mysql_thread.h:1072
|
#8 lock_io_cache (cache=cache@entry=0x55a02be08468, pos=pos@entry=136312) at ./mysys/mf_iocache.c:1108
|
#9 0x000055a01208d21a in _my_b_cache_read_r (cache=0x55a02be08468, Buffer=0x7f28a8868d70 "\220", Count=10) at ./mysys/mf_iocache.c:1284
|
#10 0x000055a01208f2b6 in _my_b_read (info=info@entry=0x55a02be08468, Buffer=<optimized out>, Buffer@entry=0x7f28a8868d70 "\220", Count=Count@entry=10) at ./mysys/mf_iocache.c:610
|
#11 0x000055a012086bbb in _mi_read_cache (info=info@entry=0x55a02be08468, buff=buff@entry=0x7f28a8868d70 "\220", pos=136312, length=10, flag=flag@entry=1) at ./storage/myisam/mi_cache.c:85
|
#12 0x000055a01204a341 in sort_get_next_record (sort_param=sort_param@entry=0x55a02be08460) at ./storage/myisam/mi_check.c:3600
|
#13 0x000055a012051557 in sort_ft_key_read (sort_param=0x55a02be08460, key=0x7f288ac293d0) at ./storage/myisam/mi_check.c:3173
|
#14 0x000055a012080a07 in thr_find_all_keys_exec (sort_param=0x55a02be08460) at ./storage/myisam/sort.c:475
|
#15 thr_find_all_keys (arg=0x55a02be08460) at ./storage/myisam/sort.c:541
|
#16 0x00007f28ac659b7b in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:448
|
#17 0x00007f28ac6d77b8 in __GI___clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
 |
Thread 1 (Thread 0x7f28ac5c5b80 (LWP 299837) "myisamchk"):
|
#0 __syscall_cancel_arch () at ../sysdeps/unix/sysv/linux/x86_64/syscall_cancel.S:56
|
#1 0x00007f28ac656668 in __internal_syscall_cancel (a1=<optimized out>, a2=<optimized out>, a3=<optimized out>, a4=<optimized out>, a5=a5@entry=0, a6=a6@entry=4294967295, nr=202) at ./nptl/cancellation.c:49
|
#2 0x00007f28ac656c9c in __futex_abstimed_wait_common64 (private=0, futex_word=0x7ffdea1706d0, expected=<optimized out>, op=<optimized out>, abstime=0x0, cancel=true) at ./nptl/futex-internal.c:57
|
#3 __futex_abstimed_wait_common (futex_word=futex_word@entry=0x7ffdea1706d0, expected=<optimized out>, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0, cancel=cancel@entry=true) at ./nptl/futex-internal.c:87
|
#4 0x00007f28ac656cfb in __GI___futex_abstimed_wait_cancelable64 (futex_word=futex_word@entry=0x7ffdea1706d0, expected=<optimized out>, clockid=clockid@entry=0, abstime=abstime@entry=0x0, private=private@entry=0) at ./nptl/futex-internal.c:139
|
#5 0x00007f28ac659158 in __pthread_cond_wait_common (cond=0x7ffdea1706b0, mutex=0x7ffdea170680, clockid=0, abstime=0x0) at ./nptl/pthread_cond_wait.c:426
|
#6 ___pthread_cond_wait (cond=cond@entry=0x7ffdea1706b0, mutex=mutex@entry=0x7ffdea170680) at ./nptl/pthread_cond_wait.c:458
|
#7 0x000055a0120549d1 in inline_mysql_cond_wait (src_file=0x55a01210a421 "./storage/myisam/mi_check.c", src_line=2966, that=0x7ffdea1706b0, mutex=0x7ffdea170680) at ./include/mysql/psi/mysql_thread.h:1072
|
#8 mi_repair_parallel (param=param@entry=0x55a012520a20 <check_param>, info=<optimized out>, name=name@entry=0x7ffdea1726a8 "/mnt/bv/db/mysql/BV/ctgov_paper", rep_quick=rep_quick@entry=0) at ./storage/myisam/mi_check.c:2966
|
#9 0x000055a012049586 in myisamchk (filename=0x7ffdea1726a8 "/mnt/bv/db/mysql/BV/ctgov_paper", param=<optimized out>) at ./storage/myisam/myisamchk.c:1019
|
#10 0x000055a012044ea4 in main (argc=<optimized out>, argv=<optimized out>) at ./storage/myisam/myisamchk.c:88
|
(gdb)
|
Table structure:
CREATE TABLE `ctgov_paper` (
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
`pmid` varchar(16) NOT NULL,
|
`fileno` int(11) NOT NULL DEFAULT 0,
|
`sortable` int(11) NOT NULL,
|
`title` text NOT NULL DEFAULT '',
|
`html` mediumtext NOT NULL DEFAULT '',
|
`txt` mediumtext NOT NULL DEFAULT '',
|
`references_html` mediumtext NOT NULL DEFAULT '',
|
`phase` varchar(16) NOT NULL,
|
`type` varchar(16) NOT NULL,
|
`enrollment` int(11) DEFAULT NULL,
|
`has_results` tinyint(1) NOT NULL,
|
PRIMARY KEY (`id`),
|
KEY `pmid` (`pmid`),
|
KEY `fileno` (`fileno`),
|
KEY `phase` (`phase`),
|
KEY `type` (`type`),
|
KEY `enrollment` (`enrollment`),
|
FULLTEXT KEY `title` (`title`,`txt`)
|
) ENGINE=MyISAM AUTO_INCREMENT=544341 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
|
myisamchk configuration:
character-sets-dir (No default value)
|
data-file-length 0
|
keys-used 18446744073709551615
|
max-record-length 9223372036854775807
|
set-auto-increment 0
|
set-collation (No default value)
|
sort-records 0
|
tmpdir (No default value)
|
key-buffer-size 1044480
|
key-cache-block-size 1024
|
myisam-block-size 1024
|
read-buffer-size 261120
|
write-buffer-size 261120
|
sort-buffer-size 134216704
|
myisam-sort-buffer-size 134216704
|
sort-key-blocks 16
|
decode-bits 9
|
ft-min-word-len 4
|
ft-max-word-len 84
|
ft-stopword-file (No default value)
|
stats-method nulls_unequal
|
myisamchk -i output:
myisamchk -i /mnt/bv/db/mysql/BV/ctgov_paper
|
Checking MyISAM file: /mnt/bv/db/mysql/BV/ctgov_paper
|
Data records: 544340 Deleted blocks: 0
|
- check file-size
|
- check record delete-chain
|
- check key delete-chain
|
- check index reference
|
- check data record references index: 1
|
Key: 1: Keyblocks used: 98% Packed: 0% Max levels: 4
|
- check data record references index: 2
|
Key: 2: Keyblocks used: 98% Packed: 82% Max levels: 4
|
- check data record references index: 3
|
Key: 3: Keyblocks used: 98% Packed: 0% Max levels: 4
|
- check data record references index: 4
|
Key: 4: Keyblocks used: 99% Packed: 93% Max levels: 3
|
- check data record references index: 5
|
Key: 5: Keyblocks used: 99% Packed: 94% Max levels: 3
|
- check data record references index: 6
|
Key: 6: Keyblocks used: 97% Packed: -9% Max levels: 4
|
- check data record references index: 7
|
Key: 7: Keyblocks used: 93% Packed: 96% Max levels: 5
|
Total: Keyblocks used: 93% Packed: 95%
|
 |
- check record links
|
Records: 544340 M.recordlength: 4652 Packed: 0%
|
Recordspace used: 100% Empty space: 0% Blocks/Record: 1.00
|
Record blocks: 544340 Delete blocks: 0
|
Record data: 2532758119 Deleted data: 0
|
Lost space: 176927 Linkdata: 3267290
|
 |
User time 29.51, System time 1.16
|
Maximum resident set size 5896, Integral resident set size 0
|
Non-physical pagefaults 736, Physical pagefaults 13, Swaps 0
|
Blocks in 1033048 out 0, Messages in 0 out 0, Signals 0
|
Voluntary context switches 3166, Involuntary context switches 13653
|