| Bug #76419 | InnoDB: Failing assertion: node->pcur->rel_pos == BTR_PCUR_ON | ||
|---|---|---|---|
| Submitted: | 20 Mar 2015 23:20 | Modified: | 1 Jul 2015 4:34 |
| Reporter: | Roel Van de Paar | Email Updates: | |
| Status: | Closed | Impact on me: | |
| 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 23:23]
Roel Van de Paar
Requires Requires --sql_mode=ONLY_FULL_GROUP_BY, just like bug 76415 - possible connection?
[21 Mar 2015 8:20]
MySQL Verification Team
Hello Roel, Thank you for the report and test case. Observed that 5.7.6 both optimized/debug builds are affected. Thanks, Umesh
[21 Mar 2015 8:21]
MySQL Verification Team
// 5.7.6 release build is affected
bin/mysql_install_db --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/76419 -v
bin/mysqld --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/76419 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.7.6/76419/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
MySQL source 5.7.6
(gdb) bt
#0 0x00007fe5adf07771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006f64d4 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
#2 <signal handler called>
#3 0x00007fe5acb0d5c9 in raise () from /lib64/libc.so.6
#4 0x00007fe5acb0ecd8 in abort () from /lib64/libc.so.6
#5 0x0000000000e62c2e in ut_dbg_assertion_failed (expr=0x12a5518 "node->pcur->rel_pos == BTR_PCUR_ON", file=<optimized out>, line=2405)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/ut/ut0dbg.cc:67
#6 0x0000000000de2df5 in row_update_for_mysql_using_upd_graph (mysql_rec=<optimized out>, prebuilt=0x7fe5689217c0)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/row/row0mysql.cc:2405
#7 0x0000000000de2ed8 in row_update_for_mysql (mysql_rec=<optimized out>, prebuilt=0x7fe5689217c0)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/row/row0mysql.cc:2614
#8 0x0000000000d1e047 in ha_innobase::update_row (this=0x7fe56801bed0, old_row=0x7fe56801c1b8 <incomplete sequence \375>, new_row=0x7fe56801c1b0 <incomplete sequence \375>)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/handler/ha_innodb.cc:7200
#9 0x0000000000738592 in handler::ha_update_row (this=0x7fe56801bed0, old_data=0x7fe56801c1b8 <incomplete sequence \375>, new_data=0x7fe56801c1b0 <incomplete sequence \375>)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/handler.cc:7477
#10 0x0000000000b70674 in multi_update::send_data (this=0x7fe568006bb8, not_used_values=...) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_update.cc:2267
#11 0x0000000000ac15a0 in end_send (join=0x7fe5689255d0, qep_tab=0x7fe5689263f8, end_of_records=<optimized out>)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:2860
#12 0x0000000000ac63dc in evaluate_join_record (join=0x7fe5689255d0, qep_tab=0x7fe568926280) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:1617
#13 0x0000000000ac67d5 in QEP_tmp_table::end_send (this=0x7fe568007170) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:4607
#14 0x0000000000ac789d in sub_select_op (join=0x7fe5689255d0, qep_tab=0x7fe568926280, end_of_records=<optimized out>)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:1051
#15 0x0000000000ac6ab2 in do_select (join=0x7fe5689255d0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:934
#16 JOIN::exec (this=0x7fe5689255d0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:197
#17 0x0000000000b2d838 in handle_query (thd=0x7fe568000b40, lex=0x7fe568002a20, result=0x7fe568006bb8, added_options=1342177281, removed_options=0)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_select.cc:180
#18 0x0000000000b71459 in mysql_multi_update (thd=0x7fe568000b40, fields=0x7fe568005308, values=0x7fe568005e30, handle_duplicates=DUP_ERROR, select_lex=0x7fe5680051d0, result=0x7fe59640b668)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_update.cc:1655
#19 0x0000000000b721e8 in Sql_cmd_update::execute_multi_table_update (this=0x7fe568005e20, thd=0x7fe568000b40)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_update.cc:2896
#20 0x0000000000b745c4 in Sql_cmd_update::execute (this=0x7fe568005e20, thd=0x7fe568000b40) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_update.cc:2932
#21 0x0000000000af1929 in mysql_execute_command (thd=0x7fe568000b40) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:3214
#22 0x0000000000af5248 in mysql_parse (thd=0x7fe568000b40, parser_state=<optimized out>) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:5129
#23 0x0000000000af6788 in dispatch_command (command=COM_QUERY, thd=0x7fe568000b40, packet=0x7fe568009c21 "UPDATE t1,t2 SET t2.b=0", packet_length=23)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:1249
#24 0x0000000000bb94a4 in handle_connection (arg=<optimized out>) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298
#25 0x0000000000f79aba in pfs_spawn_thread (arg=0x2a259e0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/perfschema/pfs.cc:2147
#26 0x00007fe5adf02df3 in start_thread () from /lib64/libpthread.so.0
#27 0x00007fe5acbce47d in clone () from /lib64/libc.so.6
[21 Mar 2015 8:21]
MySQL Verification Team
// 5.7.6 debug build is affected
bin/mysql_install_db --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/76419 -v
bin/mysqld-debug --basedir=/export/umesh/mysql-5.7.6 --datadir=/export/umesh/mysql-5.7.6/76419 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.7.6/76419/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
MySQL source 5.7.6
(gdb) bt
#0 0x00007f4b0b61c771 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 0x00007f4b0a2225c9 in raise () from /lib64/libc.so.6
#5 0x00007f4b0a223cd8 in abort () from /lib64/libc.so.6
#6 0x000000000160d6bb in ut_dbg_assertion_failed (expr=0x1c62f98 "node->pcur->rel_pos == BTR_PCUR_ON",
file=0x1c62088 "/export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/row/row0mysql.cc", line=2405)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/ut/ut0dbg.cc:67
#7 0x000000000154e0ed in row_update_for_mysql_using_upd_graph (mysql_rec=0x7f4a9003cc88 <incomplete sequence \375>, prebuilt=0x7f4a900437e8)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/row/row0mysql.cc:2405
#8 0x000000000154e996 in row_update_for_mysql (mysql_rec=0x7f4a9003cc88 <incomplete sequence \375>, prebuilt=0x7f4a900437e8)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/row/row0mysql.cc:2614
#9 0x000000000141c5f9 in ha_innobase::update_row (this=0x7f4a9003c9a0, old_row=0x7f4a9003cc88 <incomplete sequence \375>, new_row=0x7f4a9003cc80 <incomplete sequence \375>)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/innobase/handler/ha_innodb.cc:7200
#10 0x0000000000c4d4a5 in handler::ha_update_row (this=0x7f4a9003c9a0, old_data=0x7f4a9003cc88 <incomplete sequence \375>, new_data=0x7f4a9003cc80 <incomplete sequence \375>)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/handler.cc:7477
#11 0x0000000001198cf1 in multi_update::send_data (this=0x7f4a90006c88, not_used_values=...) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_update.cc:2267
#12 0x00000000010a0975 in end_send (join=0x7f4a9001a448, qep_tab=0x7f4a9001b2a0, end_of_records=false)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:2860
#13 0x000000000109d76a in evaluate_join_record (join=0x7f4a9001a448, qep_tab=0x7f4a9001b128) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:1617
#14 0x00000000010a53ed in QEP_tmp_table::end_send (this=0x7f4a9001b3b8) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:4607
#15 0x000000000109c7aa in sub_select_op (join=0x7f4a9001a448, qep_tab=0x7f4a9001b128, end_of_records=true)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:1051
#16 0x000000000109c8e1 in sub_select (join=0x7f4a9001a448, qep_tab=0x7f4a9001afb0, end_of_records=true)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:1208
#17 0x000000000109c8e1 in sub_select (join=0x7f4a9001a448, qep_tab=0x7f4a9001ae38, end_of_records=true)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:1208
#18 0x000000000109c45c in do_select (join=0x7f4a9001a448) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:934
#19 0x000000000109a364 in JOIN::exec (this=0x7f4a9001a448) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_executor.cc:197
#20 0x000000000113209d in handle_query (thd=0x7f4a90000bb0, lex=0x7f4a90002a90, result=0x7f4a90006c88, added_options=1342177408, removed_options=0)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_select.cc:180
#21 0x0000000001196833 in mysql_multi_update (thd=0x7f4a90000bb0, fields=0x7f4a90005388, values=0x7f4a90005ef0, handle_duplicates=DUP_ERROR, select_lex=0x7f4a90005250, result=0x7f4b00e44cd8)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_update.cc:1655
#22 0x000000000119aa4d in Sql_cmd_update::execute_multi_table_update (this=0x7f4a90005ee0, thd=0x7f4a90000bb0)
at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_update.cc:2896
#23 0x000000000119ab90 in Sql_cmd_update::execute (this=0x7f4a90005ee0, thd=0x7f4a90000bb0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_update.cc:2923
#24 0x00000000010e3ebf in mysql_execute_command (thd=0x7f4a90000bb0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/sql/sql_parse.cc:3214
#25 0x00000000010e9a6f in mysql_parse (thd=0x7f4a90000bb0, parser_state=0x7f4b00e465d0) 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=0x7f4a90000bb0, packet=0x7f4a90009ce1 "UPDATE t1,t2 SET t2.b=0", packet_length=23)
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=0x7f4a90000bb0) 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=0x5100840) 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=0x5101ef0) at /export/home/pb2/build/sb_0-14552753-1424962715.41/mysql-5.7.6-m16/storage/perfschema/pfs.cc:2147
#30 0x00007f4b0b617df3 in start_thread () from /lib64/libpthread.so.0
#31 0x00007f4b0a2e347d in clone () from /lib64/libc.so.6
[21 Mar 2015 8:24]
MySQL Verification Team
// 5.7.8 - opt/release build is affected
bin/mysql_install_db --basedir=/export/umesh/mysql-5.7.8 --datadir=/export/umesh/mysql-5.7.8/76419 -v
bin/mysqld --basedir=/export/umesh/mysql-5.7.8 --datadir=/export/umesh/mysql-5.7.8/76419 --sql_mode=ONLY_FULL_GROUP_BY --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/mysql-5.7.8/76419/log.err 2>&1 &
more ~umshastr/.mysql_secret
- 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 0x00007f2a0269e771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000007817d5 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
#2 <signal handler called>
#3 0x00007f2a012a45c9 in raise () from /lib64/libc.so.6
#4 0x00007f2a012a5cd8 in abort () from /lib64/libc.so.6
#5 0x00000000007549a2 in ut_dbg_assertion_failed (expr=expr@entry=0x1559468 "node->pcur->rel_pos == BTR_PCUR_ON",
file=file@entry=0x1558b68 "/export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/row/row0mysql.cc", line=line@entry=2420)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/ut/ut0dbg.cc:67
#6 0x0000000000f29975 in row_update_for_mysql_using_upd_graph (prebuilt=prebuilt@entry=0x7f29a892cdc0, mysql_rec=0x7f29a800e0a8 <incomplete sequence \375>)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/row/row0mysql.cc:2420
#7 0x0000000000f2ad50 in row_update_for_mysql (mysql_rec=mysql_rec@entry=0x7f29a800e0a8 <incomplete sequence \375>, prebuilt=0x7f29a892cdc0)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/row/row0mysql.cc:2629
#8 0x0000000000e59d3b in ha_innobase::update_row (this=0x7f29a800ddc0, old_row=0x7f29a800e0a8 <incomplete sequence \375>, new_row=0x7f29a800e0a0 <incomplete sequence \375>)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/innobase/handler/ha_innodb.cc:7296
#9 0x00000000007cb9fa in handler::ha_update_row (this=0x7f29a800ddc0, old_data=0x7f29a800e0a8 <incomplete sequence \375>, new_data=0x7f29a800e0a0 <incomplete sequence \375>)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/handler.cc:7555
#10 0x0000000000ca8d25 in Query_result_update::send_data (this=0x7f29a8006cc8, not_used_values=...)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_update.cc:2269
#11 0x0000000000c01490 in end_send (join=0x7f29a8930be0, qep_tab=0x7f29a8931a00, end_of_records=<optimized out>)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_executor.cc:2866
#12 0x0000000000bfe0bc in evaluate_join_record (join=join@entry=0x7f29a8930be0, qep_tab=0x7f29a8931888)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_executor.cc:1623
#13 0x0000000000c02ebc in QEP_tmp_table::end_send (this=0x7f29a8931b18) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_executor.cc:4613
#14 0x0000000000c03564 in sub_select_op (join=0x7f29a8930be0, qep_tab=0x7f29a8931888, end_of_records=<optimized out>)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_executor.cc:1050
#15 0x0000000000bfc73f in do_select (join=0x7f29a8930be0) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_executor.cc:933
#16 JOIN::exec (this=0x7f29a8930be0) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_executor.cc:196
#17 0x0000000000c66add in handle_query (thd=thd@entry=0x7f29a8000b40, lex=0x7f29a8002ae8, result=result@entry=0x7f29a8006cc8, added_options=added_options@entry=1342177408,
removed_options=removed_options@entry=0) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_select.cc:183
#18 0x0000000000cab9a2 in mysql_multi_update (thd=thd@entry=0x7f29a8000b40, fields=fields@entry=0x7f29a80053d8, values=values@entry=0x7f29a8005f20, handle_duplicates=DUP_ERROR,
select_lex=select_lex@entry=0x7f29a80052a0, result=result@entry=0x7f29eaa8e7c0) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_update.cc:1655
#19 0x0000000000cac8d0 in Sql_cmd_update::execute_multi_table_update (this=this@entry=0x7f29a8005f10, thd=thd@entry=0x7f29a8000b40)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_update.cc:2898
#20 0x0000000000caca8c in Sql_cmd_update::execute (this=0x7f29a8005f10, thd=0x7f29a8000b40) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_update.cc:2934
#21 0x0000000000c29d7b in mysql_execute_command (thd=thd@entry=0x7f29a8000b40) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:4495
#22 0x0000000000c2fdf8 in mysql_parse (thd=thd@entry=0x7f29a8000b40, parser_state=parser_state@entry=0x7f29eaa8f7b0)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:5201
#23 0x0000000000c310f7 in dispatch_command (thd=thd@entry=0x7f29a8000b40, com_data=com_data@entry=0x7f29eaa8fe00, command=COM_QUERY)
at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:1280
#24 0x0000000000c3202f in do_command (thd=thd@entry=0x7f29a8000b40) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/sql/sql_parse.cc:851
#25 0x0000000000ce39b0 in handle_connection (arg=arg@entry=0x408fc90)
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
#26 0x00000000011502b3 in pfs_spawn_thread (arg=0x41c9d70) at /export/home3/pb2/build/sb_0-14765270-1426872165.51/mysqlcom-pro-5.7.8-rc/storage/perfschema/pfs.cc:2147
#27 0x00007f2a02699df3 in start_thread () from /lib64/libpthread.so.0
#28 0x00007f2a0136547d in clone () from /lib64/libc.so.6
(gdb)
[21 Mar 2015 8:26]
MySQL Verification Team
// 5.8.0 debug/opt build are not affected
[21 Mar 2015 8:28]
MySQL Verification Team
// 5.6.25 debug/opt build not affected
[5 May 2015 15:29]
Paul DuBois
Noted in 5.7.8, 5.8.0 changelogs. Enabling the sql_buffer_results system variable could cause a server exit for multiple-table UPDATE statements.
[1 Jul 2015 1:05]
Roel Van de Paar
Another testcase, @developers: please add this to MTR DROP DATABASE test;CREATE DATABASE test;USE test; SET SESSION SQL_BUFFER_RESULT=1; create table t1(s1 char(5)character set utf8mb4 collate utf8mb4_unicode_ci); INSERT INTO t1 VALUES(1); UPDATE t1,performance_schema.setup_instruments pfs SET t1.s1=1
[1 Jul 2015 1:06]
Roel Van de Paar
Re-opening to add secondary MTR testcase
[1 Jul 2015 4:34]
MySQL Verification Team
Reverting bug status to "Closed".
Description: 2015-03-21 10:16:37 0x7fe3674b7700 InnoDB: Assertion failure in thread 140614667302656 in file row0mysql.cc line 2405 InnoDB: Failing assertion: node->pcur->rel_pos == BTR_PCUR_ON +bt #0 0x00007fba4a74d771 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 0x00007fba493515c9 in raise () from /lib64/libc.so.6 #5 0x00007fba49352cd8 in abort () from /lib64/libc.so.6 #6 0x00000000016c790b in ut_dbg_assertion_failed (expr=0x1c385c8 "node->pcur->rel_pos == BTR_PCUR_ON", file=0x1c376e0 "/bzr/mysql-5.7.6-m16_dbg/storage/innobase/row/row0mysql.cc", line=2405) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/ut/ut0dbg.cc:67 #7 0x0000000001608a25 in row_update_for_mysql_using_upd_graph (mysql_rec=0x7fb9a60aff08 <incomplete sequence \375>, prebuilt=0x7fb9a6096098) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/row/row0mysql.cc:2405 #8 0x000000000160933f in row_update_for_mysql (mysql_rec=0x7fb9a60aff08 <incomplete sequence \375>, prebuilt=0x7fb9a6096098) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/row/row0mysql.cc:2614 #9 0x00000000014d812b in ha_innobase::update_row (this=0x7fb9a60afc20, old_row=0x7fb9a60aff08 <incomplete sequence \375>, new_row=0x7fb9a60aff00 <incomplete sequence \375>) at /bzr/mysql-5.7.6-m16_dbg/storage/innobase/handler/ha_innodb.cc:7200 #10 0x0000000000c25131 in handler::ha_update_row (this=0x7fb9a60afc20, old_data=0x7fb9a60aff08 <incomplete sequence \375>, new_data=0x7fb9a60aff00 <incomplete sequence \375>) at /bzr/mysql-5.7.6-m16_dbg/sql/handler.cc:7477 #11 0x0000000001157e39 in multi_update::send_data (this=0x7fb9a602da88, not_used_values=...) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_update.cc:2268 #12 0x0000000001063b66 in end_send (join=0x7fb9a608f598, qep_tab=0x7fb9a60903f0, end_of_records=false) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.cc:2860 #13 0x00000000010609aa in evaluate_join_record (join=0x7fb9a608f598, qep_tab=0x7fb9a6090278) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.cc:1617 #14 0x00000000010684ae in QEP_tmp_table::end_send (this=0x7fb9a6090508) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.cc:4607 #15 0x000000000105fa07 in sub_select_op (join=0x7fb9a608f598, qep_tab=0x7fb9a6090278, end_of_records=true) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.cc:1051 #16 0x000000000105fb44 in sub_select (join=0x7fb9a608f598, qep_tab=0x7fb9a6090100, end_of_records=true) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.cc:1208 #17 0x000000000105fb44 in sub_select (join=0x7fb9a608f598, qep_tab=0x7fb9a608ff88, end_of_records=true) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.cc:1208 #18 0x000000000105f6ae in do_select (join=0x7fb9a608f598) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.cc:934 #19 0x000000000105d60f in JOIN::exec (this=0x7fb9a608f598) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_executor.cc:197 #20 0x00000000010f3195 in handle_query (thd=0x7fb9a601a000, lex=0x7fb9a601c068, result=0x7fb9a602da88, added_options=1342177408, removed_options=0) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_select.cc:180 #21 0x0000000001155add in mysql_multi_update (thd=0x7fb9a601a000, fields=0x7fb9a602c188, values=0x7fb9a602ccf0, handle_duplicates=DUP_ERROR, select_lex=0x7fb9a602c050, result=0x7fba4ad43b68) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_update.cc:1655 #22 0x0000000001159b1a in Sql_cmd_update::execute_multi_table_update (this=0x7fb9a602cce0, thd=0x7fb9a601a000) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_update.cc:2896 #23 0x0000000001159c74 in Sql_cmd_update::execute (this=0x7fb9a602cce0, thd=0x7fb9a601a000) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_update.cc:2923 #24 0x00000000010a58a9 in mysql_execute_command (thd=0x7fb9a601a000) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:3214 #25 0x00000000010aae7a in mysql_parse (thd=0x7fb9a601a000, parser_state=0x7fba4ad44e00) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:5129 #26 0x00000000010a0bd4 in dispatch_command (command=COM_QUERY, thd=0x7fb9a601a000, packet=0x7fb9a6046011 "UPDATE t1,t2 SET t2.b=0", packet_length=23) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:1249 #27 0x000000000109f925 in do_command (thd=0x7fb9a601a000) at /bzr/mysql-5.7.6-m16_dbg/sql/sql_parse.cc:835 #28 0x00000000011c2fd9 in handle_connection (arg=0x7fba417f7f60) at /bzr/mysql-5.7.6-m16_dbg/sql/conn_handler/connection_handler_per_thread.cc:298 #29 0x00000000013d2299 in pfs_spawn_thread (arg=0x7fba427b2e10) at /bzr/mysql-5.7.6-m16_dbg/storage/perfschema/pfs.cc:2147 #30 0x00007fba4a748df3 in start_thread () from /lib64/libpthread.so.0 #31 0x00007fba494121ad in clone () from /lib64/libc.so.6 How to repeat: DROP DATABASE test;CREATE DATABASE test;USE test; CREATE TABLE t1(c1 INT); SET @@session.sql_buffer_result=ON; INSERT INTO t1 VALUES(0),(0),(0),('Z'),('z'); CREATE TEMPORARY TABLE t2(b INT); INSERT INTO t2 VALUES(0),(0); UPDATE t1,t2 SET t2.b=0;