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

LP #1382749: Assertion `m_lock_type == 2' failed in sql/handler.cc:2753 | abort (sig=6) in handler::ha_close

    Details

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

      Description

      **Reported in Launchpad by Ramesh Sivaraman last update 29-03-2016 10:05:54

                                      • Text case

      CREATE TEMPORARY TABLE t1(c1 BIT);
      ALTER TABLE t1 ENGINE=BLACKHOLE;
      LOCK TABLES t1 WRITE;
      TRUNCATE TABLE t1;

                                      • GDB

      +bt
      #0 0x00007f2b82c74771 in pthread_kill () from /lib64/libpthread.so.0
      #1 0x0000000000ab75b6 in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/stacktrace.c:422
      #2 0x000000000072fa2f in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/signal_handler.cc:236
      #3 <signal handler called>
      #4 0x00007f2b818785c9 in raise () from /lib64/libc.so.6
      #5 0x00007f2b81879cd8 in abort () from /lib64/libc.so.6
      #6 0x00007f2b81871536 in __assert_fail_base () from /lib64/libc.so.6
      #7 0x00007f2b818715e2 in __assert_fail () from /lib64/libc.so.6
      #8 0x000000000064225c in handler::ha_close (this=0x7f2a88caaf10) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/handler.cc:2753
      #9 0x00000000008ab948 in closefrm (table=0x7f2a88d5fa00, free_share=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/table.cc:2468
      #10 0x000000000076f55f in close_temporary (table=0x7f2a88d5fa00, free_share=false, delete_table=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:2248
      #11 0x000000000076f43a in close_temporary_table (thd=0x7f2ad3ea3000, table=0x7f2a88d5fa00, free_share=false, delete_table=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_base.cc:2218
      #12 0x00000000009f8df3 in recreate_temporary_table (thd=0x7f2ad3ea3000, table=0x7f2a88d5fa00) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_truncate.cc:287
      #13 0x00000000009f9302 in Sql_cmd_truncate_table::truncate_table (this=0x7f2a88c1f650, thd=0x7f2ad3ea3000, table_ref=0x7f2a88c1f0e8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_truncate.cc:437
      #14 0x00000000009f95cb in Sql_cmd_truncate_table::execute (this=0x7f2a88c1f650, thd=0x7f2ad3ea3000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_truncate.cc:543
      #15 0x00000000007e9dd3 in mysql_execute_command (thd=0x7f2ad3ea3000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:5411
      #16 0x00000000007ed1c3 in mysql_parse (thd=0x7f2ad3ea3000, rawbuf=0x7f2a88c1f010 "TRUNCATE TABLE t1", length=17, parser_state=0x7f2b83265df0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:6773
      #17 0x00000000007df62c in dispatch_command (command=COM_QUERY, thd=0x7f2ad3ea3000, packet=0x7f2ac3b06001 "TRUNCATE TABLE t1", packet_length=17) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1432
      #18 0x00000000007de558 in do_command (thd=0x7f2ad3ea3000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1049
      #19 0x00000000007a6515 in do_handle_one_connection (thd_arg=0x7f2ad3ea3000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1532
      #20 0x00000000007a601d in handle_one_connection (arg=0x7f2ad3ea3000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1443
      #21 0x0000000000dc5bdc in pfs_spawn_thread (arg=0x7f2b66bbab00) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/perfschema/pfs.cc:1860
      #22 0x00007f2b82c6fdf3 in start_thread () from /lib64/libpthread.so.0
      #23 0x00007f2b8193901d in clone () from /lib64/libc.so.6
      (gdb) +set logging off

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: