Ok it stalls when I try to unpack an already packed table.
Here is the backtrace requested. Hope it helps...
root@node00:~# DEBUGINFOD_URLS="https://debuginfod.debian.net"; gdb -p `pidof myisamchk`
-ex "thr a a bt"
GNU gdb (Debian 16.3-1) 16.3
Copyright (C) 2024 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
Type "show copying" and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<https://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
<http://www.gnu.org/software/gdb/documentation/>.
For help, type "help".
Type "apropos word" to search for commands related to "word".
Attaching to process 299837
[New LWP 299843]
[New LWP 299842]
[New LWP 299841]
[New LWP 299840]
[New LWP 299839]
[New LWP 299838]
This GDB supports auto-downloading debuginfo from the following URLs:
<https://debuginfod.debian.net>
Enable debuginfod for this session? (y or [n]) y
Debuginfod has been enabled.
To make this setting permanent, add 'set debuginfod enabled on' to .gdbinit.
Downloading 4.97 M separate debug info for /usr/bin/myisamchk
Downloading 477.14 K separate debug info for
/root/.cache/debuginfod_client/811049469acae4b8b4be233b64f926092ffd3045/debuginfo
Downloading 124.44 K separate debug info for /lib/x86_64-linux-gnu/libz.so.1
Downloading 1.32 M separate debug info for /lib/x86_64-linux-gnu/libm.so.6
Downloading 4.12 M separate debug info for /lib/x86_64-linux-gnu/libc.so.6
Downloading 542.84 K separate debug info for /lib64/ld-linux-x86-64.so.2
Downloading 47.70 K separate debug info for system-supplied DSO at
0x7f28ac8e3000
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
Download failed: Invalid argument. Continuing without source file
./nptl/../sysdeps/unix/sysv/linux/x86_64/syscall_cancel.S.
__syscall_cancel_arch () at
../sysdeps/unix/sysv/linux/x86_64/syscall_cancel.S:56
warning: 56 ../sysdeps/unix/sysv/linux/x86_64/syscall_cancel.S: No such file or
directory
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
--Type <RET> for more, q to quit, c to continue without paging--
#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
#18 0x00007f28ac659b7b in start_thread (arg=<optimized out>) at
./nptl/pthread_create.c:448
--Type <RET> for more, q to quit, c to continue without paging--
#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)
On 7/5/25 8:58 PM, Sergey Vojtovich wrote:
Hi Vassilis,
Try something like gdb -p `pidof myisamchk` -ex "thr a a bt" and get back to us
with
provided output.
Regards,
Sergey
On Sat, Jul 5, 2025 at 9:02 PM Vassilis Virvilis via discuss
<discuss@lists.mariadb.org> wrote:
Hi,
Debian unstable here with mariadb 11.8.2-1
When I am trying to uncompress a maybe compressed table with
parallel-recovers it stalls in around 268KB of TMD file. The original table is
2GB compressed and 3.4GB uncompressed.
For now I remove the --parallel-recover flag.
Any ideas?
|root@node00:# ps auxw | grep ||myisamchk|
|root 1300496 0.0 0.0 584384 8188 pts/9 Sl+ 16:44 0:00
myisamchk --tmpdir=/mnt/bv/db/mysql/../tmp --unpack --force --safe-recover
--sort-index --analyze --parallel-recover /mnt/bv/db/mysql/BV/ctgov_paper
|
|root@node00:# strace -p 1300496
|
|strace: Process 1300496 attached
futex(0x7fff7bebeef0, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 0,
NULL, FUTEX_BITSET_MATCH_ANY^Cstrace: Process 1300496 detached
| |<detached ...>
| |
|
Vassilis|
|
|
|
_______________________________________________
discuss mailing list -- discuss@lists.mariadb.org
To unsubscribe send an email to discuss-le...@lists.mariadb.org
_______________________________________________
discuss mailing list -- discuss@lists.mariadb.org
To unsubscribe send an email to discuss-le...@lists.mariadb.org
