Test main.partition_icp crashes on sparc64

main.partition_icp                       w11 [ fail ]

        Test ended at 2025-04-23 01:09:37

CURRENT_TEST: main.partition_icp

mysqltest: At line 37: query 'SELECT a, HEX(b) FROM t2 WHERE b >= 'te' and (a % 2)' failed: <Unknown> (2013): Lost connection to server during query

The result from queries just before the failure was:

< snip >

INSERT INTO t1 (a, b) VALUES (1, 0xdeadbeef), (2, "text filler"),

(3, 'filler...'), (4, " more filler "), (5, "test text"), (6, "testing...");

SELECT a, HEX(b) FROM t1 WHERE b >= 'te' and (a % 2);

a	HEX(b)

5	746573742074657874

1	DEADBEEF

set @handler_icp_attempts=(select cast(variable_value as int) from information_schema.session_status where variable_name='handler_icp_attempts');

set @handler_icp_match=(select cast(variable_value as int) from information_schema.session_status where variable_name='handler_icp_match');

select @old_handler_icp_attempts = @handler_icp_attempts;

@old_handler_icp_attempts = @handler_icp_attempts

1

select @old_handler_icp_match = @handler_icp_match;

@old_handler_icp_match = @handler_icp_match

1

CREATE TABLE t2 (a int PRIMARY KEY, b BLOB, c varchar(16) DEFAULT 'Filler...',

INDEX (b(4), a)) ENGINE = innodb PARTITION BY HASH (a) PARTITIONS 3;

INSERT INTO t2 (a, b) VALUES (1, 0xdeadbeef), (2, "text filler"),

(3, 'filler...'), (4, " more filler "), (5, "test text"), (6, "testing...");

set @@optimizer_switch='index_condition_pushdown=off';

SELECT a, HEX(b) FROM t2 WHERE b >= 'te' and (a % 2);

More results from queries before failure can be found in /build/reproducible-path/mariadb-11.8.1/builddir/mysql-test/var/11/log/partition_icp.log

 - found 'core.2891072' (1/1)

Core generated by '/build/reproducible-path/mariadb-11.8.1/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.8.1/builddir/mysql-test/var/11/mysqld.1/data/tc.log during file-backed mapping note processing

[New LWP 2891649]

[New LWP 2891246]

[New LWP 2891244]

[New LWP 2891247]

[New LWP 2891620]

[New LWP 2891621]

[New LWP 2891627]

[New LWP 2891072]

[New LWP 2891628]

[New LWP 2891634]

[New LWP 2891641]

[New LWP 2891642]

[New LWP 2891713]

[New LWP 2891245]

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.8.1/builddir/sql/mariadbd --defaults-group-suffix=.1 --defaults-file=/build/reproducible-path/mariadb-11.8.1/builddir/mysql-test/var/11/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 --loose-sequence --core-file --loose-debug-sync-timeout=300'.

Program terminated with signal SIGUSR1, User defined signal 1.

#0  0xfff8000102a951b0 in ?? () from /lib/sparc64-linux-gnu/libc.so.6

[Current thread is 1 (Thread 0xfff800010fd368e0 (LWP 2891649))]

#0  0xfff8000102a951b0 in ?? () from /lib/sparc64-linux-gnu/libc.so.6

#1  0x0000010000aef804 in handle_fatal_signal (sig=10) at ./sql/signal_handler.cc:298

#2  <signal handler called>

#3  0x7265636f76657261 in ?? ()