Details

    • Type: Bug
    • Status: On Hold
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: 5.7.23-23, 8.0.12-2rc1
    • Fix Version/s: None
    • Component/s: MyRocks

      Description

      sql

      # mysqld options required for replay: --plugin-load-add=RocksDB=ha_rocksdb.so --max_allowed_packet=33554432 --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY --log_bin=binlog --server-id=0 --binlog_format=ROW --gtid_mode=ON --enforce_gtid_consistency=ON --master_verify_checksum=on --binlog_checksum=CRC32 --tokudb-check-jemalloc=0 --init-file=/home/hrvoje/percona-qa/plugins_57.sql --performance-schema --performance-schema-instrument='%=on' --thread_handling=pool-of-threads --innodb_file_per_table=1 --query-cache-size=1125899906842624 --profiling-history-size=0 --innodb-purge-threads=12 --rocksdb-bytes-per-sync=2
      
      CREATE DATABASE test;
      USE test;
      CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT,KEY (c1)) engine=RocksDB;
      INSERT INTO t1 VALUES(18446744073709551601);
      INSERT INTO t1 VALUES();
      SET @@global.auto_increment_increment=2;
      INSERT INTO t1 VALUES(CONVERT(_ucs2 0x063906440645064A USING utf8));
      SET @@session.auto_increment_increment=DEFAULT;
      INSERT INTO t1 VALUES(),();
      INSERT INTO t1 VALUES(GeomFromText('POINT(305066789 201736238)'));
      INSERT INTO t1 VALUES();
      INSERT INTO t1 VALUES(GeomFromText('POINT(305066789 201736238)'));
      INSERT INTO t1 VALUES(GeomFromText('POINT(305066789 201736238)'));
      INSERT INTO t1 VALUES(GeomFromText('POINT(305066789 201736238)'));
      
      (gdb) bt
      +bt
      #0  0x00007fa9d29199b1 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
      #1  0x0000000001872a64 in my_write_core (sig=6) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/mysys/stacktrace.c:249
      #2  0x0000000000e90acf in handle_fatal_signal (sig=6) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/signal_handler.cc:223
      #3  <signal handler called>
      #4  0x00007fa9d0a251f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
      #5  0x00007fa9d0a268e8 in __GI_abort () at abort.c:90
      #6  0x00007fa9d0a1e266 in __assert_fail_base (fmt=0x7fa9d0b70e68 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x7fa992de9ab0 "last_val > 0", file=file@entry=0x7fa992de4750 "/home/hrvoje/worktable/PS-5.7-trunk_dbg/storage/rocksdb/ha_rocksdb.cc", line=line@entry=10475, function=function@entry=0x7fa992df03a0 <myrocks::ha_rocksdb::get_auto_increment(unsigned long long, unsigned long long, unsigned long long, unsigned long long*, unsigned long long*)::__PRETTY_FUNCTION__> "virtual void myrocks::ha_rocksdb::get_auto_increment(ulonglong, ulonglong, ulonglong, ulonglong*, ulonglong*)") at assert.c:92
      #7  0x00007fa9d0a1e312 in __GI___assert_fail (assertion=0x7fa992de9ab0 "last_val > 0", file=0x7fa992de4750 "/home/hrvoje/worktable/PS-5.7-trunk_dbg/storage/rocksdb/ha_rocksdb.cc", line=10475, function=0x7fa992df03a0 <myrocks::ha_rocksdb::get_auto_increment(unsigned long long, unsigned long long, unsigned long long, unsigned long long*, unsigned long long*)::__PRETTY_FUNCTION__> "virtual void myrocks::ha_rocksdb::get_auto_increment(ulonglong, ulonglong, ulonglong, ulonglong*, ulonglong*)") at assert.c:101
      #8  0x00007fa9927a1551 in myrocks::ha_rocksdb::get_auto_increment (this=0x7fa988454030, off=1, inc=2, nb_desired_values=1, first_value=0x7fa9d2f0eb50, nb_reserved_values=0x7fa9d2f0eb48) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/storage/rocksdb/ha_rocksdb.cc:10475
      #9  0x0000000000f255cb in handler::update_auto_increment (this=0x7fa988454030) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/handler.cc:3886
      #10 0x00007fa992799c0f in myrocks::ha_rocksdb::write_row (this=0x7fa988454030, buf=0x7fa9884cf830 "\377") at /home/hrvoje/worktable/PS-5.7-trunk_dbg/storage/rocksdb/ha_rocksdb.cc:8233
      #11 0x0000000000f2f2e8 in handler::ha_write_row (this=0x7fa988454030, buf=0x7fa9884cf830 "\377") at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/handler.cc:8452
      #12 0x0000000001758b8e in write_record (thd=0x7fa988419000, table=0x7fa98847b220, info=0x7fa9d2f0eec0, update=0x7fa9d2f0ef40) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_insert.cc:1881
      #13 0x0000000001755cf0 in Sql_cmd_insert::mysql_insert (this=0x7fa98842d450, thd=0x7fa988419000, table_list=0x7fa98842cda8) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_insert.cc:773
      #14 0x000000000175c691 in Sql_cmd_insert::execute (this=0x7fa98842d450, thd=0x7fa988419000) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_insert.cc:3123
      #15 0x0000000001536418 in mysql_execute_command (thd=0x7fa988419000, first_level=true) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_parse.cc:3746
      #16 0x000000000153c3bf in mysql_parse (thd=0x7fa988419000, parser_state=0x7fa9d2f10470) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_parse.cc:5901
      #17 0x0000000001530f0f in dispatch_command (thd=0x7fa988419000, com_data=0x7fa9d2f10c50, command=COM_QUERY) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_parse.cc:1490
      #18 0x000000000152fd97 in do_command (thd=0x7fa988419000) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/sql_parse.cc:1021
      #19 0x0000000001670586 in handle_connection (arg=0x7fa9b8a07ac0) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/sql/conn_handler/connection_handler_per_thread.cc:312
      #20 0x000000000189635d in pfs_spawn_thread (arg=0x7fa9ce818e20) at /home/hrvoje/worktable/PS-5.7-trunk_dbg/storage/perfschema/pfs.cc:2190
      #21 0x00007fa9d2914e25 in start_thread (arg=0x7fa9d2f11700) at pthread_create.c:308
      #22 0x00007fa9d0ae834d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
      

      Reproduced on 5.7 trunk (d666728a14ff7349fbb923336bc9977565cbe479)

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                hrvoje.matijakovic Hrvoje Matijakovic
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 6 hours, 15 minutes
                  6h 15m