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

handle_fatal_signal (sig=11) in dict_index_is_auto_gen_clust | sql/signal_handler.cc:223

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 5.7.x, Not 5.5.x, Not 5.6.x
    • Fix Version/s: 5.7.23-24
    • Component/s: None
    • Labels:

      Description

      Startup

      /data/perf/201/Percona-Server-5.7.21-20-Linux.x86_64.ssl101/bin/mysqld --defaults-file=/home/ramesh/toku-qa/bin/my_inno.cnf --user=ramesh --basedir=/data/perf/201/Percona-Server-5.7.21-20-Linux.x86_64.ssl101 --datadir=/data/perf/201/Percona-Server-5.7.21-20-Linux.x86_64.ssl101/data --innodb_buffer_pool_size=10G --port= --pid-file=/data/perf/201/Percona-Server-5.7.21-20-Linux.x86_64.ssl101/data/pid.pid --core-file --socket=/tmp/ps-perf-mysql.sock --log-error=/data/perf/201/Percona-Server-5.7.21-20-Linux.x86_64.ssl101/data/error.log.out &

      Testcase

       sysbench /usr/share/sysbench/oltp_insert.lua --mysql-storage-engine=innodb --rand-type=uniform --threads=2048 --tables=2048 --table-size=100000 --mysql-db=test --mysql-user=root --db-driver=mysql --mysql-socket=/tmp/ps-perf-mysql.sock prepare

      my.cnf

      [mysqld]
      innodb_flush_method = O_DIRECT
      innodb_log_file_size = 2000M
      innodb_log_files_in_group = 2
      innodb_flush_log_at_trx_commit = 1
      innodb_log_buffer_size=128M
      innodb_max_dirty_pages_pct=80
      innodb_read_io_threads = 8
      innodb_write_io_threads = 8
      innodb_io_capacity = 5000
      
      #transaction-isolation=READ-COMMITTED
      #log-bin=mysql-bin
      #server-id=100
      max-prepared-stmt-count=100000000
      sync_binlog=0
      max_connections=5000
      table_open_cache=5000
      table-definition-cache=1000
      query_cache_size=0
      query_cache_type=0
      performance_schema=0
      

      GDB info

      #0 0x00007fb210a7a97c in pthread_kill () from /lib64/libpthread.so.0
      #1 0x000000000079a955 in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.7-binaries-release-rocks/label_exp/centos6-64/percona-server-5.7.21-20/sql/signal_handler.cc:223
      #2 <signal handler called>
      #3 dict_index_is_auto_gen_clust (thd=Unhandled dwarf expression opcode 0xf3
      ) at /mnt/workspace/percona-server-5.7-binaries-release-rocks/label_exp/centos6-64/percona-server-5.7.21-20/storage/innobase/include/dict0dict.ic:319
      #4 innobase_parse_hint_from_comment (thd=Unhandled dwarf expression opcode 0xf3
      ) at /mnt/workspace/percona-server-5.7-binaries-release-rocks/label_exp/centos6-64/percona-server-5.7.21-20/storage/innobase/handler/ha_innodb.cc:12525
      #5 0x0000000000fc2c36 in create_table_info_t::create_table_update_dict (this=0x7fad86a64d90) at /mnt/workspace/percona-server-5.7-binaries-release-rocks/label_exp/centos6-64/percona-server-5.7.21-20/storage/innobase/handler/ha_innodb.cc:13014
      #6 0x0000000000fc5687 in ha_innobase::create (this=Unhandled dwarf expression opcode 0xf3
      ) at /mnt/workspace/percona-server-5.7-binaries-release-rocks/label_exp/centos6-64/percona-server-5.7.21-20/storage/innobase/handler/ha_innodb.cc:13095
      #7 0x00000000008002a4 in ha_create_table (thd=0x7fad7c07bce0, path=Unhandled dwarf expression opcode 0xf3
      ) at /mnt/workspace/percona-server-5.7-binaries-release-rocks/label_exp/centos6-64/percona-server-5.7.21-20/sql/handler.cc:5546
      #8 0x0000000000d566f8 in rea_create_table (thd=0x7fad7c07bce0, path=0x7fad86a67860 "./test/sbtest1667", db=0x7fad7c081078 "test", table_name=0x7fad7c080ab0 "sbtest1667", create_info=0x7fad86a67d20, create_fields=..., keys=1, key_info=0x7fad7c088760, file=0x7fad7c088260, no_ha_table=false) at /mnt/workspace/percona-server-5.7-binaries-release-rocks/label_exp/centos6-64/percona-server-5.7.21-20/sql/unireg.cc:557
      #9 0x0000000000d08b26 in create_table_impl (thd=0x7fad7c07bce0, db=0x7fad7c081078 "test", table_name=0x7fad7c080ab0 "sbtest1667", error_table_name=0x7fad7c080ab0 "sbtest1667", path=0x7fad86a67860 "./test/sbtest1667", create_info=0x7fad86a67d20, alter_info=0x7fad86a67c50, internal_tmp_table=false, select_field_count=0, no_ha_table=false, is_trans=0x7fad86a67ac0, key_info=0x7fad86a67850, key_count=0x7fad86a67840) at /mnt/workspace/percona-server-5.7-binaries-release-rocks/label_exp/centos6-64/percona-server-5.7.21-20/sql/sql_table.cc:5547
      #10 0x0000000000d09184 in mysql_create_table_no_lock (thd=0x7fad7c07bce0, db=0x7fad7c081078 "test", table_name=0x7fad7c080ab0 "sbtest1667", create_info=0x7fad86a67d20, alter_info=0x7fad86a67c50, select_field_count=0, is_trans=0x7fad86a67ac0) at /mnt/workspace/percona-server-5.7-binaries-release-rocks/label_exp/centos6-64/percona-server-5.7.21-20/sql/sql_table.cc:5675
      #11 0x0000000000d092bc in mysql_create_table (thd=0x7fad7c07bce0, create_table=0x7fad7c080af8, create_info=0x7fad86a67d20, alter_info=0x7fad86a67c50) at /mnt/workspace/percona-server-5.7-binaries-release-rocks/label_exp/centos6-64/percona-server-5.7.21-20/sql/sql_table.cc:5723
      #12 0x0000000000ca0723 in mysql_execute_command (thd=0x7fad7c07bce0, first_level=Unhandled dwarf expression opcode 0xf3
      ) at /mnt/workspace/percona-server-5.7-binaries-release-rocks/label_exp/centos6-64/percona-server-5.7.21-20/sql/sql_parse.cc:3429
      #13 0x0000000000ca2b4d in mysql_parse (thd=0x7fad7c07bce0, parser_state=Unhandled dwarf expression opcode 0xf3
      ) at /mnt/workspace/percona-server-5.7-binaries-release-rocks/label_exp/centos6-64/percona-server-5.7.21-20/sql/sql_parse.cc:5901
      #14 0x0000000000ca370d in dispatch_command (thd=0x7fad7c07bce0, com_data=Unhandled dwarf expression opcode 0xf3
      ) at /mnt/workspace/percona-server-5.7-binaries-release-rocks/label_exp/centos6-64/percona-server-5.7.21-20/sql/sql_parse.cc:1490
      #15 0x0000000000ca50e7 in do_command (thd=0x7fad7c07bce0) at /mnt/workspace/percona-server-5.7-binaries-release-rocks/label_exp/centos6-64/percona-server-5.7.21-20/sql/sql_parse.cc:1021
      #16 0x0000000000d6a5a0 in handle_connection (arg=Unhandled dwarf expression opcode 0xf3
      ) at /mnt/workspace/percona-server-5.7-binaries-release-rocks/label_exp/centos6-64/percona-server-5.7.21-20/sql/conn_handler/connection_handler_per_thread.cc:312
      #17 0x0000000000ede204 in pfs_spawn_thread (arg=0x763f2b0) at /mnt/workspace/percona-server-5.7-binaries-release-rocks/label_exp/centos6-64/percona-server-5.7.21-20/storage/perfschema/pfs.cc:2190
      #18 0x00007fb210a75aa1 in start_thread () from /lib64/libpthread.so.0
      #19 0x00007fb20ed6cbcd in clone () from /lib64/libc.so.6
      

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              yura.sorokin Yura Sorokin
              Reporter:
              ramesh.sivaraman Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1 hour, 35 minutes Original Estimate - 1 hour, 35 minutes
                  1h 35m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day, 1 hour, 25 minutes
                  1d 1h 25m