[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) Created: 2016-08-12  Updated: 2016-09-08  Resolved: 2016-09-07

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2
Fix Version/s: 10.2.2

Type: Bug Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-10024 Fix test failures on InnoDB 5.7 in Ma... Closed

 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


Generated at Thu Feb 08 07:43:05 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.