MYSQL GALERA BUG REPORT:mysqld got signal 11 ; Most likely, you have hit a bug

[jack wei]

BUG REPORT

When a mysql user account password expires, when logging in with navicat, navicat prompts to change the password. At this time, entering a new password and submitting it will cause the mysql service to crash.

##################

crash info:

 mysqld got signal 11 ;

Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.

BuildID[sha1]=c3cad835e66a5bae7b7117f436034c93993aa0a9

Thread pointer: 0x7f0f40000b60

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 = 7f1250144bc8 thread_stack 0x100000

/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x560d19cc6c11]

/usr/sbin/mysqld(print_fatal_signal(int)+0x393) [0x560d18ad2d43]

/usr/sbin/mysqld(handle_fatal_signal+0xa5) [0x560d18ad2df5]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x143c0) [0x7f12c292e3c0]

/usr/sbin/mysqld(mysql_execute_command(THD*, bool)+0x326f) [0x560d1895b13f]

/usr/sbin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x530) [0x560d1895e380]

/usr/sbin/mysqld(Query_log_event::do_apply_event(Relay_log_info const*, char const*, unsigned long)+0xa00) [0x560d198ece50]

/usr/sbin/mysqld(Log_event::apply_event(Relay_log_info*)+0x74) [0x560d198e58d4]

/usr/sbin/mysqld(wsrep_apply_events(THD*, Relay_log_info*, void const*, unsigned long)+0x303) [0x560d18b15fe3]

/usr/sbin/mysqld(+0x12ffb17) [0x560d18adcb17]

/usr/sbin/mysqld(Wsrep_high_priority_service::apply_toi(wsrep::ws_meta const&, wsrep::const_buffer const&, wsrep::mutable_buffer&)+0x2f9) [0x560d18ade109]

/usr/sbin/mysqld(wsrep::server_state::on_apply(wsrep::high_priority_service&, wsrep::ws_handle const&, wsrep::ws_meta const&, wsrep::const_buffer const&)+0x1c4) [0x560d1a6ff324]

/usr/sbin/mysqld(+0x2f2f908) [0x560d1a70c908]

/usr/lib/libgalera_smm.so(+0x65a0b) [0x7f12b5bada0b]

/usr/lib/libgalera_smm.so(+0x78d7e) [0x7f12b5bc0d7e]

/usr/lib/libgalera_smm.so(+0x7bbe8) [0x7f12b5bc3be8]

/usr/lib/libgalera_smm.so(+0xadf92) [0x7f12b5bf5f92]

/usr/lib/libgalera_smm.so(+0xae11b) [0x7f12b5bf611b]

/usr/lib/libgalera_smm.so(+0xae31f) [0x7f12b5bf631f]

/usr/lib/libgalera_smm.so(+0x7c5e0) [0x7f12b5bc45e0]

/usr/lib/libgalera_smm.so(+0x51361) [0x7f12b5b99361]

/usr/sbin/mysqld(wsrep::wsrep_provider_v26::run_applier(wsrep::high_priority_service*)+0x12) [0x560d1a70cfd2]

/usr/sbin/mysqld(+0x133d780) [0x560d18b1a780]

/usr/sbin/mysqld(start_wsrep_THD(void*)+0x4fe) [0x560d18af19fe]

/usr/sbin/mysqld(+0x2cbb4bd) [0x560d1a4984bd]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x8609) [0x7f12c2922609]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x43) [0x7f12c2060163]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (7f0f40010bbc): ALTER USER USER() IDENTIFIED BY 'PASSWD'

Connection ID (thread ID): 11

Status: NOT_KILLED

##################

set user password_expired:

 update mysql.user set password_expired='Y' where user='p123tmp01' ;

flush privileges ;

##################

Ubuntu 20.04.4 LTS

/usr/sbin/mysqld  Ver 8.0.39 for Linux on x86_64 (Galera Cluster for MySQL)

[jack wei]

[Colin Charles]

Hi, i tried to repeat this but failed at it. Same configuration. Simpler test case:

CREATE USER 'p123tmp01'@'localhost' IDENTIFIED BY 'initial_password';
GRANT ALL PRIVILEGES ON *.* TO 'p123tmp01'@'localhost';
FLUSH PRIVILEGES;

ALTER USER 'p123tmp01'@'localhost' PASSWORD EXPIRE;

\q

mysql -u p123tmp01 -p

see

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

ALTER USER USER() IDENTIFIED BY 'new_password';

no crash. flush privileges; also no crash. try to reconnect with new password, all is good.

Can you repeat? I tried ubuntu 20.04 + mysql 8.0.39 + wsrep_provider_version is 4.20(rfed86127)   (show status like 'wsrep_provider_version';)

[Jan Lindström]

Hi,

This could be same problem as earlier reported problem with USER() function in https://github.com/codership/mysql-wsrep-bugs/issues/1859

R: Jan