handle_fatal_signal (sig=11) in replace_user_table | sql/sql_acl.cc:3387

Bug #1384566 reported by Ramesh Sivaraman on 2014-10-23
12
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Undecided
Unassigned
5.1
Won't Fix
Low
Unassigned
5.5
Won't Fix
Low
Unassigned
5.6
Fix Released
Low
Unassigned

Bug Description

**** GDB info

+bt
#0 0x00007f8959310771 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 0x000000000074ed91 in replace_user_table (thd=0x260ed40, table=0x7f8900668e60, combo=0x7f8900005190, rights=0, revoke_grant=false, can_create_user=true, no_auto_create=false) 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:3387
#5 0x000000000075632a in mysql_grant (thd=0x260ed40, db=0x0, list=..., rights=0, revoke_grant=false, is_proxy=false) 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:5557
#6 0x00000000007e789a in mysql_execute_command (thd=0x260ed40) 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:4581
#7 0x00000000007ed193 in mysql_parse (thd=0x260ed40, rawbuf=0x7f89000050a0 "grant usage on *.* to usera@localhost", length=37, parser_state=0x7f8922195e30) 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
#8 0x00000000007df5fc in dispatch_command (command=COM_QUERY, thd=0x260ed40, packet=0x2601121 "grant usage on *.* to usera@localhost;", packet_length=38) 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
#9 0x00000000007de528 in do_command (thd=0x260ed40) 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
#10 0x00000000007a64e5 in do_handle_one_connection (thd_arg=0x260ed40) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1532
#11 0x00000000007a5fed in handle_one_connection (arg=0x260ed40) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.21-69.0/sql/sql_connect.cc:1443
#12 0x0000000000dc5bac in pfs_spawn_thread (arg=0x2dceb90) 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
#13 0x00007f895930bdf3 in start_thread () from /lib64/libpthread.so.0
#14 0x00007f8957fd501d in clone () from /lib64/libc.so.6

*** Crashing query

 grant usage on *.* to usera@localhost

Ramesh Sivaraman (rameshvs02) wrote :
tags: added: qa
Ramesh Sivaraman (rameshvs02) wrote :

Single threaded run, single mysqld involved

description: updated
Ramesh Sivaraman (rameshvs02) wrote :

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

tags: added: upstream
Ramesh Sivaraman (rameshvs02) wrote :

***** Testcase

DROP TABLE mysql.user;
use mysql;
CREATE TABLE user(Host char binary DEFAULT'',User char binary DEFAULT'',Password char collate latin1_bin DEFAULT'',Select_priv enum('','')COLLATE utf8_general_ci DEFAULT'',Insert_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Update_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Delete_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Create_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Drop_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Reload_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Shutdown_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Process_priv enum('','') COLLATE utf8_general_ci DEFAULT'',File_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Grant_priv enum('','') COLLATE utf8_general_ci DEFAULT'',References_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Index_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Alter_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Show_db_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Super_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Create_tmp_t_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Lock_ts_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Execute_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Repl_slave_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Repl_client_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Create_v_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Show_v_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Create_routine_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Alter_routine_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Create_user_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Event_priv enum('','') COLLATE utf8_general_ci DEFAULT'',Trigger_priv enum('','') COLLATE utf8_general_ci DEFAULT'',ssl_type ENUM('','X509','') COLLATE utf8_general_ci DEFAULT'',ssl_cipher BLOB,x509_issuer BLOB,x509_subject BLOB,max_questions int unsigned,max_updates int unsigned,max_connections int unsigned,max_user_connections int unsigned,PRIMARY KEY Host (Host,User)) engine=MyISAM COLLATE utf8_bin comment='Users and global privileges';
grant select on test.* to''@'santa.claus.ipv4.example.com';

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

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Related blueprints

Remote bug watches

Bug watches keep track of this bug in other bug trackers.