server crash in signal handler, my_write_core, on sparc64

main.partition_order                     w2 [ fail ]

        Test ended at 2022-02-25 10:53:53

CURRENT_TEST: main.partition_order

mysqltest: At line 534: query 'select * from t1 force index (b) where b > '0' order by b' failed: <Unknown> (2013): Lost connection to server during query

The result from queries just before the failure was:

< snip >

a	b

1	1

35	2

30	4

2	5

drop table t1;

CREATE TABLE t1 (

a int not null,

b tinytext not null,

primary key(a),

index (b(10)))

partition by range (a)

partitions 2

(partition x1 values less than (25),

partition x2 values less than (100));

INSERT into t1 values (1, '1');

INSERT into t1 values (2, '5');

INSERT into t1 values (30, '4');

INSERT into t1 values (35, '2');

select * from t1 force index (b) where b > '0' order by b;

More results from queries before failure can be found in /<<PKGBUILDDIR>>/builddir/mysql-test/var/2/log/partition_order.log

 - found 'core' (0/5)

Trying 'dbx' to get a backtrace

Trying 'gdb' to get a backtrace from coredump /<<PKGBUILDDIR>>/builddir/mysql-test/var/2/log/main.partition_order/mysqld.1/data/core

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 2294694]

[New LWP 2294047]

[New LWP 2294053]

[New LWP 2294055]

[New LWP 2294051]

[New LWP 2294049]

[New LWP 2296516]

[New LWP 2294031]

[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'.

Program terminated with signal SIGUSR1, User defined signal 1.

#0  0xffff800101047fcc in pthread_kill () from /lib/sparc64-linux-gnu/libpthread.so.0

[Current thread is 1 (Thread 0xffff800107944870 (LWP 2294694))]

#0  0xffff800101047fcc in pthread_kill () from /lib/sparc64-linux-gnu/libpthread.so.0

#1  0x000001000098d944 in handle_fatal_signal (sig=<optimized out>) at ./sql/signal_handler.cc:345

Backtrace stopped: Cannot access memory at address 0xf0

Thread 8 (Thread 0xffff800100037780 (LWP 2294031)):

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

#1  0x00000100006b3bb4 in poll (__timeout=-1, __nfds=<optimized out>, __fds=<optimized out>) at /usr/include/sparc64-linux-gnu/bits/poll2.h:47

#2  handle_connections_sockets () at ./sql/mysqld.cc:6118

#3  0x00000100006b4c0c in mysqld_main (argc=<optimized out>, argv=<optimized out>) at ./sql/mysqld.cc:5823

#4  0xffff800101773cfc in __libc_start_main () from /lib/sparc64-linux-gnu/libc.so.6

#5  0x00000100006a79b0 in _start () at ./sql/sql_list.h:159

Backtrace stopped: previous frame identical to this frame (corrupt stack?)

Thread 7 (Thread 0xffff8001063f2870 (LWP 2296516)):

#0  0xffff80010104d890 in __futex_abstimed_wait_common64 () from /lib/sparc64-linux-gnu/libpthread.so.0

#1  0xffff8001010468a0 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/sparc64-linux-gnu/libpthread.so.0

#2  0x000001000067595c in psi_cond_timedwait (that=0x100017a85b0 <thread_cache>, mutex=0x100017a8620 <thread_cache+112>, abstime=0xffff8001063f1a80, file=0x10000f38388 "./sql/thread_cache.h", line=<optimized out>) at ./mysys/my_thr_init.c:609

#3  0x0000010000871724 in inline_mysql_cond_timedwait (src_file=0x10000f38388 "./sql/thread_cache.h", src_line=176, abstime=0xffff8001063f1a80, mutex=<optimized out>, that=<optimized out>) at ./include/mysql/psi/mysql_thread.h:1086

#4  Thread_cache::park (this=<optimized out>) at ./sql/thread_cache.h:176

#5  do_handle_one_connection (connect=<optimized out>, put_in_cache=<optimized out>) at ./sql/sql_connect.cc:1431

#6  0x0000010000871858 in handle_one_connection (arg=<optimized out>) at ./sql/sql_connect.cc:1312

#7  0x0000010000bb6690 in pfs_spawn_thread (arg=<optimized out>) at ./storage/perfschema/pfs.cc:2201

#8  0xffff80010103f494 in start_thread () from /lib/sparc64-linux-gnu/libpthread.so.0

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

Backtrace stopped: previous frame identical to this frame (corrupt stack?)

Thread 6 (Thread 0xffff80010780d870 (LWP 2294049)):

#0  0xffff80010104d890 in __futex_abstimed_wait_common64 () from /lib/sparc64-linux-gnu/libpthread.so.0

#1  0xffff8001010468a0 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/sparc64-linux-gnu/libpthread.so.0

#2  0x000001000067595c in psi_cond_timedwait (that=0x10001fdb4f8 <COND_checkpoint>, mutex=0x10001fdb530 <LOCK_checkpoint>, abstime=0xffff80010780ca60, file=0x100010a1188 "./storage/maria/ma_servicethread.c", line=<optimized out>) at ./mysys/my_thr_init.c:609

#3  0x0000010000b541d4 in inline_mysql_cond_timedwait (src_file=0x100010a1188 "./storage/maria/ma_servicethread.c", src_line=115, abstime=0xffff80010780ca60, mutex=<optimized out>, that=<optimized out>) at ./include/mysql/psi/mysql_thread.h:1086

#4  my_service_thread_sleep (control=0x1000170ea98 <checkpoint_control>, sleep_time=<optimized out>) at ./storage/maria/ma_servicethread.c:115

#5  0x0000010000b4bcec in ma_checkpoint_background (arg=0x1e) at ./storage/maria/ma_checkpoint.c:725

#6  0x0000010000bb6690 in pfs_spawn_thread (arg=<optimized out>) at ./storage/perfschema/pfs.cc:2201

#7  0xffff80010103f494 in start_thread () from /lib/sparc64-linux-gnu/libpthread.so.0

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

Backtrace stopped: previous frame identical to this frame (corrupt stack?)

Thread 5 (Thread 0xffff80010785a870 (LWP 2294051)):

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

#1  0x00000100006aa680 in my_sigwait (code=<synthetic pointer>, sig=0xffff800107859a28, set=0xffff800107859a30) at ./include/my_pthread.h:195

#2  signal_hand (arg=<optimized out>) at ./sql/mysqld.cc:3116

#3  0x0000010000bb6690 in pfs_spawn_thread (arg=<optimized out>) at ./storage/perfschema/pfs.cc:2201

#4  0xffff80010103f494 in start_thread () from /lib/sparc64-linux-gnu/libpthread.so.0

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

Backtrace stopped: previous frame identical to this frame (corrupt stack?)

Thread 4 (Thread 0xffff8001078f6870 (LWP 2294055)):

#0  0xffff80010104d890 in __futex_abstimed_wait_common64 () from /lib/sparc64-linux-gnu/libpthread.so.0

#1  0xffff8001010468a0 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/sparc64-linux-gnu/libpthread.so.0

#2  0x000001000067595c in psi_cond_timedwait (that=0x100017a85b0 <thread_cache>, mutex=0x100017a8620 <thread_cache+112>, abstime=0xffff8001078f5a80, file=0x10000f38388 "./sql/thread_cache.h", line=<optimized out>) at ./mysys/my_thr_init.c:609

#3  0x0000010000871724 in inline_mysql_cond_timedwait (src_file=0x10000f38388 "./sql/thread_cache.h", src_line=176, abstime=0xffff8001078f5a80, mutex=<optimized out>, that=<optimized out>) at ./include/mysql/psi/mysql_thread.h:1086

#4  Thread_cache::park (this=<optimized out>) at ./sql/thread_cache.h:176

#5  do_handle_one_connection (connect=<optimized out>, put_in_cache=<optimized out>) at ./sql/sql_connect.cc:1431

#6  0x0000010000871858 in handle_one_connection (arg=<optimized out>) at ./sql/sql_connect.cc:1312

#7  0x0000010000bb6690 in pfs_spawn_thread (arg=<optimized out>) at ./storage/perfschema/pfs.cc:2201

#8  0xffff80010103f494 in start_thread () from /lib/sparc64-linux-gnu/libpthread.so.0

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

Backtrace stopped: previous frame identical to this frame (corrupt stack?)

Thread 3 (Thread 0xffff8001078a8870 (LWP 2294053)):

#0  0xffff80010104d890 in __futex_abstimed_wait_common64 () from /lib/sparc64-linux-gnu/libpthread.so.0

#1  0xffff80010104652c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/sparc64-linux-gnu/libpthread.so.0

#2  0x00000100006758e4 in psi_cond_wait (that=0x100017aa9b8 <COND_manager>, mutex=0x100017aa9f0 <LOCK_manager>, file=0x10000f4d390 "./sql/sql_manager.cc", line=<optimized out>) at ./mysys/my_thr_init.c:596

#3  0x00000100007689d4 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

#4  handle_manager (arg=<optimized out>) at ./sql/sql_manager.cc:103

#5  0x0000010000bb6690 in pfs_spawn_thread (arg=<optimized out>) at ./storage/perfschema/pfs.cc:2201

#6  0xffff80010103f494 in start_thread () from /lib/sparc64-linux-gnu/libpthread.so.0

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

Backtrace stopped: previous frame identical to this frame (corrupt stack?)

Thread 2 (Thread 0xffff80010008f870 (LWP 2294047)):

#0  0xffff80010104d890 in __futex_abstimed_wait_common64 () from /lib/sparc64-linux-gnu/libpthread.so.0

#1  0xffff8001010468a0 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/sparc64-linux-gnu/libpthread.so.0

#2  0x000001000067595c in psi_cond_timedwait (that=0x10002079e40 <COND_timer>, mutex=0x10002079e78 <LOCK_timer>, abstime=0xffff80010008eb40, file=0x1000111c520 "./mysys/thr_timer.c", line=<optimized out>) at ./mysys/my_thr_init.c:609

#3  0x0000010000e9c740 in inline_mysql_cond_timedwait (that=0x10002079e40 <COND_timer>, mutex=0x10002079e78 <LOCK_timer>, src_file=0x1000111c520 "./mysys/thr_timer.c", src_line=321, abstime=0xffff80010008eb40) at ./include/mysql/psi/mysql_thread.h:1086

#4  timer_handler (arg=<optimized out>) at ./mysys/thr_timer.c:321

#5  0x0000010000bb6690 in pfs_spawn_thread (arg=<optimized out>) at ./storage/perfschema/pfs.cc:2201

#6  0xffff80010103f494 in start_thread () from /lib/sparc64-linux-gnu/libpthread.so.0

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

Backtrace stopped: previous frame identical to this frame (corrupt stack?)

Thread 1 (Thread 0xffff800107944870 (LWP 2294694)):

#0  0xffff800101047fcc in pthread_kill () from /lib/sparc64-linux-gnu/libpthread.so.0

#1  0x000001000098d944 in handle_fatal_signal (sig=<optimized out>) at ./sql/signal_handler.cc:345

Backtrace stopped: Cannot access memory at address 0xf0

...

Too many failed: Failed 18/997 tests, 98.19% were successful.

Failing test(s): main.partition_order main.func_str main.group_by main.group_by_null main.features main.repair_symlink-5543 main.type_datetime main.xml main.func_like main.func_math

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, please read first the documentation

at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

Errors/warnings were found in logfiles during server shutdown after running the

following sequence(s) of tests:

    main.lock main.partition_hash main.ignored_index main.ctype_uca_partitions main.partition_cache_myisam main.partition_default main.partition_mgm_err2 main.partition_myisam main.partition_mgm main.partition_column main.information_schema_part main.partition_list main.huge_frm-6224 main.partition_key_cache main.ctype_partitions main.long_unique main.explain_non_select main.explain_json_format_partitions main.partition_order main.partition_column_prune main.partition_charset main.partition_mrr_myisam main.partition_grant main.partition_csv main.assign_key_cache main.partition_error main.partition_mgm_err main.partition_bug18198 main.partition_mrr_aria main.auto_increment_ranges_myisam main.column_compression_parts

    main.partition_order

    main.func_regexp_pcre main.func_regexp main.func_sapdb main.func_op main.func_str main.func_set

    main.func_str

    main.grant_not_windows main.grant_slave_monitor main.grant_explain_non_select main.grant_master_admin main.grant_read_only main.greedy_optimizer main.grant_server main.group_by main.grant_cache_ps_prot main.grant_kill main.grant_repair main.grant_slave_admin main.grant_lowercase_fs

    main.group_by

    main.group_by_null

    main.group_by_null

    main.explain main.events_2 main.events_grant main.events_slowlog main.failed_auth_3909 main.explain_json main.events_embedded main.enforce_storage_engine main.features main.execution_constants main.except_all main.events_1 main.events_microsec main.except main.events_scheduling

    main.features

    main.subselect_extra main.subselect_extra_no_semijoin main.subselect_cache main.empty_user_table main.type_datetime main.subselect_exists2in_costmat main.subselect_exists2in main.subselect_gis main.subselect_mat main.subselect3_jcl6 main.empty_string_literal main.subselect3 main.empty_table main.empty_server_name-8224

    main.type_datetime

    main.win_orderby main.udf main.win_percent_cume main.xml

149 tests were skipped, 61 by the test itself.