Bug #97676 Slave SQL error 1237 warnings
Submitted: 18 Nov 2019 9:27 Modified: 28 Dec 2019 18:08
Reporter: liu thomase Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Group Replication Severity:S3 (Non-critical)
Version:5.7.27 OS:Any
Assigned to: Bogdan Kecman CPU Architecture:Any
Tags: replicate-*-tableļ¼Œsalve

[18 Nov 2019 9:27] liu thomase
Description:
Description:

 mysql service run the 5.7.27 version,Master-slave synchronization
 add configuration  /etc/my.conf
 replicate-wild-do-table=ios_logs.money_change_%,ios_logs.item_change_%

/etc/init.d/mysqld restart

How to repeat:
[root@localhost][(none)]>  SHOW slave status \G;
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 192.168.56.11
                  Master_User: copy
                  Master_Port: 3306
                Connect_Retry: 10
              Master_Log_File: mysql-bin.000016
          Read_Master_Log_Pos: 4807
               Relay_Log_File: relay.000003
                Relay_Log_Pos: 941
        Relay_Master_Log_File: mysql-bin.000016
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB: 
          Replicate_Ignore_DB: mysql
           Replicate_Do_Table: 
       Replicate_Ignore_Table: 
      Replicate_Wild_Do_Table: ios_logs.money_change_%,ios_logs.item_change_%

The mongey_change table is not synchronized,

Master:
[root@localhost][ios_logs]>insert into money_change_20191103 values(null,'2018-01-06 23:59:51',108,'a','000108_148566392','20050000385637',5,'ad',16,0,33,25,1,1,5,1);
Query OK, 1 row affected (0.00 sec)

[root@localhost][ios_logs]>insert into money_change_20191103 values(null,'2018-01-06 23:59:51',108,'a','000108_148566392','20050000385637',5,'ad',16,0,33,25,1,1,5,1);
Query OK, 1 row affected (0.00 sec)

[root@localhost][ios_logs]>insert into money_change_20191103 values(null,'2018-01-06 23:59:51',108,'a','000108_148566392','20050000385637',5,'ad',16,0,33,25,1,1,5,1);
Query OK, 1 row affected (0.00 sec)

slave server:
root@localhost][ios_logs]>select * from money_change_20191103;       
Empty set (0.00 sec)

[root@localhost][ios_logs]>

Slave server logerror repeat
2019-11-18T17:25:16.171278+08:00 21 [Note] Slave SQL for channel '': Worker 1 failed executing transaction 'ANONYMOUS' at master log mysql-bin.000016, end_log_pos 4973; Could not execute Query event. Detailed error: Slave SQL thread ignored the query because of replicate-*-table rules; Error log throttle is enabled. This error will not be displayed for next 60 secs. It will be suppressed, Error_code: 1237
[28 Nov 2019 18:08] Bogdan Kecman
Hi,

Not sure what are you reporting as a bug here? Can you share more details?
[29 Dec 2019 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".