Assertion `!((flags & MYSQL_START_TRANS_OPT_READ_ONLY) && (flags & MYSQL_START_TRANS_OPT_READ_WRITE))' failed

Description

GDB info
{code]
#0 0x00007f8526d10771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000af7cec in my_write_core (sig=6) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/mysys/stacktrace.c:424
#2 0x000000000075bcbe in handle_fatal_signal (sig=6) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/signal_handler.cc:248
#3 <signal handler called>
#4 0x00007f8524e985d7 in raise () from /lib64/libc.so.6
#5 0x00007f8524e99cc8 in abort () from /lib64/libc.so.6
#6 0x00007f8524e91546 in __assert_fail_base () from /lib64/libc.so.6
#7 0x00007f8524e915f2 in __assert_fail () from /lib64/libc.so.6
#8 0x00000000008f0d64 in trans_begin (thd=0x7f850dbc3000, flags=2408550287) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/transaction.cc:171
#9 0x000000000081a53c in mysql_execute_command (thd=0x7f850dbc3000) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/sql_parse.cc:5480
#10 0x0000000000821527 in mysql_parse (thd=0x7f850dbc3000, rawbuf=0x7f84f641f010 "LOCK TABLES performance_schema.threads WRITE", length=44, parser_state=0x7f85272334b0) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/sql_parse.cc:7925
#11 0x00000000008207ac in wsrep_mysql_parse (thd=0x7f850dbc3000, rawbuf=0x7f84f641f010 "LOCK TABLES performance_schema.threads WRITE", length=44, parser_state=0x7f85272334b0) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/sql_parse.cc:7625
#12 0x000000000080f59e in dispatch_command (command=COM_QUERY, thd=0x7f850dbc3000, packet=0x7f850dbcf001 "LOCK TABLES performance_schema.threads WRITE;", packet_length=45) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/sql_parse.cc:1742
#13 0x000000000080db3b in do_command (thd=0x7f850dbc3000) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/sql_parse.cc:1189
#14 0x00000000007d42fd in do_handle_one_connection (thd_arg=0x7f851ef67000) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/sql_connect.cc:1583
#15 0x00000000007d3ff1 in handle_one_connection (arg=0x7f851ef67000) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/sql/sql_connect.cc:1480
#16 0x0000000000b3b74d in pfs_spawn_thread (arg=0x7f850db60340) at /mnt/workspace/qa.pxc56.build/BUILD_TYPE/debug/label_exp/centos7-64/storage/perfschema/pfs.cc:1860
#17 0x00007f8526d0bdf5 in start_thread () from /lib64/libpthread.so.0
#18 0x00007f8524f591ad in clone () from /lib64/libc.so.6

Environment

None

Smart Checklist

Activity

Show:

Kathy Williamson April 22, 2020 at 12:14 PM

MySQL 5.6 is scheduled for EOL in Feb 2021.  At this time, we do not believe that this issue will be fixed prior to EOL.  If you believe this issue is important enough to be be fixed prior to EOL, or that it also affects a later version, please leave a comment and we will consider the new information.

Won't Do

Details

Assignee

Reporter

Affects versions

Priority

Smart Checklist

Created March 8, 2017 at 5:45 PM
Updated March 6, 2024 at 11:22 PM
Resolved April 22, 2020 at 12:14 PM