Thanks for this information. I have edited the issue description accordingly.
On Thu, Jul 17, 2025 at 12:13 PM Vassilis Virvilis <vas...@iit.demokritos.gr> wrote: > Thank you for this. > > That would be my next question. If I should file a bug or not. > Let me know if you want me to copy past the info below to the jira bug you > created. > > Anyway here is the info requested > > 1) > MariaDB [DB]> SHOW CREATE TABLE ctgov_paper; > ctgov_paper | 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 > > 2) > rooo~# myisamchk -? > Variables (--variable-name=value) > and boolean options {FALSE|TRUE} Value (after reading options) > --------------------------------- ---------------------------------------- > 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 > > 3) > root~# 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 > > Hope that helps > > Vassilis > > > On 7/17/25 10:58 AM, Sergey Vojtovich wrote: > > 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