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)

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

            jplindst Jan Lindström (Inactive) created issue -
            jplindst Jan Lindström (Inactive) made changes -
            Field Original Value New Value
            jplindst Jan Lindström (Inactive) made changes -
            Description In InnoDB 5.7 branch bb-10.2-jan (please wait for email about status):

            In tests:
            * handler.innodb
            * main.implicit_commit

            Example stack:
            {noformat}
            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
            {noformat}
            In InnoDB 5.7 branch bb-10.2-jan (please wait for email about status):

            In tests:
            * handler.innodb
            * main.implicit_commit
            * innodb.innodb_bug13510739

            Example stack:
            {noformat}
            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
            {noformat}
            jplindst Jan Lindström (Inactive) made changes -
            Description In InnoDB 5.7 branch bb-10.2-jan (please wait for email about status):

            In tests:
            * handler.innodb
            * main.implicit_commit
            * innodb.innodb_bug13510739

            Example stack:
            {noformat}
            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
            {noformat}
            In InnoDB 5.7 branch bb-10.2-jan commit 3f1b8c9474e351e50a6556675108864d5aac5528

            In tests:
            * handler.innodb
            * main.implicit_commit
            * innodb.innodb_bug13510739

            Example stack:
            {noformat}
            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
            {noformat}
            jplindst Jan Lindström (Inactive) made changes -
            Summary mysqld: /home/jan/mysql/10.2/sql/handler.cc:2692: int handler::ha_index_first(uchar*): Assertion `table_share->tmp_table != NO_TMP_TABLE || m_lock_type != 2' failed. mysqld: /home/jan/mysql/10.2/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)
            serg Sergei Golubchik made changes -
            Summary mysqld: /home/jan/mysql/10.2/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) 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)
            serg Sergei Golubchik made changes -
            issue.field.resolutiondate 2016-09-07 16:00:57.0 2016-09-07 16:00:57.281
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2.2 [ 22013 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 76643 ] MariaDB v4 [ 150752 ]

            People

              serg Sergei Golubchik
              jplindst Jan Lindström (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.