Correct typo in authentication_ldap_simple_ca_path to correct crash of mysqld
General
Escalation
General
Escalation
Description
Environment
None
Activity
Show:

Percona Bot
updated the AFFECTED USER LEVELMarch 6, 2024 at 10:53 AM
None
Internal
Secure Custom Fields for Jira (Security & Permission)
updated the AFFECTED USER LEVELDecember 19, 2023 at 10:02 AM
None
This field doesn't support this UI

Hrvoje Matijakovic
changed the StatusOctober 13, 2020 at 5:13 PM
Pending Release
Done

Kathy Williamson
updated the SummaryOctober 12, 2020 at 1:21 PM
Typo in authentication_ldap_simple_ca_path will crash mysqld
Correct typo in authentication_ldap_simple_ca_path to correct crash of mysqld

Zsolt Parragi
logged 3hOctober 6, 2020 at 4:26 PM

Zsolt Parragi
updated the Time SpentOctober 6, 2020 at 4:26 PM
15m
3h 15m

Zsolt Parragi
changed the StatusOctober 6, 2020 at 4:25 PM
In Progress
Pending Release

Zsolt Parragi
updated the Fix versionsOctober 6, 2020 at 4:25 PM
None
8.0.21-12

Zsolt Parragi
updated the ResolutionOctober 6, 2020 at 4:25 PM
None
Fixed

Zsolt Parragi
changed the StatusOctober 6, 2020 at 4:25 PM
Open
In Progress

Zsolt Parragi
changed the AssigneeOctober 6, 2020 at 4:25 PM
Unassigned

Zsolt Parragi

Zsolt Parragi
updated the Linked IssuesOctober 1, 2020 at 7:41 PM
This issue relates to PSMDB-726
None

Zsolt Parragi
updated the Linked IssuesOctober 1, 2020 at 7:41 PM
None
This issue relates to PSMDB-726

George Lorch
updated the Linked IssuesOctober 1, 2020 at 4:52 PM
None
This issue relates to PS-7357

George Lorch
updated the ComponentsOctober 1, 2020 at 4:49 PM
None
Simple LDAP

Yura Sorokin
logged 15mOctober 1, 2020 at 12:18 PM

Yura Sorokin
updated the Time SpentOctober 1, 2020 at 12:18 PM
0m
15m

Jira Bot
changed the StatusSeptember 29, 2020 at 6:56 PM
New
Open

Michael Coburn
updated the DescriptionSeptember 29, 2020 at 2:51 PM
Making a typo in ca_path will crash {{mysqld}}:
{code:java}
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{code}
Making a typo in ca_path will crash {{mysqld}}:
{code:java}
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{code}
From the client:
{code:java}
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 {code}

Michael Coburn
created the BugSeptember 29, 2020 at 2:49 PM
Done
Details
Details
Assignee
Zsolt Parragi
Zsolt ParragiReporter
Michael Coburn
Michael CoburnTime tracking
3h 15m logged
Components
Fix versions
Affects versions
Priority
Created September 29, 2020 at 2:49 PM
Updated March 6, 2024 at 10:53 AM
Resolved October 6, 2020 at 4:25 PM
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