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
