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

Assertion `(&(&share->intern_lock)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&share->intern_lock)->m_mutex)->thread)' failed in _ma_state_info_write or ER_CRASHED_ON_USAGE upon SELECT with UNION

    Details

      Description

      CREATE TABLE t1 (b BLOB, vb BLOB AS (b) VIRTUAL);
      INSERT INTO t1 (b) VALUES ('foobar');
       
      SELECT 'foo' AS f1, CONVERT( 'bar' USING latin1 ) AS f2 FROM t1
        UNION
      SELECT b AS f1, CONVERT( vb USING latin1 ) AS f2 FROM t1
      ;
       
      # Cleanup
      DROP TABLE t1;
      

      10.3 f454189c606b9ce7c401a3493c9b85c72651e220 debug

      2018-10-18  6:32:17 16 [ERROR] mysqld: Table '/home/travis/logs/vardir/tmp/#sql_5632_4' is marked as crashed and should be repaired
      mysqld: /home/travis/src/storage/maria/ma_open.c:1379: _ma_state_info_write: Assertion `(&(&share->intern_lock)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&share->intern_lock)->m_mutex)->thread)' failed.
      181018  6:32:17 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fe48d64cca2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055a86e71f95e in _ma_state_info_write (share=0x55a872307c80, pWrite=1) at /home/travis/src/storage/maria/ma_open.c:1379
      #9  0x000055a86e7643ee in maria_close (info=0x55a872308e80) at /home/travis/src/storage/maria/ma_close.c:148
      #10 0x000055a86e6dac6e in ha_maria::close (this=0x55a8722b9428) at /home/travis/src/storage/maria/ha_maria.cc:1275
      #11 0x000055a86e102eae in handler::ha_close (this=0x55a8722b9428) at /home/travis/src/sql/handler.cc:2751
      #12 0x000055a86e6df288 in ha_maria::drop_table (this=0x55a8722b9428, name=0x55a872307380 "/home/travis/logs/vardir/tmp/#sql_5632_4") at /home/travis/src/storage/maria/ha_maria.cc:2697
      #13 0x000055a86e108194 in handler::ha_drop_table (this=0x55a8722b9428, name=0x55a872307380 "/home/travis/logs/vardir/tmp/#sql_5632_4") at /home/travis/src/sql/handler.cc:4579
      #14 0x000055a86de7933f in free_tmp_table (thd=0x55a871ed1ed0, entry=0x55a872305f38) at /home/travis/src/sql/sql_select.cc:18605
      #15 0x000055a86defc3e2 in st_select_lex_unit::cleanup (this=0x55a871ed5d80) at /home/travis/src/sql/sql_union.cc:1876
      #16 0x000055a86def5bd8 in mysql_union (thd=0x55a871ed1ed0, lex=0x55a871ed5cb8, result=0x55a8722c5ff0, unit=0x55a871ed5d80, setup_tables_done_option=0) at /home/travis/src/sql/sql_union.cc:42
      #17 0x000055a86de452d5 in handle_select (thd=0x55a871ed1ed0, lex=0x55a871ed5cb8, result=0x55a8722c5ff0, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:360
      #18 0x000055a86de0fc5d in execute_sqlcom_select (thd=0x55a871ed1ed0, all_tables=0x55a871ee5028) at /home/travis/src/sql/sql_parse.cc:6547
      #19 0x000055a86de062cf in mysql_execute_command (thd=0x55a871ed1ed0) at /home/travis/src/sql/sql_parse.cc:3769
      #20 0x000055a86de13bea in mysql_parse (thd=0x55a871ed1ed0, rawbuf=0x55a871ee4148 "/* GenTest::Transform::ExecuteAsIntersect */ (  SELECT DISTINCT UpdateXML( '01:10:09.003094', '/bed/dbecbcebaa/decce', NULL ) AS field1, CONVERT( ( IF( `pk`, 'g', `vcol_blob` ) ) USING latin1 ) AS fie"..., length=555, parser_state=0x7fe48c0b9600, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8091
      #21 0x000055a86de00dfa in dispatch_command (command=COM_QUERY, thd=0x55a871ed1ed0, packet=0x55a871edba11 "/* GenTest::Transform::ExecuteAsIntersect */ (  SELECT DISTINCT UpdateXML( '01:10:09.003094', '/bed/dbecbcebaa/decce', NULL ) AS field1, CONVERT( ( IF( `pk`, 'g', `vcol_blob` ) ) USING latin1 ) AS fie"..., packet_length=556, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1850
      #22 0x000055a86ddff82b in do_command (thd=0x55a871ed1ed0) at /home/travis/src/sql/sql_parse.cc:1395
      #23 0x000055a86df6804a in do_handle_one_connection (connect=0x55a871df8df0) at /home/travis/src/sql/sql_connect.cc:1402
      #24 0x000055a86df67dce in handle_one_connection (arg=0x55a871df8df0) at /home/travis/src/sql/sql_connect.cc:1308
      #25 0x00007fe48e20e184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #26 0x00007fe48d71affd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      10.3 3e47b41a16b5e2 non-debug

      mysqltest: At line 4: query 'SELECT 'foo' AS f1, CONVERT( 'bar' USING latin1 ) AS f2 FROM t1
      UNION
      SELECT b AS f1, CONVERT( vb USING latin1 ) AS f2 FROM t1
      ' failed: 1194: Table '/dev/shm/var/tmp/mysqld.1/#sql_2a71_0' is marked as crashed and should be repaired
      

      Also reproducible on previous 10.3 releases.
      Not reproducible on 10.2.

        Attachments

          Activity

            People

            • Assignee:
              monty Michael Widenius
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: