Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-3993

handler.cc:3008: int handler::ha_close(): Assertion `m_lock_type == 2' failed.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: MyRocks
    • Labels:
      None

      Description

      This one took a while to figure out

      Core was generated by `/sda/PS240817-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysqld --no-defau'.Core was generated by `/sda/PS240817-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysqld --no-defau'.Program terminated with signal 6, Aborted.#0  0x00007f57e9f95741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:6161  val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),(gdb) bt#0  0x00007f57e9f95741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61#1  0x0000000001862e06 in my_write_core (sig=6) at /git/PS-5.7.19_dbg/mysys/stacktrace.c:249#2  0x0000000000e8a2af in handle_fatal_signal (sig=6) at /git/PS-5.7.19_dbg/sql/signal_handler.cc:223#3  <signal handler called>#4  0x00007f57e83291d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56#5  0x00007f57e832a8c8 in __GI_abort () at abort.c:90#6  0x00007f57e8322146 in __assert_fail_base (fmt=0x7f57e84733a8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n",     assertion=assertion@entry=0x1dd988f "m_lock_type == 2", file=file@entry=0x1dda1f0 "/git/PS-5.7.19_dbg/sql/handler.cc",     line=line@entry=3008, function=function@entry=0x1ddd5e0 <handler::ha_close()::__PRETTY_FUNCTION__> "int handler::ha_close()")    at assert.c:92#7  0x00007f57e83221f2 in __GI___assert_fail (assertion=0x1dd988f "m_lock_type == 2",     file=0x1dda1f0 "/git/PS-5.7.19_dbg/sql/handler.cc", line=3008,     function=0x1ddd5e0 <handler::ha_close()::__PRETTY_FUNCTION__> "int handler::ha_close()") at assert.c:101#8  0x0000000000f1ba53 in handler::ha_close (this=0x7f577509ea30) at /git/PS-5.7.19_dbg/sql/handler.cc:3008#9  0x0000000001623017 in closefrm (table=0x7f577523d220, free_share=false) at /git/PS-5.7.19_dbg/sql/table.cc:3572#10 0x000000000149efb1 in close_temporary (table=0x7f577523d220, free_share=true, delete_table=true)    at /git/PS-5.7.19_dbg/sql/sql_base.cc:2534#11 0x000000000149dfe2 in close_temporary_tables (thd=0x7f5775012000) at /git/PS-5.7.19_dbg/sql/sql_base.cc:2066#12 0x0000000001793a8c in Start_log_event_v3::do_apply_event (this=0x7f57752e0860, rli=0x7f57751ce000)    at /git/PS-5.7.19_dbg/sql/log_event.cc:5301#13 0x0000000001794762 in Format_description_log_event::do_apply_event (this=0x7f57752e0820, rli=0x7f57751ce000)    at /git/PS-5.7.19_dbg/sql/log_event.cc:5542#14 0x000000000178e02f in Log_event::apply_event (this=0x7f57752e0860, rli=0x7f57751ce000)    at /git/PS-5.7.19_dbg/sql/log_event.cc:3447#15 0x00000000017e12a7 in mysql_client_binlog_statement (thd=0x7f5775012000) at /git/PS-5.7.19_dbg/sql/sql_binlog.cc:275#16 0x0000000001530328 in mysql_execute_command (thd=0x7f5775012000, first_level=true) at /git/PS-5.7.19_dbg/sql/sql_parse.cc:5076#17 0x0000000001532408 in mysql_parse (thd=0x7f5775012000, parser_state=0x7f57ea5864e0) at /git/PS-5.7.19_dbg/sql/sql_parse.cc:5891#18 0x0000000001526fe7 in dispatch_command (thd=0x7f5775012000, com_data=0x7f57ea586c90, command=COM_QUERY)    at /git/PS-5.7.19_dbg/sql/sql_parse.cc:1493#19 0x0000000001525e2d in do_command (thd=0x7f5775012000) at /git/PS-5.7.19_dbg/sql/sql_parse.cc:1021#20 0x000000000166583a in handle_connection (arg=0x7f5775011040)    at /git/PS-5.7.19_dbg/sql/conn_handler/connection_handler_per_thread.cc:312#21 0x00000000018919e5 in pfs_spawn_thread (arg=0x7f57dc7ec520) at /git/PS-5.7.19_dbg/storage/perfschema/pfs.cc:2188#22 0x00007f57e9f90dc5 in start_thread (arg=0x7f57ea587700) at pthread_create.c:308
      #23 0x00007f57e83eb73d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
      
      # Options required: --no-defaults --server-id=0 --plugin-load-add=tokudb=ha_tokudb.so --tokudb-check-jemalloc=0 --log-bin --plugin-load-add=rocksdb=ha_rocksdb.so
      
      CREATE TABLE t1(a INT,b INT,c INT,d INT,KEY(a),KEY(a,b)) ENGINE=InnoDB;
      CREATE TABLE t2(KEY (a))ENGINE=InnoDB SELECT a FROM t1;
      create temporary table t4(f int);
      create table t3(groupid int,goodsid int);
      LOCK TABLES t4 WRITE,t3 WRITE,t2 WRITE;
      BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';

       

        Smart Checklist

          Attachments

          1. current_test
            1 kB
          2. MYR-174.diff
            3 kB
          3. mysqld.1.err
            9 kB

            Activity

              People

              Assignee:
              roel.vandepaar Roel Van de Paar (Inactive)
              Reporter:
              roel.vandepaar Roel Van de Paar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: