Bug #76415 InnoDB: Failing assertion: srv_read_only_mode || trx->in_depth > 0 in SELECT
Submitted: 20 Mar 2015 22:11 Modified: 8 Apr 2015 18:38
Reporter: Roel Van de Paar Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S6 (Debug Builds)
Version:5.7.5-m16, 5.7.6, 5.7.8 OS:Any
Assigned to: CPU Architecture:Any

[20 Mar 2015 22:11] Roel Van de Paar 
Description:
2015-03-20T22:02:00.773339Z 0 [Note] /sda/MS-mysql-5.7.6-m16-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.7.6-m16-debug'  socket: '/sda/MS-mysql-5.7.6-m16-linux-x86_64-debug/socket.sock'  port: 18512  MySQL Community Server (GPL)
2015-03-21 09:02:07 0x7f5f216a4700  InnoDB: Assertion failure in thread 140046559233792 in file trx0trx.h line 1410
InnoDB: Failing assertion: srv_read_only_mode || trx->in_depth > 0
[...]
22:02:07 UTC - mysqld got signal 6 ;
[...]
Query (7f5e7cc2c020): SELECT EVENT_NAME,e.MIN_TIMER_WAIT,MIN(t.MIN_TIMER_WAIT)FROM performance_schema.events_waits_summary_global_by_event_name AS e JOIN pe
rformance_schema.events_waits_summary_by_thread_by_event_name AS t USING (EVENT_NAME) GROUP BY EVENT_NAME

(gdb) bt
+bt
#0  0x00007f5f210ab771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000013a521c in my_write_core (sig=6) at /bzr/mysql-5.7.6-m16_dbg/mysys/stacktrace.c:247
#2  0x0000000000bb713c in handle_fatal_signal (sig=6) at /bzr/mysql-5.7.6-m16_dbg/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f5f1fcaf5c9 in raise () from /lib64/libc.so.6
#5  0x00007f5f1fcb0cd8 in abort () from /lib64/libc.so.6
#6  0x00000000016c790b in ut_dbg_assertion_failed (expr=0x1bf69c8 "srv_read_only_mode || trx->in_depth > 0", file=0x1bf6988 "/bzr/mysql-5.7.6-m16_dbg/storage/innobase/include/trx0trx.h", line=1410) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/ut/ut0dbg.cc:67
#7  0x00000000014eb7bf in TrxInInnoDB::is_aborted (trx=0x7f5f134008e8) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/include/trx0trx.h:1410
#8  0x00000000014d80aa in ha_innobase::update_row (this=0x7f5e7cce14e8, old_row=0x7f5e7cce11b8 "\375)", new_row=0x7f5e7cce1020 "\375)") at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/handler/ha_innodb.cc:7190
#9  0x0000000000c25131 in handler::ha_update_row (this=0x7f5e7cce14e8, old_data=0x7f5e7cce11b8 "\375)", new_data=0x7f5e7cce1020 "\375)") at /bzr/mysql-5.7.6-m16_dbg/sql/handler.cc:7477
#10 0x00000000010650e9 in end_update (join=0x7f5e7cca2ae8, qep_tab=0x7f5e7cca4318, end_of_records=false) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.cc:3370
#11 0x0000000001068227 in QEP_tmp_table::put_record (this=0x7f5e7cca3e30, end_of_records=false) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.cc:4542
#12 0x0000000001068f81 in QEP_tmp_table::put_record (this=0x7f5e7cca3e30) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.h:248
#13 0x000000000105fab1 in sub_select_op (join=0x7f5e7cca2ae8, qep_tab=0x7f5e7cca4318, end_of_records=false) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.cc:1065
#14 0x00000000012a72c4 in JOIN_CACHE::generate_full_extensions (this=0x7f5e7cca3c58, rec_ptr=0x7f5e7cd72010 ")") at /bzr/mysql-5.7.6-m16_dbg/sql/sql_join_buffer.cc:2040
#15 0x00000000012a6fce in JOIN_CACHE_BNL::join_matching_records (this=0x7f5e7cca3c58, skip_last=false) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_join_buffer.cc:1923
#16 0x00000000012a694d in JOIN_CACHE::join_records (this=0x7f5e7cca3c58, skip_last=false) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_join_buffer.cc:1728
#17 0x00000000012a9db5 in JOIN_CACHE::end_send (this=0x7f5e7cca3c58) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_join_buffer.h:448
#18 0x000000000105fa07 in sub_select_op (join=0x7f5e7cca2ae8, qep_tab=0x7f5e7cca41a0, end_of_records=true) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.cc:1051
#19 0x000000000105fb44 in sub_select (join=0x7f5e7cca2ae8, qep_tab=0x7f5e7cca4028, end_of_records=true) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.cc:1208
#20 0x000000000105f6ae in do_select (join=0x7f5e7cca2ae8) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.cc:934
#21 0x000000000105d60f in JOIN::exec (this=0x7f5e7cca2ae8) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.cc:197
#22 0x00000000010f3195 in handle_query (thd=0x7f5e7cc1a000, lex=0x7f5e7cc1c068, result=0x7f5e7cca0de0, added_options=0, removed_options=0) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_select.cc:180
#23 0x00000000010a9eff in execute_sqlcom_select (thd=0x7f5e7cc1a000, all_tables=0x7f5e7cc2da40) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:4712
#24 0x00000000010a3aa0 in mysql_execute_command (thd=0x7f5e7cc1a000) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:2450
#25 0x00000000010aae7a in mysql_parse (thd=0x7f5e7cc1a000, parser_state=0x7f5f216a2e00) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:5129
#26 0x00000000010a0bd4 in dispatch_command (command=COM_QUERY, thd=0x7f5e7cc1a000, packet=0x7f5e7cc46011 "", packet_length=239) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:1249
#27 0x000000000109f925 in do_command (thd=0x7f5e7cc1a000) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:835
#28 0x00000000011c2fd9 in handle_connection (arg=0x7f5f17ff78c0) at /bzr/mysql-5.7.6-m16_dbg/sql/conn_handler/connection_handler_per_thread.cc:298
#29 0x00000000013d2299 in pfs_spawn_thread (arg=0x7f5f18fb2d50) at /bzr/mysql-5.7.6-m16_dbg/storage/perfschema/pfs.cc:2147
#30 0x00007f5f210a6df3 in start_thread () from /lib64/libpthread.so.0
#31 0x00007f5f1fd701ad in clone () from /lib64/libc.so.6

How to repeat:
Requires --sql_mode=ONLY_FULL_GROUP_BY

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t0(m INT UNSIGNED,n INT UNSIGNED,o enum('',''),KEY (m)) ENGINE=InnoDB;
XA START'';
SELECT COUNT(*)FROM t0;
SET @@session.sql_mode=MAXDB;
SET @@session.tmp_table_size=0;
SELECT EVENT_NAME,e.MIN_TIMER_WAIT,MIN(t.MIN_TIMER_WAIT)FROM performance_schema.events_waits_summary_global_by_event_name AS e JOIN performance_schema.events_waits_summary_by_thread_by_event_name AS t USING (EVENT_NAME) GROUP BY EVENT_NAME;
[20 Mar 2015 23:23] Roel Van de Paar 
See bug 76419 (which also requires ONLY_FULL_GROUP_BY)
[21 Mar 2015 6:53] MySQL Verification Team 
Hello Roel,

Thank you for the report and test case.
Confirmed that 5.7.6 debug build is affected.

Thanks,
Umesh
[21 Mar 2015 6:54] MySQL Verification Team 
// 5.7.6 - debug only build

bin/mysql_install_db --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/76415 -v
bin/mysqld-debug --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/76415 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/mysql-5.7.6/76415/log.err 2>&1 &

- build

commit: e1298eb6a8e2247361533811930a07fde7aff618
date: 2015-02-26 15:29:31 +0100
build-date: 2015-02-26 15:35:58 +0100
short: e1298eb
branch: mysql-5.7.6-m16-release

(gdb) bt
#0  0x00007f48ac976771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000013ee069 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/mysys/stacktrace.c:247
#2  0x0000000000bdeba0 in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f48ab57c5c9 in raise () from /lib64/libc.so.6
#5  0x00007f48ab57dcd8 in abort () from /lib64/libc.so.6
#6  0x000000000160d6bb in ut_dbg_assertion_failed (expr=0x1c1c738 "srv_read_only_mode || trx->in_depth > 0",
    file=0x1c1c6d0 "/export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/include/trx0trx.h", line=1410)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/ut/ut0dbg.cc:67
#7  0x0000000001430249 in TrxInInnoDB::is_aborted (trx=0x7f48a25628f8) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/include/trx0trx.h:1410
#8  0x000000000141c578 in ha_innobase::update_row (this=0x7f48300223d8, old_row=0x7f48300220a8 "\375)", new_row=0x7f4830021f10 "\375)")
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/handler/ha_innodb.cc:7190
#9  0x0000000000c4d4a5 in handler::ha_update_row (this=0x7f48300223d8, old_data=0x7f48300220a8 "\375)", new_data=0x7f4830021f10 "\375)")
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/handler.cc:7477
#10 0x00000000010a1eca in end_update (join=0x7f483001a998, qep_tab=0x7f483001c1c8, end_of_records=false)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:3370
#11 0x00000000010a5164 in QEP_tmp_table::put_record (this=0x7f483001bce0, end_of_records=false) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:4542
#12 0x00000000010a5ef1 in QEP_tmp_table::put_record (this=0x7f483001bce0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.h:248
#13 0x000000000109c855 in sub_select_op (join=0x7f483001a998, qep_tab=0x7f483001c1c8, end_of_records=false)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:1065
#14 0x00000000012efa86 in JOIN_CACHE::generate_full_extensions (this=0x7f483001bb08, rec_ptr=0x7f48309465a0 ")")
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_join_buffer.cc:2040
#15 0x00000000012ef77a in JOIN_CACHE_BNL::join_matching_records (this=0x7f483001bb08, skip_last=false)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_join_buffer.cc:1923
#16 0x00000000012ef0ef in JOIN_CACHE::join_records (this=0x7f483001bb08, skip_last=false) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_join_buffer.cc:1728
#17 0x00000000012f25b1 in JOIN_CACHE::end_send (this=0x7f483001bb08) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_join_buffer.h:448
#18 0x000000000109c7aa in sub_select_op (join=0x7f483001a998, qep_tab=0x7f483001c050, end_of_records=true)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:1051
#19 0x000000000109c8e1 in sub_select (join=0x7f483001a998, qep_tab=0x7f483001bed8, end_of_records=true)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:1208
#20 0x000000000109c45c in do_select (join=0x7f483001a998) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:934
#21 0x000000000109a364 in JOIN::exec (this=0x7f483001a998) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:197
#22 0x000000000113209d in handle_query (thd=0x7f4830000bb0, lex=0x7f4830002a90, result=0x7f483003ea80, added_options=0, removed_options=0)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_select.cc:180
#23 0x00000000010e8bd7 in execute_sqlcom_select (thd=0x7f4830000bb0, all_tables=0x7f4830006c40) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:4712
#24 0x00000000010e1c54 in mysql_execute_command (thd=0x7f4830000bb0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:2450
#25 0x00000000010e9a6f in mysql_parse (thd=0x7f4830000bb0, parser_state=0x7f48a119f5d0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:5129
#26 0x00000000010debc8 in dispatch_command (command=COM_QUERY, thd=0x7f4830000bb0, packet=0x7f4830009ce1 "", packet_length=239)
    at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:1249
#27 0x00000000010dd693 in do_command (thd=0x7f4830000bb0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:835
#28 0x000000000120444f in handle_connection (arg=0x485aec0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298
#29 0x00000000017770f1 in pfs_spawn_thread (arg=0x48866e0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/perfschema/pfs.cc:2147
#30 0x00007f48ac971df3 in start_thread () from /lib64/libpthread.so.0
#31 0x00007f48ab63d47d in clone () from /lib64/libc.so.6
[21 Mar 2015 6:55] MySQL Verification Team 
// 5.7.8 - debug only build

bin/mysql_install_db --basedir=/export/umesh/mysql-5.7.8 --datadir=/export/umesh/mysql-5.7.8/76415 -v
bin/mysqld-debug --basedir=/export/umesh/mysql-5.7.8 --datadir=/export/umesh/mysql-5.7.8/76415 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/mysql-5.7.8/76415/log.err 2>&1 &

- build

commit: 91153f3385c4917a215aa4c7818b3f6265608286
date: 2015-03-20 14:48:27 +0100
build-date: 2015-03-20 18:03:24 +0100
short: 91153f3
branch: mysql-5.7

MySQL source 5.7.8

(gdb) bt
#0  0x00007ffb15768771 in pthread_kill () from /lib64/libpthread.so.0
#1  0x00000000018c6688 in my_write_core (sig=6) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/mysys/stacktrace.c:247
#2  0x0000000000f4b39e in handle_fatal_signal (sig=6) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007ffb1436e5c9 in raise () from /lib64/libc.so.6
#5  0x00007ffb1436fcd8 in abort () from /lib64/libc.so.6
#6  0x0000000001ae4b43 in ut_dbg_assertion_failed (expr=0x221a638 "srv_read_only_mode || trx->in_depth > 0",
    file=0x221a5c8 "/export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/include/trx0trx.h", line=1423)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/ut/ut0dbg.cc:67
#7  0x00000000019079ff in TrxInInnoDB::is_aborted (trx=0x7ffb073018f8) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/include/trx0trx.h:1423
#8  0x00000000018f3d76 in ha_innobase::update_row (this=0x7ffa9000dde0, old_row=0x7ffa9004f688 "\375)", new_row=0x7ffa9004f4f0 "\375)")
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/handler/ha_innodb.cc:7286
#9  0x0000000000fbe427 in handler::ha_update_row (this=0x7ffa9000dde0, old_data=0x7ffa9004f688 "\375)", new_data=0x7ffa9004f4f0 "\375)")
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/handler.cc:7555
#10 0x0000000001580b5f in end_update (join=0x7ffa90032cf8, qep_tab=0x7ffa900344c8, end_of_records=false)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_executor.cc:3376
#11 0x0000000001583c9d in QEP_tmp_table::put_record (this=0x7ffa90034028, end_of_records=false)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_executor.cc:4548
#12 0x00000000015849f7 in QEP_tmp_table::put_record (this=0x7ffa90034028) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_executor.h:248
#13 0x000000000157b51b in sub_select_op (join=0x7ffa90032cf8, qep_tab=0x7ffa900344c8, end_of_records=false)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_executor.cc:1064
#14 0x00000000017c8e08 in JOIN_CACHE::generate_full_extensions (this=0x7ffa90033e50, rec_ptr=0x7ffa909519e0 ")")
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_join_buffer.cc:2040
#15 0x00000000017c8b12 in JOIN_CACHE_BNL::join_matching_records (this=0x7ffa90033e50, skip_last=false)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_join_buffer.cc:1923
#16 0x00000000017c8491 in JOIN_CACHE::join_records (this=0x7ffa90033e50, skip_last=false)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_join_buffer.cc:1728
#17 0x00000000017cb8f9 in JOIN_CACHE::end_send (this=0x7ffa90033e50) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_join_buffer.h:448
#18 0x000000000157b471 in sub_select_op (join=0x7ffa90032cf8, qep_tab=0x7ffa90034350, end_of_records=true)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_executor.cc:1050
#19 0x000000000157b5ae in sub_select (join=0x7ffa90032cf8, qep_tab=0x7ffa900341d8, end_of_records=true)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_executor.cc:1207
#20 0x000000000157b118 in do_select (join=0x7ffa90032cf8) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_executor.cc:933
#21 0x0000000001579079 in JOIN::exec (this=0x7ffa90032cf8) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_executor.cc:196
#22 0x000000000160f9d1 in handle_query (thd=0x7ffa90000bb0, lex=0x7ffa90002b60, result=0x7ffa9004e300, added_options=0, removed_options=0)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_select.cc:183
#23 0x00000000015c68e4 in execute_sqlcom_select (thd=0x7ffa90000bb0, all_tables=0x7ffa90006d30)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:4782
#24 0x00000000015c02ab in mysql_execute_command (thd=0x7ffa90000bb0) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:2468
#25 0x00000000015c78b1 in mysql_parse (thd=0x7ffa90000bb0, parser_state=0x7ffafd90ae50) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:5201
#26 0x00000000015bd46c in dispatch_command (thd=0x7ffa90000bb0, com_data=0x7ffafd90be00, command=COM_QUERY)
    at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:1280
#27 0x00000000015bc0bf in do_command (thd=0x7ffa90000bb0) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:851
#28 0x00000000016e052e in handle_connection (arg=0x4d4dae0) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/conn_handler/connection_handler_per_thread.cc:299
#29 0x0000000001ce1375 in pfs_spawn_thread (arg=0x4c6efc0) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/perfschema/pfs.cc:2147
#30 0x00007ffb15763df3 in start_thread () from /lib64/libpthread.so.0
#31 0x00007ffb1442f47d in clone () from /lib64/libc.so.6
[21 Mar 2015 7:07] MySQL Verification Team 
// 5.8.0 latest debug/release build not affected
[21 Mar 2015 7:10] MySQL Verification Team 
// 5.6.25 debug/release build not affected
[8 Apr 2015 18:38] Daniel Price 
Posted by developer:
 
Fixed as of the upcoming 5.7.8, 5.8.0 releases, and here's the changelog entry:

Transaction objects were passed to intrinsic table APIs, causing an
assertion. Intrinsic tables, which do not support rollback and are not
shared across connections, should ignore the transaction objects.

Thank you for the bug report.