Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-8322

Assertion `!is_set()' fails with RESET REPLICA when both GR and async channels are configured

Details

    • Bug
    • Status: Open
    • Medium
    • Resolution: Unresolved
    • 8.0.x
    • None
    • None

    Description

      The server hits the assertion 

       

      void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `!is_set()' failed

      on RESET REPLICA when both GR and async channels are configured.

       

       

      Steps to reproduce:

      1. Start a single node cluster

       

        1. INSTALL PLUGIN  group_replication SONAME 'group_replication.so';
        2. SET global group_replication_group_name='aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa';
        3. SET global group_replication_group_seeds = "localhost:5555,localhost:5556";
        4. SET global group_replication_local_address= 'localhost:5555';
        5. SET GLOBAL group_replication_bootstrap_group=ON;
        6. START GROUP_REPLICATION;
        7. SET GLOBAL group_replication_bootstrap_group=OFF;

      Setup async replication to non-existent server

        8. CHANGE MASTER TO aster_host='127.0.0.1',master_port=13001,master_user='root'; -- 13001 is not running 

       

      Shutdown and restart Node 1 

      9. Shutdown Node 1
      10. Restart Node 1

      Execute RESET REPLICA

      11. RESET REPLICA;
      
      ERROR 2013 (HY000): Lost connection to MySQL server during query 
      No connection. Trying to reconnect... 
      Connection id:    14 Current database: *** NONE ***ERROR 2013 (HY000): Lost connection to MySQL server during query No connection. Trying to reconnect... ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1:4000' (111) 
      ERROR:  
      Can't connect to the server

      Stacktrace:

      (gdb) bt
      #0  __GI_raise ([email protected]=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x00007ffff753e859 in __GI_abort () at abort.c:79
      #2  0x00007ffff753e729 in __assert_fail_base (fmt=0x7ffff76d4588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55555b6f6eed "!is_set()", 
          file=0x55555b6f6d80 "/home/venki/work/mysql/80/sql/sql_error.cc", line=374, function=<optimized out>) at assert.c:92
      #3  0x00007ffff754ffd6 in __GI___assert_fail (assertion=0x55555b6f6eed "!is_set()", file=0x55555b6f6d80 "/home/venki/work/mysql/80/sql/sql_error.cc", line=374, 
          function=0x55555b6f72a0 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)")
          at assert.c:101
      #4  0x0000555558927811 in Diagnostics_area::set_ok_status (this=0x7fff2c003510, affected_rows=0, last_insert_id=0, message_text=0x0) at /home/venki/work/mysql/80/sql/sql_error.cc:374
      #5  0x00005555588bf01c in my_ok (thd=0x7fff2c001040, affected_rows=0, id=0, message=0x0) at /home/venki/work/mysql/80/sql/sql_class.cc:3257
      #6  0x00005555589a3cc1 in mysql_execute_command (thd=0x7fff2c001040, first_level=true) at /home/venki/work/mysql/80/sql/sql_parse.cc:4092
      #7  0x00005555589a74d5 in dispatch_sql_command (thd=0x7fff2c001040, parser_state=0x7fffa07f6b50) at /home/venki/work/mysql/80/sql/sql_parse.cc:5207
      #8  0x000055555899d1b8 in dispatch_command (thd=0x7fff2c001040, com_data=0x7fffa07f7b40, command=COM_QUERY) at /home/venki/work/mysql/80/sql/sql_parse.cc:1957
      #9  0x000055555899b0af in do_command (thd=0x7fff2c001040) at /home/venki/work/mysql/80/sql/sql_parse.cc:1352
      #10 0x0000555558ba7d6b in handle_connection (arg=0x5555602154b0) at /home/venki/work/mysql/80/sql/conn_handler/connection_handler_per_thread.cc:302
      #11 0x000055555aaa7d08 in pfs_spawn_thread (arg=0x55556028f1d0) at /home/venki/work/mysql/80/storage/perfschema/pfs.cc:2942
      #12 0x00007ffff7f85609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #13 0x00007ffff763b133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

      Attachments

        Activity

          People

            Unassigned Unassigned
            venkatesh.prasad Venkatesh Prasad
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Smart Checklist