Bug#1098651: mariadb: FTBFS on sparc64: Post-build test suite fails on main.view

Source: mariadb
Version: 1:11.4.5-1
Tags: upstream, confirmed, help, ftbfs
X-Debbugs-CC: [email protected]
User: [email protected]
Usertags: sparc64
Forwarded: https://jira.mariadb.org/browse/MDEV-36145

After latest upload to Debian unstable I noticed the post-build test
fails on MariaDB crashing during main.view:


main.view                                w6 [ fail ]
        Test ended at 2025-02-22 04:08:02

CURRENT_TEST: main.view
mysqltest: At line 6789: query 'SELECT * FROM v WHERE
UpdateXML('<user>N/A</user>','/a',CURRENT_USER())' failed: <Unknown>
(2013): Lost connection to server during query

The result from queries just before the failure was:
< snip >
CREATE TABLE t1 (i INT);
CREATE VIEW v1 AS SELECT 1 FROM t1
UNION
(SELECT 1 FROM DUAL WHERE 1 GROUP BY 1 HAVING 1 ORDER BY 1
FOR UPDATE);
SELECT * FROM v1;
1
1
SHOW CREATE VIEW v1;
View Create View character_set_client collation_connection
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY
DEFINER VIEW `v1` AS select 1 AS `1` from `t1` union (select 1 AS `1`
from DUAL  where 1 group by 1 having 1 for update) latin1
latin1_swedish_ci
DROP VIEW v1;
DROP TABLE t1;
#
# MDEV-35090: (Item_func_current_user) Assertion
# `typeid(*copy) == typeid(*this)' failed in
# Item_func_or_sum::do_build_clone
#
CREATE VIEW v AS SELECT 1;
SELECT * FROM v WHERE UpdateXML('<user>N/A</user>','/a',CURRENT_USER());

More results from queries before failure can be found in
/build/reproducible-path/mariadb-11.4.5/builddir/mysql-test/var/6/log/view.log

 - found 'core' (0/1)
Core generated by
'/build/reproducible-path/mariadb-11.4.5/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).
--------------------------

warning: Can't open file anon_inode:[io_uring] during file-backed
mapping note processing

warning: Can't open file
/build/reproducible-path/mariadb-11.4.5/builddir/mysql-test/var/6/mysqld.1/data/tc.log
during file-backed mapping note processing
[New LWP 3239891]
[New LWP 3239867]
[New LWP 3239868]
[New LWP 3239869]
[New LWP 3239870]
[New LWP 3239876]
[New LWP 3239841]
[New LWP 3239877]
[New LWP 3239880]
[New LWP 3239883]
[New LWP 3239884]
[New LWP 3239887]
[New LWP 3239903]
[New LWP 3239879]
[New LWP 3239980]
[New LWP 3239982]

This GDB supports auto-downloading debuginfo from the following URLs:
  <https://debuginfod.debian.net>
Enable debuginfod for this session? (y or [n]) [answered N; input not
from terminal]
Debuginfod has been disabled.
To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit.
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/sparc64-linux-gnu/libthread_db.so.1".
Core was generated by
`/build/reproducible-path/mariadb-11.4.5/builddir/sql/mariadbd
--defaults-group-suffix=.1
--defaults-file=/build/reproducible-path/mariadb-11.4.5/builddir/mysql-test/var/6/my.cnf
--log-output=file --loose-enable-partition --innodb --innodb-cmpmem
--innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits
--innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page
--innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields
--innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes
--innodb-sys-tables --innodb-sys-virtual --core-file
--loose-debug-sync-timeout=300'.
Program terminated with signal SIGUSR1, User defined signal 1.
#0  0xffff800102a94e88 in ?? () from /lib/sparc64-linux-gnu/libc.so.6
[Current thread is 1 (Thread 0xffff800113d868c0 (LWP 3239891))]
#0  0xffff800102a94e88 in ?? () from /lib/sparc64-linux-gnu/libc.so.6
#1  0x0000010000ac44c4 in handle_fatal_signal (sig=10) at
./sql/signal_handler.cc:298
#2  <signal handler called>
#3  0x4d7953514c586964 in ?? ()
Backtrace stopped: previous frame identical to this frame (corrupt stack?)

Thread 16 (Thread 0xffff800113e228c0 (LWP 3239982)):
#0  0xffff800102a8f13c in ?? () from /lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
#1  0xffff800102a92518 in pthread_cond_timedwait () from
/lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
#2  0x00000100006d7ce8 in psi_cond_timedwait (that=0x10001af6968
<thread_cache>, mutex=0x10001af69d8 <thread_cache+112>,
abstime=0xffff800113e21a10, file=0x10001172930 "./sql/thread_cache.h",
line=176) at ./mysys/my_thr_init.c:611
        state = {m_flags = 256, m_operation = (unknown: 0x966008),
m_cond = 0x700000001, m_mutex = 0xffff8001009ca0c0, m_thread =
0xffff800103320f40, m_timer_start = 1740197267488084915, m_timer =
0x67b94d93, m_wait = 0x1daecf7a}
        locker = 0x0
        result = <optimized out>
#3  0x00000100009665e4 in inline_mysql_cond_timedwait
(src_file=0x10001172930 "./sql/thread_cache.h", src_line=176,
that=<optimized out>, mutex=<optimized out>,
abstime=0xffff800113e21a10) at ./include/mysql/psi/mysql_thread.h:1086
No locals.
#4  Thread_cache::park (this=<optimized out>) at ./sql/thread_cache.h:176
        error = <optimized out>
        abstime = {tv_sec = 1740197567, tv_nsec = 497995000}
        connect = 0x0
        flushed = <optimized out>
        abstime = <optimized out>
        connect = <optimized out>
        flushed = <optimized out>
        _now_ = <optimized out>
        error = <optimized out>
#5  do_handle_one_connection (connect=<optimized out>,
put_in_cache=true) at ./sql/sql_connect.cc:1421
        create_user = <optimized out>
        thr_create_utime = <optimized out>
        thd = 0xffff800148000c68
#6  0x00000100009666ec in handle_one_connection (arg=<optimized out>)
at ./sql/sql_connect.cc:1320
        connect = <optimized out>
#7  0x0000010000d16768 in pfs_spawn_thread (arg=<optimized out>) at
./storage/perfschema/pfs.cc:2201
        typed_arg = <optimized out>
        user_arg = 0x10003462488
        user_start_routine = 0x10000966690 <handle_one_connection(void*)>
        pfs = <optimized out>
        klass = <optimized out>
#8  0xffff800102a92db0 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 15 (Thread 0xffff800113dd48c0 (LWP 3239980)):
#0  0xffff800102a8f13c in ?? () from /lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
#1  0xffff800102a92518 in pthread_cond_timedwait () from
/lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
#2  0x00000100006d7ce8 in psi_cond_timedwait (that=0x10001af6968
<thread_cache>, mutex=0x10001af69d8 <thread_cache+112>,
abstime=0xffff800113dd3a10, file=0x10001172930 "./sql/thread_cache.h",
line=176) at ./mysys/my_thr_init.c:611
        state = {m_flags = 256, m_operation = (unknown: 0x966008),
m_cond = 0x700000001, m_mutex = 0xffff8001009ca0c0, m_thread =
0xffff8001033225c0, m_timer_start = 1740197267530182605, m_timer =
0x67b94d93, m_wait = 0x2030d3a0}
        locker = 0x0
        result = <optimized out>
#3  0x00000100009665e4 in inline_mysql_cond_timedwait
(src_file=0x10001172930 "./sql/thread_cache.h", src_line=176,
that=<optimized out>, mutex=<optimized out>,
abstime=0xffff800113dd3a10) at ./include/mysql/psi/mysql_thread.h:1086
No locals.
#4  Thread_cache::park (this=<optimized out>) at ./sql/thread_cache.h:176
        error = <optimized out>
        abstime = {tv_sec = 1740197567, tv_nsec = 540070000}
        connect = 0x0
        flushed = <optimized out>
        abstime = <optimized out>
        connect = <optimized out>
        flushed = <optimized out>
        _now_ = <optimized out>
        error = <optimized out>
#5  do_handle_one_connection (connect=<optimized out>,
put_in_cache=true) at ./sql/sql_connect.cc:1421
        create_user = <optimized out>
        thr_create_utime = <optimized out>
        thd = 0xffff800144000c68
#6  0x00000100009666ec in handle_one_connection (arg=<optimized out>)
at ./sql/sql_connect.cc:1320
        connect = <optimized out>
#7  0x0000010000d16768 in pfs_spawn_thread (arg=<optimized out>) at
./storage/perfschema/pfs.cc:2201
        typed_arg = <optimized out>
        user_arg = 0x100034558a8
        user_start_routine = 0x10000966690 <handle_one_connection(void*)>
        pfs = <optimized out>
        klass = <optimized out>
#8  0xffff800102a92db0 in ?? () from /lib/sparc64-linux-gnu/libc.so.6
No symbol table info available.
Backtrace stopped: previous frame identical to this frame (corrupt stack?)

Full log at: https://buildd.debian.org/status/fetch.php?pkg=mariadb&arch=sparc64&ver=1%3A11.4.5-1&stamp=1740197979&raw=0