MySQL Forums
Forum List  »  German

mysqlbinlog wrong data
Posted by: Santiago Díaz
Date: May 18, 2017 08:35AM

I have a binlogs files. I'm using the next command

mysqlbinlog --verbose --base64-output=DECODE-ROWS /tmp/binlogs.000009

and I obtain for example the next UPDATE statement

#170517 12:44:14 server id 1 end_log_pos 3341 CRC32 0x075b4b46 Update_rows: table id 77 flags: STMT_END_F
### UPDATE `hancom_files`.`traffic_counters`
### WHERE
### @1=6860
### SET
### @6=0.00094890594482421875
### @7=4
### @8=0.00063419342041015625
### @9=2.574920654296875e-05

But... The same binlog file into another server... I see the next

#170517 12:44:14 server id 1 end_log_pos 3341 CRC32 0x075b4b46 Update_rows: table id 77 flags: STMT_END_F
### UPDATE `hancom_files`.`traffic_counters`
### WHERE
### @1=-268435430 (4026531866)
### SET
### @6=5.9065984934807991718e-309
### @7=0
### @8=3.4369501639685242035e-310
### @9=***Corrupted replication event was detected. Not printing the value***


Why? The first server is a RedHat Enterprise 6.8.
mysql Ver 14.14 Distrib 5.6.35-80.0, for Linux (x86_64) using 6.0

The second server is a Ubuntu 16.04.1 LTS
mysql Ver 15.1 Distrib 10.0.29-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2


Does it the diferent versions the problem?

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqlbinlog wrong data
663
May 18, 2017 08:35AM


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.