# MySQL replication 1677

**URL:** <https://forums.percona.com/t/mysql-replication-1677/17557>\
**Category:** Percona XtraDB Cluster 8.x\
**Created:** [September 19, 2022, 7:12pm UTC](https://forums.percona.com/t/mysql-replication-1677/17557 "2022-09-19T19:12:39Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dba1](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/dba1/32/24223_2.png) [@Dba1](https://forums.percona.com/u/Dba1)\
**Post date:** [September 19, 2022, 7:12pm UTC](https://forums.percona.com/t/mysql-replication-1677/17557/1 "2022-09-19T19:12:39Z")

</div>

I have a replication error 1677 . Table cannot be converted from type varchar(135 octects ) to type varchar(303 octects) character set utf8. Any Help would be appreciated

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [September 19, 2022, 7:27pm UTC](https://forums.percona.com/t/mysql-replication-1677/17557/2 "2022-09-19T19:27:43Z")

</div>

Please provide `SHOW CREATE TABLE` on both source and replica.

---

<div class="post-metadata">

**Author:** ![Dba1](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/dba1/32/24223_2.png) [@Dba1](https://forums.percona.com/u/Dba1)\
**Post date:** [September 19, 2022, 7:40pm UTC](https://forums.percona.com/t/mysql-replication-1677/17557/3 "2022-09-19T19:40:06Z")

</div>

Show create table outputs is the same on both servers( master and replica) the trouble column is a dynamic column and data type is blob both in the same server

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [September 19, 2022, 8:44pm UTC](https://forums.percona.com/t/mysql-replication-1677/17557/4 "2022-09-19T20:44:20Z")

</div>

Could you please provide `SHOW CREATE TABLE` on both source and replica? This will allow us to recreate your setup and run some tests if necessary. And also the full output from `SHOW REPLICA STATUS\G`

---

<div class="post-metadata">

**Author:** ![Dba1](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/dba1/32/24223_2.png) [@Dba1](https://forums.percona.com/u/Dba1)\
**Post date:** [September 20, 2022, 8:32pm UTC](https://forums.percona.com/t/mysql-replication-1677/17557/5 "2022-09-20T20:32:01Z")

</div>

Thank you Mr.Mathew I was able to resolve the issue by repairing the table with restarting replication as well. Thank you