MySQL Forums
Forum List  »  Replication

Strange issue with replication
Posted by: John Coppens
Date: July 03, 2021 07:33PM

I have a server and a 'client' with replication from server to client. I'm detecting differences in the replica. As far as I can see, the structure is completely the same in both the server table and the replica.

For example, I have a MediumInt(8) unsigned field in both, but, for some reason the data changes:

Server 65535 (ffff)
client 16777215 (ffffff)

Server 7097632 (6c4d20)
client 19744 (4d20)

Server 162 (a2)
client 7209122 (6e00a2)

I've included the hex values, as it shows that it looks as if either a MSB was added or lost. And strangely enough, if the source value has 3 bytes, the copy is 2 bytes, and vice versa.

Sorry for the lack of formatting.

I suspect some conversion issue, though both tables are defined as utf-8.
Could this be a problem with MariaDB versions?

Options: ReplyQuote

Written By
Strange issue with replication
July 03, 2021 07:33PM

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.