Strange issue with replication
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?
Subject
Views
Written By
Posted
Strange issue with replication
752
July 03, 2021 07:33PM
335
July 03, 2021 08:31PM
305
July 04, 2021 05:49PM
275
July 04, 2021 08:20PM
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.