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

SIGSEGV in PROF_MEASUREMENT::~PROF_MEASUREMENT | QUERY_PROFILE::~QUERY_PROFILE

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL)
    • 10.5, 10.6, 10.11
    • OTHER
    • None

    Description

      CREATE TABLE t (c INT) ENGINE=MyISAM UNION=(t,t0) INSERT_METHOD=FIRST;
      INSERT INTO t VALUES (0);
      SET SESSION profiling=ON;
      SELECT * INTO outfile 'a' FROM t;
      DROP TABLE t;
      CREATE TABLE t (a INT GENERATED ALWAYS AS (0) VIRTUAL,KEY(a)) ENGINE=MyISAM;
      LOAD DATA INFILE 'a' REPLACE INTO TABLE t;
      CREATE TABLE t0 (a INT) ENGINE=MyISAM;
      UPDATE t SET a=0;
      

      Leads to:

      11.1.0 17127fd91b763ba7c3f8ecb30190689a06bd9485 (Optimized)

      Core was generated by `/test/MD060623-mariadb-11.1.0-linux-x86_64-opt/bin/mariadbd --no-defaults --cor'.
      Program terminated with signal SIGSEGV, Segmentation fault.
      #0  0x000055d910ea7625 in PROF_MEASUREMENT::~PROF_MEASUREMENT (
          this=0x150000000040, __in_chrg=<optimized out>)
          at /test/11.1_opt/sql/sql_profile.cc:184
      [Current thread is 1 (Thread 0x151dbc051700 (LWP 1462580))]
      (gdb) bt
      #0  0x000055d910ea7625 in PROF_MEASUREMENT::~PROF_MEASUREMENT (this=0x150000000040, __in_chrg=<optimized out>) at /test/11.1_opt/sql/sql_profile.cc:184
      #1  0x000055d910ea79c8 in QUERY_PROFILE::~QUERY_PROFILE (this=0x151d84067700, __in_chrg=<optimized out>) at /test/11.1_opt/sql/sql_profile.cc:280
      #2  0x000055d910ea7cf0 in PROFILING::restart (this=0x151d840047a0) at /test/11.1_opt/sql/sql_profile.cc:348
      #3  0x000055d910d2be1f in THD::free_connection (this=<optimized out>) at /test/11.1_opt/sql/sql_class.cc:1609
      #4  0x000055d910c79906 in unlink_thd (thd=<optimized out>) at /test/11.1_opt/sql/mysqld.cc:2840
      #5  0x000055d910ea4c51 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55d913ad0ee8, put_in_cache=put_in_cache@entry=true) at /test/11.1_opt/sql/sql_connect.cc:1427
      #6  0x000055d910ea511d in handle_one_connection (arg=0x55d913ad0ee8) at /test/11.1_opt/sql/sql_connect.cc:1318
      #7  0x0000151dd3d1f609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #8  0x0000151dd390b133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      11.1.0 17127fd91b763ba7c3f8ecb30190689a06bd9485 (Debug)

      Core was generated by `/test/MD060623-mariadb-11.1.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --cor'.
      Program terminated with signal SIGSEGV, Segmentation fault.
      #0  PROF_MEASUREMENT::~PROF_MEASUREMENT (this=0x1500000000d0, 
          __in_chrg=<optimized out>) at /test/11.1_dbg/sql/sql_profile.cc:184
      [Current thread is 1 (Thread 0x1523a4629700 (LWP 1462658))]
      (gdb) bt
      #0  PROF_MEASUREMENT::~PROF_MEASUREMENT (this=0x1500000000d0, __in_chrg=<optimized out>) at /test/11.1_dbg/sql/sql_profile.cc:184
      #1  0x00005587e0d51da0 in QUERY_PROFILE::~QUERY_PROFILE (this=0x15236c024460, __in_chrg=<optimized out>) at /test/11.1_dbg/sql/sql_profile.h:147
      #2  0x00005587e0d520e2 in PROFILING::restart (this=this@entry=0x15236c004a48) at /test/11.1_dbg/sql/sql_profile.h:147
      #3  0x00005587e0b80bea in THD::free_connection (this=this@entry=0x15236c000d48) at /test/11.1_dbg/sql/sql_class.cc:1609
      #4  0x00005587e0abaf1e in unlink_thd (thd=0x15236c000d48) at /test/11.1_dbg/sql/mysqld.cc:2840
      #5  0x00005587e0d4dcd3 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5587e497c9c8, put_in_cache=put_in_cache@entry=true) at /test/11.1_dbg/sql/sql_connect.cc:1427
      #6  0x00005587e0d4dfd6 in handle_one_connection (arg=0x5587e497c9c8) at /test/11.1_dbg/sql/sql_connect.cc:1318
      #7  0x00001523bd2e0609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #8  0x00001523bcecc133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Bug confirmed present in:
      MariaDB: 10.4.30 (dbg), 10.4.30 (opt), 10.5.21 (dbg), 10.5.21 (opt), 10.6.14 (dbg), 10.6.14 (opt), 10.9.7 (dbg), 10.9.7 (opt), 10.10.5 (dbg), 10.10.5 (opt), 10.11.4 (dbg), 10.11.4 (opt), 11.0.2 (dbg), 11.0.2 (opt), 11.1.0 (dbg), 11.1.0 (opt)

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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