Description:
we see the sql replication failed with the error
mysql> SHOW SLAVE STATUS\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: x.x.x.x
Master_User: rep
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql_binary_log.002533
Read_Master_Log_Pos: 82650265
Relay_Log_File: mysqld-relay-bin.000002
Relay_Log_Pos: 3551413
Relay_Master_Log_File: mysql_binary_log.002524
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1677
Last_Error: Column 0 of table 'navms.NAV_METRICETLSTATUS' cannot be converted from type 'varchar(300)' to type 'varchar(100)'
Skip_Counter: 0
Exec_Master_Log_Pos: 10987097
Relay_Log_Space: 1021238728
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 1677
Last_SQL_Error: Column 0 of table 'navms.NAV_METRICETLSTATUS' cannot be converted from type 'varchar(300)' to type 'varchar(100)'
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
Master_UUID: 6f70f11c-083b-11e5-8335-000f5328e04c
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State:
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp: 180607 16:08:22
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
1 row in set (0.00 sec)
=======================
there is no change in the table definition on both the master and slave
mysql> describe navms.NAV_METRICETLSTATUS;
+----------------+--------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+-------------------+-----------------------------+
| METRICIDENTITY | varchar(100) | NO | PRI | NULL | |
| DATEOFLASTLOAD | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| ETLSTATE | text | YES | | NULL | |
+----------------+--------------+------+-----+-------------------+-----------------------------+
3 rows in set (0.00 sec)
How to repeat:
Iam looking for afix
Description: we see the sql replication failed with the error mysql> SHOW SLAVE STATUS\G; *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: x.x.x.x Master_User: rep Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql_binary_log.002533 Read_Master_Log_Pos: 82650265 Relay_Log_File: mysqld-relay-bin.000002 Relay_Log_Pos: 3551413 Relay_Master_Log_File: mysql_binary_log.002524 Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 1677 Last_Error: Column 0 of table 'navms.NAV_METRICETLSTATUS' cannot be converted from type 'varchar(300)' to type 'varchar(100)' Skip_Counter: 0 Exec_Master_Log_Pos: 10987097 Relay_Log_Space: 1021238728 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 1677 Last_SQL_Error: Column 0 of table 'navms.NAV_METRICETLSTATUS' cannot be converted from type 'varchar(300)' to type 'varchar(100)' Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_UUID: 6f70f11c-083b-11e5-8335-000f5328e04c Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: 180607 16:08:22 Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: Executed_Gtid_Set: Auto_Position: 0 1 row in set (0.00 sec) ======================= there is no change in the table definition on both the master and slave mysql> describe navms.NAV_METRICETLSTATUS; +----------------+--------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+-------------------+-----------------------------+ | METRICIDENTITY | varchar(100) | NO | PRI | NULL | | | DATEOFLASTLOAD | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | | ETLSTATE | text | YES | | NULL | | +----------------+--------------+------+-----+-------------------+-----------------------------+ 3 rows in set (0.00 sec) How to repeat: Iam looking for afix