[debian-mysql] Bug#1074558: Acknowledgement (mariadb: FTBFS on sparc64: Multiple tests fail network connection issues)
Otto Kekäläinen
otto at debian.org
Mon Jul 1 00:05:17 BST 2024
Control: retitle -1 mariadb: FTBFS on sparc64: Multiple tests crash / time out
Ignore the previous list of issues, it a mistake from wrong architecture.
The actual sparc64 build at
https://buildd.debian.org/status/fetch.php?pkg=mariadb&arch=sparc64&ver=1%3A11.4.2-1&stamp=1719764783&raw=0
failed on timeouts/crashes from these tests:
main.partition w13 [ fail ]
main.backup_stages w8 [ fail ] timeout after 7200 seconds
main.mysqldump-timing w2 [ fail ] timeout after 7200 seconds
main.sp-i_s_columns w6 [ fail ] timeout after 7200 seconds
Example crash stack trace:
main.partition w13 [ fail ]
Test ended at 2024-06-30 14:16:16
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
/<<PKGBUILDDIR>>/builddir/mysql-test/var/13/log/partition.log
- found 'core' (0/1)
Core generated by '/<<PKGBUILDDIR>>/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 3099949]
[New LWP 3099936]
[New LWP 3099935]
[New LWP 3099937]
[New LWP 3099941]
[New LWP 3099908]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/sparc64-linux-gnu/libthread_db.so.1".
Core was generated by `/<<PKGBUILDDIR>>/builddir/sql/mariadbd
--defaults-group-suf'.
Program terminated with signal SIGUSR1, User defined signal 1.
#0 0xfff80001028928c0 in ?? () from /lib/sparc64-linux-gnu/libc.so.6
[Current thread is 1 (Thread 0xfff80001024f68c0 (LWP 3099949))]
#0 0xfff80001028928c0 in ?? () from /lib/sparc64-linux-gnu/libc.so.6
#1 0x0000010000a85b74 in handle_fatal_signal (sig=10) at
./sql/signal_handler.cc:357
Backtrace stopped: Cannot access memory at address 0xf0
Thread 6 (Thread 0xfff8000100036ca0 (LWP 3099908)):
#0 0xfff800010290049c in poll () from /lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
#1 0x0000010000735f44 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 = <optimized out>,
is_extra_port = <optimized out>, address_family = <optimized out>,
m_psi = 0x10002884700}
error_count = 0
cAddr = {ss_family = 1, __ss_padding =
"\001\000\002.\254\251\000\000\000\000\000\000\000\000\377\370\000\001\002\260\fH\000\000\a\376\377\352d\241\000\000\001\000\000s\177\230\000\000\000\000\000\000?p\000\000\001\000\001\004\226`\000\000\a\376\377\352d\241\000\000\001\000\000st@\000\000\a\376\377\352d\241\000\000\001\000\000sm@\000\000\000\a\000\000\000\000\377\370\000\001\000\035\223\300\377\370\000\001\003p6\300\027\335\315\330\n=\230\302",
__ss_align = 1099527935632}
retval = <optimized out>
fds = {array = {buffer = 0x1000289ad68 "", elements = 3,
max_element = 16, alloc_increment = 16, size_of_element = 8, m_psi_key
= 0, malloc_flags = 0}}
termination_fds = {32, 33}
event_fd = {fd = 32, events = 1, revents = 12600}
#3 0x00000100007374e4 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 0xfff800010282f088 in ?? () from /lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
#5 0xfff800010282f1a4 in __libc_start_main () from
/lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
#6 0x0000010000729000 in _start ()
No symbol table info available.
Backtrace stopped: previous frame identical to this frame (corrupt stack?)
Thread 5 (Thread 0xfff80001024a88c0 (LWP 3099941)):
#0 0xfff8000102846af0 in sigtimedwait () from /lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
#1 0x000001000072bed4 in my_sigwait (code=<synthetic pointer>,
sig=<synthetic pointer>, set=0xfff80001024a79e0) at
./include/my_pthread.h:191
siginfo = {si_signo = 7, si_errno = 4, si_code = -524287,
__pad0 = 122151936, _sifields = {_pad = {0, 0, 256, 36733056, -524287,
57708736, -524287, 57708736, 400412120, 149706496, 256, 16307856,
-524287, 57711104, 0, 0, -524287, 38433537, 256, 13217932, 0, 0, 0, 0,
0, 0, 0, 0}, _kill = {si_pid = 0, si_uid = 0}, _timer = {si_tid = 0,
si_overrun = 0, si_sigval = {sival_int = 256, sival_ptr =
0x10002308080}}, _rt = {si_pid = 0, si_uid = 0, si_sigval = {sival_int
= 256, sival_ptr = 0x10002308080}}, _sigchld = {si_pid = 0, si_uid =
0, si_status = 256, si_utime = -2251795461009216, si_stime =
-2251795461009216}, _sigfault = {si_addr = 0x0, _si_trapno = 256,
si_addr_lsb = 560, _bounds = {_addr_bnd = {_lower =
0xfff80001037090c0, _upper = 0xfff80001037090c0}, _pkey =
4294443009}}, _sigpoll = {si_band = 0, si_fd = 0}, _sigsys =
{_call_addr = 0x0, _syscall = 256, _arch = 36733056}}}
siginfo = <optimized out>
#2 signal_hand () at ./sql/mysqld.cc:3247
error = <optimized out>
origin = <optimized out>
set = {__val = {147461, 18444492278248546104, 0, 0,
18444492278229267009, 18444492278233444176, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0}}
sig = <optimized out>
#3 0x0000010000c9b0a0 in pfs_spawn_thread (arg=<optimized out>) at
./storage/perfschema/pfs.cc:2201
typed_arg = <optimized out>
user_arg = 0x0
user_start_routine = 0x1000072bda4 <signal_hand(void*)>
pfs = <optimized out>
klass = <optimized out>
#4 0xfff800010289068c in ?? () from /lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
Backtrace stopped: previous frame identical to this frame (corrupt stack?)
Thread 4 (Thread 0xfff800010245a8c0 (LWP 3099937)):
#0 0xfff800010288cc4c in ?? () from /lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
#1 0xfff800010288fd20 in pthread_cond_wait () from
/lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
#2 0x00000100006f9d34 in psi_cond_wait (that=0x100019f8498
<COND_manager>, mutex=0x100019f84d0 <LOCK_manager>, file=0x1000105d1f8
"./sql/sql_manager.cc", line=109) at ./mysys/my_thr_init.c:598
state = {m_flags = 7, m_operation = (unknown: 0x817bc0),
m_cond = 0x100023c88c0, m_mutex = 0xfff80001001de440, m_thread =
0xfff8000103707a40, m_timer_start = 1719756960493323065, m_timer =
0x10000f8d690 <my_timer_nanoseconds>, m_wait = 0xfff8000103708380}
locker = 0xfff8000102459a08
result = <optimized out>
#3 0x0000010000817e0c in inline_mysql_cond_wait (that=<optimized
out>, mutex=<optimized out>, src_file=<optimized out>,
src_line=<optimized out>) at ./include/mysql/psi/mysql_thread.h:1070
No locals.
#4 handle_manager (arg=<optimized out>) at ./sql/sql_manager.cc:109
cb = <optimized out>
error = 0
abstime = {tv_sec = 0, tv_nsec = 1099549175792}
reset_flush_time = true
#5 0x0000010000c9b0a0 in pfs_spawn_thread (arg=<optimized out>) at
./storage/perfschema/pfs.cc:2201
typed_arg = <optimized out>
user_arg = 0x0
user_start_routine = 0x10000817a60 <handle_manager(void*)>
pfs = <optimized out>
klass = <optimized out>
#6 0xfff800010289068c in ?? () from /lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
Backtrace stopped: previous frame identical to this frame (corrupt stack?)
Thread 3 (Thread 0xfff80001007fd8c0 (LWP 3099935)):
#0 0xfff800010288cc4c in ?? () from /lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
#1 0xfff8000102890060 in pthread_cond_timedwait () from
/lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
#2 0x00000100006f9dac in psi_cond_timedwait (that=0x100022b72c8
<COND_timer>, mutex=0x100022b7300 <LOCK_timer>,
abstime=0xfff80001007fcaf0, file=0x10001126758 "./mysys/thr_timer.c",
line=321) at ./mysys/my_thr_init.c:611
state = {m_flags = 7, m_operation = PSI_COND_WAIT, m_cond =
0x100023c7f40, m_mutex = 0xfff80001001d9d40, m_thread =
0xfff8000103704d40, m_timer_start = 1719756960404835598, m_timer =
0x10000f8d690 <my_timer_nanoseconds>, m_wait = 0xfff8000103705680}
locker = 0xfff80001007fc9f8
result = <optimized out>
#3 0x0000010000f7f330 in inline_mysql_cond_timedwait
(that=0x100022b72c8 <COND_timer>, mutex=0x100022b7300 <LOCK_timer>,
src_file=0x10001126758 "./mysys/thr_timer.c", src_line=321,
abstime=0xfff80001007fcaf0) at ./include/mysql/psi/mysql_thread.h:1086
No locals.
#4 timer_handler (arg=<optimized out>) at ./mysys/thr_timer.c:321
error = <optimized out>
top_time = 0x100022b7260 <max_timer_data>
now = <optimized out>
abstime = {tv_sec = 2147483647, tv_nsec = 0}
#5 0x0000010000c9b0a0 in pfs_spawn_thread (arg=<optimized out>) at
./storage/perfschema/pfs.cc:2201
typed_arg = <optimized out>
user_arg = 0x0
user_start_routine = 0x10000f7f110 <timer_handler>
pfs = <optimized out>
klass = <optimized out>
#6 0xfff800010289068c in ?? () from /lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
Backtrace stopped: previous frame identical to this frame (corrupt stack?)
Thread 2 (Thread 0xfff800010d0018c0 (LWP 3099936)):
#0 0xfff800010288cc4c in ?? () from /lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
#1 0xfff8000102890060 in pthread_cond_timedwait () from
/lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
#2 0x00000100006f9dac in psi_cond_timedwait (that=0x1000222c0b0
<COND_checkpoint>, mutex=0x1000222c0e8 <LOCK_checkpoint>,
abstime=0xfff800010d000a10, file=0x100010b64a0
"./storage/maria/ma_servicethread.c", line=115) at
./mysys/my_thr_init.c:611
state = {m_flags = 7, m_operation = PSI_COND_WAIT, m_cond =
0x100023c8640, m_mutex = 0xfff80001001db240, m_thread =
0xfff80001037063c0, m_timer_start = 1719756960432569199, m_timer =
0x10000f8d690 <my_timer_nanoseconds>, m_wait = 0xfff8000103706d00}
locker = 0xfff800010d000928
result = <optimized out>
#3 0x0000010000c36e10 in inline_mysql_cond_timedwait
(src_file=0x100010b64a0 "./storage/maria/ma_servicethread.c",
src_line=115, abstime=0xfff800010d000a10, mutex=<optimized out>,
that=<optimized out>) at ./include/mysql/psi/mysql_thread.h:1086
No locals.
#4 my_service_thread_sleep (control=0x10001932268
<checkpoint_control>, sleep_time=<optimized out>) at
./storage/maria/ma_servicethread.c:115
abstime = {tv_sec = 1719756989, tv_nsec = 432567000}
res = 0 '\000'
#5 0x0000010000c2e928 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 = 256}
dfile = 0x0
kfile = 0x0
#6 0x0000010000c9b0a0 in pfs_spawn_thread (arg=<optimized out>) at
./storage/perfschema/pfs.cc:2201
typed_arg = <optimized out>
user_arg = 0x1e
user_start_routine = 0x10000c2e808 <ma_checkpoint_background>
pfs = <optimized out>
klass = <optimized out>
#7 0xfff800010289068c in ?? () from /lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
Backtrace stopped: previous frame identical to this frame (corrupt stack?)
Thread 1 (Thread 0xfff80001024f68c0 (LWP 3099949)):
#0 0xfff80001028928c0 in ?? () from /lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
#1 0x0000010000a85b74 in handle_fatal_signal (sig=10) at
./sql/signal_handler.cc:357
curr_time = 1719756966
tm = {tm_sec = 6, tm_min = 16, tm_hour = 14, tm_mday = 30,
tm_mon = 5, tm_year = 124, tm_wday = 0, tm_yday = 181, tm_isdst = 0,
tm_gmtoff = 0, tm_zone = 0x100023bbef0 "UTC"}
thd = 0xfff800011c000c68
print_invalid_query_pointer = false
Backtrace stopped: Cannot access memory at address 0xf0
More information about the pkg-mysql-maint
mailing list