Assertion `!thd->is_current_stmt_binlog_format_row()' failed | sql/sql_acl.cc:5634

[Ramesh Sivaraman]

** 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}_run_pquery # Run the testcase with pquery binary(produces
output)
$ vi /dev/shm/{epoch}/error.log.out # Verify the error log
$ ./{epoch}_gdb # Brings you to a gdb prompt attached to correct
mysqld
& generated core
$ ./{epoch}_parse_core # Create {epoch}_STD.gdb and {epoch}_FULL.gdb;
standard and full var gdb stack traces
etc.

** Extra start-up parameter

 --log-bin=binlog --binlog_format=MIXED

** GDB info

#0 0x00007fae6283d771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab97ca in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/mysys/stacktrace.c:422
#2 0x00000000007301a3 in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/signal_handler.cc:236
#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=0x7fae49ef4000, db=0x7fae3fc1f0e8 "test", list=..., rights=1, revoke_grant=false, is_proxy=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_acl.cc:5634
#9 0x00000000007e81d8 in mysql_execute_command (thd=0x7fae49ef4000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:4615
#10 0x00000000007edf41 in mysql_parse (thd=0x7fae49ef4000, rawbuf=0x7fae3fc1f010 "grant select on test.* to 'root'@'localhost'", length=44, parser_state=0x7fae62cefdf0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:6922
#11 0x00000000007dfdb7 in dispatch_command (command=COM_QUERY, thd=0x7fae49ef4000, packet=0x7fae49ef8001 "grant select on test.* to 'root'@'localhost'; ", packet_length=46) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:1434
#12 0x00000000007decd5 in do_command (thd=0x7fae49ef4000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:1051
#13 0x00000000007a6c4d in do_handle_one_connection (thd_arg=0x7fae49ef4000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_connect.cc:1532
#14 0x00000000007a6755 in handle_one_connection (arg=0x7fae49ef4000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_connect.cc:1443
#15 0x0000000000dc9e6c in pfs_spawn_thread (arg=0x7fae5bf41600) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/perfschema/pfs.cc:1860
#16 0x00007fae62838df3 in start_thread () from /lib64/libpthread.so.0
#17 0x00007fae615021ad in clone () from /lib64/libc.so.6

[Laurynas Biveinis (laurynas-biveinis)]

Is this an upstream bug?

[Ramesh Sivaraman (rameshvs02)]

Could not reproduce the issue with upstream (5.6.29 version) using multi thread pquery binary run.

[Shahriyar Rzayev (rzayev-sehriyar)]

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