cannot be converted from type 'varchar(6000(bytes))' to type 'mediumtext'

[nshigit]

show replica status\G
*************************** 1. row ***************************
Replica_IO_State: Waiting for source to send event
Source_Host: pcxxxxxxxxxxxxxxxxx.rwlb.rds.aliyuncs.com
Source_User: xxxxxxxxxx
Source_Port: 3306
Connect_Retry: 60
Source_Log_File: mysql-bin.037807
Read_Source_Log_Pos: 401105392
Relay_Log_File: mysql-relay-bin.000002
Relay_Log_Pos: 4956938
Relay_Source_Log_File: mysql-bin.037805
Replica_IO_Running: Yes
Replica_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table: xxxx.%
Replicate_Wild_Ignore_Table: xxxxx.tmp_%
Last_Errno: 13146
Last_Error: Column 4 of table 'xxxxx.branch_resource_param' cannot be converted from type 'varchar(6000(bytes))' to type 'mediumtext'
Skip_Counter: 0
Exec_Source_Log_Pos: 479728715
Relay_Log_Space: 971998423
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Source_SSL_Allowed: No
Source_SSL_CA_File:
Source_SSL_CA_Path:
Source_SSL_Cert:
Source_SSL_Cipher:
Source_SSL_Key:
Seconds_Behind_Source: NULL
Source_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 13146
Last_SQL_Error: Column 4 of table 'xxxxxxx.branch_resource_param' cannot be converted from type 'varchar(6000(bytes))' to type 'mediumtext'
Replicate_Ignore_Server_Ids:
Source_Server_Id: 35095752
Source_UUID: 73b43377-f5a5-11ef-bf36-08c0ebd508aa
Source_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Replica_SQL_Running_State:

show create table pos3_dyh.branch_resource_param\G
*************************** 1. row ***************************
Table: branch_resource_param
Create Table: CREATE TABLE branch_resource_param (
system_book_code varchar(20) NOT NULL,
branch_num int(11) NOT NULL,
branch_resource_name varchar(50) NOT NULL,
branch_resource_param_key varchar(200) NOT NULL,
branch_resource_param_val varchar(2000) DEFAULT NULL,
aged_timestamp datetime DEFAULT NULL,
PRIMARY KEY (system_book_code,branch_num,branch_resource_name,branch_resource_param_key)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

CREATE TABLE branch_resource_param (
system_book_code varchar(20) NOT NULL,
branch_num int NOT NULL,
branch_resource_name varchar(50) NOT NULL,
branch_resource_param_key varchar(200) NOT NULL,
branch_resource_param_val text,
aged_timestamp datetime DEFAULT NULL,
PRIMARY KEY (system_book_code,branch_num,branch_resource_name,branch_resource_param_key)
) ENGINE=DUCKDB DEFAULT CHARSET=utf8mb3

[p1p1bear]

@nshigit Hi,

Based on the information you provided, it seems that a DDL was executed on the source side, but it could not be applied successfully on the replica, which caused replication to stop.

However, from the table definitions you shared, I do not see any column with the type varchar(6000(bytes)). So the current table structure does not seem to fully match the error message.

Could you please check whether the table definition provided is correct? It would be best if you could also share the exact DDL statement executed on the source side.

Thank you.