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

Assertion `table_share->tmp_table != NO_TMP_TABLE || m_lock_type != 2' fails on SELECT .. PARTITION

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.0.4
    • Component/s: None
    • Labels:
      None

      Description

      mysqld:  10.0-monty/sql/handler.cc:2435: int handler::ha_rnd_next(uchar*): Assertion `table_share->tmp_table != NO_TMP_TABLE || m_lock_type != 2' failed.
      130720  1:16:38 [ERROR] mysqld got signal 6 ;

      #6  0x00007f0cd3f550ee in __assert_fail_base (fmt=<optimized out>, assertion=0xf2d888 "table_share->tmp_table != NO_TMP_TABLE || m_lock_type != 2", file=0xf2cd20 " 10.0-monty/sql/handler.cc", line=<optimized out>, function=<optimized out>) at assert.c:94
      #7  0x00007f0cd3f55192 in __GI___assert_fail (assertion=0xf2d888 "table_share->tmp_table != NO_TMP_TABLE || m_lock_type != 2", file=0xf2cd20 " 10.0-monty/sql/handler.cc", line=2435, function=0xf2f540 "int handler::ha_rnd_next(uchar*)") at assert.c:103
      #8  0x00000000007f6ec0 in handler::ha_rnd_next (this=0x7f0cbc0f1ea8, buf=0x7f0cbc1463f8 "\375\t") at  10.0-monty/sql/handler.cc:2434
      #9  0x0000000000d97afc in ha_partition::rnd_next (this=0x7f0cbc145c98, buf=0x7f0cbc1463f8 "\375\t") at  10.0-monty/sql/ha_partition.cc:4785
      #10 0x00000000007f6f68 in handler::ha_rnd_next (this=0x7f0cbc145c98, buf=0x7f0cbc1463f8 "\375\t") at  10.0-monty/sql/handler.cc:2438
      #11 0x000000000091a4a4 in rr_sequential (info=0x7f0cbc02a1e8) at  10.0-monty/sql/records.cc:458
      #12 0x000000000067ed27 in sub_select (join=0x7f0cbc008418, join_tab=0x7f0cbc02a138, end_of_records=false) at  10.0-monty/sql/sql_select.cc:16291
      #13 0x000000000067e52d in do_select (join=0x7f0cbc008418, fields=0x33c34d8, table=0x0, procedure=0x0) at  10.0-monty/sql/sql_select.cc:15942
      #14 0x000000000065ec79 in JOIN::exec_inner (this=0x7f0cbc008418) at  10.0-monty/sql/sql_select.cc:2965
      #15 0x000000000065bfd5 in JOIN::exec (this=0x7f0cbc008418) at  10.0-monty/sql/sql_select.cc:2256
      #16 0x000000000065f516 in mysql_select (thd=0x33c0180, rref_pointer_array=0x33c3628, tables=0x7f0cbc007a60, wild_num=1, fields=..., conds=0x7f0cbc0081e8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f0cbc0083f8, unit=0x33c2ce8, select_lex=0x33c33c8) at  10.0-monty/sql/sql_select.cc:3193
      #17 0x0000000000655ebb in handle_select (thd=0x33c0180, lex=0x33c2c28, result=0x7f0cbc0083f8, setup_tables_done_option=0) at  10.0-monty/sql/sql_select.cc:363
      #18 0x000000000062e5a0 in execute_sqlcom_select (thd=0x33c0180, all_tables=0x7f0cbc007a60) at  10.0-monty/sql/sql_parse.cc:5062
      #19 0x0000000000626ac9 in mysql_execute_command (thd=0x33c0180) at  10.0-monty/sql/sql_parse.cc:2496
      #20 0x0000000000630e3c in mysql_parse (thd=0x33c0180, rawbuf=0x7f0cbc0077f8 "SELECT * FROM t1 PARTITION (p0) WHERE i > 3", length=43, parser_state=0x7f0cd56204e0) at  10.0-monty/sql/sql_parse.cc:6190
      #21 0x0000000000623d7b in dispatch_command (command=COM_QUERY, thd=0x33c0180, packet=0x33c5561 "", packet_length=43) at  10.0-monty/sql/sql_parse.cc:1266
      #22 0x0000000000622efa in do_command (thd=0x33c0180) at  10.0-monty/sql/sql_parse.cc:982
      #23 0x00000000007351aa in do_handle_one_connection (thd_arg=0x33c0180) at  10.0-monty/sql/sql_connect.cc:1379
      #24 0x0000000000734b78 in handle_one_connection (arg=0x33c0180) at  10.0-monty/sql/sql_connect.cc:1293
      #25 0x00000000009aed14 in pfs_spawn_thread (arg=0x32e6060) at  10.0-monty/storage/perfschema/pfs.cc:1853
      #26 0x00007f0cd4d25e9a in start_thread (arg=0x7f0cd5621700) at pthread_create.c:308
      #27 0x00007f0cd4019cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      bzr version-info

      revision-id: sergii@pisem.net-20130717165112-i9klgxk4enpvc09a
      revno: 3637
      branch-nick: 10.0-monty

      Test case:

      --source include/have_partition.inc
       
      CREATE TABLE t1 ( i INT ) ENGINE = MyISAM PARTITION BY HASH (i) PARTITIONS 3;
      INSERT INTO t1 VALUES (9), (8);
      SELECT * FROM t1 PARTITION (p0) WHERE i > 3;

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              igor Igor Babaev
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: