Re: Deadlock BLOB INSERT MySQL 8.0x InnoDB Cluster

[Frederic Descamps]

Hi Volker,

Thank you for using MySQL InnoDB Cluster.

I just tied with exact the same files as you and I didn't experienced any issue:

MySQL 127.0.0.1:33060+ ssl sbtest SQL > INSERT INTO `onlineorder_attachments` (`AttachmentGUID`,`Filename`,`File`) VALUES ('00a2b54f-b0cf-4f3a-9bed-02dba853b506', 'M-02-012.jpg', LOAD_FILE('/var/lib/mysql-files/M-02-012.jpg'));
Query OK, 1 row affected (8.9896 sec)


I've the same values as the one you published.

Just for the test could you replace the PK with an auto_increment ?

Regards,