[MariaDB discuss] Re: myisamchk --paralle-recover stalls

Thu, 17 Jul 2025 01:14:29 -0700 

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 <[email protected]> 
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 
<[email protected]> 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 -- [email protected]
        To unsubscribe send an email to [email protected]




_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to