Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
None
-
None
-
Not for Release Notes
Description
crash:
Server version: 11.8.8-MariaDB-debug source revision: 46a8eb42a520193686d9a16d4cea4b3e002917e4
The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
contains instructions to obtain a better version of the backtrace below.
Following these instructions will help MariaDB developers provide a fix quicker.
Attempting backtrace. Include this in the bug report.
(note: Retrieving this information may fail)
Thread pointer: 0x776334000dc8
stack_bottom = 0x7f6380073000 thread_stack 0x49000
addr2line: DWARF error: invalid or unhandled FORM value: 0x23
/home/mysql/mariadb/bld/sql/mariadbd(my_print_stacktrace+0x53)[0x55dd4b983f43]
/home/mysql/mariadb/bld/sql/mariadbd(handle_fatal_signal+0x2df)[0x55dd4aa1f88f]
libc_sigaction.c:0(__restore_rt)[0x7f63827d6520]
addr2line: DWARF error: invalid or unhandled FORM value: 0x23
sql_select.cc:0(remove_const(JOIN*, st_order*, Item*, bool, bool*))[0x55dd4a40a431]
/home/mysql/mariadb/bld/sql/mariadbd(_ZN4JOIN15optimize_stage2Ev+0x2298)[0x55dd4a4013f8]
/home/mysql/mariadb/bld/sql/mariadbd(_ZN4JOIN14optimize_innerEv+0x31aa)[0x55dd4a3fde5a]
/home/mysql/mariadb/bld/sql/mariadbd(_ZN4JOIN8optimizeEv+0x10e)[0x55dd4a3faa1e]
/home/mysql/mariadb/bld/sql/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x849)[0x55dd4a3ebe19]
/home/mysql/mariadb/bld/sql/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x31b)[0x55dd4a3eb39b]
/home/mysql/mariadb/bld/sql/mariadbd(_Z21mysql_execute_commandP3THDb+0xd31a)[0x55dd4a34345a]
/home/mysql/mariadb/bld/sql/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x680)[0x55dd4a328db0]
/home/mysql/mariadb/bld/sql/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x24ea)[0x55dd4a32377a]
/home/mysql/mariadb/bld/sql/mariadbd(_Z10do_commandP3THDb+0xec9)[0x55dd4a32a4a9]
/home/mysql/mariadb/bld/sql/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3da)[0x55dd4a6adeda]
/home/mysql/mariadb/bld/sql/mariadbd(handle_one_connection+0x1ed)[0x55dd4a6ad9ed]
/home/mysql/mariadb/bld/sql/mariadbd(+0x1743346)[0x55dd4afda346]
nptl/pthread_create.c:442(start_thread)[0x7f6382828ac3]
x86_64/clone.S:102(_GI__clone)[0x7f63828b9a84]
Connection ID (thread ID): 4
Status: NOT_KILLED
Query (0x776334048bf0): INSERT INTO v8 ( v1 ) SELECT 'x' FROM v9 WHERE v4 = 93
reproduce:
SET GLOBAL TRANSACTION READ WRITE;
SET SESSION TRANSACTION READ WRITE;
DROP DATABASE IF EXISTS test_sqlright1;
CREATE DATABASE IF NOT EXISTS test_sqlright1;
USE test_sqlright1;
CREATE TABLE v1099(c1100 INT);
CREATE TABLE v0 ( v1 NUMERIC NOT NULL NOT NULL CHECK ( v2 >= -1 AND v1 < 0 ) , v2 INT UNIQUE , v3 INT , v4 INT UNIQUE ) ;
CREATE VIEW v8 AS SELECT * FROM ( SELECT DISTINCT v4 FROM v0 WHERE TRUE NOT LIKE - 0 OR ( v1 = 127 AND v1 = 'x' ) ) AS v6 NATURAL JOIN v0 AS v7 NATURAL JOIN v0 AS v5 WHERE v3 = v1 ORDER BY v4 = 'x' AND v4 = 'x' AND v2 = 'x' , 96 + v2 ;
CREATE TABLE v9 AS SELECT v4 , v2 FROM v0 ;
CREATE TRIGGER v10 BEFORE INSERT ON v0 FOR EACH ROW INSERT INTO v8 VALUES ( ( ( ( SELECT 30 FROM v0 WHERE v2 != 71 GROUP BY v1 ) != 'x' + 16 ) / 32 OR v3 = 'x' ) ) ;
UPDATE v8 AS v11 SET v2 = 98 ;
INSERT INTO v8 ( v1 ) SELECT 'x' FROM v9 WHERE v4 = 93 ;
Attachments
Issue Links
- duplicates
-
MDEV-30756 Crash in get_sort_by_table / make_join_statistics / update_depend_map_for_order, various UBSAN pointer issues, MSAN use of uninit value
-
- Stalled
-