[debian-mysql] Bug#1074558: mariadb: FTBFS on sparc64: Multiple tests crash / time out

Otto Kekäläinen otto at debian.org
Sat Jul 6 02:41:58 BST 2024


I built the binary in debug mode and that yielded a stacktrace:

***********************************

main.partition                           w38 [ retry-fail ]
        Test ended at 2024-07-06 01:14:43

CURRENT_TEST: main.partition
mysqltest: At line 3010: query 'select id from t1 where data = 'ab'
order by id' failed: <Unknown> (2013): Lost connection to server
during query

The result from queries just before the failure was:
< snip >
insert t1 values (6, 'ab'), (4, 'ab'), (5, 'ab'), (16, 'ab'), (14,
'ab'), (15, 'ab'), (5, 'ac'), (15, 'aa') ;
select id from t1 where data = 'ab' order by id;
id
4
5
6
14
15
16
drop table t1;
create table t1(id int unsigned not null,
data text default null,
key data_idx (data(1),id)
) default charset=utf8
partition by range (id) (
partition p10 values less than (10),
partition p20 values less than (20)
);
insert t1 values (6, 'ab'), (4, 'ab'), (5, 'ab'), (16, 'ab'), (14,
'ab'), (15, 'ab'), (5, 'ac'), (15, 'aa') ;
select id from t1 where data = 'ab' order by id;

More results from queries before failure can be found in
/home/otto/mariadb-server/builddir/mysql-test/var/38/log/partition.log

 - found 'core' (1/1)
worker[38] > Restart  - not started
Core generated by '/home/otto/mariadb-server/builddir/sql/mariadbd'
Output from gdb follows. The first stack trace is from the failing thread.
The following stack traces are from all threads (so the failing one is
duplicated).
--------------------------
[New LWP 3175949]
[New LWP 3175830]
[New LWP 3175886]
[New LWP 3175896]
[New LWP 3175931]
[New LWP 3175902]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/sparc64-linux-gnu/libthread_db.so.1".
Core was generated by `/home/otto/mariadb-server/builddir/sql/mariadbd
--defaults-group-suffix=.1 --de'.
Program terminated with signal SIGUSR1, User defined signal 1.
#0  0xfff80001028928c0 in __pthread_kill_implementation
(threadid=18444492278236620992, signo=10, no_tid=0) at
./nptl/pthread_kill.c:43
43 ./nptl/pthread_kill.c: No such file or directory.
[Current thread is 1 (Thread 0xfff8000102baa8c0 (LWP 3175949))]
#0  0xfff80001028928c0 in __pthread_kill_implementation
(threadid=18444492278236620992, signo=10, no_tid=0) at
./nptl/pthread_kill.c:43
#1  0x000001000154ca3c in my_write_core (sig=10) at ./mysys/stacktrace.c:424
#2  0x0000010000c39778 in handle_fatal_signal (sig=10) at
./sql/signal_handler.cc:357
#3  <signal handler called>
#4  0x0000010000f35cac in ha_partition::init_record_priority_queue
(this=0xfff800011cca7c10) at ./sql/ha_partition.cc:5657
#5  0x0000010000f363b4 in ha_partition::index_init
(this=0xfff800011cca7c10, inx=0, sorted=true) at
./sql/ha_partition.cc:5762
#6  0x0000010000939870 in handler::ha_index_init (sorted=true, idx=0,
this=0xfff800011cca7c10) at ./sql/handler.h:3495
#7  join_read_always_key (tab=0xfff800011cd285c0) at ./sql/sql_select.cc:24407
#8  0x000001000091df74 in sub_select (join=0xfff800011c017560,
join_tab=0xfff800011cd285c0, end_of_records=<optimized out>) at
./sql/sql_select.cc:23632
#9  0x000001000095c6ec in do_select (procedure=0x0,
join=0xfff800011c017560) at ./sql/sql_select.cc:23146
#10 JOIN::exec_inner (this=0xfff800011c017560) at ./sql/sql_select.cc:5010
#11 0x000001000095cd60 in JOIN::exec (this=0xfff800011c017560) at
./sql/sql_select.cc:4796
#12 0x000001000095a938 in mysql_select (thd=0xfff800011c000dc8,
tables=0xfff800011c015f48, fields=..., conds=0xfff800011c016818,
og_num=1, order=<optimized out>, group=<optimized out>,
having=<optimized out>, proc_param=<optimized out>,
select_options=<optimized out>, result=<optimized out>,
unit=<optimized out>, select_lex=<optimized out>) at
./sql/sql_select.cc:5326
#13 0x000001000095ac54 in handle_select (thd=0xfff800011c000dc8,
lex=0xfff800011c005170, result=0xfff800011c017538,
setup_tables_done_option=<optimized out>) at ./sql/sql_select.cc:628
#14 0x00000100008a0d64 in execute_sqlcom_select
(thd=0xfff800011c000dc8, all_tables=0xfff800011c015f48) at
./sql/sql_parse.cc:6141
#15 0x00000100008aea04 in mysql_execute_command
(thd=0xfff800011c000dc8, is_called_from_prepared_stmt=false) at
./sql/sql_parse.cc:3950
#16 0x00000100008b6168 in mysql_parse (thd=0xfff800011c000dc8,
rawbuf=<optimized out>, length=<optimized out>,
parser_state=<optimized out>) at ./sql/sql_parse.cc:7862
#17 0x00000100008b929c in dispatch_command (command=COM_QUERY,
thd=0xfff800011c000dc8, packet=0xfff800011c00bdb9 "",
packet_length=<optimized out>, blocking=true) at ./sql/sql_class.h:254
#18 0x00000100008bc800 in do_command (thd=0xfff800011c000dc8,
blocking=true) at ./sql/sql_parse.cc:1406
#19 0x0000010000a5ee1c in do_handle_one_connection (connect=<optimized
out>, put_in_cache=true) at ./sql/sql_connect.cc:1437
#20 0x0000010000a5f16c in handle_one_connection (arg=0x100031b2a58) at
./sql/sql_connect.cc:1339
#21 0x0000010000f490e4 in pfs_spawn_thread (arg=0x10003190318) at
./storage/perfschema/pfs.cc:2201
#22 0xfff800010289068c in start_thread (arg=0xfff8000102baa8c0) at
./nptl/pthread_create.c:444
#23 0xfff800010290b410 in __thread_start () at
../sysdeps/unix/sysv/linux/sparc/sparc64/clone.S:79
Backtrace stopped: previous frame identical to this frame (corrupt stack?)

Thread 6 (Thread 0xfff80001024dc8c0 (LWP 3175902)):
#0  0xfff800010288cc4c in __futex_abstimed_wait_common64 (private=0,
cancel=true, abstime=0x0, op=<optimized out>, expected=0,
futex_word=0x100021fe9e0 <COND_manager+40>) at
./nptl/futex-internal.c:57
        _arg2 = <optimized out>
        _arg5 = 0
        __o0 = 512
        __o3 = 0
        _arg3 = 0
        _arg6 = 4294967295
        __o1 = 393
        __o4 = 0
        _arg1 = 1099547273696
        _arg4 = 0
        __g1 = 142
        __o2 = 0
        __o5 = 4294967295
        sc_cancel_oldtype = 0
        sc_ret = <optimized out>
#1  __futex_abstimed_wait_common (futex_word=0x100021fe9e0
<COND_manager+40>, expected=0, clockid=<optimized out>, abstime=0x0,
private=0, cancel=true) at ./nptl/futex-internal.c:87
        err = <optimized out>
        clockbit = <optimized out>
        op = <optimized out>
#2  0xfff800010288fd20 in __pthread_cond_wait_common (abstime=0x0,
clockid=0, mutex=0x100021fea18 <LOCK_manager+40>, cond=0x100021fe9b8
<COND_manager>) at ./nptl/pthread_cond_wait.c:503
        spin = 0
        buffer = {__routine = 0xfff800010288fa1c
<__condvar_cleanup_waiting>, __arg = 0xfff80001024db728, __canceltype
= -524287, __prev = 0x0}
        cbuffer = {wseq = 4, cond = 0x100021fe9b8 <COND_manager>,
mutex = 0x100021fea18 <LOCK_manager+40>, private = 0}
        err = <optimized out>
        g = 0
        flags = <optimized out>
        g1_start = <optimized out>
        maxspin = 0
        signals = <optimized out>
        result = 0
        wseq = 4
        seq = 2
        private = 0
        maxspin = <optimized out>
        err = <optimized out>
        result = <optimized out>
        wseq = <optimized out>
        g = <optimized out>
        seq = <optimized out>
        flags = <optimized out>
        private = <optimized out>
        signals = <optimized out>
        done = <optimized out>
        g1_start = <optimized out>
        spin = <optimized out>
        buffer = <optimized out>
        cbuffer = <optimized out>
        s = <optimized out>
#3  ___pthread_cond_wait (cond=0x100021fe9b8 <COND_manager>,
mutex=0x100021fea18 <LOCK_manager+40>) at
./nptl/pthread_cond_wait.c:618
No locals.
#4  0x0000010001550c08 in safe_cond_wait (cond=0x100021fe9b8
<COND_manager>, mp=0x100021fe9f0 <LOCK_manager>, file=0x100018884a8
"./mysys/my_thr_init.c", line=598) at ./mysys/thr_mutex.c:494
        error = <optimized out>
        save_state = <optimized out>
#5  0x000001000154b594 in psi_cond_wait (that=0x100021fe9b8
<COND_manager>, mutex=0x100021fe9f0 <LOCK_manager>, file=0x10001689450
"./sql/sql_manager.cc", line=109) at ./mysys/my_thr_init.c:598
        state = {m_flags = 7, m_operation = (unknown: 0x89e090),
m_cond = 0x10002bda000, m_mutex = 0xfff80001001de540, m_thread =
0xfff8000103707a40, m_timer_start = 1720228449431484150, m_timer =
0x10001564ad4 <my_timer_nanoseconds>, m_wait = 0xfff8000103708380}
        locker = 0xfff80001024db8c8
        result = <optimized out>
#6  0x000001000089df88 in inline_mysql_cond_wait (src_line=109,
src_file=0x10001689450 "./sql/sql_manager.cc", mutex=0x100021fe9f0
<LOCK_manager>, that=0x100021fe9b8 <COND_manager>) at
./include/mysql/psi/mysql_thread.h:1070
No locals.
#7  handle_manager (arg=<optimized out>) at ./sql/sql_manager.cc:109
        cb = <optimized out>
        error = 0
        abstime = {tv_sec = 0, tv_nsec = 0}
        reset_flush_time = true
        _db_stack_frame_ = {func = 0x1000188b510 "?func", file =
0x1000188b518 "?file", level = 2147483649, line = -1, prev = 0x0}
        __PRETTY_FUNCTION__ = <optimized out>
#8  0x0000010000f490e4 in pfs_spawn_thread (arg=0x10002be3858) at
./storage/perfschema/pfs.cc:2201
        typed_arg = 0x10002be3858
        user_arg = 0x0
        user_start_routine = 0x1000089dca8 <handle_manager(void*)>
        pfs = <optimized out>
        klass = <optimized out>
#9  0xfff800010289068c in start_thread (arg=0xfff80001024dc8c0) at
./nptl/pthread_create.c:444
        ret = <optimized out>
        start = <optimized out>
        pd = 0xfff80001024dc8c0
        out = <optimized out>
        unwind_buf = {cancel_jmp_buf = {{jmp_buf = {{__uc_link = 0x0,
__uc_flags = 0, __uc_sigmask = 18446744073709485823, __uc_mcontext =
{__mc_gregs = {296084308485, 18444492278233062140,
18444492278233062144, 0, 0, 18444492278229485760,
18444492278234245108, 18444492278234246644, 18444492278234248948, 192,
18444492278229485760, 18444492278229482320, 0, 0, 0, 0, 0,
18444492278229480081, 18444492278233368068}, __mc_fp =
18444492278229480833, __mc_i7 = 18444492278233871368, __mc_fpregs =
{__mcfpu_fpregs = {__sregs = {0 <repeats 32 times>}, __dregs = {0
<repeats 32 times>}, __qregs = {0 <repeats 16 times>}}, __mcfpu_fprs =
0, __mcfpu_gsr = 0, __mcfpu_fq = 0x0, __mcfpu_qcnt = 0 '\000',
__mcfpu_qentsz = 0 '\000', __mcfpu_enab = 0 '\000'}}}}, mask_was_saved
= 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup
= 0x0, canceltype = 0}}}
        not_first_call = <optimized out>
#10 0xfff800010290b410 in __thread_start () at
../sysdeps/unix/sysv/linux/sparc/sparc64/clone.S:79
No locals.
Backtrace stopped: previous frame identical to this frame (corrupt stack?)

Thread 5 (Thread 0xfff8000102b5c8c0 (LWP 3175931)):
#0  0xfff8000102846af0 in __GI___sigtimedwait (set=0xfff8000102b5b8c0,
info=0xfff8000102b5b940, timeout=0x0) at
../sysdeps/unix/sysv/linux/sigtimedwait.c:31
        _arg2 = -2251795473254080
        _arg4 = 8
        __g1 = 105
        __o1 = -2251795473254080
        __o3 = 8
        _arg1 = -2251795473254208
        _arg3 = 0
        __o0 = 4
        __o2 = 0
        sc_ret = <optimized out>
        sc_cancel_oldtype = 0
        sc_ret = <optimized out>
        result = <optimized out>
#1  0x0000010000738e1c in my_sigwait (code=<synthetic pointer>,
sig=<synthetic pointer>, set=0xfff8000102b5b8c0) at
./include/my_pthread.h:191
        siginfo = {si_signo = 7, si_errno = 4, si_code = -524287,
__pad0 = 122151936, _sifields = {_pad = {0, 0, 256, 45188032, -524287,
57708736, 256, 51137440, 400521897, 348463665, 256, 22432468, -524287,
57711104, 256, 16027860, 0 <repeats 12 times>}, _kill = {si_pid = 0,
si_uid = 0}, _timer = {si_tid = 0, si_overrun = 0, si_sigval =
{sival_int = 256, sival_ptr = 0x10002b183c0}}, _rt = {si_pid = 0,
si_uid = 0, si_sigval = {sival_int = 256, sival_ptr = 0x10002b183c0}},
_sigchld = {si_pid = 0, si_uid = 0, si_status = 256, si_utime =
-2251795461009216, si_stime = 1099562765216}, _sigfault = {si_addr =
0x0, _si_trapno = 256, si_addr_lsb = 689, _bounds = {_addr_bnd =
{_lower = 0xfff80001037090c0, _upper = 0x100030c4ba0}, _pkey =
4294443009}}, _sigpoll = {si_band = 0, si_fd = 0}, _sigsys =
{_call_addr = 0x0, _syscall = 256, _arch = 45188032}}}
        siginfo = <optimized out>
#2  signal_hand () at ./sql/mysqld.cc:3247
        error = <optimized out>
        origin = <optimized out>
        set = {__val = {147461, 0, 18444492278236295441,
1099533938084, 0, 0, 0, 0, 0, 1878019572857189, 0, 0, 0, 0, 0, 0}}
        sig = <optimized out>
        __PRETTY_FUNCTION__ = "void* signal_hand(void*)"
#3  0x0000010000f490e4 in pfs_spawn_thread (arg=0x100030c4bb8) at
./storage/perfschema/pfs.cc:2201
        typed_arg = 0x100030c4bb8
        user_arg = 0x0
        user_start_routine = 0x10000738904 <signal_hand(void*)>
        pfs = <optimized out>
        klass = <optimized out>
#4  0xfff800010289068c in start_thread (arg=0xfff8000102b5c8c0) at
./nptl/pthread_create.c:444
        ret = <optimized out>
        start = <optimized out>
        pd = 0xfff8000102b5c8c0
        out = <optimized out>
        unwind_buf = {cancel_jmp_buf = {{jmp_buf = {{__uc_link = 0x0,
__uc_flags = 0, __uc_sigmask = 18446744073709485823, __uc_mcontext =
{__mc_gregs = {296084308483, 18444492278233062140,
18444492278233062144, 0, 0, 18444492278236301504,
18444492278234245108, 18444492278234246644, 18444492278234248948, 192,
18444492278236301504, 18444492278236298064, 0, 0, 0, 0, 0,
18444492278236295825, 18444492278233368068}, __mc_fp =
18444492278236296577, __mc_i7 = 18444492278233871368, __mc_fpregs =
{__mcfpu_fpregs = {__sregs = {0 <repeats 32 times>}, __dregs = {0
<repeats 32 times>}, __qregs = {0 <repeats 16 times>}}, __mcfpu_fprs =
0, __mcfpu_gsr = 0, __mcfpu_fq = 0x0, __mcfpu_qcnt = 0 '\000',
__mcfpu_qentsz = 0 '\000', __mcfpu_enab = 0 '\000'}}}}, mask_was_saved
= 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup
= 0x0, canceltype = 0}}}
        not_first_call = <optimized out>
#5  0xfff800010290b410 in __thread_start () at
../sysdeps/unix/sysv/linux/sparc/sparc64/clone.S:79
No locals.
Backtrace stopped: previous frame identical to this frame (corrupt stack?)

Thread 4 (Thread 0xfff800010d0018c0 (LWP 3175896)):
#0  0xfff800010288cc4c in __futex_abstimed_wait_common64 (private=0,
cancel=true, abstime=0xfff800010d0008f0, op=<optimized out>,
expected=0, futex_word=0x10002a359d0 <COND_checkpoint+40>) at
./nptl/futex-internal.c:57
        _arg2 = <optimized out>
        _arg5 = 0
        __o0 = 516
        __o3 = -2251795300611856
        _arg3 = 0
        _arg6 = 4294967295
        __o1 = 393
        __o4 = 0
        _arg1 = 1099555887568
        _arg4 = -2251795300611856
        __g1 = 142
        __o2 = 0
        __o5 = 4294967295
        sc_cancel_oldtype = 0
        sc_ret = <optimized out>
#1  __futex_abstimed_wait_common (futex_word=0x10002a359d0
<COND_checkpoint+40>, expected=0, clockid=<optimized out>,
abstime=0xfff800010d0008f0, private=0, cancel=true) at
./nptl/futex-internal.c:87
        err = <optimized out>
        clockbit = <optimized out>
        op = <optimized out>
#2  0xfff8000102890060 in __pthread_cond_wait_common
(abstime=0xfff800010d0008f0, clockid=0, mutex=0x10002a35a08
<LOCK_checkpoint+40>, cond=0x10002a359a8 <COND_checkpoint>) at
./nptl/pthread_cond_wait.c:503
        spin = 0
        buffer = {__routine = 0xfff800010288fa1c
<__condvar_cleanup_waiting>, __arg = 0xfff800010d000658, __canceltype
= 256, __prev = 0x0}
        cbuffer = {wseq = 0, cond = 0x10002a359a8 <COND_checkpoint>,
mutex = 0x10002a35a08 <LOCK_checkpoint+40>, private = 0}
        err = <optimized out>
        g = 0
        flags = <optimized out>
        g1_start = <optimized out>
        maxspin = 0
        signals = <optimized out>
        result = 0
        wseq = 0
        seq = 0
        private = 0
        maxspin = <optimized out>
        err = <optimized out>
        result = <optimized out>
        wseq = <optimized out>
        g = <optimized out>
        seq = <optimized out>
        flags = <optimized out>
        private = <optimized out>
        signals = <optimized out>
        done = <optimized out>
        g1_start = <optimized out>
        spin = <optimized out>
        buffer = <optimized out>
        cbuffer = <optimized out>
        s = <optimized out>
#3  ___pthread_cond_timedwait64 (cond=0x10002a359a8 <COND_checkpoint>,
mutex=0x10002a35a08 <LOCK_checkpoint+40>, abstime=0xfff800010d0008f0)
at ./nptl/pthread_cond_wait.c:643
        flags = <optimized out>
        clockid = 0
#4  0x0000010001550e94 in safe_cond_timedwait (cond=0x10002a359a8
<COND_checkpoint>, mp=0x10002a359e0 <LOCK_checkpoint>,
abstime=0xfff800010d0008f0, file=0x100018884a8
"./mysys/my_thr_init.c", line=611) at ./mysys/thr_mutex.c:548
        error = <optimized out>
        save_state = <optimized out>
#5  0x000001000154b628 in psi_cond_timedwait (that=0x10002a359a8
<COND_checkpoint>, mutex=0x10002a359e0 <LOCK_checkpoint>,
abstime=0xfff800010d0008f0, file=0x100017656d0
"./storage/maria/ma_servicethread.c", line=115) at
./mysys/my_thr_init.c:611
        state = {m_flags = 7, m_operation = (unknown: 0x100188),
m_cond = 0x10002bd9d80, m_mutex = 0xfff80001001db2c0, m_thread =
0xfff80001037063c0, m_timer_start = 1720228448893468821, m_timer =
0x10001564ad4 <my_timer_nanoseconds>, m_wait = 0xfff8000103706d00}
        locker = 0xfff800010d000808
        result = <optimized out>
#6  0x0000010000ebe308 in inline_mysql_cond_timedwait (src_line=115,
src_file=0x100017656d0 "./storage/maria/ma_servicethread.c",
abstime=0xfff800010d0008f0, mutex=<optimized out>, that=<optimized
out>) at ./include/mysql/psi/mysql_thread.h:1086
No locals.
#7  my_service_thread_sleep (control=0x10002132888
<checkpoint_control>, sleep_time=29000000000) at
./storage/maria/ma_servicethread.c:115
        abstime = {tv_sec = 1720228477, tv_nsec = 893465000}
        res = 0 '\000'
        _db_stack_frame_ = {func = 0x1000188b510 "?func", file =
0x1000188b518 "?file", level = 2147483649, line = -1, prev = 0x0}
#8  0x0000010000eb39b4 in ma_checkpoint_background (arg=0x1e) at
./storage/maria/ma_checkpoint.c:725
        interval = 30
        sleeps = 1
        sleep_time = 29
        log_horizon_at_last_checkpoint = 4295394948
        pagecache_flushes_at_last_checkpoint = 0
        pages_bunch_size = 0
        filter_param = {up_to_lsn = 4295394904, max_pages = 0}
        dfile = 0x0
        kfile = 0x0
        __PRETTY_FUNCTION__ = "ma_checkpoint_background"
#9  0x0000010000f490e4 in pfs_spawn_thread (arg=0x10002d4bc38) at
./storage/perfschema/pfs.cc:2201
        typed_arg = 0x10002d4bc38
        user_arg = 0x1e
        user_start_routine = 0x10000eb379c <ma_checkpoint_background>
        pfs = <optimized out>
        klass = <optimized out>
#10 0xfff800010289068c in start_thread (arg=0xfff800010d0018c0) at
./nptl/pthread_create.c:444
        ret = <optimized out>
        start = <optimized out>
        pd = 0xfff800010d0018c0
        out = <optimized out>
        unwind_buf = {cancel_jmp_buf = {{jmp_buf = {{__uc_link = 0x0,
__uc_flags = 0, __uc_sigmask = 18446744073709485823, __uc_mcontext =
{__mc_gregs = {296084308482, 18444492278233062140,
18444492278233062144, 0, 0, 18444492278408943808,
18444492278234245108, 18444492278234246644, 18444492278234248948, 192,
18444492278408943808, 18444492278408940368, 0, 0, 0, 0, 0,
18444492278408938129, 18444492278233368068}, __mc_fp =
18444492278408938881, __mc_i7 = 18444492278233871368, __mc_fpregs =
{__mcfpu_fpregs = {__sregs = {0 <repeats 32 times>}, __dregs = {0
<repeats 32 times>}, __qregs = {0 <repeats 16 times>}}, __mcfpu_fprs =
0, __mcfpu_gsr = 0, __mcfpu_fq = 0x0, __mcfpu_qcnt = 0 '\000',
__mcfpu_qentsz = 0 '\000', __mcfpu_enab = 0 '\000'}}}}, mask_was_saved
= 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup
= 0x0, canceltype = 0}}}
        not_first_call = <optimized out>
#11 0xfff800010290b410 in __thread_start () at
../sysdeps/unix/sysv/linux/sparc/sparc64/clone.S:79
No locals.
Backtrace stopped: previous frame identical to this frame (corrupt stack?)

Thread 3 (Thread 0xfff8000100afd8c0 (LWP 3175886)):
#0  0xfff800010288cc4c in __futex_abstimed_wait_common64 (private=0,
cancel=true, abstime=0xfff8000100afc9c0, op=<optimized out>,
expected=0, futex_word=0x10002ac54b0 <COND_timer+40>) at
./nptl/futex-internal.c:57
        _arg2 = <optimized out>
        _arg5 = 0
        __o0 = 516
        __o3 = -2251795507197504
        _arg3 = 0
        _arg6 = 4294967295
        __o1 = 393
        __o4 = 0
        _arg1 = 1099556476080
        _arg4 = -2251795507197504
        __g1 = 142
        __o2 = 0
        __o5 = 4294967295
        sc_cancel_oldtype = 0
        sc_ret = <optimized out>
#1  __futex_abstimed_wait_common (futex_word=0x10002ac54b0
<COND_timer+40>, expected=0, clockid=<optimized out>,
abstime=0xfff8000100afc9c0, private=0, cancel=true) at
./nptl/futex-internal.c:87
        err = <optimized out>
        clockbit = <optimized out>
        op = <optimized out>
#2  0xfff8000102890060 in __pthread_cond_wait_common
(abstime=0xfff8000100afc9c0, clockid=0, mutex=0x10002ac54e8
<LOCK_timer+40>, cond=0x10002ac5488 <COND_timer>) at
./nptl/pthread_cond_wait.c:503
        spin = 0
        buffer = {__routine = 0xfff800010288fa1c
<__condvar_cleanup_waiting>, __arg = 0xfff8000100afc728, __canceltype
= 256, __prev = 0x0}
        cbuffer = {wseq = 0, cond = 0x10002ac5488 <COND_timer>, mutex
= 0x10002ac54e8 <LOCK_timer+40>, private = 0}
        err = <optimized out>
        g = 0
        flags = <optimized out>
        g1_start = <optimized out>
        maxspin = 0
        signals = <optimized out>
        result = 0
        wseq = 0
        seq = 0
        private = 0
        maxspin = <optimized out>
        err = <optimized out>
        result = <optimized out>
        wseq = <optimized out>
        g = <optimized out>
        seq = <optimized out>
        flags = <optimized out>
        private = <optimized out>
        signals = <optimized out>
        done = <optimized out>
        g1_start = <optimized out>
        spin = <optimized out>
        buffer = <optimized out>
        cbuffer = <optimized out>
        s = <optimized out>
#3  ___pthread_cond_timedwait64 (cond=0x10002ac5488 <COND_timer>,
mutex=0x10002ac54e8 <LOCK_timer+40>, abstime=0xfff8000100afc9c0) at
./nptl/pthread_cond_wait.c:643
        flags = <optimized out>
        clockid = 0
#4  0x0000010001550e94 in safe_cond_timedwait (cond=0x10002ac5488
<COND_timer>, mp=0x10002ac54c0 <LOCK_timer>,
abstime=0xfff8000100afc9c0, file=0x100018884a8
"./mysys/my_thr_init.c", line=611) at ./mysys/thr_mutex.c:548
        error = <optimized out>
        save_state = <optimized out>
#5  0x000001000154b628 in psi_cond_timedwait (that=0x10002ac5488
<COND_timer>, mutex=0x10002ac54c0 <LOCK_timer>,
abstime=0xfff8000100afc9c0, file=0x10001889248 "./mysys/thr_timer.c",
line=321) at ./mysys/my_thr_init.c:611
        state = {m_flags = 7, m_operation = (unknown: 0x1546da4),
m_cond = 0x10002bd9680, m_mutex = 0xfff80001001d9dc0, m_thread =
0xfff8000103704d40, m_timer_start = 1720228448801301484, m_timer =
0x10001564ad4 <my_timer_nanoseconds>, m_wait = 0xfff8000103705680}
        locker = 0xfff8000100afc8d8
        result = <optimized out>
#6  0x00000100015516e4 in inline_mysql_cond_timedwait (src_line=321,
src_file=0x10001889248 "./mysys/thr_timer.c",
abstime=0xfff8000100afc9c0, mutex=0x10002ac54c0 <LOCK_timer>,
that=0x10002ac5488 <COND_timer>) at
./include/mysql/psi/mysql_thread.h:1086
No locals.
#7  timer_handler (arg=<optimized out>) at ./mysys/thr_timer.c:321
        error = <optimized out>
        top_time = <optimized out>
        now = <optimized out>
        abstime = {tv_sec = 2147483647, tv_nsec = 0}
#8  0x0000010000f490e4 in pfs_spawn_thread (arg=0x10002c96188) at
./storage/perfschema/pfs.cc:2201
        typed_arg = 0x10002c96188
        user_arg = 0x0
        user_start_routine = 0x100015513d8 <timer_handler>
        pfs = <optimized out>
        klass = <optimized out>
#9  0xfff800010289068c in start_thread (arg=0xfff8000100afd8c0) at
./nptl/pthread_create.c:444
        ret = <optimized out>
        start = <optimized out>
        pd = 0xfff8000100afd8c0
        out = <optimized out>
        unwind_buf = {cancel_jmp_buf = {{jmp_buf = {{__uc_link = 0x0,
__uc_flags = 0, __uc_sigmask = 18446744073709485823, __uc_mcontext =
{__mc_gregs = {296084308485, 18444492278233062140,
18444492278233062144, 0, 0, 18444492278202357952,
18444492278234245108, 18444492278234246644, 18444492278234248948, 192,
18444492278202357952, 18444492278202354512, 0, 0, 0, 0, 0,
18444492278202352273, 18444492278233368068}, __mc_fp =
18444492278202353025, __mc_i7 = 18444492278233871368, __mc_fpregs =
{__mcfpu_fpregs = {__sregs = {0 <repeats 32 times>}, __dregs = {0
<repeats 32 times>}, __qregs = {0 <repeats 16 times>}}, __mcfpu_fprs =
0, __mcfpu_gsr = 0, __mcfpu_fq = 0x0, __mcfpu_qcnt = 0 '\000',
__mcfpu_qentsz = 0 '\000', __mcfpu_enab = 0 '\000'}}}}, mask_was_saved
= 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup
= 0x0, canceltype = 0}}}
        not_first_call = <optimized out>
#10 0xfff800010290b410 in __thread_start () at
../sysdeps/unix/sysv/linux/sparc/sparc64/clone.S:79
No locals.
Backtrace stopped: previous frame identical to this frame (corrupt stack?)

Thread 2 (Thread 0xfff8000100036de0 (LWP 3175830)):
#0  0xfff800010290049c in __GI___poll (fds=0x1000318f0b8, nfds=3,
timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29
        _arg2 = 3
        __g1 = 153
        __o1 = 3
        _arg1 = 1099563593912
        _arg3 = -1
        __o0 = 516
        __o2 = -1
        sc_ret = <optimized out>
        sc_cancel_oldtype = 0
        sc_ret = <optimized out>
#1  0x00000100007466b0 in poll (__timeout=-1, __nfds=<optimized out>,
__fds=<optimized out>) at
/usr/include/sparc64-linux-gnu/bits/poll2.h:39
No locals.
#2  handle_connections_sockets () at ./sql/mysqld.cc:6324
        sock = {fd = 12, is_unix_domain_socket = 1 '\001',
is_extra_port = 0 '\000', address_family = 0, m_psi = 0x100030c7fc0}
        error_count = 0
        cAddr = {ss_family = 1, __ss_padding = '\000' <repeats 14
times>, "\377\370\000\001\002\257\353\310\000\000\001\000\002\037\201\200\000\000\001\000\001e\f\200\000\000\000\000\000\000\027y\000\000\001\000\002\257\257)\000\000\000\000\000\000\000\000\377\370\000\001\002\260\fH\000\000\a\376\377\352\303\021\000\000\001\000\000t\222\324\000\000\000\000\000\000\000\000\000\000\a\376\377\352\313\230\000\000\001\000\001\210\265\020\000\000\001\000\001\210\265\030",
__ss_align = 9223372041149752939}
        retval = <optimized out>
        fds = {array = {buffer = 0x1000318f0b8 "", elements = 3,
max_element = 16, alloc_increment = 16, size_of_element = 8, m_psi_key
= 0, malloc_flags = 0}}
        _db_stack_frame_ = {func = 0x1000188b510 "?func", file =
0x1000188b518 "?file", level = 2147483649, line = -1, prev = 0x0}
        termination_fds = {32, 33}
        event_fd = {fd = 32, events = 1, revents = 14216}
#3  0x000001000074938c in mysqld_main (argc=<optimized out>,
argv=<optimized out>) at ./sql/mysqld.cc:6022
        please_close_stdin = <optimized out>
        ho_error = <optimized out>
        new_thread_stack_size = <optimized out>
        user = <optimized out>
#4  0x0000010000735518 in main (argc=9, argv=0x7feffead658) at ./sql/main.cc:34
No locals.

Thread 1 (Thread 0xfff8000102baa8c0 (LWP 3175949)):
#0  0xfff80001028928c0 in __pthread_kill_implementation
(threadid=18444492278236620992, signo=10, no_tid=0) at
./nptl/pthread_kill.c:43
        _arg2 = 3175949
        __g1 = 211
        __o1 = 3175949
        _arg1 = 0
        _arg3 = 10
        __o0 = 0
        __o2 = 10
        tid = 3175949
        ret = <optimized out>
        pd = 0xfff8000102baa8c0
        old_mask = {__val = {18444492278233934732}}
        ret = <optimized out>
#1  0x000001000154ca3c in my_write_core (sig=10) at ./mysys/stacktrace.c:424
No locals.
#2  0x0000010000c39778 in handle_fatal_signal (sig=10) at
./sql/signal_handler.cc:357
        curr_time = 1720228468
        tm = {tm_sec = 28, tm_min = 14, tm_hour = 1, tm_mday = 6,
tm_mon = 6, tm_year = 124, tm_wday = 6, tm_yday = 187, tm_isdst = 0,
tm_gmtoff = 0, tm_zone = 0x10002bd92b0 "UTC"}
        thd = 0xfff800011c000dc8
        print_invalid_query_pointer = false
#3  <signal handler called>
No locals.
#4  0x0000010000f35cac in ha_partition::init_record_priority_queue
(this=0xfff800011cca7c10) at ./sql/ha_partition.cc:5657
        _db_stack_frame_ = {func = 0x100017724b0
"ha_partition::index_init", file = 0x1000176fa10
"./sql/ha_partition.cc", level = 2147483660, line = -1, prev =
0xfff8000102ba7870}
        __PRETTY_FUNCTION__ = "bool ha_partition::init_record_priority_queue()"
        alloc_len = <optimized out>
        used_parts = <optimized out>
        blob_storage = 0xfff800011c1915c8
        objs = 0xfff800011c191628
        n_all = <optimized out>
        ptr = 0xfff800011c191587 '\245' <repeats 49 times>,
"\217\217\217\217\217\217\217\217\377\370"
        i = 1
        cmp_func = <optimized out>
        cmp_arg = <optimized out>
#5  0x0000010000f363b4 in ha_partition::index_init
(this=0xfff800011cca7c10, inx=0, sorted=true) at
./sql/ha_partition.cc:5762
        err = <optimized out>
        error = 0
        i = <optimized out>
        _db_stack_frame_ = {func = 0x10001660990 "ha_index_init", file
= 0x10001660450 "./sql/handler.h", level = 2147483659, line = -1, prev
= 0xfff8000102ba7960}
#6  0x0000010000939870 in handler::ha_index_init (sorted=true, idx=0,
this=0xfff800011cca7c10) at ./sql/handler.h:3495
        result = <optimized out>
        _db_stack_frame_ = {func = 0x10001695e70 "sub_select", file =
0x10001693748 "./sql/sql_select.cc", level = 2147483658, line = -1,
prev = 0xfff8000102ba7a30}
        result = <optimized out>
        _db_stack_frame_ = <optimized out>
        __PRETTY_FUNCTION__ = <optimized out>
#7  join_read_always_key (tab=0xfff800011cd285c0) at ./sql/sql_select.cc:24407
        error = <optimized out>
        table = 0xfff800011cbcaea8
#8  0x000001000091df74 in sub_select (join=0xfff800011c017560,
join_tab=0xfff800011cd285c0, end_of_records=<optimized out>) at
./sql/sql_select.cc:23632
        error = <optimized out>
        rc = NESTED_LOOP_OK
        _db_stack_frame_ = {func = 0x1000169a5a0 "do_select", file =
0x10001693748 "./sql/sql_select.cc", level = 2147483657, line = -1,
prev = 0xfff8000102ba7b88}
        __PRETTY_FUNCTION__ = "enum_nested_loop_state
sub_select(JOIN*, JOIN_TAB*, bool)"
        skip_over = <optimized out>
        info = <optimized out>
#9  0x000001000095c6ec in do_select (procedure=0x0,
join=0xfff800011c017560) at ./sql/sql_select.cc:23146
        join_tab = 0xfff800011cd285c0
        rc = 0
        error = NESTED_LOOP_OK
        top_level_tables = <optimized out>
        _db_stack_frame_ = {func = 0x1000169a508 "JOIN::exec_inner",
file = 0x10001693748 "./sql/sql_select.cc", level = 2147483656, line =
-1, prev = 0xfff8000102ba7b08}
        rc = <optimized out>
        error = <optimized out>
        top_level_tables = <optimized out>
        _db_stack_frame_ = <optimized out>
        __PRETTY_FUNCTION__ = <optimized out>
        res = <optimized out>
        last_tab = <optimized out>
        state = <optimized out>
        end_select = <optimized out>
        cleared_tables = <optimized out>
        columns_list = <optimized out>
        join_tab = <optimized out>
        sort_tab = <optimized out>
        join_tab = <optimized out>
        const_tables = <optimized out>
#10 JOIN::exec_inner (this=0xfff800011c017560) at ./sql/sql_select.cc:5010
        columns_list = <optimized out>
        _db_stack_frame_ = {func = 0x1000169a438 "mysql_select", file
= 0x10001693748 "./sql/sql_select.cc", level = 2147483655, line = -1,
prev = 0xfff8000102ba8060}
        __PRETTY_FUNCTION__ = "int JOIN::exec_inner()"
        trace_wrapper = {<Json_writer_struct> =
{_vptr.Json_writer_struct = 0x10001f9ef40 <vtable for
Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0},
closed = false}, <No data fields>}
        trace_exec = {<Json_writer_struct> = {_vptr.Json_writer_struct
= 0x10001f9ef40 <vtable for Json_writer_object+16>, my_writer = 0x0,
context = {writer = 0x0}, closed = false}, <No data fields>}
        trace_steps = {<Json_writer_struct> =
{_vptr.Json_writer_struct = 0x10001f9ef60 <vtable for
Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0},
closed = false}, <No data fields>}
#11 0x000001000095cd60 in JOIN::exec (this=0xfff800011c017560) at
./sql/sql_select.cc:4796
        res = <optimized out>
#12 0x000001000095a938 in mysql_select (thd=0xfff800011c000dc8,
tables=0xfff800011c015f48, fields=<optimized out>,
conds=0xfff800011c016818, og_num=1, order=<optimized out>,
group=<optimized out>, having=<optimized out>, proc_param=<optimized
out>, select_options=<optimized out>, result=<optimized out>,
unit=<optimized out>, select_lex=<optimized out>) at
./sql/sql_select.cc:5326
        err = 0
        free_join = true
        exec_error = false
        _db_stack_frame_ = {func = 0x1000169a448 "handle_select", file
= 0x10001693748 "./sql/sql_select.cc", level = 2147483654, line = -1,
prev = 0xfff8000102ba8170}
        join = 0xfff800011c017560
#13 0x000001000095ac54 in handle_select (thd=0xfff800011c000dc8,
lex=0xfff800011c005170, result=0xfff800011c017538,
setup_tables_done_option=<optimized out>) at ./sql/sql_select.cc:628
        unit = 0xfff800011c005250
        res = <optimized out>
        select_lex = 0xfff800011c015908
        _db_stack_frame_ = {func = 0x100018b2108
"mysql_execute_command", file = 0x100018afc48 "./sql/sql_parse.cc",
level = 2147483653, line = -1, prev = 0xfff8000102ba87e8}
#14 0x00000100008a0d64 in execute_sqlcom_select
(thd=0xfff800011c000dc8, all_tables=0xfff800011c015f48) at
./sql/sql_parse.cc:6141
        save_protocol = 0x0
        lex = 0xfff800011c005170
        result = 0xfff800011c017538
        res = <optimized out>
        __PRETTY_FUNCTION__ = "bool execute_sqlcom_select(THD*, TABLE_LIST*)"
#15 0x00000100008aea04 in mysql_execute_command
(thd=0xfff800011c000dc8, is_called_from_prepared_stmt=false) at
./sql/sql_parse.cc:3950
        privileges_requested = <optimized out>
        wsrep_error_label = <optimized out>
        error = <optimized out>
        res = 0
        lex = 0xfff800011c005170
        select_lex = <optimized out>
        first_table = 0xfff800011c015f48
        all_tables = 0xfff800011c015f48
        unit = 0xfff800011c005250
        _db_stack_frame_ = {func = 0x100018b2b80 "mysql_parse", file =
0x100018afc48 "./sql/sql_parse.cc", level = 2147483652, line = -1,
prev = 0xfff8000102ba8da0}
        __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*, bool)"
        ots = {ctx = 0xfff800011c004ed0, traceable = false}
        orig_binlog_format = BINLOG_FORMAT_MIXED
        orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT
#16 0x00000100008b6168 in mysql_parse (thd=0xfff800011c000dc8,
rawbuf=<optimized out>, length=<optimized out>,
parser_state=<optimized out>) at ./sql/sql_parse.cc:7862
        found_semicolon = <optimized out>
        error = <optimized out>
        lex = 0xfff800011c005170
        err = <optimized out>
        _db_stack_frame_ = {func = 0x100018b3038 "dispatch_command",
file = 0x100018afc48 "./sql/sql_parse.cc", level = 2147483651, line =
-1, prev = 0xfff8000102ba8ee8}
        __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint,
Parser_state*)"
#17 0x00000100008b929c in dispatch_command (command=COM_QUERY,
thd=0xfff800011c000dc8, packet=0xfff800011c00bdb9 "",
packet_length=<optimized out>, blocking=true) at ./sql/sql_class.h:254
        packet_end = 0xfff800011c01587f ""
        parser_state = {m_lip = {lookahead_token = -1,
lookahead_yylval = 0x0, m_thd = 0xfff800011c000dc8, m_ptr =
0xfff800011c015880 "\004", m_tok_start = 0xfff800011c015880 "\004",
m_tok_end = 0xfff800011c015880 "\004", m_end_of_query =
0xfff800011c01587f "", m_tok_start_prev = 0xfff800011c01587f "", m_buf
= 0xfff800011c015850 "select id from t1 where data = 'ab' order by
id", m_buf_length = 47, m_echo = true, m_echo_saved = true, m_cpp_buf
= 0xfff800011c0158d8 "select id from t1 where data = 'ab' order by
id", m_cpp_ptr = 0xfff800011c015907 "", m_cpp_tok_start =
0xfff800011c015907 "", m_cpp_tok_start_prev = 0xfff800011c015907 "",
m_cpp_tok_end = 0xfff800011c015907 "", m_body_utf8 = 0x0,
m_body_utf8_ptr = 0xfff800011cbcaabd '\245' <repeats 200 times>...,
m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END,
found_semicolon = 0x0, ignore_space = false, stmt_prepare_mode =
false, multi_statements = true, yylineno = 1, m_digest = 0x0,
in_comment = NO_COMMENT, in_comment_saved = NO_COMMENT,
m_cpp_text_start = 0xfff800011c0158f8 "ab' order by id",
m_cpp_text_end = 0xfff800011c0158fa "' order by id", m_underscore_cs =
0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info =
{m_item = {0x0 <repeats 13 times>}}, m_lock_type = TL_READ_DEFAULT,
m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0xfff800011c004c60}
        net = 0xfff800011c001110
        error = false
        do_end_of_statement = true
        _db_stack_frame_ = {func = 0x100018b36c8 "do_command", file =
0x100018afc48 "./sql/sql_parse.cc", level = 2147483650, line = -1,
prev = 0xfff8000102ba9830}
        drop_more_results = false
        __PRETTY_FUNCTION__ = "dispatch_command_return
dispatch_command(enum_server_command, THD*, char*, uint, bool)"
        __FUNCTION__ = "dispatch_command"
        res = <optimized out>
#18 0x00000100008bc800 in do_command (thd=0xfff800011c000dc8,
blocking=true) at ./sql/sql_parse.cc:1406
        return_value = <optimized out>
        packet = 0xfff800011c00bdb8 "\002"
        packet_length = 48
        net = 0xfff800011c001110
        command = COM_QUERY
        _db_stack_frame_ = {func = 0x1000188b510 "?func", file =
0x1000188b518 "?file", level = 2147483649, line = -1, prev = 0x0}
        __PRETTY_FUNCTION__ = "dispatch_command_return do_command(THD*, bool)"
        __FUNCTION__ = "do_command"
#19 0x0000010000a5ee1c in do_handle_one_connection (connect=<optimized
out>, put_in_cache=true) at ./sql/sql_connect.cc:1437
        create_user = true
        thr_create_utime = <optimized out>
        thd = 0xfff800011c000dc8
#20 0x0000010000a5f16c in handle_one_connection (arg=0x100031b2a58) at
./sql/sql_connect.cc:1339
        connect = 0x100031b2a58
#21 0x0000010000f490e4 in pfs_spawn_thread (arg=0x10003190318) at
./storage/perfschema/pfs.cc:2201
        typed_arg = 0x10003190318
        user_arg = 0x100031b2a58
        user_start_routine = 0x10000a5f0e8 <handle_one_connection(void*)>
        pfs = <optimized out>
        klass = <optimized out>
#22 0xfff800010289068c in start_thread (arg=0xfff8000102baa8c0) at
./nptl/pthread_create.c:444
        ret = <optimized out>
        start = <optimized out>
        pd = 0xfff8000102baa8c0
        out = <optimized out>
        unwind_buf = {cancel_jmp_buf = {{jmp_buf = {{__uc_link = 0x0,
__uc_flags = 0, __uc_sigmask = 18446744073709485823, __uc_mcontext =
{__mc_gregs = {296084308487, 18444492278233062140,
18444492278233062144, 0, 0, 18444492278236620992,
18444492278234245108, 18444492278234246644, 18444492278234248948, 192,
18444492278236620992, 18444492278236617552, 0, 0, 0, 0, 0,
18444492278236615313, 18444492278233368068}, __mc_fp =
18444492278236616065, __mc_i7 = 18444492278233871368, __mc_fpregs =
{__mcfpu_fpregs = {__sregs = {0 <repeats 32 times>}, __dregs = {0
<repeats 32 times>}, __qregs = {0 <repeats 16 times>}}, __mcfpu_fprs =
0, __mcfpu_gsr = 0, __mcfpu_fq = 0x0, __mcfpu_qcnt = 0 '\000',
__mcfpu_qentsz = 0 '\000', __mcfpu_enab = 0 '\000'}}}}, mask_was_saved
= 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup
= 0x0, canceltype = 0}}}
        not_first_call = <optimized out>
#23 0xfff800010290b410 in __thread_start () at
../sysdeps/unix/sysv/linux/sparc/sparc64/clone.S:79
No locals.
Backtrace stopped: previous frame identical to this frame (corrupt stack?)

 - deleting it, already saved 1
 - skipping '/home/otto/mariadb-server/builddir/mysql-test/var/38/log/main.partition/'

Test main.partition has failed 2 times, no more retries!

***Warnings generated in error logs during shutdown after running
tests: main.partition



More information about the pkg-mysql-maint mailing list