Slave_SQL_Running_State: System lock

[monty solomon]

Newly created slaves continue to fall behind.

I have a cluster running version 5.7.18 with multiple slaves that can't keep up. Newly created slaves just continue to fall further behind.

I created various slaves using different machine configurations and the servers are mostly idle.

Here is a sample excerpt from show slave status

               Slave_IO_State: Waiting for master to send event
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 369898343
              Relay_Log_Space: 31147353955
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 9946
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: System lock
           Master_Retry_Count: 0
                  Master_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Master_SSL_Crl:
           Master_SSL_Crlpath:

           Id: 488
         User: system user
         Host:
           db: NULL
      Command: Connect
         Time: 10148
        State: System lock
         Info: NULL
    Rows_sent: 0
Rows_examined: 0

[monty solomon (monty+launchpad)]

Upstream https://bugs.mysql.com/bug.php?id=72131

[monty solomon (monty+launchpad)]

mysql Ver 14.14 Distrib 5.7.18-15, for Linux (x86_64) using 6.0

Server version: 5.7.18-15-log Percona Server (GPL), Release 15, Revision bff2cd9

Linux bold-grass 4.4.57-hs299.el6.x86_64 #1 SMP Tue Mar 28 21:56:50 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux

CentOS release 6.8 (Final)

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3737