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

Correct typo in authentication_ldap_simple_ca_path to correct crash of mysqld

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 8.0.19-10
    • Fix Version/s: 8.0.21-12
    • Component/s: Simple LDAP
    • Labels:
      None

      Description

      Making a typo in ca_path will crash mysqld:

       mysqld: unbind.c:46: ldap_unbind_ext: Assertion `( (ld)->ldc->ldc_options.ldo_valid == 0x2 )' failed.
      2020-09-29T14:18:42.284485Z 115 [Note] [MY-000000] [WSREP] Initiating SST cancellation
      14:18:42 UTC - mysqld got signal 6 ;
      Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
      Thread pointer: 0x7f635c01f150
      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 = 7f63ac072c30 thread_stack 0x46000
      /usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x1fb014d]
      /usr/sbin/mysqld(handle_fatal_signal+0x303) [0x11521f3]
      /lib64/libpthread.so.0(+0xf630) [0x7f643590e630]
      /lib64/libc.so.6(gsignal+0x37) [0x7f64337ad387]
      /lib64/libc.so.6(abort+0x148) [0x7f64337aea78]
      /lib64/libc.so.6(+0x2f1a6) [0x7f64337a61a6]
      /lib64/libc.so.6(+0x2f252) [0x7f64337a6252]
      /lib64/libldap_r-2.4.so.2(ldap_unbind_ext+0x66) [0x7f63a7b6a546]
      /usr/lib64/mysql/plugin/authentication_ldap_simple.so(mysql::plugin::auth_ldap::Connection::connect(std::string const&, std::string const&)+0x107) [0x7f63a7dd6987]
      /usr/lib64/mysql/plugin/authentication_ldap_simple.so(mysql::plugin::auth_ldap::Pool::reconfigure(unsigned long, unsigned long, std::string const&, unsigned short, bool, bool, std::string const&, std::string const&, std::string const&)+0x339) [0x7f63a7dec049]
      /usr/lib64/mysql/plugin/authentication_ldap_simple.so(void update_sysvar<char*>(THD*, SYS_VAR*, void*, void const*)+0x119) [0x7f63a7dc7e89]
      /usr/sbin/mysqld(plugin_var_memalloc_global_update(THD*, SYS_VAR*, char**, char const*)+0x36) [0x103a406]
      /usr/sbin/mysqld(sys_var::update(THD*, set_var*)+0xc3) [0xf36fd3]
      /usr/sbin/mysqld(set_var::update(THD*)+0x2a) [0xf38f7a]
      /usr/sbin/mysqld(sql_set_variables(THD*, List<set_var_base>*, bool)+0xb1) [0xf38a71]
      /usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x3056) [0x100adb6]
      /usr/sbin/mysqld(mysql_parse(THD*, Parser_state*, bool)+0x42f) [0x100eeef]
      /usr/sbin/mysqld() [0x100f52b]
      /usr/sbin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x38d1) [0x1013ba1]
      /usr/sbin/mysqld(do_command(THD*)+0x277) [0x10141c7]
      /usr/sbin/mysqld() [0x1141dc8]
      /usr/sbin/mysqld() [0x24a2709]
      /lib64/libpthread.so.0(+0x7ea5) [0x7f6435906ea5]
      /lib64/libc.so.6(clone+0x6d) [0x7f64338758dd]Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (7f635c5cbef8): SET GLOBAL authentication_ldap_simple_ca_path='/etc/mysql/ca.crt1'
      Connection ID (thread ID): 115
      Status: NOT_KILLED

      From the client:

      mysql> SET GLOBAL authentication_ldap_simple_ca_path='/etc/mysql/ca.crt1';
      ERROR 2013 (HY000): Lost connection to MySQL server during query
      mysql> command terminated with exit code 137 

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              zsolt.parragi Zsolt Parragi
              Reporter:
              michael.coburn@percona.com Michael Coburn
              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 hours, 15 minutes
                  3h 15m

                    Smart Checklist