mysqld got signal 11 ; on SHOW GRANTS | handle_fatal_signal (sig=11) in show_routine_grants

[Roel Van de Paar]

[...more messages in error log...]
2014-10-19 08:42:00 3391 [ERROR] Invalid (old?) table or database name 'mysqltest-1'
21:42:00 UTC - mysqld got signal 11 ;
[...]
Query (7fcc209d0750): SHOW GRANTS FOR 'user2'@'%'
Connection ID (thread ID): 4
Status: NOT_KILLED

Single threaded run, single mysqld involved

Thread 1 (Thread 0x7fcc7309f700 (LWP 3624)):
+bt
#0 0x00007fcc8c52d771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab7586 in my_write_core (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/mysys/stacktrace.c:422
#2 0x000000000072f9ff in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007fcc8b22ddfa in __strcmp_sse42 () from /lib64/libc.so.6
#5 0x000000000075ab85 in show_routine_grants (thd=0x2e05520, lex_user=0x7fcc209d0828, hash=0x1876c80 <func_priv_hash>, type=0xf310f9 "FUNCTION", typelen=8, buff=0x7fcc7309c630 "GRANT CREATE ROUTINE ON `db1`.* TO 'user2'@'%'", buffsize=1024) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_acl.cc:7161
#6 0x000000000075a969 in mysql_show_grants (thd=0x2e05520, lex_user=0x7fcc209d0828) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_acl.cc:7116
#7 0x00000000007e7e62 in mysql_execute_command (thd=0x2e05520) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:4720
#8 0x00000000007ed193 in mysql_parse (thd=0x2e05520, rawbuf=0x7fcc209d0750 "SHOW GRANTS FOR 'user2'@'%'", length=27, parser_state=0x7fcc7309dd50) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:6773
#9 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x2e05520, packet=0x35f4771 "", packet_length=28) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1432
#10 0x00000000007de528 in do_command (thd=0x2e05520) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_parse.cc:1049
#11 0x00000000008c2c30 in threadpool_process_request (thd=0x2e05520) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_common.cc:311
#12 0x00000000008c5572 in handle_event (connection=0x3529290) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_unix.cc:1553
#13 0x00000000008c57a2 in worker_main (param=0x1898400 <all_groups+2048>) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/threadpool_unix.cc:1606
#14 0x0000000000dc5bac in pfs_spawn_thread (arg=0x7fcc20004ba0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/storage/perfschema/pfs.cc:1860
#15 0x00007fcc8c528df3 in start_thread () from /lib64/libpthread.so.0
#16 0x00007fcc8b1f201d in clone () from /lib64/libc.so.6

[Ramesh Sivaraman (rameshvs02)]

This is an upstream bug : http://bugs.mysql.com/bug.php?id=74778

**** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
create procedure p1()update t1 set value='';
GRANT EXECUTE ON PROCEDURE p1 TO user1@localhost IDENTIFIED BY'',user2@localhost IDENTIFIED BY 'secret2';
RENAME TABLE mysql.procs_priv TO procs_priv_backup;
FLUSH PRIVILEGES;
show grants;
FLUSH PRIVILEGES;
show grants;

[Laurynas Biveinis (laurynas-biveinis)]

Assuming that 5.5 is not affected?

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-832