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

Reply via email to