Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21107

Assertion `!tmp_gco->next_gco || tmp_gco->last_sub_id > sub_id' failed in finish_event_group

    XMLWordPrintable

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)
    • 10.5, 10.6
    • Replication

    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

        1. dt_slave.7z
          473 kB
        2. mysql-bin.7z
          2.83 MB

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.