Re: Replication sql errors

[sharath s]

Hello Peter,
I fetched the bin log entries from B based on the output of show slave status from C. below is hte output.How to identify which bin log this query would be in the Server A which is replicating to B.


# at 6267632
#210501 20:26:45 server id 1 end_log_pos 6267757 Table_map: `tablaname` mapped to number 8688616
# at 6267757
#210501 20:26:45 server id 1 end_log_pos 6268229 Update_rows: table id tableid flags: STMT_END_F

BINLOG '
LWyNYBMBAAAAfQAAAG2jXwAAAOiThAAAAAEAC1NCUkVEQ0FSUEVUAANraXQAJQgSDxIPEAgPDw8D
CAgICBL8/PwDAw8PDwgICAMPDw8PDwgKDwokAP8AAP8AAQD/AP8A/wAABAQE/wD/AP8A/wD/AP8A
/wD/AAoA/v///x8=
LWyNYB8BAAAA2AEAAEWlXwAAAOiThAAAAAEAAgAl/////////////wACRmf/CzQCAAAAAACZqX1B
Ag5BTk9OWU1PVVNfVVNFUpmoqTX1DkFOT05ZTU9VU19VU0VSAAIAAAAAAAAAEDQ4NDQ0MTA1MDA3
MjE5NzUKMTg0MDA3MjE5NwEAAAAFAAAAAAAAAMmlAQAAAAAAAwAAAAAAAAADAAAAAAAAAJm4fgAA
IAAAAFIWLIsHrGiyUtGpLxu3n5BoSG4/w1s65S4ch9pnwuBuAAAAAAAAAAAMMTM5MzAwMDAwMDAw
DDEzOTMwMDAwMDAwMAAAAAACMDUHMDA3MjE5NwACRmf/CzQCAAAAAACZqYNHiQ5BTk9OWU1PVVNf
VVNFUpmoqTX1DkFOT05ZTU9VU19VU0VSAAMAAAAAAAAAEDQ4NDQ0MTA1MDA3MjE5NzUKMTg0MDA3
MjE5NwEAAAAFAAAAAAAAAMmlAQAAAAAAAwAAAAAAAAADAAAAAAAAAJm4fgAAIAAAAFIWLIsHrGiy
UtGpLxu3n5BoSG4/w1s65S4ch9pnwuBuAAAAAAAAAAAMNTIwNzAwMDAwMDAwDDUyMDcwMDAwMDAw
MAAAAAACMDUHMDA3MjE5Nw==
'/*!*/;
### UPDATE `tablename`.`XXX`
### WHERE
### @1=144395
### @2='2021-04-30 20:04:02'
### @3='ANONYMOUS_USER'
### @4='2021-01-20 19:23:53'
### @5='ANONYMOUS_USER'
### @6=b'0'
### @7=2
### @8='4844410500721975'
### @9='1840072197'
### @10=NULL
### @11=1
### @12=5
### @13=107977
### @14=3
### @15=3
### @16='2025-12-31 00:00:00'
### @17='R\x16,▒\x07▒h▒Rѩ/\x1b▒▒▒hHn?▒[:▒.\x1c▒▒g▒▒n'
### @18=NULL
### @19=NULL
### @20=0
### @21=0
### @22='139300000000'
### @23=NULL
### @24='139300000000'
### @25=NULL
### @26=NULL
### @27=NULL
### @28=0
### @29='05'
### @30=NULL
### @31=NULL
### @32='0072197'
### @33=NULL
### @34=NULL
### @35=NULL
### @36=NULL
### @37=NULL
### SET
### @1=144395
### @2='2021-05-01 20:30:09'
### @3='ANONYMOUS_USER'
### @4='2021-01-20 19:23:53'
### @5='ANONYMOUS_USER'
### @6=b'0'
### @7=3
### @8='4844410500721975'
### @9='1840072197'
### @10=NULL
### @11=1
### @12=5
### @13=107977
### @14=3
### @15=3
### @16='2025-12-31 00:00:00'
### @17='R\x16,▒\x07▒h▒Rѩ/\x1b▒▒▒hHn?▒[:▒.\x1c▒▒g▒▒n'
### @18=NULL
### @19=NULL
### @20=0
### @21=0
### @22='520700000000'
### @23=NULL
### @24='520700000000'
### @25=NULL
### @26=NULL
### @27=NULL
### @28=0
### @29='05'
### @30=NULL
### @31=NULL
### @32='0072197'
### @33=NULL
### @34=NULL
### @35=NULL
### @36=NULL
### @37=NULL
# at 6268229
#210501 20:26:45 server id 1 end_log_pos 6268256 Xid = 167369059