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

Assertion `whitelist != nullptr' failed.

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: MyRocks
    • Labels:

      Description

      # mysqld options required for replay: --plugin-load-add=RocksDB=ha_rocksdb.so 
      INSTALL PLUGIN QUERY_RESPONSE_TIME SONAME 'query_responset.so';
      DROP DATABASE test;CREATE DATABASE test;USE test;
      SET SESSION DEFAULT_STORAGE_ENGINE='RocksDB';
      CREATE EVENT ev1 ON SCHEDULE EVERY 1 SECOND DO INSERT INTO t1 VALUES (1);
      SET GLOBAL rocksdb_read_free_rpl_tables=NULL;
      SET @@GLOBAL.event_scheduler=ON;
      CREATE TABLE t1(c1 YEAR);
      # Wait a bit
      SELECT 1; # Shows server is gone

      Leads to:

      2018-05-19T06:33:37.040712Z 0 [Note] /sda/PS280418-percona-server-5.7.21-20-linux-x86_64-debug/bin/mysqld: ready for connections.
      Version: '5.7.21-20-debug' socket: '/sda/PS280418-percona-server-5.7.21-20-linux-x86_64-debug/socket.sock' port: 19264 MySQL Community Server (GPL)
      2018-05-19T06:33:41.078870Z 5 [Note] Event Scheduler: scheduler thread started with id 5
      2018-05-19T06:33:41.080827Z 6 [ERROR] Event Scheduler: [root@localhost][test.ev1] Table 'test.t1' doesn't exist
      2018-05-19T06:33:41.080853Z 6 [Note] Event Scheduler: [root@localhost].[test.ev1] event execution failed.
      mysqld: /git/io_cache_dbg/storage/rocksdb/ha_rocksdb.cc:5613: void myrocks::ha_rocksdb::set_use_read_free_rpl(const char*): Assertion `whitelist != nullptr' failed.
      06:33:42 UTC - mysqld got signal 6 ;
      
      Core was generated by `/sda/PS280418-percona-server-5.7.21-20-linux-x86_64-debug/bin/mysqld --no-defau'.
      Program terminated with signal SIGABRT, Aborted.
      #0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      57	../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory.
      [Current thread is 1 (Thread 0x7ff65ea99700 (LWP 12423))]
      (gdb) bt
      #0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1 0x0000564f13e49da6 in my_write_core (sig=6) at /git/io_cache_dbg/mysys/stacktrace.c:249
      #2 0x0000564f133d0b0d in handle_fatal_signal (sig=6) at /git/io_cache_dbg/sql/signal_handler.cc:223
      #3 <signal handler called>
      #4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
      #5 0x00007ff65cdd0801 in __GI_abort () at abort.c:79
      #6 0x00007ff65cdc039a in __assert_fail_base (fmt=0x7ff65cf477d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", 
      assertion=assertion@entry=0x7ff62094385b "whitelist != nullptr", 
      file=file@entry=0x7ff62093f2f8 "/git/io_cache_dbg/storage/rocksdb/ha_rocksdb.cc", line=line@entry=5613, 
      function=function@entry=0x7ff620948860 <myrocks::ha_rocksdb::set_use_read_free_rpl(char const*)::__PRETTY_FUNCTION__> "void myrocks::ha_rocksdb::set_use_read_free_rpl(const char*)") at assert.c:92
      #7 0x00007ff65cdc0412 in __GI___assert_fail (assertion=0x7ff62094385b "whitelist != nullptr", 
      file=0x7ff62093f2f8 "/git/io_cache_dbg/storage/rocksdb/ha_rocksdb.cc", line=5613, 
      function=0x7ff620948860 <myrocks::ha_rocksdb::set_use_read_free_rpl(char const*)::__PRETTY_FUNCTION__> "void myrocks::ha_rocksdb::set_use_read_free_rpl(const char*)") at assert.c:101
      #8 0x00007ff6202646e0 in myrocks::ha_rocksdb::set_use_read_free_rpl (this=0x7ff5e6880030, whitelist=0x0)
      at /git/io_cache_dbg/storage/rocksdb/ha_rocksdb.cc:5613
      #9 0x00007ff620264d01 in myrocks::ha_rocksdb::open (this=0x7ff5e6880030, name=0x7ff5e69c7500 "./test/t1", mode=2, 
      test_if_locked=2) at /git/io_cache_dbg/storage/rocksdb/ha_rocksdb.cc:5734
      #10 0x0000564f1346804b in handler::ha_open (this=0x7ff5e6880030, table_arg=0x7ff5e681c620, name=0x7ff5e69c7500 "./test/t1", 
      mode=2, test_if_locked=2) at /git/io_cache_dbg/sql/handler.cc:2937
      #11 0x0000564f13be15da in open_table_from_share (thd=0x7ff5e649c000, share=0x7ff5e69c7130, alias=0x7ff5e694ff00 "t1", db_stat=39, 
      prgflag=8, ha_open_flags=0, outparam=0x7ff5e681c620, is_create_table=false) at /git/io_cache_dbg/sql/table.cc:3467
      #12 0x0000564f13a4e266 in open_table (thd=0x7ff5e649c000, table_list=0x7ff5e6941030, ot_ctx=0x7ff65ea96700)
      at /git/io_cache_dbg/sql/sql_base.cc:3560
      #13 0x0000564f13a50fd3 in open_and_process_table (thd=0x7ff5e649c000, lex=0x7ff5e694e990, tables=0x7ff5e6941030, 
      counter=0x7ff5e694ea50, flags=0, prelocking_strategy=0x7ff65ea96788, has_prelocking_list=false, ot_ctx=0x7ff65ea96700)
      at /git/io_cache_dbg/sql/sql_base.cc:5177
      #14 0x0000564f13a52280 in open_tables (thd=0x7ff5e649c000, start=0x7ff65ea96770, counter=0x7ff5e694ea50, flags=0, 
      prelocking_strategy=0x7ff65ea96788) at /git/io_cache_dbg/sql/sql_base.cc:5793
      #15 0x0000564f13a5371a in open_tables_for_query (thd=0x7ff5e649c000, tables=0x7ff5e6941030, flags=0)
      at /git/io_cache_dbg/sql/sql_base.cc:6570
      #16 0x0000564f13d193f0 in Sql_cmd_insert::mysql_insert (this=0x7ff5e694ff08, thd=0x7ff5e649c000, table_list=0x7ff5e6941030)
      at /git/io_cache_dbg/sql/sql_insert.cc:464
      #17 0x0000564f13d21333 in Sql_cmd_insert::execute (this=0x7ff5e694ff08, thd=0x7ff5e649c000)
      at /git/io_cache_dbg/sql/sql_insert.cc:3123
      #18 0x0000564f13adf5b1 in mysql_execute_command (thd=0x7ff5e649c000, first_level=false) at /git/io_cache_dbg/sql/sql_parse.cc:3746
      #19 0x0000564f13a1e9b2 in sp_instr_stmt::exec_core (this=0x7ff5e69415b8, thd=0x7ff5e649c000, nextp=0x7ff65ea97ee0)
      at /git/io_cache_dbg/sql/sp_instr.cc:1058
      #20 0x0000564f13a1d4ef in sp_lex_instr::reset_lex_and_exec_core (this=0x7ff5e69415b8, thd=0x7ff5e649c000, nextp=0x7ff65ea97ee0, 
      open_tables=false) at /git/io_cache_dbg/sql/sp_instr.cc:447
      #21 0x0000564f13a1e050 in sp_lex_instr::validate_lex_and_execute_core (this=0x7ff5e69415b8, thd=0x7ff5e649c000, 
      nextp=0x7ff65ea97ee0, open_tables=false) at /git/io_cache_dbg/sql/sp_instr.cc:749
      #22 0x0000564f13a1e619 in sp_instr_stmt::execute (this=0x7ff5e69415b8, thd=0x7ff5e649c000, nextp=0x7ff65ea97ee0)
      at /git/io_cache_dbg/sql/sp_instr.cc:945
      #23 0x0000564f13a16428 in sp_head::execute (this=0x7ff5e694e030, thd=0x7ff5e649c000, merge_da_on_success=true)
      at /git/io_cache_dbg/sql/sp_head.cc:790
      #24 0x0000564f13a18647 in sp_head::execute_procedure (this=0x7ff5e694e030, thd=0x7ff5e649c000, args=0x7ff65ea98770)
      at /git/io_cache_dbg/sql/sp_head.cc:1526
      #25 0x0000564f13c3554e in Event_job_data::execute (this=0x7ff65ea98b90, thd=0x7ff5e649c000, drop=false)
      at /git/io_cache_dbg/sql/event_data_objects.cc:1444
      #26 0x0000564f13d43d85 in Event_worker_thread::run (this=0x7ff65ea98e47, thd=0x7ff5e649c000, event=0x7ff5e6411190)
      at /git/io_cache_dbg/sql/event_scheduler.cc:338
      #27 0x0000564f13d43ab4 in event_worker_thread (arg=0x7ff5e6411190) at /git/io_cache_dbg/sql/event_scheduler.cc:283
      #28 0x0000564f13e70e1f in pfs_spawn_thread (arg=0x7ff5e64cc220) at /git/io_cache_dbg/storage/perfschema/pfs.cc:2190
      #29 0x00007ff65dacc6db in start_thread (arg=0x7ff65ea99700) at pthread_create.c:463
      #30 0x00007ff65ceb188f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 3 minutes
                    3m