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

Updating auto increment value causes server to "go away" [ZN7myrocks10ha_rocksdb31update_auto_incr_val_from_fieldEv]

    XMLWordPrintable

    Details

      Description

      gdb info

      (gdb) bt
      +bt
      #0  0x00007f9e1b0499b1 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
      #1  0x0000000001871633 in my_write_core (sig=6) at /home/hrvoje/worktable/PS-5.7.21_dbg/mysys/stacktrace.c:249
      #2  0x0000000000e9018f in handle_fatal_signal (sig=6) at /home/hrvoje/worktable/PS-5.7.21_dbg/sql/signal_handler.cc:223
      #3  <signal handler called>
      #4  0x00007f9e191551f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
      #5  0x00007f9e191568e8 in __GI_abort () at abort.c:90
      #6  0x00007f9ddb38ec37 in myrocks::rdb_get_int_col_max_value (field=0x7f9dd14b0868) at /home/hrvoje/worktable/PS-5.7.21_dbg/storage/rocksdb/ha_rocksdb.cc:4389
      #7  0x00007f9ddb38f09c in myrocks::ha_rocksdb::update_auto_incr_val_from_field (this=0x7f9dd1454030) at /home/hrvoje/worktable/PS-5.7.21_dbg/storage/rocksdb/ha_rocksdb.cc:4502
      #8  0x00007f9ddb39bceb in myrocks::ha_rocksdb::update_pk (this=0x7f9dd1454030, kd=..., row_info=..., pk_changed=@0x7f9e1b638b5f: false) at /home/hrvoje/worktable/PS-5.7.21_dbg/storage/rocksdb/ha_rocksdb.cc:8606
      #9  0x00007f9ddb39c4ff in myrocks::ha_rocksdb::update_indexes (this=0x7f9dd1454030, row_info=..., pk_changed=@0x7f9e1b638b5f: false) at /home/hrvoje/worktable/PS-5.7.21_dbg/storage/rocksdb/ha_rocksdb.cc:8735
      #10 0x00007f9ddb39c7c3 in myrocks::ha_rocksdb::update_write_row (this=0x7f9dd1454030, old_data=0x0, new_data=0x7f9dd14b0830 <incomplete sequence \375>, skip_unique_check=false) at /home/hrvoje/worktable/PS-5.7.21_dbg/storage/rocksdb/ha_rocksdb.cc:8807
      #11 0x00007f9ddb39a9bb in myrocks::ha_rocksdb::write_row (this=0x7f9dd1454030, buf=0x7f9dd14b0830 <incomplete sequence \375>) at /home/hrvoje/worktable/PS-5.7.21_dbg/storage/rocksdb/ha_rocksdb.cc:8221
      #12 0x0000000000f2e9a8 in handler::ha_write_row (this=0x7f9dd1454030, buf=0x7f9dd14b0830 <incomplete sequence \375>) at /home/hrvoje/worktable/PS-5.7.21_dbg/sql/handler.cc:8452
      #13 0x0000000001757a92 in write_record (thd=0x7f9dd1419000, table=0x7f9dd147b220, info=0x7f9e1b638ec0, update=0x7f9e1b638f40) at /home/hrvoje/worktable/PS-5.7.21_dbg/sql/sql_insert.cc:1877
      #14 0x0000000001754bf3 in Sql_cmd_insert::mysql_insert (this=0x7f9dd142d1c0, thd=0x7f9dd1419000, table_list=0x7f9dd142cc30) at /home/hrvoje/worktable/PS-5.7.21_dbg/sql/sql_insert.cc:769
      #15 0x000000000175b595 in Sql_cmd_insert::execute (this=0x7f9dd142d1c0, thd=0x7f9dd1419000) at /home/hrvoje/worktable/PS-5.7.21_dbg/sql/sql_insert.cc:3119
      #16 0x000000000153541c in mysql_execute_command (thd=0x7f9dd1419000, first_level=true) at /home/hrvoje/worktable/PS-5.7.21_dbg/sql/sql_parse.cc:3746
      #17 0x000000000153b3c3 in mysql_parse (thd=0x7f9dd1419000, parser_state=0x7f9e1b63a470) at /home/hrvoje/worktable/PS-5.7.21_dbg/sql/sql_parse.cc:5901
      #18 0x000000000152ff13 in dispatch_command (thd=0x7f9dd1419000, com_data=0x7f9e1b63ac50, command=COM_QUERY) at /home/hrvoje/worktable/PS-5.7.21_dbg/sql/sql_parse.cc:1490
      #19 0x000000000152ed9b in do_command (thd=0x7f9dd1419000) at /home/hrvoje/worktable/PS-5.7.21_dbg/sql/sql_parse.cc:1021
      #20 0x000000000166f4c8 in handle_connection (arg=0x7f9e01246850) at /home/hrvoje/worktable/PS-5.7.21_dbg/sql/conn_handler/connection_handler_per_thread.cc:312
      #21 0x000000000191b351 in pfs_spawn_thread (arg=0x7f9e17018d20) at /home/hrvoje/worktable/PS-5.7.21_dbg/storage/perfschema/pfs.cc:2190
      #22 0x00007f9e1b044e25 in start_thread (arg=0x7f9e1b63b700) at pthread_create.c:308
      #23 0x00007f9e1921834d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
      

      Testcase:

      CREATE DATABASE test;
      USE test;
      CREATE TABLE t1(C1 DOUBLE AUTO_INCREMENT KEY,C2 CHAR)ENGINE=RocksDB;
      insert into t1 values(2177,0);
      

      Version (release branch for RM-321):

      Server version: 5.7.21-20-debug MySQL Community Server (GPL)
      

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              george.lorch George Lorch
              Reporter:
              hrvoje.matijakovic Hrvoje Matijakovic
              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 - 4 hours, 3 minutes
                  4h 3m