Vassilis, There is a stall in MariaDB IO_CACHE, which means it is likely a bug. I have created jira issue to track it https://jira.mariadb.org/browse/MDEV-37255
We need some additional information to get it reproduced on our side. 1. Table definition: SHOW CREATE TABLE ctgov_paper 2. myisamchk configuration (lines under Variables section): myisamchk -? 3. table statistics: myisamchk -i /mnt/bv/db/mysql/BV/ctgov_paper Regards, Sergey On Mon, Jul 14, 2025 at 4:36 PM Vassilis Virvilis <vas...@iit.demokritos.gr> wrote: > 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"; > <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> <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/> > <https://www.gnu.org/software/gdb/bugs/>. > Find the GDB manual and other documentation resources online at: > <http://www.gnu.org/software/gdb/documentation/> > <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> <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
