Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
-
None
Description
perl ./mtr --view-protocol rpl.rpl_parallel_no_log_slave_updates
|
|
10.0 4886d14827c |
181209 19:00:32 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master-bin.000001' position 880; GTID position '0-1-3'
|
mysqld: /data/src/10.0/sql/sql_base.cc:893: void close_thread_tables(THD*): Assertion `thd->transaction.stmt.is_empty() || thd->in_sub_stmt || (thd->state_flags & Open_tables_state::BACKUPS_AVAIL)' failed.
|
181209 19:00:32 [ERROR] mysqld got signal 6 ;
|
|
|
#7 0x00007f948d06aee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x00000000005e9e86 in close_thread_tables (thd=0x7f9476c16070) at /data/src/10.0/sql/sql_base.cc:892
|
#9 0x00000000006555c5 in mysql_execute_command (thd=0x7f9476c16070) at /data/src/10.0/sql/sql_parse.cc:5175
|
#10 0x00000000006589d0 in mysql_parse (thd=0x7f9476c16070, rawbuf=0x7f94788c9e88 "CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `mysqltest_tmp_v` AS SELECT * FROM t3 WHERE a >= 30 ORDER BY a", length=153, parser_state=0x7f9486647a00) at /data/src/10.0/sql/sql_parse.cc:6637
|
#11 0x000000000092a116 in Query_log_event::do_apply_event (this=0x7f94788c9cb0, rgi=0x7f9478816800, query_arg=0x7f94788c9e88 "CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `mysqltest_tmp_v` AS SELECT * FROM t3 WHERE a >= 30 ORDER BY a", q_len_arg=153) at /data/src/10.0/sql/log_event.cc:4435
|
#12 0x0000000000929127 in Query_log_event::do_apply_event (this=0x7f94788c9cb0, rgi=0x7f9478816800) at /data/src/10.0/sql/log_event.cc:4096
|
#13 0x00000000005c1d4c in Log_event::apply_event (this=0x7f94788c9cb0, rgi=0x7f9478816800) at /data/src/10.0/sql/log_event.h:1360
|
#14 0x00000000005b8444 in apply_event_and_update_pos (ev=0x7f94788c9cb0, thd=0x7f9476c16070, rgi=0x7f9478816800, rpt=0x7f94788aacf0) at /data/src/10.0/sql/slave.cc:3310
|
#15 0x00000000007c7a3e in rpt_handle_event (qev=0x7f947889e270, rpt=0x7f94788aacf0) at /data/src/10.0/sql/rpl_parallel.cc:52
|
#16 0x00000000007ca285 in handle_rpl_parallel_thread (arg=0x7f94788aacf0) at /data/src/10.0/sql/rpl_parallel.cc:1202
|
#17 0x0000000000acdb54 in pfs_spawn_thread (arg=0x7f9478861270) at /data/src/10.0/storage/perfschema/pfs.cc:1861
|
#18 0x00007f948eb53494 in start_thread (arg=0x7f9486648700) at pthread_create.c:333
|
#19 0x00007f948d12793f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Attachments
Issue Links
- relates to
-
MDEV-27691
make working view-protocol
-
- Closed
-
I am getting identical assertion on 10.5 1ae008d272ad3f424fd334 with rqg
/git/10.5/sql/sql_base.cc:800: int close_thread_tables(THD*): Assertion `thd->transaction->stmt.is_empty() || thd->in_sub_stmt || (thd->state_flags & Open_tables_state::BACKUPS_AVAIL)' failed.200708 13:35:19 [ERROR] mysqld got signal 6 ;Server version: 10.5.5-MariaDB-debug-loglinux/raise.c:51(__GI_raise)[0x7f6971622f47]stdlib/abort.c:81(__GI_abort)[0x7f69716248b1]assert/assert.c:89(__assert_fail_base)[0x7f697161442a]??:0(__assert_fail)[0x7f69716144a2]sql/sql_base.cc:802(close_thread_tables(THD*))[0x555dc0ca8f8d]sql/sql_parse.cc:6021(mysql_execute_command(THD*))[0x555dc0e58ea2]sql/sql_parse.cc:7993(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x555dc0e65e47]sql/log_event_server.cc:1906(Query_log_event::do_apply_event(rpl_group_info*, char const*, unsigned int))[0x555dc197d1f1]sql/log_event_server.cc:1579(Query_log_event::do_apply_event(rpl_group_info*))[0x555dc197a40b]sql/log_event.h:1496(Log_event::apply_event(rpl_group_info*))[0x555dc0be5657]sql/slave.cc:4003(apply_event_and_update_pos_apply(Log_event*, THD*, rpl_group_info*, int))[0x555dc0bc751f]sql/slave.cc:4190(apply_event_and_update_pos_for_parallel(Log_event*, THD*, rpl_group_info*))[0x555dc0bc829f]sql/rpl_parallel.cc:61(rpt_handle_event(rpl_parallel_thread::queued_event*, rpl_parallel_thread*))[0x555dc13a0547]sql/rpl_parallel.cc:1343(handle_rpl_parallel_thread)[0x555dc13a7c95]perfschema/pfs.cc:2203(pfs_spawn_thread)[0x555dc1f2c531]nptl/pthread_create.c:463(start_thread)[0x7f697251f6db]x86_64/clone.S:97(clone)[0x7f6971705a3f]Trying to get some variables.Some pointers may be invalid and cause the dump to abort.Query (0x6140000a24e0): CREATE VIEW `v1` AS SELECT * FROM t3 WHERE a >= 30 ORDER BY a