MySQL Forums
Forum List  »  Replication

Re: Replication sql errors
Posted by: sharath s
Date: May 03, 2021 01:51AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
386
May 01, 2021 06:47AM
164
May 01, 2021 09:28AM
Re: Replication sql errors
193
May 03, 2021 01:51AM
159
May 03, 2021 11:07AM
269
May 06, 2021 12:08AM
178
May 06, 2021 11:17AM
157
May 07, 2021 04:25AM
189
May 06, 2021 11:20AM
170
May 06, 2021 06:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.