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

LP:802979 - Assertion `table->key_read == 0' in close_thread_table in maria-5.3

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      Repeatable with maria-5.3, maria-5.3-subqueries-wl90. Reproducible even after 609045. Reproducible with all relevant swiches set to OFF.

      assertion:

      mysqld: sql_base.cc:1387: bool close_thread_table(THD*, TABLE**): Assertion `table->key_read == 0' failed.

      #6 0x00000033b58296e6 in __assert_fail () from /lib64/libc.so.6
      #7 0x000000000070012c in close_thread_table (thd=0xcc6f098, table_ptr=0xcc6f150) at sql_base.cc:1387
      #8 0x0000000000700873 in close_open_tables (thd=0xcc6f098) at sql_base.cc:1204
      #9 0x0000000000700d29 in close_thread_tables (thd=0xcc6f098) at sql_base.cc:1362
      #10 0x00000000006ae270 in dispatch_command (command=COM_QUERY, thd=0xcc6f098, packet=0xcceb8c9 "", packet_length=152) at sql_parse.cc:1590
      #11 0x00000000006ae635 in do_command (thd=0xcc6f098) at sql_parse.cc:904
      #12 0x00000000006990eb in handle_one_connection (arg=0xcc6f098) at sql_connect.cc:1178
      #13 0x00000033b600673d in start_thread () from /lib64/libpthread.so.0
      #14 0x00000033b58d40cd in clone () from /lib64/libc.so.6

      optimizer switch in effect:

      index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=off,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=on,mrr_cost_based=off,mrr_sort_keys=on,outer_join_with_cache=off,semijoin_with_cache=off,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on

      test case:

      CREATE TABLE t1 ( f1 int, f2 int , KEY (f1)) ;
      INSERT IGNORE INTO t1 VALUES (1,0),(5,0);

      EXPLAIN
      SELECT *
      FROM t1 AS alias2 JOIN t1 AS alias3 ON alias3.f2
      WHERE alias3.f2 =
      (
      SELECT f2
      FROM t1
      WHERE EXISTS
      (
      SELECT DISTINCT f1
      FROM t1 )
      ) ;

      Attachments

        Activity

          People

            timour Timour Katchaounov (Inactive)
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.