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

[PS8QA] PS crashes with keyring_vault encryption

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Blocker
    • Resolution: Invalid
    • Affects Version/s: 8.0
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:

      CentOS7.5

      Description

      1. Create PS8.0.12 debug build from latest PS branch

      2. Start mysql server with following options

       

      /home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/bin/mysqld --innodb_buffer_pool_size=2G --innodb_log_file_size=2G --innodb_page_size=16K --early-plugin-load=keyring_vault=keyring_vault.so --keyring_vault_config=/home/mchawla/test_mode/vault/keyring_vault.cnf --log-bin=mysql-bin --log-slave-updates --server-id=1 --gtid-mode=ON --enforce-gtid-consistency --binlog-format=row --encrypt_binlog=ON --master_verify_checksum=ON --binlog_checksum=CRC32 --innodb_encrypt_tables=ON --innodb_encrypt_online_alter_logs=ON --innodb_temp_tablespace_encrypt=ON --core-file --basedir=/home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug --tmpdir=/home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/data --datadir=/home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/data --plugin-load-add=tokudb=ha_tokudb.so --tokudb-check-jemalloc=0 --plugin-load-add=rocksdb=ha_rocksdb.so --socket=/home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/socket.sock --port=12301 --log-error=/home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/log/master.err 2>&1 &
      

       

      3. The mysql server crashes. The master.err log displays the following:

      2018-09-07T08:40:58.062883Z 0 [System] [MY-010116] [Server] /home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/bin/mysqld (mysqld 8.0.12-1-debug) starting as process 1701
      08:40:58 UTC - mysqld got signal 11 ;
      This could be because you hit a bug. It is also possible that this binary
      or one of the libraries it was linked against is corrupt, improperly built,
      or misconfigured. This error can also be caused by malfunctioning hardware.
      Attempting to collect some information that could help diagnose the problem.
      As this is a crash and something is definitely wrong, the information
      collection process might fail.
      Please help us make Percona Server better by reporting any
      bugs at http://bugs.percona.com/
      
      key_buffer_size=8388608
      read_buffer_size=131072
      max_used_connections=0
      max_threads=152
      thread_count=0
      connection_count=0
      It is possible that mysqld could use up to
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 804172555 K bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.
      
      Thread pointer: 0x0
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0 thread_stack 0x46000
      /home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/bin/mysqld(my_print_stacktrace(unsigned char*, unsigned long)+0x43) [0x3df8e64]
      /home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/bin/mysqld(handle_fatal_signal+0x410) [0x2c5d5f3]
      /usr/lib64/libpthread.so.0(+0xf6d0) [0x7f89226416d0]
      /home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/lib/mysql/plugin/keyring_vault.so(+0x26c3c) [0x7f890c868c3c]
      /home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/lib/mysql/plugin/keyring_vault.so(+0x25a72) [0x7f890c867a72]
      /home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/bin/mysqld() [0x2ae700d]
      /home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/bin/mysqld() [0x2ae7611]
      /home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/bin/mysqld(plugin_register_early_plugins(int*, char**, int)+0x14b) [0x2ae78a5]
      /home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/bin/mysqld() [0x296739b]
      /home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/bin/mysqld(mysqld_main(int, char**)+0x1815) [0x296b67b]
      /home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/bin/mysqld(main+0x20) [0x2959f4d]
      /usr/lib64/libc.so.6(__libc_start_main+0xf5) [0x7f892072e445]
      /home/mchawla/PS050918-percona-server-8.0.12-1-linux-x86_64-debug/bin/mysqld() [0x2959e69]
      You may download the Percona Server operations manual by visiting
      http://www.percona.com/software/percona-server/. You may find information
      in the manual which will help you identify the cause of the crash.
      Writing a core file

       

      4. Core backtrace

      #0 0x00007f892263ea01 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
      #1 0x0000000003df8f27 in my_write_core (sig=11) at /home/mchawla/PS-8.0.12_dbg/mysys/stacktrace.cc:278
      #2 0x0000000002c5d7e5 in handle_fatal_signal (sig=11) at /home/mchawla/PS-8.0.12_dbg/sql/signal_handler.cc:254
      #3 <signal handler called>
      #4 0x00007f890c868c3c in init_logging_service_for_plugin (reg_srv=0x7f890ca81960 <reg_srv>, log_bi=0x7f890ca81940 <log_bi>, log_bs=0x7f890ca81948 <log_bs>) at /home/mchawla/PS-8.0.12_dbg/include/mysql/components/services/log_builtins.h:1359
      #5 0x00007f890c867a72 in keyring_vault_init (plugin_info=0x856bd80) at /home/mchawla/PS-8.0.12_dbg/plugin/keyring_vault/vault_keyring.cc:124
      #6 0x0000000002ae700d in plugin_initialize (plugin=0x856bd80) at /home/mchawla/PS-8.0.12_dbg/sql/sql_plugin.cc:1218
      #7 0x0000000002ae7611 in plugin_init_initialize_and_reap () at /home/mchawla/PS-8.0.12_dbg/sql/sql_plugin.cc:1358
      #8 0x0000000002ae78a5 in plugin_register_early_plugins (argc=0x640def0 <remaining_argc>, argv=0x8430470, flags=0) at /home/mchawla/PS-8.0.12_dbg/sql/sql_plugin.cc:1418
      #9 0x000000000296739b in init_server_components () at /home/mchawla/PS-8.0.12_dbg/sql/mysqld.cc:5245
      #10 0x000000000296b67b in mysqld_main (argc=29, argv=0x8430470) at /home/mchawla/PS-8.0.12_dbg/sql/mysqld.cc:6183
      #11 0x0000000002959f4d in main (argc=28, argv=0x7fff44fa2198) at /home/mchawla/PS-8.0.12_dbg/sql/main.cc:30
      

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                robert.golebiowski Robert Golebiowski
                Reporter:
                manish.chawla Manish Chawla
              • Votes:
                0 Vote for this issue
                Watchers:
                7 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 - 6 hours, 21 minutes
                  6h 21m