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

handle_fatal_signal (sig=11) in ha_tokudb::write_row

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Pending Release
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 8.0.12-2rc1, 5.7.23-24
    • Fix Version/s: 8.0.NEXT, 5.7.24-26
    • Component/s: TokuDB
    • Labels:

      Description

      # mysqld options required for replay: --plugin-load=TokuDB=ha_tokudb.so --sql_mode= 
      CREATE DATABASE test;
      USE test;
      CREATE TEMPORARY TABLE t1(a INT AUTO_INCREMENT,PRIMARY KEY(a)) ENGINE=TokuDB;
      INSERT INTO t1 VALUES(0xF0908080);
      DELETE FROM t1;
      INSERT IGNORE INTO t1 VALUES(),(),(); 

      Leads to:

      Version: '5.7.23-24-debug'  socket: '/sda/PS201118-percona-server-5.7.23-24-linux-x86_64-debug/socket.sock'  port: 13193  MySQL Community Server (GPL)
      22:30:10 UTC - mysqld got signal 11 ;
      
      5.7.23>INSERT IGNORE INTO t1 VALUES(),(),(); 
      ERROR 2013 (HY000): Lost connection to MySQL server during query
      
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1  0x000055ffaba98940 in my_write_core (sig=11) at /git/ps-5.7-5049_dbg/mysys/stacktrace.c:249
      #2  0x000055ffab7eb213 in handle_fatal_signal (sig=11) at /git/ps-5.7-5049_dbg/sql/signal_handler.cc:223
      #3  <signal handler called>
      ^[[A^[[A^[[A^[[A^[[A^[[A
      #4  0x00007f0be20389dd in abort_txn (txn=0x0) at /git/ps-5.7-5049_dbg/storage/tokudb/tokudb_txn.h:145
      ^[[A^[[A^[[A
      #5  0x00007f0be2006feb in ha_tokudb::write_row (this=0x7f0baf4c5030, record=0x7f0baf4b1830 "\377")
          at /git/ps-5.7-5049_dbg/storage/tokudb/ha_tokudb.cc:4087
      ^[[A^[[A^[[A
      #6  0x000055ffab02036a in handler::ha_write_row (this=0x7f0baf4c5030, buf=0x7f0baf4b1830 "\377")  at /git/ps-5.7-5049_dbg/sql/handler.cc:8523
      #7  0x000055ffab956e74 in write_record (thd=0x7f0baf419000, table=0x7f0baf5fae20, info=0x7f0c20da9fa0, update=0x7f0c20daa020)
          at /git/ps-5.7-5049_dbg/sql/sql_insert.cc:1881
      #8  0x000055ffab953ca6 in Sql_cmd_insert::mysql_insert (this=0x7f0baf4280c8, thd=0x7f0baf419000, table_list=0x7f0baf427b38)
          at /git/ps-5.7-5049_dbg/sql/sql_insert.cc:773
      #9  0x000055ffab95adaf in Sql_cmd_insert::execute (this=0x7f0baf4280c8, thd=0x7f0baf419000)
          at /git/ps-5.7-5049_dbg/sql/sql_insert.cc:3120
      #10 0x000055ffab687bcd in mysql_execute_command (thd=0x7f0baf419000, first_level=true) at /git/ps-5.7-5049_dbg/sql/sql_parse.cc:3796
      #11 0x000055ffab68dfed in mysql_parse (thd=0x7f0baf419000, parser_state=0x7f0c20dab460, update_userstat=false)
          at /git/ps-5.7-5049_dbg/sql/sql_parse.cc:5880
      #12 0x000055ffab6822a9 in dispatch_command (thd=0x7f0baf419000, com_data=0x7f0c20dabd80, command=COM_QUERY)
          at /git/ps-5.7-5049_dbg/sql/sql_parse.cc:1528
      #13 0x000055ffab681034 in do_command (thd=0x7f0baf419000) at /git/ps-5.7-5049_dbg/sql/sql_parse.cc:1053
      #14 0x000055ffab7c59cf in handle_connection (arg=0x7f0be1712f70)
          at /git/ps-5.7-5049_dbg/sql/conn_handler/connection_handler_per_thread.cc:312
      #15 0x000055ffababe822 in pfs_spawn_thread (arg=0x7f0c13fb7f20) at /git/ps-5.7-5049_dbg/storage/perfschema/pfs.cc:2190
      #16 0x00007f0c207c16db in start_thread (arg=0x7f0c20dac700) at pthread_create.c:463
      #17 0x00007f0c1e85b88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 

      In 5.7.21 it gives:

      5.7.21>INSERT IGNORE INTO t1 VALUES(),(),(); 
      ERROR 1467 (HY000): Failed to read auto-increment value from storage engine

       Also in 5.7 trunk (not George's tree), it gives the same error as per George. George's tree which produces this crash (i.e. the new 23-25 release);

      rm -Rf ps-5.7-5049; git clone --recursive --depth=1 https://github.com/georgelorchpercona/percona-server.git -b ps-5.7-5049 ps-5.7-5049

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                george.lorch George Lorch
                Reporter:
                roel.vandepaar Roel Van de Paar
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours, 35 minutes
                  2h 35m