Details
-
Bug
-
Status: Stalled (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3, 11.1.2, 11.2.2
-
None
-
Server version: 11.1.2-MariaDB-1:11.1.2+maria~ubu2204 source revision: 9bc25d98209df6810f7a7d5e7dd3ae677a313ab5
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=1
max_threads=153
thread_count=1
Description
I first run the following statements to create tables.
create table t1 (`c1` bigint, key (`c1`)); |
insert into t1 values (-2); |
create table t2 ( `c2` double unsigned ); |
insert into t2 values (12.991); |
After creating tables, I repeat executing the following statement through the MariaDB CLI.
SELECT f6 FROM (SELECT DISTINCT `c1` AS `f6` FROM `t1`) AS `t1` |
JOIN (SELECT CHARSET(`c2`) AS `f5` FROM `t2`) AS `t3` |
ON (EXISTS (SELECT `c2` FROM `t2`)) AND |
(NOT ((CHARSET(`f5`)) NOT BETWEEN `f6` AND `f6`)); |
After repeating several times (maybe 20 times), I lost the connection to the server.
Or try to run the following EXPLAIN query twice, I can get the same error.
EXPLAIN SELECT f6 FROM (SELECT DISTINCT `c1` AS `f6` FROM `t1`) AS `t1` |
JOIN (SELECT CHARSET(`c2`) AS `f5` FROM `t2`) AS `t3` |
ON (EXISTS (SELECT `c2` FROM `t2`)) AND |
(NOT ((CHARSET(`f5`)) NOT BETWEEN `f6` AND `f6`)); |
The following trace is gotten from the log.
stack_bottom = 0x7f4c90082c38 thread_stack 0x49000
|
Printing to addr2line failed
|
mariadbd(my_print_stacktrace+0x32)[0x563dd110a7c2]
|
mariadbd(handle_fatal_signal+0x488)[0x563dd0be3cf8]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7f4ca74bd520]
|
mariadbd(_Z15optimize_keyuseP4JOINP16st_dynamic_array+0x148)[0x563dd09b5088]
|
mariadbd(+0x8ad551)[0x563dd09eb551]
|
mariadbd(_ZN4JOIN14optimize_innerEv+0x1322)[0x563dd09f07e2]
|
mariadbd(_ZN4JOIN8optimizeEv+0xda)[0x563dd09f0e2a]
|
mariadbd(+0x7ec60c)[0x563dd092a60c]
|
mariadbd(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0x95)[0x563dd0929e35]
|
mariadbd(_ZN4JOIN14optimize_innerEv+0xb27)[0x563dd09effe7]
|
mariadbd(_ZN4JOIN8optimizeEv+0xda)[0x563dd09f0e2a]
|
mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xd1)[0x563dd09f0f21]
|
mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x154)[0x563dd09f1774]
|
mariadbd(+0x826f55)[0x563dd0964f55]
|
mariadbd(_Z21mysql_execute_commandP3THDb+0x419e)[0x563dd0973f0e]
|
mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1e7)[0x563dd0975237]
|
mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x14bd)[0x563dd0977a1d]
|
mariadbd(_Z10do_commandP3THDb+0x138)[0x563dd0979818]
|
mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3bf)[0x563dd0aa13af]
|
mariadbd(handle_one_connection+0x5d)[0x563dd0aa16fd]
|
mariadbd(+0xcd1906)[0x563dd0e0f906]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x94ac3)[0x7f4ca750fac3]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x126a40)[0x7f4ca75a1a40]
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Attachments
Issue Links
- relates to
-
-
- Confirmed
-
-
-
- Open
-