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

Unable to install RocksDB engine plugin if server is started with --loose-rocksdb_persistent_cache_size_mb

Details

    • Yes
    • Yes

    Description

      Start the server:

      ./bin/mysqld --no-defaults --datadir=`pwd`/data_80 --port=22000 --socket=/tmp/mysql_22000.sock --max-connections=1024 --log-error --general-log --log-error-verbosity=3 --core-file --loose-rocksdb_persistent_cache_size_mb=12 &

      Try to install RocksDb engine

      ./bin/ps-admin --enable-rocksdb -uroot -S/tmp/mysql_22000.sock

      The server will crash

      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000055592f296dad in my_write_core (sig=6) at /home/mohit.joshi/mysql-8.0/mysys/stacktrace.cc:409
      #2  0x000055592dddc3bd in handle_fatal_signal (sig=6) at /home/mohit.joshi/mysql-8.0/sql/signal_handler.cc:194
      #3  <signal handler called>
      #4  __GI_raise ([email protected]=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x00007f2feb4cc859 in __GI_abort () at abort.c:79
      #6  0x00007f2feb4cc729 in __assert_fail_base (fmt=0x7f2feb662588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", 
          assertion=0x7f2f4dbdea6a "status.ok()", 
          file=0x7f2f4dbdea00 "/home/mohit.joshi/mysql-8.0/storage/rocksdb/rocksdb/utilities/persistent_cache/block_cache_tier.cc", line=33, 
          function=<optimized out>) at assert.c:92
      #7  0x00007f2feb4ddf36 in __GI___assert_fail (assertion=0x7f2f4dbdea6a "status.ok()", 
          file=0x7f2f4dbdea00 "/home/mohit.joshi/mysql-8.0/storage/rocksdb/rocksdb/utilities/persistent_cache/block_cache_tier.cc", line=33, 
          function=0x7f2f4dbde9c8 "virtual rocksdb::Status rocksdb::BlockCacheTier::Open()") at assert.c:101
      #8  0x00007f2f4d831a51 in rocksdb::BlockCacheTier::Open (this=0x7f2f201d3fc0)
          at /home/mohit.joshi/mysql-8.0/storage/rocksdb/rocksdb/utilities/persistent_cache/block_cache_tier.cc:33
      #9  0x00007f2f4d8346d7 in rocksdb::NewPersistentCache (env=0x7f2f4dfd5800 <rocksdb::Env::Default()::default_env>, path="", size=12582912, 
          log=std::shared_ptr<class rocksdb::Logger> (use count 6, weak count 0) = {...}, optimized_for_nvm=true, cache=0x7f2fdc507ee0)
          at /home/mohit.joshi/mysql-8.0/storage/rocksdb/rocksdb/utilities/persistent_cache/block_cache_tier.cc:413
      #10 0x00007f2f4d8ee00a in myrocks::rocksdb_init_internal (p=0x7f2f20165890) at /home/mohit.joshi/mysql-8.0/storage/rocksdb/ha_rocksdb.cc:5693
      #11 0x00007f2f4d8f11a6 in myrocks::rocksdb_init_func (p=0x7f2f20165890) at /home/mohit.joshi/mysql-8.0/storage/rocksdb/ha_rocksdb.cc:6120
      #12 0x000055592d6f7017 in ha_initialize_handlerton (plugin=0x7f2f20127c50) at /home/mohit.joshi/mysql-8.0/sql/handler.cc:801
      #13 0x000055592dbd7791 in plugin_initialize (plugin=0x7f2f20127c50) at /home/mohit.joshi/mysql-8.0/sql/sql_plugin.cc:1288
      #14 0x000055592dbdb712 in mysql_install_plugin (thd=0x7f2f20010ff0, name=..., dl=0x7f2f200274b8)
          at /home/mohit.joshi/mysql-8.0/sql/sql_plugin.cc:2373
      #15 0x000055592dbe0956 in Sql_cmd_install_plugin::execute (this=0x7f2f20027488, thd=0x7f2f20010ff0)
          at /home/mohit.joshi/mysql-8.0/sql/sql_plugin.cc:3746
      #16 0x000055592dba738c in mysql_execute_command (thd=0x7f2f20010ff0, first_level=true) at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:4697
      #17 0x000055592dba952a in dispatch_sql_command (thd=0x7f2f20010ff0, parser_state=0x7f2fdc50aaa0, update_userstat=false)
          at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:5302
      #18 0x000055592db9ea86 in dispatch_command (thd=0x7f2f20010ff0, com_data=0x7f2fdc50bb70, command=COM_QUERY)
          at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:1956
      #19 0x000055592db9cdf8 in do_command (thd=0x7f2f20010ff0) at /home/mohit.joshi/mysql-8.0/sql/sql_parse.cc:1404
      #20 0x000055592ddc3654 in handle_connection (arg=0x555936a8e2f0)
          at /home/mohit.joshi/mysql-8.0/sql/conn_handler/connection_handler_per_thread.cc:307
      #21 0x000055592fb2961e in pfs_spawn_thread (arg=0x555936da4020) at /home/mohit.joshi/mysql-8.0/storage/perfschema/pfs.cc:2899
      #22 0x00007f2feb6a2609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #23 0x00007f2feb5c9293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      On 5.7, the server crashes during start.

      /home/mohit.joshi/mysql-5.7/storage/rocksdb/rocksdb/utilities/persistent_cache/block_cache_tier.cc:33: virtual rocksdb::Status rocksdb::BlockCacheTier::Open(): Assertion `status.ok()' failed.

      Attachments

        Issue Links

          Activity

            People

              marcelo.altmann Marcelo Altmann
              mohit.joshi Mohit Joshi
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 1 hour, 46 minutes Original Estimate - 1 hour, 46 minutes
                  1h 46m
                  Remaining:
                  Time Spent - 6 hours, 3 minutes Remaining Estimate - 27 minutes
                  27m
                  Logged:
                  Time Spent - 6 hours, 3 minutes Remaining Estimate - 27 minutes
                  6h 3m

                  Smart Checklist