MySQL Bugs: #75947: handle_fatal_signal (sig=11) in replace_user

Bug #75947	handle_fatal_signal (sig=11) in replace_user_table
Submitted:	18 Feb 2015 4:36	Modified:	19 Feb 2015 11:16
Reporter:	Roel Van de Paar	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.7.5-m15	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
2015-02-18T04:29:59.109991Z 0 [Note] /sda/MS-mysql-5.7.5-m15-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.7.5-m15-debug'  socket: '/sda/MS-mysql-5.7.5-m15-linux-x86_64-debug/socket.sock'  port: 11997  MySQL Community Server (GPL)
04:30:08 UTC - mysqld got signal 11 ;

(gdb) bt
#0  0x00007f22e8286771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000e15cd8 in my_write_core (sig=11) at /bzr/testbuild/mysql-5.7.5-m15_dbg/mysys/stacktrace.c:247
#2  0x0000000000822044 in handle_fatal_signal (sig=11) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/signal_handler.cc:219
#3  <signal handler called>
#4  0x00000000008384e0 in replace_user_table (thd=0x7f222c81c000, table=0x7f222c864410, combo=0x7f222c827f50, rights=0, revoke_grant=false, can_create_user=true, no_auto_create=false) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/auth/sql_user_table.cc:602
#5  0x0000000000c9de94 in mysql_table_grant (thd=0x7f222c81c000, table_list=0x7f222c8279b0, user_list=..., columns=..., rights=140523583, revoke_grant=false) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/auth/sql_authorization.cc:1275
#6  0x0000000000b4c375 in mysql_execute_command (thd=0x7f222c81c000) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_parse.cc:4095
#7  0x0000000000b4fcc1 in mysql_parse (thd=0x7f222c81c000, parser_state=0x7f22e887de60) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_parse.cc:5427
#8  0x0000000000b44814 in dispatch_command (command=COM_QUERY, thd=0x7f222c81c000, packet=0x7f222c833011 "GRANT ALL ON mysqltest_1.t1 TO mysqltest_1@'127.0.0.0/255.0.0.0'", packet_length=64) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_parse.cc:1250
#9  0x0000000000b4354d in do_command (thd=0x7f222c81c000) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/sql_parse.cc:834
#10 0x0000000000c4d4ce in handle_connection (arg=0x7f22c9fffee0) at /bzr/testbuild/mysql-5.7.5-m15_dbg/sql/conn_handler/connection_handler_per_thread.cc:298
#11 0x0000000000e394b8 in pfs_spawn_thread (arg=0x7f22ca7f8a50) at /bzr/testbuild/mysql-5.7.5-m15_dbg/storage/perfschema/pfs.cc:2137
#12 0x00007f22e8281df3 in start_thread () from /lib64/libpthread.so.0
#13 0x00007f22e6f4b1ad in clone () from /lib64/libc.so.6

How to repeat:
mysqld option required: --sql_mode=ONLY_FULL_GROUP_BY

Then run mysql client and SOURCE the attached sql file

bug75947.sql

Attachment: bug75947.sql (application/octet-stream, text), 2.25 KiB.

Thank you for the bug report. Repeatable with 5.7.5 but not anymore with recent source server:

Your MySQL connection id is 1
Server version: 5.7.5-m15-debug MySQL Community Server - Debug (GPL)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> source c:/temp/bug75947.sql
ERROR 1008 (HY000): Can't drop database 'transforms'; database doesn't exist
Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.00 sec)

Database changed
Query OK, 0 rows affected, 29 warnings (0.06 sec)

ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
-------------------------------**------------------------------
Your MySQL connection id is 2
Server version: 5.7.6-m16-debug Source distribution 2015/02/09

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
mysql> SELECT @@GLOBAL.sql_mode;
+--------------------+
| @@GLOBAL.sql_mode  |
+--------------------+
| ONLY_FULL_GROUP_BY |
+--------------------+
1 row in set (0.00 sec)

mysql> source c:/temp/bug75947.sql
ERROR 1008 (HY000): Can't drop database 'transforms'; database doesn't exist
Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.02 sec)

Database changed
Query OK, 0 rows affected, 29 warnings (0.04 sec)

ERROR 1054 (42S22): Unknown column 'plugin' in 'mysql.user'
mysql> SHOW VARIABLES LIKE "%VERSION%";
+-------------------------+--------------------------------+
| Variable_name           | Value                          |
+-------------------------+--------------------------------+
| innodb_version          | 5.7.6                          |
| protocol_version        | 10                             |
| slave_type_conversions  |                                |
| version                 | 5.7.6-m16-debug                |
| version_comment         | Source distribution 2015/02/09 |
| version_compile_machine | x86_64                         |
| version_compile_os      | Win64                          |
+-------------------------+--------------------------------+
7 rows in set (0.00 sec)