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

handle_fatal_signal (sig=11) in rocksdb::StackableDB::GetEnv

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 8.0
    • Fix Version/s: None
    • Component/s: MyRocks

      Description

      # mysqld options required for replay: --plugin-load-add=RocksDB=ha_rocksdb.so 
      CREATE DATABASE test;
      USE test;
      create table t1(a INT key)engine=RocksDB;
      SELECT * FROM t1 FOR UPDATE;
      UNINSTALL PLUGIN RocksDB;
      create trigger trg before insert on t1 for each row set @a:=new.i;
      

      Leads to;

      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1  0x000055bfc240d997 in my_write_core (sig=sig@entry=11) at stacktrace.cc:278
      #2  0x000055bfc1736975 in handle_fatal_signal (sig=11) at signal_handler.cc:254
      #3  <signal handler called>
      #4  0x00007fe3734859ce in rocksdb::StackableDB::GetEnv (this=0x7fe3a6b03000) at rocksdb/include/rocksdb/utilities/stackable_db.h:263
      #5  rocksdb::PessimisticTransactionDB::UnLock (this=0x7fe3a6b03000, txn=txn@entry=0x7fe339471d00, keys=keys@entry=0x7fe339471e00)
          at rocksdb/utilities/transactions/pessimistic_transaction_db.cc:350
      #6  0x00007fe373485052 in rocksdb::PessimisticTransaction::Clear (this=0x7fe339471d00)
          at rocksdb/utilities/transactions/pessimistic_transaction.cc:100
      #7  0x00007fe3734825a4 in rocksdb::PessimisticTransaction::Rollback (this=0x7fe339471d00)
          at rocksdb/utilities/transactions/pessimistic_transaction.cc:353
      #8  0x00007fe373129856 in myrocks::Rdb_transaction_impl::rollback (this=0x7fe3bb062a80) at ha_rocksdb.cc:2476
      #9  0x00007fe37312dbe3 in myrocks::rocksdb_rollback (hton=<optimized out>, thd=0x7fe339417000, rollback_tx=<optimized out>)
          at ha_rocksdb.cc:3270
      #10 0x000055bfc13b90a7 in ha_rollback_low (thd=thd@entry=0x7fe339417000, all=all@entry=true) at handler.cc:1905
      #11 0x000055bfc2140d52 in MYSQL_BIN_LOG::rollback (this=0x55bfc3d7fbe0 <mysql_bin_log>, thd=0x7fe339417000, all=<optimized out>)
          at binlog.cc:2434
      #12 0x000055bfc13b93f1 in ha_rollback_trans (thd=thd@entry=0x7fe339417000, all=all@entry=true) at handler.cc:1985
      #13 0x000055bfc16ff60a in trans_rollback (thd=thd@entry=0x7fe339417000) at transaction.cc:372
      #14 0x000055bfc16bae40 in Sql_cmd_create_trigger::execute (this=0x7fe3395d3180, thd=0x7fe339417000) at sql_trigger.cc:514
      #15 0x000055bfc160d278 in mysql_execute_command (thd=thd@entry=0x7fe339417000, first_level=first_level@entry=true)
          at sql_parse.cc:4464
      #16 0x000055bfc16110cb in mysql_parse (thd=thd@entry=0x7fe339417000, parser_state=parser_state@entry=0x7fe3bb9b9d30, 
          update_userstat=update_userstat@entry=false, force_primary_storage_engine=force_primary_storage_engine@entry=false)
          at sql_parse.cc:5269
      #17 0x000055bfc1614489 in dispatch_command (thd=thd@entry=0x7fe339417000, com_data=com_data@entry=0x7fe3bb9bac60, command=COM_QUERY)
          at sql_parse.cc:1734
      #18 0x000055bfc1614ff9 in do_command (thd=thd@entry=0x7fe339417000) at sql_parse.cc:1290
      #19 0x000055bfc1728010 in handle_connection (arg=arg@entry=0x7fe3706977f0) at conn_handler/connection_handler_per_thread.cc:317
      #20 0x000055bfc24b95ef in pfs_spawn_thread (arg=0x7fe3b17f8a20) at pfs.cc:2836
      #21 0x00007fe3bd80b6db in start_thread (arg=0x7fe3bb9bb700) at pthread_create.c:463
      #22 0x00007fe3bbadd88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      On optimized. Debug crashes also.
      Looks like another UNINSTALL PLUGIN issue.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                roel.vandepaar Roel Van de Paar (Inactive)
              • 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 - 7 minutes
                  7m