Description:
I tried to do PITR. The source server is MySQL V5.6. I run the generated sql to other MySQL V5.6, it raises the below error when it runs a insert statement:
ERROR 1105 (HY000): Unknown error
When I run the generate sql on V5.7, and V8.0, the same error occures.
How to repeat:
Run below on a MySQL Server. It would fail at the insert statement.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
create database `icdb_mar16v6`;
use icdb_mar16v6;
CREATE TABLE `favorite_state_lookup`
(
state INTEGER NOT NULL PRIMARY KEY,
name VARCHAR(100) NOT NULL
);
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#200316 13:35:21 server id 3133010956 end_log_pos 120 CRC32 0xc28e484f Start: binlog v 4, server v 5.6.45-log created 200316 13:35:21
BINLOG '
GRBvXg8M9L26dAAAAHgAAAAAAAQANS42LjQ1LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAU9I
jsI=
'/*!*/;
# at 58889040
#200316 19:54:41 server id 3133010956 end_log_pos 58889122 CRC32 0x09483b62 Query thread_id=105150 exec_time=0 error_code=0
SET TIMESTAMP=1584359681/*!*/;
SET @@session.pseudo_thread_id=105150/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=2097152/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8mb4 *//*!*/;
SET @@session.character_set_client=45,@@session.collation_connection=45,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
BEGIN
/*!*/;
# at 58889122
#200316 19:54:41 server id 3133010956 end_log_pos 58889197 CRC32 0xd53400b6 Table_map: `icdb_mar16v6`.`favorite_state_lookup` mapped to number 2929
# at 58889197
#200316 19:54:41 server id 3133010956 end_log_pos 58889250 CRC32 0xec88c99c Write_rows: table id 2929 flags: STMT_END_F
BINLOG '
AWlvXhMM9L26SwAAAO2TggMAAHELAAAAAAMADGljZGJfbWFyMTZ2NgAVZmF2b3JpdGVfc3RhdGVf
bG9va3VwAAIDDwIsAQC2ADTV
AWlvXh4M9L26NQAAACKUggMAAHELAAAAAAEAAgACA/wAAAAACwBVTkZBVk9SSVRFRJzJiOw=
'/*!*/;
### INSERT INTO `icdb_mar16v6`.`favorite_state_lookup`
### SET
### @1=0 /* INT meta=0 nullable=0 is_null=0 */
### @2='UNFAVORITED' /* VARSTRING(300) meta=300 nullable=0 is_null=0 */
COMMIT/*!*/;
SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/;
DELIMITER ;
Description: I tried to do PITR. The source server is MySQL V5.6. I run the generated sql to other MySQL V5.6, it raises the below error when it runs a insert statement: ERROR 1105 (HY000): Unknown error When I run the generate sql on V5.7, and V8.0, the same error occures. How to repeat: Run below on a MySQL Server. It would fail at the insert statement. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> create database `icdb_mar16v6`; use icdb_mar16v6; CREATE TABLE `favorite_state_lookup` ( state INTEGER NOT NULL PRIMARY KEY, name VARCHAR(100) NOT NULL ); /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #200316 13:35:21 server id 3133010956 end_log_pos 120 CRC32 0xc28e484f Start: binlog v 4, server v 5.6.45-log created 200316 13:35:21 BINLOG ' GRBvXg8M9L26dAAAAHgAAAAAAAQANS42LjQ1LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAU9I jsI= '/*!*/; # at 58889040 #200316 19:54:41 server id 3133010956 end_log_pos 58889122 CRC32 0x09483b62 Query thread_id=105150 exec_time=0 error_code=0 SET TIMESTAMP=1584359681/*!*/; SET @@session.pseudo_thread_id=105150/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=2097152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C utf8mb4 *//*!*/; SET @@session.character_set_client=45,@@session.collation_connection=45,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; # at 58889122 #200316 19:54:41 server id 3133010956 end_log_pos 58889197 CRC32 0xd53400b6 Table_map: `icdb_mar16v6`.`favorite_state_lookup` mapped to number 2929 # at 58889197 #200316 19:54:41 server id 3133010956 end_log_pos 58889250 CRC32 0xec88c99c Write_rows: table id 2929 flags: STMT_END_F BINLOG ' AWlvXhMM9L26SwAAAO2TggMAAHELAAAAAAMADGljZGJfbWFyMTZ2NgAVZmF2b3JpdGVfc3RhdGVf bG9va3VwAAIDDwIsAQC2ADTV AWlvXh4M9L26NQAAACKUggMAAHELAAAAAAEAAgACA/wAAAAACwBVTkZBVk9SSVRFRJzJiOw= '/*!*/; ### INSERT INTO `icdb_mar16v6`.`favorite_state_lookup` ### SET ### @1=0 /* INT meta=0 nullable=0 is_null=0 */ ### @2='UNFAVORITED' /* VARSTRING(300) meta=300 nullable=0 is_null=0 */ COMMIT/*!*/; SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/; DELIMITER ;