Description:
Update a table report an ERROR:
ERROR 1534 (HY000): Writing one row to the row-based binary log failed
How to repeat:
CREATE TABLE `t1` (
`ID` int NOT NULL AUTO_INCREMENT,
`C_TINYBLOB` tinyblob,
`C_BLOB` blob,
`C_MEDIUMBLOB` mediumblob,
`C_LONGBLOB` longblob,
`C_TINYTEXT` tinytext,
`C_TEXT` text,
`C_MEDIUMTEXT` mediumtext,
`C_LONGTEXT` longtext,
`C_JSON` json DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=254 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
INSERT INTO t1(
C_TINYBLOB,
C_BLOB,
C_MEDIUMBLOB,
C_LONGBLOB,
C_TINYTEXT,
C_TEXT,
C_MEDIUMTEXT,
C_LONGTEXT,
C_JSON) VALUES(
'中文字符',
NULL,
repeat('a',16777215),
repeat('b',1024*1024*1024),
repeat('1',254),
repeat('1',65534),
repeat('0',16772150),
repeat('b',1024*1024*1024-1),
concat('{"a":','"',repeat('a',261),'",','"b":','"',repeat('2',65793),'",','"c":','"',repeat('3',257),'",','"d":','"',repeat('d',65773),'"}')
), (
'中文字符',
NULL,
repeat('a',16777215),
repeat('b',1024*1024*1024),
repeat('1',254),
repeat('1',65534),
repeat('0',16772150),
repeat('b',1024*1024*1024-1),
concat('{"a":','"',repeat('a',261),'",','"b":','"',repeat('2',65793),'",','"c":','"',repeat('3',257),'",','"d":','"',repeat('d',65773),'"}'));
update t1 set C_BLOB='aaaaaa';
Description: Update a table report an ERROR: ERROR 1534 (HY000): Writing one row to the row-based binary log failed How to repeat: CREATE TABLE `t1` ( `ID` int NOT NULL AUTO_INCREMENT, `C_TINYBLOB` tinyblob, `C_BLOB` blob, `C_MEDIUMBLOB` mediumblob, `C_LONGBLOB` longblob, `C_TINYTEXT` tinytext, `C_TEXT` text, `C_MEDIUMTEXT` mediumtext, `C_LONGTEXT` longtext, `C_JSON` json DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=254 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; INSERT INTO t1( C_TINYBLOB, C_BLOB, C_MEDIUMBLOB, C_LONGBLOB, C_TINYTEXT, C_TEXT, C_MEDIUMTEXT, C_LONGTEXT, C_JSON) VALUES( '中文字符', NULL, repeat('a',16777215), repeat('b',1024*1024*1024), repeat('1',254), repeat('1',65534), repeat('0',16772150), repeat('b',1024*1024*1024-1), concat('{"a":','"',repeat('a',261),'",','"b":','"',repeat('2',65793),'",','"c":','"',repeat('3',257),'",','"d":','"',repeat('d',65773),'"}') ), ( '中文字符', NULL, repeat('a',16777215), repeat('b',1024*1024*1024), repeat('1',254), repeat('1',65534), repeat('0',16772150), repeat('b',1024*1024*1024-1), concat('{"a":','"',repeat('a',261),'",','"b":','"',repeat('2',65793),'",','"c":','"',repeat('3',257),'",','"d":','"',repeat('d',65773),'"}')); update t1 set C_BLOB='aaaaaa';