Assertion `!thd->is_current_stmt_binlog_format_row()' failed | sql/sql_acl.cc:5634
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Undecided
|
Unassigned | |||
5.5 |
New
|
Undecided
|
Unassigned | |||
5.6 |
Triaged
|
High
|
Unassigned | |||
5.7 |
Triaged
|
High
|
Unassigned |
Bug Description
** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
flush tables;
CREATE TEMPORARY TABLE mysql.user (id INT);
grant select on test.* to 'root'@'localhost';
To reproduce the issue we need to run multi thread pquery binary. The attached tarball gives the testcase as an exact match of our system, including some handy utilities
$ vi {epoch}_mybase # Update base path in this file (the only change
required!)
$ ./{epoch}_init # Initializes the data dir
$ ./{epoch}_start # Starts mysqld
$ ./{epoch}_cl # To check mysqld is up
$ ./{epoch}
output)
$ vi /dev/shm/
$ ./{epoch}_gdb # Brings you to a gdb prompt attached to correct
mysqld
& generated core
$ ./{epoch}
standard and full var gdb stack traces
etc.
** Extra start-up parameter
--log-bin=binlog --binlog_
** GDB info
#0 0x00007fae6283d771 in pthread_kill () from /lib64/
#1 0x0000000000ab97ca in my_write_core (sig=6) at /mnt/workspace/
#2 0x00000000007301a3 in handle_fatal_signal (sig=6) at /mnt/workspace/
#3 <signal handler called>
#4 0x00007fae614415c9 in raise () from /lib64/libc.so.6
#5 0x00007fae61442cd8 in abort () from /lib64/libc.so.6
#6 0x00007fae6143a536 in __assert_fail_base () from /lib64/libc.so.6
#7 0x00007fae6143a5e2 in __assert_fail () from /lib64/libc.so.6
#8 0x0000000000756dbd in mysql_grant (thd=0x7fae49ef
#9 0x00000000007e81d8 in mysql_execute_
#10 0x00000000007edf41 in mysql_parse (thd=0x7fae49ef
#11 0x00000000007dfdb7 in dispatch_command (command=COM_QUERY, thd=0x7fae49ef4000, packet=
#12 0x00000000007decd5 in do_command (thd=0x7fae49ef
#13 0x00000000007a6c4d in do_handle_
#14 0x00000000007a6755 in handle_
#15 0x0000000000dc9e6c in pfs_spawn_thread (arg=0x7fae5bf4
#16 0x00007fae62838df3 in start_thread () from /lib64/
#17 0x00007fae615021ad in clone () from /lib64/libc.so.6
Is this an upstream bug?