main.partition_key_cache w2 [ fail ]
|
Test ended at 2022-02-25 12:00:49
|
|
CURRENT_TEST: main.partition_key_cache
|
mysqltest: At line 146: query 'INSERT t1 SELECT @a, CONCAT('X_', @a, ' MySQL'), 1167612400 - (@a:=@a+1) FROM x, x a' failed: <Unknown> (2013): Lost connection to server during query
|
|
The result from queries just before the failure was:
|
< snip >
|
KEY `inx_c`(c))
|
PARTITION BY RANGE (a)
|
SUBPARTITION BY HASH (a)
|
(PARTITION p0 VALUES LESS THAN (10)
|
(SUBPARTITION sp0,
|
SUBPARTITION sp1),
|
PARTITION p1 VALUES LESS THAN MAXVALUE
|
(SUBPARTITION sp2,
|
SUBPARTITION sp3));
|
CREATE TABLE t2 (
|
a INT,
|
b VARCHAR(257),
|
c INT NOT NULL,
|
PRIMARY KEY (a),
|
KEY `inx_b` (b),
|
KEY `inx_c`(c));
|
SET @a:=1167602400;
|
CREATE VIEW v AS SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4;
|
CREATE VIEW x AS SELECT 1 FROM v,v a,v b;
|
INSERT t1 SELECT @a, CONCAT('X_', @a, ' MySQL'), 1167612400 - (@a:=@a+1) FROM x, x a;
|
|
More results from queries before failure can be found in /<<PKGBUILDDIR>>/builddir/mysql-test/var/2/log/partition_key_cache.log
|
|
|
Server [mysqld.1 - pid: 6169, winpid: 6169, exit: 256] failed during test run
|
Server log from this test:
|
----------SERVER LOG START-----------
|
220225 12:00:49 [ERROR] mysqld got signal 11 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
Server version: 10.6.7-MariaDB-2~exp1-log
|
key_buffer_size=1048576
|
read_buffer_size=131072
|
max_used_connections=1
|
max_threads=153
|
thread_count=3
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62381 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0xafd006b8
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0xb29a9c5c thread_stack 0x49000
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0xafd0dc80): INSERT t1 SELECT @a, CONCAT('X_', @a, ' MySQL'), 1167612400 - (@a:=@a+1) FROM x, x a
|
|
Connection ID (thread ID): 105
|
Status: NOT_KILLED
|
|
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off
|
|
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
|
information that should help you find out what is causing the crash.
|
Writing a core file...
|
Working directory at /<<PKGBUILDDIR>>/builddir/mysql-test/var/2/mysqld.1/data
|
Resource Limits:
|
Limit Soft Limit Hard Limit Units
|
Max cpu time unlimited unlimited seconds
|
Max file size unlimited unlimited bytes
|
Max data size unlimited unlimited bytes
|
Max stack size 8388608 unlimited bytes
|
Max core file size unlimited unlimited bytes
|
Max resident set unlimited unlimited bytes
|
Max processes 30112 30112 processes
|
Max open files 1024 1024 files
|
Max locked memory 67108864 67108864 bytes
|
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 30112 30112 signals
|
Max msgqueue size 819200 819200 bytes
|
Max nice priority 0 0
|
Max realtime priority 0 0
|
Max realtime timeout unlimited unlimited us
|
Core pattern: core
|
|
----------SERVER LOG END-------------
|
|
|
- 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_key_cache/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 6898]
|
[New LWP 6383]
|
[New LWP 6189]
|
[New LWP 6193]
|
[New LWP 6188]
|
[New LWP 6203]
|
[New LWP 6170]
|
[New LWP 6198]
|
[Thread debugging using libthread_db enabled]
|
Using host libthread_db library "/lib/arm-linux-gnueabi/libthread_db.so.1".
|
Core was generated by `/<<PKGBUILDDIR>>/builddir/sql/mariadbd --defaults'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 0xb6a547a8 in pthread_kill () from /lib/arm-linux-gnueabi/libpthread.so.0
|
[Current thread is 1 (Thread 0xb29aa330 (LWP 6898))]
|
#0 0xb6a547a8 in pthread_kill () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#1 0x00b3ca2c in handle_fatal_signal (sig=<optimized out>) at ./sql/signal_handler.cc:345
|
#2 <signal handler called>
|
#3 0xafdf0a20 in ?? ()
|
#4 0x00957ec4 in best_extension_by_limited_search (join=0xafa069a0, remaining_tables=<optimized out>, idx=2946562296, record_count=0, read_time=0, search_depth=0, prune_level=0, use_cond_selectivity=2949646008) at ./sql/sql_select.cc:10057
|
Backtrace stopped: previous frame inner to this frame (corrupt stack?)
|
|
Thread 8 (Thread 0xb11b3330 (LWP 6198)):
|
#0 0xb6a5a8f0 in __futex_abstimed_wait_common64 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#1 0xb6a5a960 in __futex_abstimed_wait_cancelable64 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#2 0xb6a52adc in pthread_cond_wait@@GLIBC_2.4 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#3 0x0081673c in psi_cond_wait (that=0x170bcd8 <COND_manager>, mutex=0x170bd10 <LOCK_manager>, file=<optimized out>, line=<optimized out>) at ./mysys/my_thr_init.c:596
|
#4 0x009115f4 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
|
#5 handle_manager (arg=arg@entry=0x0) at ./sql/sql_manager.cc:103
|
#6 0x00d7353c in pfs_spawn_thread (arg=0x3c23548) at ./storage/perfschema/pfs.cc:2201
|
#7 0xb6a49e58 in start_thread () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#8 0xb6742f98 in ?? () from /lib/arm-linux-gnueabi/libc.so.6
|
Backtrace stopped: previous frame identical to this frame (corrupt stack?)
|
|
Thread 7 (Thread 0xb6fa5550 (LWP 6170)):
|
#0 0xb6736fe0 in poll () from /lib/arm-linux-gnueabi/libc.so.6
|
#1 0x0085af4c in poll (__timeout=-1, __nfds=<optimized out>, __fds=<optimized out>) at /usr/include/arm-linux-gnueabi/bits/poll2.h:47
|
#2 handle_connections_sockets () at ./sql/mysqld.cc:6118
|
#3 0x0085c258 in mysqld_main (argc=<optimized out>, argv=<optimized out>) at ./sql/mysqld.cc:5823
|
#4 0xb6679e24 in __libc_start_main () from /lib/arm-linux-gnueabi/libc.so.6
|
#5 0x0084f1a8 in _start () at ./sql/my_decimal.h:147
|
Backtrace stopped: previous frame identical to this frame (corrupt stack?)
|
|
Thread 6 (Thread 0xb1168330 (LWP 6203)):
|
#0 0xb6a5a8f0 in __futex_abstimed_wait_common64 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#1 0xb6a5a960 in __futex_abstimed_wait_cancelable64 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#2 0xb6a52f20 in __pthread_cond_timedwait64 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#3 0xb6a5316c in pthread_cond_timedwait@@GLIBC_2.4 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#4 0x008167d4 in psi_cond_timedwait (that=0x170a660 <thread_cache>, mutex=0x170a6d0 <thread_cache+112>, abstime=0xb1167c20, file=<optimized out>, line=176) at ./mysys/my_thr_init.c:609
|
#5 0x00a1dd94 in inline_mysql_cond_timedwait (src_file=0x10fda78 "./sql/thread_cache.h", src_line=176, abstime=0xb1167c20, mutex=<optimized out>, that=0x170a660 <thread_cache>) at ./include/mysql/psi/mysql_thread.h:1086
|
#6 Thread_cache::park (this=0x170a660 <thread_cache>) at ./sql/thread_cache.h:176
|
#7 0x00a1d7a4 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x3ca2138, put_in_cache=put_in_cache@entry=true) at ./sql/sql_connect.cc:1431
|
#8 0x00a1db40 in handle_one_connection (arg=arg@entry=0x3ca2138) at ./sql/sql_connect.cc:1312
|
#9 0x00d7353c in pfs_spawn_thread (arg=0x3c3e9d8) at ./storage/perfschema/pfs.cc:2201
|
#10 0xb6a49e58 in start_thread () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#11 0xb6742f98 in ?? () from /lib/arm-linux-gnueabi/libc.so.6
|
Backtrace stopped: previous frame identical to this frame (corrupt stack?)
|
|
Thread 5 (Thread 0xb28ac330 (LWP 6188)):
|
#0 0xb6a5a8f0 in __futex_abstimed_wait_common64 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#1 0xb6a5a960 in __futex_abstimed_wait_cancelable64 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#2 0xb6a52f20 in __pthread_cond_timedwait64 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#3 0xb6a5316c in pthread_cond_timedwait@@GLIBC_2.4 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#4 0x008167d4 in psi_cond_timedwait (that=that@entry=0x1fa1610 <COND_timer>, mutex=mutex@entry=0x1fa15c8 <LOCK_timer>, abstime=0xb28abc70, file=<optimized out>, line=line@entry=321) at ./mysys/my_thr_init.c:609
|
#5 0x010658e8 in inline_mysql_cond_timedwait (that=0x1fa1610 <COND_timer>, mutex=0x1fa15c8 <LOCK_timer>, src_file=0x12d5b1c "./mysys/thr_timer.c", src_line=321, abstime=0xb28abc70) at ./include/mysql/psi/mysql_thread.h:1086
|
#6 timer_handler (arg=arg@entry=0x0) at ./mysys/thr_timer.c:321
|
#7 0x00d7353c in pfs_spawn_thread (arg=0x3b6da78) at ./storage/perfschema/pfs.cc:2201
|
#8 0xb6a49e58 in start_thread () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#9 0xb6742f98 in ?? () from /lib/arm-linux-gnueabi/libc.so.6
|
Backtrace stopped: previous frame identical to this frame (corrupt stack?)
|
|
Thread 4 (Thread 0xb11fe330 (LWP 6193)):
|
#0 0xb669206c in ?? () from /lib/arm-linux-gnueabi/libc.so.6
|
#1 0xb6692168 in sigtimedwait () from /lib/arm-linux-gnueabi/libc.so.6
|
#2 0x008519fc in my_sigwait (code=<synthetic pointer>, sig=0xb11fdb54, set=0xb11fdb58) at ./include/my_pthread.h:195
|
#3 signal_hand (arg=arg@entry=0x0) at ./sql/mysqld.cc:3116
|
#4 0x00d7353c in pfs_spawn_thread (arg=0x3c27368) at ./storage/perfschema/pfs.cc:2201
|
#5 0xb6a49e58 in start_thread () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#6 0xb6742f98 in ?? () from /lib/arm-linux-gnueabi/libc.so.6
|
Backtrace stopped: previous frame identical to this frame (corrupt stack?)
|
|
Thread 3 (Thread 0xb19ff330 (LWP 6189)):
|
#0 0xb6a5a8f0 in __futex_abstimed_wait_common64 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#1 0xb6a5a960 in __futex_abstimed_wait_cancelable64 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#2 0xb6a52f20 in __pthread_cond_timedwait64 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#3 0xb6a5316c in pthread_cond_timedwait@@GLIBC_2.4 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#4 0x008167d4 in psi_cond_timedwait (that=0x1f2a4b8 <COND_checkpoint>, mutex=0x1f2a490 <LOCK_checkpoint>, abstime=abstime@entry=0xb19fec08, file=<optimized out>, line=line@entry=115) at ./mysys/my_thr_init.c:609
|
#5 0x00d0fca4 in inline_mysql_cond_timedwait (src_file=0x125eddc "./storage/maria/ma_servicethread.c", src_line=115, abstime=0xb19fec08, mutex=<optimized out>, that=<optimized out>) at ./include/mysql/psi/mysql_thread.h:1086
|
#6 my_service_thread_sleep (control=control@entry=0x1692c04 <checkpoint_control>, sleep_time=<optimized out>) at ./storage/maria/ma_servicethread.c:115
|
#7 0x00d0749c in ma_checkpoint_background (arg=arg@entry=0x1e) at ./storage/maria/ma_checkpoint.c:725
|
#8 0x00d7353c in pfs_spawn_thread (arg=0x3bd2870) at ./storage/perfschema/pfs.cc:2201
|
#9 0xb6a49e58 in start_thread () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#10 0xb6742f98 in ?? () from /lib/arm-linux-gnueabi/libc.so.6
|
Backtrace stopped: previous frame identical to this frame (corrupt stack?)
|
|
Thread 2 (Thread 0xb0d8e330 (LWP 6383)):
|
#0 0xb6a5a8f0 in __futex_abstimed_wait_common64 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#1 0xb6a5a960 in __futex_abstimed_wait_cancelable64 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#2 0xb6a52f20 in __pthread_cond_timedwait64 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#3 0xb6a5316c in pthread_cond_timedwait@@GLIBC_2.4 () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#4 0x008167d4 in psi_cond_timedwait (that=0x170a660 <thread_cache>, mutex=0x170a6d0 <thread_cache+112>, abstime=0xb0d8dc20, file=<optimized out>, line=176) at ./mysys/my_thr_init.c:609
|
#5 0x00a1dd94 in inline_mysql_cond_timedwait (src_file=0x10fda78 "./sql/thread_cache.h", src_line=176, abstime=0xb0d8dc20, mutex=<optimized out>, that=0x170a660 <thread_cache>) at ./include/mysql/psi/mysql_thread.h:1086
|
#6 Thread_cache::park (this=0x170a660 <thread_cache>) at ./sql/thread_cache.h:176
|
#7 0x00a1d7a4 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x3c27aa0, put_in_cache=put_in_cache@entry=true) at ./sql/sql_connect.cc:1431
|
#8 0x00a1db40 in handle_one_connection (arg=arg@entry=0x3c27aa0) at ./sql/sql_connect.cc:1312
|
#9 0x00d7353c in pfs_spawn_thread (arg=0x3c3e9d8) at ./storage/perfschema/pfs.cc:2201
|
#10 0xb6a49e58 in start_thread () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#11 0xb6742f98 in ?? () from /lib/arm-linux-gnueabi/libc.so.6
|
Backtrace stopped: previous frame identical to this frame (corrupt stack?)
|
|
Thread 1 (Thread 0xb29aa330 (LWP 6898)):
|
#0 0xb6a547a8 in pthread_kill () from /lib/arm-linux-gnueabi/libpthread.so.0
|
#1 0x00b3ca2c in handle_fatal_signal (sig=<optimized out>) at ./sql/signal_handler.cc:345
|
#2 <signal handler called>
|
#3 0xafdf0a20 in ?? ()
|
#4 0x00957ec4 in best_extension_by_limited_search (join=0xafa069a0, remaining_tables=<optimized out>, idx=2946562296, record_count=0, read_time=0, search_depth=0, prune_level=0, use_cond_selectivity=2949646008) at ./sql/sql_select.cc:10057
|
Backtrace stopped: previous frame inner to this frame (corrupt stack?)
|