Bug #119215 pfs_thread.processlist_id will be null after select group_replication_reset_member_actions()

• Submitted: 23 Oct 9:16
• Modified: 23 Oct 9:36
• Reporter: yl deng
• Status: Open
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 8.0.30
• OS: Any
• CPU Architecture: Any
• Tags: pfs_thread.processlist_id will be null after select group_replication_reset_memb

[23 Oct 9:16] yl deng

Description:
After execute `select group_replication_reset_member_actions() `, pfs_thread.processlist_id corresponding to the current thread will be null.

How to repeat:
mysql> select connection_id();
+-----------------+
| connection_id() |
+-----------------+
|              13 |
+-----------------+
1 row in set (0.00 sec)

mysql> select * from performance_schema.threads where processlist_id = connection_id()\G
*************************** 1. row ***************************
          THREAD_ID: 52
               NAME: thread/sql/one_connection
               TYPE: FOREGROUND
     PROCESSLIST_ID: 13
   PROCESSLIST_USER: root
   PROCESSLIST_HOST: localhost
     PROCESSLIST_DB: performance_schema
PROCESSLIST_COMMAND: Query
   PROCESSLIST_TIME: 0
  PROCESSLIST_STATE: executing
   PROCESSLIST_INFO: select * from performance_schema.threads where processlist_id = connection_id()
   PARENT_THREAD_ID: NULL
               ROLE: NULL
       INSTRUMENTED: YES
            HISTORY: YES
    CONNECTION_TYPE: SSL/TLS
       THREAD_OS_ID: 69122
     RESOURCE_GROUP: USR_default
   EXECUTION_ENGINE: PRIMARY
1 row in set (0.00 sec)

mysql> select group_replication_reset_member_actions();
+------------------------------------------+
| group_replication_reset_member_actions() |
+------------------------------------------+
| OK                                       |
+------------------------------------------+
1 row in set (0.56 sec)

mysql> install plugin group_replication soname 'group_replication.so';
Query OK, 0 rows affected (0.93 sec)

mysql> select * from performance_schema.threads where processlist_id = connection_id()\G
Empty set (0.01 sec)

mysql> select * from performance_schema.threads where thread_id = 52\G
*************************** 1. row ***************************
          THREAD_ID: 52
               NAME: thread/sql/one_connection
               TYPE: BACKGROUND
     PROCESSLIST_ID: NULL
   PROCESSLIST_USER: root
   PROCESSLIST_HOST: localhost
     PROCESSLIST_DB: performance_schema
PROCESSLIST_COMMAND: NULL
   PROCESSLIST_TIME: 0
  PROCESSLIST_STATE: statistics
   PROCESSLIST_INFO: select * from performance_schema.threads where thread_id = 52
   PARENT_THREAD_ID: NULL
               ROLE: NULL
       INSTRUMENTED: YES
            HISTORY: YES
    CONNECTION_TYPE: SSL/TLS
       THREAD_OS_ID: 69122
     RESOURCE_GROUP: USR_default
   EXECUTION_ENGINE: PRIMARY
1 row in set (0.00 sec)