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?)