[MDEV-14738] Replication breaks when dropping a column of a combined primary key (with a confusing error message) Created: 2017-12-21 Updated: 2023-04-27 |
|
| Status: | Confirmed |
| Project: | MariaDB Server |
| Component/s: | Replication |
| Affects Version/s: | 10.2.11 |
| Fix Version/s: | 10.4 |
| Type: | Bug | Priority: | Minor |
| Reporter: | Patrick Kummutat | Assignee: | Sergei Golubchik |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||||||
| Description |
|
Hi, replication breaks when I'm dropping a column which is part of a combined primary key. Master: 10.1.29 Version Howto reproduce:
On Slave:
Regards, |
| Comments |
| Comment by Elena Stepanova [ 2017-12-22 ] | |||||
|
The change in behavior in 10.2 vs 10.1 was intentional, it's a result of a bug fix. The same error would happen if one tried to drop a part of the primary key directly on the 10.2 server:
There is a more detailed explanation in comments to Replication error is an unfortunate but probably unavoidable side effect of this change. However, what is undeniably wrong is the error message that's produced in this case; it should be fixed (it was also discussed in the above mentioned reports). So, I'm keeping this bug report for at least fixing the error message. I'm not sure if it can be done in 10.2, but whenever it can be done, it should be. |