Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-40895

remove_const couse segfault

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Duplicate
    • None
    • N/A
    • Optimizer
    • 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

          Activity

            People

              Unassigned Unassigned
              v3rdant Xingwang Xiang
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.