Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.5, 10.6, 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
Description
10.4 f9ceb0a67ffb20631c936a7e |
#3 <signal handler called>
|
#4 0x00007f4c6bdb6428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
|
#5 0x00007f4c6bdb802a in __GI_abort () at abort.c:89
|
#6 0x00007f4c6bdaebd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55f4a2f009d8 "!tmp_gco->next_gco || tmp_gco->last_sub_id > sub_id", file=file@entry=0x55f4a2f008d8 "/10.4/sql/rpl_parallel.cc", line=line@entry=228, function=function@entry=0x55f4a2f014e0 <finish_event_group(rpl_parallel_thread*, unsigned long long, rpl_parallel_entry*, rpl_group_info*)::__PRETTY_FUNCTION__> "void finish_event_group(rpl_parallel_thread*, uint64, rpl_parallel_entry*, rpl_group_info*)") at assert.c:92
|
#7 0x00007f4c6bdaec82 in __GI___assert_fail (assertion=0x55f4a2f009d8 "!tmp_gco->next_gco || tmp_gco->last_sub_id > sub_id", file=0x55f4a2f008d8 "/10.4/sql/rpl_parallel.cc", line=228, function=0x55f4a2f014e0 <finish_event_group(rpl_parallel_thread*, unsigned long long, rpl_parallel_entry*, rpl_group_info*)::__PRETTY_FUNCTION__> "void finish_event_group(rpl_parallel_thread*, uint64, rpl_parallel_entry*, rpl_group_info*)") at assert.c:101
|
#8 0x000055f4a2399aa1 in finish_event_group (rpt=0x7f4bf80098d8, sub_id=26, entry=0x7f4bf801cbe0, rgi=0x7f4bf8035500) at /10.4/sql/rpl_parallel.cc:228
|
#9 0x000055f4a239cbf7 in handle_rpl_parallel_thread (arg=0x7f4bf80098d8) at /10.4/sql/rpl_parallel.cc:1379
|
#10 0x00007f4c6d2a56ba in start_thread (arg=0x7f4c555f8700) at pthread_create.c:333
|
#11 0x00007f4c6be8841d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
reproducible with optimistic/aggressive slave_parallel_mode and >=3 slave_parallel_threads
with following rqg grammar:
query_init:
|
CREATE TABLE t (i1 int, i2 int, pk int) ; |
query:
|
a | b;
|
a:
|
CREATE TABLE t3 LIKE t ; ALTER TABLE t3 ENGINE = MERGE UNION (t1,t2); COMMIT ; |
b:
|
DELETE FROM mysql.tables_priv WHERE user = 'aaa' ; FLUSH PRIVILEGES ; |
perl ./runall-new.pl --no-mask --seed=time --duration=300 --queries=100M --mysqld=--log_bin=mysql-bin --mysqld=--slave_parallel_mode=\"optimistic\" --rpl_mode=mixed --grammar=conf/mariadb/1.yy --skip-gendata --threads=1 --mysqld=--slave_parallel_threads=3 --vardir= --basedir=/git/10.4
|
there is a bug MDEV-21149 about Engine=MERGE (maybe it is a reason of this one)
Attachments
Issue Links
- relates to
-
MDEV-8125 Assertion `!tmp_gco->next_gco || tmp_gco->last_sub_id > sub_id' failed at 10.1-patched/sql/rpl_parallel.cc:189: void finish_event_group(rpl_parallel_thread*, uint64, rpl_parallel_entry*, rpl_group_info*)
- Closed
-
MDEV-33668 Adapt parallel slave's round-robin scheduling to XA events
- Closed