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

mysqld: sql/handler.cc:2692: int handler::ha_index_first(uchar*): Assertion `table_share->tmp_table != NO_TMP_TABLE || m_lock_type != 2' failed. (branch bb-10.2-jan)

    XMLWordPrintable

    Details

      Description

      In InnoDB 5.7 branch bb-10.2-jan commit 3f1b8c9474e351e50a6556675108864d5aac5528

      In tests:

      • handler.innodb
      • main.implicit_commit
      • innodb.innodb_bug13510739

      Example stack:

      Thread 1 (Thread 0x7fa71834c300 (LWP 23713)):
      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
      #1  0x00005562412d7d6c in my_write_core (sig=6) at /home/jan/mysql/10.2/mysys/stacktrace.c:456
      #2  0x0000556240ba47ab in handle_fatal_signal (sig=6) at /home/jan/mysql/10.2/sql/signal_handler.cc:272
      #3  <signal handler called>
      #4  0x00007fa72ee6c418 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
      #5  0x00007fa72ee6e01a in __GI_abort () at abort.c:89
      #6  0x00007fa72ee64bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55624140ad48 "table_share->tmp_table != NO_TMP_TABLE || m_lock_type != 2", file=file@entry=0x556241409e18 "/home/jan/mysql/10.2/sql/handler.cc", line=line@entry=2692, function=function@entry=0x55624140c480 <handler::ha_index_first(unsigned char*)::__PRETTY_FUNCTION__> "int handler::ha_index_first(uchar*)") at assert.c:92
      #7  0x00007fa72ee64c82 in __GI___assert_fail (assertion=0x55624140ad48 "table_share->tmp_table != NO_TMP_TABLE || m_lock_type != 2", file=0x556241409e18 "/home/jan/mysql/10.2/sql/handler.cc", line=2692, function=0x55624140c480 <handler::ha_index_first(unsigned char*)::__PRETTY_FUNCTION__> "int handler::ha_index_first(uchar*)") at assert.c:101
      #8  0x0000556240bab904 in handler::ha_index_first (this=0x7fa6dc0c9178, buf=0x7fa6dc170db8 "\377\217\217\217\217\245\245\245\377\245\245\245\245\245\245\245\330\r\027\334\246\177") at /home/jan/mysql/10.2/sql/handler.cc:2691
      #9  0x0000556240949282 in mysql_ha_read (thd=0x7fa6dc000b00, tables=0x7fa6dc01d018, mode=RFIRST, keyname=0x7fa6dc01d610 "a", key_expr=0x7fa6dc01d6b0, ha_rkey_mode=HA_READ_KEY_EXACT, cond=0x0, select_limit_cnt=1, offset_limit_cnt=0) at /home/jan/mysql/10.2/sql/sql_handler.cc:856
      #10 0x000055624097427e in mysql_execute_command (thd=0x7fa6dc000b00) at /home/jan/mysql/10.2/sql/sql_parse.cc:5379
      #11 0x000055624097a11e in mysql_parse (thd=0x7fa6dc000b00, rawbuf=0x7fa6dc01cea8 "handler ha1 read a first", length=24, parser_state=0x7fa71834b240, is_com_multi=false, is_next_command=false) at /home/jan/mysql/10.2/sql/sql_parse.cc:7742
      #12 0x000055624096ab5d in dispatch_command (command=COM_QUERY, thd=0x7fa6dc000b00, packet=0x7fa6dc1936e1 "", packet_length=24, is_com_multi=false, is_next_command=false) at /home/jan/mysql/10.2/sql/sql_parse.cc:1790
      #13 0x0000556240969acc in do_command (thd=0x7fa6dc000b00) at /home/jan/mysql/10.2/sql/sql_parse.cc:1353
      #14 0x0000556240aa742a in do_handle_one_connection (connect=0x556244a9b630) at /home/jan/mysql/10.2/sql/sql_connect.cc:1354
      #15 0x0000556240aa71b8 in handle_one_connection (arg=0x556244a9b630) at /home/jan/mysql/10.2/sql/sql_connect.cc:1260
      #16 0x0000556240d9fc38 in pfs_spawn_thread (arg=0x5562449eb8d0) at /home/jan/mysql/10.2/storage/perfschema/pfs.cc:1862
      #17 0x00007fa7303706fa in start_thread (arg=0x7fa71834c300) at pthread_create.c:333
      #18 0x00007fa72ef3db5d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              jplindst Jan Lindström
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration