[MDEV-18638] Server hangs or Assertion `INTERNAL_SYSCALL_ERRNO (e, __err) != ESRCH || !robust' failed on SHOW CREATE USER under skip-grant-tables Created: 2019-02-18  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Authentication and Privilege System
Affects Version/s: 10.2, 10.3, 10.4
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 0
Labels: None


 Description   
  • start server with skip-grant-tables
  • connect to the server
  • run SHOW CREATE USER

10.4 40b4f9c9

mysqld: ../nptl/pthread_mutex_lock.c:352: __pthread_mutex_lock_full: Assertion `INTERNAL_SYSCALL_ERRNO (e, __err) != ESRCH || !robust' failed.
190219  1:43:47 [ERROR] mysqld got signal 6 ;
 
#5  0x00007ff09c3253fa in abort () from /lib/x86_64-linux-gnu/libc.so.6
#6  0x00007ff09c31ce37 in __assert_fail_base () from /lib/x86_64-linux-gnu/libc.so.6
#7  0x00007ff09c31cee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x00007ff09dff59dd in __pthread_mutex_lock_full (mutex=0x5653131618e0) at ../nptl/pthread_mutex_lock.c:352
#9  0x000056530fc48209 in safe_mutex_lock (mp=0x5653131618e0, my_flags=0, file=0x56530fced3e0 "/data/src/10.2/sql/sql_acl.cc", line=8586) at /data/src/10.2/mysys/thr_mutex.c:248
#10 0x000056530f1ca91c in inline_mysql_mutex_lock (that=0x5653131618e0, src_file=0x56530fced3e0 "/data/src/10.2/sql/sql_acl.cc", src_line=8586) at /data/src/10.2/include/mysql/psi/mysql_thread.h:666
#11 0x000056530f1e1f82 in mysql_show_create_user (thd=0x7ff034000b00, lex_user=0x7ff034010ca0) at /data/src/10.2/sql/sql_acl.cc:8586
#12 0x000056530f272ccc in mysql_execute_command (thd=0x7ff034000b00) at /data/src/10.2/sql/sql_parse.cc:5504
#13 0x000056530f27a351 in mysql_parse (thd=0x7ff034000b00, rawbuf=0x7ff034010c08 "show create user", length=16, parser_state=0x7ff098f91250, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:8018
#14 0x000056530f267c8b in dispatch_command (command=COM_QUERY, thd=0x7ff034000b00, packet=0x7ff034018ef1 "", packet_length=16, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1829
#15 0x000056530f266596 in do_command (thd=0x7ff034000b00) at /data/src/10.2/sql/sql_parse.cc:1379
#16 0x000056530f3b9a3e in do_handle_one_connection (connect=0x565313189aa0) at /data/src/10.2/sql/sql_connect.cc:1336
#17 0x000056530f3b97cb in handle_one_connection (arg=0x565313189aa0) at /data/src/10.2/sql/sql_connect.cc:1242
#18 0x00007ff09dff3494 in start_thread (arg=0x7ff098f92700) at pthread_create.c:333
#19 0x00007ff09c3d993f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Non-debug version can hang instead.


Generated at Thu Feb 08 08:45:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.