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

mysqld got signal 6 if you try to enable encrypt_binlog + binary log without keyring-file plugin

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.7.21-20
    • Component/s: None

      Description

      Hi,
      Here is the result of enabling encrypt_binlog and binary logging without enabling Keyring plugin:

      [shahriyar.rzaev@qaserver-02 PS301217-5.7.20-18-linux-x86_64-debug]$ ./all_no_cl --innodb_page_size=64K --encrypt_binlog=ON --master_verify_checksum=ON --binlog_checksum=CRC32 --log-bin=mysql-bin --log-slave-updates --gtid-mode=ON --enforce-gtid-consistency --binlog-format=row --server-id=1111
      2017-12-31T08:56:53.723556Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
      2017-12-31T08:56:53.757161Z 0 [Warning] InnoDB: innodb-page-size has been changed from the default value 16384 to 65536.
      2017-12-31T08:56:56.298638Z 0 [Warning] InnoDB: New log files created, LSN=130886
      2017-12-31T08:56:56.964404Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
      2017-12-31T08:56:57.258584Z 0 [ERROR] Failed to fetch percona_binlog key from keyring and thus failed to initialize binlog encryption.
      2017-12-31T08:56:57.258656Z 0 [ERROR] Either disk is full or file system is read only while opening the binlog. Aborting the server.
      08:56:57 UTC - mysqld got signal 6 ;
      /home/shahriyar.rzaev/XB_TEST/binlog_enc/PS301217-5.7.20-18-linux-x86_64-debug/bin/mysqld(my_print_stacktrace+0x35)[0x186c2b2]
      /home/shahriyar.rzaev/XB_TEST/binlog_enc/PS301217-5.7.20-18-linux-x86_64-debug/bin/mysqld(handle_fatal_signal+0x411)[0xe8eb32]
      /usr/lib64/libpthread.so.0(+0xf130)[0x7ff0d257c130]
      /usr/lib64/libc.so.6(gsignal+0x37)[0x7ff0d07015d7]
      /usr/lib64/libc.so.6(abort+0x148)[0x7ff0d0702cc8]
      /home/shahriyar.rzaev/XB_TEST/binlog_enc/PS301217-5.7.20-18-linux-x86_64-debug/bin/mysqld[0x17c92ba]
      /home/shahriyar.rzaev/XB_TEST/binlog_enc/PS301217-5.7.20-18-linux-x86_64-debug/bin/mysqld(_ZN13MYSQL_BIN_LOG11open_binlogEPKcS1_mbbbP28Format_description_log_event+0xe78)[0x17d1558]
      /home/shahriyar.rzaev/XB_TEST/binlog_enc/PS301217-5.7.20-18-linux-x86_64-debug/bin/mysqld[0xe7e2fa]
      /home/shahriyar.rzaev/XB_TEST/binlog_enc/PS301217-5.7.20-18-linux-x86_64-debug/bin/mysqld(_Z11mysqld_mainiPPc+0x82c)[0xe7eff6]
      /home/shahriyar.rzaev/XB_TEST/binlog_enc/PS301217-5.7.20-18-linux-x86_64-debug/bin/mysqld(main+0x20)[0xe7631d]
      /usr/lib64/libc.so.6(__libc_start_main+0xf5)[0x7ff0d06edaf5]
      /home/shahriyar.rzaev/XB_TEST/binlog_enc/PS301217-5.7.20-18-linux-x86_64-debug/bin/mysqld[0xe76239]
      
      (gdb) bt
      +bt
      #0  0x00007f3d33b12771 in pthread_kill () from /usr/lib64/libpthread.so.0
      #1  0x000000000186c339 in my_write_core (sig=6) at /home/shahriyar.rzaev/XB_TEST/binary_log_encryption_tests/PS-5.7_dbg/mysys/stacktrace.c:249
      #2  0x0000000000e8ed29 in handle_fatal_signal (sig=6) at /home/shahriyar.rzaev/XB_TEST/binary_log_encryption_tests/PS-5.7_dbg/sql/signal_handler.cc:223
      #3  <signal handler called>
      #4  0x00007f3d31c9a5d7 in raise () from /usr/lib64/libc.so.6
      #5  0x00007f3d31c9bcc8 in abort () from /usr/lib64/libc.so.6
      #6  0x00000000017c92ba in exec_binlog_error_action_abort (err_string=0x2196cb0 "Either disk is full or file system is read only while opening the binlog. Aborting the server.") at /home/shahriyar.rzaev/XB_TEST/binary_log_encryption_tests/PS-5.7_dbg/sql/binlog.cc:1985
      #7  0x00000000017d1558 in MYSQL_BIN_LOG::open_binlog (this=0x2d1c0c0 <mysql_bin_log>, log_name=0x7f3d2ffff0c0 "mysql-bin", new_name=0x0, max_size_arg=1073741824, null_created_arg=false, need_lock_index=true, need_sid_lock=true, extra_description_event=0x0) at /home/shahriyar.rzaev/XB_TEST/binary_log_encryption_tests/PS-5.7_dbg/sql/binlog.cc:5311
      #8  0x0000000000e7e2fa in init_server_components () at /home/shahriyar.rzaev/XB_TEST/binary_log_encryption_tests/PS-5.7_dbg/sql/mysqld.cc:4533
      #9  0x0000000000e7eff6 in mysqld_main (argc=23, argv=0x7f3d2fc1e900) at /home/shahriyar.rzaev/XB_TEST/binary_log_encryption_tests/PS-5.7_dbg/sql/mysqld.cc:5011
      #10 0x0000000000e7631d in main (argc=23, argv=0x7fff75ff4808) at /home/shahriyar.rzaev/XB_TEST/binary_log_encryption_tests/PS-5.7_dbg/sql/main.cc:25
      

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              robert.golebiowski Robert Golebiowski (Inactive)
              Reporter:
              shahriyar.rzayev Shahriyar Rzayev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: